Hi Maneesha, Fixed this in the master branch with [1] and will be added in the next release. Can you use the new script [2] in your test for the time being ?
[1] - https://github.com/wso2/carbon-identity-framework/pull/1772 [2] - https://github.com/wso2/carbon-identity-framework/blob/master/features/identity-core/org.wso2.carbon.identity.core.server.feature/resources/dbscripts/oracle.sql Regards, Omindu. On Wed, Aug 1, 2018 at 1:02 PM Maneesha Wijesekara <[email protected]> wrote: > Hi All, > > I'm trying to run IS integration tests with latest Identity Server 5.7 M5 > pack against Oracle 12.1.0.2 as the Database. But the integration tests > were failing due to 'ORA-00972: identifier is too long' with following > stacktrace. > > This happens when try to create an index which has more than 30 characters > as the name with Oracle. According to [1], this doesn't caused with Oracle > 12.2 or higher versions but for the lower versions it does. Do we have any > workaround or a fix for this ? Really appreciate any inputs on this. > > [2018-07-31 16:13:13,847] ERROR > {org.wso2.carbon.identity.core.internal.IdentityCoreServiceComponent} - > Error occurred while populating identity configuration properties INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - > org.wso2.carbon.identity.base.IdentityRuntimeException: > java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.identity.base.IdentityRuntimeException.error(IdentityRuntimeException.java:71) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.executeSQL(IdentityDBInitializer.java:351) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.executeSQLScript(IdentityDBInitializer.java:264) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.createIdentityDatabase(IdentityDBInitializer.java:141) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.identity.core.persistence.JDBCPersistenceManager.initializeDatabase(JDBCPersistenceManager.java:112) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.identity.core.internal.IdentityCoreServiceComponent.activate(IdentityCoreServiceComponent.java:133) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at java.lang.reflect.Method.invoke(Method.java:498) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:515) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServerManager.java:291) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.wso2.carbon.core.init.PreAxis2ConfigItemListener.bundleChanged(PreAxis2ConfigItemListener.java:118) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:847) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - Caused by: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too > long INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at > oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at java.lang.reflect.Method.invoke(Method.java:498) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at com.sun.proxy.$Proxy19.execute(Unknown Source) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - at > org.wso2.carbon.identity.core.persistence.IdentityDBInitializer.executeSQL(IdentityDBInitializer.java:318) > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - ... 31 more INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - > Caused by: Error : 972, Position : 13, Sql = CREATE INDEX > IDX_IDN_AUTH_SESSION_STORE_TIME ON IDN_AUTH_SESSION_STORE (TIME_CREATED) , > OriginalSql = CREATE INDEX IDX_IDN_AUTH_SESSION_STORE_TIME ON > IDN_AUTH_SESSION_STORE (TIME_CREATED) , Error Msg = ORA-00972: identifier > is too long INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - > INFO [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] > - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) INFO > [org.wso2.carbon.automation.extensions.servers.utils.ServerLogReader] - ... > 49 more > > > [1] > https://stackoverflow.com/questions/3085562/ora-00972-identifier-is-too-long-alias-column-name#3085571 > > Regards > Maneesha > > > -- > Maneesha Wijesekara > Software Engineer - QA Team > WSO2 Inc. > > Email: [email protected] > Linkedin: http://linkedin.com/in/maneeshawijesekara > Mobile: +94712443119 > -- Omindu Rathnaweera Senior Software Engineer, WSO2 Inc. Mobile: +94 771 197 211
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
