[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
PeopleSoft SQR Problem BEN733
- Subject: PeopleSoft SQR Problem BEN733
- From: Bill Bowers <bowersb@PSPH.PROVIDENCE.ORG>
- Date: Thu, 10 Sep 1998 10:57:56 PST
- Encoding: 30 Text
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