The following error occurs while scheduling a BO report. What could be the cause?

[Former Member]

"The following database error occurred: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)"

I checked the mentioned SAP Note but it does not provide any relevant answer to this problem.

What could be possible reason or cause for this error.

Regards

[Joe_Peters]

It's an Oracle error -- it means that the database has run out of temp space.

This could be an issue in the database, and has nothing to do with your query. Or, the query may be poorly formed (ex., joining several huge dimension tables). Either way, check with your DBA.