April 4, 2007
Web grading
I've added a menu choice to the faculty menu to maintain the web grade change request queue. I've given access to it to user roles registrar and webtailor.
Posted by wendlerb at 11:24 AM | Comments (0)
March 21, 2007
Web Grading
The registrar let us know that the W grade was showing up in the drop down list of available grades to give a student on the web grading package. This is package bwlkffgd. We had set this up last year and got it to work. I looked at the cursor SHRGRDE2C and noticed it changed quite a bit on the 7.3 package which came in since we last looked at it. The effective date logic of the cursor was incorrect so I fixed it and it looks to be working ok now.
Posted by wendlerb at 10:48 AM | Comments (0)
September 20, 2006
Tgrappl
I put the /*+ Rule */ compiler hint into this job submission program and it sped up substantially.
Posted by wendlerb at 1:50 PM | Comments (0)
September 8, 2006
Tgrfeed and Tgrclos
We have been unable to get a feed since the upgrade. We could tell the cursor was stuck at f_query_one_lock in the package tb_receivable. The code looked ok but did have this or piece with rowid and pidm. Apparently when running in a plsql block it had trouble with it. Jeremy added a /*+ rule */ to the statement and it did the trick.
Posted by wendlerb at 1:15 PM | Comments (1)
August 1, 2006
job submission updates
Wou mod changes need put in 7.3 when we go live.
Currently in woud
shrastd
swbrdll
swbrpfd
phpmtim
sfrfasc
shrtaeq
shredir
shrediy
Posted by wendlerb at 3:04 PM | Comments (0)
July 27, 2006
Feed testing (cont)
Woudev
TGRAPPL contunued to be slow
Jeremy and I stuck and driving site hint on sfvstms instead of all rows and we looked at code and saw some text in a compiler hint in the program that could have been causing the hint to not work. I removed offending text and we reran.
Took 20 minutes
Posted by wendlerb at 11:15 AM | Comments (0)
July 21, 2006
Feed testimg
Woudev
Tested swbuglf process after cashiers did some sessions.
Lot of problems:
TGRCLOS would never complete. I had to close manually and the run it to finalize.
Swbuglf hung up on TGRAPPL, application of payments. It ran from 9 am to late at night. Had to kill it. In order to rerun you have to do the job delete thing
DELETE FROM GJBPRUN
WHERE GJBPRUN_JOB = 'TGRAPPL'
AND GJBPRUN_ONE_UP_NO = -1;
Tried it again and was getting the same thing so I killed it.
Placed ver 7.1 in woudev path and it completed taking about 35 minutes.
I will try again afterdb refresh next week.
Posted by wendlerb at 2:59 PM | Comments (0)
June 15, 2006
Loan feed
Tbrmemo has added 3 new fields. Tbraccd remains the same
SWBRDLL and SWBRPFD have changes to them and are located in woud:[wou_sis_mods.c] These will need to be moved into production when we go live.
Posted by wendlerb at 11:34 AM | Comments (0)
June 14, 2006
Woudev
Wou mods placed on packages
compiler hint added to all views with spriden
Forms compiled in upg path
Menu fixed
SZZDCRV - the baseline has changed so much I can't even put wou mods on new version
GUAGMNU - returning to baseline
SPAIDEN - tested with ssn, generated, name change, and corporation.
Posted by wendlerb at 2:50 PM | Comments (0)
June 12, 2006
WOUDEV/WOTR
This is at 7.3 now. It looks like id stuff hasn't changed since 7.2 version which would be good news. Form server not quite ready so can't really test yet this morning. Hoping we might be able to take some stuff back to baseline. Checking the views now.
Posted by wendlerb at 11:14 AM | Comments (0)
May 3, 2006
Upgrade - Prelim SIS
SIS
Packages: 7.2 version?
ACADHIST
BWGKOADR Y
BWGKOGAD Y
BWLKOIDS Y
BWSKFCLS Y
BWTKTXNS
SAKMTCH Y
BWCKGENS
SFKFEES Y
BWCKREGS
BWLKADVR
BWLKFCWL
BWLKFFGD
BWLKFTRN
BWLKILIB
BWSKAPER
BWSKOACC
DEHOLD
DML_SPRIDEN
GB_IDENTIFICATION
GOKMAIL
SAKDCSN
SAKVAPL
SFKEDIT
SHKROLS
SOKLIBS
TTKFUNC
Views:
SFVSTMS
GLVEXTR
SMVRQCM
SPRIDEN
many more
Forms:
SPAIDEN
TSASPAY
TSAAREV
WOUCHEK
GOQRPLS
SAADCRV
SAAQUIK
SFAREGS
SFAREGQ
SRAQUIK
GUASYST
SZZDCRV
SOILCUR
Posted by wendlerb at 11:05 AM | Comments (0)
Upgrade - Prelim FIS/HR
FIS
Packages:
BWGKOADR
BWGKOGAD
GB_BIO
GB_IDENTIFICATION
DML_SPRIDEN
Table triggers:
Spriden
Swbpidm
Forms:
PPAIDEN
FTMVEND
Posted by wendlerb at 10:39 AM | Comments (0)