Forum Discussion
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.
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-runtime-auto-update
3 Replies
- dlevy
Microsoft Employee
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?
- dlevy
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-runtime-auto-update
