Viewing of Promotion fails with message: Error during sort of table "@PROM_OBJ"

Viewing of Promotion fails with message: Error during sort of table "@PROM_OBJ"

book

Article ID: KB0086060

calendar_today

Updated On:

Products Versions
TIBCO Object Service Broker for z/OS -
Not Applicable -

Description

Resolution:
While viewing a Promotion and PF04 is hit a second time to view the tables in the Promotion,  the following error message is displayed:

            Error during sort of table "@PROM_OBJ"

Hitting PF02 then shows the following additional messages
:
            Error detected in rule "VIEW_TABLES" at action 7                                
            Access error on table "@PROM_OBJ"                                              
            FORALL  @PROM_OBJ('DOB50ZOS','15') WHERE TYPE = TABLE | TYPE = SCRTBL | TYPE =
            Error during sort of table "@PROM_OBJ"


CAUSE OF THE PROBLEM:

          Insufficient amount of virtual storage available for external sort is the most common cause for this error


SOLUTION:

          Review the value for EE Parameter SORTEXTMEMMAX.  If you are using the default (244K), or some other low value, please change it to a higher value (e.g. 1 or 2 Meg).

          If this does not resolve the problem, please see if you can find some SYNCSORT/DFSORT messages in the logs and send these to TIBCO Support.  

          If you can not find any messages, please review the EE parameter SORTPRINT and set the value to ALL,  (at least for this run) so that the relevant messages are printed out.

Issue/Introduction

Viewing of Promotion fails with message: Error during sort of table "@PROM_OBJ"