SteveJM Posted October 12, 2023 Share Posted October 12, 2023 I am running asset_import.exe, it is 'working' (uploading the assets correctly) - no errors on screen, BUT I am seeing an error in the .log file: 2023/10/12 16:27:31 [ERROR] Unable to run Query [getUserAccountsList] You need the right 'sys.a.manageUsers' in order to invoke the query: getUserAccountsList I am importing a CSV, C:\Asset_Import> asset_import.exe -file=conf_example_csv2.json ---- XMLMC Database Asset Import Asset_Import_20231012162728_0.logv4.1.1 ---- [DEBUG] Flag - Config File conf_example_csv2.json [DEBUG] Flag - Dry Run false [DEBUG] Flag - Concurrent 1 [MESSAGE] Successfully decrypted Hornbill instance authentication information Current binary is the latest version: 4.1.1 Caching User Records from Hornbill... 0 / ? [---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------=] 0s Accounts LoadedAsset_Import_20231012162728_0.log [ See Attached full transcript and Log] Do I need an extra permissions on my login account? Link to comment Share on other sites More sharing options...
SteveJM Posted October 12, 2023 Author Share Posted October 12, 2023 Log file attached Asset_Import_20231012162728_0.log Link to comment Share on other sites More sharing options...
Victor Posted October 12, 2023 Share Posted October 12, 2023 Unable to run Query [getUserAccountsList] You need the right 'sys.a.manageUsers' in order to invoke the query: getUserAccountsList Have a look if your user has the "Hornbill Service Manager Integrations" role. Link to comment Share on other sites More sharing options...
Archana Posted November 15, 2023 Share Posted November 15, 2023 I have tried a dry run for asset_import.exe v4.2.2 and received the same error in log file. But the records processed and import completed without any other error. And the the user I used is having "Hornbill Service Manager Integrations" role. Link to comment Share on other sites More sharing options...
Victor Posted November 17, 2023 Share Posted November 17, 2023 @Archana create a custom role as follows: Details: System Rights: Assign this role to the user that does the import and try the import again. Link to comment Share on other sites More sharing options...
Archana Posted December 13, 2023 Share Posted December 13, 2023 @Victor It worked after creating custom role as you mentioned. Thank you for the help. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now