/
Job Details

Job Details

The Jobs Details screen contains the following sections.

Messages

The Messages section provides various job details such as:

Data Load Type

Property

Value (Description)

Example

Data Load Type

Property

Value (Description)

Example

General

Incremental

  • True

  • False

Incremental: true

General

Incremental load date

Timestamp

Incremental load date: Thu Nov 28 00:07:25 UTC 2024

Internal Copy

Using incremental load date

Timestamp

Using incremental load date Thu Nov 28 00:07:25 UTC 2024

General

Ran with user context

  • Login Name

  •  null

General

Target rows before

  1. Data Load Type

  2. Number of rows

General

Filter

Used Target filter

General

Final filter

Final (Source) filter is the combination of the optional incremental filter and user selected Source filter.

General

New lastUpdateDate

Date of the last update

Index Maintenance

Starting at with incremental

  1. Timestamp

  2. Incremental mode: True, False

Index Maintenance

Table for has rows before rebuild

  1. Data Source

  2. Number of rows

Index Maintenance

Table for has rows after rebuild

  1. Data Source

  2. Number of rows

Index Maintenance

Rebuilt table in non-inc mode

n/a

Calculation

Target fields

List of Target fields

Calculation

Source fields

List of Source fields

Internal Copy

Using source filter

Used Source filter

Calculation

Logic

Used Logic

Calculation

Feeder

Used Feeder Logic

Calculation

Formula feeder warnings

Used Feeder Logic

Calculation

End of feeder formula warnings

n/a

General

Source rows

Number of rows

Calculation

Target snapshot to be queried...

n/a

Calculation

Target snapshot is disabled

n/a

Calculation

Source snapshot to be queried...

n/a

Calculation

Completed snapshot of

  1. Datamart

  2. Used filter

  3. SortBy

  4. AutoKey

Calculation

Calculated rows

  1. Number of calculated rows

  2. Number of skipped rows

Publishing

System parameter

  1. Index on Publish

  2. True, False

Index Maintenance

Skipped indexing

  1. columnarnon columnar

  2. Data Load

Index Maintenance

Created indexes

  1. columnarnon columnar

  2. Data Load

Calculation

Calculation context

Context from the Calculation Step

Truncate

Deleted

Number of rows

Refresh

Deleted rows from

  1. Number of deleted rows

  2. Data Source

Calculation

Updated fields

List of updated fiels

Refresh

Update from source complete

Data Source

Calculation

Calculation is distributed

n/a

n/a

Calculation

Calculation is local

n/a

Calculation

Load mode

  • FULL

  • INCREMENTAL

  • ENRICHMENT

  • ALLOCATION

Calculation

Rows in result table

Number of rows

Calculation

No rows to load

n/a

Truncate

Truncated target table

n/a

General

Load cancelled

n/a

General

Load failed

Error message

General

Load failed with formula syntax error

Any sandbox Groovy error message.

n/a

Flush

Flush error

Error message

General

Load cancelled

Data Load name

General

Load failed

Data Load name

Truncate

Truncate cancelled

Error message

Truncate

Truncate failed

Error message

General

Source

Data Source name

General

Source filter

Filter applied in the Source tab.

Calculation

Batching filter

Filter applied in the Source tab.

General

Waited s(millis) on lock on

  1. Number of seconds (milliseconds)

  2. Data Source

General

Source rows

Number of rows

Refresh

Secondary source has new or updated rows

  1. Data Source

  2. Number of updated rows

Calculation

Formula not found

Formula name

General

Unable to store calculation result

Error message. While the Pricefx can serialize a wide range of Java/Groovy objects, serialization can occasionally fail. This is often due to attempts to store objects that are not intended to be stored or as a result of a bug.

n/a

Flush

Added a total of rows, skipped rows with errors

  1. Number of total rows

  2. Number of skipped rows

  3. Number of rows with error

Refresh

Skipping update from as not all key fields are in the target DM's table

Data Source

Flush

Skipping row due to invalid field values

  1. Number of the skipped row

  2. Key Attributes

  3. List of invalid field values

Flush

Flushed a total of data rows, skipped rows with errors

  1. Number of total rows

  2. Number of skipped rows

Internal Copy

Loaded rows

Number of rows

Internal Copy

Nothing to load

n/a

General

Next incremental load date

Timestamp

Flush

Applied currency post-processing

n/a

Truncate

Applied Currencies DS post-processing after partial truncate

n/a

Flush

Applied Currencies DS post-processing

n/a

Calculation

Post calculation task failed

Error message

Calculation

Pending

  1. Number of pending calculation item

  2. ID of pending calculation item

General

Load successful

n/a

General

Load completed with errors

n/a

Calculation

No rows to load

n/a

Index Maintenance

Reindexing done

n/a

Internal Copy

Copy cancelled

n/a

Internal Copy

Copy cancelled

Error message

Internal Copy

Copy failed

Error message

Calendar

Calendar load cancelled

Error message

Calendar

Calendar load failed

Error message

Index Maintenance

Maintenance cancelled

Error message

Index Maintenance

Maintenance failed

Error message

Index Maintenance

Table is empty - aborting

n/a

Index Maintenance

Table is no longer distributed

n/a

Truncate

Target was truncated before copy

n/a

Index Maintenance

Table is distributed on

Distribution Key

Index Maintenance

Table is now distributionKey on

Distribution Key

Index Maintenance

Table is now partitioned on

Partitioning Key

Index Maintenance

Table is partitioned on

Partitioning Key

Truncate

Truncate cancelled

n/a

Refresh

Aborting as DM has no source

n/a

Truncate

NOT truncating target due to Incremental option

n/a

Refresh

Using legacy loader

n/a

Index Maintenance

Maintenance cancelled

n/a

Calculation

Warnings

List of warnings

Flush

Not logging any further errors as max of reached!

Maximum number of errors

General

Target rows after

  1. Data Load Type

  2. Number of rows

Results

The Results section provides results for calculation, as shown in the following example.

Parameters

Label

Calculation Result

Label

Calculation Result

Incremental

false

Incremental

false

Recommendations

Label

Calculation Result

Label

Calculation Result

Policy Records

Show

Pricing

Show

#Segments

0

#Success

0

#Failed

0

#Yellow Alert

0

#Red Alert

0

#Critical Alert

0

Job Parameters

The Job Parameters section provides details about the job parameters used during job execution, as shown in the following example.

 

Found an issue in documentation? Write to us.

 
Pricefx version 14.0