Refreshing Datasets Error Message

Options
Rachael
Rachael Member
edited December 2023 in General

Hi,

I recently updated the credentials for an external system, and when refreshing some of the tables a few of the columns have been removed. Previously this hasn't been a problem because I can just configure the tables, but since we upgraded I've been getting the following message:

Screenshot 1: Notification that there are changes

image.png

Screenshot 2: Error message which comes up

image.png

Any help would be great! The only way around it I've found so far is deleting the old dataset and adding it back in.

Thanks

@SpeedySteven tagging you for info

Best Answer

  • Josh Boxer
    Josh Boxer Administrator
    Answer ✓
    Options

    Hi Rachel

    What type of database is this you are connecting to?

    If you know that the columns are missing then you can 'Annotate columns' of the Dataset and set them to Optional before hitting refresh.

    We will investigate the error message you are getting

Answers

  • Rachael
    Rachael Member
    Options

    Hi Josh,

    It's a SQL server database. Will try that workaround for now, thanks

    Rachael

  • Ian Hayden
    Ian Hayden Experian Super Contributor
    Options

    Hi @Rachael, could you send me your datastudio.log file so I can look into this more. Please send to ian.hayden@experian.com and I will be in touch.

    Many thanks,

    Ian

  • Rachael
    Rachael Member
    Options

    Hi @Ian Hayden, just sent that over to you

    Thanks

    Rachael

Categories