IBM Support

Using multi-valued LDAP attributes as session Parameters results in: QE-DEF-0260 Parsing error

Troubleshooting


Problem

The Proven Practice document "Leveraging multi-valued LDAP attributes as session Parameters" describes the steps necessary to leverage so called multi-valued LDAP attributes as session parameters in Cognos8. The test of the calculation fails when using memberOf as Session Parameter. The test works fine when using the department number.

Symptom

English:

QE-DEF-0260 Parsing error before or near position: 102 of: <distinguishedName>

German:

QE-DEF-0260 Fehler in der Syntaxanalyse vor oder nahe der Stelle: 102 von: <distinguishedName>

Cause

The expression is not correct: #csv(@account.parameters.memberOf)#

Environment

  • IBM Cognos 8 BI MR2 or above
  • LDAP or ADS Namespace with the additional Session Parameter memberOf

Diagnosing The Problem

The file <C8_ROOT>/configuration/CQEconfig.xml has been modified

Resolving The Problem

Since the result of the attribute memberOf is a string you need to use the single quote function (sq) to surround the result of a string expression with single quotation marks.

The correct expression is: #sq(csv(@account.parameters.memberOf))#

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Security","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2;10.1.1;10.1;8.4.1;8.4;8.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9RTN","label":"Cognos 8 Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Framework Manager","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SS9RTN","label":"Cognos 8 Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Security","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3;8.4;8.4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1028031

Document Information

Modified date:
20 March 2020

UID

swg21372300