Highlighted
Super Contributor.. Super Contributor..
Super Contributor..
87 views

How to migrate TQL models from test to production?

I have two ucmdb systems (1) test (2) production

 

I have created a TQL enrichment that I would like to move from the test to production system.

 

When I try to export from the test system and import into production it fails because the IDs are not the same.

 

 

0 Likes
4 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: How to migrate TQL models from test to production?

Hello,

Could you share the exact error you are encountering and the log which contains it?
0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: How to migrate TQL models from test to production?

Here is a sampe of the the xml i am trying to move:

 

<?xml version="1.0"?>
-<enrichment><version>10.01</version><displayInUI>true</displayInUI>-<resourceBundles><resourceBundle>UCMDB</resourceBundle></resourceBundles>-<CmdbGraph>-<Objects>-<CmdbObject><ID>31b7c8d85f02c9751f15141904269ac6</ID><Type>EnrichmentDefinitionImpl</Type>-<Properties>-<CmdbProperty><Key>index</Key><Type>integer</Type><Value>0</Value></CmdbProperty>-<CmdbProperty><Key>enrichmentName</Key><Type>string</Type><Value>ER7 - 'As Is' CI Replication to 'To Be' CI</Value></CmdbProperty>-<CmdbProperty><Key>originalPatternId</Key><Type>string</Type><Value>ER7 - 'As Is' CI Replication to 'To Be' CI</Value></CmdbProperty>-<CmdbProperty><Key>isActive</Key><Type>boolean</Type><Value>false</Value></CmdbProperty>-<CmdbProperty><Key>description</Key><Type>string</Type><Value>'As Is' CI Replication to 'To Be' CI</Value></CmdbProperty>-<CmdbProperty><Key>isCalculated</Key><Type>boolean</Type><Value>false</Value></CmdbProperty>-<CmdbProperty><Key>enrichmentType</Key><Type>integer</Type><Value>1</Value></CmdbProperty></Properties></CmdbObject>-<CmdbObject><ID>d176ff03f1ed8950d737a2eedb861550</ID><Type>EnrichmentLinkImpl</Type>-<Properties>-<CmdbProperty><Key>nodeNumberEnd1</Key><Type>integer</Type><Value>-13</Value></CmdbProperty>-<CmdbProperty><Key>nodeNumberEnd2</Key><Type>integer</Type><Value>-15</Value></CmdbProperty>-<CmdbProperty><Key>index</Key><Type>integer</Type><Value>0</Value></CmdbProperty>-<CmdbProperty><Key>action</Key><Type>string</Type><Value>CREATE ACTION</Value></CmdbProperty>-<CmdbProperty><Key>nodeNumber</Key><Type>integer</Type><Value>10</Value></CmdbProperty>-<CmdbProperty><Key>className</Key><Type>string</Type><Value>containment</Value></CmdbProperty></Properties></CmdbObject>-<CmdbObject><ID>cd6d294082f67d629b1f8cc43830a1a0</ID><Type>EnrichmentActionsImpl</Type><Properties/></CmdbObject>-<CmdbObject><ID>a4a15a82ba6607d610c1bcaf90c5c685</ID><Type>EnrichmentAttributesImpl</Type><Properties/></CmdbObject></Objects>-<Links>-<CmdbLink><ID>2b1ec26446e86cbfe31f84a84fb64521</ID><Type>cmdb_configuration_links</Type><End1>31b7c8d85f02c9751f15141904269ac6</End1><End2>cd6d294082f67d629b1f8cc43830a1a0</End2><Properties/></CmdbLink>-<CmdbLink><ID>e655982940f54282360650353870fd91</ID><Type>cmdb_configuration_links</Type><End1>cd6d294082f67d629b1f8cc43830a1a0</End1><End2>d176ff03f1ed8950d737a2eedb861550</End2><Properties/></CmdbLink>-<CmdbLink><ID>c7c4859f02508919a8f5c0b00b091815</ID><Type>cmdb_configuration_links</Type><End1>d176ff03f1ed8950d737a2eedb861550</End1><End2>a4a15a82ba6607d610c1bcaf90c5c685</End2><Properties/></CmdbLink></Links></CmdbGraph></enrichment>

 

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: How to migrate TQL models from test to production?

on the production server when trying to import get and error "Import Failed"

0 Likes
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: How to migrate TQL models from test to production?

There is not enough information to answer your question.

As genral guidelines, please check following:

- class model is in sync between two systems; at least production has classes you're using in TQL both as nodes and conditions

- enrichment consist of two elements - TQL and enrichment definition. Both should be in the same package.

- you are able to create new CIs on production.

Hope this helps.

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.