IBM Support

webMethods Knowlegebase : Error in scheduler page in IS. (1737419)

Troubleshooting


Problem

When accessing the SCHEDULER page of IS Admin, the following error appears:

[sag-cjdbc42-0011][Oracle JDBC Driver]Invalid SQL specified.

This error was found together with other messages:

2012-05-30 16:46:52 CEST [ISS.0137.0017E] Scheduler: Exception getting tasks from database: [sag-cjdbc42-0011][Oracle JDBC Driver]Invalid SQL specified.

2012-05-30 16:46:52 CEST [WmAuditingSC.queue.2010D] Attempting to insert event onto queue 'Error Queue'

2012-05-30 16:46:52 CEST [ISS.0048.9999D] [sag-cjdbc42-0011][Oracle JDBC Driver]Invalid SQL specified.

2012-05-30 16:46:52 CEST [ISU.0000.9999D] InfraDC: Service Error Event null

2012-05-30 16:46:52 CEST [ISU.0000.9999D] InfraDC: ISDCNotificationQueue sending isextdc.logmessage to queue

2012-05-30 16:46:52 CEST [ISC.0072.0005T] service returned: >>>state=running, error=[sag-cjdbc42-0011][Oracle JDBC Driver]Invalid SQL specified.<<<

2012-05-30 16:46:52 CEST [ISC.0072.0018T] IfVarToken.eval name:tasks value:null

2012-05-30 16:46:52 CEST [ISC.0072.0018T] IfVarToken.eval name:error value:[sag-cjdbc42-0011][Oracle JDBC Driver]Invalid SQL specified.

2012-05-30 16:46:52 CEST [ISC.0072.0018T] IfVarToken.eval name:extTasks value:null

2012-05-30 16:46:52 CEST [ISC.0072.0018T] IfVarToken.eval name:error value:[sag-cjdbc42-0011][Oracle JDBC Driver]Invalid SQL specified.

2012-05-30 16:46:52 CEST [ISC.0072.0018T] IfVarToken.eval name:showAll value:null

This is due to the JDBC Pool that for some unknown reasons does not work well anymore.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVYEV","label":"IBM webMethods Integration"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Integration Server (PIE)"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8.2.1"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFIWYE","label":"IBM webMethods B2B"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Integration Server (PIE)"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8.2.1"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQG2X","label":"IBM webMethods Managed File Transfer"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Integration Server (PIE)"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8.2.1"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 March 2025

UID

ibm17218691

Page Feedback