-
Title
Sending Transform and Cleanse results, to Local storage, results in an exception error "...Quest.Toad.LocalStorage.Dialogs.LocalStorageDestinationForm.GetColumnMapHashTable" -
Description
When sending the results of a Transform and Cleanse to Local Storage (create a single table), the following error occurs:
System.NullReferenceException Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.LocalStorage.Dialogs.LocalStorageDestinationForm.GetColumnMapHashTable(FastTable mapTable, FastTable targetTable, FastTable sourceTable, IActiveStorageSource& adapter)
at Quest.Toad.LocalStorage.Dialogs.LocalStorageDestinationForm.
GetDestinationTable(IActiveStorageSource& adapter)at Quest.Toad.LocalStorage.Dialogs.LocalStorageDestinationForm.
Show(IConnection sourceConnection, IActiveStorageSource adapter, FastTable sourceTable, LocalStorageAction& localStorageActionOut, String& databaseNameOut, String& tableNameOut, Boolean& truncateOut, FastTable& destinationTableOut, IActiveStorageSource& destinationAdapterOut)at Quest.Toad.LocalStorage.LocalStorage.SaveLocalStorage(FastTable table, IActiveStorageSource adapter) at Quest.Toad.ETL.ETLTransformCleanse.ETLForm.b__47()
-
Cause
Table name specified in the wizard is mixed case. -
Resolution
WORKAROUND
Use all lowercase for the destination table name.
STATUS
Fixed in version 4.0. The latest release can be downloaded here.
-
Defect ID
QAT-6560 -
Additional Information
This error may also occur if a mixed case table name already exists in the local storage and this is selected from the 'use existing table' dropdown. In addition, the error may occur when browsing the Local Storage in the Object Explorer, if a mixed case table name exists.