« July 2005 | Main | September 2005 »
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 10, 2005
CAPP Banner 7
CAPP in woutst is now working like production. There are a number of functions and procedures along with 1 package under the capp schema. Some of these had to be recompiled while logged in as capp. The kicker is 4 table triggers that we had to email Xiaobin to find. They are:
insert_sgrsatt_from_sordegr
insert_sgrsatt_from_shrtram
insert_sgrsatt_from_saradap
insert_sgrsatt_from_sgbstdn
These all had to be recompiled
Posted by wendlerb at 11:49 AM | Comments (0)
August 9, 2005
FZRRBLG
Rush building insurance value report....
Posted by wendlerb at 1:43 PM | 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 5, 2005
Capp stuff
Trying to update tables shrtrat and shrtatt with attribute codes for split courses. Have to do a triple looking for a record match on a table while b table has no match. List has undergone several changes to get closer fit. Faye will set up a couse and person to test before doing full update of database.
Posted by wendlerb at 7:56 AM | 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)