Refer KB Articles below, this should help to solve problems
URLS:
https://empower.softwareag.com/sl24sec/SecuredServices/KCFullTextASP/viewing/view.asp?KEY=099532-17020522&DSN=PIVOTAL&DST=TCD&HL=1&QUERY=WmAuditingSC.logger.3405E&SessionID=980304787
https://empower.softwareag.com/sl24sec/SecuredServices/KCFullTextASP/viewing/view.asp?KEY=100081-14215357&DSN=PIVOTAL&DST=TCD&HL=1&QUERY=WmAuditingSC.destination.1122E&SessionID=980304787
https://empower.softwareag.com/sl24sec/SecuredServices/KCFullTextASP/viewing/view.asp?KEY=098040-3224853&DSN=PIVOTAL&DST=TCD&HL=1&QUERY=WmAuditingSC.destination.1105E&SessionID=980304787
Details Below
======================================================
webMethods Integration Server - [WmAuditingSC.destination.1105E] Destination ‘SessionDBDest’ caught unexpected SQLException inserting value for field ‘com.wm.app.b2b.server.audit.type.SessionIdFieldType’ into PreparedStatement
KB #: 1744038 Operating System Family: ALL
Product: webMethods Integration Server (PIE) Operating System: All
Version:
Last Updated: 13-MAY-2013
Description:
The DB itself seems to work well. User can test all the JDBC-Connections in the Integration Server Admin Page, but find the above error in the server log.
Resolution:
Please make sure if you are not ignoring any jvm parameters while startup especially:
-Dcom.webMethods.sc.auditing.Use80TableFormat=true
=================================================================
webMethods Integration Server - WmAuditingSC errors in server.log
KB #: 1746057 Operating System Family: PC
Product: webMethods Integration Server (PIE) Operating System: Windows Server 2008
Version: 9.0.1
Last Updated: 08-AUG-2013
Description:
The following errors appeared in server.log. But the IS Core Audit has been configured successfully during installation, the configured JDBC Pools in IS Admin Console are working and ISCoreAudit and ISInternal database scripts have executed successfully using Database Component Configurator.
2013-07-11 16:10:48 WST [WmAuditingSC.destination.1105E] Destination ‘CoreAuditDBDest’ caught unexpected SQLException inserting value for field ‘com.wm.app.b2b.server.audit.type.TxErrorMessageFieldType’ into PreparedStatement: [SoftwareAG][Oracle JDBC Driver]Invalid parameter binding(s).
2013-07-11 16:10:48 WST [WmAuditingSC.destination.1122E] Destination ‘CoreAuditDBDest’ caught unexpected Throwable logging audit event: Destination ‘CoreAuditDBDest’ caught unexpected SQLException inserting value for field ‘com.wm.app.b2b.server.audit.type.TxErrorMessageFieldType’ into PreparedStatement: [SoftwareAG][Oracle JDBC Driver]Invalid parameter binding(s).
2013-07-11 16:10:48 WST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘Guaranteed Delivery Outbound Queue’ failed to log event to destination ‘CoreAuditDBDest’; reason ‘[SoftwareAG][Oracle JDBC Driver]Invalid parameter binding(s).’; stack trace follows
2013-07-11 16:10:48 WST [WmAuditingSC.queue.2416I] In queue ‘Guaranteed Delivery Outbound Queue’ worker, the preceding error is non-recoverable; failing-over
2013-07-11 16:10:48 WST [WmAuditingSC.queue.2098E] The following record could not be written to the Failed Audit Log: WMTXOUT 6423c970-ea01-11e2-a426-ffef682a0b4d
Resolution:
The root cause is starting up IS from \profiles\IS\bin.
If IS is started up with startup.bat in \IntegrationServer\bin, audit function works fine.
It is not supported to start up IS from \profiles\IS\bin and also modify the configuration files there.
Correct way to start up IS is always from \IntegrationServer\bin.
This is same for ver.8.2 as well.
The scripts under \IntegrationServer\bin handles some initialization required for Integration Server unlike the ones from \profiles\IS\bin.
webMethods Process Engine - Cannot insert the value NULL into column ‘EXTERNALID’
KB #: 1745590 Operating System Family: PC
Product: webMethods Process Engine (WPE) Operating System: Windows Server 2008
Version: 8.2.2
Last Updated: 28-JUN-2013
Description:
Seeing in IS server.log the following errors:
[PRT.0101.0196I] started Process [PID=839ce320-cb77-11e2-bcfe-c7ddad827daf:1, MID=XX/YY, MVer=1]
[WmAuditingSC.destination.1122E] Destination ‘ProcessAuditDBDest’ caught unexpected Throwable logging audit event: [sag-cjdbc42-0011][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column ‘EXTERNALID’, table ‘wm82GA.dbo.WMPROCESSASSOC’; column does not allow nulls. INSERT fails.
[WmAuditingSC.logger.3405E] In logger ‘Process Logger’, failed to log to destination; reason: Fatal SQLException detected
[PRT.0101.0002E] ERROR: com.wm.app.prt.ProcessException
?
[WmAuditingSC.destination.1122E] Destination ‘ProcessAuditDBDest’ caught unexpected Throwable logging audit event: [sag-cjdbc42-0011][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column ‘EXTERNALID’, table ‘wm82GA.dbo.WMPROCESSASSOC’; column does not allow nulls. INSERT fails.
[WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ProcessAuditQueue’ failed to log event to destination ‘ProcessAuditDBDest’; reason ‘[sag-cjdbc42-0011][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column ‘EXTERNALID’, table ‘wm82GA.dbo.WMPROCESSASSOC’; column does not allow nulls. INSERT fails.’; stack trace follows
[WmAuditingSC.queue.2416I] In queue ‘ProcessAuditQueue’ worker, the preceding error is non-recoverable; failing-over
[WmAuditingSC.destination.1206E] Destination ‘FailedAuditLog’ detects null value for required field type ‘com.wm.app.prt.audit.schema.ExternalIdFieldType’
[WmAuditingSC.destination.1206E] Destination ‘FailedAuditLog’ detects null value for required field type ‘com.wm.app.prt.audit.schema.ExternalIdFieldType’
[WmAuditingSC.queue.2098E] The following record could not be written to the Failed Audit Log: WMPROCESSASSOC 839ce320-cb77-11e2-bcfe-c7ddad827daf ?.
Resolution:
An invocation to logCustomId with a null value for the EXTERNALID will result in this exception from the Audit Logging Subsystem.
In this case , customer used the pub.prt.logCustomId in one of their Process?s steps ,and this cause the Exception as 'EXTERNALID? column in WMPROCESSASSOC DB table is not allowed to be null.