Skip to main content

Import Fail: due to Scenario Name

Scenario fails to import into Advice Designer because the scenario name contains restricted words or symbols

Overview

A scenario can fail to import into Advice Designer because of the name given to the scenario in Xplan. The scenario data itself may be complete and correct, but the import is rejected before it is processed.

Why This Happens

Advice Designer runs a security check on scenario names during import. This check reads some words and symbols as database commands, and rejects the import to protect your data.

Scenario names should not contain:

  • Command words, especially as the first word: Select, Update, Delete, Insert, Drop, Create, Alter, Truncate, Union, Merge, Exec, Declare, Having

  • A word followed by brackets, e.g. Sleep(5), IF(a=1)

  • Symbols: ; ' " -- # /* */

Examples

  • ❌ "Update", "Select Scenario", "Plan; Update cover"

  • ✅ "Retirement Projection – Jan 2026", "Revised Contribution Options"

How to Fix It

The scenario name must be corrected directly in Xplan before re-attempting the import.

  1. Open the relevant client record in Xplan.

  2. Navigate to the Xtools+ scenario that failed to import.

  3. Check the scenario name against the restricted words and symbols listed above.

  4. Rename the scenario to remove any restricted words or symbols, and save.

  5. Return to Advice Designer and import the scenario again.

💡Tip: Use plain, descriptive names for your scenarios (e.g. the strategy and date) to avoid this issue in future.

Still Seeing the Error?

If the import still fails after renaming the scenario, confirm the change has been saved in Xplan and that you are selecting the renamed scenario in Advice Designer. If the issue continues, contact the Advice Designer support team.

Did this answer your question?