This discussion is archived
1 Reply Latest reply: Apr 17, 2013 6:51 PM by Rajesh Gurram - BI RSS

ODBC conncetion issue.

Raj_D Newbie
Currently Being Moderated
Hi,

I am trying to automate my cache clearing from rpd side.

I followed the bellow link.
http://oraclebisolutions.blogspot.co.uk/2012/12/obiee-clear-server-cache-from-direct.html

When I try to run the analysis it run without any error and even clears the cache.

But when I try to schedule the analysis through an agent it keeps giving me the following error.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 16001] ODBC error state: 08004 code: 10018 message: [NQODBC] [SQL_STATE: 08004]
[nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "BIServer"."AnalyticsWeb" Call SAPurgeAllCache()')}


Am I missing something here.

Help please....

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points