Solved

License Error - IFS account already logged in by...

  • 13 January 2021
  • 3 replies
  • 67 views

Badge +2
  • Do Gooder
  • 6 replies

Hi,

 

We have users who can’t login to the application because they are getting the error message:

“IFS account is already logged in by EXAMPLEDOMAIN\RANDOM.USERNAME. Contact your system administrator!.”

 

But we can’t find their session against the database by looking at Solution Manager - Monitoring - Database Sessions.

And we have also tried to query the views:

fnd_session_runtime

v$session

gv$session

 

They have tried to restart their machines and it still happens from another machine too.

 

Thanks in advance!

icon

Best answer by Banu Liyanapathirana 13 January 2021, 15:19

Hi @kwc,

This kind of a situation (already logged in) usually occur when a user did not log off from the IFS Applications properly which will prevent the user from being able to login and the application will show a message to say the user is already logged in, until that session information will be automatically cleared after an HTTP timeout. Otherwise, there should be a network-related issue between the client and the server.

In order to manually clear the above session information, please log into the database directly and inspect the table ‘FND_CLIENT_LOGON_TAB’ to find any record existing regarding the particular users. You can use DIRECTORY_ID and OS_USER columns to find the corresponding record for the particular user. If you find such a record please delete it from that database table and check whether it solves the issue.

 

DELETE from FND_CLIENT_LOGON_TAB

WHERE DIRECTORY_ID = 'XXXX' AND OS_USER = 'XXXX' AND PROGRAM = 'Ifs.Fnd.Explorer.exe'

 

And commit the statement at the end. Please use the appropriate directory id and os user id in place of xxxx in the above query example.

 

Ensure that the users exit the IEE client by going to File > Exit to avoid such an issue.

 

/Banu

View original

3 replies

Userlevel 5
Badge +9

Hi @kwc,

This kind of a situation (already logged in) usually occur when a user did not log off from the IFS Applications properly which will prevent the user from being able to login and the application will show a message to say the user is already logged in, until that session information will be automatically cleared after an HTTP timeout. Otherwise, there should be a network-related issue between the client and the server.

In order to manually clear the above session information, please log into the database directly and inspect the table ‘FND_CLIENT_LOGON_TAB’ to find any record existing regarding the particular users. You can use DIRECTORY_ID and OS_USER columns to find the corresponding record for the particular user. If you find such a record please delete it from that database table and check whether it solves the issue.

 

DELETE from FND_CLIENT_LOGON_TAB

WHERE DIRECTORY_ID = 'XXXX' AND OS_USER = 'XXXX' AND PROGRAM = 'Ifs.Fnd.Explorer.exe'

 

And commit the statement at the end. Please use the appropriate directory id and os user id in place of xxxx in the above query example.

 

Ensure that the users exit the IEE client by going to File > Exit to avoid such an issue.

 

/Banu

Userlevel 6
Badge +10

Hi @kwc,

As Banu has mentioned above, it shall help you to resolve the issue, and the main KBA (Knowledge Based Article) for this is Error: "IFS account is already logged in by XXX" already available in community :)

Best Regards,
Yasas

Badge +2

Thank you Banu and Yasas. The suggestion provided by Banu worked great! :)

Reply