Document Attach OLE conversion utility

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (0)

Suggested answer

Steve Rodionoff 261 on at

Like (0)

Report

RE: Document Attach OLE conversion utility

[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 :)
Steve Rodionoff 261 on at

Like (0)

Report

RE: Document Attach OLE conversion utility

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."