webMethods Knowlegebase : Display of invalid identifier error message when Log Invocation destination is set to Audit Log (1807123)

Problem

When configuring JDBC pools and the Log Invocation destination (Policies > Traffic Monitoring > Log Invocation) is set to Audit Log, API Gateway displays an invalid identifier error message as below when data gets inserted into database table 'AGW_EVENT_TXN'.

-----

[WmAuditingSC.destination.1122E] Destination 'apigatewayTxnJdbc' caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: "ERRORORIGIN": invalid identifier

[WmAuditingSC.queue.2406E] AuditQueueWorker for queue 'APIGatewayTransactionQueue' failed to log event to destination 'apigatewayTxnJdbc'; reason '[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: "ERRORORIGIN": invalid identifier

'; stack trace follows

com.webmethods.sc.auditing.api.destination.WmFatalDestinationException: Fatal SQLException detected

at com.webmethods.sc.auditing.destination.WmDatabaseDestination.sqlToAuditingException(WmDatabaseDestination.java:1293)

at com.webmethods.sc.auditing.destination.WmDatabaseDestination.handleLoggingException(WmDatabaseDestination.java:793)

at com.webmethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:701)

at com.webmethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:184)

at com.webmethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:88)

Caused by: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00904: "ERRORORIGIN": invalid identifier

at com.wm.dd.jdbcspyoracle.SpyLogger.sqlException(Unknown Source)

at com.wm.dd.jdbcspyoracle.SpyStatement.executeBatch(Unknown Source)

at com.webmethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:693)

... 2 more

-----