Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

There was a transaction active when exiting the stored procedure 'sp_tables'

564 views
Skip to first unread message

Darcy

unread,
Aug 18, 2004, 8:32:55 AM8/18/04
to
server:8.0.2 4411, client:8.0.2 4308

Error Message:
I. 08/18 20:17:40. <thread 1.10>: Synchronization request from: B00212
(version: v0401)
E. 08/18 20:17:40. <1.10> [B00212]: Error: ODBC: [MERANT][ODBC Sybase Wire
Protocol driver][SQL Server]There was a transaction active when exiting the
stored procedure 'sp_tables'. The temporary table '#cumulative_role_set' was
dropped in this transaction either explicitly or implicitly. This
transaction has been aborted to prevent database corruption.
(ODBC State = HY000, Native error code = 277)
E. 08/18 20:17:40. <1.10> [B00212]: Error: ODBC: [MERANT][ODBC Sybase Wire
Protocol driver][SQL Server]Transaction count after EXECUTE indicates that a
COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0.
(ODBC State = HY000, Native error code = 266)
I. 08/18 20:17:41. <1.10> [B00212]: Synchronization complete

I don't know what happened, and who can tell me the reason caused this
error,thanks.


Graham Hurst

unread,
Aug 19, 2004, 1:57:08 PM8/19/04
to
According to the site below you need to update the Sybase System Catalog
Stored Procedures:
http://knowledgebase2.datadirect.com/kbase.nsf/26536a530e20a22b85256e550079afc2/ba0de69cd2216aa085256d39005403e9?OpenDocument
(aliased as http://tinyurl.com/5zhks for your convenience)

Sorry in advance that I don't know where to get those.

Cheers,

Graham

0 new messages