Postgresql encoding error when login to Devtest portal

Products

• Service Virtualization

Issue/Introduction

We are trying to install a new instance of DEVTEST10.7 to replace our current 10.3 version.

 

postgres=# \l
                                   List of databases
   Name    |   Owner    | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+------------+----------+-------------+-------------+-----------------------
 commondb  | devtestint | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 iamdb     | devtestint | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres  | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

 

at first startup of the Devtest portal console login, getting an error as below. Please provide solution for this issue.

 [qtp991964130-100] ERROR com.itko.lisa.test.LisaSecurityManager - Authentication Error
javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00
Error Code: 0

 

Cause

   This issue is due to incorrect entries added in database during migration from 10.3 version to 10.7. This happens only for one particular user who tried to login during migration.

Environment

Release : 10.7

Component :

Postgressql 13

Resolution

Connect to postgres database and run below query:

SELECT acl_user_id, misc_info, user_name, user_password, user_unique_id
 FROM public.acl_users where  user_unique_id = '<Login_failure_User_id>' ;

If you see an entry for user fdesmarquest in database, run below query to update the user-id details and insert a record.

update acl_users set user_unique_id = '<Login_failure_User_id>' where user_unique_id = '<Login_failure_User_id>'

insert into acl_users values (9999,null,null,null,'<Login_failure_User_id>')

If there is no entry in registry database, insert a record manually with below query

insert into acl_users values (9999,null,null,null,'<Login_failure_User_id>')

 

After these changes, try login from portal console and let me know.