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 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)
November 27, 2007
FPAPURR
The copy button wasn't working on this form. Nothing was getting copied. I traced the trigger on the form to the library foqrpls. In here there was an insert on the table fbapohd. We broke the library on purpose to track the error down to this table. Then we tried to do the insert manually and tracked to the match_ind field. That rang a bell because it was the same field in a different table that caused a problem developing the new feed. Turns out the default value of 'U' didn't come across in the merge. I added it to the table and everything works normally.
Posted by wendlerb at 11:50 AM | Comments (0)
November 26, 2007
Thankgsgiving weekend
The database merge went very well this weekend. We actually opened the system up earlier than our best guess scenario. The INB menus came across doubled in a lot of places so we spent a fair amount of time cleaning them up. One problem has surfaced that is a real headache for the programmers. We can't seem to compile in the PL/SQL Developer editor and have to work around it. This makes debugging code a real pain. You can compile fine from command line
Posted by wendlerb at 9:54 AM | Comments (0)
November 13, 2007
woux path
Checking woux:[wou_mods] against woux:[ous_mods]
So far had issue with run_pzrcweb.com and run_pzpname.com. Changed submit from cedar$batch to spruce$batch.
Removed fzbmail.exe from woux:[wou_mods] Newer version in ous_mods.
Removed gurfeed.pc from wou_mods. Newer version in ous_mods
Checking on iitfeed
Removed pwpchkp.pc from wou_mods. Newer version in ous_mods
Posted by wendlerb at 11:01 AM | Comments (0)
November 6, 2007
wops link on wouupg
I did a search for wops on functions, procedures,packages, and views and found a number of things. There are a bunch of views that start with GENERAL_ or SATURN_ that use a wops link. It turns out these are necessary for the consolidation script. There are several wou packages that use the link. I took the link out of the code, made sure it compiled ok, and then stuck a copy of the source in the merged folder on my H drive. I put the old code in the SIS72 folder so I can get it again if needed. There are also a couple of packages written by a former programmer, Mark, that have been broken for a time anyway and I didn't fix them
Posted by wendlerb at 3:03 PM | Comments (0)
October 23, 2007
ftp_ous
This printer option didn't work in wouupg. The error message indicated the process made it to gjajobs_ftp.com ok and errored out there. Key pairs needed to be set up in wouupg for the sftp connection. Once the dbas did this, it worked ok. I'm having them set up wouprd now for this so we won't have to deal with it later after the merge.
Posted by wendlerb at 9:38 AM | Comments (0)
October 15, 2007
Employee tax packages
Bring over from wodv
bwpkxw2s
ppw2
pp_w2_2006
pp_w2_common
Posted by wendlerb at 8:25 AM | Comments (0)
October 8, 2007
Restricted list
baninst1
saturn
fimsmgr
wtailor
bansecr
oper
wendlerb
soukupm
vandeusm
whitenaf
silbernd
vickersb
lindj
dunkins
olsenk
hickersj
wongf
Posted by wendlerb at 10:47 AM | Comments (0)
September 18, 2007
Master To-Do List
Get max employee parking primary and secondary numbers - set seq in wouprd
Final Feed
Final AR Feed
Follow shutting down access to banner web blog
Wait on refreshes and new wouprd build
Get new max for fdoc number from feed and set in FOBSEQN
Get links changed to new INB link.
Make sure fabinvh_match_required is set up with a default of 'U'
Follow ID creation blog entry
Bring over employee tax stuff
Make sure forms are correct (GUASYST gets removed.)
Build correct menus using GUTGMNU
Open Banner Web
Follow Banner web blog
Open access to web for all
Change wops link in wou_util to wouprd
Remoce szpvpad from cron
Follow employee parking blog
Posted by wendlerb at 9:16 AM | Comments (0)
September 17, 2007
Shutting down access to Banner web
Giving access in order to get into Banner web by the dbas gives it to everybody. In order to limit it while I fix the menus I can do the following.
Login to what was student
go to web tailor and custimize twbkwbis.P_ValLogin
Only allow local role as Web tailor Administrator
Unclick Non Secured Access Allowed
Posted by wendlerb at 11:49 AM | Comments (0)
August 30, 2007
Employee parking
Need to add aero.world link
need to remove all wouprd references. One in html tag and others in link
use f_fa_transact from student not hr/fis
pwbpark synonym screwed up
check if sequences came across from wops
Need to check module ownership of procedures via webtailor
remove link on faculty tab
Posted by wendlerb at 2:56 PM | Comments (0)
August 23, 2007
Banner Web steps
Check to make sure baninst1 function f_payroll_employee_ind came from fis
Add employee menu (pmenu.P_MainMnu) to standalone_role_nav_bar. All three indicators need checked for it to work.
Add employee menu to main menu bmenu.P_MainMnu with all checked
Change header in global interface to WouHeader
Change text on bmenu.P_MainMnu to relect combined system
Bring over employee tax packages from wodv
Posted by wendlerb at 1:59 PM | Comments (0)
June 28, 2007
TGRFEED
I noticed in a test of the feed that the fdoc numbers started over back at 1 instead of the next number from the last feed in the sis database.
Looks like when finance is installed, tgrfeed is written to do things a little differently.
Fdoc numbers and state 1099 numbers come from fobseqn.
There is also a grant billing that gets done.
Posted by wendlerb at 11:17 AM | Comments (0)
June 13, 2007
SWBUGLF cont
Need to make sure fabinvh_match_required is set up with a default of 'U' or else FWRAPAY errors out on an insert statement. Sucessfully ran feed in wouupg. Removed the creation of the report zjrbaas along with copiying to archive. This is a report created by EOU. In the future, posting has to be going before swbuglf us run. Otherwise Fgrtrni won't do anything.
Posted by wendlerb at 2:50 PM | Comments (0)
June 11, 2007
SWBUGLF
I have a combined SIS/FIS filw that I've put in the woux path. Kicked it off this morning and looks lik the SIS half ran ok. I've run into problems with the set up of the FIS jobs for job submission on wouupg. Either the files not there or the object is not created, I had Jim move over the exe and obj files to woux. Need Faye to create fwriapp and fwrckno objects and access on wouupg. We also want this created on wouprd so it comes over in the merge. Have to talk to Jim about how to handle the directories.
Posted by wendlerb at 1:42 PM | Comments (0)
May 11, 2007
ID creation
Spent a fair amount of time figuring this out.
Packages:
GB_COMMON returned to baseline
GB_BIO use FIS mod
GB_IDENTIFICATION use FIS MOD
DML_SPRIDEN modified specifically for merged. Do not use FIS or SIS
Table triggers:
ST_SPRIDEN_INSERT_ROW modified specifically for merge
ST_SPRIDEN_DELETE_ROW modified specifically for merge
ST_SPBPERS_INSERT_ROW dropped in merge
FT_FTVVEND_INSERT_ROW return to baseline
Sequence:
GENERAL.PIDM_SEQUENCE set to number higher than max(spriden_pidm)
BANINST1.WOU_ZSPRIDA_SEQ set to number in wodv
Notes:
We are keeping the table generated V number to handle outside banner applications such as credit card admissions that create a person in Banner.
Tested generated person and generated coportation in PPAIDEN and SPAIDEN. Tested name change in PPAIDEN and SPAIDEN. Tested SSN entry in PPAIDEN and SPAIDEN. Have not tested SRAQUIK yet .
The spriden table trigger no longer makes use of SWBPIDM. There is logic now to see what form inserts the spriden record and then updates or inserts a spbpers record if coming from a student form. PPAIDEN does the insert automatically and will throw an error without this logic on the trigger. PPAIDEN has a problem if the pidm sequence is less than max pidm. It increments to an unused pidm but grabs some email info from the first attempt pidm and saves it with the latter one. SPAIDEN doesn't have that problem. Setting the seq above max takes care of it.
Posted by wendlerb at 11:10 AM | Comments (0)
May 4, 2007
Menus
Inserted gurobjs records into FIS/HR that were in SIS but not already in FIS/HR.
Inserted guraobj records into FIS/HR that were in SIS but not in FIS/HR
Added rights to new objects via Bansecr to class FINCORE
Built student menus on FIS using GUTGMNU.
Posted by wendlerb at 9:23 AM | Comments (0)
April 12, 2007
GJAJOBS
The gjajobs.com is different between FIS/HR and SIS so we will need to merge them. It was suggested at the last consolidation meeting that we keep seoerate files for each system which would get run depending on the job. This was turned over to WOU programmers because of time constraints. I merged both into one and have run it on wotr and woudev ok. Will try some checks.
Posted by wendlerb at 2:14 PM | Comments (0)
February 13, 2007
Web parking purchase
I renamed the package wou_park in SIS to wou_park_sis and created the webtailor entries. Student web now points to wou_park_sis. This was necessary because wou_park also exists on FIS/HR but has different mods. I will remove the old wou_park package from SIS when I know wou_park_sis works ok.
Posted by wendlerb at 3:21 PM | Comments (0)