IllegalStateException: Illegal column name username in table FW_CSUserGroups (Doc ID 1527233.1)

Last updated on MAY 12, 2023

Applies to:

Symptoms

After upgrading to CS 7.6.2 with WEM, seeing this error in the application server log:

[2/4/13 11:55:30:734 EST] 00000024 WebApplicatio E The RuntimeException could not be mapped to a response, re-throwing to the HTTP container
  java.lang.IllegalStateException: Illegal column name username in table FW_CSUserGroups
at COM.FutureTense.CatalogManager.F.A(y:4872)
at COM.FutureTense.CatalogManager.F.A(y:5156)
at COM.FutureTense.Common.J.SQL(y:288)
at com.fatwire.security.UserGroupManagerImpl.getUserGroups(y:1335)
at com.fatwire.assetapi.site.UserManagerImpl._getUserGroups(UserManagerImpl.java:273)
at com.fatwire.assetapi.site.UserManagerImpl.read(UserManagerImpl.java:181)
at com.fatwire.rest.service.impl.LocalUserService._getUser(LocalUserService.java:95)
at com.fatwire.rest.service.impl.LocalUserService.getUser(LocalUserService.java:54)
at com.fatwire.rest.resources.UserResource.getUser(UserResource.java:68)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.