Monday, September 23, 2019

GP - A get/change operation on table 'ivexceptiondays' failed accessing sql data. Conversion failed when converting date and/or time from character string.

SQL Profiler shows an error like this

exec TWO.dbo.zDP_IV41001SS_1 '-4714.11.25'

SELECT TOP 25 EXCEPTIONDATE,DATETYPE,DEX_ROW_ID FROM TWO.dbo.IV41001 WHERE EXCEPTIONDATE = '-4714.11.25' ORDER BY EXCEPTIONDATE ASC

Most likely this stock count was imported, or marked as verified using an sql script or some external method that did not set the Countdate and counttime on the stock count lines.

Run these scripts to set a proper date and time, update with the values you need. Add filters if you have a specific count only.

update iv10301 set countdate = '2019-09-23 00:00:00.000'
update iv10301 set counttime = '1900-01-01 06:51:16.000'

No comments:

Post a Comment