System cannot find the path specified error

[Former Member]

Hi,

I am trying to copy files from one folder to another folder within the same shared drive. Getting error "cannot find the path specified". Please see my error log.

13196	12532	PRINTFN	7/25/2015 12:30:25 PM	\\vmspfsfsch02\JET_INTEL_TO_BL\*
13196	12532	PRINTFN	7/25/2015 12:30:25 PM	\\vmspfsfsch02\JET_INTEL_TO_BL\Processed\*
13196	12532	PRINTFN	7/25/2015 12:30:25 PM	1: The system cannot find the path specified.
13196	12532	JOB	7/25/2015 12:30:25 PM	Job <JOB_JET0010_PreLoad> is completed successfully.

Script is as follows

print ( $GV_Jet_Base_Folder );

print( $GV_Jet_Processed_Folder );

print(exec('cmd','copy "'||$GV_Jet_Base_Folder||'" "'||$GV_Jet_Processed_Folder||' - copied to Processed Folder on '||to_char(sysdate(),'mm-dd-yyyy')|| ' at '   ||to_char(sysdate(),'hh-mi-ss')|| '.txt'||   '"',8));

Even if I change my global variables to the path on the job server, same error message.

Can anybody help?

Thx
RM

[chethan_lingaraju · Accepted solution]

Target path should end with \, not with *

Ex:

Copy \\FromServer\SomeFolder\* \\ToServer\SomeOtherFolder\

[Former Member · Accepted solution]

Chetan,

Thanks for the reply.

I defined my global variables as

" \\\Vmspfsfsch02\jet_intel_to_bl\Jet*"  --> Source Folder

" \\\Vmspfsfsch02\jet_intel_to_bl\Processed\" --> Target folder

Script is ok. but when I run the job,

Getting below error.....

I tried with single quotes and double quotes.

7244	19228	PAR-010202	7/26/2015 9:39:47 AM	Error parsing global variable values from the command line: <$GV_Jet_Base_Folder= "
7244	19228	PAR-010202	7/26/2015 9:39:47 AM	\\\Vmspfsfsch02\jet_intel_to_bl\Jet*";$GV_Jet_Processed_Folder= " \\\Vmspfsfsch02\jet_intel_to_bl\Processed\";>. Check the
7244	19228	PAR-010202	7/26/2015 9:39:47 AM	syntax and try again.

Please help.

Thx
RM

[Former Member · Accepted solution]

Chetan,

More error text...

8220	15912	PAR-010102	7/26/2015 9:35:45 AM	Syntax error at line <1>: <>:  found <[end of text]> expecting <'(', &ERROR, __AL_LOOKUPEX_TRAN, __AL_SEARCH_REPLACE_TRAN,
8220	15912	PAR-010102	7/26/2015 9:35:45 AM	__RFC_FUNCTION, __AL_SCRIPT_FUNCTION, __AL_STORED_PROCEDURE, __AL_EXTRACT_FROM_XML, __AL_EXTRACT_FROM_JSON, __AL_TRAN_FUNCTION,
8220	15912	PAR-010102	7/26/2015 9:35:45 AM	+, AL_UNSPECIFIED_PARAM, CONVERT, a float, identifier, an integer, a null, a quoted identifier, ;, a string, a decimal,
8220	15912	PAR-010102	7/26/2015 9:35:45 AM	VARCHAR, VARIABLE, -, +>.
8220	15912	PAR-010102	7/26/2015 9:35:45 AM	1 error(s), 0 warning(s).

[chethan_lingaraju · Accepted solution]

Hi Ravi, Preliminary checks

1. Check if you have created all the folders in source & target
2. Try opening the path from Jobserver to check if its reachable. Use FQDM if required.

Try the following one by one

1. Check if there is any space in the beginning of the path - before three slash and after double quotes
2. Use double slash in the beginning instead of three
   1. "\\Vmspfsfsch02\jet_intel_to_bl\Jet*"  --> Source Folder
   2. "\\Vmspfsfsch02\jet_intel_to_bl\Processed\" --> Target folder
3. End source path with *.*
   1. "\\\Vmspfsfsch02\jet_intel_to_bl\Jet*.*"  --> Source Folder
4. Hard-code the path and check if the job works. Create a new test job with just a script which copies files to target so that you can isolate the issue.

[Former Member · Accepted solution]

Preliminary Checks

1. Folders are there. I have some other jobs creating the files fine in the source folder. And I see that the target folder is also there, but no files yet.

2. How can I open the path from the JobServer?

1a. there are no spaces in front and at the end

2a. I used double slashes

3a. Done

4.   I had a separate job with just the script to copy the files. I hardcoded the path.

Print(exec('cmd','copy "\\VMSPFSFSCH02\INTEL_TO_BL\Jet*.*" "\\VMSPFSFSCH02\INTEL_TO_BL\Processed\"',8));

14456

14080

PRINTFN

7/26/2015 11:09:52 AM

1: The system cannot find the path specified.

[Former Member · Accepted solution]

Hi Ravi,

Try passing the IP address instead of the domain name, if you are passing the domain name just check whether the Host entries are maintained on the server or not.

Other option would be to try this copy directly from command prompt.

Regards..

[chethan_lingaraju · Accepted solution]

Login to Jobserver, in your computer:

• Start menu -> Run -> type mstsc and press enter
• Enter jobserver name and credentials

After logging into Jobserver, in jobserver:

• Start menu -> Run -> paste \\Vmspfsfsch02\jet_intel_to_bl\Processed and press enter.

Also, check if the path \\Vmspfsfsch02\jet_intel_to_bl\Processed is having full permission for the user in which BODS services are running.

[former_member198401 · Accepted solution]

Hi Ravi,

Have you checked by manually running the batch script from command line. Does it execute successfully.

Regards

Arun Sasi

[Former Member · Accepted solution]

Guys,

Thanks to all of you. I had to use the full server including domain name. Then it is working.