Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Oracle] Organization creation fail #22125

Open
aaujayasena opened this issue Jan 1, 2025 · 1 comment
Open

[Oracle] Organization creation fail #22125

aaujayasena opened this issue Jan 1, 2025 · 1 comment
Labels
Affected/7.1.0-m6 Issues that get reported against IS7.1.0 M6 pack will get this label DB/Oracle Oracle DB related Issues will be tracked under this label. Priority/Highest QA-Reported Issues reported by a QA Severity/Blocker Team/B2B Type/Bug

Comments

@aaujayasena
Copy link
Contributor

aaujayasena commented Jan 1, 2025 •
edited
Loading

Description

Carbon log

[2025-01-01 10:47:38,566] [5085092d-9d09-4927-8105-ee19fd30e1c7]  INFO {org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent} - Tenant 5 is not initialized correctly. Hence initializing the tenant registry
[2025-01-01 10:47:38,605] [5085092d-9d09-4927-8105-ee19fd30e1c7]  INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at configregistry in 0ms
[2025-01-01 10:47:38,606] [5085092d-9d09-4927-8105-ee19fd30e1c7]  INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at govregistry in 1ms
[2025-01-01 10:47:38,629] [5085092d-9d09-4927-8105-ee19fd30e1c7]  INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at configregistry in 0ms
[2025-01-01 10:47:38,629] [5085092d-9d09-4927-8105-ee19fd30e1c7]  INFO {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService} - Connected to mount at govregistry in 1ms
[2025-01-01 10:47:39,717] [5085092d-9d09-4927-8105-ee19fd30e1c7] ERROR {org.wso2.carbon.security.keystore.KeyStoreAdmin} - Error when adding a keyStore java.lang.SecurityException: Error while adding the key store.
	at org.wso2.carbon.keystore.persistence.impl.JDBCKeyStorePersistenceManager.addKeystore(JDBCKeyStorePersistenceManager.java:92)
	at org.wso2.carbon.core.util.KeyStoreManager.addKeyStore(KeyStoreManager.java:262)
	at org.wso2.carbon.core.util.KeyStoreManager.addKeyStore(KeyStoreManager.java:201)
	at org.wso2.carbon.security.keystore.KeyStoreAdmin.addKeyStore(KeyStoreAdmin.java:145)
	at org.wso2.carbon.keystore.mgt.KeyStoreGenerator.persistKeyStore(KeyStoreGenerator.java:239)
	at org.wso2.carbon.keystore.mgt.KeyStoreGenerator.generateKeyStore(KeyStoreGenerator.java:114)
	at org.wso2.carbon.keystore.mgt.KeystoreTenantMgtListener.onTenantCreate(KeystoreTenantMgtListener.java:43)
	at org.wso2.carbon.tenant.mgt.util.TenantMgtUtil.triggerAddTenant(TenantMgtUtil.java:160)
	at org.wso2.carbon.tenant.mgt.services.TenantMgtImpl.notifyTenantAddition(TenantMgtImpl.java:538)
	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)
	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:245)
	at org.wso2.carbon.identity.api.server.organization.management.v1.impl.OrganizationsApiServiceImpl.organizationPost(OrganizationsApiServiceImpl.java:126)
	at org.wso2.carbon.identity.api.server.organization.management.v1.OrganizationsApi.organizationPost(OrganizationsApi.java:178)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	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:119)
	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:149)
	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.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:383)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
	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:840)
Caused by: org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException: Error in performing Database query: '%s.' INSERT INTO KEY_STORE (NAME, TYPE, PROVIDER, PASSWORD, PRIVATE_KEY_ALIAS, PRIVATE_KEY_PASS, CONTENT, PUB_CERT_ID, TENANT_ID, VERSION, CREATED_AT, UPDATED_AT) VALUES (:NAME;, :TYPE;, :PROVIDER;, :PASSWORD;, :PRIVATE_KEY_ALIAS;, :PRIVATE_KEY_PASS;, :CONTENT;, :PUB_CERT_ID;, :TENANT_ID;, :VERSION;, :CREATED_AT;, :UPDATED_AT;);
	at org.wso2.carbon.database.utils.jdbc.NamedJdbcTemplate.executeInsert(NamedJdbcTemplate.java:322)
	at org.wso2.carbon.database.utils.jdbc.NamedJdbcTemplate.executeInsert(NamedJdbcTemplate.java:271)
	at org.wso2.carbon.keystore.persistence.impl.JDBCKeyStorePersistenceManager.addKeystore(JDBCKeyStorePersistenceManager.java:76)
	... 72 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Steps to Reproduce

  1. Login to console
  2. Navigate to Organization page
  3. Create new organization

Version

IS 7.1.0-m7

Environment Details (with versions)

Oracle 19c
@aaujayasena aaujayasena added Priority/Highest Severity/Blocker Type/Bug QA-Reported Issues reported by a QA DB/Oracle Oracle DB related Issues will be tracked under this label. Affected/7.1.0-m6 Issues that get reported against IS7.1.0 M6 pack will get this label labels Jan 1, 2025
@aaujayasena
Copy link
Contributor Author

This issue is due to the The placeholders (:NAME;, :TYPE;, etc.) use semicolons (;) incorrectly within parameter names. In Oracle SQL, parameter placeholders should not end with semicolons.

@aaujayasena aaujayasena mentioned this issue Jan 1, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Affected/7.1.0-m6 Issues that get reported against IS7.1.0 M6 pack will get this label DB/Oracle Oracle DB related Issues will be tracked under this label. Priority/Highest QA-Reported Issues reported by a QA Severity/Blocker Team/B2B Type/Bug
Projects
Identity Server 7.1.0
Status: No status
Milestone
No milestone
Development

No branches or pull requests
1 participant
@aaujayasena