We upgraded from PI Integrator for Business Analytics 2016 R2 SP1 to PI Integrator for BA - DW (PI Integrator).
We published a view to the PIIntegrator SQL database and it take a lot of time for the view to be published.
That could be explained that it is a lot of data.
However we get the following error during the publishing:
SQLWriter::SyncFunc: Table='EventFrames', Source='.Net SqlClient Data Provider' - SQL Exception error: [-2146232060] - Violation of PRIMARY KEY constraint 'PK__OOC_PIEv__3214EC07173118C2'. Cannot insert duplicate key in object 'dbo.EventFrames'. The duplicate key value is (822001).
The statement has been terminated.
I would expect that the Integrator should handle Primary keys for us...
Am I overlooking something?