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

2018-08-02 Thread 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  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 
> 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
>>

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

2018-08-01 Thread 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 ?

[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 
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
>

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

2018-08-01 Thread 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)