BIP model editor error when bilingual column is used.
Hi All,
Customer is trying to develop a report to in BI 11.1.1.6. Data source is BI Analytics (rpd) file
In the BIP model editor, If the SQL used in the column has multi language data, will give an error.
"java.io.IOException:prepare query failed {nQSError:43113} Message returned from OBIS
{nQSError: 43119} Query failed: {nQSError: 23006} The seesion variable
NQ_SESSION.LAN_INT, has no value definition. {nQSError:14072} The fist argument to IndexCol,
VALUEOF(NQ_SESSION.LAN_INT), cannot be evaluated "
If the single column has no bilingual language then there is no issue.
Please assist.
Cheers,
Vish
Customer is trying to develop a report to in BI 11.1.1.6. Data source is BI Analytics (rpd) file
In the BIP model editor, If the SQL used in the column has multi language data, will give an error.
"java.io.IOException:prepare query failed {nQSError:43113} Message returned from OBIS
{nQSError: 43119} Query failed: {nQSError: 23006} The seesion variable
NQ_SESSION.LAN_INT, has no value definition. {nQSError:14072} The fist argument to IndexCol,
VALUEOF(NQ_SESSION.LAN_INT), cannot be evaluated "
If the single column has no bilingual language then there is no issue.
Please assist.
Cheers,
Vish
0