Question

Issue while login to IFS Test App8 after Prod Refresh

  • 4 March 2022
  • 4 replies
  • 91 views
S
Rank
Userlevel 1
Badge +6

Hi Team,

We are getting the below error while login to IFS Test Apps 8 after we refresh from PROD data. Did anyone got this issue? Any suggestion please?

 

Thanks,

Sanjay

Thanks, Sanjay
This topic has been closed for comments

4 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @SANJ,

Looks like some of the privileges have been revoked after the refresh. Do you get this error when logging in as Application Owner as well? Please try running following scripts:

Logged in as SYS:

BEGIN
    Prepare_SYS.Dbagrant('&APPOWNER’);
END;

 

Logged in as Application Owner:

BEGIN
    Installation_SYS.Grant_Ifssys(TRUE);
END;

 

BEGIN
    Fndbas_Installation_API.Post_Installation_Object; 
END;

 

BEGIN
    Fndbas_Installation_API.Post_Installation_Data; 
END;

 

Hope this helps!

Charith - https://charith.xyz
S
Rank
Userlevel 1
Badge +6

Hi Charith,

Thanks for your reply.

I ran the above scripts except the below two seems they are not available for Apps8, but still the same issue and I am getting this error with every user id including AO.

BEGIN
    Fndbas_Installation_API.Post_Installation_Object; 
END;

 

BEGIN
    Fndbas_Installation_API.Post_Installation_Data; 
END;

Thanks,

Sanjay

Thanks, Sanjay
K
Rank
Userlevel 5
Badge +15

Hi @SANJ 

 

Try to refresh dictionary and security cache:

Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'FULL');

Security_SYS.Refresh_Active_List__(1);

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
S
Rank
Userlevel 1
Badge +6

Hi @Charith Epitawatta , @knepiosko ,

Thanks for your reply.

Finally i restarted Application server followed by providing all the grants again and it worked.

Thanks,

Sanjay

Thanks, Sanjay
Terms & ConditionsCookie settings