« October 2007 | Main | December 2007 »
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 16, 2007
Form Development
I've modified a number of Banner forms but I never tried to make a new one so I thought I'd give it a shot. Been a challenge but I can appreciate all the work that goes into these forms. I'm working on a form that list graduates for a given term and levl since I get this request all the time now. So far it's make a few changes, sftp over to inb2, compile, see what happened. It's a slow process.
Posted by wendlerb at 10:40 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 8, 2007
Swlffac and swlffac_old
These are two job submission programs that the library runs to populate some kind of database over there. They were using views and procedures on wops. I found them in a search for programs like this that use a wops link which goes away during the merge. Discovered it used a population select that tied into the table pwrojob which doesn't get populated anymore. I cahanged it to work in a merged database without the linked views and just wrote the select statement directly.
Posted by wendlerb at 9:36 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)
November 5, 2007
SPAIDN1
There is a concern that once we merge student workers would be able to see employee info set up on ppaiden. In order to be proactive I made a clone of spaiden and modified the enable_tab_pages trigger. The tabs don't get enabled if the record is an employee with an eclass code beginning with a U or C. Nothing may come of the form but it is available if needed.
Posted by wendlerb at 1:09 PM | Comments (0)