Export a process model from dimensions 9 and attempting to create a base database in dim 10. expm from 9.1.3.7 crdb to Dim 10.1.0.1: SYSTEM> crdb payroll /toolman=dmsys /import=intermdt91.exp
At the moment it's not fully understood why this problem occurs with the EXPM command, and currently it's only been seen with the Dimensions CM 2009R2 release, but as a workaround you can substitute all occurrences of 2147483392 in the export file with NULL. You can then retry the CRDB operation and it should allow the new base database to be created successfully.
#1042497 - Error: failed to update database (unique constraint (,CPL_CATALOGUE_K1) violated) ... trying to update an item attribute on a copied database Creating a new database via CRDB from an existing process model exported using EXPM did not correctly copy across multi-field multi-value attributes (blocks). The single-field multi-value attributes were copied, and still recorded that they were grouped by the same block attribute. Because the block attribute had not been copied fully, the attributes grouped by it returned the above error when you tried to edit or de-assign them.
