Thanks a lot Omindu. I will use the updated scripts to run IS integration tests.
Regards Maneesha On Wed, Aug 1, 2018 at 8:54 PM, Omindu Rathnaweera <[email protected]> wrote: > 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 > -- Maneesha Wijesekara Software Engineer - QA Team WSO2 Inc. Email: [email protected] Linkedin: http://linkedin.com/in/maneeshawijesekara Mobile: +94712443119
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
