Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
NsersweCC
New Contributor

Error: The field 'ProvisioningState' of the record wasn't found.

In a Trial capacity with Premium, When trying to connect data from a dataflow Gen2 to a Fabric SQL Database - run into this error and the data tables do not get written to the Database. 

Could someone help me resolve this please? 

 

Error message: 

The field 'ProvisioningState' of the record wasn't found. (Request ID: 3de0c1cd-534e-41df-a4f4-420efc4c57ed, Region: us2)

Details

Reason = Expression.Error

connectionInfo = Data Source=6bvo5ubprp7uzbkyskf7pa27me- 
twooditrulbebhmy54stykp62u.database.fabric.microsoft.com,1433;Initial Catalog=FabricSQLV2-d531f33b-a080-4e44-850f-541a7a8e5164;Multiple Active Result Sets=False;Connect Timeout=30;Encrypt=True;Trust Server Certificate=False

databaseName = FabricSQLV2-d531f33b-a080-4e44-850f-541a7a8e5164

serverFqdn = 6bvo5ubprp7uzbkyskf7pa27me-twooditrulbebhmy54stykp62u.database.fabric.microsoft.com,1433

provisioningState = Active

createdDate = 2025-01-10T19:18:07.680174

lastUpdatedTimeUtc = 2025-01-10T19:18:40.461358.

 

image (1).png

SQLDatabaseError.PNG

 

 

1 ACCEPTED SOLUTION

In this case you are looking for a self hosted integration runtime (SHIR) that is running on a machine in your network. The name of the SHIR should match the host name of the machine you need to log into to update it. Once you are there you should see an update button like here: https://learn.microsoft.com/en-us/purview/manage-integration-runtimes#self-hosted-integration-runtim...

View solution in original post

3 REPLIES 3
dlevy
Contributor

Hi @NsersweCC - Sorry to hear you are having trouble!

 

We took a look at the logs and it appears that the integration runtime you are using is from August. Please update your integration runtime to the latest version. The version you are on is not compatible with the latest code.

 

The team is looking at ways to handle this better in the future.

Thank you, How do I update my Integration Runtime? Do I do it from Inside Fabric or elsewhere?

In this case you are looking for a self hosted integration runtime (SHIR) that is running on a machine in your network. The name of the SHIR should match the host name of the machine you need to log into to update it. Once you are there you should see an update button like here: https://learn.microsoft.com/en-us/purview/manage-integration-runtimes#self-hosted-integration-runtim...

Helpful resources

Announcements
Users online (25)