Symptom
With CMS Database (From BI4.0 SP05 Patch 3
onwards) pointing to HANA (Rev does not matter), Audit will not work.
From CMC >> 'Auditing', it will show "Warning: No connection to
Auditing Data Store from CMS xxx_nn.CentralManagementServer.".
Environment
- SAP BusinessObjects BI Platform 4.0 SP05 Patch 3
- HANA Rev 52
- Linux
Reproducing the Issue
- Use SAP HANA as a audit database in SAP BI 4.0.
- Login to CMC and go to 'Auditing' section.
Cause
CMS errors show
"(AuditDatabaseSubsystem_impl.cpp:160) DBConnectionHolder - (AuditDB) -
Caught retryable error with Code 274, Msg: [SAP AG][LIBODBCHDB SO][HDB]
General error;274 inserted value too large for column: ( SELECT CASE
WHEN 'ALL' <> 'ALL' then ( Table__10."LEVEL_4_NAM Number of
retryable errors on this connection is 1".
In this case Web Intelligence Server was writing an event with a very large detail. For HANA, when the text written to a column is too large instead of truncating it like the other DBMS’s an error is thrown. This is causing the CMS to think there is a problem with the ADS.
In this case Web Intelligence Server was writing an event with a very large detail. For HANA, when the text written to a column is too large instead of truncating it like the other DBMS’s an error is thrown. This is causing the CMS to think there is a problem with the ADS.
The issue has been identified and logged under Problem Report ID : ADAPT01687789
Resolution
The issue is fixed in BI Platform 4.0 Patch5.7 under fix ID: ADAPT01687790
See Also
SAP KBA: 1815203 - Error is received when trying to enable auditing on a HANA Database.
Keywords
Audit, Hana, Linux, ADAPT01687789
No comments:
Post a Comment