Error "Object reference not set to an instance of an object" when trying to add a 'day of the week' rule to a Transform and Cleanse (4308982)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Error "Object reference not set to an instance of an object" when trying to add a 'day of the week' rule to a Transform and Cleanse
Beschreibung

The following error occurs when trying add a 'day of the week' rule to a Transform & Cleanse
System.NullReferenceException: Object reference not set to an instance of an object.
Stack trace:
at Quest.Toad.ETL.ToadETLProvider.GenerateAllSqlStatements(IConnection connection, String defaultSchema, IETLStep[] steps, IETLOutput stopOutput)
at Quest.Toad.ETL.ETLTransformCleanse.ETLForm.UpdateSql()
at Quest.Toad.ETL.ETLTransformCleanse.ETLForm.get_SqlAvailable()
at Quest.Toad.ETL.ETLTransformCleanse.ETLActionManager.EnableSQLOutput(BarItem item)
Ursache

Toad is trying to generate SQL for the rule but this is causing an exception
Lösung

WORKAROUND
To workaround the issue, add a rule that disables sql generation. Below is an example where a calculated column is added and the "Use SQL Transform" is deselected.

STATUS
Waiting for fix in a future release of Toad Data Point
Fehler-ID

QAT-9829

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel