This discussion is archived
4 Replies Latest reply: Jul 31, 2013 10:51 AM by JeffJon RSS

IN FDM 11.1.2.2 EXPORT ERROR API PROCEDURE ESBLOGIN THREWCODE 1054067

1012870 Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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    

Legend

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