Essbase Error: Single Sign On Authentication Failed With Error
Hi
Issue is i am getting an error when i try to generate a report in BI Answers where my datasource is Essbase cube.
Error is :Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Essbase Error: Single Sign On Authentication Failed With Error [Failed to authenticate user sartha against provider ADENT] (HY000)
SQL Issued: SELECT PD_Band."Gen3,PD_Band" saw_0, bas_reg.PDWgt*100 saw_1, bas_reg.Obligors saw_2, bas_reg.EBal saw_3, case when bas_reg.Undrn_Amt<0 then 0 else bas_reg.Undrn_Amt end saw_4, bas_reg.EAD saw_5, bas_reg.Eff_Maturity saw_6, ' ' saw_7, bas_reg.LGD*100 saw_8, bas_reg.PD_LGD_Adj_Effect saw_9, ' ' saw_10, bas_reg.RWA saw_11, bas_reg.ECLoss saw_12, AGGREGATE(saw_1 BY ), AGGREGATE(saw_2 BY ), AGGREGATE(saw_3 BY ), AGGREGATE(saw_4 BY ), AGGREGATE(saw_5 BY ), AGGREGATE(saw_6 BY ), AGGREGATE(saw_8 BY ), AGGREGATE(saw_9 BY ), AGGREGATE(saw_11 BY ), AGGREGATE(saw_12 BY ) FROM "bas_reg#1" WHERE (DepInst."Gen2,DepInst" = 'DI_CWFN - Wells Fargo and Company Cons') AND (Product."Gen2,Product" = 'B2_SGRP_IPRE - Wholesale IPRE') AND (Time."Gen3,Time" = '2009 Qtr3') ORDER BY saw_0, saw_7, saw_10
I checked the Query log and system it says 'Essbase Error: Single Sign On Authentication Failed With Error [Failed to authenticate user sartha against provider ADENT]'
I changed the userid and password but no change.Still same above error. Please let me know what might the reason behind this error