Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Bulkload doesn't load records with datetime-tz field

« Go Back

Information

 
Article Number000093461
EnvironmentProduct: OpenEdge
Version:11.7.3
Other: proutil
Question/Problem Description
Bulkload doesn't load records with datetime-tz field.

Just the records with datetime-tz field with an adjacent character field that includes a "+" sign fail to load.


 
Steps to Reproduce1.- Create a table with with datetime-tz field and a character field
2.- Dump the .fd file for the Bulkload description.
3.- Create a .d file with the following content:
2018-07-26T10:30:38.731-04:00 "Copy+Delete"
4.- Use proutil's bulk load to load the record.
Clarifying Information
Error MessageERROR - Invalid time zone format. Use MM-DD-YYYY HH:MM:SS.SSS+HH:MM for datetime-tz format (12104)
>> ERROR READING LINE #1 (OFFSET=0) (1527)
Defect/Enhancement NumberOCTA-8691
Cause
Unknown at the time of this writing.
Resolution
Upgrade to OpenEdge 11.7.5
Workaround
Exclude the "+" sign in the adjacent character field.

Or move the character field position so it is not next to the datetime-tz field.
Notes
Attachment 
Last Modified Date12/20/2018 3:44 AM