5 Replies Latest reply on Jun 10, 2014 8:34 AM by Francisco Amores

    Issue in loading flat file

    1050864

      Hi,

       

      I am trying to load data into hfm application using dat file my target dimensions are

       

      Account

      Amount

      Custom1

      Custom2

      Entity

      ICP

       

      Set up process done are

       

      Created Import format,Location,Period Mapping, Category Mapping

       

      & In  worflow

       

      Created data rule,In data load rule

      In Data Load Workbench Imported in data successful & validate successfull but in export error

       

      In Logs below error shows...

       

      Error in HfmData.loadDataTraceback (most recent call last):

        File "<string>", line 106, in loadData

      RuntimeError: Load Error

       

      RuntimeError: ODI-1226: Step HFM Load Data fails after 1 attempt(s).

       

       

      How to clear this issue..?

       

       

      Thanks in advance

        • 1. Re: Issue in loading flat file
          KKT

          Check that the dimension mapping is correct for the class in the target application and that your import format is going to the proper target dimension.

           

          This error comes when your target dimension are not mapped properly.

           

          Thanks,

          ~KKT~

          1 person found this helpful
          • 2. Re: Issue in loading flat file
            Francisco Amores

            Can you set your log level to 5?

            Which are the details in the log?

            1 person found this helpful
            • 3. Re: Issue in loading flat file
              SSN01

              Check the Process Log Details.

              Did you register the HFM adapter ?

              1 person found this helpful
              • 4. Re: Issue in loading flat file
                1050864

                1. I see log file that the log level is 5 , but don't know where to set the log details?

                2. I pasted some log details

                 

                2014-06-08 23:13:56,320 INFO  [AIF]: FDMEE Process Start, Process ID: 113

                2014-06-08 23:13:56,324 INFO  [AIF]: FDMEE Logging Level: 5

                2014-06-08 23:13:56,324 INFO  [AIF]: FDMEE Log File: C:\Oracle\FDMEE\outbox\logs\POC_113.log

                2014-06-08 23:13:56,324 INFO  [AIF]: User:admin

                2014-06-08 23:13:56,324 INFO  [AIF]: Location:Dat file (Partitionkey:2)

                2014-06-08 23:13:56,325 INFO  [AIF]: Period Name:JAN (Period Key:1/31/10 12:00 AM)

                2014-06-08 23:13:56,325 INFO  [AIF]: Category Name:Actual (Category key:5)

                2014-06-08 23:13:56,325 INFO  [AIF]: Rule Name:POC Actual (Rule ID:1)

                2014-06-08 23:14:00,129 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

                [Java

                 

                HotSpot(TM) 64-Bit Server VM (Sun Microsystems Inc.)]

                2014-06-08 23:14:00,129 INFO  [AIF]: Java Platform: java1.6.0_35

                2014-06-08 23:14:01,846 INFO  [AIF]: -------START IMPORT STEP-------

                2014-06-08 23:14:03,711 DEBUG [AIF]: CommData.getRuleInfo - START

                 

                 

                2014-06-08 23:14:04,688 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'JAN'

                2014-06-08 23:14:04,688 DEBUG [AIF]: CommData.updateWorkflow - START

                2014-06-08 23:14:04,688 DEBUG [AIF]:

                        UPDATE TLOGPROCESS

                        SET PROCESSENDTIME = CURRENT_TIMESTAMP

                       

                        ,PROCESSSTATUS = 12

                          ,PROCESSVAL = 0

                          ,BLNVALDIRTY = 0

                          ,PROCESSVALNOTE = 'Error =

                 

                98 records'

                        WHERE PARTITIONKEY = 2

                        AND CATKEY = 5

                        AND PERIODKEY = '2010-01-31'

                        AND

                 

                RULE_ID = 1

                       

                2014-06-08 23:14:04,691 DEBUG [AIF]: CommData.updateWorkflow - END

                2014-06-08 23:14:04,691 INFO  [AIF]: Total Data Rows available for Export to Target: 0

                2014-06-08 23:14:04,692 FATAL [AIF]: Error in CommMap.validateData

                Traceback (most recent call last):

                  File

                 

                "<string>", line 2348, in validateData

                RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period

                 

                'JAN'"]

                 

                2014-06-08 23:14:04,734 DEBUG [AIF]: Comm.finalizeProcess - START

                2014-06-08 23:14:04,734 DEBUG [AIF]: CommData.updateRuleStatus - START

                2014-06-08 23:14:04,734 DEBUG [AIF]:

                    UPDATE AIF_BALANCE_RULES

                    SET STATUS = CASE 'FAILED'

                      WHEN 'SUCCESS'

                 

                THEN

                        CASE (

                          SELECT COUNT(*)

                          FROM AIF_PROCESS_DETAILS pd

                          WHERE pd.PROCESS_ID =

                 

                113

                          AND pd.STATUS IN ('FAILED','WARNING')

                        )

                        WHEN 0 THEN 'SUCCESS'

                        ELSE (

                         

                 

                SELECT MIN(pd.STATUS)

                          FROM AIF_PROCESS_DETAILS pd

                          WHERE pd.PROCESS_ID = 113

                          AND pd.STATUS

                 

                IN ('FAILED','WARNING')

                        )

                        END

                      ELSE 'FAILED'

                    END

                    WHERE RULE_ID = 1

                   

                2014-06-08 23:14:04,741 DEBUG [AIF]: CommData.updateRuleStatus - END

                2014-06-08 23:14:04,742 FATAL [AIF]: Error in COMM Validate Data

                2014-06-08 23:14:04,742 DEBUG [AIF]: Comm.updateProcess - START

                2014-06-08 23:14:04,748 DEBUG [AIF]: Comm.updateProcess - END

                2014-06-08 23:14:04,749 INFO  [AIF]: FDMEE Process End, Process ID: 113

                1 person found this helpful
                • 5. Re: Issue in loading flat file
                  Francisco Amores

                  YOu said IMPORT AND VALIDATE were success although in that log it is shown that there errors due to unmapped members

                   

                  Data rows with unmapped dimensions exist for Period


                  Your Validate step should fail and you should see validation errors in "Validation Errors" tab in the data grid.

                  1 person found this helpful