Select to view content in your preferred language

Automating Quick Import in python, 9.3.1 sp2

440
2
08-13-2012 11:18 AM
JohnBuzzard
Deactivated User
My goal is to automate the process of importing data from Views in an Oracle Database. I have built a model with modelbuilder in ArcGIS Desktop 9.3.1 SP2. The model utilizes the quick import tool available with the Data Interoperability Extention. The model runs great in ArcCatalog, but if I export it out into python, it throws the following error:

arcgisscripting.ExecuteError: Java reader not found -- no reader named `ORACLE8I' is available in this FME version
Tool execution failed.


Why will the tool run great from ArcCatalog, but not execute in python? Below is the python script I am using. I will leave out the connection information contained in the parantheses of the last line.

# Import system modules
import sys, string, os, arcgisscripting

# Create the Geoprocessor object
gp = arcgisscripting.create()

# Check out any necessary licenses
gp.CheckOutExtension("DataInteroperability")

# Load required toolboxes...
gp.AddToolbox("D:/Program Files (x86)/ArcGIS/ArcToolbox/Toolboxes/Data Interoperability Tools.tbx")


# Local variables...
DPWtest_gdb = "D:\\TEMP\\DPWtest.gdb"

# Process: Quick Import...
gp.QuickImport_interop(
0 Kudos
2 Replies
BruceHarold
Esri Regular Contributor
Hello John

Please log a support call for this issue, it will need to be reproduced in your environment for a response.

regards
0 Kudos
JohnBuzzard
Deactivated User
ESRI Technical support was eventually able to point me to a work around that was documented in a technical article. Ultimately the real issue was having both desktop and server installed on the same machine.

http://support.esri.com/en/knowledgebase/techarticles/detail/37392
0 Kudos