Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

PMERR_TRANS

PMERR_TRANS

When the Integration Service encounters a transformation error, it inserts an entry into the PMERR_TRANS table. This table stores metadata, such as the name and datatype of the source and transformation ports.
The following table describes the structure of the PMERR_TRANS table:
Column Name
Datatype
Description
REPOSITORY_GID
Varchar
Unique identifier for the repository.
WORKFLOW_RUN_ID
Integer
Unique identifier for the workflow.
WORKLET_RUN_ID
Integer
Unique identifier for the worklet. If a session is not part of a worklet, this value is “0”.
SESS_INST_ID
Integer
Unique identifier for the session.
TRANS_MAPPLET_INST
Varchar
Specifies the instance of a mapplet.
TRANS_NAME
Varchar
Name of the transformation where an error occurred.
TRANS_GROUP
Varchar
Name of the input group or output group where an error occurred. Defaults to either “input” or “output” if the transformation does not have a group.
TRANS_ATTR
Varchar
Lists the port names and datatypes of the input or output group where the error occurred. Port name and datatype pairs are separated by commas, for example: portname1:datatype, portname2:datatype.
This value can span multiple rows. When the data exceeds 2000 bytes, the Integration Service creates a new row for the transformation attributes and writes the line number in the LINE_NO column.
SOURCE_MAPPLET_INST
Varchar
Name of the mapplet in which the source resides.
SOURCE_NAME
Varchar
Name of the source qualifier. n/a appears when a row error occurs downstream of an active source that is not a source qualifier or a non pass-through partition point with more than one partition.
SOURCE_ATTR
Varchar
Lists the connected field(s) in the source qualifier where an error occurred. When an error occurs in multiple fields, each field name is entered on a new line. Writes the line number in the LINE_NO column.
LINE_NO
Integer
Specifies the line number for each row error entry in TRANS_ATTR and SOURCE_ATTR that spans multiple rows.
Use the column names in bold to join tables.


Updated August 27, 2020