AnsweredAssumed Answered

Kreporter Core install fails on MS SQL Server 2008 R2

Question asked by leobor on Jul 5, 2015
I am struggling with installing Kreporter 3.1.0 on Sugar 6.5 CE with MS SQL Server 2008 R2 as database backend. Getting error when installing Core package:

Error creating indexes Query Failed:ALTER TABLE kreportsnapshotsdata ADD CONSTRAINT snapshot_data PRIMARY KEY (snapshot_id,record_id)::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'kreportsnapshotsdata'. 

Not sure how to overcome - any suggestion would help.

Outcomes