search cancel

Postgresql encoding error when login to Devtest portal


Article ID: 238376


Updated On:


Service Virtualization


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



   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.


Release : 10.7

Component :

Postgressql 13


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.