Summary

Error Messages

Steps to Reproduce

1. Execute a Strategy in a data flow. The Strategy results are sent to a DDS.
2. Use a Dynamic System Setting (DSS) to set the Specify Time to Live (30 days).

Root Cause

Resolution

1. CQLSH Query to fetch the "TTL" remaining in seconds for a record

   Query Syntax: select ttl(data_), [key_column] from <keyspace>.<table> where [use only the exposed columns] limit 10 ALLOW FILTERING;
   
   TTL remaining time in days:  tl(data_) / 86400 = x days 

2. CQLSH Query to fetch the WRITETIME (in microseconds) of a record into C* table

   Query Syntax: SELECT WRITETIME(data_) from <keyspace>.<table> where [use only the exposed columns];

3. Convert the WRITETIME result into the Actual Date and Time

   Convert the query result from microseconds to milliseconds before converting the result to the Actual Date and Time.

   TTL elapsed time in days: Use the Days calculator to identify the Days Between Two Dates      

   Ensure to use the 'End Date' as the date when the 'CQLSH Query 1' above is run 

4. Actual TTL value set from the application
   
   Actual TTL Value in days = "TTL remaining time in days" + "TTL elapsed time in days" = XY days which is the actual TTL value set for this record when it is inserted to the C* table from the Pega application.