« March 2008 | Main | May 2008 »
April 30, 2008
WOUCKIN
It's become apparent that we need to have some type of check in monitoring of stuff going into production. I thought it'd be easiest to create a local Banner form to keep track of it. I created the table wouckin under baninst1 for starters with seven fields and gave a unique index on item and version. I used stvatyp as the starting point for a new form since it seemed close to what I wanted. The new form is called WOUCKIN as well and we are going to make the effort to keep it updated.
Posted by wendlerb at 2:35 PM | Comments (0)
April 24, 2008
Fgbtrnd/fgbtrnh archive process (cont)
Archive process: Foparcp
One fiscal year creates a huge file almost the size of my home directory. FY 96 took about 2 hrs to process.
Run with the perform bank reconciliation and perform grant edit parameters set to N. Otherwise you end up with some records only partially archived.
Process aborted on third year do do index tablespace size on an index. Tables are under the fimsarc schema.
Restore process: Foparcr
Seems to take longer
Run table is fobproc
Posted by wendlerb at 2:45 PM | Comments (0)
April 23, 2008
Billing
To reset billing
set statement date, due date, and bill date on tbraccd records you want to redo
Posted by wendlerb at 2:34 PM | Comments (0)
April 16, 2008
Innovative invoice vouchers to Banner
I got a call from the library telling us their process for transfering invoice vouchers to Banner was no longer working since the move to the new boxes in Corvallis. The library runs a software called Millenium Aquisitions from Innovative. They process some vouchers and then there is a ftp screen that transfers it over. I clicked the secure transfer button and had them change their password on zeus but it didn't work. They had been going to cedar. The library needed to install a patch on their system for sftp. Once done, it seems to be working fine.
Posted by wendlerb at 10:58 AM | Comments (0)
April 14, 2008
Phpcalc and PHAADJT
When payroll was trying to do a manual check on PHAADJT, they were getting an oracle error when they ran the payroll calc option. The error message was a delete record error. Investigating the trigger showed a deletion occuring on gjbprun after calc got run. We noticed gjbprun records for phpcalc going to Apr 10 when none should be found so suspected phpcalc was bombing. Running it directly from command line gave the error:%DCL-E-NOTFR, no transfer address
The dbas trued to recompile phpcalc using a cobol script but it errored out. They copied a working copy on Zeus over to Apollo to get us running
Posted by wendlerb at 1:12 PM | Comments (0)
April 10, 2008
cron and sleep/wake restarts
Wouprd no longer goes through a cold restart every night for backups. It only does a cold restart now on Saturday mornings. This means if you start a DS it doesn't terminate till Saturday morning. If you kill a cron job, it will not restart automatically till Saturday. So you're stuck asking the dbas to do a restart or setting it up again on gwrcron and deleting the old entry in the CRON_RESTART_WOUPRD.DAT file under woup:[wou_mods.com]
Posted by wendlerb at 3:27 PM | Comments (0)
April 7, 2008
Apollo upgrade
So far there have been some printer issues. We had to go through and check all the queues to make sure Apollo wasn't blocked. If it was I could telnet in through spruce and put apollo on the allow list. Some printers are turned off so we'll have to wait and see n those. A larger issue is regular ftp has been disabled from apollo so some of the feeds from financial aid no longer ftp files across.
Posted by wendlerb at 1:03 PM | Comments (0)