BMQL Lexical Error Occurs with Certain WHERE Queries (Doc ID 2665502.1)

Last updated on JULY 31, 2020

Applies to:

Symptoms

The following error is present when opening quotes:

Error 500
Internal Server Error

The following error is present in the bm.log/debugger(If the culprit action/library function is found):

[ERROR] com.bm.xchange.services.bulkservices.BulkDownloadService.invokeMethod(BulkDownloadService.java:1529) - Error running bulk download task.
com.bm.xchange.services.scripts.bmjscript.sql.parser.impl.TokenMgrError: Lexical error at line 1, column ##. Encountered: "@" (64), after : ""

[ERROR] com.bm.xchange.services.bulkservices.BulkDownloadService.getXmlBody(BulkDownloadService.java:2102) - Could not download CmBsData with id ********* (possible orphan).
Could not retrieve value of 'data_xml' field for CmBsData with id ***********

Changes

•  New BML function has been written
•  BMQL has been added to an already existing BML function
•  New Data Table entries have been made

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.