Common Issues Seen in Activation Runs

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 date and priority: 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:

  1. Update the field mapping to map the query fields to the Target object fields.

  2. Restart the Activation.

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, or TO_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.

Refer to the following table for the list of key updates made to this page: