wso2 IS Table 'wso2.sp_app' doesn't exist -
i trying started ws02 identityserver 5.0. have changed default data source mysql 5.6. have executed scripts in wso2is-5.0.0\dbscripts\mysql.sql , wso2is-5.0.0\dbscripts\identity\mysql.sql.
the server starts without errors. however, when try create user local dashboard below exception thrown. missing here? appreciated.
[2015-07-08 16:19:25,729] error {org.wso2.carbon.identity.provisioning.outboundprovisioningmanager} - error while out-bound provisioning. org.wso2.carbon.identity.application.common.identityapplicationmanagementexception: failed update service provider 0 @ org.wso2.carbon.identity.application.mgt.dao.impl.applicationdaoimpl.getapplication(applicationdaoimpl.java:1090) @ org.wso2.carbon.identity.application.mgt.applicationinfoprovider.getserviceprovider(applicationinfoprovider.java:178) @ org.wso2.carbon.identity.provisioning.outboundprovisioningmanager.provision(outboundprovisioningmanager.java:343) @ org.wso2.carbon.identity.provisioning.listener.defaultinbounduserprovisioninglistener.dopreadduser(defaultinbounduserprovisioninglistener.java:127) @ org.wso2.carbon.user.core.common.abstractuserstoremanager.adduser(abstractuserstoremanager.java:1063) @ org.wso2.carbon.user.core.common.abstractuserstoremanager.adduser(abstractuserstoremanager.java:1022) @ org.wso2.carbon.user.core.common.abstractuserstoremanager.adduser(abstractuserstoremanager.java:1164) @ org.wso2.carbon.identity.user.registration.userregistrationservice.adduser(userregistrationservice.java:231) @ org.wso2.carbon.identity.user.registration.userregistrationservice.adduser(userregistrationservice.java:162) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) @ java.lang.reflect.method.invoke(unknown source) @ org.apache.axis2.rpc.receivers.rpcutil.invokeserviceclass(rpcutil.java:212) @ org.apache.axis2.rpc.receivers.rpcinonlymessagereceiver.invokebusinesslogic(rpcinonlymessagereceiver.java:66) @ org.apache.axis2.receivers.abstractmessagereceiver.receive(abstractmessagereceiver.java:110) @ org.apache.axis2.engine.axisengine.receive(axisengine.java:180) @ org.apache.axis2.transport.http.httptransportutils.processhttppostrequest(httptransportutils.java:172) @ org.apache.axis2.transport.http.axisservlet.dopost(axisservlet.java:146) @ org.wso2.carbon.core.transports.carbonservlet.dopost(carbonservlet.java:231) @ javax.servlet.http.httpservlet.service(httpservlet.java:755) @ javax.servlet.http.httpservlet.service(httpservlet.java:848) @ org.eclipse.equinox.http.servlet.internal.servletregistration.service(servletregistration.java:61) @ org.eclipse.equinox.http.servlet.internal.proxyservlet.processalias(proxyservlet.java:128) @ org.eclipse.equinox.http.servlet.internal.proxyservlet.service(proxyservlet.java:68) @ javax.servlet.http.httpservlet.service(httpservlet.java:848) @ org.wso2.carbon.tomcat.ext.servlet.delegationservlet.service(delegationservlet.java:68) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.wso2.carbon.tomcat.ext.filter.charactersetfilter.dofilter(charactersetfilter.java:61) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:171) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99) @ org.wso2.carbon.tomcat.ext.valves.compositevalve.continueinvocation(compositevalve.java:178) @ org.wso2.carbon.tomcat.ext.valves.carbontomcatvalve$1.invoke(carbontomcatvalve.java:47) @ org.wso2.carbon.webapp.mgt.tenantlazyloadervalve.invoke(tenantlazyloadervalve.java:56) @ org.wso2.carbon.tomcat.ext.valves.tomcatvalvecontainer.invokevalves(tomcatvalvecontainer.java:47) @ org.wso2.carbon.tomcat.ext.valves.compositevalve.invoke(compositevalve.java:141) @ org.wso2.carbon.tomcat.ext.valves.carbonstuckthreaddetectionvalve.invoke(carbonstuckthreaddetectionvalve.java:156) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:936) @ org.wso2.carbon.tomcat.ext.valves.carboncontextcreatorvalve.invoke(carboncontextcreatorvalve.java:52) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:407) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1004) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:589) @ org.apache.tomcat.util.net.nioendpoint$socketprocessor.run(nioendpoint.java:1653) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source) caused by: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: table 'wso2.sp_app' doesn't exist @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source) @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source) @ java.lang.reflect.constructor.newinstance(unknown source) @ com.mysql.jdbc.util.handlenewinstance(util.java:389) @ com.mysql.jdbc.util.getinstance(util.java:372) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:980) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3835) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3771) @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:2435) @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2582) @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2535) @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:1911) @ com.mysql.jdbc.preparedstatement.executequery(preparedstatement.java:2034) @ org.wso2.carbon.identity.application.mgt.dao.impl.applicationdaoimpl.getbasicapplicationdata(applicationdaoimpl.java:1121) @ org.wso2.carbon.identity.application.mgt.dao.impl.applicationdaoimpl.getapplication(applicationdaoimpl.java:1042) ... 52 more [2015-07-08 16:19:29,520] error {org.wso2.carbon.identity.application.authentication.framework.handler.request.impl.defaultrequestcoordinator} - exception in uthentication framework org.wso2.carbon.identity.application.authentication.framework.exception.frameworkexception: error while reading application @ org.wso2.carbon.identity.application.authentication.framework.config.builder.uibasedconfigurationbuilder.getsequence(uibasedconfigurationbuilder.java :77) @ org.wso2.carbon.identity.application.authentication.framework.config.configurationfacade.getsequenceconfig(configurationfacade.java:64) @ org.wso2.carbon.identity.application.authentication.framework.handler.request.impl.defaultrequestcoordinator.findpreviousauthenticatedsession(default requestcoordinator.java:212) @ org.wso2.carbon.identity.application.authentication.framework.handler.request.impl.defaultrequestcoordinator.initializeflow(defaultrequestcoordinator .java:201) @ org.wso2.carbon.identity.application.authentication.framework.handler.request.impl.defaultrequestcoordinator.handle(defaultrequestcoordinator.java:61 ) @ org.wso2.carbon.identity.application.authentication.framework.servlet.commonauthenticationservlet.dopost(commonauthenticationservlet.java:51) @ org.wso2.carbon.identity.application.authentication.framework.servlet.commonauthenticationservlet.doget(commonauthenticationservlet.java:44) @ javax.servlet.http.httpservlet.service(httpservlet.java:735) @ javax.servlet.http.httpservlet.service(httpservlet.java:848) @ org.eclipse.equinox.http.helper.contextpathservletadaptor.service(contextpathservletadaptor.java:37) @ org.eclipse.equinox.http.servlet.internal.servletregistration.service(servletregistration.java:61) @ org.eclipse.equinox.http.servlet.internal.proxyservlet.processalias(proxyservlet.java:128) @ org.eclipse.equinox.http.servlet.internal.proxyservlet.service(proxyservlet.java:60) @ javax.servlet.http.httpservlet.service(httpservlet.java:848) @ org.wso2.carbon.tomcat.ext.servlet.delegationservlet.service(delegationservlet.java:68) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.wso2.carbon.tomcat.ext.filter.charactersetfilter.dofilter(charactersetfilter.java:61) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:243) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:222) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:123) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:171) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:99) @ org.wso2.carbon.tomcat.ext.valves.compositevalve.continueinvocation(compositevalve.java:178) @ org.wso2.carbon.tomcat.ext.valves.carbontomcatvalve$1.invoke(carbontomcatvalve.java:47) @ org.wso2.carbon.webapp.mgt.tenantlazyloadervalve.invoke(tenantlazyloadervalve.java:56) @ org.wso2.carbon.tomcat.ext.valves.tomcatvalvecontainer.invokevalves(tomcatvalvecontainer.java:47) @ org.wso2.carbon.tomcat.ext.valves.compositevalve.invoke(compositevalve.java:141) @ org.wso2.carbon.tomcat.ext.valves.carbonstuckthreaddetectionvalve.invoke(carbonstuckthreaddetectionvalve.java:156) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:936) @ org.wso2.carbon.tomcat.ext.valves.carboncontextcreatorvalve.invoke(carboncontextcreatorvalve.java:52) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:407) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1004) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:589) @ org.apache.tomcat.util.net.nioendpoint$socketprocessor.run(nioendpoint.java:1653) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source) caused by: org.wso2.carbon.identity.application.common.identityapplicationmanagementexception: error while reading application @ org.wso2.carbon.identity.application.mgt.dao.impl.applicationdaoimpl.getserviceprovidernamebyclientid(applicationdaoimpl.java:2293) @ org.wso2.carbon.identity.application.mgt.applicationinfoprovider.getserviceprovidernamebyclientid(applicationinfoprovider.java:150) @ org.wso2.carbon.identity.application.mgt.applicationinfoprovider.getserviceproviderbyclienid(applicationinfoprovider.java:209) @ org.wso2.carbon.identity.application.authentication.framework.config.builder.uibasedconfigurationbuilder.getsequence(uibasedconfigurationbuilder.java :75) ... 40 more
issue resolved after running wso2is-5.0.0\dbscripts\identity\application-mgt\mysql.sql.
Comments
Post a Comment