Issue

In MCP0200 when clicking on the View Directory button the error message 550 - The System cannot find the path specified is shown. The path shown in the top of the window exists on the server and there is a *.shp file in the folder. The folder permissions are ok (read/write/execute for all users).

 Solution

The error ‘550 - The System cannot find the path specified’ was ‘originated’ on FTP server. To check it run the SQL command below:

 begin

           nm3mcp_ftp.MOVE_SHAPEFILES_IN;

 end;

and the output is:

ORA-20000: 550-The system cannot find the path specified.

ORA-06512: at "HIGHWAYS.NM3FTP", line 301

ORA-06512: at "HIGHWAYS.NM3FTP", line 279

ORA-06512: at "HIGHWAYS.NM3FTP", line 807

ORA-06512: at "HIGHWAYS.NM3MCP_FTP", line 488

ORA-06512: at line 2

20000. 00000 - "%s"*Cause:   The stored procedure 'raise_application_error'  was called which causes this error to be generated.

*Action:   Correct the problem as described in the error message or contact   the application administrator or DBA for more information.

220 FTP_SERVER_NAME

331 Password required for FTP_USER.

230-All connections are monitored

   User logged in. Win32 error:   The operation completed successfully.

   Error details: File system returned an error.

230 End

227 Entering Passive Mode (10,94,142,62,194,92).

         LIST MCI/MCI_In/

550-The system cannot find the path specified.

The issue is related to ftp user account and recreating it (or changing it to another one) on FTP server solves the issue. When everything is fine and running SQL command (above) the output should be:

 220 FTP_SERVER

331 Password required for FTP_USER

230-All connections are monitored

230 User logged in.

227 Entering Passive Mode (10,94,142,62,198,15).

LIST MCI/MCI_In/

125 Data connection already open; Transfer starting.

226 Transfer complete.