TPX batch update using extract file gives expected results even though there are error messages
search cancel

TPX batch update using extract file gives expected results even though there are error messages

book

Article ID: 49658

calendar_today

Updated On:

Products

TPX - Session Management

Issue/Introduction

 TPX batch update using extract file gives expected results even though there are error messages TPBL1010 return code is 8 and TPBL1054 means value not appropriate for this variable.

EXTRACT GIVING (EXTFILE) PROFILE AND MATCHING SESSIONS
                         (PENTAPPL(CICSA---))
UPDATE USING(EXTFILE) (PENTAPPL(CICSB---))
 
 
TPBL1010 04/30/12.121 15:40:34.45 VPUT     PENTAPPL return code is    8
TPBL1054 04/30/12.121 15:40:34.45  means value not appropriate for this variable
TPBL1031 04/30/12.121 15:40:34.45   while Updating PUSERSP21
TPBL1037 04/30/12.121 15:40:34.45 No fields updated for PUSERSP21
TPBL1033 04/30/12.121 15:40:34.45 PUSERSP21         Prcssed
TPBL1033 04/30/12.121 15:40:34.55 PUSERSP21CICSA    UPDATed
TPBL1033 04/30/12.121 15:40:34.55 PBASEPROFCICSAA   UPDATed
TPBL1033 04/30/12.121 15:40:34.55 PBASEPROFCICSBB   UPDATed

 

 

 

Resolution

 The extract PROFILE AND MATCHING SESSIONS results in an extract file containing one record for the profile plus individual records for each matching session within the profile. There is no way to extract only the session records.

The UPDATE statement will attempt to update the identified variable on each of the extracted records.

Since the variable PENTAPPL for Applid or Tier level is only on the profile session records, TPX batch puts out these messages indicating that this variable is not on the profile record, which is correct and expected:

TPBL1010 04/30/12.121 15:40:34.45 VPUT     PENTAPPL return code is    8
TPBL1054 04/30/12.121 15:40:34.45  means value not appropriate for this variable
TPBL1031 04/30/12.121 15:40:34.45   while Updating PUSERSP21
TPBL1037 04/30/12.121 15:40:34.45 No fields updated for PUSERSP21

 

NOTE: PUSERSP21 indicates Profile record for profile USERSP21

These are followed by the message indicating that this record was processed.

TPBL1033 04/30/12.121 15:40:34.45 PUSERSP21 Prcssed

 

Then the UPDATE attempts the next record which is successful so there is a message indicating that record was updated, not simply processed.

TPBL1033 04/30/12.121 15:40:34.55 PUSERSP21CICSA UPDATed

 

NOTE: PUSERSP21CICSA indicates Profile record for profile USERSP21 session CICSA.

Return code 8 is appropriate in this situation since you should be alerted to verify that the inability to update a particular record makes sense for the variables that you have specified.