Rally DataBase Connector is receiving the following error : Unable to populate table Story

Products

• Rally On-Premise
• Rally SaaS

Issue/Introduction

Rally DB Connector:Unable to populate table Story

I am suddenly getting the error when running the Rally DB connector: 

Unable to populate table Story, new row for relation "story" violates check constraint "story_schedulestate_check" 

Environment

Release:
Component: ACSAAS

Cause

This was caused by a configuration issue that stems from trying to pull a Project Entity and ask for the Project Oid to populate for several Projects. This is causing conflicts in the connector. 

Resolution

To pull all Projects for a Workspace we recommend using a config just for projects (ie project1.yml) then commenting out the Projects tag. Example below: 

Workspaces: 
- Workspace: Exampletest4 # currently only one workspace is supported 
# Projects: 
# - Project2 
Entities : Project 
Fetch : ObjectID,Name 
Selectors : 

Since Project Entity is very different in what fields can be pulled, I would always run Project Entity separately from other types of Entities.