2 Replies Latest reply on Aug 21, 2015 11:57 AM by v.nones

    Error while exporting data into a plan type

    v.nones

      Hello,

       

      I am finding some issues in exporting data into a plan type. I have 2 target applications A and B, both with 2 plan types A1 and Workforce and B1 and workforce.

       

      The dimensionality of the plan types are different.I am loading some accounting data into all the plan types by using different load rules. In one target application -A- I have loaded the data successfully but in the other -B- I cannot load data into the plan type workforce due to a 3303 error: PRODUCT_NA doesnt' exist, but it does exist in the target application B and in the target application A there was no error (and we also have PRODUCT_NA)

       

      Also, I am loading other data in A and B and in B is not working due to this error:

       

      RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period 'January - 2014'"]

      2015-08-19 16:23:51,892 DEBUG [AIF]: Comm.executeScript - START
      2015-08-19 16:23:51,893 DEBUG [AIF]: The following script does not exist: vmhodiagap2\FDMEE\ENG/data/scripts/event/AftValidate.py
      2015-08-19 16:23:51,893 DEBUG [AIF]: Comm.executeVBScript - START
      2015-08-19 16:23:51,893 DEBUG [AIF]: The following script does not exist: vmhodiagap2\FDMEE\ENG\data\scripts\event\AftValidate.vbs
      2015-08-19 16:23:51,893 DEBUG [AIF]: Comm.executeVBScript - END
      2015-08-19 16:23:51,893 DEBUG [AIF]: Comm.executeScript - END
      2015-08-19 16:23:51,995 DEBUG [AIF]: Comm.finalizeProcess - START
      2015-08-19 16:23:51,995 DEBUG [AIF]: CommData.updateRuleStatus - START
      2015-08-19 16:23:51,996 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 = 446
                AND pd.STATUS IN ('FAILED','WARNING')
              )
              WHEN 0 THEN 'SUCCESS'
              ELSE (
                SELECT MIN(pd.STATUS)
                FROM AIF_PROCESS_DETAILS pd
                WHERE pd.PROCESS_ID = 446
                AND pd.STATUS IN ('FAILED','WARNING')
              )
              END
            ELSE 'FAILED'
          END
          WHERE RULE_ID = 60
         
      2015-08-19 16:23:51,998 DEBUG [AIF]: CommData.updateRuleStatus - END
      2015-08-19 16:23:51,999 FATAL [AIF]: Error in COMM Validate Data
      2015-08-19 16:23:51,999 DEBUG [AIF]: Comm.updateProcess - START
      2015-08-19 16:23:52,003 DEBUG [AIF]: Comm.updateProcess - END
      2015-08-19 16:23:52,005 DEBUG [AIF]: The fdmAPI connection has been closed.
      2015-08-19 16:23:52,005 INFO  [AIF]: FDMEE Process End, Process ID: 446

       

      but in the workbench I cannot see anything.

       

      Does anybody has a clue if this is FDMEE problema or it may be in the target application?

       

      Thanks!