search

conveniencable / microsoft_project_connector

9 stars 3 forks source link

Error while merging or saving changes to redmine #31

Closed RAPGabs closed 1 week ago

RAPGabs commented 2 months ago

While loading or saving my mpp to redmine I am getting the following errors System.Runtime.InteropServices.COMException (0x800A044D): This is not a valid lookup table value. at Microsoft.Office.Interop.MSProject.Task.SetField(PjField FieldID, String Value) at NZWlJ1CpgZS1P1mL8N.KGWDAn8g69rVrNPiCT.O4RLxQ5DV(Task , IssueData ) at LLxRP2xauCrpLYgBJ8W.CELXZKxBtq4BTsp3HP4.gaEZoYUnlu(Object , Object , Int16 , Dictionary2 , Dictionary2 ) at LLxRP2xauCrpLYgBJ8W.CELXZKxBtq4BTsp3HP4.gaEZoYUnlu(Object , Object , Int16 , Dictionary2 , Dictionary2 ) at LLxRP2xauCrpLYgBJ8W.CELXZKxBtq4BTsp3HP4.Rc3Zyhsf2R(Object , Object ) at RedmineConnector.ScriptObject.xpOmdFiEJjDCPvqWPCb(Object , Object ) at RedmineConnector.ScriptObject.loadIssues(String jsonString, Boolean isMerge)

image

conveniencable commented 2 months ago

What's the version of MS Project? Can you take a screenshot to show the selected Redmine fields loading to MS Project?

RAPGabs commented 1 month ago

Hey Li,

I am using v2406. image

The following columns are being loaded in MSP. image

Note: If I uncheck "Target version" and then load/save everything works as intended. There is no error. But having it checked causes the error above. Target version being a mandatory field I cannot make tasks in Redmine.

conveniencable commented 1 month ago

Does the Text5 field has folumar validation?

RAPGabs commented 1 month ago

Yes, it is a mandatory field to make tasks. We have a dropdown; the same way we have dropdowns for "Status" or "Tracker".

image

conveniencable commented 1 month ago

What's you redmine version? This circumstance looks like some Redmine issues's using a missing target versoin which is not in the dropdown, but I don't know how to make it as the used target version couldn't be deleted. Could you try to use the NOT filter selecting all the availables target version to see if it can find some exception issues.

RAPGabs commented 1 month ago

Redmine version is 4.2 stable.

While filtering out tasks with no target version, i just get change requests.

Another observation: Even though I get errors when loading tasks with target version checked, I get target versions of other projects in the drop-down, sometimes even for those projects that I have access to.

Very weird.

conveniencable commented 1 month ago

Redmine version is 4.2 stable.

While filtering out tasks with no target version, i just get change requests.

Another observation: Even though I get errors when loading tasks with target version checked, I get target versions of other projects in the drop-down, sometimes even for those projects that I have access to.

Very weird.

I think the these issues with exception target version were created in another project, and then changed to this project later. So the solution is: change these issues to invalid target versions, it's quite easy by bulk operation in Redmine.

RAPGabs commented 1 month ago

Understood, I will check it out and revert back with my findings.

RAPGabs commented 7 hours ago

I think the these issues with exception target version were created in another project, and then changed to this project later. So the solution is: change these issues to invalid target versions, it's quite easy by bulk operation in Redmine.

I cloned the actual Redmine and set up a local version to try what you suggested with moving tickets from one project to another project that didn't have an error while synchronising. But couldn't replicate this.

The cause of the error is something different.

Even on the same Redmine setup with multiple projects, only some projects have this issue, while others don't.