Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Error handling
Migration Platform
  • Overview
  • Product features
    • Release notes
    • Source and target platforms
    • Third-party applications
  • Getting started
    • Creating a new project
    • Ora2Pg installation
    • Tree view filtering
    • Compatible ODAC versions
    • Opening an existing project
    • Connecting to servers
      • Connecting to an Azure SQL Database
      • Connecting to an Oracle database
      • Connecting to a PostgreSQL database
      • Connecting to a Microsoft SQL Server database
    • Command timeout
  • Mapping
    • Object mapping
    • Error mapping rules
    • Data types mapping
  • Schema conversion
  • Schema comparison
  • Data comparison
  • Data migration
    • Migration task
      • Creating migration tasks
      • Templates
      • Migration options
      • Task actions
      • Task statuses
      • Errors or non-standard situations
    • Installing migration agent
      • Installing and uninstalling the data migration agent
      • Registering the migration agents
    • Project settings
  • Test organizer
    • Creating tests
    • Auto-generating tests
    • Groups and tests execution
    • Groups and tests states and execution statuses
    • Tests moving logic
    • Importing and exporting tests
    • Advanced comparison options
    • Creating reports
    • Error handling
  • Data store
  • Development project
  • System requirements
  • Hot keys
  • Known issues
  • Support

Error handling

  • Share
    • Share via Facebook
    • Share via Twitter
    • Share via Linkedin

Test Organizer provides wide opportunities for errors handling — it’s important that both the Source and Target databases perform the same way, including errors. For expected errors, users can override syntax differences for similar errors by enabling the Compare error messages option. For not expected errors, users can pass them by adding custom error mapping rules.

Expected errors

The expected errors list includes errors defined within the Mapping rules to classify them as expected behavior.

Expected error

Figure 1. Similar expected error messages

To enable Error comparison, go to the Main Menu at the upper left corner of the screen, choose Project Settings > Test Organizer and check the Show the “Advanced compare options” tab option.

Advanced error options

Figure 2. Enabling Advanced compare options

Then, return to the main Test Organizer field and click on the Advanced compare options tab. Scroll down to the bottom of the tab, check Override parent options and Compare error messages and click Save.

Compare error messages

Figure 3. Enabling error comparison

After running the test, the expected error will be added to the exception and will have the “passed” status.

Expected error exception

Figure 4. Expected error added to exception

Not expected errors

The expected errors list includes errors whose scenarios are not included in the Mapping rules.

Not expected error message

Figure 5. Not expected error message

To enable custom matching, enable the Compare error messages option as in Figure 3. Then, go to Mapping > Error mapping rules and click Add.

Copy the error messages for both the Source and Target databases from the Results tab in the Test Organizer module and paste them in the corresponding fields of the Create error mapping rule menu, then click Save.

Create error mapping rule

Figure 6. Adding custom mapping rules

After running the test, the previously classified not expected error will be added to the exception and will have the passed status.

Not expected exception

Figure 7. Not expected error added to exception


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].

Did this page help you?

Provide Feedback
PreviousAdvanced comparison options
Next Data store

Did this page help you? Yes

Thanks for letting us know that we did a great job.

Did this page help you? No

Thanks for letting us know that there is a problem on this page.

Send Feedback

Feel free to share your ideas or occurred issues with us. The DB Best team will be happy to make our documentation better.

Please, specify your email address so that we can reach out to you to clarify your question. Also, we will use this email address to notify you about solving the issue.

* marks the mandatory fields

Dark theme Light theme

© 2002–2021 DB Best Technologies, LLC. All rights reserved.