| Author |
Message
|
| wbiadp |
 Posted: Thu Aug 18, 2005 4:37 pm Post subject: JDBC Adapter Polling failure - WBIMB |
 |
|
Newbie
Joined: 17 Aug 2005
Posts: 9
|
While Polling the events table I get the following error. Actually,there are 3 rows in the table that are to be processed by the adapter.
JDBC Adapter v2.6, Framework Version 2.6, DB2 8.1, MQ 5.3, WBI MB v5
, win2k
Should I have the Message Broker running when I start the connector ?
| Quote: |
[Version:4.3.0.0][TZ:America/Los_Angeles]
[Time: 2005/08/18 20:03:56.438] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: wbia_main (#1083619647)] [Type: Trace] [MsgID: 17016] [Mesg: Initializing connector myJDBCConnector, Version = 2.6.0, Connector Framework version = 4.3.0, CDK version = 4.3.0.]
[Time: 2005/08/18 20:03:56.469] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: wbia_main (#1083619647)] [Type: Error] [MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.] [Time: 2005/08/18 20:03:56.469] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: wbia_main (#1083619647)] [Type: Internal Warning] [MsgID: 33027] [Mesg: No applicable transport-layer security context information was foundfor a requested ssl-protected socket. The request was made on behalfof component {1} of type {2}.]
[Time: 2005/08/18 20:03:57.797] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: wbia_main (#1083619647)] [Type: Info] [MsgID: 17066] [Mesg: Application state is connected]
[Time: 2005/08/18 20:03:58.703] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: ClientPacketSyncDrvFormattermyJDBCConnector (#1089943871)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state is active.]
[Time: 2005/08/18 20:03:58.969] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: wbia_main (#1083619647)] [Type: Info] [MsgID: 17007] [Mesg: Press q to quit connector.]
[Time: 2005/08/18 20:03:59.047] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: appPolling (#1087535423)] [Type: Error] [MsgID: 17109] [Mesg: Exception caught in the method BusObjJavaInterface::poll. Reason: java.lang.NullPointerException]
[Time: 2005/08/18 20:03:59.047] [System: ConnectorAgent] [SS: myJDBCConnector] [Thread: appPolling (#1087535423)] [Type: Error] [MsgID: 17050] [Mesg: The call to method poll() in the application connector failed.] |
|
|
| Back to top |
|
 |
| wbiadp |
| Posted: Fri Aug 19, 2005 5:14 am Post subject: |
|
|
Newbie
Joined: 17 Aug 2005
Posts: 9
|
Hi All,
Jst wondering if any one had a chance to look at this problem? |
|
| Back to top |
|
|
| recallsunny |
| Posted: Fri Aug 19, 2005 8:03 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
You donot need the Message broker running for the Connector Agent to start.
Do you have the Trace level upto 5? The message seems very rudimentary, doesn't look like a JDBC specific error. Wonder if you configured all the needed properties in Conn Specific Properties tab.
Can you post them here? |
|
| Back to top |
|
|
| wbiadp |
| Posted: Fri Aug 19, 2005 10:31 am Post subject: |
|
|
Newbie
Joined: 17 Aug 2005
Posts: 9
|
Hi RecallSunny,
not much of information i could gather when trace level was set to 5. it almost dumps the same error with out much info. I will post that in the next post ......... below are the conn specific properties.. . thanks in adv.
ApplicationPassword wbi4
ApplicationUserName wbiadmin (has all db permissions)
ArchiveProcessed true
ArchiveTableName myArchiveTable
AutoCommit False
CheckForEventTableInInit False
ChildUpdatePhyDelete False
CloseDBConnection False
ConnectorID NONE
DatabaseURL jdbc:db2:MYUSERS
DateFormat MM/dd/yyyy HH:mm:ss
DriverConnectionProperties currentSchema=wbiadmin
DriverSupportForLong True
EventKeyDel ;
EventOrderBy
EventQueryType Fixed
EventTableName MYJDBCEVENTS
JDBCDriverClass COM.ibm.db2.jdbc.app.DB2Driver
MaximumDatabaseConnections 5
PingQuery
PollQuantity 1
PreserveUIDSeq True
QueryTimeOut False
RDBMS.initsession
RDBMSVendor DB2
RetryCountAndInterval 3,20
ReturnDummyBOForSP False
SchemaName
UniqueIDTableName MYJDBC_UID
UseDefaults False
UseDefaultsForCreatingChildBOs False
UseDefaultsForRetrieve False
UseDefaultsWhenPolling True |
|
| Back to top |
|
|
| recallsunny |
| Posted: Fri Aug 19, 2005 12:45 pm Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
Ok,
Your Conn Specific properties Look good, nothing there to suggest foulplay... However it is recommended that you set the "CheckForEventTableInInit" property to true.
The other thing is
| Code: |
| [Type: Error] [MsgID: 33018] [Mesg: This is an internal error. A request was made that a client-socket-generatorgenerate a server socket.] |
I have'nt seen this kind of Error before, especially with JDBC adapter because You don't deal with SSL issues for a Database call, unless Your JMS provider is configured to use SSL... 
Can you check if your JMS provider is set to "CxCommon.Messaging.jms.IBMMQSeriesFactory" and repository directory points to the location of your Message Set XSD location.
Finally check if your messageFilename points to JDBCConnector.txt. |
|
| Back to top |
|
|
| recallsunny |
| Posted: Fri Aug 19, 2005 12:59 pm Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
I've a feeling that your MessageFileName is pointing to "WBIAdapterRuntime.txt" as the MsgID: 33018 is present in that.
Can you change your MessageFileName to JDBCConnector.txt present in the "messages" folder of your Connector installation directory. This should point us to an accurate Error rather than leading us on a wild goose chase!
 |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Sat Aug 20, 2005 6:17 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
Can you pull out one of the record in the EventTable, (What are the row contents)...
what value did u give in the PollFrequency Property ?
and I suggest.. to fill in these attributes.
1. PingQuery (eventtablename) (infact any table which exists)
2. CheckForEventTableInInit (True)
3. SchemaName (schema where ur eventTable exists)
give a shot with these changes..
-RR |
|
| Back to top |
|
|
| wbiadp |
| Posted: Sun Aug 21, 2005 7:40 pm Post subject: |
|
|
Newbie
Joined: 17 Aug 2005
Posts: 9
|
Thanks ya'll . Based on your suggestions, I configured my adapter with below conn specific props. It starts up with no errors. But it does the reverse of what I want. My scenario is use this JDBC adapter to send a message to the queue where WBIMB will process. But this one, when it finds a new row (lets say with VERB -CREATE ) in my events table, it picks up and converts into a BO and instead of putting it on a queue, it is performing that operation (CREATE) back on the database table which the BO represents.
With my understanding frm documentation, there is no need for that as long as the queues are set up and this app has permissions to put msg on the queus.
Is there any setting that needed to be done....... ??
ApplicationUserName wbiadmin
ApplicationPassword tiger
ArchiveProcessed true
ArchiveTableName xworlds_archive_events
AutoCommit False
CheckForEventTableInInit true
ChildUpdatePhyDelete False
CloseDBConnection False
ConnectorID NONE
DatabaseURL jdbc:oracle:thin:@altair:1521:PROD
DateFormat MM/dd/yyyy HH:mm:ss
DriverConnectionProperties
MaximumDatabaseConnections 5
PingQuery xworlds_events
PollQuantity 1
PreserveUIDSeq True
QueryTimeOut False
RDBMS.initsession
RDBMSVendor ORACLE
RetryCountAndInterval 3,20
ReturnDummyBOForSP False
SchemaName wbiadmin
UniqueIDTableName xworlds_uid
UseDefaults False
UseDefaultsForCreatingChildBOs False
UseDefaultsWhenPolling True
UseDefaultsForRetrieve False
DriverSupportForLong True
EventKeyDel ;
EventOrderBy
EventQueryType Fixed
EventTableName xworlds_events
JDBCDriverClass oracle.jdbc.driver.OracleDriver |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Mon Aug 22, 2005 4:08 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
check the supported verbs in the .xsd,
-RR |
|
| Back to top |
|
|
| recallsunny |
| Posted: Mon Aug 22, 2005 10:01 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
How does the event Look in the Event Table that you've configured for the Adapter?
Are these values populated ...
| Code: |
connector_id,
object_key,
object_name,
object_verb,
event_priority,
event_status |
|
|
| Back to top |
|
|
| MSV |
| Posted: Fri Sep 01, 2006 2:19 am Post subject: |
|
|
Acolyte
Joined: 11 Apr 2006
Posts: 59
|
I am using jdbc connector to retrieve records from a table and to place them into the delivery queue(which is my messagebroker input queue)
Environment:
Adapter framework version is 2.6.0.4
Jdbc connector version is 2.6.0
MQ V6.0,MB 6.0.0.1
Though my connector is running, i'm getting an error :"Setting timingStats to default" while starting it.I ignored it and continued testing.
After inserting data in the XWORLDS_EVENTS table, i'm getting the following errors in the jdbc console.
| Quote: |
[Time: 2006/09/01 15:07:35.562] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1193762853)] [Type:
Error] [MsgID: 35030] [Mesg: Cannot find the business object WO1 in the database with the key values received.]
[System: ConnectorAgent] [SS: JDBCConnector]
[Thread: appPolling (#1193762853)] [Type: Error] [MsgID: 10556] [Mesg: Exception
Detail:com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException[Type: Error] [MsgID: 35030] [Mesg: Cannot find
the business object WO1 in the database with the key values received.] ]
[Time: 2006/09/01 15:07:35.562] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1193762853)] [Type: Trace]
[Mesg: :com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type:Error] [MsgID: 35030] [Mesg: Cannot
find the business object WO1 in the database with the key values received.]
[Time: 2006/09/01 15:07:35.562] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: appPolling (#1193762853)] [Type: Fatal
Error] [MsgID: 35030] [Mesg: Cannot find the business object WO1 in the database with the key values received.] |
Within the supported BO's, the bo name is mentioned correctly.
status field is returning '-1'
Anyone help me in this regard... |
|
| Back to top |
|
|
| MSV |
| Posted: Sun Sep 03, 2006 7:40 am Post subject: |
|
|
Acolyte
Joined: 11 Apr 2006
Posts: 59
|
The sql file(event_packages_db2.sql) present in installfolder/connectors/dependencies is not executed successfully.
will this be a reason for the error listed in the above post ? |
|
| Back to top |
|
|
|
|
