Analysis Failures

Follow

pamixon

• June 16, 2011 20:13

I keep get this error every time I try to setup activity. "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." Then the program automatically shuts down. Is there anything I can do to stop or fix this problem.

0

• 

  DougO

  • June 16, 2011 20:46

  Need a little more information. The error occurs when you press the "Setup Activity" menu item? Have you successfully created an activity before in this model? If you are creating an activity: Which activity type (eg, industry change)? What were you doing just before you received the error? The error message indicates that there is something in the event fields that the Access database can't handle.

  0

  Comment actions Permalink
• 

  pamixon

  • June 16, 2011 20:54

  The error occurs when I click the Setup activities or analyze activities (for the one that setup successfully) I ran one analysis and then this started happening. I have tried creating a different activity, new model and new region. I am creating a industry change. As soon as I try to analyze the activity this error window pops up, and then I cannot do anything else.

  0

  Comment actions Permalink
• 

  DougO

  • June 16, 2011 21:15

  Can I get you to run an update on your software (Help>Check for updates)? Make sure you have version 3.0.11.2 after you run the update (Help>About). Sometimes it appears to run but doesn't. Then try again (from creating a new model), apparently one update dealt with this (or similar) issue.

  0

  Comment actions Permalink
• 

  pamixon

  • June 16, 2011 21:29

  I was using 3.0.11.2. Same result. Even uninstalled and re-installed and re updated to 3.0.11.2. I have use a different industry and the problem did not occur. The problem seems to occur only with food service and drinking places (sector 411)

  0

  Comment actions Permalink
• 

  DougO

  • June 16, 2011 22:02

  Interesting. Please call in so a tech can look at your appliance and model. Call 651-439-4421 and select the option for "installation issues" and mention case number 334 to whomever answers.

  0

  Comment actions Permalink
• 

  ScottL

  • June 20, 2011 19:09

  The problem is that somehow the activityid code in the impactevent table is out of sync with the impactactivity table. I do not know why this occurs but I have seen it a few times. It would be useful to know the exact steps when the activities were created. Was there a copy/paste or was it simply entering an activity for sector 411? It would be helpful to know exactly what year and what data files are being used so the sequence of events can be duplicated to see if we can recreate the error here. I can't fix an error that I can't duplicate. The fact that he can use another industry without the issue is an important piece of information. EDIT - In one case its a bridging table that is out of sync. We are trying to duplicate the steps to create this.

  0

  Comment actions Permalink
• 

  ScottL

  • June 20, 2011 23:47

  And it was discovered that an apostrophe in the scenario name caused all the trouble. This has been fixed and will be in the next update.

  0

  Comment actions Permalink

Please sign in to leave a comment.