APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Installation & Configuration :
I am trying to import a file to Oracle, but getting an error "File doesn't exist".
Test 1:
Selected an APPXIO file that had 0 records.
Exported - Exported OK
Changed File Spec. to Oracle
Created File - File Created OK
Imported - Receive error - File Does Not Exist.
Tried to Create File again, - File already exists is message.

What may be happening is that you have used an FMS group to redirect the AppxIO files (in other words, the AppxIO files are not in their usual location when you do the export). That means that the Portdata files are not in their usual location either. When Appx tries to import (using your Oracle FMS group), it can't find the Portdata files (thus the File Does Not Exist error).

If that is the case, this is easy to fix. Find the FMS group that holds your AppxIO files (let's call that the APPXIO FMS group) it has an FMS type of 1. Make a note of the FMS Path for that FMS group. Now find your Oracle FMS group (let's say that one is named ORACLE) and it has an FMS type of 5. Now make a new FMS group (type 1 this time), but give it the same name as your ORACLE FMS group. In this new ORACLE (type 1) FMS group, enter the FMS path that you wrote down from the APPXIO FMS group.

That should take care of the problem.

The root of the problem is that Portdata files are always AppxIO files - when you try to import from Portdata into Oracle, Appx is using the ORACLE FMS group to find the Portdata files. Since you don't have a type 1 FMS group named ORACLE, Appx is looking in the default location for the Portdata files - and they're not there. Creating a new type 1 FMS group with the same names as your type 5 ORACLE group will give Appx a way to find the Portdata files.

[Append to This Answer]
2005-May-02 1:07pm
Previous: (Answer) What is the environment variable for identifying the Ethernet adapter for the APPX serial number?
Next: (Answer) How do I upgrade APPX 3.5 or 4.0 to version 4.2?
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=567
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.