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]
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
