Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: bhswati on 22 Sep 2015 01:13:33 AM

Title: Getting XQE-DAT-0001:datasource adapter error while testing relationship in FM
Post by: bhswati on 22 Sep 2015 01:13:33 AM
Hi Everyone,

I have a created an FM model in DQM mode.While trying to test a relationship between two query subjects I am getting the below error.

"XQE-DAT-0001 Data source adapter error: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP"

This error occurs for most of the relationships in the model.But it does not occur while validating the relationship.

I got the temp space of the DB upgraded but still the error persists.

However ,when I run the native sql of relationship in the oracle 11g ,it runs fine.Also the the joins seem to work in report studio.

What could be the issue that the test fails in FM?
Title: Re: Getting XQE-DAT-0001:datasource adapter error while testing relationship in FM
Post by: MFGF on 22 Sep 2015 04:39:56 AM
Quote from: bhswati on 22 Sep 2015 01:13:33 AM
Hi Everyone,

I have a created an FM model in DQM mode.While trying to test a relationship between two query subjects I am getting the below error.

"XQE-DAT-0001 Data source adapter error: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP"

This error occurs for most of the relationships in the model.But it does not occur while validating the relationship.

I got the temp space of the DB upgraded but still the error persists.

However ,when I run the native sql of relationship in the oracle 11g ,it runs fine.Also the the joins seem to work in report studio.

What could be the issue that the test fails in FM?

Hi,

The error being generated here is from Oracle, so you're not going to be able to fix it unless you sort out the space Oracle uses for intermediate data.

Take a look at the following for a few ideas:

http://stackoverflow.com/questions/25350703/ora-01652-unable-to-extend-temp-segment-by-128-in-tablespace-system-how-to-ext

Cheers!

MF.
Title: Re: Getting XQE-DAT-0001:datasource adapter error while testing relationship in FM
Post by: bhswati on 22 Sep 2015 05:30:09 AM
Quote from: MFGF on 22 Sep 2015 04:39:56 AM
Hi,

The error being generated here is from Oracle, so you're not going to be able to fix it unless you sort out the space Oracle uses for intermediate data.

Take a look at the following for a few ideas:

http://stackoverflow.com/questions/25350703/ora-01652-unable-to-extend-temp-segment-by-128-in-tablespace-system-how-to-ext

Cheers!

MF.

Hi MF,

Thanks MF .The space has been extended upto 2 gb. It is difficult to upgrade further as the database isn't very big.

Could there be any other reason why am I getting this error?The Native SQL seems to work fine when executed at the database.
Text only | Text with Images