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>
TID: 7fc EXIT COracleCommand::Execute(hr=0): 1946 TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(2, 20ae71c, 20ae798, 20ae79c)
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 ENTRY IRowsetInfoImpl::GetProperties(1, 20aeba4, 20aeb90, 20aeb84)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20aeb84, 20aeb70, 20aeb64)
TID: 7fc ENTRY IRowsetInfoImpl::GetProperties(1, 20aeb84, 20aeb70, 20aeb64)
TID: 7ac ENTRY COracleSource::GetProperties(1, 0x1fef0e4, 0x1fef100,
TID: 7ac ENTRY CErrorLookup::GetHelpInfo(80004005, 1, 1409, 244b854,
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
Date: 3 Jan 2002 23:39:48 -0800
Message-ID: <43160f6f.0201032339.4836d50_at_posting.google.com>
WHERE (OUM_GRV_ID = 7)): 1912lines are also perfectly normal, presumably resulting from the ASP accessing the resulting recordset ?
^^^^^ execute of SQL string, everything is as normal, the next 30 odd
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): 725responding to an error which has occurred above or doing something (which doesn't occur on other passes through this code) which causes an error.
^^^^^up until here everything is normal but after that we're either
TID: 7ac ENTRY COracleSource::GetProperties(1, 0x1fef0e4, 0x1fef100,
0x1fef108)TID: 7ac EXIT COracleSource::GetProperties(hr=0): 4061 TID: 7ac ENTRY IDBCreateCommandOracleImpl::CreateCommand(0, 208878179, 11ce2a1c)
^^^^^whatever it is that's doing it has a different thread ?
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): 2414doesn't alway get exec'd - anyone care to tell me what it's doing [in broad terms ;-)]
^^^^^^this stuff might be all quite legitatmate but as I said above it
TID: 7ac ENTRY CErrorLookup::GetHelpInfo(80004005, 1, 1409, 244b854,
244b860)next line we can see the infamous 80004005 being got read to wheel onto centre stage
^^^^^^after here things are obviously looking bad and in fact on the
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