No 'projectroleid' field for ProjectRoleActor

Question

Hi, I received following error message whileimporting project from one instance to another - "There was a problem parsing the backup XML file at : No 'projectroleid' field for ProjectRoleActor <28760>. Can you please suggest how to fix this and import the project successfully. Thanks a lot, Regds, Pawan

Yusuf TAMBAG · Answer

Nothing, it will just clean the zombie records from the projectroleactor table.

Utkarsh Agarwal_dxo2bp · Answer

What effect will this query have on the database?

We have a lot of entries when we run a select query

SELECT * FROM projectroleactor WHERE projectroleid IS null;

Before we run the delete query I want to know what can be the possible consequences.

Gregory Kneller · Answer

just run the following SQL over Jira database before generating your XML backup:

delete from ProjectRoleActor  where projectroleid is null;
commit;

No restart or reindex is required