Getting 0326(record not found error)

kcs4u2004 · New User Joined: 21 Apr 2008 Posts: 56 Location: Chennai

Hi all,

I am running one batch job which has a input file and two o/p file,I am getting 0326(record not found error),i got the first record not found,so i dleted the first record and ran..then got the 2nd record not found...it continued until the last record of the input file...with an empty input file I am able to run the job but output file is an empty one also..
could anyone please tell me why this happens..why none of the record of input file is not found in database.taken a clone of production just before and ran also..

Craq Giegerich · Posted: Fri Jul 10, 2009 9:55 pm

1. What is the source of the input file?

2. Are you sure the definition of the file you are using actually matches the file you are using.

3. Are you sure the database is defined and loaded properly.

4. What do the specifications for the batch program say about an unmatched condition?

5. We know nothing about your batch program or database so what makes you think we would even be able to guess at the cause of the problem?

sudharsan.soundararajan · New User Joined: 15 Oct 2008 Posts: 17 Location: Chennai

Hi Krish,

There might be one reason

there is a mismatch between your input file and database record.
i mean your input file may have low values, but your database migh stored with spaces

for example :
if say Name is the calc key . it is of 10 chars and say the field is "hari".

you might see HARI in both the input file and database but the difference comes in the next 6 chars after HARI. check the HEX DEC value in the input file and make sure the rest 6 chars are same in both input file and database

Both must be spaces ( Hex value 40) or low valus ( Hex value 00).

This may be an reason but i am not sure.

Give a try and update us

kcs4u2004 · New User Joined: 21 Apr 2008 Posts: 56 Location: Chennai

Hi,
Thanks for the response.
I found out the reason.actually the case is the data(key values) which is in input file,after being processed for overnight processing getting erased in due course in the program.I checked the employees in the db in OLQ,but did not find in db.so because of that the error is 0326.

now my question is the data comes FROM THE PRODUCTION CATALOGUE(online screen),its being processed and creates the output file in the overnight run..but the employee numbers which its getting from online screen are getting erased after the job runs..now those employees does not exist in the database..so how to test that program...if I will create the inpu file with the employee which is present in the database,but their other criterias are not matching..so its showing its not found(0326)
all the previous program is running succesfully

kcs4u2004 · New User Joined: 21 Apr 2008 Posts: 56 Location: Chennai

yes,with empty input file it is also running.but creating empty output reports.

so how the testing can be done..?

nelson.pandian · Posted: Tue Jul 28, 2009 11:15 am

Hi krish,

kcs4u2004 · New User Joined: 21 Apr 2008 Posts: 56 Location: Chennai

Thanks Nelson,You had a valuale suggestion,but the thing is I ran the job successfully,my input file is output of some other program,so ran that,even though it gave me exactly same file,still it ran successfully with my desired...for everytime I want to run,I have run it freshly..so it will run successfully..

Thanks again