« SSBSECT/SSRMEET/SIRASGN trigger mods | Main | Christmas Vacation »
December 14, 2012
SAAADMS/SAAQUIK trigger error in test
The Banner team ran into a trigger error while updating a record in SAAADMS and SAAQUIK in TEST. I traced the error to a trigger that updates the student PIN number record in GORPRAC. The trigger looks through an audit table in GORPAUD to see if an external_user name has already been used. The table was missing some records (which may have been manually deleted) so it used an external_user name that's aleady been used and through a constraint error. I ran a sql script from Sungard that recreates those missing records and it seemed to fix the error.
Posted by soukupm at December 14, 2012 2:33 PM
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.)