Hi All,

I notice that my JDBC driver hanging couple of times when trying to
execute the SQL query. The last line of the log below is where my driver
hang.
Is it possible due to connectivity problem? This issue only happened
after we perform server migration.

[05/28/15 15:27:07.661]:AMBG-IDV_TO_IPF-UPP ST:
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.0.2.0">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="ipfdb.sync_upp"
event-id="DVMPLX015#20150528072706#3#1:4a157d7a-eb16-4a48-b983-7a7d154a16eb"
qualified-src-dn="O=AMBG\OU=AMB40000000560000000000\OU=EMPLOYEE\ CN=10029632"
src-dn="\AMBG-IDV\AMBG\AMB40000000560000000000\EMPLOYEE\10029632 "
src-entry-id="77012">
<add-attr attr-name="trp_name">
<value>BANCS</value>
</add-attr>
<add-attr attr-name="upp_resource">
<value>BANCS</value>
</add-attr>
<add-attr attr-name="upp_desc">
<value>BANCS</value>
</add-attr>
<add-attr attr-name="usr_login">
<value>10029632</value>
</add-attr>
<add-attr attr-name="upp_login">
<value>10029632</value>
</add-attr>
<add-attr attr-name="upp_status">
<value>DA</value>
</add-attr>
<add-attr attr-name="upp_linked">
<value>T</value>
</add-attr>
<add-attr attr-name="upp_assigned">
<value>T</value>
</add-attr>
<operation-data>
<slot>ambgBANCS</slot>

<dn>\AMBG-IDV\AMBG\AMB40000000560000000000\EMPLOYEE\10029632 </dn>
<ops>add</ops>
</operation-data>
</add>
</input>
</nds>
[05/28/15 15:27:07.663]:AMBG-IDV_TO_IPF-UPP ST:Submitting document to
subscriber shim:
[05/28/15 15:27:07.663]:AMBG-IDV_TO_IPF-UPP ST:
<nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.0.2.0">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="ipfdb.sync_upp"
event-id="DVMPLX015#20150528072706#3#1:4a157d7a-eb16-4a48-b983-7a7d154a16eb"
qualified-src-dn="O=AMBG\OU=AMB40000000560000000000\OU=EMPLOYEE\ CN=10029632"
src-dn="\AMBG-IDV\AMBG\AMB40000000560000000000\EMPLOYEE\10029632 "
src-entry-id="77012">
<add-attr attr-name="trp_name">
<value>BANCS</value>
</add-attr>
<add-attr attr-name="upp_resource">
<value>BANCS</value>
</add-attr>
<add-attr attr-name="upp_desc">
<value>BANCS</value>
</add-attr>
<add-attr attr-name="usr_login">
<value>10029632</value>
</add-attr>
<add-attr attr-name="upp_login">
<value>10029632</value>
</add-attr>
<add-attr attr-name="upp_status">
<value>DA</value>
</add-attr>
<add-attr attr-name="upp_linked">
<value>T</value>
</add-attr>
<add-attr attr-name="upp_assigned">
<value>T</value>
</add-attr>
<operation-data>
<slot>ambgBANCS</slot>

<dn>\AMBG-IDV\AMBG\AMB40000000560000000000\EMPLOYEE\10029632 </dn>
<ops>add</ops>
</operation-data>
</add>
</input>
</nds>
[05/28/15 15:27:07.674]:AMBG-IDV_TO_IPF-UPP ST:Stripping operation data
from input document
[05/28/15 15:27:07.674]:AMBG-IDV_TO_IPF-UPP ST:BEGIN Transaction
[05/28/15 15:27:07.674]:AMBG-IDV_TO_IPF-UPP ST: INSERT INTO
sync_upp(trp_name, usr_login, upp_resource, upp_desc, upp_login,
upp_status, upp_linked, upp_assigned) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
[05/28/15 15:27:07.675]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 1, field
'trp_name', length: 5, value = 'BANCS'
[05/28/15 15:27:07.675]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 2, field
'usr_login', length: 8, value = '10029632'
[05/28/15 15:27:07.675]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 3, field
'upp_resource', length: 5, value = 'BANCS'
[05/28/15 15:27:07.675]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 4, field
'upp_desc', length: 5, value = 'BANCS'
[05/28/15 15:27:07.675]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 5, field
'upp_login', length: 8, value = '10029632'
[05/28/15 15:27:07.680]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 6, field
'upp_status', length: 2, value = 'DA'
[05/28/15 15:27:07.680]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 7, field
'upp_linked', length: 1, value = 'T'
[05/28/15 15:27:07.680]:AMBG-IDV_TO_IPF-UPP ST: IN @ index 8, field
'upp_assigned', length: 1, value = 'T'


--
kyin_ying
------------------------------------------------------------------------
kyin_ying's Profile: https://forums.netiq.com/member.php?userid=6787
View this thread: https://forums.netiq.com/showthread.php?t=53565