Log de Cambios Versión 3.2.2.22.11

Se contempla la migración desde la versión 3.2.2.19O

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

Nuevo!
Función para verificación en un solo paso de archivos cfg²⁾, tablas y actualizaciones de versión.

En SetupBox > Módulos > Común
Para la versión 3.2.2.22.11 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
 
 
--------------------  Verify BDD Basic-----------------------
Create BDD:Common
Create BDD:SetupBox
Create BDD:DataLink
Create BDD:CMDB
Create BDD:Atis
Create BDD:DRobot
Create BDD:Demo
-- 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:SDCASEMT	 FIELD:CASEMT_SET_LS_HERESTEP_CONFIG	 SQL:ALTER TABLE SDCASEMT ADD [CASEMT_SET_LS_HERESTEP_CONFIG]TEXT
YES 	 NEW_COLUMN 	 TABLE:MDSERVICEEXTRATABLE	 FIELD:IDCMDBCIIMP_TYPE	 SQL:ALTER TABLE MDSERVICEEXTRATABLE ADD [IDCMDBCIIMP_TYPE]INTEGER, CONSTRAINT IDMDSERVICEEXTRATABLE3 FOREIGN KEY ([IDCMDBCIIMP_TYPE]) REFERENCES CMDBCIMP_TYPE([IDCMDBCIIMP_TYPE])
YES 	 NEW_COLUMN 	 TABLE:MDSERVICEEXTRATABLE	 FIELD:USEBASELINE	 SQL:ALTER TABLE MDSERVICEEXTRATABLE ADD [USEBASELINE]BIT
YES 	 NEW_COLUMN 	 TABLE:MDSERVICEEXTRATABLE	 FIELD:SQL	 SQL:ALTER TABLE MDSERVICEEXTRATABLE ADD [SQL]TEXT
YES 	 NEW_TABLE 	 TABLE:PMPSEARCH	 FIELD:IDPMPSEARCH	 SQL:CREATE TABLE PMPSEARCH ([IDPMPSEARCH]INTEGER IDENTITY(1,1), CONSTRAINT IDPMPSEARCH1 UNIQUE ([IDPMPSEARCH])) 
YES 	 NEW_COLUMN 	 TABLE:PMPSEARCH	 FIELD:NAMEPMPSEARCH	 SQL:ALTER TABLE PMPSEARCH ADD [NAMEPMPSEARCH]VARCHAR(255)
YES 	 NEW_COLUMN 	 TABLE:PMPSEARCH	 FIELD:QUERYPMPSEARCH	 SQL:ALTER TABLE PMPSEARCH ADD [QUERYPMPSEARCH]TEXT
YES 	 NEW_COLUMN 	 TABLE:TOPICS	 FIELD:IDSDCASE	 SQL:ALTER TABLE TOPICS ADD [IDSDCASE]INTEGER
YES 	 NEW_TABLE 	 TABLE:TOPICRESPONSE_NOTIFY	 FIELD:IDTOPICRESPONSE_NOTIFY	 SQL:CREATE TABLE TOPICRESPONSE_NOTIFY ([IDTOPICRESPONSE_NOTIFY]INTEGER IDENTITY(1,1), CONSTRAINT IDTOPICRESPONSE_NOTIFY1 UNIQUE ([IDTOPICRESPONSE_NOTIFY])) 
YES 	 NEW_COLUMN 	 TABLE:TOPICRESPONSE_NOTIFY	 FIELD:IDTOPICSRESPONSE	 SQL:ALTER TABLE TOPICRESPONSE_NOTIFY ADD [IDTOPICSRESPONSE]INTEGER, CONSTRAINT IDTOPICRESPONSE_NOTIFY2 FOREIGN KEY ([IDTOPICSRESPONSE]) REFERENCES TOPICSRESPONSE([IDTOPICSRESPONSE])
YES 	 NEW_COLUMN 	 TABLE:TOPICRESPONSE_NOTIFY	 FIELD:IDCMDBCI	 SQL:ALTER TABLE TOPICRESPONSE_NOTIFY ADD [IDCMDBCI]INTEGER, CONSTRAINT IDTOPICRESPONSE_NOTIFY3 FOREIGN KEY ([IDCMDBCI]) REFERENCES CMDBCI([IDCMDBCI])
YES 	 NEW_COLUMN 	 TABLE:TOPICRESPONSE_NOTIFY	 FIELD:TOPICRESPONSE_NOTIFY_ISSENDCONSOLE	 SQL:ALTER TABLE TOPICRESPONSE_NOTIFY ADD [TOPICRESPONSE_NOTIFY_ISSENDCONSOLE]BIT
YES 	 NEW_COLUMN 	 TABLE:TOPICRESPONSE_NOTIFY	 FIELD:TOPICRESPONSE_NOTIFY_ISSENDEMAIL	 SQL:ALTER TABLE TOPICRESPONSE_NOTIFY ADD [TOPICRESPONSE_NOTIFY_ISSENDEMAIL]BIT
YES 	 NEW_COLUMN 	 TABLE:TOPICRESPONSE_NOTIFY	 FIELD:TOPICRESPONSE_NOTIFY_TYPE	 SQL:ALTER TABLE TOPICRESPONSE_NOTIFY ADD [TOPICRESPONSE_NOTIFY_TYPE]INTEGER
-- Interno Service Prefix[DRobot] BDD[mdf] --
changes were not in the database.
-- Interno Service Prefix[Demo] BDD[mdf] --
changes were not in the database.
 
 
 
--------------------  Build BDD Extra-----------------------
Generate:CIExtraTable
Generate:ServiceExtraTable
Generate:BaseLine
 
 
 
--------------------  Verify BDD Extra-----------------------
Create:CIExtraTable
Create:ServiceExtraTable
Create:BaseLine
-- 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
Persistence.ITHC.Properties+TITHCVERSION_Persistence.ITHC.Properties+TITHCVERSIONBUILD OK
 
UpGrade Service pack completed
Service OK: 4
Service Error: 0
 
 
--------------------  Upgrade Model -----------------------
[Listado actualización de función ModuleCode]
[Result ModuleCode add # : True]
 
[Listado actualización de Modelos]
[Result Model #, Step # : True]

Verificación de Services Pack en base de datos

Consultas ejecutadas automáticamente con las 4 actualizaciones:

INSERT INTO ITHCVERSION (IDITHCVERSION, VERSIONCOMERCIAL, VERSIONCERTIFICATION) VALUES (2, '2020 Q1', '3.2')  
 
INSERT ATMODULE (IDATMODULE,MODULENAME) VALUES (39,'Forum manager')
INSERT INTO ITHCVERSIONBUILD (IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) VALUES (17, 2, -1, '12:00:00 am 08/03/2020', 'Forum manager') 
 
INSERT ATMODULE (IDATMODULE,MODULENAME) VALUES (40,'Project Manager')
INSERT INTO ITHCVERSIONBUILD (IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) VALUES (20, 2, -1, '12:00:00 am 09/30/2020', 'Project manager, Project Manager Setup')  
 
INSERT ATMODULE (IDATMODULE,MODULENAME) VALUES (41,'Project Manager Setup')
INSERT INTO ITHCVERSIONBUILD (IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) VALUES (21, 2, -1, '12:00:00 am 11/17/2020', 'Module Code Manager')  
 
INSERT ATMODULE (IDATMODULE,MODULENAME) VALUES (42,'Module Code Manager')
INSERT INTO ITHCVERSIONBUILD (IDITHCVERSIONBUILD, IDITHCVERSION, BUILDRELEASE, BUILDDATE, BUILDDETAIL) VALUES (22, 2, -1, '12:00:00 am 11/19/2020', 'Module Code MODULECODETYPE update') 
 
INSERT INTO MODULECODETYPE(IDMODULECODETYPE,MODULECODETYPE_NAME,MODULECODE_MODE,IDSYSTEMSTATUS) VALUES (1,'GPQUERY',1,1)  
INSERT INTO MODULECODETYPE(IDMODULECODETYPE,MODULECODETYPE_NAME,MODULECODE_MODE,IDSYSTEMSTATUS) VALUES (2,'ATROLE',1,1)  
INSERT INTO MODULECODETYPE(IDMODULECODETYPE,MODULECODETYPE_NAME,MODULECODE_MODE,IDSYSTEMSTATUS) VALUES (3,'PSGROUP',1,1)  
INSERT INTO MODULECODETYPE(IDMODULECODETYPE,MODULECODETYPE_NAME,MODULECODE_MODE,IDSYSTEMSTATUS) VALUES (4,'HOMEBANDS',1,1)  
INSERT INTO MODULECODETYPE(IDMODULECODETYPE,MODULECODETYPE_NAME,MODULECODE_MODE,IDSYSTEMSTATUS) VALUES (5,'PBITEMPLATE',1,1)  
INSERT INTO MODULECODETYPE(IDMODULECODETYPE,MODULECODETYPE_NAME,MODULECODE_MODE,IDSYSTEMSTATUS) VALUES (6,'LIFESTATUS',1,1) 
 
[INSERT INTO MODULECODEMANAGER( IDMODULECODETYPE, IDMODULECODE, MODULECODE, LASTUPGRADE ) VALUES ( ... )] -- Inserción según el tipo MODULECODETYPE --

¹⁾

Modulo para administrar conexión con motor de base de datos

²⁾

Archivos propios de configuración del sistema