Hello Everyone,
I have a problem in my production environment, version 12.2.5.9.0
My dashboard in the production environment are normaly working well , but randomly it doest work and all the dashboards generates errors like this one (see the message below) and i cant even see the domains when i create an analysis , but 15 min later or few minutes later the dashboards work without any intervention.
The support asked for the log file and said that there is no problem in the platform.
Can someone help me with this problem ?
Error generating view. Error getting cursor in GenerateHead
Error Details
Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 27002. [nQSError: 27002] Near <)>: Syntax error (HY000)
State: HY000. Code: 26012. [nQSError: 26012] . (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT FILTER("Indicateurs"."CA HT"USING (("Date de création"."Date" >= (2023-01-01)) AND ("Date de création"."Date2" <= ()))) + FILTER("Indicateurs"."Nbr Importateur P9" * 500 USING (("Date de création"."Date" >= (2023-01-01)) AND ("Date de création"."Date2" <= ()))) FROM "Tarification"', 'PRECISION_SCALE')}
SQL Issued: SELECT FILTER("Indicateurs"."CA HT"USING (("Date de création"."Date" >= (2023-01-01)) AND ("Date de création"."Date2" <= ()))) + FILTER("Indicateurs"."Nbr Importateur P9" * 500 USING (("Date de création"."Date" >= (2023-01-01)) AND ("Date de création"."Date2" <= ()))) FROM "Tarification"