Fact ID in PR_DATA_IH_FACT Table is storing Negative Values
For few responses added in PR_DATA_IH_FACT table was storing negative values for Fact ID and PZIDs.
Steps to Reproduce
Submit IS response and you would notice negative (sporadically) values getting added under PZIDs and Fact ID columns.
The Fact ID generation in Pega 7 is different than PRPC 6.3.1. In older release, PRPC uses a database sequence approach, while Pega 7 uses a class RandomSequentialIDGenerator which generates partially random and partially sequential long (64 bit) ID's. The generated ID's represent a hash of the entire FACT record and therefore can have negative number values.
From 7.1 onwards the IDs are not numbers pulled off a database sequence but they represent a hash of the entire FACT record. These are generated randomly from the PRPC class com.pega.decision.common.ih.RandomSequentialIDGenerator. Hence negative number values for pxFactID are possible.
0% found this useful