Hello,
I have over 100 Software Policies to migrate to a new environment.
There are at least 50 packages per Software Policy which means manual creation or writing a script will take a substantial amount of time.
When I used the MDBAC for the export/import of the Software Policies it fails due to NULLs in the object permissions.
From the mdbac log file...
2016-03-03 11:47:00,594 INFO [importObjects] loading object permissions ...
2016-03-03 11:47:00,641 INFO [importObjects] object permissions loaded
2016-03-03 11:47:00,641 INFO [executePush] calling {call merge_swpolicy( ? )} with [38616235633861393533336439366663]
2016-03-03 11:47:00,688 ERROR [executePush] Cannot insert the value NULL into column 'object_def_uuid', table 'mdb.dbo.ca_object_ace'; column does not allow nulls. INSERT fails.
I attempted to remove entire sections from the exported xml file where <column name="ace">0</column> and attempted an import.
example:
</table>
<table class="ca.itcm.mdbac.api.pl.objects.Ca_object_ace" name="ca_object_ace">
<column name="security_profile_uuid">111111111111119b05a14e1d7a</column>
<column name="ace">0</column>
<column name="access">1</column>
<column name="object_def_uuid">222222222222222222a</column>
<column name="security_profile_name">x509cert://dsm r11/cn=dsm directory synchronisation,o=computer associates,c=us</column>
</table>
This still resulted in a failure.
Has anyone seen this before and provide input?
Thank you,
Jeff