« October 2007 | Main | December 2007 »

November 29, 2007

Compiler hints and the database merge

The old compiler hint ( /*+ ALL_rows */ ) we added to our programs, packages, and views to speed things up seem to be slowing things down. I've been removing the ones that have been coming up as a problems so far. The other hints ( /*+ RULE */, /*+ driving_site(spriden) */ ) haven't been a problem so far. Eventually we'll want to remove them all from our programs. Some packages we'll be able to go back to baseline once we remove these.

Posted by soukupm at 4:38 PM | Comments (0)

November 27, 2007

PL/SQL developer compile error workaround

Since the merge this last weekend, we've been unable to compile via the editor window. PL/SQL developer would disconnect you once you tried to compile something. I looked online and found a workaround for the meantime so that we can compile again via the editor window. Go to Tools, Preferences, Debugger, and uncheck "Add debug info for connections".

Posted by soukupm at 12:38 PM | Comments (0)

November 15, 2007

Banner Web - Not Authorized Error

I got a call yesterday about a student that was unable to login to Banner Web to register. When the student tried to login, they got this message:
P_ValLogin OTHERS Exception - SQLCODE=-1422 ORA-01422: exact fetch returns more than requested number of rows

You are not authorized to use the Banner SIS Web System. Please contact the Office of the University Registrar at --- --- ---- for assistance.

It turned out the student had two spriden records with the spriden_change_ind = NULL (the query to fetch the student's roles returned more than one row).

Posted by soukupm at 11:29 AM | Comments (0)

November 8, 2007

WEBRESTTKT - Registration time ticketing

I added a new GTVSDAX value to Banner today called WEBRESTTKT, that controls whether or not a student can register for classes if they belong to a registration time ticket. Right now I have it set to N so that a student can register if they are not in a registration group ( so I can iron out the bugs). For winter 2008 registration, I'll set it to Y, so that it prevents all registration unless a student belongs to a registration group. I will also change the way I setup time tickets for next term. Instead of using last terms registered students as the population, I will be using all active students in SGBSTDN (sgbstdn_stst_code = 'AS'). This will help control who gets to register when and prevent students from registering early when they're not supposed to.

Posted by soukupm at 10:54 AM | Comments (0)

November 6, 2007

SOREMAL - fixed for asterisks in pin numbers

I finally figured out why SOREMAL (batch email process) was crashing when it hit an asterisk in someones pin number when sending out registration emails. It was using these asterisks to identify the last character of a line in an array. So when it hit one of these, it was returning an incorrect end of the array (strlen( ) wasn't returning the true end since it returned the length of the first asterisk it hit). It's fixed now and looks for the last occurance of an asterisk.

Posted by soukupm at 3:57 PM | Comments (0)