Course.dat file throwing JBO-27127: The effective date operation for Entity LearningItemTranslationD
Content
I am trying to load courses to OLC through HDL. Some courses are getting uploaded fine but for few of them it is throwing error:
JBO-27127: The effective date operation for Entity LearningItemTranslationDEO will introduce gaps or overlaps. key=oracle.jbo.Key[300000013771781 2010-06-01 4712-12-31 US ]
Any pointers to resolve this?
METADATA|Course|CourseNumber|EffectiveEndDate|EffectiveStartDate|CoverArtFile|CoverArtFileName|CurrencyCode|SourceId|SourceInfo|SourceType|MaximumExpectedEffort|MaximumPrice|MinimumExpectedEffort|MinimumPrice|OwnedByPersonNumber|PublishEndDate|PublishStartDate|ShortDescription|Syllabus|Title|TrailerLiId|TrailerLiNumber|SourceSystemId|SourceSystemOwner
MERGE|Course|CN_612||2010/06/01|||JMD|612|EBS-HR_COURSE-612|EBS-HR_COURSE|||||100634|||The course is designed to teach participants the fundamentals of basic etiquette that apply to business and social life.||COM1004 - Fundamentals of Etiquette|||612|EBS-HR