I am trying to migrate an existing
application from ND 3.x to ND 4.x.
The problem I am currently facing is with a
few INSERT data objects which bomb out. The
description of the error generated suggests
that the connection to the DB is already in
use. Oddly enough another INSERT DO works
correctly after the upgrade.
I have included the NetDynamics log file
at the bottom of this message with the RDBMS
Service error message thats generated. I hope
it will help understand the problem. The first
half of the file contains the log for the
failing INSERT DO and the remaining half for
the INSERT DO thats executing correctly.
One thing I see in the log file that is not
consistent between the two DOs is that the
AutoCommit is DISABLED for the failing DO. I
wonder if that is causing the problem & how
do I resolve it???
I will greatly appreciate any input towards
resolving this problem.
Thanks in advance,
Nilima Desai
408-970-2236
[EMAIL PROTECTED]
***************************************************************
NETDYNAMICS LOG FILE BEGINS
***************************************************************
6032 Jul 20, 1999 at 16:57:55.218 Terse Debug Thread-17 CPService
COIN_Web2.doGetNewPK:c:932513861937:w:932513862140:execute:
'doGetNewPK', request=[EC-[offset=0, count=1, whence=B],
SP=|arshad.get_new_pk|,
inputSchema=[[name=table_name, paramType=1],[name=no_ok_keys, paramType=1]],
procedureParams=spider.database.CSpDBProcedureParam
[|issues|, |1|]]
6033 Jul 20, 1999 at 16:57:55.437 Terse Debug Thread-17 CPService
COIN_Web2.doGetNewPK:c:932513861937:w:932513862140:executeTheRequestAtTheDS:
'doGetNewPK' executed SUCCESSFULLY.
results=spider.database.CSpDBProcedureResult
[spider.database.CSpDBResultStatus [SUCCESS(9)],
spider.database.CSpDBResultTable
[rows=1, cols=2, firstRowIndex=0, data(no trim)={|861|, |0|,
spider.database.CSpDBResultSchema
[], returnValue=||, returnParams=spider.database.CSpDBProcedureParam []]
6034 Jul 20, 1999 at 16:57:55.453 Terse Debug Thread-17 CPService
COIN_Web2.doGetNewPK:c:932513861937:w:932513862140:execute:
'doGetNewPK', request=[EC-[offset=0, count=1, whence=B],
SP=|arshad.get_new_pk|,
inputSchema=[[name=table_name, paramType=1],[name=no_ok_keys, paramType=1]],
procedureParams=spider.database.CSpDBProcedureParam
[|comments|, |1|]]
6035 Jul 20, 1999 at 16:57:55.656 Terse Debug Thread-17 CPService
COIN_Web2.doGetNewPK:c:932513861937:w:932513862140:executeTheRequestAtTheDS:
'doGetNewPK' executed SUCCESSFULLY.
results=spider.database.CSpDBProcedureResult
[spider.database.CSpDBResultStatus [SUCCESS(9)],
spider.database.CSpDBResultTable
[rows=1, cols=2, firstRowIndex=0, data(no trim)={|1143|, |0|,
spider.database.CSpDBResultSchema
[], returnValue=||, returnParams=spider.database.CSpDBProcedureParam []]
6036 Jul 20, 1999 at 16:57:55.656 Terse Debug Thread-17 CPService
spider.database.CSpTransaction:c:932513861937:w:932513862140:sendTransactionControl:
Begin-Y Commit-N Rollback-N
6037 Jul 20, 1999 at 16:57:55.718 Terse Debug 307 DSRdbmsService
CNdClientList:c:932513849957:w:932513850234:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
6038 Jul 20, 1999 at 16:57:55.718 Terse Debug 307 DSRdbmsService
CNdConnectionPool:c:932513849957:w:932513850234:Use
existing database connection
databaseType.INFORMIX.databaseName.coin.serverName.ifam.ifam.
6039 Jul 20, 1999 at 16:57:55.718 Terse Debug 307 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234:AutoCommit DISABLED
6040 Jul 20, 1999 at 16:57:55.750 Terse Debug 193 DSRdbmsService
CNdClientList:c:932513849957:w:932513850234:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
6041 Jul 20, 1999 at 16:57:55.750 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234:Common Error Handler:
6042 Jul 20, 1999 at 16:57:55.750 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Error code: 7
6043 Jul 20, 1999 at 16:57:55.750 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Error message [VENDORLIB] Vendor
Library Error: Connection name in use.
6044 Jul 20, 1999 at 16:57:55.765 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Is terminal: No
6045 Jul 20, 1999 at 16:57:55.781 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor error 1: -1802
6046 Jul 20, 1999 at 16:57:55.781 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor error 2: 0
6047 Jul 20, 1999 at 16:57:55.781 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor message 1:
6048 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor message 2:
6049 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234:Common Error Handler:
6050 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Error code: 7
6051 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Error message [VENDORLIB] Vendor
Library Error: Connection does not exist.
6052 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Is terminal: No
6053 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor error 1: -1803
6054 Jul 20, 1999 at 16:57:55.796 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor error 2: 0
6055 Jul 20, 1999 at 16:57:55.812 Warning 193 DSRdbmsService
DSRdbmsService:c:932513849957:w:932513850234: Vendor message 1:
6056 Jul 20, 1999 at 16:57:55.812 Warning 193
5736 Jul 20, 1999 at 16:55:39.953 Terse Debug Thread-17 CPService
spider.session.CSpSession:c:932513861927:w:932513862140:putSessionData:
SessionId=(3,-gu4idtv1vpcd), Session Caching
Control=spider.session.CSpSessionCachingControl
[enabled=Y, prefetchMethod=Specific Objects(^implicitSessionObjectsSet)>,
updateMethod=Modified
Objects]
5737 Jul 20, 1999 at 16:55:39.984 Terse Debug Thread-17 CPService
CSpider:c:932513861927:w:932513862140:connectionEnd:
5738 Jul 20, 1999 at 16:55:40.00 Terse Debug Thread-17 CPService
CSpider:c:932513861927:w:932513862140:releaseProjectUserContext: 'Thread-17'
releasing 'COIN_Web2' (0)
5739 Jul 20, 1999 at 16:55:40.00 Terse Debug Thread-17 CPService
netdyn.services.log.client.CNdLogProxy:c:932513861927:w:932513862140:LogService
resetService operations exceeded
5740 Jul 20, 1999 at 16:55:40.15 Terse Debug Thread-17 CPService
netdyn.cosi.service.loadBalancing.CNdServiceClientList:c:932513861927:w:932513862140:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5741 Jul 20, 1999 at 16:56:07.140 Terse Debug 291 DSRdbmsService
CNdClientList:c:932513849955:w:932513850234:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5742 Jul 20, 1999 at 16:56:07.140 Terse Debug 291 DSRdbmsService
CNdConnectionPool:c:932513849955:w:932513850234:Use
existing database connection
databaseType.INFORMIX.databaseName.coin.serverName.ifam.ifam.
5743 Jul 20, 1999 at 16:56:07.265 Terse Debug 291 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:binding parameter table_name customer as
input at position 0
5744 Jul 20, 1999 at 16:56:07.265 Terse Debug 291 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:binding parameter no_ok_keys 1 as input
at position 1
5745 Jul 20, 1999 at 16:56:07.281 Terse Debug 291 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:fetching result table using MemoryTable
method
5746 Jul 20, 1999 at 16:56:07.437 Terse Debug 291 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:end-of-fetch: bounced into first or last
row during fetch
5747 Jul 20, 1999 at 16:56:07.437 Terse Debug 291 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:parameter 0 output 0
5748 Jul 20, 1999 at 16:56:07.437 Terse Debug 291 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:parameter 1 output 0
5749 Jul 20, 1999 at 16:56:07.562 Terse Debug 223 DSRdbmsService
CNdClientList:c:932513849955:w:932513850234:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5750 Jul 20, 1999 at 16:56:07.562 Terse Debug 223 DSRdbmsService
CNdConnectionPool:c:932513849955:w:932513850234:Use
existing database connection
databaseType.INFORMIX.databaseName.coin.serverName.ifam.ifam.
5751 Jul 20, 1999 at 16:56:07.781 Terse Debug 223 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:execute:
|INSERT INTO arshad.customer ( customer_id, customer_name, distributor,
customer_add_date
) VALUES ( 443, ?, ?, datetime(1999-07-20) year to day )|
5752 Jul 20, 1999 at 16:56:07.890 Terse Debug 223 DSRdbmsService
DSRdbmsService:c:932513849955:w:932513850234:fetching result table using MemoryTable
method
5753 Jul 20, 1999 at 16:56:06.953 Terse Debug Thread-17 CPService
netdyn.cosi.worker.CNdClientList:c:932513861928:w:932513862140:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5754 Jul 20, 1999 at 16:56:06.953 Terse Debug Thread-17 CPService
CSpider:c:932513861928:w:932513862140:connectionStart:
5755 Jul 20, 1999 at 16:56:06.953 Terse Debug Thread-17 CPService
CSpider:c:932513861928:w:932513862140:allocateProjectUserContext: 'Thread-17'
assigned to 'COIN_Web2' (0)
5756 Jul 20, 1999 at 16:56:06.968 Terse Debug Thread-17 CPService
spider.control.CSpWebEventProcessor:c:932513861928:w:932513862140:getUserSessionInformation:
Session=(3,-gu4idtv1vpcd), htmlFrameSetName=null
5757 Jul 20, 1999 at 16:56:06.968 Terse Debug Thread-17 CPService
spider.session.CSpSession:c:932513861928:w:932513862140:refreshSessionData:
SessionId=(3,-gu4idtv1vpcd), Session Caching
Control=spider.session.CSpSessionCachingControl
[enabled=Y, prefetchMethod=Specific Objects(^implicitSessionObjectsSet)>,
updateMethod=Modified
Objects], clearBeforeSetting=true
5758 Jul 20, 1999 at 16:56:07.78 Terse Debug Thread-17 CPService
COIN_Web2.doGetNewPK:c:932513861928:w:932513862140:execute:
'doGetNewPK', request=[EC-[offset=0, count=1, whence=B],
SP=|arshad.get_new_pk|,
inputSchema=[[name=table_name, paramType=1],[name=no_ok_keys, paramType=1]],
procedureParams=spider.database.CSpDBProcedureParam
[|customer|, |1|]]
5759 Jul 20, 1999 at 16:56:07.468 Terse Debug Thread-17 CPService
COIN_Web2.doGetNewPK:c:932513861928:w:932513862140:executeTheRequestAtTheDS:
'doGetNewPK' executed SUCCESSFULLY.
results=spider.database.CSpDBProcedureResult
[spider.database.CSpDBResultStatus [SUCCESS(9)],
spider.database.CSpDBResultTable
[rows=1, cols=2, firstRowIndex=0, data(no trim)={|443|, |0|,
spider.database.CSpDBResultSchema
[], returnValue=||, returnParams=spider.database.CSpDBProcedureParam []]
5760 Jul 20, 1999 at 16:56:07.531 Terse Debug Thread-17 CPService
COIN_Web2.doInsertNewCust:c:932513861928:w:932513862140:execute:
'doInsertNewCust', request=[EC-[offset=0, count=1, whence=B],
tableName=|arshad.customer|,
nameValues=(customer_id=443), (customer_name=TESTND40), (distributor=C),
(customer_add_date=1999-07-20
16:56:07.484)]
5761 Jul 20, 1999 at 16:56:07.937 Terse Debug Thread-17 CPService
COIN_Web2.doInsertNewCust:c:932513861928:w:932513862140:executeTheRequestAtTheDS:
'doInsertNewCust' executed SUCCESSFULLY.
results=spider.database.CSpDBSQLResult [spider.database.CSpDBResultStatus
[SUCCESS(0)], spider.database.CSpDBResultTable [rows=0, cols=0,
firstRowIndex=0,
data(no trim)=, spider.database.CSpDBResultSchema []]
5762 Jul 20, 1999 at 16:56:07.984 Terse Debug Thread-17 CPService
spider.session.CSpSession:c:932513861928:w:932513862140:putSessionData:
SessionId=(3,-gu4idtv1vpcd), Session Caching
Control=spider.session.CSpSessionCachingControl
[enabled=Y, prefetchMethod=Specific Objects(^implicitSessionObjectsSet)>,
updateMethod=Modified
Objects]
5763 Jul 20, 1999 at 16:56:08.00 Terse Debug Thread-17 CPService
CSpider:c:932513861928:w:932513862140:connectionEnd:
5764 Jul 20, 1999 at 16:56:08.00 Terse Debug Thread-17 CPService
CSpider:c:932513861928:w:932513862140:releaseProjectUserContext: 'Thread-17'
releasing 'COIN_Web2' (0)
5765 Jul 20, 1999 at 16:56:08.15 Terse Debug Thread-12 CPService
netdyn.cosi.service.loadBalancing.CNdServiceClientList:c:932513861928:w:932513862140:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5766 Jul 20, 1999 at 16:56:15.718 Terse Debug Thread-12 CPService
netdyn.cosi.worker.CNdClientList:c:932513861929:w:932513862140:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5767 Jul 20, 1999 at 16:56:15.718 Terse Debug Thread-12 CPService
CSpider:c:932513861929:w:932513862140:connectionStart:
5768 Jul 20, 1999 at 16:56:15.718 Terse Debug Thread-12 CPService
CSpider:c:932513861929:w:932513862140:allocateProjectUserContext: 'Thread-12'
assigned to 'COIN_Web2' (0)
5769 Jul 20, 1999 at 16:56:15.718 Terse Debug Thread-12 CPService
spider.control.CSpWebEventProcessor:c:932513861929:w:932513862140:getUserSessionInformation:
Session=(3,-gu4idtv1vpcd), htmlFrameSetName=null
5770 Jul 20, 1999 at 16:56:15.718 Terse Debug Thread-12 CPService
spider.session.CSpSession:c:932513861929:w:932513862140:refreshSessionData:
SessionId=(3,-gu4idtv1vpcd), Session Caching
Control=spider.session.CSpSessionCachingControl
[enabled=Y, prefetchMethod=Specific Objects(^implicitSessionObjectsSet)>,
updateMethod=Modified
Objects], clearBeforeSetting=true
5771 Jul 20, 1999 at 16:56:15.765 Terse Debug Thread-12 CPService
spider.session.CSpSession:c:932513861929:w:932513862140:putSessionData:
SessionId=(3,-gu4idtv1vpcd), Session Caching
Control=spider.session.CSpSessionCachingControl
[enabled=Y, prefetchMethod=Specific Objects(^implicitSessionObjectsSet)>,
updateMethod=Modified
Objects]
5772 Jul 20, 1999 at 16:56:15.781 Terse Debug Thread-12 CPService
CSpider:c:932513861929:w:932513862140:connectionEnd:
5773 Jul 20, 1999 at 16:56:15.781 Terse Debug Thread-12 CPService
CSpider:c:932513861929:w:932513862140:releaseProjectUserContext: 'Thread-12'
releasing 'COIN_Web2' (0)
5774 Jul 20, 1999 at 16:56:15.812 Terse Debug Thread-17 CPService
netdyn.cosi.service.loadBalancing.CNdServiceClientList:c:932513861929:w:932513862140:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5775 Jul 20, 1999 at 16:56:19.156 Terse Debug Thread-17 CPService
netdyn.cosi.worker.CNdClientList:c:932513861930:w:932513862140:clientAuthorized:
incoming client ticket and stored session ticket are valid, proceeding with
comparison
5776 Jul 20, 1999 at 16:56:19.156 Terse Debug Thread-17 CPService
CSpider:c:932513861930:w:932513862140:connectionStart:
5777 Jul 20, 1999 at 16:56:19.156 Terse Debug Thread-17 CPService
CSpide
***************************************************************
NETDYNAMICS LOG FILE ENDS
***************************************************************
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
