Monthly Release Notes - April 2017

Jump to:

Automate	Bytware	CCSS	Document Management (RJS)
GoAnywhere	Halcyon	Insite	Intermapper
Powertech	Robot	Safestone	Sequel
Showcase

CCSS

QMessage Monitor

Version 8.11

We removed the limitation on the number of records you can have with QHST monitoring.
We updated V7R3 support for MMAUDJRN monitoring.
The MMAUDJRN queue won’t fail even if the message queue is full.
Monitoring two message queues with the same name no longer fails.
An issue that caused systems to drop due to CPF2526 “job message queue cannot be extended” has been fixed.

QMessage Control

Version 4.11

We fixed a problem with SMS sending and time zones.

Document Management (RJS)

DeliverNow

Version 1.2.12

Fixes

Fixed issue when checking a document into WebDocs, it was getting assigned to the literal route “*” when “* No Route” is selected.
Fixed issue when checking a document into WebDocs iSeries when index information contains a single quote.
Fixed issue when reading an RDX file that contains characters outside the English character set.
Fixed issue when DeliverNow tries to send emails when “Email Report on Error” is enabled.

Webdocs

Version 1.9.0

Enhancements

In-browser Viewing with support for PDF, DOCX, TIF, JPG, and PNG files.
Add annotations using highlighter, rubber stamps, text boxes, sticky notes and more.

Fixes

Fixed issue when executing a URL Search in WDW, the results list contains bad "View" icons.
Fixed issue where customer was unable to delete a document.
Fixed issue where WebDocs Search Results, Date Added sort, doesn't work properly. The values are treated as strings instead of dates.
Fixed issue where date and version is reversed in WD 1.8.5.
Fixed issue where user was unable to delete a document from the Search screen.

NOTE:

Some of the images and tables, which are embedded in any .docx files might not be viewable through In-browser viewing feature, but can be viewed through native Microsoft Word Application. HelpSystems is aware of this issue and it will addressed through upcoming releases.

GoAnywhere

GoAnywhere MFT

Version 5.5.0

Agents

GoAnywhere Agents provide real-time remote workflow and file transfer capabilities that are controlled from a central GoAnywhere MFT server. Agents can be deployed to virtually any operating system including Windows, Linux, IBM i and other platforms. Agents can run on systems inside an organization’s network to move files throughout the data center. Additionally, you can deploy Agents to remote sites like branch offices, cloud environments like Amazon AWS, Azure, and other remote locations. When an Agent starts up, it will connect to GoAnywhere MFT which will then take over management of that Agent.

Agents can run multi-step workflows on the systems where they are installed. These workflows can copy files, archive files, translate data, add data to a database, execute native commands, or other file system tasks. Workflows on Agents can be scheduled to run on a recurring basis.

Agents can also monitor for new, modified, and deleted files on its file system. When a file is found, Agents can process the file locally or call a Project workflow on GoAnywhere MFT.

GoAnywhere MFT acts as the central point of control to manage all Agents which are connected to it. Admin users in GoAnywhere MFT will configure the work that should be performed on its Agents. Administrators can also view events that occurred, such as file transfers or completed jobs on those Agents.

Agents can be grouped together to simplify setup and configuration. This allows administrators to define tasks that should run on all Agents in a group. For example, an organization that has hundreds of retail stores can easily send out new files to each store in the group. Or, a group of Linux servers can be defined to execute the same SSH commands on all Agent systems at once.

Agent Features

Listed below is a summary of features in GoAnywhere Agents:

Secures file transfers between Agents and the central GoAnywhere MFT environment.
Authenticates Agents connections using X.509 certificates.
Monitors for new, modified, and deleted files on Agent systems.
Compresses and decompresses files on the Agent systems using Zip, Tar, and Gzip standards.
Translates data to/from databases, CSV, Fixed Width, XML, and JSON.
Executes native commands on Agents.
Controls which folders are accessible on Agents.

Administrator users in GoAnywhere MFT can work with Agents using the following features:

Create Agent Templates with registration rules to easily deploy Agents on a large scale.
Configure Agents or Agent Groups from the Agent Console on GoAnywhere MFT.
Design Project Workflows to be executed on Agents.
View completed Jobs, active Jobs, or Queued Jobs on for Agents.
Create custom Agent installers from the Software Library.
Automatically deploy Agent upgrades directly from GoAnywhere MFT.

Secure Mail

Added the ability to Request Files from recipients using Secure Mail. This new option will send a unique link to recipients requiring files to be uploaded and returned to the requester.

Secure Forms

Added the ability to submit Secure Forms using RESTful web services.
Added the ability to search for submitted Secure Forms by Job Number.

Administration

Added support for storing GoAnywhere MFT backend tables on the PostgreSQL database system. The "Switch Database" wizard was enhanced to simplify database migration, which will automatically create the tables and migrate existing data to the PostgreSQL database.
Added 26 RESTful web service endpoints to retrieve useful information from GoAnywhere. This information is what is generally shown via Dashboard gadgets.
Enhanced the basic search on the Job File Audit Log page when using the file name field to be case insensitive and inclusive rather than exact match.
Enhanced several auxiliary pages for Monitors and Schedules to save the state of the List pages. When returning from those pages to the list page, all search parameters are remembered and the list is filtered as it was before.
Enhanced the basic and advanced search tabs on Monitors and Schedules to have a consistent search operator 'contains' in both cases.
Enhanced the File Transfer Summary dashboard gadget to include the Secure Forms module type.
Updated FTP upload tasks by adding a success message to the job log per file after it is uploaded.
Updated the Help Documentation pages to have a language code to assist with 508 compliance.
Updated the Help Documentation for 508 compliance by adding visual indication to all links when focused as well as adding a title to the Search input field.
Updated the Admin Log messages to have the same format for changes made to the Admin User and Web User Password Policies.
Updated many pages by dropping the word 'Last' for labels that were Last Modified By and Last Modified On.
Updated the Modified Date and Size columns in the File Chooser dialog to not wrap values keeping them on a single row.
Updated several Audit Log retention periods from a maximum of 999 days to be 9999.
Updated the SOAP message generator based on the WSDL definition to render better in Firefox.
Removed the admin logging for changes made to the isEncrypted password flag on Resources as that setting is hidden since version 5.4.
Upgraded Primefaces from version 5.2.21 to 6.0.10.
Upgraded the embedded Apache Tomcat web server from 7.0.56 to 7.0.73.
Updated the sales and support email addresses on the Help About page to refer to the new HelpSystems ones.
Updated the "Remove All Permissions" button on the Project Permissions page to have a confirmation dialog window to confirm the action.
Updated the SAML process to handle failures better and provide a more useful error message.
Organized the Services main menu section by creating submenus for GoDrive, Secure Mail, Secure Forms, and Agents.

Other Issues

Fixed the quick help documentation for the Response Body field on the REST Get task to indicate the correct default setting which is the job log.
Fixed an issue where downloading as Zip in the Web Client would report a successful status for audit log events when users cancel the download. It now will report a failure status.
Fixed an issue with the Number of Files Copied output variable of the Copy Task could report an inaccurate number in certain cases if files are skipped during processing.
Fixed a minor issue with the Project designer where unnecessary XML tags were added to the Project definition for File Set filters.
Fixed an issue with the Rename action on the FTP, GoFast, and GoAnywhere HTTPS tasks where the File Chooser for the From location was not set to the correct location type.
Fixed an issue with the File Transfer Summary gadget and report could misrepresent statistics when using multiple Domains.
Updated the MySQL database driver from version 5.1.17 to 5.1.40. This fixed an issue with the Limit clause in the SQL Wizard.
Fixed an issue where AS2 messages sent with content type 'application/XML' were not handling case sensitivity correctly. This issue was introduced in 5.4.0.
Fixed a typo on the Security Settings Audit report for the item regarding how FTP should not be allowed for inbound connections unless it is encrypted.
Fixed an issue where the Compose page in the Web Client was not showing the valid locale based on the browser settings. This issue was introduced in 5.4.0.
Fixed an issue with dropdown components on Secure Forms to properly validate valid options when submitted via SOAP web services.

Version 5.4.4

Enhanced the performance of the initial remote snapshot process for GoDrive device synchronization.
Enhanced the performance of the SSH key exchange by only validating algorithms that are enabled on the Task and Resource.
Updated the MQ Send Task to no longer include the JMSXAppID message property by default. A system property 'com.linoma.mq.useLegacyJMSXAppID=true' is added on upgrade to persist behavior of existing installs, however new installs will not include this system property.

GoAnywhere Gateway

Version 2.4.0

April 13, 2017

Added new ‘AgentIP’ session persistence option for supporting GoAnywhere Agent connections through GoAnywhere Gateway.

Insite

Deployment Manager

Version 1.3

Product license key management is now available for Robot, Powertech, and Sequel products. You can add and remove product license keys for active products and HA environments.
Product licenses can be automatically generated and applied across supported products through the use of an ELA (Enterprise License Agreement).
You can now run Audit Reports in Deployment Manager. This feature allows you to view the details of your ELA-generated product licenses, including which products are currently licensed, which licenses have expired, and the overall state of your Insite server.
The Systems page has been expanded to include an Enterprise overview of your products. It lists the products that are installed and staged on your systems, shows you which products have updates available, and alerts you to which products have expiring (or expired) licenses.

Insite

Version 1.12.1

Corrected an issue that prevents users from authenticating Insite with a system that doesn't have RBTSYSLIB installed.

Powertech

Authority Broker

Version 4.16

Work with Profile Switches now allows *Normal switches to be ended. (Previously, only *Timed or *Firecall switches could be ended.) See Work with Profile Switches in the Authority Broker Administrator's Guide.

Command Security

Version 1.10

A loophole where the internal semaphore unlock failed to occur has been closed.
The initial sentence of the help text for the PCSJRNRPT command, which incorrectly referenced a Command Security setting, has been corrected.
F5 (Refresh) for PCS2880 no longer causes an error when the list it displays contains no entries.
PCS2880 no longer displays the incorrect text when the list is empty. (Previously the copyright message would appear in this case. Now the correct message, that no data exists, is displayed.)

Interact

Version 3.09

CEF entries for custom journals are no longer missing the file information (library, file, member).
Commands STRPLIAMON and ENDPLIAMON can now be run outside of the product.
Help text from the Work with Brokers/Agents screen that incorrectly stated all messages sent to QSYSMSG are also sent to QSYSOPR has been corrected.

Network Security

Version 7.11

Performance enhancement: Network Security now attempts job interrupts in a more efficient manner.

Version 7.10

A merge issue impacting installation was resolved.

Version 7.09

A merge issue impacting installation was resolved.

Sequel

Sequel 11

Version R11M07

Enhancements

Repository mode now offers an authentication model that allows for:
- Users don’t require an IBM i profile
- JDE prompting for Environment and Role
- An interface that is based on the folder structure of the Repository
- Use of long object names in both Viewpoint and SWI from the Repository
PostgreSQL database support added.
The TOSTMF path on the EXECUTE command size limit was increased from 128 characters to 2,000 characters.

Fixes

Runtime SQL conversion for SERVER(*LOCALSYS) SYNTAX(*SEQUEL) displays the error QRY2232 ‘Cannot translate SQL from *SEQUEL syntax to standard SQL’ when field was named MOD.
After installing R11M05, processes writing to the QNTC folder no longer created a file.
When user defaults are set to Versioning and the view (*USRSPC) had an Authorization List to secure the object, re-saving the view would remove the Authorization List.
The Viewpoint Universal drivers for an ADS or JDE connection was initially designed with an internal limit for the longest string that can be passed of 9999 characters. The limit was increase to 20,000.
OPNSQLF on a DDM file at V7R2 failed with the error ‘Value specified in UFCB (User File Control Block) is not valid at offset 151’.
Some views return a "SQL0305 Indicator Variable Required" error when no records are returned using *LOCALSYS connection.
Versioned output was not produced if the target folder did not exist. Now the folder will automatically be created.
Using EXECUTE to email PDF results when no records are selected, and user defaults are set to ‘Send if No Data No’ results in error EML0070 ‘Spool file attributes not eligible for selection’.
When emailing view or host table output that exceeds 132 width and no records were selected, and the user defaults were set to send the email, the email was not sent because the second, not the first spooled file was searched for.

Viewpoint

Version 11.17.104

Enhancements

Dashboards now have a setting for Default Font.
The Viewpoint log now includes the date and time in the filename like so: VPlog_02242017_113011.txt. Files older than 7 days will automatically be deleted.
New command line switch added to allow logging to be turned on without the warning message to the user /z:q

Fixes

View Designer (with server connection of remote—not *LOCALSYS or *SEQUEL) displays error ‘SQ9999 Error occurred in SQL Call Level Interface’ when switching to the Files & Fields and there is an alias field used mixed as “SumLval70”.
View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) removed the GROUP BY clause when switching to the Files & Field tab and view contained a WDATA on the SELECT clause.
In View Designer Files & Fields tab (for *LOCALSYS views only) derived fields that result in a DATE data type will now apply a type of DATE in the TYPE field.
In View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) the Expression Editor to build the WHERE clause should use the AltName of an expression, not the expression itself.
In a *LOCALSYS view, when building conditions in the WHERE clause Expression Editor, file identifiers are included when you select fields from files and not variable names.
Opening a view in View Builder when files are not library qualified on FROM clause displays error 'A library is required for selection'.
Application open in design will now detect any changes made to the view.
Temporary files created by the Viewpoint OLE DB Provider will now be deleted.
Emailing IBM i joblog from Viewpoint when there is a single apostrophe in the message text, failed to deliver email.
When saving a client report over a view with either a numeric or an expression type variable (with no default value), will return an error that the value is not a valid numeric value for the numeric variable, or a syntax error for the expression type variable.
Running a dashboard from a Viewpoint shortcut (.vpt) multiple times could produce a ‘runtime automation’ error message. Problem introduced in VP 11.16.294.
Viewpoint is buffering data from a view when run in a dashboard, even though charts are designed beyond the initial records.
The ability to provide custom edit masks on 7 segment digital gauges has been restored and improved by extending the supported mask from 6 characters to 20 characters.
In Dashboard designer, resizing gauges very often causes the gauge to shrink or disappear.
Running a client report from a script using the REPORT command to email displays the error MCH1210 ‘Receiver value too small to hold result’.
Saving a client report when the view had an Expression (EXPR) variable, without a Default Value, would fail.
In the Script Designer on Windows 10, prompting a second command did not show the command prompter, but the log showed the error ‘there was a problem with DLL: cwbunapi.dll’.
From the Excel Add-in, Refresh All was not working with two views from two different hosts.
From the Excel Add-in, when refreshing data if a prompted view returns no records, the current data is not blanked out.
From the Excel Add-in, when refreshing all variables, even if from different views, will combine into one prompt.
Dynamic Drill Down and Show Details option display syntax errors when the view used WDATA.
Viewpoint Administrator will now all you to delete a remote server entry.
A .vpt shortcut to create PC file without /D switch should prompt for path information.
The Import > Query option will now use the SERVER and SYNTAX settings from the User’s defaults.

Sequel Web Interface

Version R10M26

Enhancements

When a user is restricted from an object or folder, they will no longer see the object or folder in the list.
Unwanted folders can now be removed from the Repository tree provided user is authorized.

Fixes

A dashboard containing a view with subtotals and the tool bar is hidden did not complete running.
Negative values in a client table do not graph in using a SWS connection.
Using a SWS connection, file locks and license locks are not released with buffered results (greater than 100 records returned).
Using both a SWI and SWS connection, the DB List box of a variable will not be entry capable.
Views using Database *LOCAL or *LOCALSYS with a variable with DB Lists that display a field value, and pass that same value to the view did not display the list of values.
Using a SWI connection, Dynamic Regrouping and including derived field generates a syntax error.
Running a host table with either a SWI or SWS connection, and with Sequel Auditing turned on, scrolling down past 100 records, would cause the buffering to freeze.
Saving results to .xlsx from a view that returns results containing a null value, Excel will not open the resulting file, instead issuing the message: ‘File format or file extension is not valid’ when running a repository object from SWS.
When emailing host report results from SWI, either after results are displayed, or directly from the SWI explorer screen, the user is prompted for variables and email, but then fails with error: Value '...' for TITLE exceeds 50 characters.
Digital Gauges do not refresh on a dashboard in SWI/SWS when the Reprompt option is chosen.
When defining an IBM host in SWS, the connection URL is now created to include ‘naming=system’.
Rare circumstances result in the following error when running a client table on a SWS server in Host mode: ‘PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException’.
Digital gauges on dashboard run in SWI or SWS only display for a single data window. Second data source gauges remain a value of zero.
In Chrome with a SWI connection, a blank page was rendered until F5 (to refresh) was pressed.

Esend

Version R03M54

No updates for this version.

Abstract

Version R10M40

The following Updates are included in this version:

Numerous MCH3402 errors are generated while analyzing a very large number of objects resulting in the creation of hundreds of spooled job logs, each of considerable size. This is causes the cross-reference load process to perform poorly and even hang in some cases.

Anydate

Version R02M16

No updates for this version.

Showcase

Showcase 10

Version R10M07

Enhancements

Repository mode now offers an authentication model that allows for:
- Users don’t require an IBM i profile
- JDE prompting for Environment and Role
- An interface that is based on the folder structure of the Repository
- Use of long object names in both Viewpoint and SWI from the Repository
PostgreSQL database support added.
The TOSTMF path on the EXECUTE command size limit was increased from 128 characters to 2,000 characters.

Fixes

Runtime SQL conversion for SERVER(*LOCALSYS) SYNTAX(*SEQUEL) displays the error QRY2232 ‘Cannot translate SQL from *SEQUEL syntax to standard SQL’ when field was named MOD.
After installing R11M05, processes writing to the QNTC folder no longer created a file.
When user defaults are set to Versioning and the view (*USRSPC) had an Authorization List to secure the object, re-saving the view would remove the Authorization List.
The Viewpoint Universal drivers for an ADS or JDE connection was initially designed with an internal limit for the longest string that can be passed of 9999 characters. The limit was increase to 20,000.
OPNSQLF on a DDM file at V7R2 failed with the error ‘Value specified in UFCB (User File Control Block) is not valid at offset 151’.
Some views return a "SQL0305 Indicator Variable Required" error when no records are returned using *LOCALSYS connection.
Versioned output was not produced if the target folder did not exist. Now the folder will automatically be created.
Using EXECUTE to email PDF results when no records are selected, and user defaults are set to ‘Send if No Data No’ results in error EML0070 ‘Spool file attributes not eligible for selection’.
When emailing view or host table output that exceeds 132 width and no records were selected, and the user defaults were set to send the email, the email was not sent because the second, not the first spooled file was searched for.

Viewpoint

Version 10.17.104

Enhancements

Dashboards now have a setting for Default Font.
The Viewpoint log now includes the date and time in the filename like so: VPlog_02242017_113011.txt. Files older than 7 days will automatically be deleted.
New command line switch added to allow logging to be turned on without the warning message to the user /z:q

Fixes

View Designer (with server connection of remote—not *LOCALSYS or *SEQUEL) displays error ‘SQ9999 Error occurred in SQL Call Level Interface’ when switching to the Files & Fields and there is an alias field used mixed as “SumLval70”.
View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) removed the GROUP BY clause when switching to the Files & Field tab and view contained a WDATA on the SELECT clause.
In View Designer Files & Fields tab (for *LOCALSYS views only) derived fields that result in a DATE data type will now apply a type of DATE in the TYPE field.
In View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) the Expression Editor to build the WHERE clause should use the AltName of an expression, not the expression itself.
In a *LOCALSYS view, when building conditions in the WHERE clause Expression Editor, file identifiers are included when you select fields from files and not variable names.
Opening a view in View Builder when files are not library qualified on FROM clause displays error 'A library is required for selection'.
Application open in design will now detect any changes made to the view.
Temporary files created by the Viewpoint OLE DB Provider will now be deleted.
Emailing IBM i joblog from Viewpoint when there is a single apostrophe in the message text, failed to deliver email.
When saving a client report over a view with either a numeric or an expression type variable (with no default value), will return an error that the value is not a valid numeric value for the numeric variable, or a syntax error for the expression type variable.
Running a dashboard from a Viewpoint shortcut (.vpt) multiple times could produce a ‘runtime automation’ error message. Problem introduced in VP 11.16.294.
Viewpoint is buffering data from a view when run in a dashboard, even though charts are designed beyond the initial records.
The ability to provide custom edit masks on 7 segment digital gauges has been restored and improved by extending the supported mask from 6 characters to 20 characters.
In Dashboard designer, resizing gauges very often causes the gauge to shrink or disappear.
Running a client report from a script using the REPORT command to email displays the error MCH1210 ‘Receiver value too small to hold result’.
Saving a client report when the view had an Expression (EXPR) variable, without a Default Value, would fail.
In the Script Designer on Windows 10, prompting a second command did not show the command prompter, but the log showed the error ‘there was a problem with DLL: cwbunapi.dll’.
From the Excel Add-in, Refresh All was not working with two views from two different hosts.
From the Excel Add-in, when refreshing data if a prompted view returns no records, the current data is not blanked out.
From the Excel Add-in, when refreshing all variables, even if from different views, will combine into one prompt.
Dynamic Drill Down and Show Details option display syntax errors when the view used WDATA.
Viewpoint Administrator will now all you to delete a remote server entry.
A .vpt shortcut to create PC file without /D switch should prompt for path information.
The Import > Query option will now use the SERVER and SYNTAX settings from the User’s defaults.

Sequel Web Interface

Version R10M26

Enhancements

When a user is restricted from an object or folder, they will no longer see the object or folder in the list.
Unwanted folders can now be removed from the Repository tree provided user is authorized.

Fixes

A dashboard containing a view with subtotals and the tool bar is hidden did not complete running.
Negative values in a client table do not graph in using a SWS connection.
Using a SWS connection, file locks and license locks are not released with buffered results (greater than 100 records returned).
Using both a SWI and SWS connection, the DB List box of a variable will not be entry capable.
Views using Database *LOCAL or *LOCALSYS with a variable with DB Lists that display a field value, and pass that same value to the view did not display the list of values.
Using a SWI connection, Dynamic Regrouping and including derived field generates a syntax error.
Running a host table with either a SWI or SWS connection, and with Sequel Auditing turned on, scrolling down past 100 records, would cause the buffering to freeze.
Saving results to .xlsx from a view that returns results containing a null value, Excel will not open the resulting file, instead issuing the message: ‘File format or file extension is not valid’ when running a repository object from SWS.
When emailing host report results from SWI, either after results are displayed, or directly from the SWI explorer screen, the user is prompted for variables and email, but then fails with error: Value '...' for TITLE exceeds 50 characters.
Digital Gauges do not refresh on a dashboard in SWI/SWS when the Reprompt option is chosen.
When defining an IBM host in SWS, the connection URL is now created to include ‘naming=system’.
Rare circumstances result in the following error when running a client table on a SWS server in Host mode: ‘PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException’.
Digital gauges on dashboard run in SWI or SWS only display for a single data window. Second data source gauges remain a value of zero.
In Chrome with a SWI connection, a blank page was rendered until F5 (to refresh) was pressed.

Esend

Version R03M54

No updates for this version.

C&DS Migration Utility

Version 10.17.104

Fixes

When Showcase 9 DBQ's are migrated that use JD Edwards Date Fields, an Alt Name is assigned/imported. This caused Viewpoint to interpret it as a derived field, and the JDE column headings are not displayed.
If a variable name contains an accented character (i.e. É, é, È, è, Ê, ê, Ë ) the letter will be converted without the accent.
Reports migrated whose database connection uses the Viewpoint driver either for Advanced Database Security or JDE, did not migrate well. Formatting attributes from the original report were missed.
JD Edwards Decimal fields are migrated with extra formatting that's not needed. This makes ViewPoint think that they are a derived field and the JDE column heading is not displayed correctly.
Improved migration of .rpt reports when PES file contains mixed data sources which prevents reports from being created without detail fields.

Copyright © Fortra, LLC and its group of companies.
All trademarks and registered trademarks are the property of their respective owners.
Last Published: 202405011210