Skip to main content
Participating Frequently
Feb 29, 2024 12:09 PM UTC
Question

Incorrect date value

Hi All,

While writing the  data to records via a pm , i am getting the below error 

Unable to write to or delete from the source due to system error.
Error Details: Incorrect date value: '292278994-08-17' for column 

 

Can anyone guide me on this issue ..

Thank You

5 replies

stefanhelzle0001
Brainy
Feb 29, 2024 12:15 PM UTC

Without more details, we could only say what the error message already does.

harshitb6843
Brainy
Feb 29, 2024 12:18 PM UTC

Can you add the screenshots of the Write Record smart service configuration and the data you are trying to delete? 

Participating Frequently
Feb 29, 2024 12:37 PM UTC

harshitb6843
Brainy
Feb 29, 2024 12:38 PM UTC

Nah. You already posted that error. I mean show me the data you are trying to write - Process Variables. And to double-check, the data type of the column in DB and in the record is date. Correct?

Participating Frequently
Mar 10, 2024 6:01 AM UTC

Thanks for updates , 
After investigating, i came to know its an  Epoch & Unix Timestamp, 

Issue was solved