The error is pretty clear - Jira needs to create tables for Active Objects, and the database account you have configured it with does not have the required rights to create the tables in the database.
Correct the permissions in the database and try it again.
The big issue with using Jira Clone command, is the old issue being cloned must fully align with the current workflow and field schema. If the workflow was physically change (statuses removed or added) or fields were removed or added since the old issue was created then the clone will failed. As well, I believe this is your situation, if you are trying to clone an issue that you didn't initially report then it will fail as well. It all depends on how open your Jira permissions scheme is setup for.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG