[Dev] Cannot do a -Dsetup after deleting the h2 database in Greg 5.0.0 pack
Hi All/BPS team,
We are getting the following error when we try to start the server with
-Dsetup option.
1. started the fresh pack normally
2. stopped the server and deleted the content in /repository/database
folder
3. restarted with -Dsetup
[2015-01-15 22:25:37,370] INFO
{org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent} -
Initialising HumanTask Server
[2015-01-15 22:25:37,442] ERROR
{org.wso2.carbon.utils.dbcreator.DatabaseCreator} - Error occurred while
executing SQL script for creating registry database
java.io.FileNotFoundException:
/home/pulasthi/wso2/greg5/wso2greg-5.0.0-SNAPSHOT/dbscripts/bps/bpel/create/h2.sql
(No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.init(FileInputStream.java:120)
at java.io.FileInputStream.init(FileInputStream.java:79)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:296)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)
at
org.wso2.carbon.humantask.core.db.Database.setupHumanTaskDatabase(Database.java:94)
at org.wso2.carbon.humantask.core.db.Database.start(Database.java:78)
at
org.wso2.carbon.humantask.core.HumanTaskServer.initDataSource(HumanTaskServer.java:166)
at
org.wso2.carbon.humantask.core.HumanTaskServer.init(HumanTaskServer.java:95)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.initHumanTaskServer(HumanTaskServiceComponent.java:100)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.activate(HumanTaskServiceComponent.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 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.attachment.mgt.server.internal.AttachmentServiceComponent.registerAttachmentServerService(AttachmentServiceComponent.java:98)
at
org.wso2.carbon.attachment.mgt.server.internal.AttachmentServiceComponent.activate(AttachmentServiceComponent.java:73)
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)
Re: [Dev] Cannot do a -Dsetup after deleting the h2 database in Greg 5.0.0 pack
Hi Hasitha,
Thanks for the quick response. Will check what you have mentioned and see.
Regards,
Pulasthi
On Jan 16, 2015 7:55 AM, Hasitha Aravinda hasi...@wso2.com wrote:
Hi Pulasthi,
I had a look at HumanTask featue, It is copying all DB scripts to correct
location. ( Carbon_Home/dbscripts/bps/bpel/create/ ). Please note that
we have changed [1] the dbscript structure for BPS 3.5.0.
Can you verify following.
1) To verify Humantak feature installation, check whether all DB scripts
are in Greg p2-profile target folder. ( in
Carbon_Home/dbscripts/bps/bpel/create/
)
2) Then check maven assembly in distribution build, whether it is poining
to correct location.
[1] Mail with Subject - dbscripts folder structure for BPS 3.5.0 @Dev
Thanks,
Hasitha.
On Thu, Jan 15, 2015 at 10:34 PM, Pulasthi Supun pulas...@wso2.com
wrote:
Hi All/BPS team,
We are getting the following error when we try to start the server with
-Dsetup option.
1. started the fresh pack normally
2. stopped the server and deleted the content in /repository/database
folder
3. restarted with -Dsetup
[2015-01-15 22:25:37,370] INFO
{org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent} -
Initialising HumanTask Server
[2015-01-15 22:25:37,442] ERROR
{org.wso2.carbon.utils.dbcreator.DatabaseCreator} - Error occurred while
executing SQL script for creating registry database
java.io.FileNotFoundException:
/home/pulasthi/wso2/greg5/wso2greg-5.0.0-SNAPSHOT/dbscripts/bps/bpel/create/h2.sql
(No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.init(FileInputStream.java:120)
at java.io.FileInputStream.init(FileInputStream.java:79)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:296)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)
at
org.wso2.carbon.humantask.core.db.Database.setupHumanTaskDatabase(Database.java:94)
at org.wso2.carbon.humantask.core.db.Database.start(Database.java:78)
at
org.wso2.carbon.humantask.core.HumanTaskServer.initDataSource(HumanTaskServer.java:166)
at
org.wso2.carbon.humantask.core.HumanTaskServer.init(HumanTaskServer.java:95)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.initHumanTaskServer(HumanTaskServiceComponent.java:100)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.activate(HumanTaskServiceComponent.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 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.attachment.mgt.server.internal.AttachmentServiceComponent.registerAttachmentServerService(AttachmentServiceComponent.java:98)
at
org.wso2.carbon.attachment.mgt.server.internal.AttachmentServiceComponent.activate(AttachmentServiceComponent.java:73)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
Re: [Dev] Cannot do a -Dsetup after deleting the h2 database in Greg 5.0.0 pack
Hi Hasitha,
Tested the changes and the issue was resolved.
Thanks,
Pulasthi
On Fri, Jan 16, 2015 at 9:59 AM, Pulasthi Supun pulas...@wso2.com wrote:
Hi Hasitha,
Thanks for the quick response. Will check what you have mentioned and see.
Regards,
Pulasthi
On Jan 16, 2015 7:55 AM, Hasitha Aravinda hasi...@wso2.com wrote:
Hi Pulasthi,
I had a look at HumanTask featue, It is copying all DB scripts to correct
location. ( Carbon_Home/dbscripts/bps/bpel/create/ ). Please note that
we have changed [1] the dbscript structure for BPS 3.5.0.
Can you verify following.
1) To verify Humantak feature installation, check whether all DB scripts
are in Greg p2-profile target folder. ( in
Carbon_Home/dbscripts/bps/bpel/create/
)
2) Then check maven assembly in distribution build, whether it is poining
to correct location.
[1] Mail with Subject - dbscripts folder structure for BPS 3.5.0 @Dev
Thanks,
Hasitha.
On Thu, Jan 15, 2015 at 10:34 PM, Pulasthi Supun pulas...@wso2.com
wrote:
Hi All/BPS team,
We are getting the following error when we try to start the server with
-Dsetup option.
1. started the fresh pack normally
2. stopped the server and deleted the content in /repository/database
folder
3. restarted with -Dsetup
[2015-01-15 22:25:37,370] INFO
{org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent} -
Initialising HumanTask Server
[2015-01-15 22:25:37,442] ERROR
{org.wso2.carbon.utils.dbcreator.DatabaseCreator} - Error occurred while
executing SQL script for creating registry database
java.io.FileNotFoundException:
/home/pulasthi/wso2/greg5/wso2greg-5.0.0-SNAPSHOT/dbscripts/bps/bpel/create/h2.sql
(No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.init(FileInputStream.java:120)
at java.io.FileInputStream.init(FileInputStream.java:79)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:296)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)
at
org.wso2.carbon.humantask.core.db.Database.setupHumanTaskDatabase(Database.java:94)
at org.wso2.carbon.humantask.core.db.Database.start(Database.java:78)
at
org.wso2.carbon.humantask.core.HumanTaskServer.initDataSource(HumanTaskServer.java:166)
at
org.wso2.carbon.humantask.core.HumanTaskServer.init(HumanTaskServer.java:95)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.initHumanTaskServer(HumanTaskServiceComponent.java:100)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.activate(HumanTaskServiceComponent.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
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.attachment.mgt.server.internal.AttachmentServiceComponent.registerAttachmentServerService(AttachmentServiceComponent.java:98)
at
org.wso2.carbon.attachment.mgt.server.internal.AttachmentServiceComponent.activate(AttachmentServiceComponent.java:73)
at
Re: [Dev] Cannot do a -Dsetup after deleting the h2 database in Greg 5.0.0 pack
Hi Pulasthi,
I had a look at HumanTask featue, It is copying all DB scripts to correct
location. ( Carbon_Home/dbscripts/bps/bpel/create/ ). Please note that we
have changed [1] the dbscript structure for BPS 3.5.0.
Can you verify following.
1) To verify Humantak feature installation, check whether all DB scripts
are in Greg p2-profile target folder. ( in
Carbon_Home/dbscripts/bps/bpel/create/
)
2) Then check maven assembly in distribution build, whether it is poining
to correct location.
[1] Mail with Subject - dbscripts folder structure for BPS 3.5.0 @Dev
Thanks,
Hasitha.
On Thu, Jan 15, 2015 at 10:34 PM, Pulasthi Supun pulas...@wso2.com wrote:
Hi All/BPS team,
We are getting the following error when we try to start the server with
-Dsetup option.
1. started the fresh pack normally
2. stopped the server and deleted the content in /repository/database
folder
3. restarted with -Dsetup
[2015-01-15 22:25:37,370] INFO
{org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent} -
Initialising HumanTask Server
[2015-01-15 22:25:37,442] ERROR
{org.wso2.carbon.utils.dbcreator.DatabaseCreator} - Error occurred while
executing SQL script for creating registry database
java.io.FileNotFoundException:
/home/pulasthi/wso2/greg5/wso2greg-5.0.0-SNAPSHOT/dbscripts/bps/bpel/create/h2.sql
(No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.init(FileInputStream.java:120)
at java.io.FileInputStream.init(FileInputStream.java:79)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:296)
at
org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)
at
org.wso2.carbon.humantask.core.db.Database.setupHumanTaskDatabase(Database.java:94)
at org.wso2.carbon.humantask.core.db.Database.start(Database.java:78)
at
org.wso2.carbon.humantask.core.HumanTaskServer.initDataSource(HumanTaskServer.java:166)
at
org.wso2.carbon.humantask.core.HumanTaskServer.init(HumanTaskServer.java:95)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.initHumanTaskServer(HumanTaskServiceComponent.java:100)
at
org.wso2.carbon.humantask.core.internal.HumanTaskServiceComponent.activate(HumanTaskServiceComponent.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 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.attachment.mgt.server.internal.AttachmentServiceComponent.registerAttachmentServerService(AttachmentServiceComponent.java:98)
at
org.wso2.carbon.attachment.mgt.server.internal.AttachmentServiceComponent.activate(AttachmentServiceComponent.java:73)
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
