amit roy 2 Posted November 24, 2018 Share Posted November 24, 2018 Hi All, I'm trying to switch from AS to EMS+Oracle DB, while configuring BWagent to start with EMS+OracleDB I'm getting this error:Message : ORA-00001: unique constraint (BWUSER.SYS_C008985) violated, not sure how to resolve it and apart from that on what operation it is failing which as not very clear from log[bwagent.log] as log is not really meaningful. 2018-11-24 19:48:28.005 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - handling error in operation [addInstalledSoftware] would be great if someone can help. Detailed Error log: 2018-11-24 19:48:16.348 INFO [main] c.t.b.t.m.t.e.c.BWEMSAdminClient - bw.agent.technology.requestTimeout : 60000 2018-11-24 19:48:16.359 INFO [main] c.t.b.t.m.t.e.c.BWEMSAdminClient - bw.agent.technology.remote.status.requestTimeout : 30000 2018-11-24 19:48:21.576 INFO [main] c.t.b.t.m.t.e.c.BWEMSAdminClient - Initialized agent with DB for persistence and EMS for transport 2018-11-24 19:48:26.714 INFO [TibQinGroupConnection DispatchTimer (bw-6-5-0-n2)] c.t.b.t.a.a.t.e.BWEMSTransportListener - I [bw-6-5-0-n2] have joined the group [bW6Network]. 2018-11-24 19:48:26.714 INFO [TibQinGroupConnection DispatchTimer (bw-6-5-0-n2)] c.t.b.t.a.a.t.e.BWEMSTransportListener - I [bw-6-5-0-n2] am the new leader 2018-11-24 19:48:26.760 INFO [main] c.t.b.t.m.t.m.udp.UDPMonitorListener - Monitor provider : UDP 2018-11-24 19:48:26.761 INFO [main] c.t.b.t.m.t.m.udp.UDPMonitorListener - UDPMonitorListener initialized 2018-11-24 19:48:26.761 INFO [main] c.t.b.t.m.t.m.udp.UDPMonitorListener - UDP Server Port : 34561 2018-11-24 19:48:26.763 INFO [main] bw - BusinessWorks Agent:6.5 2018-11-24 19:48:26.767 INFO [main] c.t.b.t.m.p.local.LocalDomainUtils - Looking for installed software in TIBCO_HOME=/home/tibco_Home/tibco/bw6 2018-11-24 19:48:26.776 INFO [uDPMonitorListener] c.t.b.t.m.t.m.udp.UDPMonitorListener - UDP server for Application stat started at localhost:34561 2018-11-24 19:48:28.005 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - handling error in operation [addInstalledSoftware] 2018-11-24 19:48:28.007 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - SQLState : 23000 ErrorCode: 1 Message : ORA-00001: unique constraint (BWUSER.SYS_C008985) violated 2018-11-24 19:48:28.007 INFO [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - closing DB connection 2018-11-24 19:48:28.011 INFO [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - closing DB connection 2018-11-24 19:48:28.014 INFO [shutdown-hook] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - closing DB connection 2018-11-24 19:48:28.673 INFO [shutdown-hook] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - initializing DB connection 2018-11-24 19:48:28.924 INFO [shutdown-hook] c.t.b.t.m.p.rdbms.ScriptRunner - agent columns already existsORA-01430: column being added already exists in table 2018-11-24 19:48:28.947 INFO [shutdown-hook] c.t.b.t.m.p.rdbms.ScriptRunner - stats columns already existsORA-00942: table or view does not exist 2018-11-24 19:48:28.982 INFO [shutdown-hook] bw - Cleaned up Datastore connection and Transport Listener. 2018-11-24 19:48:28.983 ERROR [uDPMonitorListener] c.t.b.t.m.t.m.udp.UDPMonitorListener - Socket closed Link to comment Share on other sites More sharing options...
amit roy 2 Posted November 25, 2018 Author Share Posted November 25, 2018 how to enable more descriptive logging for BWRDBMSDataManager to see from which location of installed software has a constraint violation Although Cleanup and Reinstallation is not the answer. Link to comment Share on other sites More sharing options...
Aveejeet Saxena Posted August 1, 2019 Share Posted August 1, 2019 Amit I am facing same issue, I have oracle and EMS driver installed. How did you fixed this issue. thanks Link to comment Share on other sites More sharing options...
amit roy 2 Posted September 3, 2019 Author Share Posted September 3, 2019 Hi Av, sorry for the late response,can you share the logs from BW6 agent Thanks Amit Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now