1 Reply Latest reply on Apr 1, 2008 10:59 PM by 631644

    Essbase and SQL Server Connection Issue

    631059
      I am using Load Rules with a direct connect to SQL Server. When I am designing the rule the SQL connection works fine and I can see the sample data from the SQL table within the Rules file however when I try to run the Outline update I get the following error messages within Admin Services and the Log File (see below). Has anyone seen this error? Anyone have ideas as to the resolution?

      Thanks!
      --------------
      ERROR MESSAGE:

      Object [XXX] is locked by user [XXX]
      Connection String for [XXX] is generated
      SELECT Statement [SELECT * FROM D_Product] is generated
      ODBC Layer Error: [08001] ==> [[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.]
      ODBC Layer Error: Native Error code [17]
      Failed to Establish Connection With SQL Database Server. See log file for more information

      ---------------
      SERVER LOG:

      [Fri Mar 28 13:04:10 2008]Local/XX/XX/XX/Info(1021003)
      Connection String for [XX] is generated
      [Fri Mar 28 13:04:10 2008]Local/XX/XX/XX/Info(1021006)
      SELECT Statement [SELECT * FROM D_Product] is generated
      [Fri Mar 28 13:04:27 2008]Local/XX/XX/XX/Info(1021013)
      ODBC Layer Error: [08001] ==> [[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.]
      [Fri Mar 28 13:04:27 2008]Local/XX/XX/XX/Info(1021014)
      ODBC Layer Error: Native Error code [17]
      [Fri Mar 28 13:04:27 2008]Local/XX/XX/XX/Error(1021001)
      Failed to Establish Connection With SQL Database Server. See log file for more information
      [Fri Mar 28 13:04:27 2008]Local/XX/XX/XX/Error(1090013)
      Cannot Open Data Source