Hi Sashika, Drop/Truncate scripts are used to recreate fresh environments. Specially these scripts will be useful, when you are working with restricted environments like where you don't have privileges to create databases, etc. Some users want these scripts specially when they do load tests.
Since you have dropped only bps database, this is expected. Since we are creating fresh environment, we need to drop registry tables and re-create them. AFAIK registry doesn't have drop scripts. Also we need to remove previous deployed artifacts from file system as well. Thanks Hasitha. On Mon, Oct 12, 2015 at 11:59 AM, Sashika Wijesinghe <[email protected]> wrote: > Hi Firzhan, > > There scripts to drop and truncate as well. Appreciate your help in > clarifying below issues. > > 1. In <BPS_HOME>/dbscripts/bps/bpel/drop there are scripts to drop the > tables in BPS database. > > To verify the scripts, I stopped the BPS server and drop tables using the > given 'drop scripts' and recreate the tables using given 'create scripts'. > After restarting the server, "*[2015-10-12 11:33:14,791] ERROR > {org.wso2.carbon.bpel.core.ode.integration.store.TenantProcessStoreImpl} - > Cannot find DeploymentUnitDAO instance for package AdderProcess-1.*" > error noted in terminal. This is because the package details are available > in registry database. > > Further it is not possible to continue the work by deploying a new bpel > process due to corrupted process. I had to undeploy the corrupted bpel > process to continue work. > > Is there any recommended best practice to use the drop bps scripts? If so > it should be documented because these scripts are bundled with the BPS > package itself. > > > Thanks > > On Fri, Oct 9, 2015 at 5:56 PM, Firzhan Naqash <[email protected]> wrote: > >> Hi, >> >> Those scripts are used to create the necessary database schema for bpel. >> Without executing this scripts, you won't be able to start the bps server. >> >> As a first step, after configuring the bps-datasources.xml file, you have >> to execute this script against your preferred database. Or else if you have >> necessary database permissions, you can start the server with -Dsetup >> option. >> >> Regards, >> Firzhan >> >> >> -- >> *Firzhan Naqash* >> Senior Software Engineer - Integration Platform Team >> WSO2 Inc. http://wso2.com >> >> email: [email protected] <[email protected]> >> mobile: (+94) 77 9785674 <%28%2B94%29%2071%205247551>*| >> blog: http://firzhanblogger.blogspot.com/ >> <http://firzhanblogger.blogspot.com/> <http://suhothayan.blogspot.com/>* >> *twitter: https://twitter.com/firzhan007 >> <https://twitter.com/firzhan007> | linked-in: >> **https://www.linkedin.com/in/firzhan >> <https://www.linkedin.com/in/firzhan>* >> >> On Fri, Oct 9, 2015 at 5:51 PM, Sashika Wijesinghe <[email protected]> >> wrote: >> >>> Hi All, >>> >>> There were bpel database scripts under <BPS HOME>/dbscripts/bps/bpel. >>> May I know the real usecase of these scripts? Is there any specific >>> pre-conditions that needs to follow before executing these scripts? >>> >>> Thanks >>> -- >>> >>> *Sashika WijesingheSoftware Engineer - QA Team* >>> Mobile : +94 (0) 774537487 >>> [email protected] >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> > > > -- > > *Sashika WijesingheSoftware Engineer - QA Team* > Mobile : +94 (0) 774537487 > [email protected] > -- -- Hasitha Aravinda, Senior Software Engineer, WSO2 Inc. Email: [email protected] Mobile : +94 718 210 200
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
