Hi Cognos Community,

We have 3 reports in our Cognos production which has Data level security applied for particular group of users in Framework Manager.

So, when these users run the reports, the reports are getting timed out with the below error 

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

But when we admins and developers run these reports, they are running fine.

We grab the SQL that is getting generated on Database Engine while user is running report. And this Query is very big.

Can anyone please suggest what might be the problem here and how can we resolve this problem.

When i research for the error "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP", People are saying that it is Oracle Database Error and by increasing the TEMP Space it may get resolved.

Thanks,

Lokeswara

Hi,

As I mentioned on your other post, this is an Oracle temp space issue, and needs to be resolved by your DBAs increasing the temp space for Oracle. Different users will likely be triggering queries that return different sized result sets - dependent on the model security filters defined. It's an Oracle issue not a Cognos issue, so focus your efforts there.

Cheers!

MF.

Hi Cognos Community,

We have 3 reports in our Cognos production which has Data level security applied for particular group of users in Framework Manager.

So, when these users run the reports, the reports are getting timed out with the below error 

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

But when we admins and developers run these reports, they are running fine.

We grab the SQL that is getting generated on Database Engine while user is running report. And this Query is very big.

Can anyone please suggest what might be the problem here and how can we resolve this problem.

When i research for the error "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP", People are saying that it is Oracle Database Error and by increasing the TEMP Space it may get resolved.

Thanks,

Lokeswara