| Author |
Message
|
| gibiman |
 Posted: Mon Apr 17, 2006 6:03 am Post subject: connector crash with error |
 |
|
Novice
Joined: 14 Apr 2006
Posts: 10
|
| Quote: |
[Time: 2006/04/17 16:57:05.302] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: Restart Thread - JDBC_CobraConnector- retry #1 (#22845834)] [Type: Info] [MsgID: 17053] [Mesg: Publishing messages on queue AP/JDBC_CobraConnector/wics1t.]
[Time: 2006/04/17 16:57:05.343] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: WT=3 (#33078541)] [Type: Info] [MsgID: 17053] [Mesg: Publishing messages on queue AP/JDBC_CobraConnector/wics1t.]
[Time: 2006/04/17 16:57:05.344] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: WT=3 (#33078541)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state is active.]
[Time: 2006/04/17 16:57:05.611] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: Restart Thread - JDBC_CobraConnector- retry #1 (#22845834)] [Type: Info] [MsgID: 17051] [Mesg: The connector agent JDBC_CobraConnector is running in background mode.]
[Time: 2006/04/17 16:57:05.619] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Error] [MsgID: 37003] [Mesg: Execution of Prepared Retrieve Statement Failed : java.sql.SQLException: ORA-00904: "EVENT_TIME": invalid identifier
]
[Time: 2006/04/17 16:57:05.619] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Error] [MsgID: 37005] [Mesg: DBManager Operation Failed]
[Time: 2006/04/17 16:57:05.620] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Error] [MsgID: 32013] [Mesg: An Error occurred in EventMonitor]
[Time: 2006/04/17 16:57:05.621] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Error] [MsgID: 10556] [Mesg: Exception Detail: com.crossworlds.connectors.JDBC.exceptions.JDBCEventMonitorException
]
[Time: 2006/04/17 16:57:05.622] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Error] [MsgID: 17058] [Mesg: Application call to method poll() returned failure. The application could not be contacted.]
[Time: 2006/04/17 16:57:05.622] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Info] [MsgID: 17064] [Mesg: Connector Agent state is inactive.]
[Time: 2006/04/17 16:57:05.625] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Info] [MsgID: 17066] [Mesg: Application state is disconnected]
[Time: 2006/04/17 16:57:05.679] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: appPolling (#610720)] [Type: Info] [MsgID: 17066] [Mesg: Application state is disconnected]
[Time: 2006/04/17 16:57:05.699] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: Restart Thread - JDBC_CobraConnector- retry #1 (#30284778)] [Type: Info] [MsgID: 17514] [Mesg: About to begin restart retry # 1 for serial connector agent JDBC_CobraConnector.]
[Time: 2006/04/17 16:57:05.699] [System: ConnectorAgent] [SS: JDBC_CobraConnector] [Thread: Restart Thread - JDBC_CobraConnector- retry #1 (#30284778)] [Type: Info] [MsgID: 17516] [Mesg: Waiting for configured restart retry interval: 1 minute(s) before restarting connector agent JDBC_CobraConnector.]
|
I'm worried about a certain : " Java.sql.SQLException: ORA-00904: "EVENT_TIME" "
Could it be that in the event table set up for this connector , the column EVENT_TIME is missing ?
If so how do i specify which columns should the connector search ? |
|
| Back to top |
|
 |
| vk |
| Posted: Mon Apr 17, 2006 9:08 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
How did you create the event table? Did you run the script that comes as part of the installation? This has the column EVENT_TIME with a default value of system time.
Re-create the event table with this field and try again.
Regards,
Vk. |
|
| Back to top |
|
|
| gibiman |
| Posted: Mon Apr 17, 2006 11:13 pm Post subject: first of all thank you for replying to my post ! |
|
|
Novice
Joined: 14 Apr 2006
Posts: 10
|
I finally managed to start the connector by adding several required fields in my event table !
I now have another question which is bothering me !
| Quote: |
How do i change the event table default coloumns ?And how do i assign the respective values ?
|
This might have worked this time , although i have some problems getting the event to flow , but i want to know because there will be further configuration problems ...
Thank you ! |
|
| Back to top |
|
|
| vk |
| Posted: Tue Apr 18, 2006 4:17 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
| Quote: |
| How do i change the event table default coloumns ? |
Why do you want to change the structure of the event table? What exactly are you trying to achieve here? The connector expects the event table to be in a particular format, which is as per the script which comes as part of installation. If you change the structure of the event table, you might get unexpected errors.
| Quote: |
| And how do i assign the respective values ? |
This is usally done by a trigger configured on the applicaion table. When an event happens in the respective table, the trigger should make an entry in the event table which the connector will be polling at regular intervals.
Regards,
VK. |
|
| Back to top |
|
|
| gibiman |
| Posted: Wed Apr 19, 2006 2:07 am Post subject: Thank you for your reply! |
|
|
Novice
Joined: 14 Apr 2006
Posts: 10
|
what i meant to say by
| Quote: |
And how do i assign the respective values ?
|
Is that if i change the name of the columns how do i make the connector understand .
Ex : If i change de event_status colomn how do i make the connector understand what variable i mean
 |
|
| Back to top |
|
|
| vk |
| Posted: Wed Apr 19, 2006 4:34 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Why do you want to do that?
I think the select query should be part of the code in the JAR file CWJDBC.jar. The column names will be hard coded in the code. It might not be something which is configurable.
Regards,
VK. |
|
| Back to top |
|
|
| fast |
| Posted: Fri Apr 21, 2006 2:56 am Post subject: |
|
|
Newbie
Joined: 28 Feb 2006
Posts: 5
Location: Bangalore
|
we can not change the event table fields, field names even order.
connector expects the fields in that order.
Santhosh
_________________
FAST-"Flexible Accurate Steady Target Try Target" |
|
| Back to top |
|
|
|
|
