Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies replies
    2
  • Answers answer
    1
  • Subscribers subscribers
    4
  • Views views
    204
  • Users 0 members are here
Related
Options

Not able to insert new asset with existing model

Sridhara

Hi All,

Trying to insert new assets with existing model name through connect-it scenario which pulls data from UCMDB, but we are getting below error message. Can somebody help us to resolve this issue.

AssetCenter/Asset Manager' API error: 'ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.amModel' with unique index 'Model_FullName'. The duplicate key value is (/PowerEdge R620/). SQLSTate: 23000\nODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. SQLSTate: 01000\nIndex error: A record in table 'Models (amModel)' with the value '/PowerEdge R620/' for field 'Full name (FullName)' already exists in the database.'

Regards,

Sridhara.

Parents
  • 0

    Hopefully the CIT mapping branch for amModel reconciliation is not set to "Insert only".  Hopefully you are not mapping directly to the FullName field.  Hopefully the model already exists in AM (ie. not being created from CIT with commit every 100 records default).  You may want to contact OpenText Support.

Reply
  • 0

    Hopefully the CIT mapping branch for amModel reconciliation is not set to "Insert only".  Hopefully you are not mapping directly to the FullName field.  Hopefully the model already exists in AM (ie. not being created from CIT with commit every 100 records default).  You may want to contact OpenText Support.

Children
No Data

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.