1 Reply Latest reply: Apr 17, 2013 8:51 PM by Rajesh Gurram - BI RSS

    ODBC conncetion issue.


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

      I followed the bellow link.

      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....