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

Error in Communication Channel

15 Views

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