Common Issues Seen in Activation Runs
This document lists a few issues noticed in an Activation run and the ways to fix them. If the suggested resolutions do not yield success, please reach out to Hevo Support.
Common Issues
Activation failed to run with: “Could not update record hash in snapshot table.”
| Probable Cause(s) | - Special characters or reserved keywords in the Activation SQL query field names. - Field mapping is null or empty. |
| Error Message | Encountered an internal error: Could not update record hash in snapshot table. |
Recommended Action(s):
-
Special characters or reserved keywords in the Activation SQL query field names: Use an alias for the column names in your query.
For example, suppose that the column names in your data warehouse table are
reg dateandpriority: high. Now, if you want to select these columns in your Activation SQL query, you must use an alias for each column name and form your SQL query as follows:SELECT "reg date" as Reg_Date, "priority: high" as High_Priority FROM CASE_TABLE; -
Field Mapping is null or empty: This may happen if there are no fields mapped for the Activation. In such a case:
-
Update the field mapping to map the query fields to the Target object fields.
-
Restart the Activation.
-
Activation failed to run with: “Could not update record hash in snapshot table.”
| Probable Cause(s) | Fields (or columns) of DATE and TIME data types are mapped to incompatible data types in the Field Mapping step. For example, a DATE type query field is mapped to a Target object field of type, TIMESTAMP. |
| Error Message | Encountered an internal error: time component is also present in Date in the source field. It must be mapped to a datetime/timestamp field in the destination. |
Recommended Action(s):
You can take any one of the following actions:
-
Update the field mapping to map the fields of compatible data types to each other.
-
Use the appropriate DATE and TIME functions, such as
TO_DATE,TO_TIMESTAMP, orTO_TIMESTAMP_TZ, on the field(s) in your query, and then map them to the required Target object field(s). Read the documentation for your Activate Warehouse to choose the suitable function.