Hi,
Thanks Nuwan.
Yes the pack used for mysql db schema is couple of days old and do not contain
USER_DOMAIN field. We updated the database using latest build pack dbscripts
and was able to solve
the issue.
Thanks, Suhan
On Tue, Dec 8, 2015 at 3:26 PM, Nuwan Dias < [email protected] > wrote:
It seems like the DB schema you are using is outdated. The column USER_DOMAIN
was added recently by the IS folks.
Thanks, NuwanD.
On Tue, Dec 8, 2015 at 3:25 PM, Suhan Dharmasuriya < [email protected] > wrote:
Hi,
We are running tests on a distributed cluster setup and we are using mysql as
our database. We took the latest build from jenkins [1].
When we try to generate a key, we are getting the following error [2] on our
keymanager instances.
[1] https://wso2.org/jenkins/ job/product-apim_release-1.10.
x/org.wso2.am$wso2am/31/ [2] TID: [-1234] [] [2015-12-08 08:50:40,690] ERROR
{org.wso2.carbon.apimgt.impl. utils.APIUtil} - Error occurred while creating
OAuthApp
admin_RefreshTokenTestAPI- Application_PRODUCTION {org.wso2.carbon.apimgt.impl.
utils.APIUtil} org.wso2.carbon.identity. oauth. IdentityOAuthAdminException:
Error when executing the SQL : SELECT * FROM
IDN_OAUTH_CONSUMER_APPS WHERE USERNAME=? AND TENANT_ID=? AND USER_DOMAIN=? AND
APP_NAME=? at org.wso2.carbon.identity. oauth.dao.OAuthAppDAO.
isDuplicateApplication( OAuthAppDAO.java:384) at org.wso2.carbon.identity.
oauth.dao.OAuthAppDAO. addOAuthApplication( OAuthAppDAO.java:70) at
org.wso2.carbon.identity. oauth.OAuthAdminService.
registerOAuthApplicationData( OAuthAdminService.java:249) at
org.wso2.carbon.apimgt.keymgt. service. APIKeyMgtSubscriberService.
createOAuthApplication( APIKeyMgtSubscriberService. java:166) at sun.reflect.
NativeMethodAccessorImpl. invoke0(Native Method) at sun.reflect.
NativeMethodAccessorImpl. invoke( NativeMethodAccessorImpl.java: 57) at
sun.reflect. DelegatingMethodAccessorImpl. invoke(
DelegatingMethodAccessorImpl. java:43) at java.lang.reflect.Method.
invoke(Method.java:606) at org.apache.axis2.rpc. receivers.RPCUtil.
invokeServiceClass(RPCUtil. java:212) at org.apache.axis2.rpc.
receivers.RPCMessageReceiver. invokeBusinessLogic( RPCMessageReceiver.java:117)
at org.apache.axis2.receivers. AbstractInOutMessageReceiver.
invokeBusinessLogic( AbstractInOutMessageReceiver. java:40) at
org.apache.axis2.receivers. AbstractMessageReceiver. receive(
AbstractMessageReceiver.java: 110) at org.apache.axis2.engine.
AxisEngine.receive(AxisEngine. java:180) at org.apache.axis2.transport.
http.HTTPTransportUtils. processHTTPPostRequest( HTTPTransportUtils.java:173)
at org.apache.axis2.transport. http.AxisServlet.doPost( AxisServlet.java:146)
at org.wso2.carbon.core. transports.CarbonServlet.
doPost(CarbonServlet.java:231) at javax.servlet.http. HttpServlet.service(
HttpServlet.java:646) at javax.servlet.http. HttpServlet.service(
HttpServlet.java:727) at org.eclipse.equinox.http. servlet.internal.
ServletRegistration.service( ServletRegistration.java:61) at
org.eclipse.equinox.http. servlet.internal.ProxyServlet.
processAlias(ProxyServlet. java:128) at org.eclipse.equinox.http.
servlet.internal.ProxyServlet. service(ProxyServlet.java:68) at
javax.servlet.http. HttpServlet.service( HttpServlet.java:727) at
org.wso2.carbon.tomcat.ext. servlet.DelegationServlet.
service(DelegationServlet. java:68) at org.apache.catalina.core.
ApplicationFilterChain. internalDoFilter( ApplicationFilterChain.java: 303) at
org.apache.catalina.core. ApplicationFilterChain. doFilter(
ApplicationFilterChain.java: 208) at org.apache.tomcat.websocket.
server.WsFilter.doFilter( WsFilter.java:52) at org.apache.catalina.core.
ApplicationFilterChain. internalDoFilter( ApplicationFilterChain.java: 241) at
org.apache.catalina.core. ApplicationFilterChain. doFilter(
ApplicationFilterChain.java: 208) at org.wso2.carbon.ui.filters.
CSRFPreventionFilter.doFilter( CSRFPreventionFilter.java:88) at
org.apache.catalina.core. ApplicationFilterChain. internalDoFilter(
ApplicationFilterChain.java: 241) at org.apache.catalina.core.
ApplicationFilterChain. doFilter( ApplicationFilterChain.java: 208) at
org.wso2.carbon.ui.filters. CRLFPreventionFilter.doFilter(
CRLFPreventionFilter.java:61) at org.apache.catalina.core.
ApplicationFilterChain. internalDoFilter( ApplicationFilterChain.java: 241) at
org.apache.catalina.core. ApplicationFilterChain. doFilter(
ApplicationFilterChain.java: 208) at org.wso2.carbon.tomcat.ext.
filter.CharacterSetFilter. doFilter(CharacterSetFilter. java:61) at
org.apache.catalina.core. ApplicationFilterChain. internalDoFilter(
ApplicationFilterChain.java: 241) at org.apache.catalina.core.
ApplicationFilterChain. doFilter( ApplicationFilterChain.java: 208) at
org.apache.catalina.core. StandardWrapperValve.invoke(
StandardWrapperValve.java:220) at org.apache.catalina.core.
StandardContextValve.invoke( StandardContextValve.java:122) at
org.apache.catalina. authenticator. AuthenticatorBase.invoke(
AuthenticatorBase.java:504) at org.apache.catalina.core.
StandardHostValve.invoke( StandardHostValve.java:170) at
org.apache.catalina.valves. ErrorReportValve.invoke( ErrorReportValve.java:103)
at org.wso2.carbon.tomcat.ext. valves.CompositeValve. continueInvocation(
CompositeValve.java:99) at org.wso2.carbon.tomcat.ext.
valves.CarbonTomcatValve$1. invoke(CarbonTomcatValve.java: 47) at
org.wso2.carbon.webapp.mgt. TenantLazyLoaderValve.invoke(
TenantLazyLoaderValve.java:57) at org.wso2.carbon.tomcat.ext.
valves.TomcatValveContainer. invokeValves( TomcatValveContainer.java:47) at
org.wso2.carbon.tomcat.ext. valves.CompositeValve.invoke(
CompositeValve.java:62) at org.wso2.carbon.tomcat.ext. valves.
CarbonStuckThreadDetectionValv e.invoke( CarbonStuckThreadDetectionValv
e.java:159) at org.apache.catalina.valves. AccessLogValve.invoke(
AccessLogValve.java:950) at org.wso2.carbon.tomcat.ext. valves.
CarbonContextCreatorValve. invoke( CarbonContextCreatorValve. java:57) at
org.apache.catalina.core. StandardEngineValve.invoke(
StandardEngineValve.java:116) at org.apache.catalina.connector.
CoyoteAdapter.service( CoyoteAdapter.java:421) at org.apache.coyote.http11.
AbstractHttp11Processor. process( AbstractHttp11Processor.java: 1074) at
org.apache.coyote. AbstractProtocol$ AbstractConnectionHandler.
process(AbstractProtocol.java: 611) at org.apache.tomcat.util.net.
NioEndpoint$SocketProcessor. doRun(NioEndpoint.java:1739) at
org.apache.tomcat.util.net. NioEndpoint$SocketProcessor.
run(NioEndpoint.java:1698) at java.util.concurrent.
ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1145) at
java.util.concurrent. ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:615) at org.apache.tomcat.util. threads.TaskThread$
WrappingRunnable.run( TaskThread.java:61) at java.lang.Thread.run(Thread.
java:745) Caused by: com.mysql.jdbc.exceptions. jdbc4.
MySQLSyntaxErrorException: Unknown column ' USER_DOMAIN ' in 'where clause' at
sun.reflect. NativeConstructorAccessorImpl. newInstance0(Native Method) at
sun.reflect. NativeConstructorAccessorImpl. newInstance(
NativeConstructorAccessorImpl. java:57) at sun.reflect.
DelegatingConstructorAccessorI mpl.newInstance( DelegatingConstructorAccessorI
mpl.java:45) at java.lang.reflect.Constructor. newInstance(Constructor.java:
526) at com.mysql.jdbc.Util. handleNewInstance(Util.java: 377) at
com.mysql.jdbc.Util. getInstance(Util.java:360) at com.mysql.jdbc.SQLError.
createSQLException(SQLError. java:978) at com.mysql.jdbc.MysqlIO.
checkErrorPacket(MysqlIO.java: 3887) at com.mysql.jdbc.MysqlIO.
checkErrorPacket(MysqlIO.java: 3823) at com.mysql.jdbc.MysqlIO.
sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.
sqlQueryDirect(MysqlIO.java: 2582) at com.mysql.jdbc.ConnectionImpl.
execSQL(ConnectionImpl.java: 2530) at com.mysql.jdbc. PreparedStatement.
executeInternal( PreparedStatement.java:1907) at com.mysql.jdbc.
PreparedStatement. executeQuery( PreparedStatement.java:2030) at
org.wso2.carbon.identity. oauth.dao.OAuthAppDAO. isDuplicateApplication(
OAuthAppDAO.java:378) ... 59 more
What can be the cause for this error?
Thanks, Suhan
Suhan Dharmasuriya Software Engineer - Test AutomationWSO2, Inc.
lean . enterprise . middleware
Tel: +94 112 145345 Mob: +94 779 869138 Blog: http://suhan-opensource.
blogspot.com/
--
Nuwan Dias
Technical Lead - WSO2, Inc. http://wso2.com email : [email protected] Phone : +94
777 775 729
Suhan Dharmasuriya Software Engineer - Test AutomationWSO2, Inc.
lean . enterprise . middleware
Tel: +94 112 145345 Mob: +94 779 869138 Blog:
http://suhan-opensource.blogspot.com/_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
