Change source path in batch Job

[Former Member]

Hi Experts,

my organization has created job in data services 3.2 to cleanse the data reading from excel flat files. the folder path was store in the global variable(I think) and now they have changed the directories hence is it throwing me below error.

Error, Input file  does not exist please confirm existence and restart job, 16 ) >

failed, due to error <50316>: <>>> Error, Input file  does not exist please confirm existence and restart job>. I want to update the folder path. I am sure it would be easy but I am very new to BODS.

(12.2) 07-15-14 16:10:08 (14232:12656)  PRINTFN: > 'JOB DEBUG' : '>>> Sleeping for 35.000000 seconds...  '

(12.2) 07-15-14 16:10:43 (14232:12656)  PRINTFN: > 'JOB DEBUG' : '>>> Waking up......  '

(12.2) 07-15-14 16:10:43 (14232:12656)  PRINTFN: > 'JOB DEBUG' : 'Starting the timer loop number 6...'

(12.2) 07-15-14 16:10:43 (14232:12656) WORKFLOW: Work flow <WF_Metadata_Files> is started.

(12.2) 07-15-14 16:10:43 (14232:12656)  PRINTFN: > 'JOB DEBUG' : '>>> $G_FILENAME_IN : ALL_Metadata_SALES.xls...'

(12.2) 07-15-14 16:10:43 (14232:12656)  PRINTFN: > 'JOB DEBUG' : '>>> looking for input file name

                                                 \\infra\finance\production\sales\Metadata\ALL_Metadata_SALES.xls'

(12.2) 07-15-14 16:11:08 (14232:12656)  PRINTFN: > 'JOB DEBUG' : '>>>  Input file Name is '

(12.2) 07-15-14 16:11:08 (14232:12656)  PRINTFN: > 'JOB ERROR' : '>>> Error, Input file  does not exist please confirm existence and restart job'

I want to update the folder path \\infra\finance\production\sales\Metadata\ALL_Metadata_SALES.xls to \\Home\BIData\finance\production\sales\Metadata\ALL_Metadata_SALES.xls

when i investigated WF_Metadata_files i saw there is a global called INPUT_DIR i assume I have to change the path there. I tried to find old directory in the batch job but i cant find it and even When i give value to global variable it is still pointing to old path.

Can anybody please help me.

Thanks

Tim

[Former Member]

Hi Tim,

Don't change the value at run time, which will be temporary.

If you want to permanently change the value of global variable in Data Services then double click on the job in the project area(in designer)-> go to tools --> click on the variables--> then give the values.

Once you change the values here, save and validate, then these changes will be permanent.

Regards,

Mubashir Hussain

[Former Member]

Hi Hussain,

Thank you so much for your quick reply that what I did. But still it is picking the old path for some reason.

[Former Member]

Is the job scheduled??

Or manually running??

[Former Member]

it is scheduled

Thanks

Tim

[Former Member]

Then go to Data Services Management Console --> Administrator --> Status --> Select the repository --> Repository Schedules Tab --> select the schedule related to your job --> global variables.

Change it and then click on apply.

[Former Member]

do I have to make changes at both the places scheduled job and in data services designer as well.

what should i do after making the change to test ?

Thank you for your reply.

Thanks

Tim

[Former Member]

I exicuted manually for administration console.

It is still picking from the old path and throwing same error.

Thanks

Tim

[Former Member]

what would be the syntax to point it to particular folder.

I am using ' \\\Home\BIData\finance\production\sales\Metadata  '  as this jobs reads more than one file from this folder.

Thanks

Tim