Release 2019.2 is now available. This patch contains a number of bug fixes and refinements. We will begin scheduling 2019.2 updates on customer Test systems starting April 22nd, 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 .Release Notes v2019.2#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

Release 2019.2.4 (06-20-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

When processing Monthly Recurring Charges that were Stopped on the Billed Through Date the billing process was incorrectly generating Bill Details transactions. The process should only flag the charge as Billing Complete and not generate any Bill Details transactions.

IN201935378

Release 2019.2.3 (05-23-2019)

Component	Description	Type	Incident(s)	Documentation
API	To address a rapidly growing API Request table, full API responses will not be saved for successful SQL POST calls or GET API Calls; only error responses will be saved.		IN201935671

Release 2019.2.2 (05-10-2019)

Component	Description	Type	Incident(s)	Documentation
API	The permissions set on each API Endpoint are now obeyed when called from a Custom Endpoint.			Custom API
Escalations & Notifications	Added a process to convert the Escalation Sequences to the new format used in 2019.1.		IN201935672

Release 2019.2.1 (04-25-2019)

Component	Description	Type	Incident(s)	Documentation
General	Corrected a missing parameter from the Initial 2019.2 release.

Release 2019.2 (04-19-19)

Component	Description	Incident(s)	Documentation
API	Reworked the API Error Responses to be consistent for all endpoints.		API
Cable	Fixed an issue where using the general search on the Ports/Pins/Lens grid (on the Equipment form) would throw an error.	IN201834888 IN201935103
Communications	Added COR functionality to the Avaya module.		Communications Module Avaya COR
Communications	Added Avaya Authorization Code functionality.		Avaya Authorization Codes
CustomerCenter	Added Package Types.		Service Desk Packages Packages
	On the Order Details Form: Changed the "Apply All" label to "Apply Order Details". Changed the "Yes" option to "Overwrite All Order Details".		Order Details
	The Location Picker was displayed on every Catalog page; now it is only displayed on the page when items on that page have Location Restrictions.		Add a Service Add Equipment
	Fixed an issue where long Package Descriptions (with line breaks) were causing layout inconsistencies on the Packages page.		Service Desk Packages Packages
	The Additional Charges section now displays the text "none" when no charges exist (instead of a blank line).
Events & Notifications	Fixed an issue causing Events to fail during the fall Daylight Savings Time transition.
General	The following functions, keywords and classes are now allowed in Custom Logic: new DateTime DateInterval add sub diff format setTimestamp setTime setDate		Custom Logic Syntax How To: Scheduling Regular Maintenance
	Improvements to Custom Validation Messages The Customer Name is displayed on the first line of message. This includes messages generated from a form, the API or Imports. The Error Dialog title was changed to "Error (Custom Validation)" to identify Custom Error messages. The Warning Dialog title was changed to "Warning (Custom Validation)" to identify Custom Warning messages.		Custom Validation
	Fixed an issue with Custom Validation where improperly formatted code in the validation message would trigger an "Oops Error" instead of displaying the appropriate error message.
	Fixed an issue where some pickers would not load the Default Perspective.	IN201833946 IN201834044
	Fixed a variety of display issues related to HTML in Remarks data. HTML entered into the system via the API, Imports or the Remarks form is now filtered to remove any potentially problematic or malformed HTML.	IN201832912 IN201732074 IN201832314	Allowed HTML Tags
Imports & Exports	Fixed an issue causing Exports to fail when manually triggered from the Exports Files grid.
	Removed several unused columns from Import Definitions.		Database Changes
	Fixed an issue where Authcode Calls were not always rated using the correct call type for local or long-distance calls.
Reporting	Fixed an issue preventing the Crystal Report Batch process from sending the completion message. Fixed an issue preventing the Crystal Report Batch process from deleting Event the Batch is linked to.	IN201834202
Service Desk	Fixed an issue where Service Desk Remove Actions removed the Location on the Service after completion of the Action.	IN201833926
	Fixed an issue where returning Equipment with a credit charge was applying a double credit after the return (rather than a Debit to cancel out the original credit).	IN201833399
	Fixed an issue where the Service Desk Auto-Assign was not filtering by the Location selected on the Action.

Database Changes in 2019.2

Table Name	Change	Table 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	ADD COLUMN HTML_REMARKS NO NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
GLA_ACTIVITY	update	ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS
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

Release 2019.2.4 (06-20-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Release 2019.2.3 (05-23-2019)

Component

Description

Type

Incident(s)

Documentation

API

Release 2019.2.2 (05-10-2019)

Component

Description

Type

Incident(s)

Documentation

API

Escalations & Notifications

Release 2019.2.1 (04-25-2019)

Component

Description

Type

Incident(s)

Documentation

General

Release 2019.2 (04-19-19)

Component

Description

Type

Incident(s)

Documentation

API

Cable

Communications

CustomerCenter

Events & Notifications

General

Imports & Exports

Reporting

Service Desk

Database Changes in 2019.2