| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| can not create data in dest database |
« View previous topic :: View next topic » |
| Author |
Message
|
| veggiehui |
 Posted: Thu May 25, 2006 1:24 am Post subject: can not create data in dest database |
 |
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
I want to sync data from A database to B database, (all oracle,jdbc connector) when create a record in A's some table, I capture some information:
From connector:
| Quote: |
[Time: 2006/05/25 17:20:58.766] [System: ConnectorAgent] [SS: CAFWfdevConnector]
[Thread: appPolling (#1565616950)] [Type: Trace] [Mesg: :Received BusObj from A
pp Connector.]
[Time: 2006/05/25 17:20:58.766] [System: ConnectorAgent] [SS: CAFWfdevConnector]
[Thread: appPolling (#1565616950)] [Type: Trace] [Mesg: :Posting BusObj to Inte
rchange.]
[Time: 2006/05/25 17:20:58.781] [System: ConnectorAgent] [SS: CAFWfdevConnector]
[Thread: appPolling (#1565616950)] [Type: Trace] [Mesg: :Business Object befor
e delivering to the ICS :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:CAFWfTstAsbo>
BusinessObject = CAFWfTstAsbo
Verb = Create
Locale = en_US
STUDENT_ID = 7
STUDENT_NAME = bbbbb
ObjectEventId = 100087xworlds_events2006-05-25 17:20:58.0
<EndBO:CAFWfTstAsbo>]
[Time: 2006/05/25 17:20:58.812] [System: ConnectorAgent] [SS: CAFWfdevConnector]
[Thread: appPolling (#1565616950)] [Type: Trace] [Mesg: :Entering deliverBusObj
]
[Time: 2006/05/25 17:20:59.703] [System: ConnectorAgent] [SS: CAFWfdevConnector]
[Thread: appPolling (#1565616950)] [Type: Trace] [Mesg: :deliverBusObj returnin
g 0] |
to connector log:
| Quote: |
[Time: 2006/05/25 17:21:00.953] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: WT=1 (#1567255349)] [Type: Trace] [Mesg: :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:CAFErpTstAsbo>
BusinessObject = CAFErpTstAsbo
Verb = Create
Locale = zh_CN
STUDENT_ID = CxIgnore
STUDENT_NAME = CxIgnore
ObjectEventId = CxCommon.BusinessObject@33c587
<EndBO:CAFErpTstAsbo>]
[Time: 2006/05/25 17:21:00.953] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: WT=1 (#1567255349)] [Type: Error] [MsgID: 35903] [Mesg: Create Opera
tion Failed]
[Time: 2006/05/25 17:21:01.062] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: WT=1 (#1567255349)] [Type: Trace] [Mesg: :[Type: Warning] [MsgID: 34
012] [Mesg: Entering method releaseConnection.] ]
[Time: 2006/05/25 17:21:01.062] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: WT=1 (#1567255349)] [Type: Trace] [Mesg: :[Type: Warning] [MsgID: 34
013] [Mesg: Exiting method releaseConnection.] ]
[Time: 2006/05/25 17:21:01.062] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: WT=1 (#1567255349)] [Type: Error] [MsgID: 37004] [Mesg: Execution of
Prepared Update Statement Failed : java.sql.SQLException: ORA-00928: missing SE
LECT keyword
]
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type:
Error] [MsgID: 37004] [Mesg: Execution of Prepared Update Statement Failed : jav
a.sql.SQLException: ORA-00928: missing SELECT keyword
]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler
.java:771)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConne
ctorBOHandler.java:130)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2128)
at AppSide_Connector.BusObjJavaInterface.DoVerbFor(BusObjJavaInterface.j
ava:194)
at AppSide_Connector.AppCalls.DoVerbFor(AppCalls.java:265)
at AppSide_Connector.AgentBusinessObjectManager.DoVerbFor(AgentBusinessO
bjectManager.java:1412)
at CxCommon.Messaging.IIOP.IDLAgent.IpostBusObj(IDLAgent.java:209)
at IdlStubs.IConnAgentPOA._invoke(IConnAgentPOA.java:197)
at com.ibm.rmi.poa.GenericPOAServerSC.dispatchToServant(GenericPOAServer
SC.java:398)
at com.ibm.rmi.poa.GenericPOAServerSC.internalDispatch(GenericPOAServerS
C.java:252)
at com.ibm.rmi.poa.GenericPOAServerSC.dispatch(GenericPOAServerSC.java:1
5
at com.ibm.rmi.iiop.ORB.process(ORB.java:396)
at com.ibm.CORBA.iiop.ORB.process(ORB.java:1608)
at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2164)
at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63)
at com.ibm.rmi.iiop.WorkerThread.run(ThreadPoolImpl.java:182)
at java.lang.Thread.run(Thread.java:513)
[Time: 2006/05/25 17:21:01.062] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: WT=1 (#1567255349)] [Type: Trace] [Mesg: :[9543] DoVerbFor cookie=Th
u May 25 13:37:38 CST 2006A rc=-1 rtnObj.status=-1 rtnObj.message=[Type: Error]
[MsgID: 37004] [Mesg: Execution of Prepared Update Statement Failed : java.sql.S
QLException: ORA-00928: missing SELECT keyword
] ]
[Time: 2006/05/25 17:21:02.734] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: appPolling (#1565616949)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID
: 17008] [Mesg: Polling every 10000 milliseconds.] ]
[Time: 2006/05/25 17:21:02.734] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: appPolling (#1565616949)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID
: 17009] [Mesg: Polling for subscription events.] ]
[Time: 2006/05/25 17:21:02.734] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: appPolling (#1565616949)] [Type: Trace] [Mesg: Thread:appPolling:exe
cuting poll call]
[Time: 2006/05/25 17:21:02.734] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: appPolling (#1565616949)] [Type: Trace] [Mesg: :Polling App Connecto
r.]
[Time: 2006/05/25 17:21:02.734] [System: ConnectorAgent] [SS: CAFErpSampConnecto
r] [Thread: appPolling (#1565616949)] [Type: Trace] [Mesg: :[Type: Warning] [Msg
ID: 33007] [Mesg: Entering pollForEvents] ] |
I don't know what's wrong, and no result after checking the topic before here.[/quote] |
|
| Back to top |
|
 |
| sirsi |
| Posted: Thu May 25, 2006 8:00 am Post subject: |
|
|
Disciple
Joined: 11 Mar 2005
Posts: 177
|
it clearly says
| Quote: |
| missing SELECT keyword |
check ur SQL statement... |
|
| Back to top |
|
|
| veggiehui |
| Posted: Thu May 25, 2006 5:02 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
| but I have set SQL in none of my components. |
|
| Back to top |
|
|
| vennela |
| Posted: Tue May 30, 2006 9:33 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Maybe you didn't use the event table the way it needs to be
Tell us what you have done so far and where and when exactly are you getting this error.
Like Dest/Source side etc. Let us know the versions too. |
|
| Back to top |
|
|
| veggiehui |
| Posted: Tue May 30, 2006 11:05 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
Well, I'm working on WBI ICS4.3.1, Adapter 2.4.4 for JDBC.
Now I have two ASBOs,one GBO, their structures are the same, because the tables between two database are the same. two connectors for two database, and respective agent can be started successfully, a callobration for their logic,
calloboration definition:
Port BOType Create Update retrieve delete
TstWfIn CAFWfTstAsbo Main Main Main Main
TestErpOut CAFErpSampAsbo None None None None
when I insert into a record into table, above error occured.
and find the error message from the flow message:
| Quote: |
| Error 8000 Collaboration exception at step 38 in CAFTestSync.thread1CAFWfdevConnector_100085xworlds_events2006-05-25 16:51:41.0CxCommon.FlowExecContext@771a920b.Main:, Error 8000 Collaboration Failed: CAFWfTstAsbo, Create with keys ( STUDENT_ID=5). Exception type is: ConsumerException. Exception message is: Error 11158 Collaboration exception at step 7 in CAFTestSync.thread1CAFWfdevConnector_100085xworlds_events2006-05-25 16:51:41.0CxCommon.FlowExecContext@771a920b.Main:, Error 11158 End Failure node 64 was reached in the collaboration subdiagram 7. Error11158. Error11158. Error8000. Error8000 |
|
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Jun 08, 2006 1:06 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
you dont have any data in the destination ASBO. That could cause a problem.
_________________
-Ratan |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
