Problem after upgrade 3.2.2 to 3.2.13

[Francois Drouin]

Hi,

After upgrade, only membres of jira-administrators group can see the Scheduled Issue table in projects.

But, in add-on section, the entire section "The Scheduler" is missing. So I can't manage acces or export/import.

Nothing special in log.

Same behavior with 3.2.14-15

thx

[Ziniewicz Maciej]

Hi Francois,

Check "Project" section in administration menu there should be the options you are looking for. In add-on section these options are in versions 4.x and above.

Regards, Ziniewicz Maciej

[Francois Drouin]

Oh thx,

But where I can manage acces? i didn't find these options

[Ziniewicz Maciej]

You can manage access in section System->Security->Scheduled Issue.

[Francois Drouin]

Got it, but error 404!

[Francois Drouin]

Jira 6.4.12 with Scheduled 3.2.15

[Ziniewicz Maciej]

Could you send us full logs file from JIRA? on mail: [e-mail]

You can find information where are the JIRA logs here: https://confluence.atlassian.com/pages/viewpage.action?pageId=213526227

Regards

[Ziniewicz Maciej]

Thank you for logs. The solution is to drop constraint in database. Please check this issue: https://bitbucket.org/apdc/the-scheduler/issues/74/the-scheduler-not-start There you can find description of the problem with the solution.

Let us know if it fix your problem.

Regards

[Francois Drouin]

I deleted the result of the query.

There are no more result, but, same error.

[Ziniewicz Maciej]

I'm working on your problem and probably do not have a row in the table named AO_A406ED_ACC_MANAGER. Recently we released w new version of TSP for Jira 6.x you can update it and it should create this row automatically, or if not try to uninstall plugin and install it again.

If problem won't be solved, please check your AO_A406ED_ACC_MANAGER table using query : SELECT * FROM AO_A406ED_ACC_MANAGER and let us know what was the result.

Regards

[Francois Drouin]

I uninstalled 3.2.15 and install 3.2.16. Same error

[Ziniewicz Maciej]

Could you send us metadata from tables which The Scheduler uses? These tables starts by prefix AO_A406ED. There you can find some informations how to do that in OrlaceDB: https://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm#ADMQS256

If you send us logs with error please send full log.file becouse there can be more informations which may be useful.

[Francois Drouin]

Thx

[Ziniewicz Maciej]

Probably the problem is the null value in column PROJECT_ROLES in table, normally there should be an empty value. This bug will be fixed in next version. Meanwhile try this solution to set empty value in PROJECT_ROLES column using this query: UPDATE AO_A406ED_ACC_MANAGER SET PROJECT_ROLES='' WHERE ID='1';

Let us know if it helped. Regards!

[Francois Drouin]

In Oracle, "empty" and null its the same thing.

I updated with your query, but same result : null value in projet role.

[Ziniewicz Maciej]

You're right. So let's try another way. I see you're using SQL Developer, please try to change value in PROJECT_ROLES column on 'Administrators' by double click on cell, refresh row and save changes.

[Francois Drouin]

Same thing '' = null value

But with a space, it's working. Do you think its "safe" with a space?

[Ziniewicz Maciej]

Yes it's safe, but if you select one value from roles, and deselect it error will appear again becouse of this null in PROJECT_ROLES. Unfortunately one value have to be selected, or if you dont want to select any roles it has to be done like you just did. It will be fixed in next TSP version.

Regards, Ziniewicz Maciej

[Francois Drouin]

OK thx for your help!

[Ziniewicz Maciej]

No problem, anytime :)