As part of the FCR Release 2608 update, enhancements were introduced to improve data import performance and ensure correct column data typing for ADO Imports to FCR.
Specifically:
- Schema Correction: Staging tables now properly instantiate numeric columns as float rather than defaulting to string.
- Performance Optimization (Table Truncation): Instead of dropping and recreating the FCR staging table from scratch on every execution, the import process now truncates the existing staging table.
Potential Impact
This impacts customers who are using ADO Import workflow tasks to import data to FCR via ADO.
If an existing staging table was previously generated with string data types, automated import jobs loading numeric (float) values from ADO may fail with the following error:
- Error Message: Source ADO table structure does not match target Staging Table structure
Fix
Update target staging table columns expecting floats from string to float. Ensure source ADO and target staging table schemas match exactly.
