Groupcodes Error When Importing Job


If you get an unhandled exception error such as the one below when importing a backup job into Cubit that has been provided by another user, then it is most likely that group code name used in the job already exists in your Cubit software.

Cubit Unhandled Exception Error:

System.Reflection.TargetInvocationException: An exception occurred during the operation, making the result invalid.  Check InnerException for exception details. ---> Npgsql.PostgresException: 23505: duplicate key value violates unique constraint "groupcodes_groupcode_key"

To resolve this you can do the following:

  1. Rename the duplicate code group in your software.
  2. Import the job. This will recreate the code group in the software with the appropriate ID in the data to prevent this issue recurring. However the code group that is created will be blank.
  3. Get a copy of the code group as a CSV file from the estimator that sent the job, and import this into the new code group on your system.

Once this has been done, any other jobs received from the second estimator using this code group will import without trouble.

If you continue to encounter trouble with this however, then it is recommended that you contact the support team, via email or phone, and we will help you resolve this issue.

The link below will take you directly to creating a new ticket with us.


0 out of 0 found this helpful


1 comment

Please sign in to leave a comment.