cs-mars 4.3.1 pnexp process abort

Unanswered Question
Oct 8th, 2007

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

Oct 8 11:37:10.605 2007@[email protected] 1024:START DATA EXPORTING...

Oct 8 11:37:10.605 2007@[email protected] 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@[email protected] 1024:Parameter: event_start_time = 01/01/01:00

Oct 8 11:37:10.683 2007@[email protected] 1024:Trying to mount /mnt/pnarchive

Oct 8 11:37:12.127 2007@[email protected] 1024:EXPORTING REPORT RESULTS ...

Oct 8 11:37:12.127 2007@[email protected] 1024:Retrieving statistics of pn_report_result table...

Oct 8 11:37:12.141 2007@[email protected] 1026:Entering data mover thread

Oct 8 11:39:58.980 2007@[email protected] 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@[email protected] 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@[email protected] 1024:Total number of report result entries exported: 0

Oct 8 11:39:58.980 2007@[email protected] 1024:EXPORTING REPORT RESULTS FAILED!

Oct 8 11:39:58.980 2007@[email protected] 1024:PROGRAM ABORTS BECAUSE OF ERROR!

Any idea ?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
michaelwoolfe Mon, 10/08/2007 - 11:38

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 Tue, 10/09/2007 - 05:23

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

Actions

This Discussion