| Author |
Message
|
| amateur10 |
 Posted: Sun Dec 11, 2005 9:16 am Post subject: A new problem in ICS, unable to connect to server |
 |
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
This morning, when tried to start server, i had the follwoing error mesage and could not connectg
[Time: 2005/12/11 09:10:16.969] [System: Server] [Thread: Test.thread1 (#676508064)] [Mesg: A worker for Collaboration.CollaborationManager$1@5eedb1ac could not be found.]
[Time: 2005/12/11 09:10:17.000] [System: ConnectorController] [SS: INCONN] [Thread: INCONNThreadPool.thread1 (#679162272)] [Type: Fatal Error] [MsgID: 14301] [Mesg: Connector An event state change could not be saved: state = Test, connector = INCONN, eventId = 1. [info]::A JDBC error was encountered during an attempt to execute accessor PBOSWrite. [info]:: (SQLState [23505]:[IBM][CLI Driver][DB2/NT] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DB2ADMIN.CXPBUSOBJSTATE" from having duplicate rows for those columns. SQLSTATE=23505
DB specific error:-803) is unable to store persistent information.A problem occurred while trying to access the repository.Check the database server's log file for further information.]
[Time: 2005/12/11 09:10:17.000] [System: Server] [Thread: INCONNThreadPool.thread1 (#679162272)] [Type: Info] [MsgID: 300] [Mesg: InterChange Server "ICSSVR" is shutdown immediately.]
do any one have any suggestion ? Pleasae help me |
|
| Back to top |
|
 |
| hopsala |
| Posted: Sun Dec 11, 2005 1:09 pm Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
What does the flow which uses this adapter do? Did it work before? What had changed? What is DB2ADMIN.CXPBUSOBJSTATE? Does this happen during polling for events or some db action your were trying to perform?
Raise collab, adapter and connector trace levels to 5 to get more info. |
|
| Back to top |
|
|
| amateur10 |
| Posted: Sun Dec 11, 2005 1:30 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
In fact I messed up and deleted the database and changted the repositary database.
I have problem here too. when i tried to create database from gui, it says
SQL4414N The DB2 Administration Server is not active.
Explanation:
The request cannot be processed unless the DB2 Administration
Server is active.
User Response:
Start the DB2 Administration Server by issuing the command
DB2ADMIN START, and reissue the request.
but when i go to command editor and give command
create database <databasename> it works
what should be the reason
thanks |
|
| Back to top |
|
|
| djeripo |
| Posted: Sun Dec 11, 2005 3:34 pm Post subject: |
|
|
Master
Joined: 25 Jan 2004
Posts: 225
|
If you have a problem like the one you had before where you cannot execute the failed flows and you think you should clean up evrything,you should never delete the DB getting into the controlcenter.Instead ,You should delete the repository from InterchangeServer.If you are not in a position to start the ICS you should try starting with -i option.
Amateur Wrote:
| Quote: |
create database <databasename> it works
what should be the reason |
So you are able to create a DB in command line.So did you try changing your DB to this new DB and start the ICS? |
|
| Back to top |
|
|
| amateur10 |
| Posted: Sun Dec 11, 2005 4:25 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
yes. I setup ics with new db( new repositary) and now i have another problem. not being able to create db was one problem which I solved other way, creagting from command editor.
Now, i can not run the test connector. I mean when i run, ne ver gets connector. |
|
| Back to top |
|
|
| amateur10 |
| Posted: Sun Dec 11, 2005 4:27 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
| i mean never gets connected. always runs |
|
| Back to top |
|
|
| amateur10 |
| Posted: Sun Dec 11, 2005 8:00 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
Once, i deleted all db setting and reset ics database, I was able to use test connector. I haave one simple connector, ( template), and one jdbc template. I first use run the system and use VT, and i was able to make connection, the bo was passed to other side, when i stop the second testconnector and run jdbc, i could not make it write to table. The jdbcconnector stops and the follwoing is the entry in the icslog. could you please suggest me the reason.
Time: 2005/12/11 14:03:03.203] [System: Collaboration] [SS: Test] [Thread: WT=4 (#672928547)] [Type: Info] [MsgID: 11014] [Mesg: The collaboration is active.]
[Time: 2005/12/11 14:24:31.453] [System: Server] [Thread: WT=6 (#675255075)] [Mesg: XML Exception:UTF8]
[Time: 2005/12/11 14:24:41.828] [System: ConnectorController] [SS: INCONN] [Thread: ControllerKeepAlive (#675451683)] [Type: Info] [MsgID: 17029] [Mesg: Contacted connector agent INCONN. Bind succeeded.]
[Time: 2005/12/11 16:55:35.391] [System: Server] [Thread: WT=1 (#678761251)] [Mesg: XML Exception:UTF8]
[Time: 2005/12/11 16:55:45.031] [System: ConnectorController] [SS: JDBCoutConn] [Thread: ControllerKeepAlive (#676975395)] [Type: Info] [MsgID: 17029] [Mesg: Contacted connector agent JDBCoutConn. Bind succeeded.]
[Time: 2005/12/11 18:33:00.625] [System: Server] [Thread: WT=14 (#704008995)] [Mesg: XML Exception:UTF8]
[Time: 2005/12/11 18:33:09.047] [System: ConnectorController] [SS: INCONN] [Thread: ControllerKeepAlive (#675451683)] [Type: Info] [MsgID: 17029] [Mesg: Contacted connector agent INCONN. Bind succeeded.]
[Time: 2005/12/11 19:47:50.922] [System: Collaboration] [SS: Test] [Thread: Test.thread1 (#673829667)] [Type: Error] [MsgID: 14201] [Mesg: A collaboration exception occurred at step 2 in Test.thread1INCONN_1134355734312_3CxCommon.FlowExecContext@2a66132a.main:, Error 14201 The status of the request is unknown for the delivery item ObjectEventId = INCONN_1134355734312_3.{2} with object event ID {3}. Returning a failure. Error14201.] |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Dec 11, 2005 8:29 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Unknown State in a statefull collaboration ?
 |
|
| Back to top |
|
|
| amateur10 |
| Posted: Sun Dec 11, 2005 8:39 pm Post subject: |
|
|
Centurion
Joined: 23 Nov 2005
Posts: 102
|
| I used both test connector and it successfully passed the bo to other side. When i removed the test connector and run jdbc connector, it gives that error. what might have happened? it means the systems itself is correct, but there is someting in connector configuration. what propertyh in jdbc connector might caused this? |
|
| Back to top |
|
|
|
|
