Skip to main content
Solved

HTTP 401 unauthorized access


Forum|alt.badge.img+6

HI Team,

 

While preview of any order report in APP7.5 SP6, we are getting the HTTP 401 unauthorized access.

 

 

Best answer by Imal Thiunuwan

Hello @envpankam,

 

Yes you can use that script.

alter user  IFSPLSQLAP identified by new_password;

Then perform a reconfiguration to the extended server.

 

Thanks.

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

13 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 48 replies
  • April 26, 2021

Check that the IFSPRINT user is not locked. Also check if the password for IFSPRINT has expired.


Novishan Dissanayake
Hero (Partner)
Forum|alt.badge.img+13

Hi,

 

Have you tried a reconfiguration of the instance to check if it addresses the issue?

Have you changed the IFSPRINT password recently using the admin.exe?

 

Cheers!

Novishan


Imal Thiunuwan
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • 117 replies
  • April 26, 2021

Hello @envpankam,

The most likely cause for this issue is that one of the IFS database system user account(s) has been locked, or the password has expired. One or many of the following database accounts could be affected:

• IFSSYS - Login for communication and configuration purposes

• IFSADMIN - Login for Administrator to the Solution Manager Client

• IFSCONNECT - Login for Batch and Connect Servers

• IFSPLSQLAP - Login for PL/SQL Access Providers

• IFSPRINT - Login for Print Server and Print Agent

• IFSWEBCONFIG - Login for Webclient. Only available if Webclient is installed in the Database

• IFSMOBILITY - Login for Mobileclient. Only available if Mobileclient is installed in the Database

To correct the issue, you can perform the following:

1. Make sure that the above accounts are not locked.

2. Reset the passwords to the value "internal" (Without quotes).
NOTE: You do not have to use the password of “internal”, but you will need to remember what the passwords are for each above system account for the next step.

3. Reinitialize the IFS Extended Server.
NOTE:  When you reinitialize the IFS Extended Server, make sure that you supply the correct password for the appropriate database user account.

 

Thanks.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • 24 replies
  • April 26, 2021

Hi All,

 

1> All IFS user user is not locked.

2> We are refresh the database and then change the password of all the IFS user to previous one and then we reconfigure the application.

But after that application is open normally but report are not previewed.

 

Regards

Pankaj


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • 24 replies
  • April 26, 2021

Hi All,

 

One more thing just now come, the services of IFS batch server and IFS connect server stopped automatically.

After that the IFSCONNECT and IFSPLSQLAP  got locked .

Am repeating the above steps 2-3 times but same issue we are got.

 

Regards

Pankaj


Imal Thiunuwan
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • 117 replies
  • April 26, 2021

Hello @envpankam;

That might be the reason behind this issue. Try to reset the password of  IFSPLSQLAP by using above mentioned method. May be the password saved in the database and the actual password are different.

 

Thanks.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • 24 replies
  • April 26, 2021

Hi Imal,

 

How can i change the password:

alter user  IFSPLSQLAP identified by password;

or 

using other method.

 

Please guide.

 

Regards

Pankaj


Imal Thiunuwan
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • 117 replies
  • Answer
  • April 26, 2021

Hello @envpankam,

 

Yes you can use that script.

alter user  IFSPLSQLAP identified by new_password;

Then perform a reconfiguration to the extended server.

 

Thanks.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • 24 replies
  • April 26, 2021

Hi Imal,

 

Thanks!

Working now.

 

Regards

Pankaj


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 3 replies
  • May 18, 2021

Hi All,

We are also getting the same error while printing or previewing report in IFS.

We had done the reconfiguration and the accounts are also not locked.

Any suggestions?

 

Regards,

Chetan


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • 24 replies
  • May 18, 2021

Hi Chetan,

 

Please check the user  IFSPLSQLAP password and also check the password in plsqlap_environment_tab table should me same.

then do the the reconfigure 

 

Regards

Pankaj


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 3 replies
  • May 18, 2021

Hi Pankaj,

Thank you. We see that the password for IFSPLSQLAP is not the same on plsqlap_environment_tab table.

How should we change/correct it?

Thanks.

Chetan


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 3 replies
  • May 19, 2021

Hi @envpankam  this is resolved now, thanks for your help. :smiley:


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