topic Re: Unable to Export To Feature Class In Model Builder in Geoprocessing Questions

Unable to Export To Feature Class In Model Builder

MarkYoung — Thu, 06 Dec 2012 13:06:47 GMT

Hi,
I have a model whereby I wish to import an sde table, create xy events and export to a feature class. For some reason it says:
ERROR 999999: Error executing function.
Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000
] [GAZMAN.LLPG_BLPU][STATE_ID = 61588]
The index passed was not within the valid range.
DBMS table not found [ORA-00942: table or view does not exist
] [CORPDATA.LLPG_Logical1][STATE_ID = 61608]
The index passed was not within the valid range.
Failed to execute (Export XY Events To FC).

when it tries to export to a feature class. I know the feature class exists but what is the max number of expressions in a list - does that mean the max amount of attributes it can export?
Thanks in advance,
Mark

Re: Unable to Export To Feature Class In Model Builder

MichaelHarty — Wed, 12 Jun 2013 20:28:18 GMT

Mark,
Did you resolve your issue? I am having a similar problem when I try to import a .csv to convert it to a feature class in the model builder. I can create an xy event layer, but the copy features tool fails and says

The index passed was not within the valid range.

Not sure what this means.

Thanks,
Michael

Re: Unable to Export To Feature Class In Model Builder

MarkYoung — Thu, 13 Jun 2013 05:58:57 GMT

Morning Michael,
I think what I ended up doing here was to recalculate the spatial index. If you right click over the feature class and select properties, click on the index tab then recalculate in the spatial index section that may work. I am not sure why but every now and then I have to recalculate the spatial indexes of feature classes..
Hope that helps
Mark

Re: Unable to Export To Feature Class In Model Builder

MichaelHarty — Thu, 13 Jun 2013 14:27:58 GMT

Thanks a lot, Mark. Problem solved