Velg en organisasjon
Error "The field '[xxx]' in the datasource 'XXX' does not exist in your database. It was either modified or removed" When Converting Field Type
Publiseringsdato: Apr 13, 2024
Beskrivelse
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
Løsning
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.Knowledge-artikkelnummer
001474500
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
