cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data services Job fails with errorcode 170101

Go to solution
Former Member

on ‎01-15-2015 6:27 PM

0 Kudos

We are using Data services 4.2

When I use the flat file format to load csv data using single filename the job works.

But when I use wildcard character * to load multiple files with the same name like TestData*.csv the job fails with errorcode 170101

Attached is job log

89129368SYS-1701011/15/2015 1:25:05 PM|Session Pages|Data flow Pages
89129368SYS-1701011/15/2015 1:25:05 PMSystem Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
89129368SYS-1701011/15/2015 1:25:05 PMCall stack:
89129368SYS-1701011/15/2015 1:25:05 PM0x00000000805BE223, BBLocale::initConstants()+0755 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\i18n\babelclasses.cpp, line 0323+0051 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x000000008057F8BA, Flat_file_base<Flat_file_mt_buffer_SB>::slow_getColumn()+7210 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\inc\filespec\flat_file.cc, line 3866
89129368SYS-1701011/15/2015 1:25:05 PM0x000000008058D6F8, Flat_file_base<Flat_file_mt_buffer_SB>::getColumn()+0072 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\inc\filespec\flat_file.cc, line 2028
89129368SYS-1701011/15/2015 1:25:05 PM0x0000000080CC8E0D, RdrFileMT_Process::getnext()+1245 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrfilemt.cpp, line 1604
89129368SYS-1701011/15/2015 1:25:05 PM0x0000000080CC6875, RdrFileMT_Process::execute()+0101 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrfilemt.cpp, line 1489+0015 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x00000000801B5A20, XTran_desc::execute()+0448 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0799
89129368SYS-1701011/15/2015 1:25:05 PM0x0000000081026E69, Rww_thread::main()+0249 byte(s),
89129368SYS-1701011/15/2015 1:25:05 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\rww\rww.cpp, line 0451
89129368SYS-1701011/15/2015 1:25:05 PM0x00000000009F438E, RWThreadFunctionImp::run()+0126 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x00000000009DC184, RWRunnableImp::exec()+0372 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x00000000009F4643, RWThreadImp::exec()+0051 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x00000000009F5F59, RWThreadImp::_setTimeSliceQuantum()+0169 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x000000006E1937D7, endthreadex()+0071 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x000000006E193894, endthreadex()+0260 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x000000000AC613D2, BaseThreadInitThunk()+0034 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PM0x000000000D1F03C4, RtlUserThreadStart()+0052 byte(s)
89129368SYS-1701011/15/2015 1:25:05 PMRegisters:
89129368SYS-1701011/15/2015 1:25:05 PMRAX=0000000000000000  RBX=00000000015FBB80  RCX=00000000015FBB80  RDX=0000000000020017  RSI=0000000000000400
89129368SYS-1701011/15/2015 1:25:05 PMRDI=0000000000000000  RBP=0000000000000000  RSP=000000000AE3E030  RIP=00000000805BE223  FLG=0000000000010206
89129368SYS-1701011/15/2015 1:25:05 PMR8=0000000000000000   R9=0000000000000007  R10=0000000009F2B2C0  R11=0000000009F2B700  R12=0000000009DDA830
89129368SYS-1701011/15/2015 1:25:05 PMR13=000000000000001F  R14=00000000817D5D50  R15=000000000000000B
89129368SYS-1701011/15/2015 1:25:05 PMException code: C0000005 ACCESS_VIOLATION
89129368SYS-1701011/15/2015 1:25:05 PMFault address:  00000001805BE223 01:00000000005BD223 C:\Program Files (x86)\SAP BusinessObjects\Data Services\bin\acta.dll
89129368SYS-1701011/15/2015 1:25:05 PM==========================================================
89129368SYS-1701011/15/2015 1:25:05 PMCollect the following and send to Customer Support:
89129368SYS-1701011/15/2015 1:25:05 PM1. Log files(error_*, monitor_*, trace_*) associated with this failed job.
89129368SYS-1701011/15/2015 1:25:05 PM2. Exported ATL file of this failed job.
89129368SYS-1701011/15/2015 1:25:05 PM3. DDL statements of tables referenced in this failed job.
89129368SYS-1701011/15/2015 1:25:05 PM4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
89129368SYS-1701011/15/2015 1:25:05 PMthe job failed.
89129368SYS-1701011/15/2015 1:25:05 PM5. Core dump, if any, generated from this failed job.
89129368SYS-1701011/15/2015 1:25:05 PM==========================================================
89129368SYS-1701011/15/2015 1:25:06 PM|Session Pages|Data flow Pages
89129368SYS-1701011/15/2015 1:25:06 PMSystem Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
89129368SYS-1701011/15/2015 1:25:06 PMCall stack:
89129368SYS-1701011/15/2015 1:25:06 PM0x00000000805BE223, BBLocale::initConstants()+0755 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\i18n\babelclasses.cpp, line 0323+0051 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x000000008057F8BA, Flat_file_base<Flat_file_mt_buffer_SB>::slow_getColumn()+7210 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\inc\filespec\flat_file.cc, line 3866
89129368SYS-1701011/15/2015 1:25:06 PM0x000000008058D6F8, Flat_file_base<Flat_file_mt_buffer_SB>::getColumn()+0072 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\inc\filespec\flat_file.cc, line 2028
89129368SYS-1701011/15/2015 1:25:06 PM0x0000000080CC8E0D, RdrFileMT_Process::getnext()+1245 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrfilemt.cpp, line 1604
89129368SYS-1701011/15/2015 1:25:06 PM0x0000000080CC6875, RdrFileMT_Process::execute()+0101 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrfilemt.cpp, line 1489+0015 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x00000000801B5A20, XTran_desc::execute()+0448 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0799
89129368SYS-1701011/15/2015 1:25:06 PM0x0000000081026E69, Rww_thread::main()+0249 byte(s),
89129368SYS-1701011/15/2015 1:25:06 PMd:\im_ds_4.2_sp02_patch_rel\src\dataservices\dataintegrator\codeline\code\src\rww\rww.cpp, line 0451
89129368SYS-1701011/15/2015 1:25:06 PM0x00000000009F438E, RWThreadFunctionImp::run()+0126 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x00000000009DC184, RWRunnableImp::exec()+0372 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x00000000009F4643, RWThreadImp::exec()+0051 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x00000000009F5F59, RWThreadImp::_setTimeSliceQuantum()+0169 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x000000006E1937D7, endthreadex()+0071 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x000000006E193894, endthreadex()+0260 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x000000000AC613D2, BaseThreadInitThunk()+0034 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PM0x000000000D1F03C4, RtlUserThreadStart()+0052 byte(s)
89129368SYS-1701011/15/2015 1:25:06 PMRegisters:
89129368SYS-1701011/15/2015 1:25:06 PMRAX=0000000000000000  RBX=00000000015FBB80  RCX=00000000015FBB80  RDX=0000000000020017  RSI=0000000000000400
89129368SYS-1701011/15/2015 1:25:06 PMRDI=0000000000000000  RBP=0000000000000000  RSP=000000000AE3E030  RIP=00000000805BE223  FLG=0000000000010206
89129368SYS-1701011/15/2015 1:25:06 PMR8=0000000000000000   R9=0000000000000007  R10=0000000009F2B2C0  R11=0000000009F2B700  R12=0000000009DDA830
89129368SYS-1701011/15/2015 1:25:06 PMR13=000000000000001F  R14=00000000817D5D50  R15=000000000000000B
89129368SYS-1701011/15/2015 1:25:06 PMException code: C0000005 ACCESS_VIOLATION
89129368SYS-1701011/15/2015 1:25:06 PMFault address:  00000001805BE223 01:00000000005BD223 C:\Program Files (x86)\SAP BusinessObjects\Data Services\bin\acta.dll
89129368SYS-1701011/15/2015 1:25:06 PM==========================================================
89129368SYS-1701011/15/2015 1:25:06 PMCollect the following and send to Customer Support:
89129368SYS-1701011/15/2015 1:25:06 PM1. Log files(error_*, monitor_*, trace_*) associated with this failed job.
89129368SYS-1701011/15/2015 1:25:06 PM2. Exported ATL file of this failed job.
89129368SYS-1701011/15/2015 1:25:06 PM3. DDL statements of tables referenced in this failed job.
89129368SYS-1701011/15/2015 1:25:06 PM4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
89129368SYS-1701011/15/2015 1:25:06 PMthe job failed.
89129368SYS-1701011/15/2015 1:25:06 PM5. Core dump, if any, generated from this failed job.
89129368SYS-1701011/15/2015 1:25:06 PM==========================================================

Any help would be appreciated.

Thanks

Hemant

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member211387
Contributor
‎01-15-2015 9:18 PM
0 Kudos

Hi,

How are you passing the file name value TestData*.csv ?

kind regards

Raghu

Show replies
Show replies
Former Member
‎01-15-2015 9:26 PM
0 Kudos

I am adding it in the Fileformat Filename field

former_member211387
Contributor
‎01-19-2015 5:55 PM
0 Kudos

Hi,

Thank you for the screenshot. I take it the location "C:\apps" is the local folder on the jobserver where you have stored files matcing the file name pattern?

If so try hard coding it to *.csv instead of test*.csv. Another option will be to store the file name pattern in a global variable and place that in the file name(s) field.

kind regards

Raghu

former_member198401
Active Contributor
‎01-20-2015 9:29 AM
0 Kudos

Hi Hemanth,

As per your screnshot the Location is Local whereas it should be Job Server as the files are processed if they are kept on the Job Server C:\apps directory...

It should be something like below

Try this and let me know

Regards

Arun Sasi

Former Member
‎02-09-2015 3:59 PM
0 Kudos

The job picked up the wild card characters after changing the setting to job server instead of local server.

Thanks for your help.

former_member198401
Active Contributor
‎02-09-2015 6:01 PM
0 Kudos

Hi Hemanth

I am glad that it worked..

Regards

Arun Sasi

former_member281308
Participant
‎10-06-2016 5:54 PM
0 Kudos

Hi Arun,

I am getting same Issue above the error but i am using Global variable   for root directory and file names also  giving global variable. if i run indivual file the job was sucess but if i run multiple files it was failed. Can you please explain and let us know..

Thanks,

krishna.

former_member198401
Active Contributor
‎10-07-2016 1:24 PM
0 Kudos

Put File Name as *.CSV or whatever extension you are using

Answers (4)

Answers (4)

former_member281308
Participant
‎10-07-2016 2:24 PM
0 Kudos

Hi Arun,

I have taken screenshot for this falt file. Our files are different brands ,

Can u please check and let us know. if i am giving the global variable or not

Thanks,

krishna

Show replies
Show replies
former_member281308
Participant
‎10-07-2016 2:18 PM
0 Kudos

Hi Arun,

Can i use Global Variable instead of *.txt. Please let us know

Regards,

krish.

Show replies
Show replies
former_member187605
Active Contributor
‎01-19-2015 8:26 PM
0 Kudos

Do all your files have exactly the same format? Does your job work with every individual file matching that name pattern in your folder?

Show replies
Show replies
former_member211387
Contributor
‎01-20-2015 9:17 AM
0 Kudos

Yes, the wildcard will work well only if all the files matching the wildcard pattern are of the same format in terms of the structure. So best to check that too. But when I had cases where the files dont match, it just used to throw an error message on the file that was wrong and proceed with the rest of the files unless I force a termination at the encounter of an error.

Raghu

mageshwaran_subramanian
Active Contributor
‎01-15-2015 7:51 PM
0 Kudos

If you want to change the approach a bit,may be you should look at this

Show replies
Show replies
Ask a Question