Solved

HTTP 401 unauthorized access

E
Rank
Userlevel 3
Badge +6

HI Team,

 

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

 

 

icon

Best answer by Imal Thiunuwan 26 April 2021, 18:02

View original
This topic has been closed for comments

13 replies

D
Rank
Userlevel 3
Badge +10

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

Novishan Dissanayake
Rank
Userlevel 6
Badge +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
Rank
Userlevel 6
Badge +16

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.

E
Rank
Userlevel 3
Badge +6

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

E
Rank
Userlevel 3
Badge +6

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
Rank
Userlevel 6
Badge +16

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.

E
Rank
Userlevel 3
Badge +6

Hi Imal,

 

How can i change the password:

alter user  IFSPLSQLAP identified by password;

or 

using other method.

 

Please guide.

 

Regards

Pankaj

Imal Thiunuwan
Rank
Userlevel 6
Badge +16

Hello @envpankam,

 

Yes you can use that script.

alter user  IFSPLSQLAP identified by new_password;

Then perform a reconfiguration to the extended server.

 

Thanks.

E
Rank
Userlevel 3
Badge +6

Hi Imal,

 

Thanks!

Working now.

 

Regards

Pankaj

M
Rank
Badge +1

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

E
Rank
Userlevel 3
Badge +6

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

M
Rank
Badge +1

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

M
Rank
Badge +1

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

Terms & ConditionsCookie settings