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
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.
SAP Knowledge Base Article - Preview