« August 2005 | Main | October 2005 »

September 30, 2005

weekly report #2

It been a really busy week with the term starting and all. Lots of phone calls the first couple days from people unable to get into banner. Ran several reports for various people, labels, DOR file, headcounts, etc. Scarf degree report is pretty much done, just need to double check the numbers. This year's scarf report has changed a bit, so I'll need to make those changes. I ran an update today on email addresses to get the new students since the last time I ran it. I'm almost finished with a web based registered students report for the network team so that I don't need to manually send those lists. I should have it done early next week.

Posted by soukupm at 03:52 PM | Comments (0)

September 28, 2005

Web client too new error

For the past two days we've had quite a few people getting a "Web client too new" error message when launching Banner SIS/FIS. The banner support team at OUS tracked it down to one of the INB servers that needed up to date patches. The patches were applied last night so users shouldn't get this message any more. If they do, you can fix it by clearing the Jinit jar cache on the computer by doing this:

OPTION 1:
(1) Close all IE browsers
(2) Open the control panel, and look for the Jinitiator Icons
(3) Double click the Jinitiator 1.3.1.13 icon, this loads the Jinitiator Control Panel
(4) Click on the "CACHE" tab
(5) Click on the Clear Jar Cache button, and choose "Yes"
(6) Try Banner7 again

OPTION2:
(1) Close all IE browsers
(2) Delete all files from the following folder: c:\Documnets and Settings\the_user_in_question\Oracle JAR Cache\*.*
(3) Try Banner7 again

Posted by soukupm at 07:31 AM | Comments (0)

September 22, 2005

Weekly Report

There used to be a trigger on the table saradap that defaulted the fee assessment rate to "Basic" for all new and updated records. Once we upgraded to 7.1, that trigger went bye bye. Luckily the code was saved in the dbprocs directory, so I just needed to run the script. It wasn't as easy as it sounds though. There were three functions and a view that also didn't make it over to production either. I was able to find those functions on woudev (6.1). I saved a copy of them on I:\programmers\Banner7sis.

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

September 21, 2005

Recent Training

Oracle 9i PL/SQL Basics (CD based)
Objectives
PL/SQL: An Introduction
Developing a Simple PL/SQL Block
Accessing the Database Using PL/SQL
Controlling Flow in PL/SQL Blocks
Composite Datatypes
Explicit Cursors
Handling Exceptions

Posted by soukupm at 08:16 AM | Comments (0)

September 16, 2005

Weekly Report #2

After running a new scarf report and looking at the totals, it seems that I'm still missing a lot of continuing licensure students. The reason they are dropping out of the report is that they don't have an effective date within 2004. Since I'm lacking on time to get this report done, I'll run the scarf report just on the population of continuing licensure students and get most of the required fields for scarf. Then store those pidms in a temp table and run a query on this population to get all their prior authorizations and endorsements and manually edit the scarf report to put these in. It's easier to do this since there's only 38 of them. I'd like to permanently fix it so I'll add this project to my list of things to do once the amount of requests slow down a little.

Posted by soukupm at 01:26 PM | Comments (0)

September 15, 2005

Weekly Entry #1

I had to fix the financial aid admissions load because it also was adding an extra space to the end of the line (should be width of 2000). I changed the database connection on wolfman for the directlending cron because Financial Aid is ready to load the loans for this year. It wasn't working at first and had a little trouble figuring out what was wrong because the code was hasn't been changed in a while. It ended up being that the new EDExpress database is now password protected. This needs to be set in the odbc connection parameter. I updated the budget report term code to fall 2005 and the section tally. Both of them seem to be working fine. I moded sfrslst becuase it was running too slow. It had about 21 cursors that was hitting the spriden table. I wrote a report to display all the new freshman for Ron so that he can add accounts for this term.

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

September 09, 2005

Weekly Entry #2

I ended up rewriting a portion of the licensure function for the scarf report because it wasn't setting the continuing licensure students report correctly. All I need to do now is write a piece of code to report the continuing licensure students that don't have an endorsement, which is a couple few.
A good thing about the scarf report is that it picks up all the data entry errors. Our reports are only as good as the data that was entered into the system, so we all want to make sure its entered correctly. Once I have the scarf code complete, I can use it as a basis to check other reports to make sure we are reporting the correct numbers.
Financial Aid's shared drive was migrated to the new server taday so I had to fix the cron jobs running on wolfman. Since they were running using aviation credentials, I had to have wolfman migrated to the new domain so that it can access the shared drive. I ran them manually and they seemed to work but I'll check again on monday to make sure they're ok.

Posted by soukupm at 02:53 PM | Comments (0)

Weekly Blog #1

Its been very busy this week since Banner was upgraded to 7.1. I came in on monday and added all the mods to web packages that needed them. Functions:
f_getspriden_id
f_format_name
Packages:
bwlkilib
bwckregs
soklibs
bwlkfcwl

I tested all the web applications to make sure they were working by tuesday, fortunately most of them worked. Tuesday was really busy. I reactivated the cron jobs on the server, had to manually run the research scripts so that morning refreshes will work from the cron job. Several people didn't have jiniator installed, so had to install a couple of those. Fixed a couple people's links to banner 7. Some folks were not able to run 2 sessions of Banner even though their internet explorer had the reuse windows box unchecked. I changed their links to launch explorer manually with the url to banner tacked on the end and that seemed to fix it. Spent lots of time tracking down various problems with certain forms: zfastwv,soilcur,sfaregq. I loaded the forms developer on my computer to get more familiar with moding forms. Loading this is not as easy as it sounds cause you have to completely uninstall all of oracle and then load the software, then grab all the shared libraries that banner uses, plus all the forms.

Posted by soukupm at 02:20 PM | Comments (0)

September 02, 2005

Weekly Blog #1

Some how my first blog disappeared into the digital black hole, so I'm rewriting it. (I checked my browser cache too and it wasn't in there either :( )
I spent a good potion of the week testing banner 7 and fixing the scarf degree report. We ran into a problem with the fee assessment where it wasn't calculating the correct tuition and fees for random students. After spending a lot of time on this, we ending up finding out it was because the tuition rates were not set for several of the tuition levels.
The scarf degree report is coming along pretty well. I've been spending a lot of time fixing missing data, various problems and learning how it all works. The report was never really tested until now, since last years report was in a different format. I ended up recoding some of the licensure function because it was dropping all of the continuing licensure students.
Financial Aid was migrated to the new domain this week. That seemed to go fairly well except some of their applications broke when their data was moved to another location. Overall, it was a very busy week since we're preparing to go live with banner 7 on Tuesday.

Posted by soukupm at 03:53 PM | Comments (0)

weekly blog #2

FIS/HR/SIS will be upgraded to Banner 7 tomorrow, hopefully things will go smoothly. I'll be coming in on monday and adding all the mods to the banner web applications that need it and testing all the procedures to make sure they function correctly, especially web registration. I turned off the cron jobs for this weekend to make sure they don't interfere with the upgrade and I'll test them manually on tuesday when we go live. The scarf degree report is almost complete and accurate, I just need to add in the degree code for the licensure students.

Posted by soukupm at 03:01 PM | Comments (0)