When I am inserting data into my activities I get "Execution error: ERROR: Column "event_time" is of type timestamp but expression is of type varchar" error but both columns are in timestamp only. Can you please suggest

Hi Abhishek,

Could you post your code. You may be missing a column in your column insert order or may have the ordering of the columns in the statement incorrect.

Hi

I have the similar problem.

Error message: "Execution error: ERROR: Column "EVENTTIME" is of type timestamp but expression is of type int"

Details:

• I did the csv import of the salesorderheaders successfully (for PoC resons)
• Created and inserted data into the
  • master activities table successfully
  • create sales order table successfully
  • sales order item delivered successfully
• I got the error message when I came to the FixedDueDate. I did the insert in the master acitivities table with the "OrderCreateDate" and the "ConfirmedReceiptDate" but the FixedDueDate does not work although it comes from the same csv import and is also defined as datetime datatype.

Please let me know if you need more details.

Thanks for your help

Dieter