es:versiones:ver_24_22



Log de Cambios Versión 3.2.2.24.24



  • Se contempla la migración desde la versión 3.2.2.24.1f

  • Realizar la actualización de personalizaciones, cualquier cambio en los SQL debe implmentarse en los archivos correspondientes de la nueva versión.



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

  1. En SetupBox > Módulos > Común
    Para la versión 3.2.2.24.24 desde la versión 3.2.2.24.1f no existen actualizaciones, sin embargo, se recomienda verificar si existe alguna pendiente de migraciones anteriores. 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



    --------------------  Build BDD Basic-----------------------
    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_TABLE 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:IDSDCASE_INPUTEMAIL	 SQL:CREATE TABLE SDCASE_INPUTEMAIL ([IDSDCASE_INPUTEMAIL]INTEGER IDENTITY(1,1), CONSTRAINT IDSDCASE_INPUTEMAIL1 UNIQUE ([IDSDCASE_INPUTEMAIL])) 
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:IDSDCASE	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [IDSDCASE]INTEGER
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:EMAIL_DATEIN	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_DATEIN]DATETIME
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:EMAIL_SOURCE	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_SOURCE]VARCHAR(255)
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:EMAIL_SUBJECT	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_SUBJECT]TEXT
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:EMAIL_DESCRIPTION	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_DESCRIPTION]TEXT
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:EMAIL_DESCRIPTION_BA	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_DESCRIPTION_BA]VARBINARY(MAX)
    YES 	 NEW_COLUMN 	 TABLE:SDCASE_INPUTEMAIL	 FIELD:IDSYSTEMSTATUS	 SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [IDSYSTEMSTATUS]INTEGER
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSER	 FIELD:SURVEYDATAUSER_DATEVOTE	 SQL:ALTER TABLE SURVEYDATAUSER ADD [SURVEYDATAUSER_DATEVOTE]DATETIME
    YES 	 NEW_TABLE 	 TABLE:SURVEYDATAUSERLOG	 FIELD:IDSURVEYDATAUSERLOG	 SQL:CREATE TABLE SURVEYDATAUSERLOG ([IDSURVEYDATAUSERLOG]INTEGER IDENTITY(1,1), CONSTRAINT IDSURVEYDATAUSERLOG1 UNIQUE ([IDSURVEYDATAUSERLOG])) 
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSERLOG	 FIELD:IDSURVEYDATAUSER	 SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [IDSURVEYDATAUSER]INTEGER
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSERLOG	 FIELD:IDSURVEYOPTION	 SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [IDSURVEYOPTION]INTEGER
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSERLOG	 FIELD:SURVEYOPTION_NAME	 SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYOPTION_NAME]VARCHAR(50)
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSERLOG	 FIELD:SURVEYOPTION_DESCRIPTION	 SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYOPTION_DESCRIPTION]TEXT
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSERLOG	 FIELD:SURVEYDATAUSER_COMMENTARY	 SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYDATAUSER_COMMENTARY]TEXT
    YES 	 NEW_COLUMN 	 TABLE:SURVEYDATAUSERLOG	 FIELD:SURVEYDATAUSER_DATEVOTE	 SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYDATAUSER_DATEVOTE]DATETIME
    -- Interno Service Prefix[DRobot] BDD[mdf] --
    YES 	 NEW_COLUMN 	 TABLE:DREMAILNEWCASEDETAIL	 FIELD:REPONSEEMAIL	 SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [REPONSEEMAIL]BIT
    YES 	 NEW_COLUMN 	 TABLE:DREMAILNEWCASEDETAIL	 FIELD:REPONSEEMAIL_START	 SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [REPONSEEMAIL_START]VARCHAR(50)
    YES 	 NEW_COLUMN 	 TABLE:DREMAILNEWCASEDETAIL	 FIELD:REPONSEEMAIL_END	 SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [REPONSEEMAIL_END]VARCHAR(50)
    -- 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 -----------------------
    
    UpGrade Service pack completed
    Service OK: 0
    Service Error: 0
    
    
    --------------------  Upgrade Model -----------------------
    [Actualización de modelos]



    Resumen de cambios 3.2.2.24.24



1)
Modulo para administrar conexión con motor de base de datos
  • es/versiones/ver_24_22.txt
  • Last modified: 2021/05/05 12:46
  • by adminnancy