Re: [Dev] [EMM] Registry Exception thrown at EMM publisher/store login

2016-10-06 Thread Dinusha Senanayaka
This happens because two different products trying to share the same config
registry and having conflicting resources.  If products are deployed
separately then we can mount config registry to different paths, but here
EMM needs both features to be install in same product.

One option would be to prefix the resource with product name, so that
resource path will be different. But this won't look nice from product
perspective. Also need migration client for existing users if we are doing
it now.
eg: /_system/config/repository/components/org.wso2.carbon.registry/queries/
*tag-summary-appmgt*

@Nuwan: Any ideas ?

Regards,
Dinusha.

On Thu, Oct 6, 2016 at 3:18 PM, Kamidu Punchihewa  wrote:

> Hi Sameera,
>
> This is a know issue with EMM 2.2.0-beta pack. You can track the progress
> of the issue by following the Jira ticket[1].
>
> [1] https://wso2.org/jira/browse/EMM-1669
>
> Thanks and Best Regards,
>
> Kamidu Sachith Punchihewa
> *Software Engineer*
> WSO2, Inc.
> lean . enterprise . middleware
> Mobile : +94 (0) 770566749 <%2B94%20%280%29%20773%20451194>
>
>
> Disclaimer: This communication may contain privileged or other
> confidential information and is intended exclusively for the addressee/s.
> If you are not the intended recipient/s, or believe that you may have
> received this communication in error, please reply to the sender indicating
> that fact and delete the copy you received and in addition, you should not
> print, copy, retransmit, disseminate, or otherwise use the information
> contained in this communication. Internet communications cannot be
> guaranteed to be timely, secure, error or virus-free. The sender does not
> accept liability for any errors or omissions.
>
> On Thu, Oct 6, 2016 at 3:14 PM, Sameera Gunarathne 
> wrote:
>
>> Hi all,
>>
>> After login to the EMM app publisher/store we can see the following
>> error:
>>
>> [2016-10-03 13:51:00,155] ERROR 
>> {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry}
>> -  Registry Exception occurred while executing the query
>> org.wso2.carbon.registry.core.exceptions.RegistryException: Invalid
>> value "8" for parameter "parameterIndex" [90008-175]
>> at org.wso2.carbon.registry.core.jdbc.dataaccess.SQLQueryProces
>> sor.executeQuery(SQLQueryProcessor.java:239)
>> at org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorMan
>> ager.executeQuery(QueryProcessorManager.java:137)
>> at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.executeQ
>> uery(EmbeddedRegistry.java:2283)
>> at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.ex
>> ecuteQuery(CacheBackedRegistry.java:480)
>> at org.wso2.carbon.registry.core.session.UserRegistry.executeQu
>> eryInternal(UserRegistry.java:1757)
>> at org.wso2.carbon.registry.core.session.UserRegistry.access$35
>> 00(UserRegistry.java:61)
>> at org.wso2.carbon.registry.core.session.UserRegistry$36.run(Us
>> erRegistry.java:1705)
>> at org.wso2.carbon.registry.core.session.UserRegistry$36.run(Us
>> erRegistry.java:1702)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at org.wso2.carbon.registry.core.session.UserRegistry.executeQu
>> ery(UserRegistry.java:1702)
>> at org.wso2.carbon.appmgt.impl.APIConsumerImpl.getAllTags(APICo
>> nsumerImpl.java:843)
>> at 
>> org.wso2.carbon.appmgt.impl.UserAwareAPIConsumer.getAllTags(UserAwareAPIConsumer.java:39)
>> ..
>>
>> After some debugging it seems to be both APIM feature and APPM feature
>> trying to execute same query at the registry path /_system/config/repositor
>> y/components/org.wso2.carbon.registry/queries/tag-summary [1]. Since
>> they are different queries [2] & [3] when loading the APPM publisher/store
>> components it triggers this error. Then I built carbon-appmgt locally by
>> giving a different path to store query scripts. Then the issue is fixed.
>> Seems like if it can be done to either of the components this issue can be
>> fixed. Any help or suggestions highly appreciated.
>>
>> [1]
>>
>> [2] - https://github.com/wso2/carbon-apimgt/blob/d37855ec3551c97
>> c70166d990504801b2d72d18b/components/apimgt/org.wso2.
>> carbon.apimgt.impl/src/main/java/org/wso2/carbon/apimgt/
>> impl/AbstractAPIManager.java#L210
>>
>> [3] - https://github.com/wso2/carbon-appmgt/blob/master/componen
>> ts/org.wso2.carbon.appmgt.impl/src/main/java/org/wso2/
>> carbon/appmgt/impl/AbstractAPIManager.java#L152
>>
>> Thanks & Regards,
>> --
>> Sameera Gunarathne
>> Software Engineer, WSO2 Inc. http://wso2.com
>> 
>> Email: samee...@wso2.com
>> Mobile: +94714155561
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Dinusha Dilrukshi
Associate Technical Lead
WSO2 Inc.: http://wso2.com/
Mobile: +94725255071
Blog: http://dinushasblog.blogspot.com/
__

Re: [Dev] [EMM] Registry Exception thrown at EMM publisher/store login

2016-10-06 Thread Kamidu Punchihewa
Hi Sameera,

This is a know issue with EMM 2.2.0-beta pack. You can track the progress
of the issue by following the Jira ticket[1].

[1] https://wso2.org/jira/browse/EMM-1669

Thanks and Best Regards,

Kamidu Sachith Punchihewa
*Software Engineer*
WSO2, Inc.
lean . enterprise . middleware
Mobile : +94 (0) 770566749 <%2B94%20%280%29%20773%20451194>


Disclaimer: This communication may contain privileged or other confidential
information and is intended exclusively for the addressee/s. If you are not
the intended recipient/s, or believe that you may have received this
communication in error, please reply to the sender indicating that fact and
delete the copy you received and in addition, you should not print, copy,
retransmit, disseminate, or otherwise use the information contained in this
communication. Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability for any
errors or omissions.

On Thu, Oct 6, 2016 at 3:14 PM, Sameera Gunarathne 
wrote:

> Hi all,
>
> After login to the EMM app publisher/store we can see the following error:
>
> [2016-10-03 13:51:00,155] ERROR 
> {org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry}
> -  Registry Exception occurred while executing the query
> org.wso2.carbon.registry.core.exceptions.RegistryException: Invalid value
> "8" for parameter "parameterIndex" [90008-175]
> at org.wso2.carbon.registry.core.jdbc.dataaccess.SQLQueryProcessor.
> executeQuery(SQLQueryProcessor.java:239)
> at org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorManager.
> executeQuery(QueryProcessorManager.java:137)
> at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.
> executeQuery(EmbeddedRegistry.java:2283)
> at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.executeQuery(
> CacheBackedRegistry.java:480)
> at org.wso2.carbon.registry.core.session.UserRegistry.
> executeQueryInternal(UserRegistry.java:1757)
> at org.wso2.carbon.registry.core.session.UserRegistry.access$
> 3500(UserRegistry.java:61)
> at org.wso2.carbon.registry.core.session.UserRegistry$36.run(
> UserRegistry.java:1705)
> at org.wso2.carbon.registry.core.session.UserRegistry$36.run(
> UserRegistry.java:1702)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.wso2.carbon.registry.core.session.UserRegistry.
> executeQuery(UserRegistry.java:1702)
> at org.wso2.carbon.appmgt.impl.APIConsumerImpl.getAllTags(
> APIConsumerImpl.java:843)
> at 
> org.wso2.carbon.appmgt.impl.UserAwareAPIConsumer.getAllTags(UserAwareAPIConsumer.java:39)
> ..
>
> After some debugging it seems to be both APIM feature and APPM feature
> trying to execute same query at the registry path /_system/config/
> repository/components/org.wso2.carbon.registry/queries/tag-summary [1].
> Since they are different queries [2] & [3] when loading the APPM
> publisher/store components it triggers this error. Then I built
> carbon-appmgt locally by giving a different path to store query scripts.
> Then the issue is fixed. Seems like if it can be done to either of the
> components this issue can be fixed. Any help or suggestions highly
> appreciated.
>
> [1]
>
> [2] - https://github.com/wso2/carbon-apimgt/blob/
> d37855ec3551c97c70166d990504801b2d72d18b/components/apimgt/
> org.wso2.carbon.apimgt.impl/src/main/java/org/wso2/carbon/apimgt/impl/
> AbstractAPIManager.java#L210
>
> [3] - https://github.com/wso2/carbon-appmgt/blob/master/
> components/org.wso2.carbon.appmgt.impl/src/main/java/org/
> wso2/carbon/appmgt/impl/AbstractAPIManager.java#L152
>
> Thanks & Regards,
> --
> Sameera Gunarathne
> Software Engineer, WSO2 Inc. http://wso2.com
> 
> Email: samee...@wso2.com
> Mobile: +94714155561
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev


[Dev] [EMM] Registry Exception thrown at EMM publisher/store login

2016-10-06 Thread Sameera Gunarathne
Hi all,

After login to the EMM app publisher/store we can see the following error:

[2016-10-03 13:51:00,155] ERROR
{org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry} -  Registry Exception
occurred while executing the query
org.wso2.carbon.registry.core.exceptions.RegistryException: Invalid value
"8" for parameter "parameterIndex" [90008-175]
at
org.wso2.carbon.registry.core.jdbc.dataaccess.SQLQueryProcessor.executeQuery(SQLQueryProcessor.java:239)
at
org.wso2.carbon.registry.core.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:137)
at
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.executeQuery(EmbeddedRegistry.java:2283)
at
org.wso2.carbon.registry.core.caching.CacheBackedRegistry.executeQuery(CacheBackedRegistry.java:480)
at
org.wso2.carbon.registry.core.session.UserRegistry.executeQueryInternal(UserRegistry.java:1757)
at
org.wso2.carbon.registry.core.session.UserRegistry.access$3500(UserRegistry.java:61)
at
org.wso2.carbon.registry.core.session.UserRegistry$36.run(UserRegistry.java:1705)
at
org.wso2.carbon.registry.core.session.UserRegistry$36.run(UserRegistry.java:1702)
at java.security.AccessController.doPrivileged(Native Method)
at
org.wso2.carbon.registry.core.session.UserRegistry.executeQuery(UserRegistry.java:1702)
at
org.wso2.carbon.appmgt.impl.APIConsumerImpl.getAllTags(APIConsumerImpl.java:843)
at
org.wso2.carbon.appmgt.impl.UserAwareAPIConsumer.getAllTags(UserAwareAPIConsumer.java:39)
..

After some debugging it seems to be both APIM feature and APPM feature
trying to execute same query at the registry
path 
/_system/config/repository/components/org.wso2.carbon.registry/queries/tag-summary
[1]. Since they are different queries [2] & [3] when loading the APPM
publisher/store components it triggers this error. Then I built
carbon-appmgt locally by giving a different path to store query scripts.
Then the issue is fixed. Seems like if it can be done to either of the
components this issue can be fixed. Any help or suggestions highly
appreciated.

[1]

[2] -
https://github.com/wso2/carbon-apimgt/blob/d37855ec3551c97c70166d990504801b2d72d18b/components/apimgt/org.wso2.carbon.apimgt.impl/src/main/java/org/wso2/carbon/apimgt/impl/AbstractAPIManager.java#L210

[3] -
https://github.com/wso2/carbon-appmgt/blob/master/components/org.wso2.carbon.appmgt.impl/src/main/java/org/wso2/carbon/appmgt/impl/AbstractAPIManager.java#L152

Thanks & Regards,
-- 
Sameera Gunarathne
Software Engineer, WSO2 Inc. http://wso2.com

Email: samee...@wso2.com
Mobile: +94714155561
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev