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=multicalendar&ocid=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=multiaccount&ocid=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