Skip to Content
Former Member
Feb 10, 2010 at 11:14 AM

Error in Communication Channel


Hi Experts,

I'm facing the below error in RWB, communication channel, did any one face the this error before, Please guide me about this

Database-level error reported by JDBC driver while executing statement 'SELECT DISTINCT I., M.PC_DESCRIPTION FROM PS_BUD_PROJECTS_INTF I, PS_BUD_PROJECTS_EST_INTF M where i.work_order_number = m.work_order_number and i.work_order_number in (select x.work_order_number from (SELECT DISTINCT H.WORK_ORDER_NUMBER from PS_BUD_PROJECTS_INTF H WHERE (H.SAP_PROC_STATUS IS NULL OR H.SAP_PROC_STATUS != 'X') AND H.WORK_ORDER_NUMBER IN (SELECT DISTINCT T.WORK_ORDER_NUMBER FROM PS_BUD_PROJECTS_INTF T,PS_BUD_PROJECTS_EST_INTF S WHERE T.WORK_ORDER_NUMBER = S.WORK_ORDER_NUMBER)) x where rownum < 1000)'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-01652: unable to extend temp segment by 25 in tablespace TEMP '. For details, contact your database server vendor.*

Any ideas would be appreciated. Thanks.

Venkat Anil