Updateuserstatus is not returning path name

muralisankarr · Post by **muralisankarr** » Tue Feb 24, 2009 5:55 am

Hi,

I need to take a path from a oracle table and I need to load the file in to a table.

I have developed 2 jobs for this

J1 will take the file name and give the value to update user status

J2 will get the file name in input param.

But the above design is not working. Always the J1 is crashing and the J2 got only the characters before the presence of '\' . The same design work well when we used this to take a string instead of path. Is there any limitation we have in sending the path name to update userstatus. My pathname look like this "E:\EDW_Project\Archive_Main\2007_02_20 09.40.09\XX_XXX_XXXXX_XXXX_XXXXXXXXX-20070220.csv"

ManyThanks
rMS

ray.wurlod · Post by **ray.wurlod** » Tue Feb 24, 2009 6:18 am

You tell us nothing.

WHY is job J1 "always crashing"? What error message is logged?

muralisankarr · Post by **muralisankarr** » Tue Feb 24, 2009 7:33 am

Hi Ray,

It's great to see a response from you. Thank you.

We don't find any error message displayed in the job level log. But the status of the job is 96 in Sequence log. Please help us

Job Seq Log:
FILEROWCOUNT..JobControl (@StartLoop_Activity_1): Loop from 1 to 2 step 1: iteration 1

FILEROWCOUNT -> (GetFileName): Job run requested
Mode (row/warn limits) = 0/50
Job Parameters --->
pSEQ_NUM=1
DSJobController=FILEROWCOUNT

FILEROWCOUNT..JobControl (DSRunJob): Waiting for job GetFileName to start

FILEROWCOUNT..JobControl (DSWaitForJob): Waiting for job GetFileName to finish

FILEROWCOUNT..JobControl (DSWaitForJob): Job GetFileName has finished, status = 96 (Crashed)

FILEROWCOUNT -> (GetRowCount): Job run requested
Mode (row/warn limits) = 0/50
Job Parameters --->
pFILENAME=E:
DSJobController=FILEROWCOUNT

Job Log:

Starting Job GetFileName.
pSEQ_NUM = 1
DSJobController = FILEROWCOUNT

GetFileName..Counter: DSD.StageRun Active stage starting, tracemode = 0.

GetFileName..Oracle_OCI_0: SELECT File_Name FROM TMP_MNP_LOAD_FILE_LIST WHERE SEQ_NUM = 1

GetFileName..Hashed_File_12.Out: Write caching disabled

GetFileName..Counter: DSD.StageRun Active stage finishing.
1 rows read from In
1 rows written to Out
0.000 CPU seconds used, 0.046 seconds elapsed.

Finished Job GetFileName.

(FILEROWCOUNT) <- GetFileName: Job under control finished.

Thanks
rMS

Mike · Post by **Mike** » Tue Feb 24, 2009 7:44 am

Since you're only receiving "E:" in your parameter and the backslash is frequently used as an escape character, try doubling up the backslash characters.

For example:

Code: Select all

"E:\\EDW_Project\\Archive_Main\\2007_02_20 09.40.09\\XX_XXX_XXXXX_XXXX_XXXXXXXXX-20070220.csv"

Another guess might be your use of the drive letter (i.e "E:"). You may need to use the \\servername\path\file syntax instead.

Mike

chulett · Post by **chulett** » Tue Feb 24, 2009 9:04 am

How about an alternate solution? Drop the filename to a flat file then use a Routine Activity to echo it and pass that to the Job Activity parameter.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 24, 2009 5:17 pm

Silly as it might sound, try forward slash in the pathname rather than backslash. E:/XXXX/test.txt

If the pathname contains spaces you may need to ensure that it is quoted, just as you do with many other DOS applications.

Can you get job J1 to work in isolation? (Because it is Crashed you will need to re-compile it, not just reset.)