user doesmysql not existss一直这样该怎么办啊

IBM &Error Contacting User Manager ... (0x): Automation error The specified service does not exist as an installed service& when launching Controller after upgrading with Controller 10.1 Interim Fix (IF) - United States
Technote (troubleshooting)
Problem(Abstract)
Customer has a working Controller 10.1.x (e.g. 10.1 RTM) application server, which they want to upgrade to a later &Interim Fix& (IF) version of Controller (for example IF6 or whatever).
Administrator launches IF setup program wizard (issetup.exe), and completes the installation wizard. After the wizard finishes, they are asked to reboot the application server. After the server has rebooted, the user launches Controller.
User chooses database. User types in username (e.g. ADM) and password. User clicks OK. An error message appears.
Error Contacting User Manager
Error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---& System.Exception (0x): Automation error The specified service does not exist as an installed service. atFrUserManagerB.UserManagerBClass.GetCurrentUsers(String sGuid, String sUser) at Cognos.Controller.Proxy(CCRWS.UserManager_GetCurrentUsers(String sGuid, String sUser) --- End of inner exception stack trace --- [OK]
I.T. administrator had not stopped all of the IBM-related Windows services before launching the Interim Fix (IF) installation wizard.
Specifically, the administrator had not stopped the service &IBM Cognos Controller User Manager&.
Resolving the problem
The solution depends on the environment:
Sometimes, simply rebooting the application server once again will fix the problem
If this does not solve the problem then it is possible to manually re-register the Controller User Manager Windows service
If the above fails, then unfortunately the Controller server software must be uninstalled/re-installed on the application server.
1. Reboot the Controller application server.
If this fails to solve the problem, go to step 2.
2. Logon to the Controller application server as a Windows administrator
3. Launch a command prompt (START - RUN - &CMD& &Enter&)
4. Type the following command:
sc create frLicServer binpath= &C:\Program Files (x86)\ibm\cognos\c10\server\FrLicServer.exe& DisplayName= &IBM Cognos Controller User Manager& depend= RpcSs
start= auto
The above command assumes that you are using Controller 10.1.1, installed into the default location, on Windows 2008 R2
Naturally the command parameters may have to be modified slightly depending on your environment (for example if you have installed the software into a different location).
5. Reboot the Controller application server
In the (unlikely) event that the above fails, then proceed with the following:
7. Perform standard precautionary tasks.
For example:
Take entire 'snapshot' backup of application server
Backup all Cognos-related databases
Take note/printscreens of all settings inside both &Controller Configuration& and &Cognos Configuration&).
8. Logon to the Controller application server as an administrator
9. Uninstall Controller via &Start - Programs - IBM Cognos 10 - Uninstall IBM Cognos&
10. Re-install Controller base version (for example 10.1.0 RTM or 10.1.1 RTM) that you are trying to create
11. Ensure that all IBM Cognos-related Windows services are stopped.
TIP: For more details, see separate IBM Technote #
12. Install relevant Controller 10.1 IF patch (e.g. IF6 or whatever) as per best practice guidelines
13. Configure settings inside both &Controller Configuration& and &Cognos Configuration&
Related information
Rate this page:
(0 users)Average rating
(0 users)Average rating
Document information
More support for:
Controller
Software version:
10.1, 10.1.1
Operating system(s):
Reference #:
Modified date:
Translate my page
Machine Translation
Machine TranslationOGG执行DDL复制报ORA-01435 user does not exist_数据库技术_Linux公社-Linux系统门户网站
你好,游客
OGG执行DDL复制报ORA-01435 user does not exist
来源:Linux社区&
作者:zhou1862324
08:29:43 WARNING OGG-00869
GoldenGate Delivery for Oracle, rep_app.prm: No unique key is defined for table 'C'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key. 08:29:43 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep_app.prm: Fatal error executing DDL replication: error [Error code [1435], ORA-01435: user does not exist SQL ALTER SESSION SET CURRENT_SCHEMA="UNID"], no error handler present. 08:29:43 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_app.prm: PROCESS ABENDING.
报错用户UNID不存在,但是我配置的意思只是想将UNIDDEV的DDL复制过去,以下是我的replicat配置:REPLICAT rep_appSETENV (NLS_LANG = "American_America.ZHS16GBK")USERID goldengate,PASSWORD GOLDENGATEREPORTCOUNT EVERY 30 MINUTES, RATEREPERROR DEFAULT, ABENDnumfiles 5000--HANDLECOLLISIONSassumetargetdefsDISCARDFILE ./dirrpt/rep_app.dsc, APPEND, MEGABYTES 1000ALLOWNOOPUPDATESmap UNIDDEV.*, target UNIDDEV.*;map SH.*, target SH.*;
GGSCI (JOADBTEST01) 7& view param ext_app
EXTRACT ext_appsetenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)TRANLOGOPTIONS ASMUSER sys@asminst, asmpassword oracleuserid goldengate,password goldengateREPORTCOUNT EVERY 1 MINUTES, RATEnumfiles 5000DISCARDFILE ./dirrpt/ext_app.dsc,APPEND,MEGABYTES 1000DISCARDROLLOVER AT 3:00exttrail ./dirdat/r1,megabytes 100dynamicresolutionTRANLOGOPTIONS EXCLUDEUSER goldengate--TRANLOGOPTIONS convertucs2clobsDDL INCLUDE ALLTABLE UNIDDEV.*;TABLE SH.*;
GGSCI (JOADBTEST01) 8& view param pmp_app
extract pmp_appdynamicresolutionpassthrurmthost 10.0.15.107, mgrport 7839, compressrmttrail ./dirdat/t1numfiles 5000TABLE UNIDDEV.*;TABLE SH.*;
解决办法:增加配置DDL INCLUDE。。。
更多Oracle相关信息见 专题页面
相关资讯 & & &
& (03/25/:14)
图片资讯 & & &
   同意评论声明
   发表
尊重网上道德,遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款后使用快捷导航没有帐号?
重定义Modern UI,打造完美Windows全新体验
查看: 2935|回复: 3
积分148最后登录精华0阅读权限20主题UID1620683帖子PB币217 威望0 贡献0 技术24 活跃74
PCBETA Milestone, 积分 148, 距离下一级还需 52 积分
UID1620683帖子PB币217 贡献0 技术24 活跃74
高手帮忙修改下LPC 我修改了总有错误& & & & Error& & & & Object does not exist (DTGP)
(36.03 KB, 下载次数: 20)
19:59 上传
下载次数: 20
下载积分: PB币 -1
积分3325最后登录精华0阅读权限70主题UID1113291帖子PB币5585 威望331 贡献0 技术46 活跃31
PCBETA RC2, 积分 3325, 距离下一级还需 2175 积分
UID1113291帖子PB币5585 贡献0 技术46 活跃31
(19.56 KB, 下载次数: 192)
20:06 上传
下载次数: 192
下载积分: PB币 -1
拿去吧..&&应该先添加DTGP..&&才可以去修改其他的...&&
积分63最后登录精华0阅读权限20主题UID2778297帖子PB币23 威望0 贡献0 技术2 活跃52
PCBETA Milestone, 积分 63, 距离下一级还需 137 积分
UID2778297帖子PB币23 贡献0 技术2 活跃52
楼上的能给出修改方法吗?我也是这样的问题
积分28最后登录精华0阅读权限10主题UID809835帖子PB币96 威望0 贡献0 技术0 活跃14
PCBETA Alpha, 积分 28, 距离下一级还需 22 积分
UID809835帖子PB币96 贡献0 技术0 活跃14
顶,也报这个错
7周年庆典勋章
远景7周年一路有你
#没攀过峻岭,何以览美景#
关于远景论坛无故跳转至其他网站的解决方案,姑且一试。大家注意网银安全啊!!!
关注远景官方微信
Copyright (C) 2005-, All rights reserved
Powered by Discuz!&&沪ICP备号
请勿发布违反中华人民共和国法律法规的言论,会员观点不代表远景论坛官方立场。}

我要回帖

更多关于 if not exists 的文章

更多推荐

版权声明:文章内容来源于网络,版权归原作者所有,如有侵权请点击这里与我们联系,我们将及时删除。

点击添加站长微信