Skip to main content
Solved

TW2023.1 infinite loop "row is no longer present"

  • February 24, 2023
  • 2 replies
  • 53 views

Forum|alt.badge.img+6

We are in the process of updating from TW2021 to TW2023 and during testing I noticed that in the windows gui one of our VIEWS no longer works as it used to do.

When I open the VIEW I see the expected records and the debug shows the SELECT exactly as I would expect it (for readability I changed it to * instead of the individual fields):

SELECT *
FROM   complaint_action_follow_up_action_gui AS t1
WHERE  (t1.complaint_header_id = 1682)
       AND (t1.action_id = 5);

But as soon as I select one of the rows (form grid) I get a message that the selected row no longer exists:


When I press OK the message dissapears and comes back again…. infinate loop…

Looking at the data that is going thru the SQL server using an Extended event shows me this query (for readability I changed it to * instead of the individual fields):

SELECT
     *
FROM  complaint_action_follow_up_action_gui AS t1
WHERE 1 = 0;

It seems to have lost all prefilter data causing it to always return NULL.

When I do the exact same thing in the Universal GUI it works (the layout of the form grid is messed up but technically it is working).

I have this issue on both our DEVELOPMENT, TEST and ACCEPTANCE servers which all run TW2023.1.10, this functionality still works fine on PRODUCTION on TW2021.3.16

Could this be related to

Best answer by Erwin Ekkel

Is 2023.1.10 the windows gui version, if so please upgrade to the latest gui and try again. A bug involving prefilters was fixed in the .11 version:
 

  • Windows GUI Web GUI - We have fixed an issue where, in some situations, a mandatory prefilter group would prevent the user from editing or inserting new data. They would encounter the message "This row does no longer exist".

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Forum|alt.badge.img+17
  • Moderator
  • 762 replies
  • Answer
  • February 24, 2023

Is 2023.1.10 the windows gui version, if so please upgrade to the latest gui and try again. A bug involving prefilters was fixed in the .11 version:
 

  • Windows GUI Web GUI - We have fixed an issue where, in some situations, a mandatory prefilter group would prevent the user from editing or inserting new data. They would encounter the message "This row does no longer exist".


Forum|alt.badge.img+6
  • Author
  • Captain
  • 86 replies
  • February 24, 2023
Erwin Ekkel wrote:

Is 2023.1.10 the windows gui version, if so please upgrade to the latest gui and try again. A bug involving prefilters was fixed in the .11 version:
 

  • Windows GUI Web GUI - We have fixed an issue where, in some situations, a mandatory prefilter group would prevent the user from editing or inserting new data. They would encounter the message "This row does no longer exist".

Lesson learned…. Ask sooner… 🤐


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings