[810312] Only module dependent UIDs are permitted for table DialogTaggedItem Transport file error

Markus Weiss-Ehlers  Please help in case of any suggestion or leads.

Check in the table Dialogcolumn for columname "UID_Dialogtaggeditem" see what the "IsUID" is set as. Then compare this for both environments and see if they are different. From my understanding the IsUID should be enabled.

First, I would ask for some necessary information.

What version are you using? Are the versions of the environments the same? Is your environment a migrated one from version 6.x?

Are you working in the same team as prakash triumphs? If so I would kindly ask to stop double-posting https://www.quest.com/community/one-identity/identity-manager/f/identity-manager-forum/30086/can-you-help-me-on-810312-only-module-dependent-uids-are-permitted-for-table-dialogtaggeditem

In addition, as Troy mentioned, can your please run the following SQL statement in your databases?

select ColumnName, IsUID, UID_DialogTable
from
 dialogcolumn
where ColumnName like 'UID%'
and IsUID = '0'

Error during execution of statement: select ColumnName ,isuid, uid_dialogtable
from DialogColumn where
uid%'
Database error 102: Incorrect syntax near '&'.
Incorrect syntax near '&'.

I tried given queries but it seems queries needs to be modified. Not working i tried as below->

select ColumnName ,isuid, uid_dialogtable
from DialogColumn where
ColumnName like '&#39';

Version used - 8.0 for both environments.

select ColumnName ,isuid, uid_dialogtable
from DialogColumn where
ColumnName like 'uid%' and isuid = '0'

Is the query i used right? Please suggest.

Yes Prakash was working with me, We can keep this thread open and I will ask him to close that one.

Apart from this I also tried few queries as below, but did not find difference in enthronements.

select top 100 isuid,columnname,* from DialogColumn where
UID_DialogTable = 'QBM-T-DialogTaggedItem' and isuid='true'

select top 100 isuid,columnname,* from DialogColumn where
UID_DialogTable ='QBM-T-DialogTag' and isuid='true'

select top 100 isuid,columnname,* from DialogColumn where
UID_DialogTable ='QBM-T-QBMTaggedChange' and isuid='true'

select top 100 isuid,columnname,* from DialogColumn where
UID_DialogTable = 'QBM-T-DialogTaggedItem' and isuid='true'

select top 100 isuid,columnname,* from DialogColumn where
UID_DialogTable ='QBM-T-DialogTag' and isuid='true'

select top 100 isuid,columnname,* from DialogColumn where
UID_DialogTable ='QBM-T-QBMTaggedChange' and isuid='true'

I tried above three- Both environment are same now- earler i found one difference but i corrected it.  (difference I found was - In target environment isuid was false for UID_DialogTaggedItem@DialogTaggedItem   I made it true and both environment give same results for above three queries i mentioned but was still getting same error while importing transport from source environment.)

Hi Markus,Hi Grandy,

Yes I am working with Deepak, will close my post regarding this issue. Moreover we run the update query in object brower sql layer (as we don't have the privilege to access SQL server studio), the value for the column 'isUID' was set true. However we are still receiving the same error while importing the TP using Change Label (that consist of Portal changes) to destination environment

Okay, so you are using 8.0 for both environments.

Still, the open question if the environment is a migrated one from version 6.x

In my SQL Statement you have to replace the ' with a single quote, sorry I forgot that the forum is replacing these.

And if you want to set the value, it has to be set to 1 not true.

The environment was migrated from Version 6 to 7, then 7 to Version 8.0 and now we will run the query again as you suggested and will get back to you in case the issue gets repeated:)

Unfortunately we still receive the same error while the TP is imported. Need your guidance

Please contact support then.