Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQ01 queries disappeared

Former Member
0 Kudos

Hi all,

In our production system, Users are reporting saying the query assignment done through (SQ03) has disappeared, that is when users were created (long back in 2006) queries were also assigned, but all of a sudden the assignments are deleted. We as a Security team have not removed this, So Please let me know if there is a way to trace these changes.

Regards

Sushma

6 REPLIES 6

Former Member
0 Kudos

Hi,

Query assignment is not done through SQ03, adhoc query user groups are assigned to users using SQ03. Is that all user groups were deleted from the system?

Thanks,

Deb

0 Kudos

Query assignment done through SQ03, which users see through Sq01 is deleted, queries are not deleted, but some users have lost access to queries as the query assignment is deleted.

we have temporarly fixed this by reassigning, but what to know the route cause to avoid this in future.

Regards,

Sushma

0 Kudos

I have seen this happen before when transports of the groups came through which deleted them. Sometimes in the wrong sequence.

However they can also be deleted in the target system and there is no (default) logging of it.

Are there any short-dumps? Anything in the transport logs from when this started?

Cheers,

Julius

0 Kudos

Hi Julius,

We do not have any short dumps, please let me know transport log of which component I need to check, we didn't have any security transports moving, but users reported that they lost access, if you advice what kind of transports effect I can go back check with basis team on that.

Thanks a lot for your time

Regards,

Sushma

0 Kudos

Hi

I did speak to dev team, seems they do not transport the modifications to these queries instead they upload the changes, and we do see changes done a day before the query user assignment disappeared. Is there any way I can prove that this was the cause

Please advice

Regards,

Sushma

Former Member
0 Kudos

Hi All,

Please advice if we need to look into any specific transport logs or if there are any relavent Notes whichc will help me.

Thanks in advance

Sushma