Skip to content

v7.1.0 - Table 'WSO2IS_IDENTITY_DB.CM_PURPOSE_CATEGORY' doesn't exist #470

Description

@Gianni-Caselli

Hi, I get this error in wso2/wso2is:7.1.0 docker-compose installation when I want to create new tenant:

[2025-07-10 12:44:56,645] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] INFO {org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent} - Tenant 13 is not initialized correctly. Hence initializing the tenant registry [2025-07-10 12:44:56,745] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at configregistry in 3ms [2025-07-10 12:44:56,747] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at govregistry in 4ms [2025-07-10 12:44:56,803] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at configregistry in 2ms [2025-07-10 12:44:56,804] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at govregistry in 2ms [2025-07-10 12:44:57,074] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] INFO {org.wso2.carbon.tenant.mgt.services.TenantMgtImpl} - Deactivated the tenant '0eb79e8b-6c9b-4848-bda4-55013bd15794 [13]' by 'I****************i' [2025-07-10 12:44:57,123] [49fbf5ae-eb30-4d2b-a08c-18a009d674e0] ERROR {org.wso2.carbon.identity.api.server.organization.management.v1.service.OrganizationManagementService} - errorCode: ORG-65026 | message: Server encountered an error while creating the tenant. org.wso2.carbon.identity.organization.management.service.exception.OrganizationManagementServerException: Unable to create the organization. at org.wso2.carbon.identity.organization.management.service.util.Utils.handleServerException(Utils.java:115) at org.wso2.carbon.identity.organization.management.service.OrganizationManagerImpl.createTenant(OrganizationManagerImpl.java:1068) at org.wso2.carbon.identity.organization.management.service.OrganizationManagerImpl.addOrganization(OrganizationManagerImpl.java:180) at org.wso2.carbon.identity.api.server.organization.management.v1.service.OrganizationManagementService.addOrganization(OrganizationManagementService.java:257) at org.wso2.carbon.identity.api.server.organization.management.v1.impl.OrganizationsApiServiceImpl.organizationPost(OrganizationsApiServiceImpl.java:135) at org.wso2.carbon.identity.api.server.organization.management.v1.OrganizationsApi.organizationPost(OrganizationsApi.java:181) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:104) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:265) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:225) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:304) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:555) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:145) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.wso2.carbon.identity.context.rewrite.valve.OrganizationContextRewriteValve.invoke(OrganizationContextRewriteValve.java:123) at org.wso2.carbon.tomcat.ext.valves.SameSiteCookieValve.invoke(SameSiteCookieValve.java:38) at org.wso2.carbon.identity.cors.valve.CORSValve.invoke(CORSValve.java:83) at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:157) at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:153) at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:110) at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:49) at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:71) at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:152) at org.wso2.carbon.extension.identity.x509Certificate.valve.X509CertificateAuthenticationValve.invoke(X509CertificateAuthenticationValve.java:59) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) at org.wso2.carbon.identity.core.context.valve.IdentityContextCreatorValve.invoke(IdentityContextCreatorValve.java:45) at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:63) at org.wso2.carbon.tomcat.ext.valves.RequestEncodingValve.invoke(RequestEncodingValve.java:49) at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:137) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:1583) Caused by: org.wso2.carbon.stratos.common.exception.TenantMgtException: Error in notifying tenant addition. at org.wso2.carbon.tenant.mgt.services.TenantMgtImpl.notifyTenantAddition(TenantMgtImpl.java:541) at org.wso2.carbon.tenant.mgt.services.TenantMgtImpl.registerTenant(TenantMgtImpl.java:112) at org.wso2.carbon.tenant.mgt.services.TenantMgtImpl.addTenant(TenantMgtImpl.java:83) at org.wso2.carbon.identity.organization.management.service.OrganizationManagerImpl.createTenant(OrganizationManagerImpl.java:1060) ... 60 more Caused by: org.wso2.carbon.stratos.common.exception.StratosException: Error while adding default purpose category for tenant:0eb79e8b-6c9b-4848-bda4-55013bd15794 at org.wso2.carbon.identity.consent.mgt.listener.TenantConsentMgtListener.addDefaultPurposeCategory(TenantConsentMgtListener.java:99) at org.wso2.carbon.identity.consent.mgt.listener.TenantConsentMgtListener.onTenantCreate(TenantConsentMgtListener.java:44) at org.wso2.carbon.tenant.mgt.util.TenantMgtUtil.triggerAddTenant(TenantMgtUtil.java:160) at org.wso2.carbon.tenant.mgt.services.TenantMgtImpl.notifyTenantAddition(TenantMgtImpl.java:538) ... 63 more Caused by: org.wso2.carbon.consent.mgt.core.exception.ConsentManagementServerException: Error occurred while retrieving purpose category fromDB for the Name: DEFAULT. at org.wso2.carbon.consent.mgt.core.util.ConsentUtils.handleServerException(ConsentUtils.java:64) at org.wso2.carbon.consent.mgt.core.dao.impl.PurposeCategoryDAOImpl.getPurposeCategoryByName(PurposeCategoryDAOImpl.java:200) at org.wso2.carbon.consent.mgt.core.ConsentManagerImpl.getPurposeCategoryFromName(ConsentManagerImpl.java:820) at org.wso2.carbon.consent.mgt.core.ConsentManagerImpl.isPurposeCategoryExists(ConsentManagerImpl.java:464) at org.wso2.carbon.consent.mgt.core.ConsentManagerImpl.validateInputParameters(ConsentManagerImpl.java:1160) at org.wso2.carbon.consent.mgt.core.ConsentManagerImpl.addPurposeCategory(ConsentManagerImpl.java:340) at org.wso2.carbon.consent.mgt.core.PrivilegedConsentManagerImpl$9.execute(PrivilegedConsentManagerImpl.java:320) at org.wso2.carbon.consent.mgt.core.PrivilegedConsentManagerImpl$9.execute(PrivilegedConsentManagerImpl.java:316) at org.wso2.carbon.consent.mgt.core.model.ConsentInterceptorTemplate.executeWith(ConsentInterceptorTemplate.java:56) at org.wso2.carbon.consent.mgt.core.PrivilegedConsentManagerImpl.addPurposeCategory(PrivilegedConsentManagerImpl.java:316) at org.wso2.carbon.identity.consent.mgt.listener.TenantConsentMgtListener.addDefaultPurposeCategory(TenantConsentMgtListener.java:92) ... 66 more Caused by: org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException: Error in performing Database query: '%s'SELECT ID, NAME, DESCRIPTION, TENANT_ID FROM CM_PURPOSE_CATEGORY WHERE NAME = ? AND TENANT_ID = ? at org.wso2.carbon.database.utils.jdbc.JdbcTemplate.fetchSingleRecord(JdbcTemplate.java:206) at org.wso2.carbon.consent.mgt.core.dao.impl.PurposeCategoryDAOImpl.getPurposeCategoryByName(PurposeCategoryDAOImpl.java:189) ... 75 more Caused by: java.sql.SQLSyntaxErrorException: Table 'WSO2IS_IDENTITY_DB.CM_PURPOSE_CATEGORY' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118) at jdk.proxy8/jdk.proxy8.$Proxy63.executeQuery(Unknown Source) at org.wso2.carbon.database.utils.jdbc.JdbcTemplate.fetchSingleRecord(JdbcTemplate.java:191)

I saw that in this pull was fixed #199, but this is for v5.10.x version.

Why isn't this fix applied by default in version 7.1.0?

Thanks.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions