Table of Contents
Migración a versión 2 (3.2.2.17)
Desde versión 1 (3.2.1.34)
Se contempla la migración desde la versión 3.2.1.34 a la versión 3.2.2.17
Documentación de versión 3.2.1.34:
Log de cambios Versión 3.2.1.32
Incluye pasos de migración y log de cambios de versiones 3.2.1.32 - 3.2.1.33 - 3.2.1.34
Después de actualizar los archivos de Software y los sitios, realizar las siguientes actualizaciones de base de datos con el SetupBox1).
Nuevo!
Función para verificación en un solo paso de archivos cfg2), tablas y actualizaciones de versión.
Función para verificación en un solo paso de archivos cfg2), tablas y actualizaciones de versión.
- 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
Verificación de Services Pack en base de datos
- 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')