Re: [Dev] [ESB] JdbcSQLException: File not found
Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:517) at org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219) at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at
Re: [Dev] [ESB] JdbcSQLException: File not found
Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara ma...@wso2.com wrote: Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:517) at org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219) at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
Re: [Dev] [ESB] JdbcSQLException: File not found
Thank you Danushka for the information. On Fri, Mar 6, 2015 at 4:49 PM, Danushka Fernando danush...@wso2.com wrote: Although we are shipping the product with H2 database we are not recommending to use it. We always recommend to use mysql or oracle. So you can point to a mysql db and start the server. So you want get in to this issue again. Thanks Regards Danushka Fernando Software Engineer WSO2 inc. http://wso2.com/ Mobile : +94716332729 On Fri, Mar 6, 2015 at 3:55 PM, Chathura Priyankara chathu...@wso2.com wrote: This error happened after remote debugging a Failover Endpoint with ESB sample 53 [1] configuration. [1] https://docs.wso2.com/display/ESB481/Sample+53%3A+Using+Failover+Endpoints+to+Handle+Peak+Loads Thanks! On Fri, Mar 6, 2015 at 3:50 PM, Manoj Kumara ma...@wso2.com wrote: Could be the database got corrupted somehow not sure why. Deleting the database files will not be a solution but we can do that when testing :) What was the operations you were doing ? *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara ma...@wso2.com wrote: Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at
Re: [Dev] [ESB] JdbcSQLException: File not found
Could be the database got corrupted somehow not sure why. Deleting the database files will not be a solution but we can do that when testing :) What was the operations you were doing ? *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara ma...@wso2.com wrote: Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) at
[Dev] [ESB] JdbcSQLException: File not found
Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451) at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:517) at org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219) at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at
Re: [Dev] [ESB] JdbcSQLException: File not found
This error happened after remote debugging a Failover Endpoint with ESB sample 53 [1] configuration. [1] https://docs.wso2.com/display/ESB481/Sample+53%3A+Using+Failover+Endpoints+to+Handle+Peak+Loads Thanks! On Fri, Mar 6, 2015 at 3:50 PM, Manoj Kumara ma...@wso2.com wrote: Could be the database got corrupted somehow not sure why. Deleting the database files will not be a solution but we can do that when testing :) What was the operations you were doing ? *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara ma...@wso2.com wrote: Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at
Re: [Dev] [ESB] JdbcSQLException: File not found
Although we are shipping the product with H2 database we are not recommending to use it. We always recommend to use mysql or oracle. So you can point to a mysql db and start the server. So you want get in to this issue again. Thanks Regards Danushka Fernando Software Engineer WSO2 inc. http://wso2.com/ Mobile : +94716332729 On Fri, Mar 6, 2015 at 3:55 PM, Chathura Priyankara chathu...@wso2.com wrote: This error happened after remote debugging a Failover Endpoint with ESB sample 53 [1] configuration. [1] https://docs.wso2.com/display/ESB481/Sample+53%3A+Using+Failover+Endpoints+to+Handle+Peak+Loads Thanks! On Fri, Mar 6, 2015 at 3:50 PM, Manoj Kumara ma...@wso2.com wrote: Could be the database got corrupted somehow not sure why. Deleting the database files will not be a solution but we can do that when testing :) What was the operations you were doing ? *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:36 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi Manoj, Thank you for the quick response. After deleting the content of database directory, using the -Dsetup parameter I can start the server. What is the issue here ? Regards, On Fri, Mar 6, 2015 at 3:20 PM, Manoj Kumara ma...@wso2.com wrote: Can you try deleting content on wso2esb-4.8.1/repository/database and start the server with -Dsetup parameter. Regards, Manoj *Manoj Kumara* Software Engineer WSO2 Inc. http://wso2.com/ *lean.enterprise.middleware* Mobile: +94713448188 On Fri, Mar 6, 2015 at 3:12 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, When restarting ESB after remote debugging I'm getting following exception. The ESB version is 4.8.1. How can I fix this issue ? [2015-03-06 15:02:26,371] ERROR - JDBCResourceDAO A SQLException error has occurred when trying to close result set or prepared statement org.h2.jdbc.JdbcSQLException: File not found: /home/chathura/office/training/training_project/ESB/wso2esb-4.8.1/repository/database/WSO2CARBON_DB.lobs.db/23.t22.lob.db [90124-140] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Database.openFile(Database.java:443) at org.h2.value.ValueLob.getInputStream(ValueLob.java:610) at org.h2.jdbc.JdbcResultSet.getBinaryStream(JdbcResultSet.java:1020) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getContentStream(JDBCResourceDAO.java:553) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResourceContentWithNoUpdate(JDBCResourceDAO.java:1239) at org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillResource(JDBCResourceDAO.java:271) at org.wso2.carbon.registry.core.jdbc.Repository.get(Repository.java:195) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:689) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:139) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:125) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(TenantThemeMgtServiceComponent.java:53) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:347) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at
