Home » Developer & Programmer » Forms » Unable to read mapped drive (Oracle 10g,Windows 2003)
Unable to read mapped drive [message #281199] Fri, 16 November 2007 01:37 Go to next message
jpnanda
Messages: 5
Registered: February 2007
Junior Member
We are working in Oracle8i at present and upgrading our system to 10g. Our programs(fmx,library etc) has been mapped to a named drive and clients has access to that drive. This is working fine in 8i environment. But in 10g , the same method is not working properly. The programs runs fine from our development machines (i.e. with ids platform). While we try to run the program on the application server, it displays error message "FRM-40010:Unable to read <program file name >". If I change the path to the original drive (instead of the mapped drive) it runs on the application server.
Example:
Programs exist in D drive of the application server.
The required folder (in D) has been shared to use by the clients and mapped to drive Z on the application server and also at the development machines. Z drive is accessible to all the clients,development machines & the application server itself.

Thanks & regards
jpn
Re: Unable to read mapped drive [message #281630 is a reply to message #281199] Sun, 18 November 2007 21:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What operating system are you using for the various machines?

David
Re: Unable to read mapped drive [message #281674 is a reply to message #281630] Mon, 19 November 2007 00:25 Go to previous messageGo to next message
jpnanda
Messages: 5
Registered: February 2007
Junior Member
Thanks for replying.

We are using windows 2003 server for our App Server.

Thanks.

jpn
Re: Unable to read mapped drive [message #281712 is a reply to message #281674] Mon, 19 November 2007 01:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I guess that you have absolute file names in your form. Please post the code that is doing the call (using 'code' tags).

David
Re: Unable to read mapped drive [message #281756 is a reply to message #281712] Mon, 19 November 2007 04:07 Go to previous messageGo to next message
jpnanda
Messages: 5
Registered: February 2007
Junior Member
Folder "D:\sims" of App Server has been mapped As Z on the same machine. App server has access to its mapped z drive.
All the program(fmx) files exist in "D:\sims" folder.

The following url we are using on our app server.

http://scoras10g.silcor10:7777/forms/frmservlet?form=z:\testform.fmx

The url given above is not working.
If I use "D:\sims" in place of Z (as shown below) it works fine.
http://scoras10g.silcor10:7777/forms/frmservlet?form=D:\sims\testform.fmx

Please Note :
App Server Name : scoras10g
Domain Name : silcor10

Thanks.

jpn
Re: Unable to read mapped drive [message #281885 is a reply to message #281756] Mon, 19 November 2007 17:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Absolute addressing is not recommended. Actually, it often doesn't work as the system can not find any called form. Put the directory's absolute address into the 'formsweb.cfg' and just use the form name.

David
Re: Unable to read mapped drive [message #282410 is a reply to message #281885] Wed, 21 November 2007 23:09 Go to previous messageGo to next message
jpnanda
Messages: 5
Registered: February 2007
Junior Member
Would you please tell me the name of the parameter where I can define the absolute address in 'formsweb.cfg'. I tried the parameter 'workingdirectory', but didn't get any result.

Thank You.

jpn
Re: Unable to read mapped drive [message #282428 is a reply to message #282410] Thu, 22 November 2007 00:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What did you put into your 'workingdirectory'?

What do you have for 'envFile='? Hopefully, 'default.env'.

Have you defined anything in 'default.env' for 'FORMS90_PATH=' or 'PATH='?

Please post a sample piece of code showing your 'call_form' statement.

David
Re: Unable to read mapped drive [message #282465 is a reply to message #282428] Thu, 22 November 2007 01:20 Go to previous messageGo to next message
jpnanda
Messages: 5
Registered: February 2007
Junior Member
I tried putting d:\sims;z: into 'workingdirectory'.

I have made changes in 'default.env' by giving forms_path='d:\sims';'z:' .

I am giving the url directly (not using any call_form syntax here) as "http://scoras10g.silcor10:7777/forms/frmservlet?form=z:\testform.fmx" which is not working.
If I give
"http://scoras10g.silcor10:7777/forms/frmservlet?form=d:\sims\testform.fmx" then it works fine.

Thank You

jpn
Re: Unable to read mapped drive [message #282635 is a reply to message #282465] Thu, 22 November 2007 19:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I recommend NOT setting the 'path' variables in 'default.env'. There is also little or no point in specifying the path in the 'http' call, just get it right in the 'formsweb.cfg'.

Lose the quotes in the 'forms_path' of the 'formsweb.cfg'. You would only needs them if you had a space in the directory name and we know that spaces in directory names are not supported by Oracle Forms anyway. I can't remember whether you need the '\' or not, but you will only need to try two options to see whether it will work.

So, undo your change to 'default.env', change your 'http' call, and then remove the 'quotes' and '\' in 'formsweb.cfg'. Stop and start the forms server, and then test. If it fails, add the '\' back to 'formsweb.cfg'. Stop and start the server and test again. One of these two will work.

David
Previous Topic: show image on application brower page
Next Topic: How to manage the result of LOV?
Goto Forum:
  


Current Time: Sat Dec 03 22:25:16 CST 2016

Total time taken to generate the page: 0.07456 seconds