Bulk Load Job failing

vintipa · Post by **vintipa** » Sun Nov 30, 2008 11:20 pm

Hi Friends,

i am getting following error:
Load_PA0000..TgtPA0000Tbl: Invalid pointer to stage user data
Internal Error: Function 'get_stage_prop' failed
Error opening file in 'Directory for Data and Command Files'

this is a bulk load job. can somebody tell me what can be the reason ans solution?

Seached in the forum but no luck.

ray.wurlod · Post by **ray.wurlod** » Sun Nov 30, 2008 11:23 pm

You have specified a pathname in the "Directory for Data and Command Files" property in your bulk load stage but either this directory does not exist or the executing user does not have permission to create the control and data files therein.

chulett · Post by **chulett** » Mon Dec 01, 2008 12:01 am

Just for the record, what stage are you using for this "bulk load job"?

vintipa · Post by **vintipa** » Mon Dec 01, 2008 1:24 am

Hi,

I am using stage DB2_UDB load. We can run the job if the directory for

data and command files is changed. the folders have full privileges.

but still the error exists.

chulett · Post by **chulett** » Mon Dec 01, 2008 8:02 am

"The error exists" even if you change the directory? Or if you change the directory, everything is fine? If the latter, then obviously something is wrong with your first directory choice.

vintipa · Post by **vintipa** » Mon Dec 01, 2008 8:31 am

Hi,

Sorry for the Confusion

Actually the job runs fine if the directory is changed.
You may be right. i'll try to find what is the problem with the old directory and reply back.

vintipa · Post by **vintipa** » Fri Dec 05, 2008 1:34 am

Hi,

Please help me to solve this problem as this has become very critical.
Even after changing the directory for 'data and command files'.

is it datastage problem or OS problem? the folder is having privileges to the user running the jobs and also enough space is allocated to this.

infranik · Post by **infranik** » Fri Dec 05, 2008 1:46 am

Actually the job runs fine if the directory is changed

I believe if you can load from one directory and similar permissions exist for the same user, then u should be able to load from any other directory !
try going to the directory in UNIX prompt with that user and opening the file.
also 'type in manually' the directory name - hardcode it for testing purpose by removing any path parameters you are using .
UNIX is very case sensitive..

vintipa · Post by **vintipa** » Tue Dec 09, 2008 3:17 am

Hi All,

The problem is resolved. i found out that there was a file inpdata.dat
in the directory for data and command files . the job was failing because of this file. when i deleted then the bulk load job ran fine.

Though the problem is resolved can anyone tell me how this inpdata.dat file is created. and what is its use?

Thanks to all.

chulett · Post by **chulett** » Tue Dec 09, 2008 8:24 am

Apparently needed / created / used by the stage and (I assume) the user running the job didn't have permissions to delete it, so you needed to handle it manually.