IBM Support

CRX-API-0018 More than 3000 tokens. The report expression is too complex.

Troubleshooting


Problem

Cannot run report. The following error appears: The expression is too complex. It has more than 3000 tokens. Error code CRX-API-0018.

Symptom

Attempting to run report results in an error.

Resolving The Problem

Modify the crxConfig.xml file found in the <install_dir>\configuration folder. This file is set to read only.

1) In the properties of the file, remove the Read-Only attribute.

2) Open the file in a text editor and increase the <CRX_MAX_TOKEN_LIMIT> value from the default 3000.

If the cognos environment is multi server environment then this setting must be updated on all servers.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m0z000000CbsBAAS","label":"Reporting->Report Authoring"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Type":"MASTER"}]

Document Information

Modified date:
19 August 2021

UID

swg21423174