Re: [Dev] [DEV][BPS] Clarification on bps dbscripts

2015-10-12 Thread Hasitha Aravinda 
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 
wrote:

> Hi Firzhan,
>
> There scripts to drop and truncate as well. Appreciate your help in
> clarifying below issues.
>
> 1. In /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  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 
>> mobile: (+94) 77 9785674 <%28%2B94%29%2071%205247551>*|
>> blog: http://firzhanblogger.blogspot.com/
>>   *
>> *twitter: https://twitter.com/firzhan007
>>  | linked-in: 
>> **https://www.linkedin.com/in/firzhan
>> *
>>
>> On Fri, Oct 9, 2015 at 5:51 PM, Sashika Wijesinghe 
>> wrote:
>>
>>> Hi All,
>>>
>>> There were bpel database scripts under /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
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [DEV][BPS] Clarification on bps dbscripts

2015-10-12 Thread Sashika Wijesinghe 
Hi Firzhan,

There scripts to drop and truncate as well. Appreciate your help in
clarifying below issues.

1. In /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  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 
> mobile: (+94) 77 9785674 <%28%2B94%29%2071%205247551>*|
> blog: http://firzhanblogger.blogspot.com/
>   *
> *twitter: https://twitter.com/firzhan007
>  | linked-in: 
> **https://www.linkedin.com/in/firzhan
> *
>
> On Fri, Oct 9, 2015 at 5:51 PM, Sashika Wijesinghe 
> wrote:
>
>> Hi All,
>>
>> There were bpel database scripts under /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
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [DEV][BPS] Clarification on bps dbscripts

2015-10-12 Thread Sashika Wijesinghe 
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  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 
> wrote:
>
>> Hi Firzhan,
>>
>> There scripts to drop and truncate as well. Appreciate your help in
>> clarifying below issues.
>>
>> 1. In /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  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 
>>> mobile: (+94) 77 9785674 <%28%2B94%29%2071%205247551>*|
>>> blog: http://firzhanblogger.blogspot.com/
>>>   *
>>> *twitter: https://twitter.com/firzhan007
>>>  | linked-in: 
>>> **https://www.linkedin.com/in/firzhan
>>> *
>>>
>>> On Fri, Oct 9, 2015 at 5:51 PM, Sashika Wijesinghe 
>>> wrote:
>>>
 Hi All,

 There were bpel database scripts under /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

Re: [Dev] [DEV][BPS] Clarification on bps dbscripts

2015-10-09 Thread Firzhan Naqash 
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 
mobile: (+94) 77 9785674 <%28%2B94%29%2071%205247551>*|
blog: http://firzhanblogger.blogspot.com/
  *
*twitter: https://twitter.com/firzhan007  |
linked-in: **https://www.linkedin.com/in/firzhan
*

On Fri, Oct 9, 2015 at 5:51 PM, Sashika Wijesinghe  wrote:

> Hi All,
>
> There were bpel database scripts under /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
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev