« February 2008 | Main | April 2008 »
March 24, 2008
wouchek initialization error
Found a note on the SCT self service site that described the error we get the first time you log into wouchek in a session. You get the form cannot be found error and then it continues on to the form and you don't see the error again the rest of the session. The note said when you make a custom form and start with a copy of a form like spaiden, it looks for soqmenu.fmx when it initializes the form. You needed to copy soqmenu and rename it to so the custom form can find it. So I copied it and renamed it to woqmenu. I compiled it to upg and it worked. So, we are placing in production.
Posted by wendlerb at 9:45 AM | Comments (0)
March 18, 2008
Swkrpsb
Changed the tbraccd amounts to only pull TUI catagory per request. Added check to see of any classes for the term are other than part of term 1. Stuck * after class for records where that scenerio is true.
Posted by wendlerb at 11:41 AM | Comments (0)
March 14, 2008
Fzrinvs
This is the check invoice selection report. We were running a very old version of this report, 3.x, and I wanted to put our mods on the 7.1 version. What a can of worms. We've added two hold indicators and an address type/seq field to the report. First credit memos wouldn't show up and that turned out to be due to the main select statement changing somewhat. I got that fixed and then started having problems with the totals not breaking right for the vendor on multiples. I had to add spriden_id and spriden to the fabinvh part of the select union.
Posted by wendlerb at 2:38 PM | Comments (0)
March 13, 2008
wouchek
We've been having a problem with student checks where the doc num and check num are getting out of sync. The original check form selects an oracle sequence for each one at the same time in the code. There's a known oracle bug where the sequence number will skip whatever is left in the sequence cache once in awhile and this appears to be what is happening. The recommendation is to set the cache to 0 and make it get it from the disk every time. I had hoped the 10G upgrade would solve this but instead it got worse.
So, I changed the form and szpbchk to get the number from the check sequence and set the cache to 0. Then I just used the same value reurned for both doc num and check num. Since they are always supposed to be the same, I should be fine. Not sure yet what the 0 cache will do under a load.
Posted by wendlerb at 11:51 AM | Comments (0)
March 5, 2008
ID Masking Soaiden, soaidns, and ftiiden
The problem: If you selected an X masked record off form it brought into parent form. Want V number to come in
Modified spridenx view to bring in masked ids as spriden_ssn and unmasked ids as spriden_id
Soaiden and Ftiiden:
spriden block spriden table source changed from spriden to spridenx
Changed spriden block item spriden_id to spriden_ssn
Added new spriden_block item and called it spriden_id. Made it invisible to canvas
Made mod to soaiden spriden block key-exeqry to check ssn instead of id
Soaidns:
spriden block spriden table source changed from spriden to spridenx
Changed spriden block item spriden_id to spriden_ssn. Unlike the other forms I had to change the column in the property palette from spriden_id to null
Added new spriden_block item and called it spriden_id. Made it invisible to canvas
Modified enable keys and disable keys triggers to use spriden_ssn
Posted by wendlerb at 3:15 PM | Comments (0)
March 4, 2008
Bio tab problems
Ran into a problem where we couldn't insert bio info on the id forms unless a spbpers record already existed or we had ssn information. This happened at the same time we started ssn masking so at first I thought it was related to that. However, it's related to the upgrade but I'm not sure if it was last weekends point release or the merge. I put a mod in GB_BIO to not insert a record into spbpers if the ssn field was null. This was back premerge when there were table triggers on spbpers to populate the sis side of the house. The problem was updating the bio tab in ppaiden on records created on a sis form. It no longer seems to be a problem so I removed the mod on GB_BIO and that solved the issue we had yesterday. Not sure why this didn't show up after the merge.
Posted by wendlerb at 9:52 AM | Comments (0)
March 3, 2008
Upgrade weekend
Things are going pretty well. I did run into a bizarro problem with the wouchek form not inserting records into the check table. I recompiled the form and it worked fine. We forgot to put wou mods on the new twbkwbis under wtailor which handles the login response and points you to pin reset. Those are now in and it looks good. The menus came across without any problems. We also implemented the new SSN masking and added RYAOFAX as a masked form.
Posted by wendlerb at 2:39 PM | Comments (0)