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
Updateuserstatus is not returning path name
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 83
- Joined: Tue Oct 28, 2008 1:55 am
- Location: Chennai
Updateuserstatus is not returning path name
The minute you start talking about what you're going to do if you lose, you have lost
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 83
- Joined: Tue Oct 28, 2008 1:55 am
- Location: Chennai
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
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
The minute you start talking about what you're going to do if you lose, you have lost
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:
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
For example:
Code: Select all
"E:\\EDW_Project\\Archive_Main\\2007_02_20 09.40.09\\XX_XXX_XXXXX_XXXX_XXXXXXXXX-20070220.csv"
Mike
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
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.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.