...
Service Catalog
Datatype is Hierarchical String.
Conditionally Required IF the Import is trying to INSERT a new record.
...
Dept. Hierarchy Owner
Datatype is Hierarchical String.
Only the Code From This Import expects the Dept. Hierarchy is expectedcode, not the Description.
Location
Datatype is Hierarchical String.
Conditionally Required if Status is Active AND if the Service Catalog flag Location Required is set.
...
The USE_RATING_GROUP Configuration flag is set to True.
SLA Catalog
Datatype is Hierarchical String.
Reference
Datatype is String.
...
GLAs added to a Service with the Service Import ONLY adds an association between the existing GLAs and the selected Service in the Import File. The Service Import cannot INSERT or UPDATE GLA records.
GLA
Datatype is Hierarchical String.
GLA must be the full GLA Path with all Components separated by the GLA_CONCATENATOR.
Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_SEPARATOR string.
The default value for this string is right angle-brace (>) with a space on either side: " > ".
When importing nested Locations, the separator you use for each level of the hierarchy must match the concatenator string.
...
.
GLA Expense Type
Conditionally Required if GLA is provided.
...
Equipment Location
Datatype is Hierarchical String.
The full Location Path hierarchy in a single string, with individual parts of the Location Hierarchy separated by the HIERARCHYPATH_CONCATENATOR.
Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_SEPARATOR string.
The default value for this string is right angle-brace (>) with a space on either side: " > ".
When importing nested Locations, the separator you use for each level of the hierarchy must match the concatenator string.
For example, Site A > Building B > Room C.
The Equipment Location value is used only with a non-blank Equipment ID. If a non-blank Equipment ID is not provided, then the Location value is ignored. You cannot lookup an Equipment with just a Location.
...
- True: Setting the flag to True appends Pools to matching Service ID Pools and does not clear any existing Pools.
- False: Setting the flag to False clears existing Pools on matching Service IDs and updates the Pool on the first instance of that Service. Any additional Service ID Pools are appended after the first instance.
Errors
There are a large number of possible errors for Imports. There are two types: errors that prevent the record from Importing and those that don't but cannot update related Import record information.
The following display if the Service INSERT or UPDATE fails:
...
When an Import Line fails, it is usually because the Line falls into one of the following categories:
The value provided from another table was not found or multiple matches found within the Database
Toggle cloak Cloak - Error : Found multiple existing Equipment with Serial Number '<serialNumber>'
- Error : Found multiple existing Equipment with MAC Address '<macAddress>'
- Error : Found multiple existing Equipment for Equipment ID '<equipmentId>'
- Error : Invalid Equipment RECID '<recid>'
- Error : Invalid Equipment MAC Address '<macAddress>'
- Error : Invalid Equipment Asset Tag '<asset>"
- Error : Invalid Equipment Location '<location>'
- Error : Invalid Equipment for Equipment ID '<equipmentId>'
- Error : Invalid Equipment Serial Number '<serialNumber>'
- Error : Invalid Service Pools '<service_pool>'
- Error : Invalid Billing Group '<BILLING_GROUP>'
- Error : Invalid Class Of Service '<class of service>'
- Error : Invalid GLA '<gla>'
- Error : Invalid Service Host '<SERVICE_HOST>'
- Error : Invalid Location '<LOCATION>'
- Error : Invalid Service Catalog '<SERV_CATALOG>'
- Error : Invalid Contact '<OWNER_CONTACT>'
- Error : Invalid Dept Hierarchy '<OWNER_DEPT_HIERARCHY>'
The value provided from another table is Inactive
Toggle cloak Cloak - Error : Inactive Service Catalog '<SERV_CATALOG>'
A blank value was provided, for a field with a required value
Toggle cloak Cloak - Error : Missing Auth Code type for new Auth Code '<SERVICE_ID>'
- Error :
...
- Missing GLA
- Error : Missing GLA Expense Type
- Error : Missing GLA Percent
- Error : No Service Catalog Specified
- Error : No Status provided for new Service '<SERVICE_ID>'
The value provided is not acceptable for the record type being created
Toggle cloak Cloak - Error : Service <serviceId>, GLA type <expenseTypeListsRecid>, Percents add up to <sum> (should be 100)
- Error :
...
- This Equipment Catalog type is restricted from being on this Service Catalog type
- Error :
...
These messages are NOT indications that the Service INSERT or UPDATE to failed. The Service will INSERT or UPDATE. However, the subsequent Child record may have a warning generate and the child record is not added to the Service. They are non-essential for the Service or they happen after the Service save.
...
- Can't assign Equipment unless Service Status is Active or Suspend
- Error : Can't assign Equipment unless Equipment Status is Assigned
- Error : Provided Service Host not permitted for this service catalog
- Error : Provided Location not permitted for this Service Catalog
- Error : No Service ID Specified
The System was unable to save the record
Toggle cloak Cloak - Error : Failed to save Service record; <errorMessage>
- Error : Service <serviceId>, GLA type <expenseTypeListsRecid>; <errorMessage>
If you experience any of these Errors, without another accompanying Message about what might have caused the Save Failure, please submit a Ticket to PCR.
Notes
The ability to append Pools to a Service was added. The default behavior for adding Pools is to clear the Pool list for the first instance of a Service ID in the import file. Then, append to the Pool list for every instance of the Service ID after the first. This can be changed with the APPEND_POOLS flag as described in the Flags section.
...