Hi Everyone,
I'm using a python script designed to export Survey123 results from the cloud to an SDE. The survey has 784 columns and all columns are necessary. After testing and removing various columns, 599 columns runs successfully, while 600+ crashes and displays the following error. I have also removed all text fields and changed them to numeric but the code still crashes giving the same error message. Has anyone seen this before? Does anyone know a workaround or fix for it? Any help would be greatly appreciated!!
FAIL: Making Tables
exception:
ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Creating or altering table 'TEST675_TESTING_675' failed because the minimum row size would be 8547, including 84 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes.] [pwsd_survey123.DBO.TEST675_TESTING_675]
DBMS table not found [pwsd_survey123.DBO.TEST675_TESTING_675]
Failed to execute (CreateFeatureclass).
["ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.\nUnderlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Creating or altering table 'TEST675_TESTING_675' failed because the minimum row size would be 8547, including 84 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes.] [pwsd_survey123.DBO.TEST675_TESTING_675]\nDBMS table not found [pwsd_survey123.DBO.TEST675_TESTING_675]\nFailed to execute (CreateFeatureclass).\n"]
<class 'arcgisscripting.ExecuteError'>
568
----------------------
arcpy messages:
ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Creating or altering table 'TEST675_TESTING_675' failed because the minimum row size would be 8547, including 84 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes.] [pwsd_survey123.DBO.TEST675_TESTING_675]
DBMS table not found [pwsd_survey123.DBO.TEST675_TESTING_675]
Failed to execute (CreateFeatureclass).
