Loftware Enterprise SP v5.1 Release Notes

When a Data Service with a Data Link was being called from a Business Rule an "Unable to create a connection pool for url” error is thrown.

The scanned barcode result and the human-readable value for a barcode with check digit set to Mod 43 may be different if the number of characters is less than the Max Chars setting.

When printing to a device configured for the Zebra Family Driver (ZPLII), custom commands do not work if the ‘Print Label As Image” option is checked.

The Spectrum website was allowing redirection to another URL based on external input.

When designing a label, if the Document DPI is set to 1200 and a code128, or code39, barcode has an x-dim between 6.4 and 9.6, the last few bars are being cut off. This occurs in Design view and on the printed label.

Specific instructions for configuring the Loftware Print Agent using HTTPS were omitted.

The documentation for Multi-site deployment neglected to state that HQ and the Facilities must be the same Spectrum version.

There was a limitation that SuperAdmin was not allowed to change the passwords for MultiAdmin, JVMAdmin, and Integration User.

When sending a System Message in System Administration, the message and bell icon was not displayed until a user signed out and back in.

When using Bulk Device Import to update the Remote Site associated with a device, the device is not listed under the Remote Site until an update is made in the UI.

After applying 4.7.1 PDF HF1 and printing to PDF, some images appear to be stacked on top of each other, even though they preview correctly.

When two labels are open in Label Design, and the zoom is set to 200%, the barcodes appear smaller when switching between the two labels.

When using the transfer utility, certain labels were failing with the error: "Text Box: java.lang.indexOutOfBoundsException: Index: 0, size: 0”.

Several issues were addressed:

• Unable to perform Print and Print Preview under the "Reprint” option in Job Queue.
• A DataMatrix barcode was showing incorrect data when scanned.
• When performing a Print Preview, then selecting the Print button, the job was printing to a second device.
• The serial number of the inner label PDF audit does not match the actual printed label.
• Partial print jobs were being errored by Spectrum and displayed the following error: "Failed to process field xxx:null”.

When using a Code39 barcode with a start/end code and human-readable text, Print Preview and Design Print failed to display the "**” between the text data.

When printing serialized labels to a Zebra print engine on a print and apply line, random labels will be missing from the middle of the job.

The Print Preview window prevents any interaction with the UI in the background.

The HTTP Data Service is not reading repeated attributes the same way that a SOAP Data Service does.

In Label Design, when the label is zoomed to 200% and an undo action is performed, label fields become distorted.

Configuring an Oracle Integration with the "Use Secure Connection” set to true and also specify a Spectrum override URL, the resolved Spectrum URL sent to the Oracle system will not be "https//” if the JVM doesn’t have a Secure JVM Port defined.

When configuring a QR Code on a Label, there is no ability to select a discrete symbol size.

The GetLabelTemplates REST call will fail if there is a versioned label that has not been checked in at least once.

When a job id is returned to Oracle via a Spectrum Oracle integration, it is in scientific notation.

When installing the Loftware Spectrum database into Oracle, you may see the following message in the installation log file. This message can be ignored and will not affect your Spectrum environment.

WARNING: possible data loss in character set conversions

When installing or upgrading a facility database in Spectrum, ensure that the name of the folder that you create does not include a space character. Including a space causes the install or upgrade to fail.

When installing a facility database in Spectrum, you may see the following message in the installation log file. This message can be ignored and does not affect the installation.

<In error box> ls_schemas failed. Exiting installer…

After upgrading, the account that Spectrum runs under will be set to the local system account. If you made changes to this account prior to the upgrade, then you will need to reset the account. 

After upgrading, if the encrypt tag is in use for the password field in the jdbc.properties file for the Loftware DaVinci solution, then you must remove it and restart Spectrum in order to launch Loftware DaVinci from Spectrum.

When upgrading, only the contents of the <SPECTRUM_HOME>\product\lib folder are preserved. All other folders and contents thereof, including PDF files associated with jobs sent to the default PDF device (default location: <SPECTRUM_HOME>\product\webapps\ ROOT\pdfs) and third-party JDBC drivers are removed during the upgrade process. Before upgrading, it is recommended that you copy all files that you want to retain after the upgrade to a location outside of <SPECTRUM_HOME>. After completing the upgrade process, copy the files back to their original folder. Also, if a third-party JDBC driver was previously installed, follow the steps in the "Add a JDBC Driver" section in the Loftware Enterprise SP User Guide (online Help).

If you are using a PostgreSQL database on Windows, there are database tasks that are required to be run on a schedule which create and populate archive tables and refresh materialized views. To ensure that these tasks are run regardless of the user that is signed in, do the following:

In the Windows "Task Scheduler" utility, a user can configure the tasks to run regardless of whether the initiating user is signed in or not:

1. In Active Tasks, select the task.

2. Double-click the task.

3. Right-click the task.

4. In the General tab, click Run whether user is logged on or not.

5. Click OK.

After upgrading, if you are using Distributed Services you will need to activate and restart the services related to Barcode Wizard and DaVinci Compare objects on all Spectrum Application Servers. Failure to do so will result in the following error dialog:

Unable to find service instance for service id: XXXXX

The services to activate and restart include the following.

Barcode Wizard folder:

1. bcwELEMENTSTRINGS_READ
2. bcwESTRANDESTRCMPNTS_READ
3. bcwSYMBOLOGIES_READ
4. bcwSYMESTRREQ_READ
5. bcwSYMSANDESTRS_READ
6. bcwWIZARDS_READ

DaVinci Compare folder:

1. DaVinci Compare REST Service

To activate and restart the services, do the following:

1. In Data Services, click File > Version Control > Check out.
2. In the View tab, click Service Management, and then select the check box for all application servers.
3. In the Home tab, click Stop Data Service.
4. Click File > Version Control > Check In.
5. Enter a comment and click OK.
6. Click File > Version Control > Publish.
7. Enter a comment and click OK.
8. In the Home tab, click Start Data Service.

When using the Server > Loftware device with a NiceLabel driver, if a printer connected to the Loftware Print Agent changes DPI, then the new DPI is not updated. A new Server >  Loftware device will need to be created in Spectrum to see the updated DPI setting.

When printing an EAN13 barcode using the Avery Dennison MPCL driver, it is recommended that the barcode be imaged to ensure the XDIM setting is honored.

It is recommended that you clear your browser cache prior to signing in after upgrading.

If you are using Distributed Services and need to remove a Spectrum Application Server, you must restore your Spectrum environment to a backup version before the Spectrum Application Server was added.

If you are using Distributed Services, the option to automatically configure devices is unavailable.

If you are using Distributed Services, the option to automatically configure servers is unavailable.

When using a variable layer in Label Design, note that the Horizontal Alignment and Vertical Alignment controls do not work as expected.

In Business Rule Configurator, using the Relative Path option for a data service can result in an error. It works correctly when the Relative Path option is not selected.

In Print, using the keyboard shortcut F9 to initiate printing to the default printer does not work.

After enabling GDPR with AES encryption, some user data viewed in Spectrum Business Intelligence will be displayed encrypted.

When using Import from Label Design or Object Promotion, the property for the Icon reference of an application object is not preserved.

When using Object Promotion with a Business Rule, Reserved Keys are not processed as expected and will result with an "Object not found" message.

After creating a data service with parameters, the data type of a parameter is read only and cannot be changed. Once a parameter is created, you will need to delete and recreate the parameter in order to change the type.

In the Core Services panel of Service Management, the Object Sync Service, Transaction Sync Service, and Multisite Management Service display a status of Unknown unless a multi-site deployment of Spectrum is licensed and configured.

When opening folders with more than 500 objects, the Spectrum user interface may become unresponsive. It is recommended to organize objects in multiple folders.

Certain device models display the Connection tab when configuring Label Specific Options (LSOs). This tab should not be shown and may cause the connection options to be overridden.

Previewing a label to a printer that has an LSO or DSO that has the text box overflow set to Allow Overrun will fail if there is an actual overrun in the label.

Using the arrow keys repeatedly to adjust the position of an object in Label Design may cause it to adjust the vertical or horizontal position as well. This causes the object to move in a diagonal pattern.

When importing a CSV file into a Cross Reference table within Spectrum and an error occurs, the error will be reported as occurring on row 1 regardless of the row the error occurred on.

A Data Service which previously used a Data Link, but was subsequently removed, will fail Object Promotion referencing the removed Data Link. To resolve the issue:

1. Open the Data Service.
2. Check the Data Link check box.
3. Delete the value in the Data Link edit control and click Save.
4. Clear the Data Link check box and click Save.

Customers that deploy Spectrum in their private cloud on AWS Linux 2, or RHEL9 could see the following error in the Spectrum.log:

"Java.lang.error: Probable fatal error: No fonts found.”

This can be resolved by running the following command:

"yum install fontconfig -y”

It can also be installed from https://www.freedesktop.org/wiki/Software/fontconfig

If you are upgrading from Spectrum 5.0 or earlier, are using an SAP BC-XOM integration, and are using the Loftware Spectrum Command Line Interpreter (CLI), Loftware recommends that you replace the Loftware Spectrum CLI with Loftware Integration Command Line Interpreter (CLI) for SAP Applications version 3.0. For more information, see Getting Started with Loftware Integration Command Line Interpreter (CLI) for SAP Applications.

If your Loftware database is in Oracle, you must install Spectrum 5.0 before upgrading to Loftware Enterprise SP 5.1. If you are using a version earlier than Spectrum 5.0, you cannot upgrade directly to Loftware Enterprise SP 5.1. Instead, you must first upgrade to Spectrum 5.0. To upgrade from a version earlier than Spectrum 5.0, follow these steps:

1. Upgrade to Spectrum 5.0. For more information, see "Upgrading Loftware Spectrum" in the 5.0 Installation and Configuration Guide.
2. Upgrade to Loftware Enterprise SP 5.1. For more information, see "Upgrading Loftware Loftware Enterprise SP" in the 5.1 Installation and Configuration Guide.

Ensure that all jobs have completed before stopping a File Drop integration. If the integration cannot be restarted, a restart of the Loftware Spectrum service is required.

Starting with Spectrum 4.0, applications are run in an HTML5-based interface. This requires that the forms that are used by your application must use a font that is licensed as installable. The following fonts are available with Spectrum for use on a form:

1. Arial
2. Arial Unicode MS
3. Verdana
4. Courier New
5. Helvetica
6. Times New Roman

If you have upgraded from a version prior to Spectrum 4.0 and you have a form that is using a font that is not listed above, then Arial will be selected by default. If you would like to use a different font, then you can use the Spectrum Font Management capability to add a new font for use on a form. See the "Use Fonts in Forms” section in the Loftware Enterprise SP User Guide (online Help).

If you have upgraded to Spectrum 5.0 and are using Applications, note the following:

Because the default color of buttons has changed, if a button was added to a form and was created using the default fill color, then it will continue to display the previous blue color. If you add a new button, it will display in the new default blue color. These are the default colors of the button. The button fill color can be changed by the user.

The same does not hold true for other control types that appear in forms. For example, check boxes and drop-downs that existed prior to the color changes will now appear with the new default blue color. The colors used for these controls cannot be changed by the user.

When upgrading Spectrum, or applying a hotfix which replaces a server.war file, and the "\webapps\spectrum-server\web-inf\classes\beans.xml” file has been customized, the instructions should state that a backup of the beans.xml needs to be captured prior to the upgrade. Once the upgrade is complete, a comparison of the beans.xml backup and the current bean.xml file should be done and any deltas should be brought to the attention of Technical Support or PSG for verification before implementing the new beans.xml file.