cs-mars 4.3.1 pnexp process abort

r.spiandorello · ‎10-08-2007

Hi , during data export the process aborts with the following error:

Oct 8 11:37:10.605 2007@LM_INFO@Thread 1024:START DATA EXPORTING...

Oct 8 11:37:10.605 2007@LM_INFO@Thread 1024:Parameter: nfs_path = 10.24.9.153:/archivio/csmarsold/migration/nwmars01_2007-1

0-08-11-36-02

Oct 8 11:37:10.605 2007@LM_INFO@Thread 1024:Parameter: event_start_time = 01/01/01:00

Oct 8 11:37:10.683 2007@LM_INFO@Thread 1024:Trying to mount /mnt/pnarchive

Oct 8 11:37:12.127 2007@LM_INFO@Thread 1024:EXPORTING REPORT RESULTS ...

Oct 8 11:37:12.127 2007@LM_INFO@Thread 1024:Retrieving statistics of pn_report_result table...

Oct 8 11:37:12.141 2007@LM_INFO@Thread 1026:Entering data mover thread

Oct 8 11:39:58.980 2007@LM_ERROR@Thread 1024:SQL exception caught while exporting report result data: ORA-01652: unable to

extend temp segment by 64 in tablespace TEMP

Oct 8 11:39:58.980 2007@LM_ERROR@SQL statement executed: select /*+ INDEX_DESC (pn_report_result_ie2) */ REPORT_ID, RUN_T

IME, BUCKET_SIZE, ITEM_RANK, ITEM_COUNT, ITEM_VALUE, ITEM_TYPE, ZONE_ID from pn_report_result where RUN_TIME >= :1 and RUN_T

IME <= :2 order by run_time desc

Oct 8 11:39:58.980 2007@LM_INFO@Thread 1024:Total number of report result entries exported: 0

Oct 8 11:39:58.980 2007@LM_ERROR@Thread 1024:EXPORTING REPORT RESULTS FAILED!

Oct 8 11:39:58.980 2007@LM_CRITICAL@Thread 1024:PROGRAM ABORTS BECAUSE OF ERROR!

Any idea ?

michaelwoolfe · ‎10-08-2007

If you can duplicate the error, can you post a copy of the sysstatus CLI command? I am interested in seeing your system resources. Check 'diskusage' and 'raidstatus' also.

r.spiandorello · ‎10-09-2007

Hi, today the export finished successfully !

I think you cannot execute the pnexp the same day of the 4.3.1 upgrade.

During the night the system obtains the requirewd space