ORAOLEDB Trace File - what does it mean ?

From: Richard Shea <rshea_at_my-deja.com>
Date: 3 Jan 2002 23:39:48 -0800
Message-ID: <43160f6f.0201032339.4836d50_at_posting.google.com>


Hi - I've got an intermittent problem with an ASP script accessing Oracle 8.1.6 via ADO using the ORAOLEDB driver (8.1.6.0).

I turned on the TRACE facility and sure enough when the error ("0x80004005 Unspecified Error") occurs I can see the result of it in the .trc file. However beyond that it's bit of a black hole to me. Below is the bit of the trace between the last 'normal' execute and the point at which ADO has hit some sort of problem. Does anyone know of a web based resource which would allow me to make some sense of what is happening at the point the error appears to occur ? I've annotated the .trc with lines beginning "^^^^" in case any guru fancies giving me an online explanation ! Here goes ...

TID: 7fc ENTRY COracleCommand::Execute(0, 0, 0, c0, 46000000) TID: 7fc EXIT COracleCommand::Execute(SQL Stmt => SELECT UNIQUE(ASR_REA_ID),REA_DESCRIPTION FROM VW_OUM_ASR_WITH_REA_DETAILS

WHERE (OUM_GRV_ID = 7)): 1912

^^^^^ execute of SQL string, everything is as normal, the next 30 odd
lines are also perfectly normal, presumably resulting from the ASP accessing the resulting recordset ?
TID: 7fc EXIT COracleCommand::Execute(hr=0): 1946 TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(2, 20ae71c, 20ae798, 20ae79c)
TID: 7fc EXIT  IRowsetInfoImpl::GetProperties(hr=40eda): 6318
TID: 7fc ENTRY IRowsetOracleImpl::RestartPosition(0)
TID: 7fc EXIT  RestartPosition(hr=0): 1857
TID: 7fc ENTRY IRowsetOracleImpl::GetNextRows(0, 0, 1, 20ae9d8,
20ae9d4)
TID: 7fc EXIT GetNextRows(hr=0): 1679
TID: 7fc ENTRY IColumnsInfoOracleImpl::GetColumnInfo(2442650, 2442654, 2442658)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20ae944, 20ae930, 20ae924)
TID: 7fc EXIT  IRowsetInfoImpl::GetProperties(hr=0): 6318
TID: 7fc EXIT  IColumnsInfoOracleImpl::GetColumnInfo(hr=0): 175
TID: 7fc ENTRY IColumnsInfoOracleImpl::GetColumnInfo(2449f10, 2449f0c,
20aec24)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20aeba4, 20aeb90, 20aeb84)
TID: 7fc EXIT  IRowsetInfoImpl::GetProperties(hr=0): 6318
TID: 7fc EXIT  IColumnsInfoOracleImpl::GetColumnInfo(hr=0): 175
TID: 7fc ENTRY IConvertTypeOracleImpl::CanConvert(131, 14, 0)
TID: 7fc EXIT  IConvertTypeOracleImpl::CanConvert(hr=0): 117
TID: 7fc ENTRY IAccessorOracleImpl::CreateAccessor(2, 1, 244b830, 0,
244a96c, 20aece8)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20aeb84, 20aeb70, 20aeb64)
TID: 7fc EXIT  IRowsetInfoImpl::GetProperties(hr=0): 6318
TID: 7fc EXIT  CreateAccessor(hr=0): 626
TID: 7fc ENTRY IRowsetOracleImpl::GetData(1, 40dfa8, 244bcf0)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20aec5c, 20aec48,
20aec3c)
TID: 7fc EXIT  IRowsetInfoImpl::GetProperties(hr=0): 6318
TID: 7fc EXIT  GetData(hr=0): 1151
TID: 7fc ENTRY IConvertTypeOracleImpl::CanConvert(129, 8, 0)
TID: 7fc EXIT  IConvertTypeOracleImpl::CanConvert(hr=0): 117
TID: 7fc ENTRY IAccessorOracleImpl::CreateAccessor(2, 1, 244b830, 0,
2451dcc, 20aece8)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20aeb84, 20aeb70, 20aeb64)
TID: 7fc EXIT  IRowsetInfoImpl::GetProperties(hr=0): 6318
TID: 7fc EXIT  CreateAccessor(hr=0): 626
TID: 7fc ENTRY IRowsetOracleImpl::GetData(1, 23ce6b8, 244df88)
TID: 7fc EXIT  GetData(hr=0): 1151
TID: 7fc ENTRY IRowsetOracleImpl::GetNextRows(0, 0, 1, 20aea1c,
20aea18)
TID: 7fc EXIT  GetNextRows(hr=40ec6): 1401
TID: 7fc ENTRY IRowsetOracleImpl::ReleaseRows(1, 24491a0, 0, 0, 0)
TID: 7fc EXIT  ReleaseRows(hr=0): 1790
TID: 7fc ENTRY IAccessorOracleImpl::ReleaseAccessor(23ce6b8, 0)
TID: 7fc EXIT  ReleaseAccessor(hr=0): 725
TID: 7fc ENTRY IAccessorOracleImpl::ReleaseAccessor(40dfa8, 0)
TID: 7fc EXIT  ReleaseAccessor(hr=0): 725

^^^^^up until here everything is normal but after that we're either
responding to an error which has occurred above or doing something (which doesn't occur on other passes through this code) which causes an error.
TID: 7ac ENTRY COracleSource::GetProperties(1, 0x1fef0e4, 0x1fef100,
0x1fef108)

^^^^^whatever it is that's doing it has a different thread ?
TID: 7ac EXIT COracleSource::GetProperties(hr=0): 4061 TID: 7ac ENTRY IDBCreateCommandOracleImpl::CreateCommand(0, 208878179, 11ce2a1c)
TID: 7ac EXIT  IDBCreateCommandOracleImpl::CreateCommand(hr=0): 528
TID: 7ac ENTRY COracleCommand::SetProperties(1, 1feed38)
TID: 7ac EXIT  COracleCommand::SetProperties(hr=0): 2736
TID: 7ac ENTRY COracleCommand::SetProperties(1, 1feee24)
TID: 7ac EXIT  COracleCommand::SetProperties(hr=0): 2736
TID: 7ac ENTRY COracleSource::GetProperties(1, 0x1feed5c, 0x1feed8c,
0x1feed78)
TID: 7ac EXIT  COracleSource::GetProperties(hr=0): 4061
TID: 7ac ENTRY COracleCommand::SetProperties(1, 2441808)
TID: 7ac EXIT  COracleCommand::SetProperties(hr=40eda): 2736
TID: 7ac ENTRY COracleCommand::SetCommandText(c8b521fb, 11ce5cf3)
TID: 7ac EXIT  COracleCommand::SetCommandText(hr=80004005): 2414

^^^^^^this stuff might be all quite legitatmate but as I said above it
doesn't alway get exec'd - anyone care to tell me what it's doing [in broad terms ;-)]
TID: 7ac ENTRY CErrorLookup::GetHelpInfo(80004005, 1, 1409, 244b854,
244b860)

^^^^^^after here things are obviously looking bad and in fact on the
next line we can see the infamous 80004005 being got read to wheel onto centre stage
TID: 7ac EXIT CErrorLookup::GetHelpInfo(hr=0): 167 TID: 7ac ENTRY CErrorLookup::GetErrorDescription(80004005, 1, 244d6f8, 1409, 244b850, 244b84c)
TID: 7ac EXIT CErrorLookup::GetErrorDescription(hr=0): TID: 818 GTXN COracleSession::FinalRelease() - Session (23cda94) released
TID: 818 ENTRY COracleSource::Uninitialize()
TID: 818 EXIT  COracleSource::Uninitialize(hr=0): 275
TID: 818 GTXN  COracleSession::FinalRelease() - Session (23e6a8c)
released
TID: 818 ENTRY COracleSource::Uninitialize() TID: 818 EXIT COracleSource::Uninitialize(hr=0): 275

... that's all folks ! As I say if anyone can point me at a resource for translating this stuff or fancies offering their own translation I'd be very grateful.

regards

richard shea.
richardshea_at_fastNOSPAMmail.fm Received on Fri Jan 04 2002 - 08:39:48 CET

Original text of this message