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
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
