on 2016 Aug 21 5:40 AM
Dear colleagues,
I created a role in RESPOSITORY, I,e repository role not SQL role,
In that Repository role I added couple of procedures and activated it in DEV, TEST and PRODUCTION systems, role is working fine,
When some changes has been done in the procedure in the development system and it is transported to the next systems then the procedure is getting disappeared in my repository role,
Every time I have activate the role again and again after the transport is done,
any solution for this, please...
Thanks,
Rama
Is this the first time this has happened for you or have you always been able to change a procedure and then have it transported whilst currently activated and stay active in the next system?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rama,
I'm not exactly sure what's going on but take a look at inactive objects in each system and perhaps you will find something inactive that is causing the issue; sometimes i've seen funky behavior that is caused by inactive objects that I can not clearly see from the repository view.
select * from _SYS_REPO.INACTIVE_OBJECT
-Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.