[Asset Import Tool]

Hello,

I'm having some issues with the asset import tool, the log states its complaining about unable to lookup a customer. I'm striped my json file down to bare minimal first removing anything that suggests it would look up a customer and then hard coded a customer in but i keep getting the same error.

Is there a default field that must be filled in that i'm missing?

 

 "AssetGenericFieldMapping": {
        "h_name": "[h_name]",
        "h_site": "[h_site]",
        "h_asset_tag": "[h_asset_tag]",
        "h_created_date": "[h_created_date]",
        "h_description": "[h_description]",
        "h_last_updated_by": "Admin",
        "h_owned_by": "Admin"

    },
    "AssetTypeFieldMapping": {
        "h_name": "[h_name]",
        "h_average_pages_per_minute": "[h_average_pages_per_minute]",
        "h_description": "[h_description]"
    }

 

Create Asset: 17687
2019/09/19 14:07:52 [ERROR] Unable to Search for Customer [<nil>]: FlowCode Exception (com.hornbill.servicemanager/flowcode/fc_ops/shrGetCustomerDetails): nodeName: API Call: userProfileGet; nodeId: 3e1a9a7d-45ca-4e80-ae16-3a473865b996; At 182/1: "Uncaught EspMethodCall::invoke: Operation[session::userProfileGet] The value in element <userId> did not meet the required input pattern constraints. at location '/methodCall/params/userId'"
    throw(e);
_fc_node_exec_3e1a9a7d_45ca_4e80_ae16_3a473865b996
2019/09/19 14:07:52 [DEBUG] API XML: <params><customerId>&lt;nil&gt;</customerId><customerType>0</customerType></params>
2019/09/19 14:07:52 [ERROR] Unable to Search for Customer [<nil>]: FlowCode Exception (com.hornbill.servicemanager/flowcode/fc_ops/shrGetCustomerDetails): nodeName: API Call: userProfileGet; nodeId: 3e1a9a7d-45ca-4e80-ae16-3a473865b996; At 182/1: "Uncaught EspMethodCall::invoke: Operation[session::userProfileGet] The value in element <userId> did not meet the required input pattern constraints. at location '/methodCall/params/userId'"
    throw(e);
_fc_node_exec_3e1a9a7d_45ca_4e80_ae16_3a473865b996
2019/09/19 14:07:52 [DEBUG] API XML: <params><customerId>&lt;nil&gt;</customerId><customerType>0</customerType></params>
2019/09/19 14:07:52 [DEBUG] Asset Create XML <params><application>com.hornbill.servicemanager</application><entity>Asset</entity><returnModifiedData>true</returnModifiedData><primaryEntityData><record><h_class>printer</h_class><h_type>40</h_type><h_last_updated>2019-09-19 14:07:51+01:00</h_last_updated><h_last_updated_by>Import - Add</h_last_updated_by><h_created_date>2018-08-24 12:56:01</h_created_date><h_description>Epson Printer</h_description><h_last_updated_by>Admin</h_last_updated_by><h_owned_by>urn:sys:0:System Administrator:Admin</h_owned_by><h_owned_by_name>System Administrator</h_owned_by_name><h_name>17687</h_name></record></primaryEntityData><relatedEntityData><relationshipName>AssetClass</relationshipName><entityAction>insert</entityAction><record><h_type>40</h_type><h_name>17687</h_name><h_description>Epson Printer</h_description></record></relatedEntityData></params>
2019/09/19 14:07:52 [DEBUG] Create Asset: 17688
2019/09/19 14:07:53 [ERROR] Unable to Search for Customer [<nil>]: FlowCode Exception (com.hornbill.servicemanager/flowcode/fc_ops/shrGetCustomerDetails): nodeName: API Call: userProfileGet; nodeId: 3e1a9a7d-45ca-4e80-ae16-3a473865b996; At 182/1: "Uncaught EspMethodCall::invoke: Operation[session::userProfileGet] The value in element <userId> did not meet the required input pattern constraints. at location '/methodCall/params/userId'"
    throw(e);
_fc_node_exec_3e1a9a7d_45ca_4e80_ae16_3a473865b996
2019/09/19 14:07:53 [DEBUG] API XML: <params><customerId>&lt;nil&gt;</customerId><customerType>0</customerType></params>
2019/09/19 14:07:53 [ERROR] Unable to Search for Customer [<nil>]: FlowCode Exception (com.hornbill.servicemanager/flowcode/fc_ops/shrGetCustomerDetails): nodeName: API Call: userProfileGet; nodeId: 3e1a9a7d-45ca-4e80-ae16-3a473865b996; At 182/1: "Uncaught EspMethodCall::invoke: Operation[session::userProfileGet] The value in element <userId> did not meet the required input pattern constraints. at location '/methodCall/params/userId'"
    throw(e);
_fc_node_exec_3e1a9a7d_45ca_4e80_ae16_3a473865b996
2019/09/19 14:07:53 [DEBUG] API XML: <params><customerId>&lt;nil&gt;</customerId><customerType>0</customerType></params>
2019/09/19 14:07:53 [DEBUG] Asset Create XML <params><application>com.hornbill.servicemanager</application><entity>Asset</entity><returnModifiedData>true</returnModifiedData><primaryEntityData><record><h_class>printer</h_class><h_type>40</h_type><h_last_updated>2019-09-19 14:07:51+01:00</h_last_updated><h_last_updated_by>Import - Add</h_last_updated_by><h_description>Epson Printer</h_description><h_last_updated_by>Admin</h_last_updated_by><h_owned_by>urn:sys:0:System Administrator:Admin</h_owned_by><h_owned_by_name>System Administrator</h_owned_by_name><h_name>17688</h_name><h_created_date>2018-08-24 12:56:01</h_created_date></record></primaryEntityData><relatedEntityData><relationshipName>AssetClass</relationshipName><entityAction>insert</entityAction><record><h_type>40</h_type><h_name>17688</h_name><h_description>Epson Printer</h_description></record></relatedEntityData></params>
2019/09/19 14:07:53 [DEBUG] Create Asset: 18809
2019/09/19 14:07:53 [ERROR] Unable to Search for Customer [<nil>]: FlowCode Exception (com.hornbill.servicemanager/flowcode/fc_ops/shrGetCustomerDetails): nodeName: API Call: userProfileGet; nodeId: 3e1a9a7d-45ca-4e80-ae16-3a473865b996; At 182/1: "Uncaught EspMethodCall::invoke: Operation[session::userProfileGet] The value in element <userId> did not meet the required input pattern constraints. at location '/methodCall/params/userId'"
    throw(e);
_fc_node_exec_3e1a9a7d_45ca_4e80_ae16_3a473865b996
2019/09/19 14:07:53 [DEBUG] API XML: <params><customerId>&lt;nil&gt;</customerId><customerType>0</customerType></params>
2019/09/19 14:07:54 [ERROR] Unable to Search for Customer [<nil>]: FlowCode Exception (com.hornbill.servicemanager/flowcode/fc_ops/shrGetCustomerDetails): nodeName: API Call: userProfileGet; nodeId: 3e1a9a7d-45ca-4e80-ae16-3a473865b996; At 182/1: "Uncaught EspMethodCall::invoke: Operation[session::userProfileGet] The value in element <userId> did not meet the required input pattern constraints. at location '/methodCall/params/userId'"
    throw(e);
_fc_node_exec_3e1a9a7d_45ca_4e80_ae16_3a473865b996
2019/09/19 14:07:54 [DEBUG] API XML: <params><customerId>&lt;nil&gt;</customerId><customerType>0</customerType></params>
2019/09/19 14:07:54 [DEBUG] Asset Create XML <params><application>com.hornbill.servicemanager</application><entity>Asset</entity><returnModifiedData>true</returnModifiedData><primaryEntityData><record><h_class>printer</h_class><h_type>40</h_type><h_last_updated>2019-09-19 14:07:51+01:00</h_last_updated><h_last_updated_by>Import - Add</h_last_updated_by><h_created_date>2018-08-24 12:56:02</h_created_date><h_description>Dot Martix Printer</h_description><h_last_updated_by>Admin</h_last_updated_by><h_owned_by>urn:sys:0:System Administrator:Admin</h_owned_by><h_owned_by_name>System Administrator</h_owned_by_name><h_name>18809</h_name></record></primaryEntityData><relatedEntityData><relationshipName>AssetClass</relationshipName><entityAction>insert</entityAction><record><h_type>40</h_type><h_name>18809</h_name><h_description>Dot Martix Printer</h_description></record></relatedEntityData></params>
 

[Add Connections based on certain criteria / bulk email connections]

Hello,

Is there a way we i can add a list of people against a service ie impacted and interested so that i can make a generic BPM that would then add those people as connectors against the ticket when raised?

Many Thanks

 

Jo 

 

[Email Notification]

brilliant, do you have a estimate time when this will be available, trying to work out if i should tweak my processes to send email depending on team or wait for the new feature

 

cheers

[Email Notification]

Hello,

 

We have turned off email notification to our analysts as a few of the teams were getting bombarding with emails but there are a few other team who don't that many calls who want to receive the email alerts.

 

Is there anything that can be done to select which teams receive the email notifications?

Many Thanks

 

Jo

[Resolution Fix Date on Portal]

Hello,

 

Is there a setting that i can turn on which will show the resolution date in the customer portal?

 

Many Thanks

 

Jo 

[Hornbill Export Tool]

That worked, thanks for the quick turnaround

[Hornbill Export Tool]

Hello,

I'm trying to use the hornbill export tool but getting some issues. Which i believe is to do with the spaces in my column names.

If my config file looks like

ReportID":4,
            "ReportName":"JBURR Test3",
            "DeleteReportInstance": true,
            "DeleteReportLocalFile": true,
            "Table":{
                "TableName":"Requests2",
                "PrimaryKey":"Request ID",
                "Mapping":{
                    "Request ID":"Request ID",
                    "Date Logged":"Date Logged",
                    "Summary":"Summary"
                }
            }

 

I get the following error

[DATABASE] Connection Successful
2019/03/18 08:20:12 [DATABASE] Query:INSERT INTO Requests2 (Request ID, Date Logged, Summary) VALUES (:Request ID, :Date Logged, :Summary) 
2019/03/18 08:20:12 [DATABASE] Binding:
2019/03/18 08:20:12 [DATABASE] :Date Logged = 2019-01-11 20:19:31
2019/03/18 08:20:12 [DATABASE] :Summary = Service is unavailable
2019/03/18 08:20:12 [DATABASE] :Request ID = IN00000002
2019/03/18 08:20:12 [ERROR]  [DATABASE] NamedExec Error: could not find name Request in map[string]interface {}{"Request ID":"IN00000002", "Date Logged":"2019-01-11 20:19:31", "Summary":"Service is unavailable"}

 

but if i add [] to accommodate for the spaces

 

"Reports":[
        {
            "ReportID":4,
            "ReportName":"JBURR Test3",
            "DeleteReportInstance": true,
            "DeleteReportLocalFile": true,
            "Table":{
                "TableName":"Requests2",
                "PrimaryKey":"[Request ID]",
                "Mapping":{
                    "[Request ID]":"Request ID",
                    "[Date Logged]":"Date Logged",
                    "[Summary]":"Summary"
                }
            }
        }

 

i get

 

[DATABASE] Connection Successful
2019/03/18 08:21:56 [ERROR] Unable to map any values from the returned record:
2019/03/18 08:21:56 [RECORD] {"Actions Control":"","Activity Stream ID":"urn:buzz:activityStream:e03ec7ac-614f-45a7-8f0e-0798c1a48ad7","Archived":"Yes","BPM Activity Update ID":"","BPM ID":"BPM20190111000001","BPM Stage Expired":"No","BPM UI state":"","BPM authorised":"0","Call Back Date":"","Cancellation Reason":"Created In Error","Catalog":"Apply For A Design","Catalog ID":"29","Category ID":"","Category Name":"","Closed By Team":"","Closed By Team ID":"","Closed By User ID":"","Closed By Username":"","Closure Category ID":"","Closure Category Name":"","Company":"","Company ID":"","Created by":"admin","Custom 21":"","Custom 22":"","Custom 23":"","Custom 24":"","Custom 25":"","Custom 26":"","Custom 27":"","Custom 28":"","Custom 29":"","Custom 30":"","Custom A":"","Custom B":"","Custom C":"","Custom D":"","Custom E":"","Custom F":"","Custom G":"","Custom H":"","Custom I":"","Custom J":"","Custom K":"","Custom L":"","Custom M":"","Custom N":"","Custom O":"","Custom P":"","Custom Q":"","Custom R":"","Custom S":"","Custom T":"","Customer ID":"admin","Customer Name":"System Administrator","Customer Organization Container ID":"","Customer type":"0","Date Closed":"2019-01-13 20:15:54","Date Logged":"2019-01-11 20:19:31","Date Modified":"2019-01-13 20:15:55","Date Placed On Hold":"","Date Resolved":"","Description":"","External Reference Number":"","Feedback Status":"awaiting","Feedback Status ID":"0","First Time Fix":"","Freetext Search Index":"lid_35c613c9-f899-4ccc-bcde-48c6598496a4","Historic Request":"","Image":"","Impact":"","Impact Id":"","Is Analyst Unread":"1","Is Customer Unread":"","Last Date an email was sent from the request details":"","Last Update Activity ID":"urn:buzz:activity:acc43ab9-0dd1-46b6-83b8-b0e6de847257","Locked":"Unlocked","On Hold Until":"","Priority ID":"5","Priority Name":"Priority 2","Profile Code":"","Rating":"","Related Activity ID":"","Reopen Date":"","Reopened By Team":"","Reopened By Team ID":"","Reopened By User ID":"","Reopened By Username":"","Reopened Count":"0","Request ID":"IN00000002","Request Language":"en-GB","Request Owner ID":"","Request Owner Name":"","Request Owner Type":"","Request Prefix":"IN","Request Resolution Timer ID":"","Request Resolve By":"","Request Resolve Seconds":"","Request Resolve Time":"","Request Respond By":"","Request Response Seconds":"","Request Response Time":"","Request Response Timer ID":"","Request Total Onhold Time":"","Request Type":"Incident","Resolution":"","Resolved By Team":"","Resolved By Team ID":"","Resolved By User ID":"","Resolved By Username":"","Service ID":"23","Service Level Agreement ID":"","Service Level Agreement Name":"","Service Level Changed":"","Service Level Date Changed":"","Service Level ID":"","Service Level Name":"","Service Name":"Apply for a Design","Site":"Concept House","Site ID":"1","Social Object Ref":"urn:sys:entity:com.hornbill.servicemanager:Requests:IN00000002","Social Object URN":"urn:sys:user:admin","Source ID":"admin","Source Type":"Self Service","Status":"status.cancelled","Sub-status Id":"","Sub-status Text":"","Summary":"Service is unavailable","Team ID":"IPO/IT/OPS/APPSL2/","Team Name":"L2 Applications","Urgency":"","Within Resolve Time":"","Within Response Time":"","h_itsm_requests Organisation Id":"0"}
2019/03/18 08:21:56 [MAPPINGS] {"[Date Logged]":"Date Logged","[Request ID]":"Request ID","[Summary]":"Summary"}

 

any help would be appreciated

 

Cheers Jo

 

 

 

[iBridge for link document]

This worked, many thanks.

 

Is there anything in the roadmap to allow me to use a dropdown / or search in the prog capture to search for a document based on tags etc.

At the moment i intend on using a simple list and put the docid in as a value so i can auto link it, but obviously this will at some point become unmanageable.

 

Many Thanks

 

Jo

[Assign to Requester Team]

Hello,

 

I will like to auto assign a call to the team of who even requested it but i get an error, not sure if i'm putting it in correctly. 

I would be grateful for some help

 

[iBridge for link document]

I would be grateful for some help with this

Many Thanks

 

Jo

[iBridge for link document]

Hello,

I have only used this and the azure devops one so far. 

Many Thanks

Jo

[Assets Database]

Hello,

I'm trying to export the h_cmbd_assets so i can import into an SQL database so that going forward my discovery tools can auto update the SQL database and then I use the import tool exe tool to update the hornbill CMDB

 

I know there is a 10k limit and i have roughly 16k in there so thought i would split the export, but there seems to be an issue with the primary key. Even ordering by the PK does seem to work, have attached ss and you can see that asset 999 appears in the middle of the higher numbers.

.

 

 

would be very grateful for a response.

 

[iBridge for link document]

is anyone able to help with this

 

Many Thanks

 

Jo

[iBridge for link document]

Hello,

 

Do you have any examples of this, i keep getting this error - iBridge Method: /Hornbill/Docmanager/Link Document.m Error: SyntaxError: Unexpected token < in JSON at position 1

[iBridge for link document]

Hi,

 

I'm trying to use the iBridge link document but not sure what i should be putting in the following params:-

• Application
• Entity
• Entity id

 

Can anyone help with this

 

Many Thanks

Jo

[Document Manager - Ability to add and remove permission to document/library via BPM]

is this still in the pipeline?

 

Many Thanks

 

Jo

[BP error: Cannot acquire assignees array for dynamic approval]

Sorry, I'm struggling to understand this, do you have 30 min free tomorrow morning to discuss, while i don't yet have a support contact i do have hours left in my SOW that we can dip into

 

Many Thanks

Jo 

[BP error: Cannot acquire assignees array for dynamic approval]

Hi Victor,

 

I'm very confused,  there has been no change to the processes and as of yesterday my users can raise call and the BPM would automatically get users from a group and create an activities, so i'm not trying to do anything different form yesterday.

When all of my IT staff create a change request the BPM is failing here, and i don't understand what has changed (it maybe something that we have changed here), but more important i do not know how to fix this issue

Is it possible to have a telephone conversation

Many Thanks

 

Jo 

[BP error: Cannot acquire assignees array for dynamic approval]

the next step in my BPM is to get a list of people and assigned a task to them to authorise

 

cheers

 

jo 

[BP error: Cannot acquire assignees array for dynamic approval]

Yes, i have restarted the processes.

 

Can you you let me know what rights they would need? is is a particular role

 

Many Thanks

Jo

[BP error: Cannot acquire assignees array for dynamic approval]

Has any updates been made as we haven't made any changes.

Do you want access they would need to be granted so i can see they permissions have been changed

Thanks for looking at this

Jo

[BP error: Cannot acquire assignees array for dynamic approval]

hello,

 

i am seeing this on our live BPM processes - Cannot acquire assignees array for dynamic approval (global.flowcode.authAutoAssignees)

 

I cant see there is anything wrong with the processes and it hasn't been changes

 

Can this be looked at urgently please

 

Many Thanks

 

Jo

[Impact and Urgency Progressive Capture forms]

Is there any particular field i need to update with the results of my impact / risk for it to show the impact in the right hand side of the change ticket

Cheers

 

Jo

[Impact and Urgency Progressive Capture forms]

Do we have any update on this. I can see the impact assessment feature can be done one the impact is raised but looking to do this more at the PCF level

Many Thanks

 

Jo

[How to create a Custom Field on requests]

Hello,

Can someone please guide me on how to create a custom field across all my calls (regardless or service and type)

 

Many Thanks

 

Jo