arcypy.da.InsertCursor error: Python int too large to convert to C long

Trippetoe

Hello. I am trying to get data from my AGOL account and insert it into an enterprise database (SQL Server).  I get the data via the ArcREST API from my AGOL table. I then use an arcpy.da InsertCursor to insert the data into a standalone table. 

I am get an error on insert when the AGOL data contains a date field. The error message is "OverflowError: Python int too large to convert to C long".

How can i use the arcypy InsertCursor to insert date data? Do i need to convert the 'ticks' that are returned from AGOL into a string date, e.g. '2017-09011' or some such?

Thanks.

Trippetoe

Hi Dan. Thanks for your reply.

I had seen the SO article you referred to and and had verified that my system maxsize was sufficient to cover the date ticks from the AGOL data (I am using python 3.x).  

I did stumble upon a solution to the problem, however. I used  a method from the ArcREST API

arcrest<SPAN class="punctuation token">.</SPAN>common<SPAN class="punctuation token">.</SPAN>spatial<SPAN class="punctuation token">.</SPAN>toDateTime‍<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

 to convert the ticks to a python date time object.  I then used that new datetime object in the InsertCursor.  So far, its working as expected.

Thanks again for your suggestion.