Table Select ERROR 000224: Cannot insert features

Discussion created by pbuxton on Mar 19, 2014
Latest reply on Mar 20, 2014 by pbuxton
I am using the Table Select tool within a model and it keeps returning ERROR 000224: Cannot insert features. The Help file suggests this error relates to mis-matched field definitions between input and output tables. The source table is being accessed via an ODBC connection to an Oracle database and has about 12 million records. The tool includes an SQL query which reduces the number of records returned to around 9 million. If I modify the query to return a small subset (~200 records), the tool works and I get no error - so I suspect the issue has nothing to do with field definitions. If I run the tool in an ArcMap session instead of a model, it works perfectly - but I need it to run in a model.

Any suggestions would be welcome.