« November 2007 | Main | January 2008 »
December 31, 2007
Finaid duplicate runs
The cron jobs ran more than once 3 times last week including swbrdll, the direct loan load. ETS confirmed and fixed the problem last Friday. Apparently, jobs were kicking off a couple of seconds too soon for some reason and then kicking off again at the correct time. Anyway, direct loans loaded multiple times for 7 people on the Dec 28 run. While the Business Office took care of tbrmemo manually and put a hold on the students, direct_pre_memo was still scewed up. This in turn caused financial aid adjustments to not load because multiple rows were being returned in a net amount select.
Posted by wendlerb at 2:35 PM | Comments (0)
December 19, 2007
Additional WOU Consolidation Issues
Note: Reposted from ECS
1. Cron Job user permissions (the Feed to Finance, maybe other processes).
Now some HR/FIS processes are run from CRON by the SIS Cron Oracle User
(BAN_WOUPRD). BAN_WOUPRD needs additional Banner Security privileges
to be able to run these processes. Testing was done with a regular
Banner user rather than the CRON BAN_WOUPRD user, so this problem
didn't show up in testing.
2. Unique indexes in SPRADDR and SPRTELE have seqno as part of the index, and in SPREMRG
have priority. Sometimes these values had to be edited in HR/FIS in order for the
record to load into SIS.
3. GOBTPAC uniqueness constraint kept some PINs from coming over, had to do workaround.
The gobtpac_external_user value in HR/FIS is not synced with the value in SIS, so
duplicates values may occur between the two systems, even though they can't occur
within any one system ( the system appends a number to the value to make it
unique if a duplicate is encountered during PIN creation).
used sql below to fix, testing found no problem with having a null gobtpac_external_user.
update gobtpac@&&HRFIS_LINK hrfis
set GOBTPAC_EXTERNAL_USER = null
where exists (
select 1
from gobtpac sis
where sis.GOBTPAC_EXTERNAL_USER = hrfis.GOBTPAC_EXTERNAL_USER);
The null value allows these records to be loaded.
4. Banner User Security: pre-consolidation, WOU made sure that each Banner user with an
account in both SIS and HR/FIS had the same userid. Then security roles were merged
during consolidation. Roles are applied in alphabetical order, so it's possible that
a low-alphabet letter role will override settings in a higher alphabet letter role.
This has not been a problem so far.
Posted by wendlerb at 2:30 PM | Comments (0)
December 18, 2007
Feed SUBUGLF documentation
Feed status file created
Step 1 - moved to end of script
Step 2 - zjrbcf2.sql captures starting run date of feed
Step 3 - zjrbcf3.sql old close and finalize cashier sessions this has been commented out and is now done via tgrclos which gets executed just before the feed starts.
Step 4 - zjrbcf4.sql - deletes all records in gurfeed and gurapay
Step 5 - tgrunap.exe - unapplication of payments
Step 6 - tgrappl.exe - application of payments
Step 7 - tgrcshr.exe - cashier summary report
Step 8 - tgrfeed.exe - feed process
Step 9 - zjrbcf9.sql - feed number captured for archive file naming
Step 10 - zjrbc10.sql - this updates doc codes to match check codes between gurapay and tgrzchk on student checks. It also sets the feed indicators on tgrzchk
Step 11 - zjrbc11.sql - creates gurapay extract file for archiving FGPxxxx.dat Also is where the gurfeed trans date gets updated to sysdate
Step 12 - zjrbc12.sql - does gurfeed file FGUxxxx.dat
Step14 - report files copied and archived Postage feed done with arpost.com
Step 14B - furfeed.exe - fdocs report
Step 15 Balancing Reports
- zjrbart.sql
- zjrbira.sql
- zjrbaad.sql
- tgrrcon.exe
Step 16 Gurfeed and gurapay archived
Step16B FIS Stuff
- fwrapay.exe - invoices for student checks feed
- fgrtrni.exe - Transaction Input and Journal entry
- fgrtrnr.exe - transaction error report
- fwriapp.sql - autoapprove docs
- fgractg.exe - posting
- fwrckno.sql - Insertion of starting check number to FATCKNO table. Note that this aborts here and sis checks won't get the accounting piece when accounts payable does not complete the accounting on a check run.
- fzbchks.exe - batch check selection
- fzbchkp.exe - batch check printing report
- fabchkr.exe - batch check register report
- fabchka.exe - barch check accounting
- fgractg.exe
Step 17 print feed reports
Step 18 more archiving reports
Step 19 close status file
Posted by wendlerb at 9:35 AM | Comments (0)
December 14, 2007
SOAIDEN
I moded this form to display Xs in the first 5 digits of a ssn. I did this by creating a spridenx view of spriden under baninst1. Then I changed the spriden block parameter definition on the form to look at spridenx instead of spriden. The drawback is you can't query a person with a ssn in the id field. It is currently in the upg path. Add SOAIDNS as well
Posted by wendlerb at 2:00 PM | Comments (0)
December 11, 2007
Merge gotchas
Here were some of the issues the local programmers and functional folks delt with merge weekend and after. Note that Jeremy knows about most of these now as well and has already tweaked his script
Overall:
If you use PL/SQL Developer, compiling stopped working after the merge. Turned out to be a debugging checkbox in the preferences but drove me crazy till we figured it out.
You're going to have a lot of small issues post merge that each take time to track down and figure out.
Banner Web:
We worked this out in test runs and had no real issues. My blog contains the steps you need to take. We had an issue with a couple of students getting on the web when we didn't want them to but it was because I didn't uncheck one of the security roles that came in checked post merge.
INB Menus:
There is an SCT bug that hits when you rebuild the menu hierarchy with GUTGMNU and it behaves differently one database instance to the next. So everytime you run a merge, the menus look different. The production merge caused a bunch of duplicate menus that didn't look anything like the previous test runs. We had to just go through and fix them individually with GUTGMNU.
Payroll:
Make sure gtvsdax values come across from HR. This affected address on check and benefits. We thought we would just use the sis settings but it turns out there are some in fis/hr that don't exist in sis. Pay attention to credit card stuff.
HR:
Birthday century came in with wrong century for some records. Preferred name had some funky value in the null records. Fixed manually and it appears only spbpers got hit.
Finance:
Three tables have a match_ind field set with a default of 'U'. This needs to be the same in the merge instance or else you will have problems with POs, invoices, and posting. We knew about 1 but now know about other 2. They're the header tables.
General:
The change in the job submission directory structure caused us quite a few issues we didn't see in test. We had to debug 15 yr old code in some cases. FTP, sqlloading, and portrait printing all stopped working correctly. Turned out we needed a record in the table gwrdest that didn't come across in the merge because we decided to use values from fis. This took care of ftp and sqlloading from job submission. Portrait and special wou printing only affected job submissions set up as a procedure. We moded an old com file that handled printing to fix it but am not really sure why it became an issue. Had to do with libraries.
Student:
Our main issues here came from the change in directory structure. Found some old,old com files hard coded to old structure. Make sure you have current versions of local job submission programs in new directory structure.
Feeds:
Make sure you set the fdoc sequence in FOASEQN. This is where tgrfeed gets its number for fdoc. I rewrote swbuglf to handle all the feeds including postage feeds. I ran into security setting issues in wouprd because I always ran swbuglf directly out of job submission in test. The bansecr rights for all the jobs need tweaked when running in a cron.
Security:
We had a few userids (4) that didn't come across in the merge. Rebuilt manually
3rd Party apps:
Banner runs faster now. This caused us a problem with our admissions app double charging credit card transactions. We had error checking to handle double mouse clicks but none of it worked post merge. We finally disabled the button after the first click and that seems to have solved it.
Posted by wendlerb at 9:47 AM | Comments (0)
December 6, 2007
Postage
The postage feed is done about once a month. The old feed does not work in the new merged database. ETS gave me access to the arfeed$coms directory so I could see the old code. This was the file arwosc.com It made use of a control file gurfeed.ctl and used the data file in arfeed$wosc. Here the fguxxxx.dat file gets renamed to gurfeed.cln. The load runs, the file gets archived and then gets deleted. I created arpost.com with code from arwosc.com and debugged it in woudev. I got it to work and then added a line @gen$com:arpost to swbuglf just before step 14. Arpost got created as an objext and needed oper$sys and oper to have rights
Posted by wendlerb at 3:47 PM | Comments (0)
December 5, 2007
7.4/7.5 SIS database packages
bwckcpmt - this is credit card stuff. Nation code not used in validation procedure
bwckfrmt
bwckgens
bwckregs
bwckschd - has spriden hint on advisor cursor. Trying back to baseline
bwlkadvr
bwlkffgd
bwlkftrn
bwskapmt
bwskfcls - Trying back to baseline
bwskoacc
bwtktxns
dml_spriden
gb_bio
gb_identification
goklibs
sakdcsn - ?
sfkedit
sfkfees - need to test part of term ending 2099
shkrols
soklibs - Trying back to baseline
Posted by wendlerb at 2:48 PM | Comments (0)
December 3, 2007
Initial 7.4 review
I have looked at the packages in wouupg and just about every major student process got hit including all the id generation stuff. Fee assessment got hit as well. I counted 65 web packages got hit. We have mods on 12 of them. There is a change on a payment procedure that affects about 5 packages that I'll have to look at. One question I have is who checks all the fis/hr packages now? Do I get the OUS mods from ets and compile them myself? FIS got hit hard.
Posted by wendlerb at 3:21 PM | Comments (0)