Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Elizabeth Whitbread]

Can anyone tell me how to resolve this IM error?  

Query ‘ARTransHeader’ cannot be previewed due to the following problem:
– Data Source ‘%1’ has been deleted from the database.
Add failed. Duplicate key value supplied.
Data Source ‘%1’ has been deleted from the database. – Add failed. Duplicate key value supplied.
Add failed. Duplicate key value supplied.

——————————
Elizabeth Whitbread
Bridgepoint Consulting
Austin TX
——————————

[Joni Finnell]

Elizabeth:

I would look at your data source properties. It looks like the path to that source is non-existing.

Thanks

——————————
Joni Finnell
Project Accountant/GP Troubleshooter
Consumer Support Services, Inc.
Newark OH
——————————
——————————————-

[Blair Christensen]

I’ve had problems with IM in trying to fix integrations once they go south.  I usually end up starting over and rebuilding it from scratch.  Here are a couple of screens not many people know about which may assist, however:

Object Browser.  This allows you to see your existing Integrations, Data Source Names, and available adapters.  Very handy!

Integration Properties.  Allows you to see error handling and scripting.

Destination Mapping – Options Tab.  Allows you to set some “hidden” values.

(PS – note to the forum: why can you not intersperse comments with images?  All the images go to the top!)

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-