in a multi user system it could be that a different user deleted the record
In your logs, a record number is not necessarily enough to ID the trouble record. In your log - write some data specific information - UUID, or some other info that is unique to the record, as 4D can/does reuse record numbers. so you can have the situation: User A loads a selection of records (Including Record 1) User B deletes record 1 User A does their Selection to Array - the error occurs as Record 1 does not exist. User C adds a record to the table - 4D reuses Record 1 you look into your log file and find that Record 1 was the trouble record you look at the data and find that there is a record 1. Chip On Wed, 3 Jul 2019 21:06:54 +0200, stardata.info via 4D_Tech wrote: > No transaction, seems that there is a record not accessible with GOTO > RECORD command. Now I trap this error with ON ERR CALL and after I > write in the application logs the record numbers contained into the > array. So I can see the record number that gives a problem... > Is strange that after restarting the client, all work normally. If > there are a strange record number, he must remain even after the > restart of client. > > Il 03/07/2019 21:00, [email protected] ha scritto: >> Message: 2 >> Date: Wed, 03 Jul 2019 16:14:45 +0100 >> From: Narinder Chandi<[email protected]> >> To: 4D Tech Mailing List<[email protected]> >> Subject: Re: OUT OF RANGE >> Message-ID:<[email protected]> >> Content-Type: text/plain; charset="UTF-8" >> >>>From memory, this error is usually triggered because a record you >> are trying to access doesn't exist. You need to look at the context >> in which you are trying to create the selection to figure this error >> out. Perhaps you are in a transaction? >> >> Regards, >> Narinder Chandi, >> ToolBox Systems Ltd. >> -- -----Original Message----- From: 4D_Tech >> <[email protected]> on behalf of 4D Tech Mailing List >> <[email protected]> Reply-To: 4D Tech Mailing List >> <[email protected]> Date: Wednesday, 3 July 2019 at 16:05 To: 4D >> Tech Mailing List <[email protected]>, >> <[email protected]> Cc: "stardata.info" >> <[email protected]> Subject: OUT OF RANGE Hi All, I use 4D V13 >> on windows in one client server application. In the command CREATE >> SELECTION FROM ARRAY sometimes i have one error: The cannot be used >> to build the selection Record # is out of range during GOTO >> RECORD.... The customer restart the application and this segnalation >> disappares. Someone can explain the reason? Now i trap the >> segnalation using ON ERR CALL but i need to understand the reasons. >> Thanks /Ferdinando/ > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
