Unable to Export To Feature Class In Model Builder

673
3
12-06-2012 05:06 AM
MarkYoung
Occasional Contributor
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
0 Kudos
3 Replies
MichaelHarty
New Contributor
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
0 Kudos
MarkYoung
Occasional Contributor
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
0 Kudos
MichaelHarty
New Contributor
Thanks a lot, Mark.  Problem solved
0 Kudos