Migración a versión 2 (3.2.2.17)

Después de actualizar los archivos de Software y los sitios, realizar las siguientes actualizaciones de base de datos con el SetupBox¹⁾.

1. En SetupBox > Módulos > Común
   Para la versión 3.2.2.17 se deben instalar las siguientes actualizaciones:
   
   
   
   

• Dar clic en Check Upgrade
  
  
  
  
• Para actualizar la versión en base de datos:
  Dar clic en Apply Upgrade.
  
  

  • Habilitar la casilla Full Update para incluir los pasos de verificación de archivos .cfg y tablas/campos
  • En caso de no activar la casilla Full Update se van a realizar unicamente las actualizaciones de versión pendientes

  
  
  
  
  Se generará resultado de las operaciones y se indicará si fue correcta o no la actualización:
  
  
  
  Resumen de verificación y actualización de los service pack
  
  

  --------------------  Build BDD -----------------------
  Generate:Common
  Generate:SetupBox
  Generate:DataLink
  Generate:CMDB
  Generate:Atis
  Generate:DRobot
  Generate:Demo
  Generate:CIExtraTable
  Generate:ServiceExtraTable
  Generate:BaseLine
   
   
  --------------------  Verify BDD -----------------------
  Create BDD:Common
  Create BDD:SetupBox
  Create BDD:DataLink
  Create BDD:CMDB
  Create BDD:Atis
  Create BDD:DRobot
  Create BDD:Demo
  Create:CIExtraTable
  Create:ServiceExtraTable
  Create:BaseLine
  -- Interno Service Prefix[Common] BDD[mdf] --
  changes were not in the database.
  -- Interno Service Prefix[SetupBox] BDD[mdf] --
  changes were not in the database.
  -- Interno Service Prefix[DataLink] BDD[mdf] --
  changes were not in the database.
  -- Interno Service Prefix[CMDB] BDD[mdf] --
  changes were not in the database.
  -- Interno Service Prefix[Atis] BDD[mdf] --
  YES 	 NEW_COLUMN 	 TABLE:SDCASE	 FIELD:CASE_DESCRIPTION_BA	 SQL:ALTER TABLE SDCASE ADD [CASE_DESCRIPTION_BA]VARBINARY(MAX)
  YES 	 NEW_COLUMN 	 TABLE:MDMODELTYPED	 FIELD:IDMDINTERFACE	 SQL:ALTER TABLE MDMODELTYPED ADD [IDMDINTERFACE]INTEGER, CONSTRAINT IDMDMODELTYPED6 FOREIGN KEY ([IDMDINTERFACE]) REFERENCES MDINTERFACE([IDMDINTERFACE])
  YES 	 NEW_COLUMN 	 TABLE:MDMODELTYPED	 FIELD:MT_IDATROLE	 SQL:ALTER TABLE MDMODELTYPED ADD [MT_IDATROLE]INTEGER 
  YES 	 NEW_COLUMN 	 TABLE:MDMODELTYPED	 FIELD:ET_IDATROLE	 SQL:ALTER TABLE MDMODELTYPED ADD [ET_IDATROLE]INTEGER 
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUS	 FIELD:LS_IDSURVEY	 SQL:ALTER TABLE MDLIFESTATUS ADD [LS_IDSURVEY]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUS	 FIELD:LS_EXPIRATIONTIME	 SQL:ALTER TABLE MDLIFESTATUS ADD [LS_EXPIRATIONTIME]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUS	 FIELD:LS_GOTONEXTSTEP	 SQL:ALTER TABLE MDLIFESTATUS ADD [LS_GOTONEXTSTEP]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUS	 FIELD:LS_SURVEYWINNER_GOTONEXTSTEP	 SQL:ALTER TABLE MDLIFESTATUS ADD [LS_SURVEYWINNER_GOTONEXTSTEP]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUS	 FIELD:LS_EXTRAOPTIONS	 SQL:ALTER TABLE MDLIFESTATUS ADD [LS_EXTRAOPTIONS]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUS	 FIELD:LS_IDATROLE	 SQL:ALTER TABLE MDLIFESTATUS ADD [LS_IDATROLE]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSTYPEUSER	 FIELD:IDSURVEYMODETYPE	 SQL:ALTER TABLE MDLIFESTATUSTYPEUSER ADD [IDSURVEYMODETYPE]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSTYPEUSER	 FIELD:SURVEYVIEW	 SQL:ALTER TABLE MDLIFESTATUSTYPEUSER ADD [SURVEYVIEW]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSTYPEUSER	 FIELD:LSTU_IDATROLE	 SQL:ALTER TABLE MDLIFESTATUSTYPEUSER ADD [LSTU_IDATROLE]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSSTEXTRAFIELDS	 FIELD:LSEFST_EXTRAOPTION_SCRIPT	 SQL:ALTER TABLE MDLIFESTATUSSTEXTRAFIELDS ADD [LSEFST_EXTRAOPTION_SCRIPT]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSSTEXTRAFIELDS	 FIELD:LSEFST_INDEX	 SQL:ALTER TABLE MDLIFESTATUSSTEXTRAFIELDS ADD [LSEFST_INDEX]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSSTEXTRAFIELDS	 FIELD:LSEFST_HELP	 SQL:ALTER TABLE MDLIFESTATUSSTEXTRAFIELDS ADD [LSEFST_HELP]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSCIEXTRAFIELDS	 FIELD:LSEFCI_EXTRAOPTION_SCRIPT	 SQL:ALTER TABLE MDLIFESTATUSCIEXTRAFIELDS ADD [LSEFCI_EXTRAOPTION_SCRIPT]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSCIEXTRAFIELDS	 FIELD:LSEFCI_INDEX	 SQL:ALTER TABLE MDLIFESTATUSCIEXTRAFIELDS ADD [LSEFCI_INDEX]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDLIFESTATUSCIEXTRAFIELDS	 FIELD:LSEFCI_HELP	 SQL:ALTER TABLE MDLIFESTATUSCIEXTRAFIELDS ADD [LSEFCI_HELP]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDCASESTEXTRAFIELDS	 FIELD:CASESTEF_EXTRAOPTION_SCRIPT	 SQL:ALTER TABLE MDCASESTEXTRAFIELDS ADD [CASESTEF_EXTRAOPTION_SCRIPT]TEXT
  YES 	 NEW_COLUMN 	 TABLE:MDCASESTEXTRAFIELDS	 FIELD:CASESTEF_INDEX	 SQL:ALTER TABLE MDCASESTEXTRAFIELDS ADD [CASESTEF_INDEX]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MDCASESTEXTRAFIELDS	 FIELD:CASESTEF_HELP	 SQL:ALTER TABLE MDCASESTEXTRAFIELDS ADD [CASESTEF_HELP]TEXT
  YES 	 NEW_COLUMN 	 TABLE:GPVIEW	 FIELD:GPVIEW_FILTERCF	 SQL:ALTER TABLE GPVIEW ADD [GPVIEW_FILTERCF]TEXT 
  YES 	 NEW_COLUMN 	 TABLE:ATROLE	 FIELD:ATROLETYPE	 SQL:ALTER TABLE ATROLE ADD [ATROLETYPE]INT 
  YES 	 NEW_COLUMN 	 TABLE:EV_EMAIL_SDCASE	 FIELD:EMAIL_BODYTEXT_BA	 SQL:ALTER TABLE EV_EMAIL_SDCASE ADD [EMAIL_BODYTEXT_BA]VARBINARY(MAX)
  YES 	 NEW_COLUMN 	 TABLE:SURVEYDATA	 FIELD:IDSURVEYOPTION_WINNER	 SQL:ALTER TABLE SURVEYDATA ADD [IDSURVEYOPTION_WINNER]INTEGER
  YES 	 NEW_TABLE 	 TABLE:SURVEYMODETYPE	 FIELD:IDSURVEYMODETYPE	 SQL:CREATE TABLE SURVEYMODETYPE ([IDSURVEYMODETYPE]INTEGER) 
  YES 	 NEW_COLUMN 	 TABLE:SURVEYMODETYPE	 FIELD:SURVEYMODETYPENAME	 SQL:ALTER TABLE SURVEYMODETYPE ADD [SURVEYMODETYPENAME]VARCHAR(50)
  YES 	 NEW_TABLE 	 TABLE:MODULECODETYPE	 FIELD:IDMODULECODETYPE	 SQL:CREATE TABLE MODULECODETYPE ([IDMODULECODETYPE]INTEGER, CONSTRAINT IDMODULECODETYPE1 UNIQUE ([IDMODULECODETYPE])) 
  YES 	 NEW_COLUMN 	 TABLE:MODULECODETYPE	 FIELD:MODULECODETYPE_NAME	 SQL:ALTER TABLE MODULECODETYPE ADD [MODULECODETYPE_NAME]VARCHAR(50)
  YES 	 NEW_COLUMN 	 TABLE:MODULECODETYPE	 FIELD:MODULECODE_MODE	 SQL:ALTER TABLE MODULECODETYPE ADD [MODULECODE_MODE]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MODULECODETYPE	 FIELD:IDSYSTEMSTATUS	 SQL:ALTER TABLE MODULECODETYPE ADD [IDSYSTEMSTATUS]INTEGER
  YES 	 NEW_TABLE 	 TABLE:MODULECODEMANAGER	 FIELD:IDMODULECODEMANAGER	 SQL:CREATE TABLE MODULECODEMANAGER ([IDMODULECODEMANAGER]INTEGER IDENTITY(1,1), CONSTRAINT IDMODULECODEMANAGER1 UNIQUE ([IDMODULECODEMANAGER])) 
  YES 	 NEW_COLUMN 	 TABLE:MODULECODEMANAGER	 FIELD:IDMODULECODETYPE	 SQL:ALTER TABLE MODULECODEMANAGER ADD [IDMODULECODETYPE]INTEGER, CONSTRAINT IDMODULECODEMANAGER2 FOREIGN KEY ([IDMODULECODETYPE]) REFERENCES MODULECODETYPE([IDMODULECODETYPE])
  YES 	 NEW_COLUMN 	 TABLE:MODULECODEMANAGER	 FIELD:IDMODULECODE	 SQL:ALTER TABLE MODULECODEMANAGER ADD [IDMODULECODE]INTEGER
  YES 	 NEW_COLUMN 	 TABLE:MODULECODEMANAGER	 FIELD:MODULECODE	 SQL:ALTER TABLE MODULECODEMANAGER ADD [MODULECODE]TEXT 
  YES 	 NEW_COLUMN 	 TABLE:MODULECODEMANAGER	 FIELD:LASTUPGRADE	 SQL:ALTER TABLE MODULECODEMANAGER ADD [LASTUPGRADE]DATETIME 
  YES 	 NEW_COLUMN 	 TABLE:PBITEMPLATECELLGRAPHIC	 FIELD:CELLGRAPHIC_EXTRAPARAM	 SQL:ALTER TABLE PBITEMPLATECELLGRAPHIC ADD [CELLGRAPHIC_EXTRAPARAM]TEXT
  YES 	 NEW_COLUMN 	 TABLE:PBITEMPLATECELLGRAPHIC	 FIELD:CELLGRAPHIC_SUBTYPEGRAPHIC	 SQL:ALTER TABLE PBITEMPLATECELLGRAPHIC ADD [CELLGRAPHIC_SUBTYPEGRAPHIC]INTEGER
  -- Interno Service Prefix[DRobot] BDD[mdf] --
  YES 	 NEW_COLUMN 	 TABLE:DREMAILNEWCASEDETAIL	 FIELD:COPYEMAIL	 SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [COPYEMAIL]BIT
  -- Interno Service Prefix[Demo] BDD[mdf] --
  YES 	 NEW_TABLE 	 TABLE:DMVARBINARY	 FIELD:IDDMVARBINARY	 SQL:CREATE TABLE DMVARBINARY ([IDDMVARBINARY]INTEGER IDENTITY(1,1), CONSTRAINT IDDMVARBINARY1 UNIQUE ([IDDMVARBINARY])) 
  YES 	 NEW_COLUMN 	 TABLE:DMVARBINARY	 FIELD:VARBINARY	 SQL:ALTER TABLE DMVARBINARY ADD [VARBINARY]VARBINARY(MAX)
  -- Interno Service Prefix[CMDB_EF] BDD[mdf] --
  changes were not in the database.
  -- Interno Service Prefix[ST] BDD[mdf] --
  changes were not in the database.
  -- Interno Service Prefix[BL] BDD[mdf] --
  changes were not in the database.
   
   
   
  --------------------  apply service pack -----------------------
  Persistence.ITHC.Properties+TITHCVERSION_Persistence.ITHC.Properties+TITHCVERSIONBUILD OK
  Persistence.ITHC.Properties+TITHCVERSION_Persistence.ITHC.Properties+TITHCVERSIONBUILD OK
  Persistence.ITHC.Properties+TITHCVERSION_Persistence.ITHC.Properties+TITHCVERSIONBUILD OK
   
  UpGrade Service pack completed
  Service OK: 3
  Service Error: 0
   
   
  --------------------  Upgrade Model -----------------------
  Result Model 1: True
  Result Model 2: True
  Result Model 3: True
  Result Model 5: True
  Result Model 7: True

  
  
  

• Consultas ejecutadas automáticamente con las 3 actualizaciones:
  
  

  UPDATE  DREMAILNEWCASEDETAIL SET  DREMAILNEWCASEDETAIL.COPYEMAIL=0 WHERE DREMAILNEWCASEDETAIL.COPYEMAIL IS NULL
   
  INSERT INTO ITHCVERSION(IDITHCVERSION, VERSIONCOMERCIAL, VERSIONCERTIFICATION) VALUES (2, '2020 Q1', '3.2')  
  INSERT INTO ITHCVERSIONBUILD(IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) VALUES (14, 2, -1, '12:00:00 am 04/22/2020', 'ServicePack_1 Copy Email')  
   
  UPDATE MDINTERFACETYPE SET INTERFACETYPE_NAME ='None' WHERE IDMDINTERFACETYPE=0; 
  UPDATE MDINTERFACETYPE SET INTERFACETYPE_NAME ='Attention reports' WHERE IDMDINTERFACETYPE=1; 
  UPDATE MDINTERFACETYPE SET INTERFACETYPE_NAME ='Model' WHERE IDMDINTERFACETYPE=2; 
  UPDATE MDINTERFACETYPE SET INTERFACETYPE_NAME ='Model Life Status Extra Table' WHERE IDMDINTERFACETYPE=3;
   
  SELECT MAX(IDSDNOTIFYTYPEEVENT) MAX FROM SDNOTIFYTYPEEVENT
  INSERT INTO SDNOTIFYTYPEEVENT(IDSDNOTIFYTYPEEVENT,TYPEEVENTNAME) VALUES (11,'Emply') 
  INSERT INTO SDNOTIFYTYPEEVENT(IDSDNOTIFYTYPEEVENT,TYPEEVENTNAME) VALUES (12,'Emply') 
   
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='E Handler Posed Scale' WHERE IDSDNOTIFYTYPEEVENT=1; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='E Manager Informed Posed Scale' WHERE IDSDNOTIFYTYPEEVENT=2; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='I Change Information' WHERE IDSDNOTIFYTYPEEVENT=3; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='B Starts Attention' WHERE IDSDNOTIFYTYPEEVENT=4; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='A New Attachments' WHERE IDSDNOTIFYTYPEEVENT=5; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='O Observation' WHERE IDSDNOTIFYTYPEEVENT=6; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='SP Status Paused' WHERE IDSDNOTIFYTYPEEVENT=7; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='SCL Status Closed' WHERE IDSDNOTIFYTYPEEVENT=8; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='SCN Status Cancelled' WHERE IDSDNOTIFYTYPEEVENT=9; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='SIP Status InProgress' WHERE IDSDNOTIFYTYPEEVENT=10; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='E Handler Trasfer Deposed Scale' WHERE IDSDNOTIFYTYPEEVENT=11; 
  UPDATE SDNOTIFYTYPEEVENT SET TYPEEVENTNAME ='E Manager Informed Deposed Scale' WHERE IDSDNOTIFYTYPEEVENT=12;
   
  INSERT INTO ITHCVERSION(IDITHCVERSION, VERSIONCOMERCIAL, VERSIONCERTIFICATION) Values (2, '2020 Q1', '3.2')  
  INSERT INTO ITHCVERSIONBUILD(IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) VALUES (15, 2, -1, '12:00:00 am 05/07/2020', 'ServicePack_2 MDInterfaceType and SDNotifyTypeEvent Upgrade')  
   
  SELECT * FROM PBIGRAPHICTYPE WHERE IDPBIGRAPHICTYPE=9
  INSERT INTO PBIGRAPHICTYPE(GRAPHIC_NAME,GRAPHIC_DESCRIPTION) VALUES ('Gauge', 'Graphic Gauge')
   
  SELECT * FROM SURVEYMODETYPE
  INSERT INTO SURVEYMODETYPE VALUES (0, 'None'), (1, 'View'), (2, 'Manager'), (3, 'Voter'), (4, 'Observer')
   
  UPDATE MDMODELTYPED SET ET_IDATROLE=0 WHERE ET_IDATROLE=null; 
  UPDATE MDMODELTYPED SET MT_IDATROLE=0 WHERE MT_IDATROLE=null; 
  UPDATE MDLIFESTATUS SET LS_IDATROLE=0 WHERE LS_IDATROLE=null; 
  UPDATE MDLIFESTATUSTYPEUSER SET LSTU_IDATROLE=0 WHERE LSTU_IDATROLE=null;
  SELECT  MDLIFESTATUSSTEXTRATABLE.IDMDLIFESTATUSSTEXTRATABLE,MDLIFESTATUS.IDMDLIFESTATUS AS IDMDLIFESTATUS1,MDLIFESTATUSSTEXTRATABLE.IDMDLIFESTATUS AS IDMDLIFESTATUS2 FROM MDLIFESTATUSTYPEUSER,MDLIFESTATUS,MDLIFESTATUSSTEXTRATABLE WHERE MDLIFESTATUSTYPEUSER.IDMDLIFESTATUS=MDLIFESTATUS.IDMDLIFESTATUS AND MDLIFESTATUSTYPEUSER.IDMDLIFESTATUSTYPEUSER = MDLIFESTATUSSTEXTRATABLE.IDMDLIFESTATUSTYPEUSER AND  MDLIFESTATUSSTEXTRATABLE.IDMDLIFESTATUS  != MDLIFESTATUS.IDMDLIFESTATUS 
   
  INSERT INTO ITHCVERSION(IDITHCVERSION, VERSIONCOMERCIAL, VERSIONCERTIFICATION) VALUES (2, '2020 Q1', '3.2')  
  SELECT IDSDTYPEUSER FROM SDTYPEUSER WHERE SDTYPEUSER.TYPEUSERNAME ='Creator'
  INSERT INTO ITHCVERSIONBUILD(IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) Values (16, 2, -1, '12:00:00 am 05/14/2020', 'ServicePack_3 PBI graphic type,survey mode type, model interface and copy, User Creator')