| Author |
Message
|
| voyager |
 Posted: Mon Jan 31, 2005 6:05 am Post subject: ICS/JDBC connector Issue |
 |
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Dear friends,
In ICS, I am trying to read SQL table and write to DB2/400 table using JDBC connectors. I created two connectors, one is JDBCRead and the other one is JDBCWrite connector. And I am reading from a SQL table with JDBC Read connector and writing to AS/400 table with JDBC Write connector. I am populating Events table with a stored procedure.
JDBCRead connector polls the Events table and whenever there is a new message in the Events table, it gets the info. from the SQL source table and JDBCWrite connector writes this data to DB2/400 destination table.
I am using IDL as the transport medium. I created BO's, maps, Collab.template and Collab. object and deployed them on
the local ICS server. I started the JDBC Read/Write Connectors(Agents)
Then, JDBC Read connector started running, but JDBC Write connector did not run and I got the following errors in the JDBC Write log.
-----------------------------------------------------------------
[Time: 2005/01/28 16:04:37.546] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477447273)] [Type: Error]
[MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.]
[Time: 2005/01/28 16:04:39.048] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477447273)] [Type: Error]
[MsgID: 37000] [Mesg: Missing user connection pool configuration update information.]
[Time: 2005/01/28 16:04:39.048] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477447273)] [Type: Error]
[MsgID: 32013] [Mesg: Message key 32013 :: C:\\IBM\\WebSphereICS\\connectors\\messages\\CwConnectorAgentMessages.txt does not contain the text for this message.]
[Time: 2005/01/28 16:04:39.064] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477447273)] [Type: Fatal Error]
[MsgID: 17050] [Mesg: The call to method init() in the application connector failed.]
[Time: 2005/01/28 16:04:39.064] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477447273)] [Type: Info]
[MsgID: 17514] [Mesg: About to begin restart retry # 3 for serial connector agent JDBCWriteConnector.]
[Time: 2005/01/28 16:04:39.064] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477447273)] [Type: Info]
[MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent JDBCWriteConnector.]
[Time: 2005/01/28 16:05:39.245] [System: Server] [Thread: wbia_main (#477447273)] [Type: Info]
[MsgID: 165] [Mesg: Updating configuration file "C:\IBM\WebSphereICS\connectors\JDBCWriteConnector.cfg".
The old configuration will be copied to "C:\IBM\WebSphereICS\connectors\JDBCWriteConnector.cfg.bak".]
--------------------------------------------------------------
Please, let me know if I have to run anything on the AS/400 in order to make the JDBC Write connector working.
Thank you very much in advance!!
_________________
voyager |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon Jan 31, 2005 7:38 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Why do you use 2 connectors?
You can use one connector for both the purposes. |
|
| Back to top |
|
|
| voyager |
| Posted: Mon Jan 31, 2005 8:03 am Post subject: Not sure!! |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
I am really not sure if I can use just one JDBC connector for both reading SQL table and write to DB2/400 table.
My basic idea is to get the table data from SQL Server and write to DB2/400 table on AS/400. I have a stored procedure to popluate "Events" table. Basically, I am getting errors with the JDBCRead connector, too. The JDBCRead.log file says
"[MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.]"
I am not sure, what exactly is happening. I am just guessing that the process thread is not able to get created. Anyway, if you have any idea how to proceed to get this done. I greatly appreciate.
Thank you!
_________________
voyager |
|
| Back to top |
|
|
| vennela |
| Posted: Mon Jan 31, 2005 9:57 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
My bad I didn't read the post right.
I thought you were reading and writing to the same DB (DB2 on AS/400). |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Jan 31, 2005 1:59 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You are the client to both DBs.
As such you need a client socket generator and not a server socket generator.
Check you setup for the DB connectors. Must be somehow wrong(trying to generate the wrong type of socket)
Enjoy  |
|
| Back to top |
|
|
| voyager |
| Posted: Mon Jan 31, 2005 2:13 pm Post subject: Thank you |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Thank you grand Master,
I will check up the JDBC connectors setup.
Thank you once again!
_________________
voyager |
|
| Back to top |
|
|
| voyager |
| Posted: Tue Feb 01, 2005 8:19 am Post subject: Still not getting JDBCWrite connector working |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Hello friends,
I still could not get the JDBCWrite connector working. And I am getting the following errors in JDBCWRite.log
-------------------------------------------------------------------------------
[Time: 2005/02/01 11:15:29.316] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Error] [MsgID: 33018] [Mesg: Setting ArchiveTableName to default.]
[Time: 2005/02/01 11:15:29.316] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Error] [MsgID: 33018] [Mesg: Setting EventTableName to default.]
[Time: 2005/02/01 11:15:29.316] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Error] [MsgID: 33016] [Mesg: Null value found for Property : pollQuantity]
[Time: 2005/02/01 11:15:30.347] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Error] [MsgID: 37000] [Mesg: A SQL Exception java.sql.SQLException: [SQL0204] XWORLDS_EVENTS in XPSFILE type *FILE not found. occurred]
[Time: 2005/02/01 11:15:30.347] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Error] [MsgID: 32013] [Mesg: An Error occurred in EventMonitor]
[Time: 2005/02/01 11:15:30.347] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application connector failed.]
[Time: 2005/02/01 11:15:30.347] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent JDBCWriteConnector.]
[Time: 2005/02/01 11:15:30.347] [System: ConnectorAgent] [SS: JDBCWriteConnector] [Thread: wbia_main (#477152969)]
[Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent JDBCWriteConnector.]
-----------------------------------------------------------------------------------
I appreciate very much if anybody could help me what is wrong in my JDBC connector configuration.
Thanks!!
_________________
voyager |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Feb 01, 2005 3:09 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well ...
Back to the basics:
Do you have Update or Insert grant on the tables you are trying to write to? |
|
| Back to top |
|
|
| voyager |
| Posted: Wed Feb 02, 2005 6:57 am Post subject: Unsubscribed Event |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Yes sir,
I do have the permissions to update the table. But, now I have come over that issue of running
JDBCWrite connector. Now, both JDBCRead and JDBCWrite connectors are running.
I am populating 'Events' table in SQL Server DB with one record with all the values.
JDBCRead connector polling the Events table and when a new record is available,
passes to ICS and then JDBCWrite connector looks for the subsriptions and writes
the SQL table record to DB2/400 DB.
These are the fields in Events table.
Event_id, Connector_Id, Object_Key, Object_Name, Object_Verb ,
Event_Priority, Event_Time, Event_Comment, Event_Status.
When I first created a record in Events table, I created with Event_Status value as zero.
When JDBCRead connector polling then it changed the Event_status value to 2 which is Unsubscribed_Event.
This is where I am stuck right now. I am unable to figure out what is causing this
Unsubscribed Event status b'cos the Collab. is subscribed to this connector.
These are the values of Event_Status:
Ready_For_Poll 0
Sent_To_InterChange 1
Unsubscribed_Event 2
In_Progress 3
Error_Processing_Event -1
Error_Sending_Event_To_InterChange -2
If anyone has any idea, I greatly appreciate.
Thank you,
_________________
voyager |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Feb 02, 2005 12:51 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Isn't the subscription done on base of object_name + object_verb.
You say you subscribed to the object what about the action (verb)?
Just guessing  |
|
| Back to top |
|
|
| voyager |
| Posted: Wed Feb 02, 2005 1:07 pm Post subject: Right |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Yes Grand Master,
The subscription takes as BO Name+ Action Verb.
We specify the verb in Collab. Template and build the Collaboration based on the template.
By the way, I am still stuck here and trying to find a way out.
Thank you,
_________________
voyager |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Feb 03, 2005 12:13 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Case sensitivity in the subscription matches the one in the publication ? |
|
| Back to top |
|
|
|
|
