Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > Troubleshooting in Siebel Marketing > Other Troubleshooting Issues in Siebel Marketing >

Resolving Snapshot Counts Discrepancies

---

After generating a snapshot, you identify a discrepancy between expected counts and actual counts.

How to diagnose. Verify segment and filter criteria, administrative setup, and data mapping. Review the snapshot log. Some problems may require you to work with your marketing administrator.

Possible Cause 1

Segment or filter criteria is incorrect.

How to diagnose 1. Verify segment and filter criteria. Some problems may require you to work with your marketing administrator.

How to resolve 1. Verify the following, correct any errors, and regenerate the snapshot.

Review segment and filter logic to make sure it maps correctly to the business requirement.
Validate segment criteria using SQL. Query the database directly to identify any data issues.
Troubleshoot using update counts. Start with simplified segment criteria, update counts using the snapshot and then keep adding more criteria till you identify the problem area.

Possible Cause 2

Measures and measure-based attributes or hierarchies setup is incorrect.

How to diagnose 2. Verify that measures are setup correctly. Some problems may require you to work with your marketing administrator.

How to resolve 2. Review the following, correct any errors, and regenerate the snapshot:

Review measures and measure-based attributes or hierarchies to make sure they are defined correctly.
Verify that the fields and attribute families are synchronized with the latest data refresh.

Possible Cause 3

Data mapping is incorrect.

How to diagnose 3. Verify that data mapping is correct. Review the snapshot log. Some problems may require you to work with your marketing administrator.

How to resolve 3. Review Marketing Server snapshot log file for the following problems, correct any errors, and regenerate the snapshot:

When verifying the table joins, make sure that the join path is pointed at the correct tables.
Using the table count summary in the log file, look for data loss resulting from incorrect join types. For example, an Equal join can eliminate data if the criteria expects an Outer join.
Verify that the table counts are correct.
Check for any errors or warning from the Marketing Server or ODBC.

Possible Cause 4

Extraneous events can affect the Marketing Server or data.

How to diagnose. Verify segment and filter criteria, administrative setup, and data mapping. Review the snapshot log. Some problems may require you to work with your marketing administrator.

How to resolve 4. Check for occurrences of external events such as ETL refreshes that may affect the Marketing Server or the data. Check your ETL logs. For example, there might be 1 MM contacts in the Siebel OLTP database and 990K in the OLAP database. You might need to refresh the OLAP database.

Bookshelf Home | Contents | Index | Search | PDF