Problem compiling [select e from User e where e.username = :username]

Support
#1

Hi,

I have problem to login after i key in default user which is admin in GUI.

here is my table structure in db for user and sec_role_assignment entities . I am using postgres, my schema is public and this is my main db.

username|role_code |role_type|
admin |system-full-access|resource |

|version|username|password |
| 1|admin |{noop}admin|

i encountered this problem
image

here is the detail of the error

Local Exception Stack:
Exception [EclipseLink-0] (Eclipse Persistence Services - 2.7.9.6-jmix): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Problem compiling [select e from User e where e.username = :username].
[14, 18] The abstract schema type ‘User’ is unknown.
[27, 37] The state field path ‘e.username’ cannot be resolved to a valid type.
at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildException(HermesParser.java:157)

i need help & thank you in advance

#3

Hello,

Have you made changes to the admin user? Is this error reproduce in a new project?

Regards,
Nikita

#5

Hello,
I have the same issue.
I don’t understand where it comes from…

Local Exception Stack:
Exception [EclipseLink-0] (Eclipse Persistence Services - 4.0.2-3-jmix.v202404051618): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Problem compiling [select e from User e where e.username = :username].
[14, 18] The abstract schema type ‘User’ is unknown.
[27, 37] The state field path ‘e.username’ cannot be resolved to a valid type.