Hi Bob, While I'm no Windows/UD expert I did think of a few things while reading your problem: 1. You say it works every time when you run it from your logged in session. If this were unix I'd say check the PATH in your script. What ever the windows equivalent to unix PATH environment variable is I'd be checking it to make sure that your script environment has access to whatever exe's/resources you need to run. 2. What is the windows equivalent of a unix inode? Can this be changing between when you detect and open the file to when you go to read it? 3. Locks. Someone else mentioned this. Conflicts with backups etc.
Hope this is of some help. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au ________________________________________ From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Saturday, 17 August 2013 4:57 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Stumped on a WRITE failure UNschedule the job completely Then REschedule it It says the password data from the time it was scheduled, and when that password gets stale it does not tell you. It just starts failing. Another thought, run a job that can READ the directory of the targeted source. Run this as a Windows BATCH job, not from Universe. This can tell you if for some reason that target location is going OFFline at a critical time. I've seen it. It happens. -----Original Message----- From: Woodward, Bob <bob_woodw...@k2sports.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Fri, Aug 16, 2013 11:28 am Subject: Re: [U2] Stumped on a WRITE failure Hi John, Not applicable in this case. The scheduler runs the program every two hours. The files are staged from another server via an OS level COPY and are only something like 5 to 20k. Good thought, though. Thanks. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 11:12 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, If you are loading data from an outside source, might you be grabbing a data file that is not 100% written to disk? I have seen this a number of times. The 2 solutions to this that I recommend are either: 1) look for a 2nd file that indicates the 1st is 100% complete (be sure to delete the stub file after processing) or 2) look at the size or date/time of the data file, sleep for 10 seconds, then look again. Repeat this process until the criteria does not change Might or might not be applicable in your case. JRI -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 2:05 PM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Hi John, It is random and I've not been able to identify a common indicator between the files that work and the ones that don't. The source files are coming in from the other side of the world so it's happening in the very early hours of the morning. By the time I get in, the scheduler has tried to run the program on the "bad" file a couple of times. I've not tried using COMO, yet. This is exactly why I like this list so much. I'll put this in right away. I'll dig into the udterrorlog file, too, as Colin suggests. Thanks! -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 10:17 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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 U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIpdEIzD71OpEVusdTdEThjvKztcQsCQrEFLThjhd79J6W arZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJV2P_TjvW_ 8FELLcLZuVtdcsZO8VMQsFLzKmKzp5dmWbfaxVZicHs3jq9J4TsTsS03fBitfyp-fdFJAu00 U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rp7fLCPiS4QPiWq81y rqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrg9A6 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosd2gQrhp7ee3D4THCXCQrEFLThKCqejqdQkTXEFECzAS zt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSe86zBPX FLZvATC7zhOyDRXBQkQT-ojohjd7b_bnhIyyHsQsEYG7DR8OJMddECSjtPtPo0c-l9Q-9DUY SCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JZNNMS2_id4 1Fr2qpFtd40NdJlrQ3h1m1EwQQg0a2MQ4zhEwtShXsvdTdDo5ApJT-v9f _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCMUg40USyOess7e9LndTdEThjvKztcQsCQrEFLThjhd79J 6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVIsgd7bDT jvW_9Lcf6zB5fHTbEFFLYMCMyCqen-mKzp55mVEVhVkffGhBrwqrjdICXCXCM0pYGjFYjfNV JdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrXzzxI5-Aq8 3iS4QPiWq81yrqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrdd0eOZzx _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------------------------------------------------------- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ------------------------------------------------------------------------------- _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
