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 |
---|---|---|---|
General | Incremental |
| 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 |
| |
General | Target rows before |
| |
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 |
| |
Index Maintenance | Table for has rows before rebuild |
| |
Index Maintenance | Table for has rows after rebuild |
| |
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 |
| |
Calculation | Calculated rows |
| |
Publishing | System parameter |
| |
Index Maintenance | Skipped indexing |
| |
Index Maintenance | Created indexes |
| |
Calculation | Calculation context | Context from the Calculation Step | |
Truncate | Deleted | Number of rows | |
Refresh | Deleted rows from |
| |
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 |
| |
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 |
| |
General | Source rows | Number of rows | |
Refresh | Secondary source has new or 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 |
| |
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 |
| |
Flush | Flushed a total of data rows, skipped rows with errors |
| |
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 |
| |
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 |
|
Results
The Results section provides results for calculation, as shown in the following example.
Parameters
Label | Calculation Result |
---|---|
Incremental | false |
Incremental | false |
Recommendations
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