Hi,

Appreciate if anyone can help on this.

JDBC driver in my IDM 4.0.1 to connect to MySQL had shows the error
below:

[11/25/11 12:12:36.140]:CIMB-IDV_TO_IPF-UPP ST:Stripping operation data
from input document
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST:Acquired lock on
connection 'dedicated0'.
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST:BEGIN Transaction
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST: BEGIN Handle ADD.
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST: BEGIN Interpret
event.
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST: END Interpret
event.
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST: BEGIN Insert row into
parent table 'ipfdb.sync_upp'.
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST: Not locking.
[11/25/11 12:12:36.141]:CIMB-IDV_TO_IPF-UPP ST: INSERT INTO
sync_upp(trp_name, usr_login, upp_resource, upp_login, upp_password,
upp_status, upp_linked, upp_assigned) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
[11/25/11 12:12:36.142]:CIMB-IDV_TO_IPF-UPP ST: BEGIN Instantiate
prepared statement.
[11/25/11 12:12:36.142]:CIMB-IDV_TO_IPF-UPP ST: Allocating statement
from connection 581f0ad3.
[11/25/11 12:12:36.142]:CIMB-IDV_TO_IPF-UPP ST: Allocated statement
3f7241d: INSERT INTO sync_upp(trp_name, usr_login, upp_resource,
upp_login, upp_password, upp_status, upp_linked, upp_assigned) VALUES
(** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT
SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED
**, ** NOT SPECIFIED **).
[11/25/11 12:12:36.143]:CIMB-IDV_TO_IPF-UPP ST: END Instantiate
prepared statement.
[11/25/11 12:12:36.143]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 1, field
'trp_name', length: 10, value = 'xxxxxxxxxxxx'
[11/25/11 12:12:36.143]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 2, field
'usr_login', length: 7, value = '00xxxx7'
[11/25/11 12:12:36.143]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 3, field
'upp_resource', length: 10, value = 'xxxxxxxxxxxxx'
[11/25/11 12:12:36.143]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 4, field
'upp_login', length: 8, value = 'xxxxxxxxxx'
[11/25/11 12:12:36.144]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 5, field
'upp_password', length: 24, value = 'xxxxxxxxxxxxxxxxx'
[11/25/11 12:12:36.144]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 6, field
'upp_status', length: 2, value = 'EA'
[11/25/11 12:12:36.144]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 7, field
'upp_linked', length: 1, value = 'F'
[11/25/11 12:12:36.144]:CIMB-IDV_TO_IPF-UPP ST: IN @ index 8, field
'upp_assigned', length: 1, value = 'T'
[11/25/11 12:12:36.145]:CIMB-IDV_TO_IPF-UPP ST: Closed statement
3f7241d: statement has been closed, no further internal information
available.
[11/25/11 12:12:36.145]:CIMB-IDV_TO_IPF-UPP ST: BEGIN Test for bad
connection.
[11/25/11 12:12:36.145]:CIMB-IDV_TO_IPF-UPP ST: END Test for bad
connection.
[11/25/11 12:12:36.145]:CIMB-IDV_TO_IPF-UPP ST: *Connection is bad.*
[11/25/11 12:12:36.145]:CIMB-IDV_TO_IPF-UPP ST: BEGIN rollback.
[11/25/11 12:12:36.145]:CIMB-IDV_TO_IPF-UPP ST: ROLLBACK
[11/25/11 12:12:36.146]:CIMB-IDV_TO_IPF-UPP ST: Unable to rollback
transaction.
[11/25/11 12:12:36.146]:CIMB-IDV_TO_IPF-UPP ST: Number of statements
allocated on connection 'dedicated0': 0.
[11/25/11 12:12:36.146]:CIMB-IDV_TO_IPF-UPP
ST:SubscriptionShim.execute() returned:
[11/25/11 12:12:36.146]:CIMB-IDV_TO_IPF-UPP ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20110402_1136" instance="CIMB-IDV_TO_IPF-UPP"
version="3.5.7">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output/>
</nds>
[11/25/11 12:12:36.146]:CIMB-IDV_TO_IPF-UPP ST:Applying input
transformation policies.
[11/25/11 12:12:36.147]:CIMB-IDV_TO_IPF-UPP ST:Applying policy:
%+C%14CPubInputP01-Read Payload%-C.
[11/25/11 12:12:36.147]:CIMB-IDV_TO_IPF-UPP ST:Policy returned:
[11/25/11 12:12:36.147]:CIMB-IDV_TO_IPF-UPP ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20110402_1136" instance="CIMB-IDV_TO_IPF-UPP"
version="3.5.7">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output/>
</nds>
[11/25/11 12:12:36.147]:CIMB-IDV_TO_IPF-UPP ST:Applying schema mapping
policies to input.
[11/25/11 12:12:36.147]:CIMB-IDV_TO_IPF-UPP ST:Applying policy:
%+C%14CSchema+Mapping+Rule%-C.
[11/25/11 12:12:36.148]:CIMB-IDV_TO_IPF-UPP ST:Resolving association
references.
[11/25/11 12:12:36.148]:CIMB-IDV_TO_IPF-UPP ST:Processing returned
document.
[11/25/11 12:12:36.148]:CIMB-IDV_TO_IPF-UPP ST:End transaction.


Its seems this error shown whenever it didn't process any transaction
to MySQL for a long time. And it wouldn't retry this transaction.
This is just my assumption, hope if anyone face/solve it before can
help.

Really appreciate and thanks!


--
suzan_low
------------------------------------------------------------------------
suzan_low's Profile: http://forums.novell.com/member.php?userid=71556
View this thread: http://forums.novell.com/showthread.php?t=449174