'ORA-00972: identifier is too long' thrown when running IS Integration Tests with Oracle 12.1.0.2

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

'ORA-00972: identifier is too long' thrown when running IS Integration Tests with Oracle 12.1.0.2

Maneesha Wijesekara
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



Regards
Maneesha


--
Maneesha Wijesekara
Software Engineer - QA Team
WSO2 Inc.

Mobile: <a href="tel:%2B94712443119" value="+94774171471" target="_blank">+94712443119

_______________________________________________
Dev mailing list
[hidden email]
http://wso2.org/cgi-bin/mailman/listinfo/dev
Reply | Threaded
Open this post in threaded view
|

Re: 'ORA-00972: identifier is too long' thrown when running IS Integration Tests with Oracle 12.1.0.2

Omindu Rathnaweera
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 ?


Regards,
Omindu.


On Wed, Aug 1, 2018 at 1:02 PM Maneesha Wijesekara <[hidden email]> 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



Regards
Maneesha


--
Maneesha Wijesekara
Software Engineer - QA Team
WSO2 Inc.

Mobile: <a href="tel:%2B94712443119" value="+94774171471" target="_blank">+94712443119


--
Omindu Rathnaweera
Senior Software Engineer, WSO2 Inc.
Mobile: +94 771 197 211

_______________________________________________
Dev mailing list
[hidden email]
http://wso2.org/cgi-bin/mailman/listinfo/dev
Reply | Threaded
Open this post in threaded view
|

Re: 'ORA-00972: identifier is too long' thrown when running IS Integration Tests with Oracle 12.1.0.2

Maneesha Wijesekara
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 <[hidden email]> 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 ?


Regards,
Omindu.


On Wed, Aug 1, 2018 at 1:02 PM Maneesha Wijesekara <[hidden email]> 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



Regards
Maneesha


--
Maneesha Wijesekara
Software Engineer - QA Team
WSO2 Inc.

Mobile: <a href="tel:%2B94712443119" value="+94774171471" target="_blank">+94712443119


--
Omindu Rathnaweera
Senior Software Engineer, WSO2 Inc.
Mobile: +94 771 197 211



--
Maneesha Wijesekara
Software Engineer - QA Team
WSO2 Inc.

Mobile: <a href="tel:%2B94712443119" value="+94774171471" target="_blank">+94712443119

_______________________________________________
Dev mailing list
[hidden email]
http://wso2.org/cgi-bin/mailman/listinfo/dev