UPDATE_FAILED - COLUMN_TYPE_MISMATCH

Q&A
,
1

Hi,
there was change in underlying DB object where I have changed Customer col datatypes to varchar from INTEGER and removed Customer_ID col from DB. Accordingly I have made change to dataset query (its spice) and refreshed and published and also updated analysis accordingly.
Its working fine in dev and dont see any issues at all But after these dev changes, i’m migrating it to prod (its existing dataset and analysis) where is failing with COLUMN_TYPE_MISMATCH - Customer INTEGER ()
COLUMN_REPLACEMENT_MISSING - Customer_ID
with error : calling the UpdateAnalysis operation: Cannot use a template when it is in CREATION_FAILED state

I looked all places both in dev and prod DB objects and the datatypes are same as mentioned above. I have no clue where to look. I refreshed/published dataset many time in dev after changes but still same issue while migrating it to prod.

Any insight to this issue would help a lot.

Thanks
BS

2

SantoshB, assume you have changed the datatype in your prod DB. But have you tried to recreate the dataset in your Quicksight production prior to the migration? See below description of Quicksight template: Template - Amazon QuickSight

1 Like
3

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!