Re: PeopleSoft SQR Problem BEN733

[Greg Gargett <ggargett@SEANET.COM>]

try defragging your database.

Bill Bowers wrote:

>      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