Job Details | Pricefx Knowledge Base

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	`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` For more information see Ran with User Context.	`Ran with user context: john.doe`
General	Target rows before	Data Load Type Number of rows	`Target rows before PublishDatamart: 20`
General	Filter	Used Target filter	`Filter: formulaResult='OK'`
General	Final filter	Final (Source) filter is the combination of the optional incremental filter and user selected Source filter.	Final filter: (`lastUpdateDate` >= "2024-11-28T00:07:25" and `formulaResult` = "OK") (*)
General	New lastUpdateDate	Date of the last update	`New lastUpdateDate: 2024-11-19T02:39:31.000Z`
Index Maintenance	Starting at with incremental	Timestamp Incremental mode: `True`, `False`	`Starting at 2024-12-12T09:10:49.232583557 with incremental false`
Index Maintenance	Table for has rows before rebuild	Data Source Number of rows	`Table for DM.Gapminder has 12864 rows before rebuild`
Index Maintenance	Table for has rows after rebuild	Data Source Number of rows	`Table for DM.Gapminder has 12864 rows after rebuild`
Index Maintenance	Rebuilt table in non-inc mode	n/a	`Rebuilt table in non-inc mode`
Calculation	Target fields	List of Target fields	`Target fields: [lastUpdateDate, InvoiceLineID, id, PaymentDays]`
Calculation	Source fields	List of Source fields	`Source fields: [InvoiceLineID, id, PaymentDays]`
Internal Copy	Using source filter	Used Source filter	Using source filter (`lastUpdateDate` >= "2024-11-28T00:07:25" and `formulaResult` = "OK")
Calculation	Logic	Used Logic	`Logic: PaymentDaysRandomizer[2147485478]`
Calculation	Feeder	Used Feeder Logic	`Feeder: DL_BonusOnSales_Feeder`
Calculation	Formula feeder warnings	Used Feeder Logic	`===== formula DL_BonusOnSales_Feeder feeder warnings:`
Calculation	End of feeder formula warnings	n/a	`===== end of feeder formula warnings`
General	Source rows	Number of rows	`Source rows: 23,998`
Calculation	Target snapshot to be queried...	n/a	`Target snapshot to be queried...`
Calculation	Target snapshot is disabled	n/a	`Target snapshot is disabled`
Calculation	Source snapshot to be queried...	n/a	`Source snapshot to be queried...`
Calculation	Completed snapshot of	Datamart Used filter SortBy AutoKey	`Completed snapshot of seeddata.DMDS.QB.2147483897: filter=null, sort=null, autoKey=false`
Calculation	Calculated rows	Number of calculated rows Number of skipped rows	`Calculated 23,998 rows, skipped 0 rows with errors`
Publishing	System parameter	Index on Publish `True`, `False`	`System parameter 'datamart.dataLoad.indexOnPublish': false`
Index Maintenance	Skipped indexing	`columnar`, `non columnar` Data Load	`Skipped indexing on non-columnar table for seeddata.DMT.datamart_transaction_2147484936_DMDL.202`
Index Maintenance	Created indexes	`columnar`, `non columnar` Data Load	`Created indexes on non-columnar table for seeddata.DMT.datamart_transaction_2147484936_DMDL.202`
Calculation	Calculation context	Context from the Calculation Step	`Calculation context: [Pricing]`
Truncate	Deleted	Number of rows	`Deleted 10 rows`
Refresh	Deleted rows from	Number of deleted rows Data Source	`Deleted 10 rows from Transactions`
Calculation	Updated fields	List of updated fiels	`Updated fields: [lastUpdateDate, InvoiceLineID, id, PaymentDays]`
Refresh	Update from source complete	Data Source	`Update from source Transactions complete`
Calculation	Calculation is distributed	n/a	n/a
Calculation	Calculation is local	n/a	`Calculation is local`
Calculation	Load mode	FULL INCREMENTAL ENRICHMENT ALLOCATION	`Load mode: FULL`
Calculation	Rows in result table	Number of rows	`Rows in result table: 0`
Calculation	No rows to load	n/a	`No rows to load`
Truncate	Truncated target table	n/a	`Truncated target table`
General	Load cancelled	n/a	`Load cancelled`
General	Load failed	Error message	`Load failed: java.lang.RuntimeException: Formula CustomerInsights_DL_Aggregation[2147485459] error: CreatingBatches : ERROR(@19): Cannot get property 'batchingDimension' on null object`
General	Load failed with formula syntax error	Any sandbox Groovy error message.	n/a
Flush	Flush error	Error message	`Flush error: Error message`
General	Load cancelled	Data Load name	`Load PublishDatamart cancelled`
General	Load failed	Data Load name	`Load PublishDatamart failed`
Truncate	Truncate cancelled	Error message	`Truncate cancelled: Error message`
Truncate	Truncate failed	Error message	`Truncate failed: Error message`
General	Source	Data Source name	`Source: Products`
General	Source filter	Filter applied in the Source tab.	`Source filter: Currency='EUR'`
Calculation	Batching filter	Filter applied in the Source tab.	`Batching filter: Currency='EUR'`
General	Waited s(millis) on lock on	Number of seconds (milliseconds) Data Source	`Waited 3s on lock on Products`
General	Source rows	Number of rows	`Source rows: 10`
Refresh	Secondary source has new or updated rows	Data Source Number of updated rows	`Secondary source Transactions has 10 new or updated rows`
Calculation	Formula not found	Formula name	`Formula Calcucation not found`
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	Number of total rows Number of skipped rows Number of rows with error	`Added a total of 0 rows, skipped 0 rows with errors`
Refresh	Skipping update from as not all key fields are in the target DM's table	Data Source	`Skipping update from Transactions as not all key fields are in the target DM's table`
Flush	Skipping row due to invalid field values	Number of the skipped row Key Attributes List of invalid field values	`Skipping row #20 CustomerId due to invalid field values: [List of values]`
Flush	Flushed a total of data rows, skipped rows with errors	Number of total rows Number of skipped rows	`Flushed a total of 200 data rows, skipped 10 rows with errors`
Internal Copy	Loaded rows	Number of rows	`Loaded 1366 rows`
Internal Copy	Nothing to load	n/a	`Nothing to load`
General	Next incremental load date	Timestamp	`Next incremental load date: 2024-12-11T15:05:23`
Flush	Applied currency post-processing	n/a	`Applied currency post-processing`
Truncate	Applied Currencies DS post-processing after partial truncate	n/a	`Applied Currencies DS post-processing after partial truncate`
Flush	Applied Currencies DS post-processing	n/a	`Applied Currencies DS post-processing`
Calculation	Post calculation task failed	Error message	`Post calculation task failed: Error message`
Calculation	Pending	Number of pending calculation item ID of pending calculation item	`Pending 10: CD00001`
General	Load successful	n/a	`Load successful`
General	Load completed with errors	n/a	`Load completed with errors`
Calculation	No rows to load	n/a	`No rows to load`
Index Maintenance	Reindexing done	n/a	`Reindexing done`
Internal Copy	Copy cancelled	n/a	`Copy cancelled`
Internal Copy	Copy cancelled	Error message	`Copy cancelled: Error message`
Internal Copy	Copy failed	Error message	`Copy failed: Error message`
Calendar	Calendar load cancelled	Error message	`Calendar load cancelled: Error message`
Calendar	Calendar load failed	Error message	`Calendar load failed: Error message`
Index Maintenance	Maintenance cancelled	Error message	`Maintenance cancelled: Error message`
Index Maintenance	Maintenance failed	Error message	`Maintenance failed: Error message`
Index Maintenance	Table is empty - aborting	n/a	`Table is empty - aborting`
Index Maintenance	Table is no longer distributed	n/a	`Table is no longer distributed`
Truncate	Target was truncated before copy	n/a	`Target was truncated before copy`
Index Maintenance	Table is distributed on	Distribution Key	`Table is distributed on CustomerID`
Index Maintenance	Table is now distributionKey on	Distribution Key	`Table is now distributionKey on CustomerID`
Index Maintenance	Table is now partitioned on	Partitioning Key	`Table is now partitioned on InvoiceDate`
Index Maintenance	Table is partitioned on	Partitioning Key	`Table is partitioned on InvoiceDate`
Truncate	Truncate cancelled	n/a	`Truncate cancelled`
Refresh	Aborting as DM has no source	n/a	`Aborting as DM has no source`
Truncate	NOT truncating target due to Incremental option	n/a	`NOT truncating target due to Incremental option`
Refresh	Using legacy loader	n/a	`Using legacy loader`
Index Maintenance	Maintenance cancelled	n/a	`Maintenance cancelled`
Calculation	Warnings	List of warnings	`Warnings: [List of warnings]`
Flush	Not logging any further errors as max of reached!	Maximum number of errors	`Not logging any further errors as max of 500 reached!`
General	Target rows after	Data Load Type Number of rows	`Target rows after PublishDatamart: 20`

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.

JSON

{
  "dataLoad": {
    "targetName": "DMF.Product_2",
    "typedId": "4630.DMDL",
    "distributed": false,
    "incremental": true,
    "type": "TRUNCATE",
    "withTargetSnapshot": false,
    "withSourceSnapshot": true,
    "dtoFilter": {
      "_constructor": "AdvancedCriteria",
      "criteria": [
        {
          "fieldName": "formulaResult",
          "value": "OK",
          "operator": "equals"
        }
      ],
      "operator": "and"
    },
    "incLoadDate": "2024-11-28T00:07:25",
    "autoLoadOnSuccess": true,
    "calculationConfig": {
      "feederInputParams": [],
      "inputParams": [],
      "mappingParams": [],
      "outputElements": []
    }
  }
}