Getting XQE-DAT-0001:datasource adapter error while testing relationship in FM

[bhswati]

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?

[MFGF]

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.

[bhswati]

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.