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>
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))#
Related Information
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Framework Manager","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Security","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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
Was this topic helpful?
Document Information
Modified date:
28 November 2022
UID
swg21372300