Solved

Opportunity - Incorrect datetime value: '4095-15-255 255:63:63.1048575'

  • 24 July 2023
  • 5 replies
  • 91 views

Userlevel 3
Badge

Hi Team,

We are getting the below error when an update is done on CROpportunity table.

“Incorrect datetime value: '4095-15-255 255:63:63.1048575' for column 'Tstamp' at row 1

Column tststamp on the table is defined as

`tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), 

from my understanding this means if there is no explicit value defined for tststamp, if any update happens the value for tstamp column should be set to current timestamp. Not sure how this invalid value is getting set.

 

 

icon

Best answer by vibindas 21 August 2023, 04:44

View original

5 replies

Userlevel 7
Badge +10

Hi @vibindas ,

Is there any customization published?

Try unpublishing the customization and check if the issue persists.

Hope, it helps!

Regards,

Sweta

Userlevel 3
Badge

@Chris Hackett , no luck so far.

Userlevel 3
Badge

we did furthermore analysis from our side and found out that there was a configuration change made on our db server (sql_mode is now set to STRICT_TRANS_TABLES).

While updating Opportunity there is a section of code that selects timestamp for the graph.

 

New restriction on the DB server could be the reason why it’s failing with Incorrect datetime value: '4095-15-255 255:63:63.1048575'. There is another way to set timestamp for the graph from db using PXDatabase.SelectTimeStamp() but unsure what are the underlying impact.

 

Userlevel 7
Badge

Hi @vibindas were you able to find a solution? Thank you!

Userlevel 3
Badge

Hi @sweta68 , 

Yes we do have Customizations, but we are not explicitly setting any values for the timestamp field.

 

Regards,

Vibin

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved