[U2] problem - Attempted WRITE with record ID larger than file/table maximum
We encountered a problem during our nightly batch processing last night and it pertains to a specific record/key. The error that we received in our log is as follows: -- Program LFBDOPOS: Line 337, Attempted WRITE with record ID larger than file/table maximum record ID size of 255 characters. Program LFBDOPOS: Line 337, FATAL: Unable to do commit of record 15500*60431*EJK in file GENACCTRN_POSTED/DATA.30. Program LFBDOPOS: Line 337, Rolling back uncommitted transactions begun within this execution environment. Attempted WRITE with record ID larger than file/table maximum record ID size of 255 characters. -- I checked our MAXKEYSIZE in UniAdmin and it's set to 255. I guess my question is why is it saying the ID/primary key is too large if it should be - 15500*60431*EJK ? Also, what do we do to fix this? Any help is appreciated, thanks! Chris _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum
Make sure there is not an index on that file being updated with a key 255 characters. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, June 09, 2010 8:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] problem - Attempted WRITE with record ID larger than file/table maximum We encountered a problem during our nightly batch processing last night and it pertains to a specific record/key. The error that we received in our log is as follows: -- Program LFBDOPOS: Line 337, Attempted WRITE with record ID larger than file/table maximum record ID size of 255 characters. Program LFBDOPOS: Line 337, FATAL: Unable to do commit of record 15500*60431*EJK in file GENACCTRN_POSTED/DATA.30. Program LFBDOPOS: Line 337, Rolling back uncommitted transactions begun within this execution environment. Attempted WRITE with record ID larger than file/table maximum record ID size of 255 characters. -- I checked our MAXKEYSIZE in UniAdmin and it's set to 255. I guess my question is why is it saying the ID/primary key is too large if it should be - 15500*60431*EJK ? Also, what do we do to fix this? Any help is appreciated, thanks! Chris _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=P ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum
I believe that is the problem, the key for record '15500*60431*EJK' must have more than 255 characters. Is there a way to check the # of characters on a key from a telnet prompt? I'm confused why the key would be so big? There must be 'historical encoding of record locks' or something behind the scenes being stored. Basically it's a record we have in table #1 that we are writing to table #2. Would there be anything to check on the record? Thanks. Date: Wed, 9 Jun 2010 10:34:07 -0400 From: perry.tay...@zirmed.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum Make sure there is not an index on that file being updated with a key 255 characters. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, June 09, 2010 8:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] problem - Attempted WRITE with record ID larger than file/table maximum We encountered a problem during our nightly batch processing last night and it pertains to a specific record/key. The error that we received in our log is as follows: -- Program LFBDOPOS: Line 337, Attempted WRITE with record ID larger than file/table maximum record ID size of 255 characters. Program LFBDOPOS: Line 337, FATAL: Unable to do commit of record 15500*60431*EJK in file GENACCTRN_POSTED/DATA.30. Program LFBDOPOS: Line 337, Rolling back uncommitted transactions begun within this execution environment. Attempted WRITE with record ID larger than file/table maximum record ID size of 255 characters. -- I checked our MAXKEYSIZE in UniAdmin and it's set to 255. I guess my question is why is it saying the ID/primary key is too large if it should be - 15500*60431*EJK ? Also, what do we do to fix this? Any help is appreciated, thanks! Chris _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=P ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multiaccountocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum
On 6/9/2010 10:46 AM, Chris Austin wrote: I believe that is the problem, the key for record '15500*60431*EJK' must have more than 255 characters. Is there a way to check the # of characters on a key from a telnet prompt? I'm confused why the key would be so big? There must be 'historical encoding of record locks' or something behind the scenes being stored. Basically it's a record we have in table #1 that we are writing to table #2. Would there be anything to check on the record? Thanks. ttp://listserver.u2ug.org/mailman/listinfo/u2-users I have done this by accident before. If you are getting your key from a multivalue list and have the wrong delimiter chosen, you will send the dynamic array as the key and that can be too long. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum
Yeah that could be it but I just did a restore of last nights pre-cycle data. An interesting thing I noticed in regards to the table GENACCTRN (the one we're having issues with) and noticed the following errors with the index: Restoring c:\LIVE/I_GENACCTRN/INDEX.005 (19:34:23) Restoring c:\LIVE/I_GENACCTRN/INDEX.006 (19:34:23) Unable to write item 9ý3136FJMA6ý912828DC1ý3136FJQU8. Unable to write item 361448AG8ý362311AH5ý36966RV60ý4165X0MJ6ý4165X0NK3ý44181EW79ý620076AH2ý620076AP4ý925524AQ3ý92923WAA8ý025816BA6ý3136FHSC0ý3136F3R32ý3128X9YC8. Unable to write item 220905202ý94979B204ý38144X500ý17306N203ý369622519ý46623D200ý95709T704ý59021V839. Unable to write item 165069AS4ý25271CAK8ý260543BJ1ý50075NAC8ý650094CA1ý3135A1GD3ý3136FHR23ý3136FJME8ý3128X9XG0ý00206RAB8ý035229CT8ý053332AF9ý06550XDM2ý06406JCU7ý219350AS4. Restoring c:\LIVE/I_GENACCTRN/INDEX.MAP (19:34:23) 'unable to write' to the index. I guess this index will need to be rebuilt? Date: Wed, 9 Jun 2010 11:24:18 -0400 From: slestak...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum On 6/9/2010 10:46 AM, Chris Austin wrote: I believe that is the problem, the key for record '15500*60431*EJK' must have more than 255 characters. Is there a way to check the # of characters on a key from a telnet prompt? I'm confused why the key would be so big? There must be 'historical encoding of record locks' or something behind the scenes being stored. Basically it's a record we have in table #1 that we are writing to table #2. Would there be anything to check on the record? Thanks. ttp://listserver.u2ug.org/mailman/listinfo/u2-users I have done this by accident before. If you are getting your key from a multivalue list and have the wrong delimiter chosen, you will send the dynamic array as the key and that can be too long. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum
Perhaps the index is defined as single-valued when it should be defined as multi-valued. Best regards, Henry Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, June 09, 2010 8:34 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] problem - Attempted WRITE with record ID largerthan file/table maximum Yeah that could be it but I just did a restore of last nights pre-cycle data. An interesting thing I noticed in regards to the table GENACCTRN (the one we're having issues with) and noticed the following errors with the index: Restoring c:\LIVE/I_GENACCTRN/INDEX.005 (19:34:23) Restoring c:\LIVE/I_GENACCTRN/INDEX.006 (19:34:23) Unable to write item 9ý3136FJMA6ý912828DC1ý3136FJQU8. Unable to write item 361448AG8ý362311AH5ý36966RV60ý4165X0MJ6ý4165X0NK3ý44181EW79ý620076AH2ý620076AP4ý925524AQ3ý92923WAA8ý025816BA6ý3136FHSC0ý3136F3R32ý3128X9YC8. Unable to write item 220905202ý94979B204ý38144X500ý17306N203ý369622519ý46623D200ý95709T704ý59021V839. Unable to write item 165069AS4ý25271CAK8ý260543BJ1ý50075NAC8ý650094CA1ý3135A1GD3ý3136FHR23ý3136FJME8ý3128X9XG0ý00206RAB8ý035229CT8ý053332AF9ý06550XDM2ý06406JCU7ý219350AS4. Restoring c:\LIVE/I_GENACCTRN/INDEX.MAP (19:34:23) 'unable to write' to the index. I guess this index will need to be rebuilt? Date: Wed, 9 Jun 2010 11:24:18 -0400 From: slestak...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum On 6/9/2010 10:46 AM, Chris Austin wrote: I believe that is the problem, the key for record '15500*60431*EJK' must have more than 255 characters. Is there a way to check the # of characters on a key from a telnet prompt? I'm confused why the key would be so big? There must be 'historical encoding of record locks' or something behind the scenes being stored. Basically it's a record we have in table #1 that we are writing to table #2. Would there be anything to check on the record? Thanks. ttp://listserver.u2ug.org/mailman/listinfo/u2-users I have done this by accident before. If you are getting your key from a multivalue list and have the wrong delimiter chosen, you will send the dynamic array as the key and that can be too long. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ 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