Thanks MATTGUO
That thread looked so promising. But it didn't work for me - I'm still stuck.
I checked the event viewer. Reporting Services encounters this error:
Log Name: Application
Source: Management Reporter 2012 Services
Date: 2/26/2020 1:32:26 PM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: xxxxxxx
Description:
{"Class":14,"Number":2601,"State":1,"Message":"Cannot insert duplicate key row in object 'dbo.FINANCIALREPORTS' with unique index 'I_11314FOLDERREPORTNAME'. The duplicate key value is (5637144576, BW1, Default Report Definitions, 12 Month Rolling Single Column Income Statement - Default).\u000d\u000aThe statement has been terminated.","ErrorCode":-2146232060,"Procedure":"","LineNumber":1,"Errors":[{"Class":14,"Number":2601,"State":1,"Message":"Cannot insert duplicate key row in object 'dbo.FINANCIALREPORTS' with unique index 'I_11314FOLDERREPORTNAME'. The duplicate key value is (5637144576, BW1, Default Report Definitions, 12 Month Rolling Single Column Income Statement - Default).","Procedure":"","LineNumber":1,"Source":".Net SqlClient Data Provider"},{"Class":0,"Number":3621,"State":0,"Message":"The statement has been terminated.","Procedure":"","LineNumber":1,"Source":".Net SqlClient Data Provider"}],"ConnectionId":"xxxxxxx","Source":".Net SqlClient Data Provider"}
Machine: xxxxxx
Event Xml:
<Event xmlns="">schemas.microsoft.com/.../event">
<System>
<Provider Name="Management Reporter 2012 Services" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2020-02-26T11:32:26.782321700Z" />
<EventRecordID>81675</EventRecordID>
<Channel>Application</Channel>
<Computer>xxxxxxx</Computer>
<Security />
</System>
<EventData>
<Data> {"Class":14,"Number":2601,"State":1,"Message":"Cannot insert duplicate key row in object 'dbo.FINANCIALREPORTS' with unique index 'I_11314FOLDERREPORTNAME'. The duplicate key value is (5637144576, BW1, Default Report Definitions, 12 Month Rolling Single Column Income Statement - Default).\u000d\u000aThe statement has been terminated.","ErrorCode":-2146232060,"Procedure":"","LineNumber":1,"Errors":[{"Class":14,"Number":2601,"State":1,"Message":"Cannot insert duplicate key row in object 'dbo.FINANCIALREPORTS' with unique index 'I_11314FOLDERREPORTNAME'. The duplicate key value is (5637144576, BW1, Default Report Definitions, 12 Month Rolling Single Column Income Statement - Default).","Procedure":"","LineNumber":1,"Source":".Net SqlClient Data Provider"},{"Class":0,"Number":3621,"State":0,"Message":"The statement has been terminated.","Procedure":"","LineNumber":1,"Source":".Net SqlClient Data Provider"}],"ConnectionId":"xxxxxxxxx","Source":".Net SqlClient Data Provider"}
Machine: xxxxxxx</Data>
</EventData>
</Event>
I don't understand how reporting services can complain about a duplicate record? (Yes the DB synchronizes successfully.)
I just want to dev
