I am in the process of creating a Dynamic CI Group for Change Management purposes. I have created a CMDB group, and while attempting to define a new Dynamic CI Group, I encountered the following error:
“Invalid insert. Service with SN App Service ID: SNSVC0001038 already exists.”
I would appreciate any insights into the root cause of this issue and guidance on how to resolve it. Specifically, I am trying to understand if this is related to a conflict with an existing service in the CMDB or a configuration constraint within the Dynamic CI Group setup.
Has anyone else experienced a similar issue, or can someone provide clarity on how this validation works?
Hello @lvenna ,
It seems that there is already an existing Service in your CMDB with that number. A Dynamic CI Group is a Service as well (its table name is cmdb_ci_query_based_service).
Please verify by going to the cmdb_ci_service_auto table (might be called "Application Service" or "Service Instance" depending on your ServiceNow release) and adding the Number column to the list. Is there already a record with Number = SNSVC0001038?
If so then the number counter needs to be adjusted. Please sort the above list by Number and take note of the largest Number. Then navigate to System Definition > Number Maintenance and open the configuration for Prefix "SNSVC". In that form, click Show Counter.
Finally, update the Number field to the largest Number you found in the service table.
The next time someone creates a Dynamic CI Group the system will increase that counter and assign it to the CI, ensuring that it is available.
Regards,
Robert
Hello @lvenna ,
It seems that there is already an existing Service in your CMDB with that number. A Dynamic CI Group is a Service as well (its table name is cmdb_ci_query_based_service).
Please verify by going to the cmdb_ci_service_auto table (might be called "Application Service" or "Service Instance" depending on your ServiceNow release) and adding the Number column to the list. Is there already a record with Number = SNSVC0001038?
If so then the number counter needs to be adjusted. Please sort the above list by Number and take note of the largest Number. Then navigate to System Definition > Number Maintenance and open the configuration for Prefix "SNSVC". In that form, click Show Counter.
Finally, update the Number field to the largest Number you found in the service table.
The next time someone creates a Dynamic CI Group the system will increase that counter and assign it to the CI, ensuring that it is available.
Regards,
Robert
