Hi All,
I am facing a problem where I am trying to load data for finance application.
My application format is
Account,Category,DataSrc,Entity,Intco,RptCurrency,Time
My data file format is
ENTITY,CATEGORY,INTCO,DATASRC,RPTCURRENCY,TIME,ACCOUNT,AMOUNT
E870,ACTUAL,Non_InterCo,Input,LC,JAN,ExtSales,-225600
Here is my transformation file
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER =
SKIP = 0
SKIPIF =
CREDITNEGATIVE=NO
CONVERTAMOUNTWDIM=
MAXREJECTCOUNT=
VALIDATERECORDS=YES
*MAPPING
Account=*COL(7)
Category=*COL(2)
DataSrc=*COL(4)
Entity=*COL(1)
IntCo=*COL(3)
RptCurrency=*COL(5)
Time=*COL(6)
AMOUNT=*COL(8)
*CONVERSION
The error I am facing is as follows:
TOTAL STEPS 2
1. Convert Data: Failed in 0 sec.
[Selection]
-
FILE=\PIP\FINANCE\DataManager\DataFiles\My Files\PIP_ACTUAL_DATA.TXT
TRANSFORMATION=\PIP\FINANCE\DataManager\TransformationFiles\System Files\Import.xls
CLEARDATA= No
RUNLOGIC= Yes
CHECKLCK= Yes
[Messages]
-
Exception from HRESULT: 0x800A005B
Can anyone please help me with this and also is there any debugging techniques with data manager package to get insight of where the error has occured.
Thanks,
Devang.