SAP Knowledge Base Article - Preview

3485467 - Not able to export HANA database audit log as CSV in HANA COCKPIT 2.0

Symptom

You can't export HANA database audit log as CSV from HANA COCKPIT , when you try to click on the Save as CSV tile it is throwing not reachable error .

The error message as below: 

This site can't be reached
The webpage at https://<hana_cockpit_host>/hdbui/security/audit/audittrail/HANA.zip?resid=XXX&name=XXXX&until=XXXXXT00%3A00%3A00 be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

From the cockpit-hdb-svc.log you can see the below error message: 

#ERROR#com.sap.hana.cockpit.hdb.api.security.audit.AuditPolicyService#
                                        ###B0A70B4BF3804E0297E276DD3125852A##cockpit-hdb-svc#sun.reflect.GeneratedMethodAccessor50########http-nio-127.0.0.1-40315-exec-8#PLAIN##
                                        During downloading an audit log
                                        com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [260] (at 76): invalid column name: AUDIT_POLICY_NAME1: line 1 col 77 (at pos 76)
                                            at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:195)
                                            at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:45)
                                            at com.sap.db.jdbc.packet.HReplyPacket._buildExceptionChain(HReplyPacket.java:837)

 


Read more...

Environment

  • SAP HANA Cockpit 2.0 SPS14 Patch 09 and below version.

Product

SAP HANA, platform edition 2.0

Keywords

/hdbui/security/audit/audittrail/HANA.zip,cockpit-web-app,network,ERR_INVALID_RESPONSE  , KBA , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.