[U2] Unidata Write Error
We just moved to unidata 7.2.5 on RHEL 5 from unidata 7.1.8 on Solaris 9. In the conversion I ran convcode, convdata and convidx across the board. Generally speaking, things have generally gone smoothly but I just ran into an error which I can't track back to conversion, permissions or triggers, but I'm open to thoughts. When attempting to delete a record, here's what happens: :AE H08.WEB.USERS 11196 --: fd Record 11196 in file H08.WEB.USERS * You are about to DELETE the ENTIRE record from the file! OK? n/y y In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,89). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,303). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,102). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,169). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,210). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,17). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 [AE] UniBasic WRITE failed, STATUS=1, check triggers. If instead of going thru AE I attempt a DELETE I get this: :DELETE H08.WEB.USERS 11196 Index: invalid OV element: (34,89). Index: invalid OV element: (34,303). Index: invalid OV element: (34,102). Index: invalid OV element: (34,169). Index: invalid OV element: (34,210). Index: invalid OV element: (34,17). 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 '11196' is not a record id in H08.WEB.USERS I reran convdata to ensure that this file was processed and Unidata thinks it's fine. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Write Error
On 6/3/2010 1:47 PM, Jeffrey Butera wrote: We just moved to unidata 7.2.5 on RHEL 5 from unidata 7.1.8 on Solaris 9. In the conversion I ran convcode, convdata and convidx across the board. Generally speaking, things have generally gone smoothly but I just ran into an error which I can't track back to conversion, permissions or triggers, but I'm open to thoughts. When attempting to delete a record, here's what happens: :AE H08.WEB.USERS 11196 --: fd Record 11196 in file H08.WEB.USERS * You are about to DELETE the ENTIRE record from the file! OK? n/y y In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,89). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,303). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,102). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,169). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,210). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,17). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 [AE] UniBasic WRITE failed, STATUS=1, check triggers. If instead of going thru AE I attempt a DELETE I get this: :DELETE H08.WEB.USERS 11196 Index: invalid OV element: (34,89). Index: invalid OV element: (34,303). Index: invalid OV element: (34,102). Index: invalid OV element: (34,169). Index: invalid OV element: (34,210). Index: invalid OV element: (34,17). 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 '11196' is not a record id in H08.WEB.USERS I reran convdata to ensure that this file was processed and Unidata thinks it's fine. Do you have any alternate key index's built on this file. If you do, you will have a X_H08.WEB.USERS file. If you do, maybe either disable updating the index, or just rebuild it. If it is damaged, may have to delete the index and reindex. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Write Error
If the index on this file was heavily overflowed, it is possible that convidx didn't successfully convert the index. You need to: LIST.INDEX H08.WEB.USERS (to make sure you have all of the index names for recreating) DELETE.INDEX H08.WEB.USERS ALL (to completely delete the index file) CREATE.INDEX - indexes listed in LIST.INDEX BUILD.INDEX H08.WEB.USERS ALL (possibly using ONLINE keyword if you need to continue to update the primary file while the index builds) Regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, June 03, 2010 11:47 AM To: U2 Users List Subject: [U2] Unidata Write Error We just moved to unidata 7.2.5 on RHEL 5 from unidata 7.1.8 on Solaris 9. In the conversion I ran convcode, convdata and convidx across the board. Generally speaking, things have generally gone smoothly but I just ran into an error which I can't track back to conversion, permissions or triggers, but I'm open to thoughts. When attempting to delete a record, here's what happens: :AE H08.WEB.USERS 11196 --: fd Record 11196 in file H08.WEB.USERS * You are about to DELETE the ENTIRE record from the file! OK? n/y y In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,89). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,303). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,102). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,169). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,210). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,17). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 [AE] UniBasic WRITE failed, STATUS=1, check triggers. If instead of going thru AE I attempt a DELETE I get this: :DELETE H08.WEB.USERS 11196 Index: invalid OV element: (34,89). Index: invalid OV element: (34,303). Index: invalid OV element: (34,102). Index: invalid OV element: (34,169). Index: invalid OV element: (34,210). Index: invalid OV element: (34,17). 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 '11196' is not a record id in H08.WEB.USERS I reran convdata to ensure that this file was processed and Unidata thinks it's fine. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ 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
Re: [U2] Unidata Write Error
On 06/03/10 13:54, Wally Terhune wrote: If the index on this file was heavily overflowed, it is possible that convidx didn't successfully convert the index Thanks Wally. Actually, in our conversion we ran convidx and also rebuilt indicies for ALL files. That said, after disabling both indicies and triggers for this file and recreating them, the problem has been resolved so I'll assume that the index file indeed was the culprit. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Write Error
Hi Jeff, When we made the move to RHEL (while I was @ Beloit College), we had something similar happen. I had to do more than rebuild the indexes. I had to completely delete the indexes, recreate them, and than rebuild them. I'm pretty sure I only had to do this for some files. I do remember it being a pain in the neck. I believe Datatel had an AnswerNet Doc on the subject. Cheers, Jon Wells jwe...@campbell.edu At 01:47 PM 6/3/2010, you wrote: We just moved to unidata 7.2.5 on RHEL 5 from unidata 7.1.8 on Solaris 9. In the conversion I ran convcode, convdata and convidx across the board. Generally speaking, things have generally gone smoothly but I just ran into an error which I can't track back to conversion, permissions or triggers, but I'm open to thoughts. When attempting to delete a record, here's what happens: :AE H08.WEB.USERS 11196 --: fd Record 11196 in file H08.WEB.USERS * You are about to DELETE the ENTIRE record from the file! OK? n/y y In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,89). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,303). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,102). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,169). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,210). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 Index: invalid OV element: (34,17). In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 In /usr/ud72/sys/CTLG/a/AE_AE at line 2285 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 [AE] UniBasic WRITE failed, STATUS=1, check triggers. If instead of going thru AE I attempt a DELETE I get this: :DELETE H08.WEB.USERS 11196 Index: invalid OV element: (34,89). Index: invalid OV element: (34,303). Index: invalid OV element: (34,102). Index: invalid OV element: (34,169). Index: invalid OV element: (34,210). Index: invalid OV element: (34,17). 311296:block offset error in U_blkwrite for file 'H08.WEB.USERS', key '', number=131 1:block offset error in delete_from_group for file 'H08.WEB.USERS', key '11196', number=131 '11196' is not a record id in H08.WEB.USERS I reran convdata to ensure that this file was processed and Unidata thinks it's fine. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ 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