2181660 - Audit data for WebIntelligence no longer written to SQL Server database

• Auditing events are not inserted into the SQL Server database
• The <boinstall>/SAP BusinessObjects Enterprise XI 4.0/Auditing folder grows in size
• Error message in the Central Management Server logs (High tracing level required) - will not appear in default logs:

.\AuditDatabaseSubsystem_impl.cpp:169) DBConnectionHolder - (AuditDB) - Caught retryable error with Code 7139, Msg: [Microsoft][SQL Server Native Client 10.0][SQL Server]Length of LOB data (<number>) to be replicated exceeds configured maximum 65536.  Number of retryable errors on this connection is 1

 

OR

 

(..\ODBCDatabase.cpp:158) ODBC error found:  ErrorMessage([Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed.), ErrorCode(0)
AuditDatabaseSubsystem::InsertAuditEntry(): CDatabase::Error exception caught
(.\AuditDatabaseSubsystem_impl.cpp:169) DBConnectionHolder - (AuditDB) - Caught retryable error with Code 0, Msg: [Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed.  Number of retryable errors on this connection is 1
(.\auditsubsystem_impl.cpp:4055) Auditor::PullAuditEvents - retryable error occurred

Read more...

• SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.0, BI 4.1, BI 4.2)
• Microsoft SQL Server

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

max, text, replication, varchar(max), Max Text Replication Size, maximum 65536, exceeds configured maximum, audit, no longer, writing, not written, not write, no write , KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , Problem