Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Release 2019.2 is now available. This patch contains a number of stabilization fixes and refinements. We will begin scheduling 2019.2 updates on customer Test systems starting April 24th, 2019.


Note: All versions after 2018.1  require an upgrade to PHP 7.2, hosted customers and customers who have 2018.1 already have the php upgrade.  Most updates to test systems will need to occur during non-business hours. Please send any scheduling requests to help@pcr.com.

This release contains some table changes that could cause issues with Adhocs, API calls, or other custom processes.  Please review the Database Changes in 2019.2 to review the changes and make the necessary changes to your customizations.


Licensed Customers will need to install PHP 7.2 before we can upgrade test to 2019.2, the instructions can be found here: PHP 7.2 Upgrade. Please consult PCR before upgrading your system.



Key


Initial Release


Component

Description

Type

Incident(s)

Documentation

Admin





API





Billing





Cable





Communications





CustomerCenter





Events & Notifications





General





Imports & Exports





Inventory





People





Reporting





Service Desk





Services







Database Changes in 2019.2

Table NameChangeTable Changes
CONTACTS_REMARKS
update


ADD COLUMN HTML_REMARKS NOT NULL


ADD COLUMN PLAIN_REMARKS NOT NULL

DROP COLUMN REMARKS


DEPT_HIERARCHY_REMARKS
update

ADD COLUMN HTML_REMARKS NOT NULL

ADD COLUMN PLAIN_REMARKS NOT NULL

DROP COLUMN REMARKS

SERVICES_REMARKS
update

ADD COLUMN HTML_REMARKS NOT NULL

ADD COLUMN PLAIN_REMARKS NOT NULL

DROP COLUMN REMARKS

EQUIPMENT_REMARKS
update

ADD COLUMN HTML_REMARKS NOT NULL

ADD COLUMN PLAIN_REMARKS NOT NULL

DROP COLUMN REMARKS

SERVICE_DESK_ACTIVITY
update

ADD COLUMN HTML_REMARKS DEFAULT NULL

ADD COLUMN PLAIN_REMARKS DEFAULT NULL

DROP COLUMN REMARKS

PURCHASE_ORDER_ACTIVITY
update

ADD COLUMN HTML_REMARKS DEFAULT NULL

ADD COLUMN PLAIN_REMARKS DEFAULT NULL

DROP COLUMN REMARKS

RETURN_ORDER_ACTIVITY
update

ADD COLUMN HTML_REMARKS DEFAULT NULL

ADD COLUMN PLAIN_REMARKS DEFAULT NULL

DROP COLUMN REMARKS

PAYMENTS_REMARKS
update

ADD COLUMN HTML_REMARKS NO NULL

ADD COLUMN PLAIN_REMARKS NOT NULL

DROP COLUMN REMARKS

PACKAGES
update

ADD COLUMN PACKAGE_TYPE_LISTS_RECID INTEGER NOT NULL

IMPORT_RECORD_TYPES_COLS
update
Removed BILLED_DATE, CONSUMED, SDA_NUMBER and AVAILABLE_SERVICE_HOST as column options.
LOCATIONS_REMARKS
update

GLA_ACTIVITY
update

AVAYA_AARDIGITCONVERSION
update
Renamed AVAYA_AARDIGITCONVERSION TO AVAYA_AARDIGITCONVERSIONS
AVAYA_ABBREVIATEDDIALINGGROUP
update
Renamed AVAYA_ABBREVIATEDDIALINGGROUP TO AVAYA_ABBREVIATEDDIALINGGROUPS
AVAYA_AGENT
update
Renamed AVAYA_AGENT TO AVAYA_AGENTS
AVAYA_ANNOUNCEMENT
update
Renamed AVAYA_ANNOUNCEMENT TO AVAYA_ANNOUNCEMENTS
AVAYA_ARSDIGITCONVERSION
update
Renamed AVAYA_ARSDIGITCONVERSION TO AVAYA_ARSDIGITCONVERSIONS
AVAYA_AUDIOGROUP
update
Renamed AVAYA_AUDIOGROUP TO AVAYA_AUDIOGROUPS
AVAYA_AUTHORIZATIONCODE
update
Renamed AVAYA_AUTHORIZATIONCODE TO AVAYA_AUTHORIZATIONCODES
AVAYA_CABINET
update
Renamed AVAYA_CABINET TO AVAYA_CABINETS
AVAYA_COR
update
Renamed AVAYA_COR TO AVAYA_CORS
AVAYA_COVERAGEPATH
update
Renamed AVAYA_COVERAGEPATH TO AVAYA_COVERAGEPATHS
AVAYA_CTILINK
update
Renamed AVAYA_CTILINK TO AVAYA_CTILINKS
AVAYA_EXTENSIONTYPE
update
Renamed AVAYA_EXTENSIONTYPE TO AVAYA_EXTENSIONTYPES
AVAYA_HUNTGROUP
update
Renamed AVAYA_HUNTGROUP TO AVAYA_HUNTGROUPS
AVAYA_IPSERVERINTERFACE
update
Renamed AVAYA_IPSERVERINTERFACE TO AVAYA_IPSERVERINTERFACES
AVAYA_MEDIAGATEWAY
update
Renamed AVAYA_MEDIAGATEWAY TO AVAYA_MEDIAGATEWAYS
AVAYA_PICKUPGROUP
update
Renamed AVAYA_PICKUPGROUP TO AVAYA_PICKUPGROUPS
AVAYA_PORT
update
Renamed AVAYA_PORT TO AVAYA_PORTS
AVAYA_REGISTEREDIPSTATION
update
Renamed AVAYA_REGISTEREDIPSTATION TO AVAYA_REGISTEREDIPSTATIONS
AVAYA_ROUTEPATTERN
update
Renamed AVAYA_ROUTEPATTERN TO AVAYA_ROUTEPATTERNS
AVAYA_SIGNALINGGROUP
update
Renamed AVAYA_SIGNALINGGROUP TO AVAYA_SIGNALINGGROUPS
AVAYA_STATION
update
Renamed AVAYA_STATION TO AVAYA_STATIONS
AVAYA_TRUNKGROUP
update
Renamed AVAYA_TRUNKGROUP TO AVAYA_TRUNKGROUPS
AVAYA_UNIFORMDIALPLAN
update
Renamed AVAYA_UNIFORMDIALPLAN TO AVAYA_UNIFORMDIALPLANS
AVAYA_VDN
update
Renamed AVAYA_VDN TO AVAYA_VDNS
AVAYA_VECTOR
update
Renamed AVAYA_VECTOR TO AVAYA_VECTORS
AVAYA_WITNESSSTATION
update
Renamed AVAYA_WITNESSSTATION TO AVAYA_WITNESSSTATIONS


  • No labels