TriniDBA

Problem: Workflow has generated an error:

Event Error Name: WFE_DISPATCH_GEN_ERR
Event Error Message: 3835: Error '-1652 - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.
Event Error Stack: 
Wf_Event.setMessage(oracle.apps.wf.notification.send, 470315, WF_XML.Generate)
Wf_Event.dispatch_internal()

Solution: Turn on autoextend on the tempfile in the TEMP1 tablespace, or add another tempfile.

To check the existing tempfiles, source the database tier environment and then log on to SQL*Plus as the sys user. Check DBA_TEMP_FILES for the existing tempfile:

SQL> select file_name, bytes/1024/1024, maxbytes/1024/1024,
  2  autoextensible from dba_temp_files where tablespace_name = 'TEMP1'
  3  order by 1
  4  /

FILE_NAME
-----------------------------------------
BYTES/1024/1024 MAXBYTES/1024/1024 AUT
--------------- ------------------ ---
/u01/test/db/apps_st/data/temp01.dbf
             10                  0 NO

/u01/test/db/apps_st/data/temp02.dbf
          32768         32767.9844 YES


SQL>

Since there is an existing tempfile that is quite small, we can on autoextend on the temp01.dbf file:

SQL> alter database tempfile '/u01/test/db/apps_st/data/temp01.dbf' autoextend on;

Database altered.

SQL>

Query DBA_TEMP_FILES once more to see the change:

SQL> select file_name, bytes/1024/1024, maxbytes/1024/1024,
  2  autoextensible from dba_temp_files where tablespace_name = 'TEMP1'
  3  order by 1
  4  /

FILE_NAME
---------------------------------------
BYTES/1024/1024 MAXBYTES/1024/1024 AUT
--------------- ------------------ ---
/u01/test/db/apps_st/data/temp01.dbf
             10         32767.9844 YES

/u01/test/db/apps_st/data/temp02.dbf
           6312         32767.9844 YES


SQL>

It was also necessary to re-enable notification emails for the user as they had been disabled.