Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

OHMark

Bug: Datamart Loading Data Internal Error Code 500 - Failed Runtime Assertion

Submitted by on ‎07-20-2023 03:33 AM

I was updating our datamart and was given the following Internal error message:

InternalError

  • ErrorMessage: An internal error happened due to failed runtime assertion: Unable to change Model locale after other objects have been created..
  • HttpStatusCode: 500

 

This also occurs when I haven't updated anything in the datamart and follow path Transform Data -> Save -> Error Message

Status: Needs Info
See more ideas labeled with:
17 Comments (17 New)
Comments
OHMark
Regular Visitor
‎08-01-2023 01:49 AM

Hello All!

 

@luizraposo is correct that the locale for me (English United Kingdom) is buggy. I switch to English United States and was able to load my datamart.

Steps to switch:

  1. Enter Datamart
  2. Trasnform Data and stay on the Home Tab
  3. Go Options -> Regional Settings
  4. Change your Locale to English United States
  5. Load Datamart - Should work

I tried switching back to English United Kingdom but it bugged out on me with the same error message. @Anonymous, Can this be resolved please as I'd prefer to stay on the English United Kingdom locale?

ivandavidbt
Frequent Visitor
‎08-01-2023 07:26 AM

Hi @OHMark , thank you for your guidance on changing the region, this solution is definitely not working for me. Are there any updates from the microsoft team @Anonymous ?

Thank you!

Dianis08
Regular Visitor
‎08-01-2023 10:25 PM

Thanks for the post @OHMark , the change worked for me, but in my case I changed from English United States to English Australia.

 

But Interested to know other solution.

 

Kind regards,

Mkin
Regular Visitor
‎08-03-2023 05:24 AM

Hello all!

 

I'm in the same boat as @ivandavidbt. I've tried changing the regional settings, but still get the same error code. If anyone knows of any other solutions, that would be greatly appreciated. 

 

Thank you!

luizraposo
Regular Visitor
‎08-03-2023 07:05 AM

guys, it's in this line of OhMark that I made the configuration and it worked first hand. I suggest running variations of "English" locales to find the correct one

sarah127583
Advocate I
Advocate I
‎08-23-2023 01:48 AM

Hi - same problem here - are there any solutions to this?

cedar
Frequent Visitor
‎08-23-2023 03:16 PM

Thanks @OHMark , I changed from English United States to English UK and it worked.

Idea Statuses