« SWEFADP2 - Advisee list by Advisor | Main | SZRENR2: Enrolled Students Job Submission »
September 28, 2006
SSASECT Error: Cannot create, record already exists for section
Brian and I spent a fair amount of time this morning figuring out why the registrar's office couldn't add a new course. It was erroring out with the message "Cannot create, record already exists for section" when you try to use the "ADD" crn in SSASECT. We traced it down to the table SOBTERM, which seems to hold the last course that was created. When you use the "ADD" crn in SSASECT, it returns the field sobterm_crn_oneup + 1. Somehow a crn got skipped in this table and the crn that it was returning already existed in the table SSBSECT. So I just updated the table sobterm and incremented the sobterm_crn_oneup number by 1 and that seemed to fix it.
Posted by soukupm at September 28, 2006 10:25 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)