You’re offline. This is a read only version of the page.
Announcements
54
I have just migrated a solution to a new environment using export/import and am experiencing and issue with a table Relationship. It is a simple one-to-many relationship that is being populated by Power Automate. The Flow works perfectly in the original environment and they appear to be identical to me...have run them side-by-side. The Flow in the new Environment eventually times out and puts out this error.
"@Microsoft.PowerApps.CDS.InnerError.Message": " Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 547"
I am passing the @{outputs('Create_New_Record')?['body/@odata.id']} in both environments, and the problematic variable string is "https://orgXXXXXXXe.crm.dynamics.com/api/data/v9.1/abc_parent(ac31ddca-142e-ed11-9db1-0011481e6f33)"
To troubleshoot, I created a replica Relationship and simply versioned the name up...then passed the same exact variable in the new relationship field defined in the Flow...and the Flow/new record worked perfectly. I also created a Relate Rows action card to associate the two records, instead of using the Odata ID reference in the Add Record action, and it worked too.
Any ideas on the root cause? Thank you!
Share
Report
All responses (
Answers (
