Page 1 of 1
Updateuserstatus is not returning path name
Posted: Tue Feb 24, 2009 5:55 am
by muralisankarr
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
Posted: Tue Feb 24, 2009 6:18 am
by ray.wurlod
You tell us nothing.
WHY is job J1 "always crashing"? What error message is logged?
Posted: Tue Feb 24, 2009 7:33 am
by muralisankarr
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
Posted: Tue Feb 24, 2009 7:44 am
by Mike
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
Posted: Tue Feb 24, 2009 9:04 am
by chulett
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.
Posted: Tue Feb 24, 2009 5:17 pm
by ray.wurlod
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.)