Re: [Dev] [DAS] Issue in connecting db2 with DAS

[Gokul Balakrishnan]

Sure Anjana, I'll work on this.

On 15 September 2015 at 19:07, Nayomi Dayarathne  wrote:

> Hi Anjana,
>
> Reported the JIRA[1].
>
> [1]. https://wso2.org/jira/browse/DAS-142
>
> Thanks.
>
>
> Nayomi Dayarathne
>
> *Software Engineer-QA*
> Mobile : +94 (0) 775246619 <+94+(0)+775246619>
>
> *nay...@wso2.com *
>
> On Tue, Sep 15, 2015 at 6:42 PM, Anjana Fernando  wrote:
>
>> Hi Nayomi,
>>
>> Yeah, for now, do test with the changed configuration name change. But we
>> will have to come up with an approach for this, since the query
>> configuration will most probably be identical for both situations. @Gokul,
>> shall we do an improvement in the database name section there to support
>> like "*" wildcard character. Maybe it will be easy if we just allow users
>> to give an regex in the place of the name, so it can be matched. Can you
>> please create an improvement JIRA and get it implemented.
>>
>> Cheers,
>> Anjana.
>>
>> On Tue, Sep 15, 2015 at 6:31 PM, Nayomi Dayarathne 
>> wrote:
>>
>>> Hi Anjana,
>>>
>>> Following error was seen when connecting DAS 3.0 with db2 .
>>>
>>>
>>> ERROR
>>> {org.wso2.carbon.analytics.dataservice.AnalyticsDataServiceComponent} -
>>> Error in activating analytics data service: Cannot find a database section
>>> in the RDBMS configuration for the database:
>>> {Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
>>> Version=10.5}
>>> org.wso2.carbon.analytics.datasource.commons.exception.AnalyticsException:
>>> Cannot find a database section in the RDBMS configuration for the database:
>>> {Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
>>> Version=10.5}
>>>
>>>
>>>
>>> After discussing with Gokul, we found that root cause for the error was
>>> the incompatibility of db2 type(windows/linux) that has mentioned in the
>>> rdbms-config.xml with the db2 we were trying to connect with DAS.
>>>
>>> Default rdbms-config.xml has the configurations for db2 for windows but
>>> not linux. And we have used db2 which was configured for linux environment .
>>>
>>>
>>> Therefore, as a workaround suggested by Gokul, we changed the name of
>>> the db2 configuration in rdbms-config.xml as DB2/LINUXX8664 (linux verison).
>>>
>>> Hence, we would like to know whether we are going to add db2
>>> configuration for both OS's or are we just going to mention it in the DAS
>>> document ?
>>>
>>>
>>>
>>>
>>>
>>> Nayomi Dayarathne
>>>
>>> *Software Engineer-QA*
>>> Mobile : +94 (0) 775246619 <+94+(0)+775246619>
>>>
>>> *nay...@wso2.com *
>>>
>>
>>
>>
>> --
>> *Anjana Fernando*
>> Senior Technical Lead
>> WSO2 Inc. | http://wso2.com
>> lean . enterprise . middleware
>>
>
>


-- 
Gokul Balakrishnan
Senior Software Engineer,
WSO2, Inc. http://wso2.com
Mob: +94 77 593 5789 | +1 650 272 9927
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [DAS] Issue in connecting db2 with DAS

[Nayomi Dayarathne]

Hi Anjana,

Reported the JIRA[1].

[1]. https://wso2.org/jira/browse/DAS-142

Thanks.


Nayomi Dayarathne

*Software Engineer-QA*
Mobile : +94 (0) 775246619 <+94+(0)+775246619>

*nay...@wso2.com *

On Tue, Sep 15, 2015 at 6:42 PM, Anjana Fernando  wrote:

> Hi Nayomi,
>
> Yeah, for now, do test with the changed configuration name change. But we
> will have to come up with an approach for this, since the query
> configuration will most probably be identical for both situations. @Gokul,
> shall we do an improvement in the database name section there to support
> like "*" wildcard character. Maybe it will be easy if we just allow users
> to give an regex in the place of the name, so it can be matched. Can you
> please create an improvement JIRA and get it implemented.
>
> Cheers,
> Anjana.
>
> On Tue, Sep 15, 2015 at 6:31 PM, Nayomi Dayarathne 
> wrote:
>
>> Hi Anjana,
>>
>> Following error was seen when connecting DAS 3.0 with db2 .
>>
>>
>> ERROR
>> {org.wso2.carbon.analytics.dataservice.AnalyticsDataServiceComponent} -
>> Error in activating analytics data service: Cannot find a database section
>> in the RDBMS configuration for the database:
>> {Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
>> Version=10.5}
>> org.wso2.carbon.analytics.datasource.commons.exception.AnalyticsException:
>> Cannot find a database section in the RDBMS configuration for the database:
>> {Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
>> Version=10.5}
>>
>>
>>
>> After discussing with Gokul, we found that root cause for the error was
>> the incompatibility of db2 type(windows/linux) that has mentioned in the
>> rdbms-config.xml with the db2 we were trying to connect with DAS.
>>
>> Default rdbms-config.xml has the configurations for db2 for windows but
>> not linux. And we have used db2 which was configured for linux environment .
>>
>>
>> Therefore, as a workaround suggested by Gokul, we changed the name of the
>> db2 configuration in rdbms-config.xml as DB2/LINUXX8664 (linux verison).
>>
>> Hence, we would like to know whether we are going to add db2
>> configuration for both OS's or are we just going to mention it in the DAS
>> document ?
>>
>>
>>
>>
>>
>> Nayomi Dayarathne
>>
>> *Software Engineer-QA*
>> Mobile : +94 (0) 775246619 <+94+(0)+775246619>
>>
>> *nay...@wso2.com *
>>
>
>
>
> --
> *Anjana Fernando*
> Senior Technical Lead
> WSO2 Inc. | http://wso2.com
> lean . enterprise . middleware
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] [DAS] Issue in connecting db2 with DAS

[Nayomi Dayarathne]

Hi Anjana,

Following error was seen when connecting DAS 3.0 with db2 .


ERROR {org.wso2.carbon.analytics.dataservice.AnalyticsDataServiceComponent}
-  Error in activating analytics data service: Cannot find a database
section in the RDBMS configuration for the database:
{Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
Version=10.5}
org.wso2.carbon.analytics.datasource.commons.exception.AnalyticsException:
Cannot find a database section in the RDBMS configuration for the database:
{Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
Version=10.5}



After discussing with Gokul, we found that root cause for the error was the
incompatibility of db2 type(windows/linux) that has mentioned in the
rdbms-config.xml with the db2 we were trying to connect with DAS.

Default rdbms-config.xml has the configurations for db2 for windows but not
linux. And we have used db2 which was configured for linux environment .


Therefore, as a workaround suggested by Gokul, we changed the name of the
db2 configuration in rdbms-config.xml as DB2/LINUXX8664 (linux verison).

Hence, we would like to know whether we are going to add db2 configuration
for both OS's or are we just going to mention it in the DAS document ?





Nayomi Dayarathne

*Software Engineer-QA*
Mobile : +94 (0) 775246619 <+94+(0)+775246619>

*nay...@wso2.com *
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [DAS] Issue in connecting db2 with DAS

[Anjana Fernando]

Hi Nayomi,

Yeah, for now, do test with the changed configuration name change. But we
will have to come up with an approach for this, since the query
configuration will most probably be identical for both situations. @Gokul,
shall we do an improvement in the database name section there to support
like "*" wildcard character. Maybe it will be easy if we just allow users
to give an regex in the place of the name, so it can be matched. Can you
please create an improvement JIRA and get it implemented.

Cheers,
Anjana.

On Tue, Sep 15, 2015 at 6:31 PM, Nayomi Dayarathne  wrote:

> Hi Anjana,
>
> Following error was seen when connecting DAS 3.0 with db2 .
>
>
> ERROR
> {org.wso2.carbon.analytics.dataservice.AnalyticsDataServiceComponent} -
> Error in activating analytics data service: Cannot find a database section
> in the RDBMS configuration for the database:
> {Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
> Version=10.5}
> org.wso2.carbon.analytics.datasource.commons.exception.AnalyticsException:
> Cannot find a database section in the RDBMS configuration for the database:
> {Category=large_dataset_optimized, Database Product Name=DB2/LINUXX8664,
> Version=10.5}
>
>
>
> After discussing with Gokul, we found that root cause for the error was
> the incompatibility of db2 type(windows/linux) that has mentioned in the
> rdbms-config.xml with the db2 we were trying to connect with DAS.
>
> Default rdbms-config.xml has the configurations for db2 for windows but
> not linux. And we have used db2 which was configured for linux environment .
>
>
> Therefore, as a workaround suggested by Gokul, we changed the name of the
> db2 configuration in rdbms-config.xml as DB2/LINUXX8664 (linux verison).
>
> Hence, we would like to know whether we are going to add db2 configuration
> for both OS's or are we just going to mention it in the DAS document ?
>
>
>
>
>
> Nayomi Dayarathne
>
> *Software Engineer-QA*
> Mobile : +94 (0) 775246619 <+94+(0)+775246619>
>
> *nay...@wso2.com *
>



-- 
*Anjana Fernando*
Senior Technical Lead
WSO2 Inc. | http://wso2.com
lean . enterprise . middleware
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev