« July 2012 | Main | September 2012 »

August 31, 2012

Linux Migration - Hard-coded paths

I went through all of our scheduler job scripts this week and updated all of the hard-coded paths so that if the scripts are copied to another instance, they will still run correctly.

Posted by soukupm at 5:22 PM | Comments (0)

Linux migration - Going Live

We will be officially migrating to Linux on Sat Sept 1,2012. The scripts that need to be run after the migration are located in I:\staff\Banner_Information\Linux Migration\Go Live Tasks.

Posted by soukupm at 5:18 PM | Comments (0)

August 24, 2012

SZRGCHG mod

I made some changes to the report SZRGCHG (grade change report). It now uses the procedure sokemal.p_sendemail instead of the utl_smtp to send emails. This report failed to run after we upgraded to Oracle 11 because of acl problems.

Posted by soukupm at 4:49 PM | Comments (0)

Linux Migration - TZPLIBF

I created a new job submission for the library that they will use when we migrate to linux. The job is named TZPLIBF and it handles the library AR feed. In the past, OUS manually fed the library invoices into banner.

Posted by soukupm at 4:43 PM | Comments (0)

August 17, 2012

Linux Migration - SWBUGLF

I ran into a problem with the feed to finance script on Linux (swbuglf). A script that I wrote (arpost.shl) was looking for feed documents (fgu*.dat files) and the swbuglf script was creating the feed documents as "FGU*.dat". With Linux, case is sensitive so the feed documents weren't loading. I made a change to my script so it should pick them up for our next test.

Posted by soukupm at 3:37 PM | Comments (0)

Linux Migration - GWRCLEN

I made a modification to the GWRCLEN script for Linux. This is a maintenance script that deletes old records from various tables, particularily the job submission tables. The mod that I made prevents the script from deleting our cron job parameters from gjbprun.

Posted by soukupm at 3:23 PM | Comments (0)

August 10, 2012

Linux printing

This is our new default printing options for landscape:
lp -d wou_printer -o landscape -o cpi=16.3 -o lpi=8.2 filename

Posted by soukupm at 1:59 PM | Comments (0)

August 9, 2012

Linux Migration - clearinghouse script

I rewrote the clearinghouse script for Linux because the old script was not going to work and it wasn't well written. It called several sql scripts and concatenated files to make it work. I merged all that logic into one script SZRCLRH.PL. This script will create the entire clearinghouse file.

Posted by soukupm at 3:43 PM | Comments (0)

August 3, 2012

Degreeworks production

I reloaded the UCX tables (validation tables) in Degreeworks production today. I also updated the students in the database (the old data needed to be purged). All of the Surecode settings were deleted in production and the Registrar's office will put those back in manually. They did this because some settings are now longer needed (some were workarounds that have been fixed in version 4.10).

Posted by soukupm at 4:40 PM | Comments (0)

E-disburse update

I made some changes to the E-disburse program TZPEDUD so that it includes some new columns that the bank will be sending us in the recipient status file. I also updated the external table tzredud with these new columns. I ran into a problem with the reconciliation file that is used for the external table TZREDRC. The bank is including header columns in the file and oracle doesn't seem to like them. I believe it has something to do with the columns not being quoted. For now, I increased the reject limit to 2 so that it skips these lines.

Posted by soukupm at 4:32 PM | Comments (0)