10-08-2007 01:53 AM - edited 03-09-2019 06:58 PM
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 ?
10-08-2007 11:38 AM
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.
10-09-2007 05:23 AM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: