Forum Discussion
Scorecard Refresh Failure - Duplicate 'Id' in 'Values' table
Hi SimpsonDM -
Unfortunately, I ended up having to re-make the entire scorecard. We were still early in the deployment, so we didn't loose anything other than a few hrs of work. Very frustrating. However, we have been running for several weeks now w/o issue. We were creating goals manually, rather than via API.
I've at least figured out what the issue was
When you create a goal without an initial value, the service seems to add a record to the values table with a blank id. If you add a second goal, also without a value, then it throws the error above (duplicate value '<pii></pii>')
To get around this, once I created the goals I added an initial check in for some time in the past that would be outside of my current date range (01/01/2000). Once this check in was added for all goals, I was able to refresh the dataset without issue.