Running the Document attach conversion for OLENotes utility in GP2015 - version 14.00.0707.00
Data appears to have exported.
However the import does not appear to be successful we have large numbers of failures trying to import PDFs we are getting the error
C:\OLEExport\HFP\0\000010B0\Embedding 3.pdf Error: Import unsuccessful. System.Data.SqlClient.SqlException (0x80131904): The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.
at Microsoft.Dynamics.Deployment.GP.OleNoteEngine.DocAttachProcessor.WriteCO00101(SqlConnection sqlConn, Guid attachmentID, String fileName, String fileDate, String fileTime)
at Microsoft.Dynamics.Deployment.GP.OleNoteEngine.DocAttachProcessor.InsertAttachment(String filePathAndName, String bizObjName, String dictionaryID, SqlConnection sqlConn, ImportDocResult& idl)
ClientConnectionId:0d0b5d85-78ea-41d8-b55c-6915ccfd569f
Error Number:242,State:3,Class:16
*This post is locked for comments
[quote user="Michael_Boyle"](0x80131904): The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.[/quote]
You might try changing the Region and Language Settings on the OS where the OLE Notes Migration Utility is being run on, to the English (United States) format.
This appears to correct it for me, i was using English (Australian) date/time format, as one normally would when one is in Australia. It seems the MS developers seem to think US date/time format is the universal standard for everyone :)
Any updates? we are having large numbers of errors due to the same error while importing.
"The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156