EPM 11.2.16 Update Breaks SQL Loads in Essbase 21.5.3, "Bad request for the REST data source. Proceed to the application log file. Error [{ "errorMessage" : "Illegal character ((CTRL-CHAR, code 0)): only regular white space (\\r, \\n, \\t) is allowed" (Doc ID 3019717.1)

Last updated on APRIL 30, 2024

Applies to:

Symptoms

After applying the EPM 11.2.16 update, Essbase SQL loads using a datasource connection fail:

[<DBNAME>] [ERROR:32] [<net>-224] [NET] [<ecid>] [<tid>] [<REQ_ID>] [<DBNAME>] Bad request for the REST data source. Proceed to the application log file. Error [{    "errorMessage" : "Illegal character ((CTRL-CHAR, code 0)): only regular white space (\\r, \\n, \\t) is allowed between tokens"  }]
[<DBNAME>] [ERROR:32] [<net>-224] [NET] [<ecid>] [<tid>] [<REQ_ID>] [<DBNAME>] Bad request for the REST data source. Proceed to the application log file. Error []
[<DBNAME>] [ERROR:32] [<net>-224] [NET] [<ecid>] [<tid>] [<REQ_ID>] [<DBNAME>] Data Load Transaction Aborted With Error [1040224]

The SQL load worked in EPM 11.2.15 which contains the same version of Essbase.

Changes

Applied the EPM 11.2.16 update. 

Cause

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