topic table to table error in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/table-to-table-error/m-p/845082#M4961 <HTML><HEAD></HEAD><BODY><P>I have been debugging an issue for the past couple of days when trying to import a table from a file geodatabase to our enterprise geodatabase in ArcCatalog 10.6.1. The message that was received was a super unhelpful ERROR 000224: Cannot insert features Failed to execute (TableToTable). I had tried numerous things to complete this TableToTable with no avail. Then suddenly I remembered that I can set the environment variable on my machine to see more information if I set the SDEINTERCEPT environment variable. After looking through the file that is produced by setting the SDEINTERCEPTLOC environment variable I was able to find the real error. The actual error was ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME"). This error needs to be found easier. The amount of text that I had to go through to find the actual error was far too much to find why the import failed.&nbsp;</P><P></P><P>Here is my question, is there a way to set the result messages in ArcCatalog 10.6.1 to show the database errors?</P></BODY></HTML> Fri, 08 Nov 2019 18:31:37 GMT AronSaylor 2019-11-08T18:31:37Z table to table error https://community.esri.com/t5/geodatabase-questions/table-to-table-error/m-p/845082#M4961 <HTML><HEAD></HEAD><BODY><P>I have been debugging an issue for the past couple of days when trying to import a table from a file geodatabase to our enterprise geodatabase in ArcCatalog 10.6.1. The message that was received was a super unhelpful ERROR 000224: Cannot insert features Failed to execute (TableToTable). I had tried numerous things to complete this TableToTable with no avail. Then suddenly I remembered that I can set the environment variable on my machine to see more information if I set the SDEINTERCEPT environment variable. After looking through the file that is produced by setting the SDEINTERCEPTLOC environment variable I was able to find the real error. The actual error was ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME"). This error needs to be found easier. The amount of text that I had to go through to find the actual error was far too much to find why the import failed.&nbsp;</P><P></P><P>Here is my question, is there a way to set the result messages in ArcCatalog 10.6.1 to show the database errors?</P></BODY></HTML> Fri, 08 Nov 2019 18:31:37 GMT https://community.esri.com/t5/geodatabase-questions/table-to-table-error/m-p/845082#M4961 AronSaylor 2019-11-08T18:31:37Z