Violation of PRIMARY KEY constraint ‘PK_Scenario’. Cannot insert duplicate key in object ‘Datamart.Scenario’.

Management Reporter CU14 Datamart Error – Violation of PRIMARY KEY If you have run into this error the source of it maybe in the sequence that you created the Datamart for multiple Dynamics GP DBs. In the case I encountered the users had 3 Dynamics GP Databases and the Functional and ISO Current were created…

Read More

Exact MAX Support – Dynamics GP Data Mart Currency Errors – MR CU13

 Exact MAX Support Dynamics GP Data Mart Currency Errors and Data Mart The official Knowledgebase article from MicroSoft is here: mbs2.microsoft.com/…/KBDisplay.aspx To install the Data Mart in Management Reporter you need to assign both a functional currency and an ISO code to each of your companies in Dynamics GP. Here are the steps: A Functional Currency…

Read More