IBM Support

webMethods Knowlegebase : PE Storage Cleaner Throwing Exception - 'Storage cleaner: executing embedded SQL'.
(1752600)

Troubleshooting


Problem

Issue:

The user reported facing issue in some of their environments.

The PE Storage Cleaner task is throwing the following exception every 10 minutes.

[199]2014-02-10 08:09:20 EST [BPM.0101.0512E] Storage exception: [SoftwareAG][SQLServer JDBC Driver][SQLServer]An expression of non-boolean type specified in a context where a condition is expected, near ','.

[198]2014-02-10 08:09:20 EST [BPM.0101.0002E] Exception: java.sql.SQLException

[197]2014-02-10 08:09:20 EST [BPM.0101.0515D] Storage cleaner: executing embedded SQL

[196]2014-02-10 07:59:20 EST [BPM.0101.0517D] Storage cleaner: Duration 50 ms

Notes:

- The user is in the correct latest version of DB component and the JDBC URL connection pool is correctly configured.

- We tested the JDBC Pool Connection and it worked without issue.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAWP1J","label":"IBM webMethods BPM"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Process Engine (WPE)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Windows Server 2008"}],"Version":"9.0.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 Process Engine (WPE)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Windows Server 2008"}],"Version":"9.0.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

ibm17198828

Page Feedback