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

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

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.

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

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

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.

Hi Imal,

How can i change the password:

alter user  IFSPLSQLAP identified by password;

or 

using other method.

Please guide.

Regards

Pankaj

Hello @envpankam,

Yes you can use that script.

alter user  IFSPLSQLAP identified by new_password;

Then perform a reconfiguration to the extended server.

Thanks.

Hi Imal,

Thanks!

Working now.

Regards

Pankaj

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

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

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

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