Page 1 of 1

Admin site give HTTP ERROR 500 when trying to view/edit user

Posted: Sat Apr 12, 2014 1:33 am
by haris
Following getting started from this page

http://www.broadleafcommerce.com/docs/core/current/getting-started

After starting the site and then the admin using jetty.

After log in to the admin using admin/admin username and password.

On the right panel expand security and click on Users which will show bunch of default users such as csr and admin.

Clicking on any of those user will result to following error

Code: Select all

HTTP ERROR 500
Problem accessing /admin/user-management/-4. Reason:
Unable to fetch results for org.broadleafcommerce.openadmin.server.security.domain.AdminPermissionImpl

Caused by:

org.broadleafcommerce.common.exception.ServiceException: Unable to fetch results for org.broadleafcommerce.openadmin.server.security.domain.AdminPermissionImpl
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

...

Caused by: java.sql.SQLSyntaxErrorException: incompatible data types in combination
   at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
   at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
   


Creating new user also give error. But somehow the new user got added in to the list.

Anyone else encounter this? I don't expect this since I just follow the getting started and have not change anything yet.

Thanks a bunch in advance
-Haris

Re: Admin site give HTTP ERROR 500 when trying to view/edit user

Posted: Sat Apr 12, 2014 9:04 am
by haris
Performing the steps (http://www.broadleafcommerce.com/docs/core/2.2/tutorials/getting-started-tutorials/switch-to-mysql-tutorial) to use MySQL instead of HSQL appear to solve this.

Must be database related issue.