Hi,

We have recently upgraded from Siebel Analytics 771 to OBIEE 10g to OBIEE 11.1.1.7

After upgrade, we noticed that the columns where TimestampAdd function is used in the logical level started giving error as below :

] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22025] Function TimestampAdd is called with an incompatible type.Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: {call NQSGetQueryColumnInfo('SELECT "XX Facts"."YYY" FROM "ABC"')}

The column formula is as follows :

TIMESTAMPADD( SQL_TSI_MINUTE ,  VALUEOF(NQ_SESSION."O1"), "Data Warehouse"."Catalog"."dbo"."XX Facts"."X_TIMESTAMP_YY")

==> X_TIMESTAMP_YY is set as DATETIME at physical layer.

==> O1 is set to -300 in the variables

On further debugging, we found that the issue does not occur when we login to analytics using the weblogic user. The  other users are LDAP authenticated and when we login using anyother user, this issue is occurring.

Same error is logged in the session logs when we try to access the XX Facts >> YYY column from the ABC subject area from Answers.

I am not understanding why the behavior is different for different users. Can anybody help in this ?

Thanks