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 "999999999ý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=multicalendar&ocid=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