4 Replies Latest reply on Nov 22, 2014 4:32 AM by 2673365

    FDMEE Export error - Failed to establish connection

    2673365

      Hello, I am trying to load a simple text file into Planning/Essbase using FDMEE, from logs, it seems that It could establish the connection from Essbase (rule file) to Oracle db.

      Not sure what I am missing here....

       

      EPM 11.1.2.3

      Oracle 11g

      Here is the error from the logfile:

       

      2014-11-20 11:48:47,474 INFO  [AIF]: FDMEE Process Start, Process ID: 32
      2014-11-20 11:48:47,474 INFO  [AIF]: FDMEE Logging Level: 4
      2014-11-20 11:48:47,474 INFO  [AIF]: FDMEE Log File: D:\FDMEEAPP\outbox\logs\Vision_32.log
      2014-11-20 11:48:47,474 INFO  [AIF]: User:admin
      2014-11-20 11:48:47,474 INFO  [AIF]: Location:zLoc (Partitionkey:4)
      2014-11-20 11:48:47,474 INFO  [AIF]: Period Name:May14 (Period Key:5/1/14 12:00 AM)
      2014-11-20 11:48:47,474 INFO  [AIF]: Category Name:Actual (Category key:1)
      2014-11-20 11:48:47,474 INFO  [AIF]: Rule Name:zLoad (Rule ID:2)
      2014-11-20 11:48:49,360 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)
      [Oracle JRockit(R) (Oracle Corporation)]
      2014-11-20 11:48:49,360 INFO  [AIF]: Java Platform: java1.6.0_37
      2014-11-20 11:48:49,360 INFO  [AIF]: Log File Encoding: UTF-8
      2014-11-20 11:48:52,046 INFO  [AIF]: -------START IMPORT STEP-------
      2014-11-20 11:48:52,188 INFO  [AIF]: -------END IMPORT STEP-------
      2014-11-20 11:48:52,249 INFO  [AIF]: -------START EXPORT STEP-------
      2014-11-20 11:48:52,499 INFO  [AIF]: File Name: dummy.txt
      2014-11-20 11:48:52,513 INFO  [AIF]:
      Move Data for Period 'May14'
      2014-11-20 11:48:53,212 INFO  [AIF]: [HPLService] Info: Cube Name: Plan1
      2014-11-20 11:48:53,212 INFO  [AIF]: [HPLService] Info: Export Mode: ADD_DATA
      2014-11-20 11:48:53,212 INFO  [AIF]: Connecting to essbase using service user:admin
      2014-11-20 11:48:53,445 INFO  [AIF]: Obtained connection to essbase provider:Embedded
      2014-11-20 11:48:53,447 INFO  [AIF]: Obtained connection to essbase cube Plan1
      2014-11-20 11:48:53,464 INFO  [AIF]: Locking rules file AIF0002
      2014-11-20 11:48:53,467 INFO  [AIF]: Successfully locked rules file AIF0002
      2014-11-20 11:48:53,467 INFO  [AIF]: Copying rules file AIF0002 for data load as AIF0002
      2014-11-20 11:48:53,488 INFO  [AIF]: Unlocking rules file AIF0002
      2014-11-20 11:48:53,489 INFO  [AIF]: Successfully unlocked rules file AIF0002
      2014-11-20 11:48:53,490 INFO  [AIF]: The data rules file has been created successfully.
      2014-11-20 11:48:53,495 INFO  [AIF]: Locking rules file AIF0002
      2014-11-20 11:48:53,498 INFO  [AIF]: Successfully locked rules file AIF0002
      2014-11-20 11:48:53,503 INFO  [AIF]: Load data into the cube by launching rules file...
      2014-11-20 11:48:53,503 INFO  [AIF]: Loading data into cube using sql...
      2014-11-20 11:48:53,508 INFO  [AIF]: Unlocking rules file AIF0002
      2014-11-20 11:48:53,510 INFO  [AIF]: Successfully unlocked rules file AIF0002
      2014-11-20 11:48:53,510 INFO  [AIF]: [HPLService] Info: Error: com.essbase.api.base.EssException: Cannot begin data load. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server.  See log for more information
      2014-11-20 11:48:53,511 ERROR [AIF]: Error encountered
      2014-11-20 11:48:53,523 INFO  [AIF]: [HPLService] Info: [loadData:32] END (com.essbase.api.base.EssException: Cannot begin data load. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server.  See log for more information)
      2014-11-20 11:48:53,535 FATAL [AIF]: Error in CommData.loadData
      Traceback (most recent call last):
        File "<string>", line 4481, in loadData
      RuntimeError: com.essbase.api.base.EssException: Cannot begin data load. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server.  See log for more information

      2014-11-20 11:48:53,646 FATAL [AIF]: Error in COMM Load Data
      2014-11-20 11:48:53,660 INFO  [AIF]: FDMEE Process End, Process ID: 32

        • 1. Re: FDMEE Export error - Failed to establish connection
          Soumya Banerjee

          Hi,

           

          Try to install the Essbase Client in your FDM server and then take a proper restart of the entire instance along with the Servers. This will resolve the issue.

           

          Soumya

          • 2. Re: FDMEE Export error - Failed to establish connection
            2673365

            Hi Soumya,

             

            Thanks for the response. FDM and Essbase(server and client) installed on the same server.

            • 3. Re: FDMEE Export error - Failed to establish connection
              TomBlakeley

              Hi,

               

              Please try the following:

               

              Look at the Essbase logs - in the APP log you are going to be able to see the error message produced when this load rule tried to connect and failed.

               

              Also - Log into EAS, and open up the Rules files under the application you are trying to load to. You should see a loadrule called AIF0002... open this load rule and try to open a SQL connection - there is going to be a prebuild query in the load rule - keep that. Run the data retrieval and use the FDMEE database username/password. Does this execute successfully? (note: you may have to create a driver connection).

               

              If it does, then the load rule is correctly functioning and you probably had an environmental issue - at least you know it is not the load rule.

               

              If it does not work, then you have something else going on.

              • 4. Re: FDMEE Export error - Failed to establish connection
                2673365


                Thanks Tom.

                 

                Here is the error

                Connection String is [DRIVER={DataDirect 7.0 Oracle Wire Protocol};Host=EPM_server;Port=1521;SID=orcl;UID=...;PWD=...;ArraySize=1000000;]
                SELECT Statement [SELECT PERIOD  ,YEAR ,SCENARIO ,UD2 ,ACCOUNT ,UD1 ,ENTITY ,AMOUNT FROM AIF_HS_BALANCES WHERE LOADID = 33] is generated

                [Fri Nov 21 22:00:36 2014]Local/Vision/Plan1/admin@Native Directory/4640/Info(1021013)
                ODBC Layer Error: [IM002] ==> [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

                [Fri Nov 21 22:00:36 2014]Local/Vision/Plan1/admin@Native Directory/4640/Info(1021014)
                ODBC Layer Error: Native Error code [0]

                [Fri Nov 21 22:00:36 2014]Local/Vision/Plan1/admin@Native Directory/4640/Error(1021001)
                Failed to Establish Connection With SQL Database Server.  See log for more information

                 

                Also, when I opened the rule file I noticed that it's not using ODBC connection, it has an entry in server name -->"Oracle:/EPM_server:1521/orcl".

                 

                If I remove the entry from the server name, I can successfully connect from the rules file, however, I am not sure how to control this from FDMEE as it creates a new rule file every time I run the export.

                 

                Thanks!