dbo.QBM_PDatabasePrepareCheck2

1  create   procedure QBM_PDatabasePrepareCheck2 as begin   declare @xdate datetime = getutcdate() declare @XUser nvarchar(64) = object_name(@@procid
2)   declare @DefaultPassword varchar(64) declare @defaultSalt varchar(5) declare @ObjectKeyOfRow varchar(138) = '<Key><T>DialogConfigParm</T><P>QBM-c88cc1888e12462e84acaee7dd94931d</P></Key>'
3 declare @TableName varchar(30) = 'DialogConfigParm' declare @ColumnName varchar(30) = 'Enabled' declare @ActionUser varchar(30) = 'dbmig' SET XACT_ABORT
4 OFF BEGIN TRY set nocount on exec QBM_PDatabasePrepareCheck1    update dialogcolumn set IsMultiValued = c.IsMultiValued  , XDateUpdated = @Xdate , XUserUpdated
5 = @XUser from dialogcolumn join dialogcolumn c on dialogcolumn.uid_basecolumn = c.uid_dialogcolumn  join dialogtable t with (readpast) on t.UID_DialogTable
6 = c.UID_DialogTable where t.tabletype in ('T', 'B', 'M') and DialogColumn.IsMultiValued <> c.IsMultiValued update dialogcolumn set IsMultiValued = ba.IsMultiValued
7  , XDateUpdated = @Xdate , XUserUpdated = @XUser from dialogcolumn join Dialogcolumn ba on ba.UID_DialogColumnUnionView = dialogcolumn.uid_dialogcolumn
8  where dialogcolumn.IsMultiValued <> ba.IsMultiValued    update dialogcolumn set isalternatepkmember = 0  , XDateUpdated = @Xdate , XUserUpdated = @XUser
9  from dialogcolumn c join dialogtable t with (readpast) on c.UID_DialogTable = t.UID_DialogTable where c.isalternatepkmember = 1 and c.SchemaDataType 
10= 'varchar' and c.SchemaDatalen = 38  and not exists (select top 1 1 from QBMRelation cr where c.uid_dialogcolumn = cr.uid_childcolumn ) and t.isTransportdisabled
11 = 0  update dialogcolumn set istoignoreonexport = 0  , XDateUpdated = @Xdate , XUserUpdated = @XUser where isAlternatepkMember = 1 and istoignoreonexport
12 = 1 if dbo.QBM_FGIDBOwner() <> 'CCC' begin update DialogColumn set IsToIgnoreOnExport = 1 , IsToIgnoreOnImport = 1  , XDateUpdated = @Xdate , XUserUpdated
13 = @XUser  from DialogColumn c join DialogTable t with (readpast) on c.UID_DialogTable = t.UID_DialogTable  where dbo.QBM_FCVGUIDToModuleOwner( c.UID_DialogColumn
14 ) = 'MDK' and (IsToIgnoreOnExport = 0 or IsToIgnoreOnImport = 0 ) end  select @DefaultPassword = 'UnableForDialogLogin' select @defaultSalt = '65721' 
15merge into DialogUser as t using ( values ('QBM-9A0DB20E74F348ABA56BED38EAA9ADF6', 'sa' , 1, 0)  ) as s (UID_DialogUser , username , IsServiceAccount ,
16 IsReadOnly ) on t.UID_DialogUser = s.UID_DialogUser when matched then update set t.IsReadOnly = s.IsReadOnly , t.password = @DefaultPassword , t.salt 
17= @defaultSalt , t.username = s.Username , t.IsServiceAccount = s.IsServiceAccount , t.XdateUpdated = @xdate , t.XUserUpdated = @XUser when not matched
18 by target  and dbo.QBM_FGIModuleExists(left(s.UID_DialogUser, 3)) = 1 then insert ( UID_DialogUser, username, password, salt, IsReadOnly , XObjectKey 
19, XUserInserted, XUserUpdated, XDateInserted, XDateUpdated , IsServiceAccount ) values (s.UID_DialogUser, s.Username, @DefaultPassword, @defaultSalt, s.IsReadOnly
20 , dbo.QBM_FCVElementToObjectKey1('dialoguser', 'uid_dialogUser', s.UID_DialogUser) , @XUser, @XUser, @xdate, @xdate , s.IsServiceAccount ) ;    delete
21 QBMDBQueueTask  from QBMDBQueueTask de left outer join QBMModuleDef m on LEFT(de.UID_Task , 3) = m.ModuleName where m.UID_ModuleDef is null delete QBMDBQueueTaskDepend
22  from QBMDBQueueTaskDepend de left outer join QBMModuleDef m on LEFT(de.UID_TaskPredecessor , 3) = m.ModuleName where m.UID_ModuleDef is null delete QBMDBQueueTaskDepend
23  from QBMDBQueueTaskDepend de left outer join QBMModuleDef m on LEFT(de.UID_TaskFollower , 3) = m.ModuleName where m.UID_ModuleDef is null    if dbo.QBM_FGIDBOwner
24() = 'CCC' and exists  (select top 1 1 from sys.tables t with (readpast) join sys.columns c with (readpast) on t.object_id = c.object_id where t.name =
25 'DialogDatabase' and c.name = 'InitialMigrationRunning' ) begin update DialogConfigParm set Enabled = 1  , XDateUpdated = @Xdate , XUserUpdated = @XUser
26 where FullPath = 'Common\Autoupdate' and Enabled = 0 end  if dbo.QBM_FGIDBOwner() = 'CCC' begin if exists (select top 1 1 from QBMBufferConfig cf where
27 cf.ObjectKeyOfRow = @ObjectKeyOfRow and cf.TableName = @TableName and cf.ColumnName = @ColumnName ) begin update QBMBufferConfig set ContentShort = '0'
28  , XDateUpdated = @Xdate , XUserUpdated = @XUser from QBMBufferConfig cf where cf.ObjectKeyOfRow = @ObjectKeyOfRow and cf.TableName = @TableName and cf.ColumnName
29 = @ColumnName end else begin insert into QBMBufferConfig(UID_QBMBufferConfig, TableName, ColumnName, ObjectKeyOfRow, XDateInserted, XDateUpdated, XUserInserted
30, XUserUpdated, ContentShort, HasContentFull, ContentFull ) select newid(), @TableName , @ColumnName, @ObjectKeyOfRow , getutcdate() , getutcdate(), @ActionUser
31, @ActionUser , '0', 0, null end end  exec QBM_P195C5572460EC8DDA27B3A3_1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar
32(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 
33