Reply from pete hefler on Jul 27 at 12:59 PM Sorry, I may have misspoke, should have read your email a little more carefully. It sounds like there may be another culprit involved, if the temp tablespace is set to auto-extend and can grow up to 32G, may not be a database problem. Sounds like the process may be spinning, or perhaps the tablespace is not auto-extending as expected. Pete Hefler Los Rios Community College District Information Technology Department
| | | ---------------Original Message--------------- From: eburkland Sent: Friday, July 27, 2012 12:50 PM Subject: FS_BP Process Abends with ORA-01652 We have been having intermittent issues when budget checking our payroll joural. Our payroll journals are roughly 7000 lines. When the process does fail it always fails on step FS_BP_ATAO.iActTAO.iActTAO with ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP message. According to our DBA the tablespace is set to autoextend with a max limit of 32GB. The program sometimes will run for hours until it fills up the entire tablespace and then abends. Wierd thing is it is completely intermittent. If I delete the Process Instance and rebudget check the journal it may or may not happen again. Sometimes the only thing that fixes it is to delete the entire journal and start from scratch. This will normally take care of the issue. I was wondering if you could shed some light on this issue. Our DBA seems to think it is something wrong with the program itself. I point the finger the other way and claim it is a database issue. We are on Financials 9.1 Bundle #20 PeopleTools 8.51 Oracle 11.2.0.2 | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment