Skip to Content
0
Former Member
Apr 14, 2010 at 06:22 PM

Error while loading data through data manager package

26 Views

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.