Bob, Can you re-create the error on demand (from the Scheduler) or is it random?
Have you tried capturing anything with a COMO? Are these on NEW records, existing records or both? Are the indexes being updated to reflect the writes even if the primary file is not? JRI -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 1:09 PM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W _______________________________________________ U2-Users mailing list [email protected] http://cp.mcafee.com/d/1jWVIpdEIzD71OpEVusdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJV2P_TjvW_8FELLcLZuVtdcsZO8VMQsFLzKmKzp5dmWbfaxVZicHs3jq9J4TsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rp7fLCPiS4QPiWq81yrqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrg9A6 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
