I am also trying to achieve the same thing. Take backup from a server and restore it to another server. So could you please tell me the restore procedure you did? dropped and restored repository? and after that configured file share? Could you please help?
this is most likely caused by an incorrect ownership of the _locktable (and possibly few other ones). Following are steps on how to address this:
1. Execute the following query in order to find all the affected tables. Should you have other user than qliksenserepository please adopt the query accordingly. To find that out you can in example use the QlikSenseUtil.exe tool located in C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\. Use Connection String Editor tab, click on Read and check for "User ID" on "QSR" database.
select 'alter table "'|| tablename || '" owner to qliksenserepository;'
2. Copy the outcome, remove the surrounding double quotes, in example:
"alter table "_locktable" owner to qliksenserepository;"
alter table "_locktable" owner to qliksenserepository;