« March 2006 | Main | May 2006 »
April 27, 2006
GUIEXTR form
This ran slowly. It populated using a view glvextr which need the compiler hint. It used spriden.
Posted by wendlerb at 3:29 PM | Comments (0)
April 24, 2006
CLM Soil
Ok, time for documentation. I had a number of issues with interest using the invoice table. The table is not current and caused a bunch of outer join headaches so I got the code CLM uses to calculate interest and used that instead.
I have a query soil4.sql the folder clm on my h drive. Run this from sql analyzer on winchester in sql server and save output to file called soil.csv This is important. You must sequence the sequence field yourself manually. Ftp the file to spruce and load it into the szasoil table using the control file soil.ctl From here you can run szrsoil to create a file szrsoil.lis which is in oregom dept of revenue format.
Posted by wendlerb at 10:04 AM | Comments (0)
April 18, 2006
Web aid release error report - Szraidd
I tested new code in wou_fa package and it worked correctly. I released aid hit the back button and tried again. The error popup came up telling me to see cashiers and it exited out to the menu. In addition I wrote a report, Szraidd, which checks aid released onto tbraccd. It looks for duplicate aid type detail code with identical descriotion fields for the term entered.
Posted by wendlerb at 8:57 AM | Comments (0)
April 17, 2006
Financial aid web release problem
Financial aid and the business office discovered 2 dtudents last term who released their aid online with problems. Some of the aid was loaded twice into tbraccd. This has never happened before. Their aiddecision shows multiple records on each of the codes but it's difficult to tell exactly what happened. The decision of the student is passed to a processing procedure as a list and it appears that the entire process is happening twice for some reason. I've added code to prevent double clicks on the submit button and to check if detail and detail description already exist for the aid released in the given term. Hopefully this will stop this from happening again in the future. I've emailed the students hoping to get a description of their session to get some clues on why this happened in the first place. So far one of them saod there were no duplicate check boxes but the pop up box didn't return right away after she clicked submit. I suspect a double click on the submit or hitingthe back button and resubmitting.
Posted by wendlerb at 10:28 AM | Comments (0)
April 12, 2006
Virtual Warehouse
We lost the connection to the listener on wilbur yesterday and had to track it down. This connection is made when logging into the current student model on our query tool Bi QueryThere is a password in a file in Jeremy's home directory on wilbur that gets looked at but it is a validation type of thing to the package on wouprd and not an actual login password. It matched what it expected so that wasn't it. The network boys turned off a lot of http functionality in favor of https so we suspected that as well. Sure enough, a line of code on oracle_obj_srsv.pl was making a call to http banweb. We changed the line of code to https on this located in Jeremy's directory on wilbur and it connected.
Posted by wendlerb at 2:04 PM | Comments (0)
April 10, 2006
Credit Card code
Some time last week it appears an old copy of wou_sis_util must have gotten placed into production. First clue of a problem came during fee payment when I heard credit card on admissions was not working. At the same time Darin got an email from ETS asking why we were using the test server instead of production. I found that we were indeed pointed at the test server and changed it to goudin. Then today I heard that the payment flag was not being set on an output from admissions. I looked at the code and found it pointing to a flag on a table on aero. Admissions runs on wilbur and could never have set this flag with it pointed to aero. Furthermore, all Jeremey's mods to lock the transaction while the credit card tansaction were gone. I put those mods back in. It's unclear right now exactly what happened.
Posted by wendlerb at 4:09 PM | Comments (0)
April 6, 2006
Shrediy and EDI Transcripts
The Banner job submission program, Shrediy, produces 4 dat files. SEDICTL.DAT, SEDIFLT.DAT, SEDILOG.DAT, and SEDISGN.DAT all get output to a directory usr$disk:[ban_woutst] for woutst. Unfortunately, this is a restricted directory and the only way to get the files moved into the spool directory is by using a com file via job submission called "Look". Summer doesn't have the access required to get the files. We eventually have to develop a sftp method to get the dat files to and from the SmartEDI server. For more info see Summer's blog
Posted by wendlerb at 3:23 PM | Comments (0)
April 5, 2006
AB Holds
The cron job that puts AB holds onto students is a jobsubmission script that calls the package wou_sis. Some people were getting holds that shouldn't be. The hold is supposed to go on when the student owes from a prior term. I also found logic that puts a hold on when the student has a balance current term and is not registered for any classes and does not have child care. The person we looked at met this qualification so I added a check to see if they had housing as well.
Posted by wendlerb at 11:34 AM | Comments (0)