| Author |
Message
|
| emiddleware |
 Posted: Wed Apr 05, 2006 8:14 pm Post subject: Duplicate records reach the target side after re-submitting |
 |
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Dear Folks ,
We are sending data from Siebel to BPCS . We use MQ connector to extract data from Siebel and JDBC connector to put data in BPCS. During transaction , the data failed in WBI ICS. On seeing logs we investigated communication link error where the agent was not able to connect to the BPCS system. We re-submitted after some time and the data reached the BPCS system but duplicate records reached .
Can u give us an idea if you have come across this situation ....
Can anybody explain the reason why duplicate records have reached .
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
 |
| Kram |
| Posted: Fri Apr 07, 2006 5:47 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006
Posts: 87
|
If there is not communication the agent would have been down which means that the message is still in the collab so once you bring the agent up the message is sent to the dest appln. so when you tried to resubmit the appln has already received the previous message pending in the collab. I think that could be the reason why you see duplicate records.
let us know if this is not the case ....
_________________
Regards,
Ram |
|
| Back to top |
|
|
| emiddleware |
| Posted: Sun Apr 09, 2006 5:39 pm Post subject: Duplicate records reach the target side after re-submitting |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Hi All,
Hey Ram, thanx!
But I have a question . Agreed that the agent was down as it was not establishing communication with the target system . But in such a case , it had failed in Failed flow . Hence , if the agent is up, then how do we know that the data would have automatically gone to target system. Since we saw a failed flow we again re-submitted ....
Can you give a detailed explaination ...
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| Kram |
| Posted: Mon Apr 10, 2006 6:00 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006
Posts: 87
|
I dont think the message will go to the failed flow if the destination connector is down... should be only in the collab as InProgress.(unless specifically coded for ....)
But you are saying you saw the message in the failed flow... can you tell what was the error for putting the message in the failed flow?
_________________
Regards,
Ram |
|
| Back to top |
|
|
| emiddleware |
| Posted: Mon Apr 10, 2006 6:42 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Thanks Ram,
On Event details it was SQL Communication Link Error .... It happens quite frequently . It happened on 13 MArch and again happened frequently .. Last it happened on 27th March ..
Let me attach a snip of the log / trace ..
27-March-2006
37005] [Mesg: DBManager Operation Failed]
[Time: 2006/03/27 19:14:46.346] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35903] [Mesg: Create Operation Failed]
[Time: 2006/03/27 19:14:46.346] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35908] [Mesg: ContainerCreate operation Failed]
[Time: 2006/03/27 19:14:46.346] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35903] [Mesg: Create Operation Failed]
[Time: 2006/03/27 19:14:46.346] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35024] [Mesg: Rollback failed on create java.sql.SQLException: The connection does not exist..]
[Time: 2006/03/27 19:14:46.362] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 10556] [Mesg: Exception Detail: com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException
[Type: Error] [MsgID: 35024] [Mesg: Rollback failed on create java.sql.SQLException: The connection does not exist..] ]
[Time: 2006/03/27 19:14:46.690] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception java.sql.SQLException: The connection does not exist. occurred]
[Time: 2006/03/27 19:14:46.690] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 37005] [Mesg: DBManager Operation Failed]
[Time: 2006/03/27 19:14:46.690] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35903] [Mesg: Create Operation Failed]
[Time: 2006/03/27 19:14:46.690] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35908] [Mesg: ContainerCreate operation Failed]
[Time: 2006/03/27 19:14:46.690] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35903] [Mesg: Create Operation Failed]
[Time: 2006/03/27 19:14:46.706] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35024] [Mesg: Rollback failed on create java.sql.SQLException: The connection does not exist..]
[Time: 2006/03/27 19:14:46.706] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 10556] [Mesg: Exception Detail: com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException
[Type: Error] [MsgID: 35024] [Mesg: Rollback failed on create java.sql.SQLException: The connection does not exist..] ]
[Time: 2006/03/27 19:14:46.987] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception java.sql.SQLException: The connection does not exist. occurred]
[Time: 2006/03/27 19:14:46.987] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 37005] [Mesg: DBManager Operation Failed]
[Time: 2006/03/27 19:14:46.987] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35903] [Mesg: Create Operation Failed]
[Time: 2006/03/27 19:14:46.987] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35908] [Mesg: ContainerCreate operation Failed]
[Time: 2006/03/27 19:14:46.987] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35903] [Mesg: Create Operation Failed]
[Time: 2006/03/27 19:14:46.987] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: WT=2 (#38662450)] [Type: Error] [MsgID: 35024] [Mesg: Rollback failed on create java.sql.SQLException: The connection does not exist..]
On that day , the same problem persisted and we re-submitted the data from failed flow and after that the target users reported that duplicate records had reached ....
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| thomeck |
| Posted: Mon Apr 10, 2006 11:55 pm Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006
Posts: 30
Location: Germany
|
|
| Back to top |
|
|
| thomeck |
| Posted: Mon Apr 10, 2006 11:58 pm Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006
Posts: 30
Location: Germany
|
And also this entry:
74226|2.6.0.5 (Enhancement)| MQ Adapter and Adapter Framework behavior for duplicate events
 |
|
| Back to top |
|
|
| emiddleware |
| Posted: Tue Apr 11, 2006 7:23 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Hi all,
Thanx theomek,
I just looked into the link and saw the corresponding enhancement message ie, 74226
2.6.0.5
(Enhancement)
MQ Adapter and Adapter Framework behavior for duplicate events
Yes . we are using v2.6 for FA. So should I take it this way that when ever there is a failed flow in ICS , and when we re-submit from failed flow, there will be duplicate entry in the target system . But , many times we have re-submitted records from failed flow . Very seldom duplicate entry happens in the target system .
Ram, Theomek and Everybody ..
what is your view point ?
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| emiddleware |
| Posted: Tue Apr 11, 2006 8:09 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Hi All,
Ram, I have another quesition in my mind ..
The agent gets the data , calls the map and sends it to collaboration. After performing logic , the collaboration passes it to the other connector controller , where the controller calls the map from GBO to ASBO. At this point of the time , the agent has stopped.
In the trace file I see ,
1) Passing the following business object into the map:
2) Getting the following business object from the map:
[Time: 2006/03/27 16:25:29.710] [System: ConnectorController] [SS: JDBCConnector] [Thread: CHN_TFMEvent_SBL_to_BPS.thread51 (#1008700735)] [Type: Trace] [Mesg: Agent process is running, Processing postBusObj]
[Time: 2006/03/27 16:25:29.788] [System: ConnectorController] [SS: JDBCConnector] [Thread: CHN_TFMEvent_SBL_to_BPS.thread51 (#1008700735)] [Type: Trace] [Mesg: [9543] deliverAcknowledge status=-1 cookie=Wed Mar 22 00:04:40 SGT 2006 rtnObj.status=-1 rtnObj.message=[Type: Error] [MsgID: 37000] [Mesg: A SQL Exception java.sql.SQLException: Communication link failure. (Connection was dropped unexpectedly.) occurred] ]
What is ur view point about this ??? its pretty urgent  (((
Theomek,
We are using the version 2.6.0 . I just checked in the licence version.
Program Name: IBM WebSphere Business Integration Adapter Framework v2.6.0.
To my knowledge, v2.6 is the latest version . Has v2.7 come out in the market ?
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| thomeck |
| Posted: Tue Apr 11, 2006 11:34 pm Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006
Posts: 30
Location: Germany
|
Hi emiddleware,
we are using af 2.6.0.3 and want to upgrade to 2.6.0.5
this is the latest Version.
I don't think that 2.7 is comming soon.
The other point to your JDBC problem.
Had you stopped the agent or is he stopped by his self?
(If you stop the agent: connector -stop
the agent will end his work and after that he will getting down.
If you say connector -kill
the agent will getting down immediatly because you are killing the agent process)
What did happen? |
|
| Back to top |
|
|
| emiddleware |
| Posted: Wed Apr 12, 2006 6:07 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
hey there,
no .. we did not stop the connector agent at all ......
Can you please answer my Queries ........ 
I am waiting for all your answers .....
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| thomeck |
| Posted: Thu Apr 13, 2006 2:23 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006
Posts: 30
Location: Germany
|
Hi,
can you give us more information? (connector log, ics trace and log)
does the mapping end succesfully?
does the agent tries to send the asbo?
has the db user all authorizations? |
|
| Back to top |
|
|
| Kram |
| Posted: Thu Apr 13, 2006 5:48 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006
Posts: 87
|
Check if the process is running at that time when u got the error?
Check if ur DB was running at that time?
_________________
Regards,
Ram |
|
| Back to top |
|
|
|
|
