4 Replies Latest reply: Jul 31, 2013 12:51 PM by JeffJon RSS

    IN FDM 11.1.2.2 EXPORT ERROR API PROCEDURE ESBLOGIN THREWCODE 1054067

    1012870

      Error Export Failed

      ESSBASE  API PROCEDURE ESBLOGIN THREWCODE 1054067-1054067 Local ///Error (1054067) Internal Error At line 24

       

      Hi

       

      When i tried to Export data from FDM 11.1.2.2  TO Essbase i am getting this error . Previous it is Upend running application.  i dont know why this suddendly happend.Following are which i had done for Essabase to FDM Integration

       

      In MyComputer Environment Variables

       

      In System Variable:

       

      ESSBASE PATH:

      E:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0

       

      ESSLANG:

      English_UnitedStates.Latin1@Binary

       

      PATH:

      E:\Oracle\Middleware\EPMSystem11R1\bin-32;E:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin;E:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32\bin;E:\Oracle\Middleware\EPMSystem11R1\bin;E:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Client\32bit;E:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Client;E:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Common\32bit;E:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Common;E:\Oracle\Middleware\EPMSystem11R1\common\SAP\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;E:\Oracle\Middleware\EPMSystem11R1\products\hsf\bin-64;E:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\6.0\Drivers

       

      In User Variables

      there is no AROBHARPATH

       

      Register Adaptor UpsES11G4J is placed in Below Path

      E:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin

       

      I am getting Unable to Retrieve Target system when i clicked on Control Tables

       

       

       

      Thanks

        • 1. Re: IN FDM 11.1.2.2 EXPORT ERROR API PROCEDURE ESBLOGIN THREWCODE 1054067
          TomBlakeley

          Here is a place to start:


          FDM: How To Register The Essbase Adapter and Troubleshoot Common Issues in 11.1.2.1 (Doc ID 1345340.1)


          Can you post the log entries? Has the Essbase password changed? Another test would be to try and point to target dimensions in the Target Adapter. Could you also try creating a mapping line, and seeing if FDM can see any members in the Essbase app.


          • 2. Re: IN FDM 11.1.2.2 EXPORT ERROR API PROCEDURE ESBLOGIN THREWCODE 1054067
            1012870

            Hi Tom

             

            This is what i had found in Logs

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-05-30-13:15:33] **

            -------------------------------------------------------------

            Error:

            Code..............10410

            Description.......Essbase API Procedure: [EsbCalc] Threw code: 1012004 - 1012004 - [Thu May 30 13:15:33 2013]prod-hypess/TDWPLAN/CAPITAL/hypadmin/Error(1012004)

             

             

            Invalid member name [[Empty]]

            Procedure.........clsHPDataManipulation.fCalculate

            Component.........upsES11XG4J

            Version...........100

            Thread............5124

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-05-30 13:17:04] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 1004

            Description...................................... SaveAs method of Workbook class failed

            Procedure........................................ clsUtility.mRecordsetToExcel

            Component........................................ upsWDataWindowDM

            Version.......................................... 1112

            Thread........................................... 3848

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-05-30 14:05:11] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 1004

            Description...................................... Microsoft Excel cannot access the file 'E:\FDM\CAPITAL\Inbox\ActiveWorkOrder\ActiveWorkOrder033.xls'. There are several possible reasons:

             

             

            • The file name or path does not exist.

            • The file is being used by another program.

            • The workbook you are trying to save has the same name as a currently open workbook.

            Procedure........................................ clsImpTemplate.fImportExcelFile

            Component........................................ upsWObjectsDM

            Version.......................................... 1112

            Thread........................................... 5908

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-05-30 14:05:11] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 91

            Description...................................... Object variable or With block variable not set

            Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile

            Component........................................ upsWObjectsDM

            Version.......................................... 1112

            Thread........................................... 5908

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-05-31-01:18:36] **

            -------------------------------------------------------------

            Error:

            Code..............10410

            Description.......Essbase API Procedure: [EsbCalc] Threw code: 1012004 - 1012004 - [Fri May 31 01:18:36 2013]prod-hypess/TDWPLAN/CAPITAL/hypadmin/Error(1012004)

             

             

            Invalid member name [[Empty]]

            Procedure.........clsHPDataManipulation.fCalculate

            Component.........upsES11XG4J

            Version...........100

            Thread............5096

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... Connection Open

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-05:51:11] **

            -------------------------------------------------------------

            Error:

            Code..............10403

            Description.......Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 05:51:11 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure.........clsHPConnection.fConnect

            Component.........upsES11XG4J

            Version...........100

            Thread............4624

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-05:51:11] **

            -------------------------------------------------------------

            Error:

            Code..............10400

            Description.......Essbase API Procedure: [EsbLogout] Threw code: 1030001 - .

            Procedure.........clsHPConnection.fDisconnect

            Component.........upsES11XG4J

            Version...........100

            Thread............4624

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 05:51:11] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 05:51:11 2013]Local////Error(1054067)

             

             

            Internal error

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActConnect

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 3052

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 05:51:12] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 05:51:11 2013]Local////Error(1054067)

             

             

            Internal error

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActExport

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 3052

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-05:51:25] **

            -------------------------------------------------------------

            Error:

            Code..............10403

            Description.......Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 05:51:25 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure.........clsHPConnection.fConnect

            Component.........upsES11XG4J

            Version...........100

            Thread............1084

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-05:51:25] **

            -------------------------------------------------------------

            Error:

            Code..............10400

            Description.......Essbase API Procedure: [EsbLogout] Threw code: 1030001 - .

            Procedure.........clsHPConnection.fDisconnect

            Component.........upsES11XG4J

            Version...........100

            Thread............1084

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 05:51:25] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 05:51:25 2013]Local////Error(1054067)

             

             

            Internal error

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActConnect

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 4856

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 05:51:25] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 05:51:25 2013]Local////Error(1054067)

             

             

            Internal error

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActExport

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 4856

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-07:20:30] **

            -------------------------------------------------------------

            Error:

            Code..............10403

            Description.......Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 07:20:30 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure.........clsHPConnection.fConnect

            Component.........upsES11XG4J

            Version...........100

            Thread............6988

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 07:20:30] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 07:20:30 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure........................................ frmIntegrateES.tabMain_Click

            Component........................................ upsES11XG4J

            Version.......................................... 100

            Thread........................................... 6988

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WorkBench

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-07:21:07] **

            -------------------------------------------------------------

            Error:

            Code..............10400

            Description.......Essbase API Procedure: [EsbLogout] Threw code: 1030001 - .

            Procedure.........clsHPConnection.fDisconnect

            Component.........upsES11XG4J

            Version...........100

            Thread............6988

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-07:28:16] **

            -------------------------------------------------------------

            Error:

            Code..............10403

            Description.......Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 07:28:16 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure.........clsHPConnection.fConnect

            Component.........upsES11XG4J

            Version...........100

            Thread............7144

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 07:28:16] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 07:28:16 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure........................................ frmIntegrateES.tabMain_Click

            Component........................................ upsES11XG4J

            Version.......................................... 100

            Thread........................................... 7144

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WorkBench

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-07:28:26] **

            -------------------------------------------------------------

            Error:

            Code..............10400

            Description.......Essbase API Procedure: [EsbLogout] Threw code: 1030001 - .

            Procedure.........clsHPConnection.fDisconnect

            Component.........upsES11XG4J

            Version...........100

            Thread............7144

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-09:29:37] **

            -------------------------------------------------------------

            Error:

            Code..............10403

            Description.......Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 09:29:37 2013]Local////Error(1054067)

             

             

            Internal error

            Procedure.........clsHPConnection.fConnect

            Component.........upsES11XG4J

            Version...........100

            Thread............5108

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-07-29-09:29:37] **

            -------------------------------------------------------------

            Error:

            Code..............10400

            Description.......Essbase API Procedure: [EsbLogout] Threw code: 1030001 - .

            Procedure.........clsHPConnection.fDisconnect

            Component.........upsES11XG4J

            Version...........100

            Thread............5108

             

             

            Identification:

            User..............hypadmin

            Computer Name.....PROD-HYPAPP

             

             

            Essbase Connection:

            App Name..........TDWPLAN

            DB Name...........CAPITAL

            Server Name.......prod-hypess

            Connect Status.... No Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 09:29:37] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 09:29:37 2013]Local////Error(1054067)

             

             

            Internal error

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActConnect

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 4996

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-07-29 09:29:38] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 10403

            Description...................................... Essbase API Procedure: [EsbLogin] Threw code: 1054067 - 1054067 - [Mon Jul 29 09:29:37 2013]Local////Error(1054067)

             

             

            Internal error

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActExport

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 4996

             

             

            IDENTIFICATION:

            User............................................. hypadmin

            Computer Name.................................... PROD-HYPAPP

            App Name......................................... CAPITAL

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... SQLOLEDB

            Data Server...................................... prod-hypsql

            Database Name.................................... fdmCapital

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... ActiveWorkOrder

            Location ID...................................... 749

            Location Seg..................................... 3

            Category......................................... Actual

            Category ID...................................... 12

            Period........................................... Mar FY12

            Period ID........................................ 3/31/2012

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

            I tried to Connect to Source dimension its showing Connection Failed

            • 3. Re: IN FDM 11.1.2.2 EXPORT ERROR API PROCEDURE ESBLOGIN THREWCODE 1054067
              TomBlakeley

              Hello,

               

              So this looks like a possible path issue - have you ever been able to communicate with Essbase on this box using FDM? If you have modified the path, did you restart the box after? I don't think that 11.1.2.2 comes out of the box with the RTC, so did you install that separately?

              • 4. Re: IN FDM 11.1.2.2 EXPORT ERROR API PROCEDURE ESBLOGIN THREWCODE 1054067
                JeffJon

                You need to make sure that the period and category control tables for the adapter are set to the proper target Period and Category:

                 

                a) Choose Metadata > controL Tables

                b) Select your essbase adapter and update the Target Period (M) and Year Target values to the target values in the Essbase Outline

                c) Choose the "Categories" drop down and set the target category values and update the grid to save