Data Services Error 50316

[Former Member]

Hello, I am getting the following error when I try to run a job in Data Services (DS) that contains a ABAP Data Flow. It's pulling data from a table in R/3 and putting data in Teradata. In my DS job, I can specify which date range to pull. For some date ranges, I am getting this error. Other date ranges, the DS job runs fine. This tells me, there is something wrong with the data..but, not exactly sure which record in the data is causing the problem. I tried running the job with "trace row" turned on..and didn't find any problems with the record it's trying to process.

This is the error I am getting:

(12.2) 06-15-11 18:19:20 (E) (9109546:0001) FIL-080101: Cannot open file /BODI/dev/DS/dataservices/log/JobServer_5/dbods__dsdev8/error_06_15_2011_18_18_12_637__3936d82e_535a_4fbb_b4d2_416473b80f53.txt.idx in 'rb' mode.

OS error message <A file or directory in the path name does not exist.>. OS error number <2>. al_engine

reached 'fileopen_retry_time' limit so exiting

(12.2) 06-15-11 18:19:20 (E) (9109546:0001) RUN-050316: |Session JOB_CON_SAP_BCONT

Error during the execution of the job:JOB_CON_SAP_BCONT

(12.2) 06-15-11 18:19:20 (E) (9109546:0001) RUN-050304: |Session JOB_CON_SAP_BCONT

Function call <raise_exception ( Error during the execution of the job:JOB_CON_SAP_BCONT ) > failed, due to error <50316>:

<Error during the execution of the job:JOB_CON_SAP_BCONT>.

(12.2) 06-15-11 18:19:20 (E) (9109546:0001) RUN-050316: |Session JOB_CON_SAP_BCONT

Error during the execution of the job:JOB_CON_SAP_BCONT

This is our Installation Details:

Designer Version: 12.2.2.2

Job Server: 12.2.3.0

Job Engine: 12.2.3.0

Any help will be appreciated.

[Former Member]

is your job Server on AIX ?

when you get this error, do you see lot of other errors being written to job's errorlog file ?

are you running DFs in parallel in this job ?

[Former Member]

Manoj,

Yes, it's running on AIX.

No, I don't see other errors.

No, I only have one DF. Degree of Parallelism = 1.

Thanks.

[Former Member]

Manoj,

I found out the record that was causing the problem. We have a Date column and a Time column in the record. The date column contained '20110408' and time contained '000000'. For some reason, Data Services doesn't like '000000' in the time column. If I change the time to '000001' it worked fine. Any explanation why DS wouldn't take '000000' for time?

Thanks.

[Former Member]

by fixing the source data, you are preventing this error, since in your case the date or time conversion was failing a warning will be logged in the error log and when its trying to write to the errorlog file the error is happening, there seems to be some issue with file related operation and multiple threads trying to write to the same file

regarding time conversion issue, DS 12.2.3 is more strict when converting date/time string to date or time datatype, the input string should match the format that is specified for date/datetime/time, for example if the time format is hh24:mi:ss and you pass time as 000000 then its not valid time string as per the format so DS will give error for this

[Former Member]

Manoj, then why '000001' works for time and '000000' doesn't?

[Former Member]

I solved the problem another way... In the ABAP dataflow for the job (in query transform), I changed the field to VARCHAR (6) and it works fine. My target table is still defined as Integer (format 99:99:99). I didn't have to modify the source data as a workaround.

Thanks.

[Former Member]

Hello Sam.

I'm getting this issue and according your explanation I understand what is happening with time formats. Is it possible to get the step by step you used in this problem??

I'm looking forward to hearing from you!!

Regards.

Lelian