KNOWLEDGE BASE

Error "The field '[xxx]' in the datasource 'XXX' does not exist in your database. It was either modified or removed" When Converting Field Type

Published: 29 Sep 2021
Last Modified Date: 25 Apr 2023

Issue

The following errors can occur for multiple causes including:

  • Converting a time field to a string field after a wildcard union with several flat files.
  • Change the data type of a string to a date in an extract.

Error: The field '[XXX]' in the datasource 'relation' does not exist in your database.  It was either modified or removed.
Error Code: 9CA7205B

or

Error: The field '[XXX]' in the datasource 'federated.XXX' does not exist in your database.  It was either modified or removed.
Error Code: 9CA7205B


User-added image

Environment

  • Tableau Desktop 2021.2 or newer.
  • Text Files
  • Oracle
  • Federated

Resolution

Option 1

Change the data type before the extract is created.

Option 2

1. Turn on the Data Interpreter before you union your data.
2. Wild card union your data.
3. Change the data type after the wildcard union.

Option 3

Use a manual union instead of wildcard union.
 
Did this article resolve the issue?    
PRINT THIS PAGE
Trending Articles
Attachments


All Support

SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
INFORMATION
ASSISTANCE