Skip to main content

Hi, all.

I've followed all the steps to copy (pull+push) data between two teams that are detailed in the documentation in pycelonis: https://celonis.github.io/pycelonis/1.7.6/tutorials/api_tutorial

 

The transfer of data is ok but when I process the data model in the target team I get the next error: The load failed: Load failed. Error Message: Timestamp column "_CEL_SF_CASE_ACTIVITIES"."EVENTTIME"] of activity table "_CEL_SF_CASE_ACTIVITIES"] must be of type DATE, but got INT].

 

It seems that the "push" loads the eventtime data as INT type instead of date time type.

An example: the time stamp 15/11/2022 12:02:00 of the source tabla is loaded as 1668681300000000 in the target table.

 

I've checked the source data when extracted in the pandas dataframe before uploading it ot the target table and it's OK.

I've checked the data once loaded and it's NOT OK.

 

Any help??

 

Thanks!

 

 

 

Hello @luis.carra12 , do you mind share the complete code or main code where error happen? Also have you check the table structure and ensure column data type is DATE?


Reply