[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

PeopleSoft SQR Problem BEN733



     We are unable to run our PeopleSoft delivered SQR, BEN733 the Base
     Benefits Audit, in our environment: Payroll, HR and Ben Admin.  It
     always stops at the same routine:  Employee and Spouse (or other
     Dependent) Both Electing Health Benefit.  The routine purpose and
     header are printed and nothing else.

     The error we get is:

     (SQR 5528) ORACLE OFETCH error - 1652 in cursor 6:
     ORA-01652: unable to extend temp seqment by 8 in tablespace PSTEMP

     Error on line 322:
     (SQR 3725) Bad return fetching row from database.

     SQRW: Program Aborting.


     We have tried the following without success:
     1.  Increasing the size of the temporary tablespace (PSTEMP) to 1GB.
     2.  Making PSTEMP permanent in order for Oracle's SMON process to
         clean it up.
     3.  The required tables do in fact exist.
     4.  Ensuring that the unique indexes are in place for all the affected
         tables.
     5.  Allocated sufficient size for batch rollback segments.

     Does anybody have any ideas on how this problem may be corrected?

     Bill