November 18, 2005
DML_SPRIDEN change to fix GENERATED problem
Made a change to the dml_spriden package today. Every once in awile on the student side we get errors caused by generating an id because a spriden record with GENERATED already exists. There's a post insert trigger on the spaiden form that deletes the GENERATED record so I'm not certain exactly why a GENERATED record gets left on the system. Anyways I fixed it so the existance of such a record won't cause problems with any new records till it gets deleted like before. This is all related to the fact that the call to the API for a spriden creation returns a rowid and that doesn't work in student because we're looking at a view.
Posted by wendlerb at 2:26 PM | Comments (0)
October 20, 2005
pidm creation
It turns out we were having a problem with the new logic that banner uses now to create the next pidm. It uses a squence now instead of the old sobseqn table. The two systems were each using their own pidm sequence which can get offset from each other. There is logic which looks at max pidm on spriden. There is a table,swbpidm, which contains crosswalk information on pidms between SIS and Fis. The spriden insert table trigger does not fire if this pidm exists in swbpidm. The problem happens when a purge process takes place removing spriden records. The corresponding records in swbpidm do not get removed. The pidm generation looks at max pidm on spriden and assigns it next one which is already in swbpidm. The table trigger doesn't fire and you end up with no V number generation untill you get past the last pidm in swbpidm. In order to fix this we are going to use the pidm sequence on wops for both systems through a mod to gb_common in wouprd.
Posted by wendlerb at 11:21 AM | Comments (0)
September 1, 2005
Fee Assessment (The crowd goes wild)
Ok, we got a fix. Required mods to 2 packages bwckregs and sfkfees.
First problem involved drops and fee reassessment. We finally discovered (with Jeremy's help) 3 tui detail codes that didn't have rules set up in SFARGFE for hrs 9, 10, and 11. We also had to set flags correctly in STVRSTS for drop codes. Now dropping on the INB form charges penalty and does new hours correctly and calcs penalty correctly 100% of time. The new fee assessment flag and withdrawl flag in rsts has to be on for penalty to work.
Second problem involved web drops. First there was logic in bwckregs that prevented drops if fee assessment flag was on. We commented it out. Then we found that penalty wasn't being charged. We found by investigating that penalty would be charged if student had a DC or DD already on their sftregs records for the term but not if they had none. The web drop removes records on this table before doing feeassessment. The sffkfees package has a p_post_rbt_penalties procedure that checks if a drop exists on the table before kicking off. Since the record was already removed, it never executed. We removed logic and let the process kickoff regardless.
Posted by wendlerb at 11:58 AM | Comments (0)
August 30, 2005
Fee Assessment cont
Not working again. This will prevent upgrade unless we figure it out. Been looking at problem for 3 days and still no closer...
Posted by wendlerb at 3:14 PM | Comments (0)
August 29, 2005
Fee assesment
We were having a problem with add/drops recalculating fees correctly. Sometimes the new credit hour amount was not calculating and the 50% refund was done as if they had dropped all hours. Theres a procedure called applyrules in the feeassessment package that actually looks at major codes. This thing wasn't working at all Friday and now was working for some this morning. I had turned on a swapping ind in SOATERM and had just developed a pattern when everything started to work. Marilyn had turned the ind back off after talking to PSU. I think the major/minor script we ran may have been one of the issues. Marilyn has also played around some with the rule codes so it's hard telling. The good news is we don't need the PSU mods in the SFKFEES package anymore and can go back to baseline.
Posted by wendlerb at 10:49 AM | Comments (0)
August 24, 2005
SAKMTCH
Add this to sis mod packages. This gets called by credit card payment from admissions package on Wilbur. Several of the procedures called didn't exist anymore on Banner 7x so I stuck them on there.
Posted by wendlerb at 9:11 AM | Comments (0)
August 23, 2005
GUASYST
GUASYST is a form used by SIS in order to tell if a person exists in FIS or HRIS. Baseline is designed for all systems being under one database. This won't work for WOU because the databases are seperate so I had to put a wops link into the form in order for it to work for us. The wops link prevents this form from working in a test environment. Naturally the form was hit in the 7.1 upgrade from 7.0 so I had to put in the wou mods again. However, we can't test this form till we go live.
Actually, I must have been on drugs when I copied mods from 6.1 form to 7.0 form. I missed a mod and thus didn't get in on the 7.1 form. The wops link was set up in woutst so now the form works.
Posted by wendlerb at 8:54 AM | Comments (0)
August 8, 2005
GB_BIO in PPAIDEN
PPAIDEN was acting wierd when bringing in a person created elsewhere such as SIS. When trying to save biographical information in spbpers, we were getting error message which was a constraint on pidm. No record existed in spbpers so tracking down what exactly was happening took a lot of time. First, spbpers has two table triggers on it that populate the corresponding SIS table. I thought maybe the trigger was locking up the record some how. However, the form error persisted even after disabling the two table triggers so that was out. The dml_spbpers is just a straight record insert. I looked at several osshe mods to the form which explained some of the other behavior we saw but still no luck . The characteristics of the error was unable to save record on first couple of tries. Eventually, however, the record would save after about 3 tries. I figured there must be some code in the form trying to call the insert twice since it doesn't commit till after coming back out of several packages. I put a commit immediately after the insert and then could never save the record correctly. However, one record was created with a null value in spbpers_ssn so I was right. I looked at the GB_BIO package and stuck an if statement in there to only insert if sspbpers_ssn was not null. This seems to have solved the problem. (after 7 hours of work).
Posted by wendlerb at 3:57 PM | Comments (0)
August 3, 2005
Shkrols
Add this to the list of SIS wou mods. This came up when in the form SFASLST. Changing or entering a grade worked fine untill you selected thr roll flag. Then it was taking 5 minutes to do a commit. The form called the package and I finally found the spriden selects that need the compiler hint. How many more are lurking out there?
Posted by wendlerb at 2:26 PM | Comments (0)
July 27, 2005
Sraquik and Saaquik
Version 7.1 mod has post-insert trigger added to spriden and generate id changed to work like Spaiden.
Posted by wendlerb at 10:49 AM | Comments (0)
July 19, 2005
SFVSTMS
Looks like Banner 7 has a few new views. This one is used by form SRAREGQ. Had to add compiler hint to it and form seems to run ok now.
Posted by wendlerb at 2:35 PM | Comments (0)
July 18, 2005
Web testing
Testing
Web for Faculty
Ran into some timeout issues with detail schedule but think it was more to do with bandev server
Did some web grading and it seemed to work ok
Student academic lookup worked just fine.
Section tally stuff was ok.
Did have to modify package nadintl which is behind Display student with IE hold. Changed to twbk…. From twgk…
Web for Student
Detail schedule worked ok
Registered for a Fall 2005 class and then dropped it.
Parking didn’t work but there’s no link to Wilbur so it wouldn’t
Print credit and wireless looked ok.
Address update worked
Web for Employee
Address update worked
Posted by wendlerb at 4:00 PM | Comments (0)
July 14, 2005
Goremal duplicate records
Since we moved to banner 7, Mike Staats ran into a problem when he tried to do a refresh which has implications when we go live. Duplicate email records in the table goremal caused the migration script to bomb out. The table now has unique constraints in Banner 7.1 so we had to remove these duplicate records from production. A script, DEDUP_GOREMAL.SQL, generates another script (dedup_email.sql) which deletes records based on rowid. You can see what records will be deleted by running dedup_email_list.sql and spooling the output. I suspect the new table constraint on goremal will have some effects on several student procedures that add email addresses to Banner.
Posted by wendlerb at 2:47 PM | Comments (0)
June 24, 2005
Fac Web
Several web for faculty packages weren't working in Banner 7.1 All I get is dreaded page not found error which means nothing. After looking through code, saw a function call to another package. Sure enough,found a bug in package SECTALL with statement twgkwbis.P_CloseDoc('1.1'); causing error in compile. Changed it to twbkwbis.P_CloseDoc('1.1'); and it seems to be working.
Posted by wendlerb at 11:46 AM | Comments (0)
June 6, 2005
SPAIDEN
Bug Description.
For records generated with no SSN, user goes back into form, types in V number,pages down into form, enters SSN into id field, and hits save. Spriden SSN record is created but the spbpers_ssn field is not populated. It works fine on a normal record creation. Only see problem with records already having a V number. Noticed form does not do the normal field updates after post insert. Tried a number of tricks in post-insert trigger to populate field but none worked. Found that if user tabs over to biographic screen and enters manually, everything works ok. Since screen is right there, Banner team decided to have user do this to solve problem.
Posted by wendlerb at 10:12 AM | Comments (0)
May 26, 2005
Testing Forms
WOU SIS databses are linked to WOU FIS/HR.
WOUTST and WODV are set up presently for testing Banner 7x.
In addition, ETS has set up an Oracle 10G form server that we have links to.
You can get the links from the Banner team if you require one.
Presently, I have developer for forms90 set up on a machine next to my desk.
You can view and test compiling with this.
Moving or getting forms from the ETS server is done through a secure web form which
secure ftps source forms from a folder in shared. I have passwords to do the operation.
Posted by wendlerb at 11:37 AM | Comments (0)
Banner 7 notes
Packages may be named the same between FIS/HR and SIS but the mods in them are
specific to fis/hr or sis. You can't load the package for dml_spriden
from sis and put it in fis/hr.
FIS/HR side
Table trigger on spriden changed to reflect new columns on table. Banner
passes info into spriden as a record type now so need new columns on trigger
for it to work. Wodv trigger has mod and works correctly
The package GB_IDENTIFICATION has a WOU mod on it. We want table trigger to
generate V number and not this package. Once again, Wodv has wou mod on it.
The packages DML_SPRIDEN and DML_FTVVEND have commit added to insert. See
Wodv Also GB_BIO modified
The form PPAIDEN has WOU mods on it clearly labeled. Search for WOU.
The form FTMVEND has OUS and WOU mods
The form GUAGMNU to fix scrolling problem. 1024 x 768 screen may allow
a return to baseline
Packages for Web for Employee address update, BWGKOGAD and BWGKOSDR, has WOU mods.
SIS side
The packages GB_IDENTIFICATION and DML_SPRIDEN have WOU mods on them.
DML_SPRIDEN is quite heavily modified. See Woutst
The form SPAIDEN has a number of WOU mods clearly labeled. Search for WOU
Forms GOQRPLS - this is a lib that has compiler hint added so typing in a ssn
doesn't take forever to change to v number in banner forms
Forms WOUCHEK,SFAREGS,TSAAREV,TSASPAY,SRAQUIK,SZZDCRV,SAAQUIK,GUAGMNU,GUASYST
Trying to return to baseline: SAADCRV,SFASLST,SHATAEQ
Web for Student address update packages, BWGKOGAD and BWGKOADR, have WOU mods
Packages NADINTL (twk... to twb...)
Packages BWSKOACC,BWCKGENS,SAKDCSN,SAKVAPL,SFKCURS,TTKFUNC,BWLKFCWL have LIX/Hick mods
Function f_format_name
General notes: You might run into an error that goes something along the
lines of "signature of package sys.dbms.... has been changed" It has to do
with baseline stuff needing to be compiled in the instance you are in.
Contact Mike Staats.
Posted by wendlerb at 8:41 AM | Comments (0)