cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
373
Views
0
Helpful
2
Replies

cs-mars 4.3.1 pnexp process abort

r.spiandorello
Level 1
Level 1

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 ?

2 Replies 2

michaelwoolfe
Level 1
Level 1

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.

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

Getting Started

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: