Hi Hasitha,
Thanks for the information. These information is not documented in BPS
documentation, therefore raised a documentation jira. (
https://wso2.org/jira/browse/DOCUMENTATION-2529)
Regards,
On Mon, Oct 12, 2015 at 1:39 PM, Hasitha Aravinda <hasi...@wso2.com> wrote:
> 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 <sash...@wso2.com>
> 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 <firz...@wso2.com> 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: firz...@wso2.com <lasan...@wso2.com>
>>> 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 <sash...@wso2.com>
>>> 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
>>>> sash...@wso2.com
>>>>
>>>> _______________________________________________
>>>> Dev mailing list
>>>> Dev@wso2.org
>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>
>>>>
>>>
>>
>>
>> --
>>
>> *Sashika WijesingheSoftware Engineer - QA Team*
>> Mobile : +94 (0) 774537487
>> sash...@wso2.com
>>
>
>
>
> --
> --
> Hasitha Aravinda,
> Senior Software Engineer,
> WSO2 Inc.
> Email: hasi...@wso2.com
> Mobile : +94 718 210 200
>
--
*Sashika WijesingheSoftware Engineer - QA Team*
Mobile : +94 (0) 774537487
sash...@wso2.com
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
