asset_import.exe: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport

[SteveJM]

I am using asset_import.exe for the first time, I am testing with a small CSV file.

I couple of questions;
An API key has been created on the Hornbill Instance, However I don't have the KeySafeKeyID number
i.e. for use in the json file  "KeysafeKeyID": 1,

I have guessed, and put a "1" in there and it seems to work,
how can I confirm what the KeysafeKeyID number is

I received this error message on the first run:
[ERROR] Unable to count asset records: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport

Is this telling me my user permissions are wrong?
 

C:\Asset_Import>asset_import.exe -file=conf_example_csv2.json
---- XMLMC Database Asset Import Utility v4.1.1 ----
[DEBUG] Flag - Config File conf_example_csv2.json
[DEBUG] Flag - Dry Run false
[DEBUG] Flag - Concurrent 1
[INPUT] Enter your Instance ID:
aXXXXXXX
[INPUT] Enter the API Key:
API Key: ded**************************c75
[MESSAGE] Successfully encrypted Hornbill instance authentication details against the local user and computer
Current binary is the latest version: 4.1.1
Caching Application Records from Hornbill...
Running CSV query for Desktop assets. Please wait...
2 of 3 returned assets successfully retrieved ready for processing.
Caching Desktop Asset Records from Hornbill...
[ERROR] Unable to count asset records: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport

-=-=-= Summary =-=-=-
Created: 0
Create Skipped: 0
Create Failed: 0
Updated: 0
Update Skipped: 0
Update Failed: 0
Update Extended Record Skipped: 0
Update Extended Record Failed: 0
Assets Software Inventory Skipped: 0
Software Records Created: 0
Software Records Create Failed: 0
Software Records Removed: 0
Software Records Removal Failed: 0
Asset Supplier Associations Success: 0
Asset Supplier Associations Failed: 0
Asset Supplier Associations Skipped: 0
Asset Supplier Contract Associations Success: 0
Asset Supplier Contract Associations Failed: 0
Asset Supplier Contract Associations Skipped: 0
Time Taken: 56s
---- XMLMC Database Asset Import Complete ----

 

 

 

 

 

[SteveJM]

So the getAssetsListForImport Stored Query exists, what permissions do I need to run/execute it?

 

 

[Steve G]

Hi @SteveJM,

The role you need is Hornbill Service Manager Integrations. It appears that this role was missed from the Data Import Guides, I'll get that corrected.

Re: the KeySafe Key ID, as per the documentation, if you're importing from CSV files then KeySafe is not used and the value should be 0 or the property can be removed entirely from the configuration:

Thanks,

Steve

[SteveJM]

Thank you