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
<http://l.facebook.com/l.php?u=http%3A%2F%2Fwso2.com&h=gAQEswASa>
Email: [email protected]
Mobile: +94714155561
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to