Hi,
I'm trying to have Snapshot process summer feed files (courses, enrollments, assignments) and it's saying it's invalid.
These courses are for the summer term (therefore, brand new and not created via GUI) and have an unique external_course_key. It's returning course_main_ak1 error.
Another possibility is: The course was created via snapshot but was passed in a file other than 212.COURSES.TERMCODE.txt
Now, could it be the fact that I had both COURSE_SPRING2012.txt and COURSE_SUMMER2012.txt, even though the external keys were unique?
Thoughts?
60713.201206|60713.CourseTitle.Summer2012|Course Title |N|ENABLED(!)java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BB_BB60.COURSE_MAIN_AK1) violated
ORA-06512: at "BB_BB60.COURSE_MAIN_CR", line 284
ORA-06512: at "BB_BB60.PROCESS_COURSE_INTEGRATION", line 483
ORA-01403: no data found
ORA-06512: at line 1
Julia,
course_main_ak1 is the index on the "batch_uid" field in the database, which is the same as the "external_course_key" in the feed file. If you're getting that error, it means that the batch_uid/external_course_key that you're trying to create already exists under a different data source key.
So, I'd check to see whether the courses you're trying to create already exist on the system, and what data source key they are associated with. This will be shown in the Data Source Key column of the admin panel course list.
Mike
MIke,
external_course_key are, I hope I'm sure, unique. Spring courses have 201201 and summer contain 201206 under external course key.
If Snapshot is accusing error course_main_ak1, which means ECK already exists. Could this maybe be an issue of Data Source Key? E.g. if requesting BB's support team to create a new Data Source Key for the Summer term and then attempt manual upload of feed files.
Thoughts?>