• State Not Answered
  • Replies 10 replies
  • Subscribers 94 subscribers
  • Views 4109 views
  • Users 0 members are here
Options
Related

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

deepak kumar2
over 4 years ago

Hi,

I am trying to import WebDesigner related change via a change Lable based transport from One Environment to another and facing mention error = ([810312] Only module dependent UIDs are permitted for table DialogTaggedItem.)

Please guide me about ways to debug this issue.

Sharing some of Import file logs ->

2019-08-20 15:33:22.2449 TRACE (SqlLog 2eccf85c-be0e-49e2-960c-2a6597dd0b9c) : ClaimConnectionAsync: Use the transaction
2019-08-20 15:33:22.2449 DEBUG (SqlLog 2eccf85c-be0e-49e2-960c-2a6597dd0b9c) : (< 1 ms) - select 1 where exists (select 1 from QBMTaggedChange where (QBMTaggedChange.UID_DialogTag = 'CCC-307C7F4D75C06145AEE3F4E351A25B40'))
2019-08-20 15:33:22.2449 DEBUG (ObjectLog 2eccf85c-be0e-49e2-960c-2a6597dd0b9c) : Run statement and fetch data done in 4ms.
2019-08-20 15:33:22.2605 DEBUG (ObjectLog 2eccf85c-be0e-49e2-960c-2a6597dd0b9c) : Rollback transaction in read/write entity
2019-08-20 15:33:22.2605 DEBUG (ObjectLog 2eccf85c-be0e-49e2-960c-2a6597dd0b9c) : Session: Rollback Transaction
2019-08-20 15:33:22.2761 ERROR (Transport ) : Transport finished with error (8/20/2019 3:33:22 PM) System.AggregateException: One or more errors occurred. ---> VI.Base.ViException: Error during execution of 'OnSaving' in logic module 'VI.DB.Entities.ModuleDependentLogic'. ---> VI.Base.ViException: Only module dependent UIDs are permitted for table DialogTaggedItem.
at VI.DB.Entities.ModuleDependentLogic.<OnSavingAsync>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at VI.DB.Entities.CombinedEntityLogic.<OnSavingWithHandlerAsync>d__13.MoveNext()
--- End of inner exception stack trace ---
at VI.DB.Entities.CombinedEntityLogic.<OnSavingWithHandlerAsync>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at VI.DB.Entities.DelayedLogicSaveEntityStrategy.<OnSavingAsync>d__5.MoveNext()

Parents
  • 0 over 4 years ago

    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.

  • 0 over 4 years ago in reply to Troy Grandy

    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.)

  • 0 over 4 years ago in reply to deepak kumar2

    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

  • 0 over 4 years ago in reply to prakash triumphs

    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 &#39; 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.

  • 0 over 4 years ago in reply to Markus Weiss-Ehlers

    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:)

Reply Children