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.