SteveJM Posted October 12, 2023 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?
SteveJM Posted October 12, 2023 Author Posted October 12, 2023 Log file attached Asset_Import_20231012162728_0.log
Victor Posted October 12, 2023 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.
Archana Posted November 15, 2023 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.
Victor Posted November 17, 2023 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.
Archana Posted December 13, 2023 Posted December 13, 2023 @Victor It worked after creating custom role as you mentioned. Thank you for the help. 1
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