Home
Troubleshooting and Tuning
Performance depends on many factors, including your database and web server configuration, network connectivity and other configurations.
Troubleshooting Guide
Processes and Flowcharts
Refer to this section for assistance in troubleshooting issues with Unica Campaign processes and flowcharts.
TempTable use warning is not displayed if data source is changed to enable use of temp tables
When you use raw SQL, you should use <TempTable> tokens.

Troubleshooting and Tuning
Performance depends on many factors, including your database and web server configuration, network connectivity and other configurations.
- Tuning Guide
- Troubleshooting Guide
  - Troubleshooting Unica Campaign Performance
    Performance depends on many factors, including your database and web server configuration, network connectivity, and Unica Campaign and Unica Platform configuration.
  - Using log files to troubleshoot
    These topics explain how to use the Unica Campaign log files for troubleshooting.
  - Unica Campaign Configuration
    These topics provide troubleshooting information about Unica Campaign configuration and integration.
  - Localization and Internationalization
    Refer to this section for assistance in troubleshooting issues with configuring Unica Campaign for use with non-ASCII data or non-United States locales.
  - Troubleshooting database issues
    Refer to this section for assistance in troubleshooting database issues for Unica Campaign system tables and user tables (data sources).
  - Unica Campaign Server and Utilities
    Refer to this section for assistance in troubleshooting issues with the Unica Campaign utilities.
  - User Administration and Security
    Refer to this section for assistance in troubleshooting issues relating to application access and user permissions.
  - Unica Campaign Interface
    Refer to this section for assistance in troubleshooting issues with using the Unica Campaign interface.
  - Processes and Flowcharts
    Refer to this section for assistance in troubleshooting issues with Unica Campaign processes and flowcharts.
    - Packaging flowchart files for troubleshooting
      If you need help from HCL to troubleshoot a flowchart, you can automatically collect relevant data to send to the Technical Support.
    - Error saving flowchart after deleting an offer used in a process
      Problem or error: When you save a flowchart after deleting an offer that is used in one of the flowchart's process boxes, Unica Campaign displays an integrity constraint error.
    - A merge of two Select processes gives unexpected results
      Problem or error: When two Select processes are merged using the Match (AND) on include option in the Merge process, the results do not equal the results from an equivalent single Select process.
    - Raw SQL in midstream Select or Segment process requires TempTable token
      When raw SQL is used in a Select or Segment process with an input cell, you should use the <TempTable> token to join against the incoming cell IDs. Not using the <TempTable> token might result in longer execution times.
    - TempTable use warning is not displayed if data source is changed to enable use of temp tables
      When you use raw SQL, you should use <TempTable> tokens.
    - Optimize process not cleaned up properly after crash
      Problem or error: If a flowchart containing an Optimize process crashes with the Optimize process running, the Optimize process is not cleaned up, and the Optimize session in which it is participating reports that a campaign is still running (Optimize will not run the session).
    - Problem profiling offer and cell UCGFs
      In contact processes, the profile function does not work on offer or cell Unica Campaign-generated fields (UCGFs).
    - Error: SERVER ignored previous N messages (server busy)
      Problem or error: The following message appears in the flowchart log: SERVER ignored previous N messages (server busy)
    - Branch or process flowchart runs are not displayed on the Monitoring page
      Only flowcharts that are run in their entirety appear on the Monitoring page.
    - Monitoring page does not display running flowcharts with WebSphere 6.1 and two nodes
      Problem or error: The Unica Campaign Monitoring page fails to display any running flowcharts in a Unica Campaign environment with the WebSphere 6.1 application server and two nodes.
    - How to shut down the server when flowcharts use triggers
      Problem or error: What issues should I be aware of when I must shut down the server on which Unica Campaign is installed, and I have flowcharts that use triggers?
    - Problem setting up a trigger with a wildcard on UNIX
      Problem or error: The following trigger did not work: /campaign/bin/unica_actrg -p 4664 * go
    - Precision loss with large numbers or non-integer values
      Problem or error: Due to limitations of the data types used in Unica Campaign, precision loss can occur in a number of circumstances.
    - Data-driven offer attributes are not validated
      Unica Campaign does not perform validation on parameterized offer attribute values. For example, if the offer expiration date is parameterized and is populated from a table data field with a date value in the past, this is allowed.
    - Length of numeric database columns is changed on export
      Problem or error: Numeric database columns of length N are changed to length N+7 in the data dictionary file (.dct file).
    - Cannot print flowcharts with Internet Explorer Print function
      Problem or error: Flowcharts cannot be printed using the Internet Explorer Print function.
    - Wrong sort order error in the flowchart log file
      Problem or error:"Wrong sort order" entries appear repeatedly in the flowchart log file.
    - Segment process displays Error 11302
      Problem or error: After running a Segment process, Unica Campaign displays the following error: Error 11302: No more records.
  - Cell Management
    Refer to this section for assistance in troubleshooting issues with cell management, including target cell spreadsheets, cell codes, and cell code formats.
  - Contact History and Response Tracking
    Refer to this section for assistance in troubleshooting issues with contact history and response tracking in Unica Campaign.
  - Stored Objects
    Refer to this section for assistance in troubleshooting issues with stored objects, including derived fields, user variables, custom macros, and templates.
  - Customizing campaigns
    Refer to this section for assistance in troubleshooting issues with customizing campaigns.
  - Installation and Upgrades
    Refer to this section for assistance in troubleshooting issues with installing and upgrading Unica Campaign.
  - Data Migration
    Refer to this section for assistance in troubleshooting issues with migrating and re-migrating data to Unica Campaign from pre-7.x versions of Affinium Unica Campaign.

<TempTable> use warning is not displayed if data source is changed to enable use of temp tables

When you use raw SQL, you should use <TempTable> tokens.

Unica Campaign produces a warning when <TempTable> tokens are not used. However, the <TempTable> use warning is not displayed if you initially disallowed temp tables but then change the data source to subsequently enable their use. If you do turn on the use of temporary tables, you should manually review all instances where raw SQL is used, to determine if the <TempTable> token should be added.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.