Skip to Content

From some for us yet unknown reason, suddenly, all the quick views (SQVI) from one of our productive system disappeared. Hundreds of quick views (3400 in total).

After short investigation we found a strange phenomenon. SQVI Usergroups were recreated. Before the incident the Usergroups were from the range SYSTQV000001 – SYSTQV000852. And now the range started at SYSTQV000853:

/wp-content/uploads/2014/09/capture_20140627_174750_006_539157.png

What we could get in the first moment, at least, was a list of reports (table TRDIR), that were generated out of all the quick views:

Clipboard09.png

By searching the table AQLQCAT (Query Catalog) for the query name (right side of the program name from the 17th character), we could find the name of the Infoset:

/wp-content/uploads/2014/09/capture_20140627_174603_004_539166.png

We went to SQ03 to check, whether the Infoset is still known to the system, and whether we could re-assign the abandoned Infoset (authorization) to the new QV Usergroup of the given user:

/wp-content/uploads/2014/09/capture_20140627_174625_005_539170.png

Apparently it was possible :-):

/wp-content/uploads/2014/09/capture_20140627_174750_006_539157.png

/wp-content/uploads/2014/09/capture_20140627_174750_006_539157.png

Still the quick view did not appear for the user in SQVI.

After a bit of testing we found a way: to copy the query from the old user group into the new one.

First in the SQ01 we selected the new user’s Usergroup: How to find and execute or work with other users quick views (or quick views created with old user-id)?

Then in the menu select Query => Copy. Here we put the old usergroup and the query name twice:

/wp-content/uploads/2014/09/capture_20140627_174830_008_539176.png

After the copy, the query appeared again in the SQVI:

/wp-content/uploads/2014/09/capture_20140627_174834_009_539180.png

And this we may repeat (in our case) 3400 times 🙂

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply