Monthly Release Notes - June 2018

Jump to:

Document Management (RJS)


DeliverNow

Version: 1.2.13
Enhancement
  • Updated how passwords are rendered to the web interface.
Fixes
  • Fixed issue when downloading reports from IBM i.
  • Fixed issue to allow the delivery to multiple destinations with an output format of ASCII Text *PRTCTL.
  • Fixed issue to allow email to be sent when TLS 1.0 is disabled.

Back to Top

 

GoAnywhere


Version: 5.7.4
  • Added the ability to specify the character encoding in the Write JSON task's output files.
  • Added the ability to specify the character encoding in the Read JSON task's input files.
  • Fixed an issue where selecting a user from a gadget or audit log would not properly filter the destination list page for the selected user.
  • Fixed an issue with the Cloud Connector cleanup process that caused extra background processes to unnecessarily run.
  • Fixed an issue in the Software Library where new versions of Agent Installers were not removing all install files from previous Agent versions.
  • Fixed an issue where the SFTP service was not logging audit entries for failed uploads and failed downloads in some cases.
  • Fixed an issue where the FileInfo function for Agent files was not returning any file information.
  • Fixed an issue where the FileInfo function, when used to lookup Resource file objects, was not properly handling authority checks in certain cases.
  • Fixed an issue where the Web User Manager page could generate null pointer errors to the server log.
  • Fixed an issue where some images do not appear in Internet Explorer 11 within the GoAnywhere web help. This issue was introduced in 5.7.0.
  • Fixed an issue where the Agent upgrade process can fail if the transfer of the upgrade file takes longer than 60 seconds.
Version: 5.7.3
  • Updated the LDAP login method implementation to use certificates from the Key Management System instead of the default trusted certificates file.
  • Upgraded the jackson databind, core, and annotations libraries from version 2.9.4 to 2.9.5.
  • Fixed an issue where deleting a file on an agent would fail after the file is uploaded to the GoAnywhere MFT server. This issue was introduced in version 1.2.0 of GoAnywhere Agents.
  • Fixed an issue where SMB (all versions) Resource information was not appearing in the help documentation. This issue was introduced in 5.7.0.
  • Fixed an issue where some functionality, such as the Azure Blob Storage Resource Test and the Dashboard News and Tips gadget, would not function correctly when GoAnywhere was in FIPS mode.
  • Fixed an issue where the Amazon S3 file chooser would display a 500 error when accessed from an IBM i or Unix/Linux installation.
  • Fixed a cross site scripting issue where some user configuration fields were not properly escaping the contents of the field when rendered to the administrative UI. This issue was introduced in 5.7.0.
  • Fixed an issue where the IP Filter settings could not be saved when GoAnywhere was using a database that is case sensitive.
Version: 5.7.2
  • Added support for MySQL 8.
  • Added the Close RowSet task to the Cloud Connector Designer.
  • Fixed an issue with the new date filter where date formats in certain locales were failing. This was introduced in 5.7.0.
Version: 5.7.1
  • Added the ability to filter the Web User list page by first name, last name, description, email address, and organization. This page was also updated to use the new page filter style.
  • Added the ability for Web Users to download previously sent attachments from the Sent Items page in Secure Mail.
  • Added the Close RowSet task to Agents.
  • Added the ability to view change history for Web User Templates.
  • Added the ability to specify the SSL Context Protocol for the Box Cloud Connector on the Box Resource. The default is TLSv1.2.
  • Added support for using trademark symbols (™) in Project XML files.
  • Added the ability to import encrypted keys into the Key Management System.
  • Added support for double and triple byte characters with the new URL Encode and Decode functions.
  • Enhanced the GoAnywhere Command Cloud Connector to include the Test Resource functionality.
  • Enhanced the SQL Wizard to only allow a single table to be selected when building Insert, Update, and Delete queries.
  • Enhanced the SQL Wizard to ensure values for insert and update fields are qualified with surrounding quotes when needed.
  • Enhanced the process that updates the Last Executed On date of a Project to be an auto-commit database transaction.
  • Enhanced the Job execution life cycle to use auto-commit database transactions when applicable.
  • Enhanced Agents to support the new master keys defined in GoAnywhere MFT.
  • Enhanced the Delete Project REST command to return a more descriptive error message if the target Project does not exist.
  • Enhanced the Recent File Activity Gadget to include file audit events from Project Workflows.
  • Enhanced the Monitor list page to search by the Project or Admin User defined on the Monitor.
  • Enhanced the Cloud Connector designer to properly handle attempts to drag and drop components where they are not supported.
  • Enhanced the Cloud Connector Marketplace to only show Cloud Connectors that are compatible with the version of GoAnywhere the user has installed.
  • Enhanced the Cloud Connector Management screen to refresh the Marketplace when the add button or the refresh button is clicked.
  • Modified the Add Web User command of the GoAnywhere Command Cloud Connector to properly escape slashes in the JSON payload for the Web User's home directory.
  • Updated the Marketplace client to handle HTTP redirects in the event the location is changed in the future.
  • Improved the performance of sequence ID generation for audit events and Job execution.
  • Improved the error message for the REST interface of the Import Monitor command when importing a Monitor that already exists. This message now includes the name and location of the existing Monitor.
  • Improved the GoDrive database transaction events to better prevent database locks when files are uploaded to GoDrive.
  • Improved inline FTP file operations by removing GoAnywhere's dependency on the STAT command when submitting commands to a server.
  • Updated the SFTP and FTPS file choosers to display the appropriate protocol versus displaying FTP.
  • Consolidated Basic and Standard Agent licenses into Standard on Agents.
  • Enhanced the GoDrive Media Viewer Comment panel to provide paragraph formatting options such as font family, size, colors, and more.
  • Fixed an issue where using the Move task in an Amazon S3 bucket may not overwrite an existing file in the destination directory.
  • Fixed an issue where submitting a Secure Forms with an editable drop down component would cause 500 an internal server error. This issue was introduced in 5.7.0.
  • Fixed an issue where the Switch Database progress bar was not rendering correctly. This was introduced in 5.7.0.
  • Fixed an issue where Secure Mail could send a duplicate email from the Web Client if there was a failed message in Draft status.
  • Fixed an issue in the HTML file uploader when navigating away from a page while an upload is occurring that would produce a JavaScript error. This issue was introduced in 5.7.0.
  • Fixed an issue where Cloud Connector Addon Workspaces were not being cleaned up at the end of a project. This was introduced in 5.7.0.
  • Added quotes to the filename parameter of the content-disposition on the REST Multipart Post task.
  • Fixed an issue where downloading files as ZIP from Amazon S3 would sometimes create an empty file.
  • Fixed an issue where deleting files from a root folder of an SMB(v1) share would fail when accessing it as a Web User virtual folder on the FTP/S server.
  • Fixed an issue where the Send Email task would fail if the CC (carbon copy) field was used. This issue was introduced in 5.7.0.
  • Fixed an issue where some file transfer operations could fail on an Amazon S3 Resource immediately after creating a new directory in an S3 bucket.
  • Enhanced the File Transfer Activity Report to include file audit events from Project Workflows.
  • Fixed an issue where the SCP Move task would report the wrong file size in the job log when a file was moved to another resource.
  • Updated the SSL Certificate Change History page to prevent line wrapping when the certificate names are long.
  • Fixed an issue where Network Shares resource for SMB (all versions) was not properly handling share names that started with a leading slash.
  • Fixed an issue where certain database systems where not properly handling case sensitivity for the Master Key Alias.
  • Fixed an issue where a REST, SOAP or GACMD request to remove an SSH Key association did not work when the Web User only had one SSH key and that key was not in the default key vault.
  • Fixed an issue where searching the Automatic IP Blacklist resulted in an Unknown Error. This was introduced in 5.7.0.
  • Fixed an issue where the Read JSON Task did not use a comma ',' as a default separator in some cases.
  • Fixed an issue where an updated Cloud Connector did not display the correct version.
  • Fixed an issue where links added to the GoDrive comment editor and the Media Viewer comment editor can sometimes display incorrectly.
  • Fixed an issue where an unlicensed version of GoAnywhere that uses the internal Derby Database sometimes displays unnecessary error messages to the startup log. This issue was introduced in 5.7.0.
  • Fixed an issue where IE11 was not rendering all Resource icons correctly.
  • Fixed an issue where the cookie enabled check was causing vulnerability scans to flag the test cookie as insecure.
  • Updated the View Schedule page to properly display the month at the top of the calendar while navigating.
  • Fixed an issue where importing a Scheduled Job referencing a non-existent Master Encryption Key would throw a NullPointerException.

Back to Top

 

IBM Partnership


Backup, Recovery, and Media Services (BRMS)

Version: PTF 7.3 SI67946, 7.2 SI67312, 7.1 SI67311
Enhancements
  • In 7.1 and later, BRMS cloud turn key control groups are being enhanced to use any user specified ASP storage for virtual media that is created for cloud transfers.
  • In 7.1 and later, BRMS volume selection has been enhanced to ensure WORM media are only returned if the media class being used is set with the Write once media value set to *YES.
  • In 7.2 and later, the DSPLOGBRM command has been enhanced to support a list of message identifiers on the MSGID() parameter to display or include in the report.
Other Fixes
  • In 7.1 and later, backups are showing excessive file open and close operations to the QA1ANET2 file in QUSRBRM.
  • In 7.1 and later, WRKSPLFBRM does not show correct spooled files when doing a parallel backup of an object list.
  • In 7.2 and later, GUI omits are not being honored if using the BRMS wiki documented interface to control which control groups will not use the select user space code.
  • In 7.3 and later, the BRMS menu selection shows incorrectly translated text on the BRMS Web GUI client.
  • In 7.1 and later, BRMS automatic cloud backups using a user profile with only *SAVSYS authority fails with MSGCPFA09C, MSGCPFBC02, and MSGBRM148A.
  • In 7.1 and later, if there are more than 10,000 media sets in saved history, STRRCYBRM or STRMNTBRM fails with MSGMCH0603.
  • In 7.1 and later, RSTLIBBRM using OUTPUT(*OUTFILE) posts a MSGCPD2861 message and fails to create the outfile .
  • In 7.1 and later, sequence 1 for expired volumes history records may not be removed when the volume is reused.
  • In 7.1 and later, batch parallel restores may fail with MSGSQL7011.
  • In 7.1 and later, BRMS networked systems are incorrectly allowed to send BRMS changes to a remote system while it is in flash copy mode.
  • In 7.1 and later, STRMNTBRM with RGZBRMDB(*YES) may use large amounts of system storage.
  • In 7.1 and later, RSTBRM using SAVLVL(*SAVDATE) parameter may select incorrect volume(s).
  • In 7.1 and later, DUPMEDBRM receives MSGBRM1483 message for volumes that are expired and available to use.

Rational Developer for i (RDi)

Version: 9.6.0.2
New Features
  • A PDM perspective has been added that has more editor real-estate, a minimal set of relevant views, and prominently features an updated Object Table view for PDM-like navigation.
  • To help first time users get started, they are automatically prompted for a hostname so they can get to work immediately. Together with the PDM perspective and the enhanced Object Table view, this provides a streamlined onboarding experience for users familiar with PDM.
  • Support for the RPG DATA-INTO opcode. DATA-INTO reads the data from a structured document, such as a JSON document, into a data structure. DATA-INTO is similar to XML-INTO, but a parser must be provided seperately.
  • Error annotations in the editor can now be navigated using the Next and Previous Annotation toolbar buttons. The keyboard shortcuts Ctrl+. and Ctrl+, can be used for Next and Previous navigation, respectively. Error navigation includes compile and program verifier Error List errors, ILE RPG live parser errors, and ILE RPG Unreferenced Definition warnings. The combination box toolbar button can select and deselect the types of annotations available in the navigation. This can also be configured through the General > Editors > Text Editors > Annotations preference page. Note that syntax checking errors are always available in the navigation.
  • Trailing spaces are trimmed when a source member is opened so that users can press the End key and move the cursor after the last non-blank position on the line. This is true even for cached local files.
  • Comments preceding an RPGLE subroutine are displayed in a hover in similar manner to a subprocedure. Hovers that do not show any additional information beyond the source line being hovered over are no longer displayed.
Enhancements
  • The Object Table view has been enhanced to make it easy for PDM users to migrate to RDi while still using similar keystrokes and ways of working. It now boasts an embedded quick filter panel to quickly identify a set of items to work with using similar criteria as PDM. A new Option column enables quick entry of PDM options and even user defined commands to act on the library, object, or member in a row. Filters can optionally be named and reused in the Remote Systems Explorer view. Many RSE power users may prefer to work in the enhanced table view because of its ease and power. Similar to F17 in PDM, there is Subset tab to subset a list on a keystroke basis without any communications delay. Additionally, a rich history mechanism provides easy reuse of filter values.
  • Improved ILE RPG outline and hover support for opcodes such as TAG, ENDSR, PLIST, PARM, KLIST and KFLD.
  • ILE RPG Indicators in column 71-76 are now properly shown as modified in outline.
  • Users now can retain the sort state of the Object Table View after refresh.
  • It is now easy to toggle between edit and browse modes using either the Ctrl-Shift-G keyboard shortcut or by selecting "Toggle Edit/Browse Mode" from the Source menu. The icon in the editor tab shows whether a member is in edit or browse mode.
  • Improved Show Block Nesting (Ctrl-Shift-O) to include support for being invoked from ELSE, WHEN and OTHER op-codes. Up to 15 levels of nesting can now be displayed.
  • Variable length database fields are now recognized correctly in the ILE RPG outline view and editor.
  • The hover help for RPGLE KLIST, and PLIST references now show field and parameter lists.
  • In the Error List, the "Remove current list" and "Remove all lists" toolbar buttons will now also remove the corresponding error annotations in the editor.
  • In ILE RPG, comments with lower case spec type like 'd*' are now included in the hover.
  • Hover of error list annotations on the right margin now includes the message ID.
Other Updates
  • SE66032 RDi 9.5.1: CL command prompter does not handle parameter values which use *CAT/*BCAT/*TCAT.
  • SE67408 RDi 9.5.1.2: Automatic uppercase when editing DDS source members with the Remote Systems LPEX Editor is not working.
  • SE67581 RDi 9.5.1.2: IBM i DDM server setting *ENCUSRPWD results in RDi message RSEF1002
  • SE67951 RDi 9.5.1.2: CL command prompter may add quotes when there is more than one string in a parm.
  • SE68317 Outline fails with NPE when ILE RPG proc returns a DS containing a subfield that overlays the DS itself.
  • SE68380 When programmatically creating an IBM i Connection the specified properties are not respected on the JDBC connection.
  • SE68384 RDI 9.5.1.2 Breakpoints not set correctly when the source name ends with the source type
  • SE68490 RDi 9.5.1.2: Unable to remove iProject ignore setting in Remote Reconciler
  • SE68562 RPGLE variables referenced by embedded SQL or the MAIN keyword should not be marked as unused.
  • SE68668 IBM Rational Developer for i 9.5.1.2 snippet imported into RDi 9.6 after insert hangs workbench.
  • SE68675 In RDi 9.6, 'Compare With' from Reconciler comparing iProject and IBM i members shows sequence numbers/dates included in IBM i member.
  • SE68693 RDi 9.6 - Zero percent coverage for all files in report if some files have zero percentage coverage
  • SE68743 RDi 9.6.0.1: The hyperlink feature to move the cursor to a referenced declaration does not work in SQLRPGLE members.
  • SE68745 RDi 9.6.0.1: CLLE prompt dialog throws StringIndexOutOfBoundsException for CL command terminated with ';'.
  • SE68833 RDi 9.6.0.1: LPEX ILE RPG formatter produces incorrect results.
  • SE68874 RDi 9.6.0: 'Full Line' and 'Free Form' settings are not respected with the 'Tab key inserts spaces' unchecked.
  • SE68882 RDi 9.6.0: The class IBMiConnection does not return a JDBC connection when used with Kerberos authentication.
  • SE68883 RDi 9.6.0.1: The ILE RPG SQL formatter may start lines in the wrong column unexpectedly.
  • SE68884 RDi 9.6.0.1: Incorrect display in outline view and hover when a fixed format data structure is followed by a free form data structure
  • SE68885 RDi 9.6.0.1: RPGLE source with qualified or nested subfield defined LIKE database field crashed with StackOverflowError.
  • SE68887 Remote Systems LPEX editor may become unresponsive when editing
  • SE68904 RDi 9.6.0.1: SQL host variables not always recognized by the SQLRPGLE parser.
  • SE68985 RDi 9.6.0.1: Time format special word followed by ':' (colon) delimiter results in "unexpected token" warning in the editor.
  • SE69005 RDi 9.6.0.1: Using LPEX to join (ALT+J) two lines can result in the second line being truncated.
  • SE69158 RDI 9.6.0.1 LPEX cursor position incorrect when Windows scaling is greater than 100%
  • SE69226 RDI 9.6.0.1 Remote Systems LPEX editor may become unresponsive when performing live parsing of RPGLE source
  • SE69256 Editing ILE RPG results in an exception for a RENAME keyword on a file spec with a non-symbol reference. This prevents the outline view and other language intelligence from updating.

Back to Top

 

Insite


Version: 2.3
Enhancements
  • Users can now edit dashboards they do not own if they have been added to the dashboard's edit rights list.
  • When a user attempts to edit a dashboard that is currently being edited by another user, they will now see a message stating the user name of that user. If a user attempts to edit a dashboard that has been recently edited and saved by another user and those changes are not reflected in the view of the current user, they will now see a popup that states 'The user (inserted user_name) has modified the dashboard. It will be reloaded to reflect the changes.'
  • Includes Insite Analytics 1.1. See Insite Analytics.
Other Fixes
  • Fixes for Network Security for Insite.
  • Fixes for Password Self-Help for Insite.
  • Fixes for Deployment Manager.
  • Toggling 'Allow Guest Login' to On within Authentication and then providing mismatched entries in the password fields now correctly displays an error message to the user.
  • There was an issue with the link from status widgets with filtered assets group not properly redirecting to a filtered assets page, but this has now been fixed.
  • Delete buttons are now a consistent color throughout the application.
  • The Vityl IT & Business Monitoring home URL has been changed to better represent the product name.
  • There were some display issues with the Full Screen button when error messages were displayed, but this has now been fixed.
  • Security enhancements have been implemented.
  • An Insite Analytics error message was rendering incorrectly on the Alerts screen, but this has now been fixed.
  • There was an issue with clearing completion codes in Robot Schedule, but this has now been fixed.
  • The full screen icon on a widget now only displays on hover over for non-touch devices.
  • There was a caching issue causing the inability to add widgets for Vityl IT & Business Monitoring, but this has now been fixed.

Back to Top

 

Powertech


Compliance Monitor

Version: 3.29

Consolidator

New Features
  • Validation has been added to the CM2BCHREQ command.
Enhancements
  • A cleanup process has been added to ensure the correct installation files are being used.
Other Updates
  • A file constraint issue no longer prevents the update process from completing.
  • Compliance Monitor user profile PLCM2ADM is no longer vulnerable to removal. This user profile, installed during product installation, is required for proper functioning of Compliance Monitor.
  • Authority Broker reports no longer incorrectly list U:ER as an Error report. (U:ER is a Swap Reason Report.)
  • Descriptive names in log file data filters have been restored.
  • A problem that caused TLS to stop functioning after an OS upgrade from V7R1 to V7R3 has been resolved.
  • A problem causing an inability to email batch assessments has been resolved.
  • Issues with the CM2BCHREQ command that prevented Batch Assessments from running have been resolved.

Endpoint

  • All objects are now included when multiple directories are requested for the Object Limit report.
  • When selecting both IFS and QSYS objects in the Object Limit report, both are now reported (instead of only one).

Network Security

Version: 7.18
  • When converting to Version 7 from a prior version, the correct release information now appears when the conversion completes successfully.
  • The help text for “Create Socket Rule Condition” and “Change Socket Rule Condition” has been changed to list only valid values for the Connector field.
Central Administration
Version 2.21
  • A change was made within the removal of a system that eliminates an MCH3601 error from appearing in Network Security’s PNSEVTMON job log.
  • A change was made within the installation of Central Administration to accommodate user profile objects whose object text cannot convert to Unicode.
  • A change was made within the “Work with Directory Queries” panel PPL2920 to ensure all validation errors are displayed appropriately. Additionally, a F4=Prompt has been added for the External Server field.

Power Admin

Version: 2.16
  • User profiles whose text is defined at the maximum length of 50 are now fully accommodated.

Central Administration Fixes

Version 2.20
  • Installation now accommodates objects that have object text defined at the maximum length of 50.
Version 2.21
  • A change was made within the installation of Central Administration to accommodate user profile objects whose object text cannot convert to Unicode.
  • A change was made within the “Work with Directory Queries” panel PPL2920 to ensure all validation errors are displayed appropriately. Additionally, a F4=Prompt has been added for the External Server field.

Security Scan

Version: 1.2
  • Security Scan now supports SUSE Linux versions 11.x, 12.x, and 15.x, and SUSE PowerLinux versions 11.x and 12.x.

Stand Guard Anti-Virus

Version: 4.1.4 (AIX only)
  • The --delay option now allows you to specify a pause (in milliseconds) as a CPU limiting technique to manage system resources under heavy use.

Back to Top

 

Robot


Robot Console

Version: 7.00
 
New Features
  • Users can now create a secure connection between the IBM i system and the Robot Console GUI within Connection Properties.
Other Updates
  • RBC296 panel parameters now match RBCDLTHST command parameters.
  • Log Monitors no longer show a failed dump status when ended normally if the Send Robot Console Product Statuses are set to 'Y'.
  • Message center for RBCRSCQ will be installed with RBCRSCQ message center for a new install of Robot Console 7.

  • There was an issue with the 'PROGRAM' OPAL keyword not being populated correctly, but this has now been fixed.

Robot Network

Version: 12.00
  • Users can now create a secure connection to the IBM i system from the Robot Network GUI within Connection Properties and using the parameter USESECURE within the RBNCFGHOST and RBNCFGNODE commands.

Robot Schedule

Version: 13.00
 
New Features
  • Users can now create a secure connection between the IBM i system and the Robot Schedule GUI within Connection Properties.
Other Updates
  • An issue that occurred in Robot Schedule when a system's local system name and local control point name were different has been fixed.
  • The pre-checker no longer errors when converting from version 10,11, or 12 to version 13.
  • A race condition that caused the reactive job to run twice when running a prerequisite job.
  • RBT635M3 is no longer included in Robot Schedule.

  • A display issue with group member sequence numbers has been fixed.

  • After a role swap, the remote group members history is now correctly listed under the group job history.

Robot Schedule Enterprise

Version: 2.0
  • Support for secure connection from the Robot Schedule GUI has been added using the parameter USESECURE within the RBECONFIG command.

Robot Space

Version: 3.41
 
New Features
  • Users can now create a secure connection between the IBM i system and the Robot Space GUI within Connection Properties.
Other Updates
  • The create date (CRTDATE()) has been added as a parameter to command DLTSPLF to mitigate a potential issue within the Age Output Queue.

Back to Top

 

Sequel


Sequel 11

Version: R11M11
Enhancement
  • GETLAST and GETLASTLOC functions will now support a blank delimiter.
  • The Viewpoint Universal Driver with a JDE connection was not observing the decimal positions when the field was used on the WHERE or HAVING clause.
  • Script Designer/Warehouse Builder did not allow command strings over 5,000 positions gave MCH1210 ‘receiver value too small to hold result’ error.
  • Scripts/Warehouse Builder Definitions with commands using UNION gave Java exception error in EXPORTSQL.
Other Fix
  • EXECUTE to create of XLSX output produces sets of folder in /tmp that are not removed when errors happen. The process can fail due to IFS1007 user profile space constraints, QRY7018 spreadsheet size constraint, MCH1201 Scalar data cannot be changed to type required, CPF9838 User profile storage limit exceeded, MCH3603 Pointer addresses object type not valid for this operation and probably others. The excess folders will no longer remain in the event of an error.
  • EXECUTE gives CPF2479 ‘Call stack entry not found’ when the user has *STRICT authority, the query does not contain any of the fields that the user is prohibited from using, and the SQL is invalid.
  • Running BLDJDELF multiple times in a job results in ‘CPF4205 Shared open not allowed.’ User had to start a new job in order to run the command again.
  • Directly running the CVTSQTOIFS command does not copy any extra .rpt objects into the repository for CRO reports. It also does not copy extra .json files out there for client tables.
  • CVTSQTOIFS will not attempt to migrate dashboard objects to Repository mode.
  • RUNSCRIPT from a command line with Variables defined longer than 30 are losing the first line of prompt when running a script.
  • EXECUTE to XLSX format will now use the value from the RCDFMT parameter for the sheet name in the spreadsheet.
  • CVTQRY fails with error QRY2301 on CVTANSI when the view contains fields that are SQL keywords like PLAN and TYPE and using SERER(*LOCALSYS) SYNTAX(*SERVER).
  • From Mod 8 to Mod 10, running scripts with an EXPR variable type whose length was less than the maximum length, would send informational message of CPI4314 ‘Comparison of selection operands may never be equal’. This was due to a change where we were truncating trailing blanks on an expression variable value. It has been changed to pass the value with the padded blanks.
  • Running a DYNSQL request to delete records from a file could result in CPF4278 ‘Query definition template not valid’. Then all subsequent DYNSQL requests, even SELECT statements that worked previously in the job now fail with QRY9995 java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0.
  • Email sent using BCHEXECUTE did not resolve variables in view Description.
  • XLSX file would show error -We found a problem with some content in file name.xlsx. Do you want us to try to recover as much as we can- when opening if there were special characters GT LT in the text attribute on a View result.
  • Viewpoint Script Designer gave error CPD0074 “Value 'EXECUTE SQ' for COMMAND exceeds 5000 characters” when trying to run a script/warehouse builder definition with a long command line.
  • Viewpoint Script Designer gave error "An error occurred initializing the script: Index and length must refer to a location within the string. ‘Parameter name:’ Length" trying to edit a script/warehouse builder definition with a long command string that has been saved.
  • A Host Table when user had *SEQUEL authority would give QRY2303 ‘operator follows proper SQL statement from QRYP01’ or if *STRICT would give CPF9898 ‘Data Access restriction instead of QRY9999’.
  • From DSNSCRIPT on the green screen, previously the script could only be run once using F19 if changes were made. Now the script can be run multiple times.
  • Exporting view output in Viewpoint to an Excel file when using SERVER(*LOCALSYS) SYNTAX(*SERVER) and numeric fields that have an edit word or an edits code that places non-numeric characters in the field (such as / or -), causes the export to error out.
  • Passing complex variable values fail with QRY3004 -string never ended or longer than 256 error- in a script or CL program. For instance: SEQUEL/DISPLAY VIEW(library/viewname) SETVAR((&PARM -CSTTE =IL))
  • REPORT command to PDF to the IFS, should not have added a ^ character prior to the & character when an ampersand was use in the file name.
  • BCHPRINT command does not submit for prompted views.
  • EXECUTE to produce XLSX output has skipped the shared strings processing due to performance reasons since R11M09. That meant we did not generate the /x1/sharedStrings.xml portion of the xlsx document. But the [Content_Types].xml we zipped into the xlsx document still made a reference to the missing /x1/sharedStrings.xml. This did not cause Excel to complain when opening the document, but other products such as the ClearSwift email filter can treat the xlsx as defective.
  • The WEEK function over a JDE date field mistakenly started the week on Monday rather than Sunday.
  • Runtime SQL conversion using SERVER(*LOCALSYS) SYNTAX(*SEQUEL) cause error RNX0301 ‘Java exception received when calling java method’ using a sub-query.
  • Presence of an ALIAS name in a view causes the field names to be displayed rather than column headings.
  • Using *LOCALYS/*SEQUEL the converted SQL may have been written to change the ordering of list of join field to try to map with the order of the files in the FROM clause. The should allow a more accurate rebuilding of the FROM/JOIN clause.

Sequel Web Interface

Version: R10M29
Enhancement
  • Improved messages from SWS Repository Mode when an IBMi profile is disabled or password has expired.
  • In SWS Repository Mode, Dashboards will now support the following for action buttons:
    • Display view directly in a new window
    • Print to a PC printer
    • Create a PC file
    • Email the view results
  • In Repository Mode, when a dashboard is run, a file is created in the tmp directory on the IFS. The files will now be cleaned up.
  • In SWS Host and Repository Modes Client Tables will now support Ranking features including Rank Style, Rank On, and Sort Type.
Other Fix
  • A dashboard created for SWS Repository Mode will now allow action buttons that support display in a new window, print to a PC printer, create a PC file and email the results of a view.
  • A dashboard run in SWS Repository Mode will now clean-up the temporary files from the /tmp directory.
  • As dashboard run in SWS Repository mode did not show graphics.
  • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
  • In Repository Mode when running a view with a very large result set saving results to a PC file or e-mailing results with attachment, failed with error "An unknown error occurred on the request. Return status is 500."
  • In Repository Mode using JDE connection, if the UDC field was qualified like f03012." AIAC0401", would receive a column meta-data error.
  • In Repository Mode using Active Directory authentication, the Recent tab would time out for users with user id’s in all uppercase.
  • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
  • In Repository Mode with a JDE connection, custom column headings weren’t displayed when run from the browser.
  • In Repository Mode, views with a || for concatenation on JOIN clause gave Cannot Get Columns Metadata error.
  • In Repository Mode, views with a CONCAT(SUBSTR. Caused a query parsing error.
  • In Repository Mode, % sign (as used in the LIKE function) not handled properly on WHERE clause , or when entered in Prompt Variable.
  • In Repository Mode, a prompted value that passed a quote/apostrophe failed to run.
  • In Repository Mode, datasource connection that contained trailing spaces caused a connection error.
  • In SWS Repository Mode, requests are run in Native SQL so UNIQUEKEY is not supported and a message has been added to that effect.
  • In both SWI and SWS (Host and Repository) connection, Dashboards containing over 140 action buttons and text boxes did not return all results. Now results are buffered so all objects will be returned.
  • In SWI and SWS connections, if a Host Table produced an error, running the Host Table again ended with an OPNID error.
  • A SWI connection DBlist variable dependent on another variable causes QRY2302 Identifier follows proper SQL statement.
  • In a Dashboard (SW and SWS connections) a Radial Gauge with an edited label ignored the value on the last label.

Viewpoint 11

Version: 11.18.159
Enhancement
  • In Repository mode the JDE connection will not be recycled if the Environment and Role have not been changed in Viewpoint repository mode. This will help in performance after the first connection to a server.
  • In Repository Mode, Import Query has been added.
  • Improved performance for JDE JDE connections if the role and environment have not been changed in ViewPoint repository mode.
  • From the view results, Export to Excel produces error 'Application-defined error' when fields used edit words.
  • Improved message in Repository Mode when user excluded from IFS directory.
Other Fix
  • Logging in to SWS Repository Mode from the Excel Addin, user is prompted for the wrong repository.
  • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
  • In Repository Mode, Dashboard designer will now allow a Script View to be used.
  • Silent Install will check for locks and prevent the install from running if the product is in use.
  • Opening a very large Warehouse Builder definition or script in Viewpoint results in an error CPD0074 Value 'EXECUTE SQ' for COMMAND exceeds 5000 characters.
  • When view results are display, and "Close & Reprompt" is selected, the prompt screen should redisplay, and the variable values should default to those previously selected. Since updating to VP 11.18.046, if a DBList variable had a default value, and the view is run with that default value still present, when "Close & Reprompt" is selected, there will be no value displayed for that variable
  • In Host Mode Dashboard designer, Save To the Repository was unavailable.
  • In the View Designer using five or more files with the Viewpoint Universal Driver (JDE and ADS connections), Viewpoint wasn't building the joins correctly.
  • In the View Designer, with a *Localsys/*Server view, if a specific length is specified on an expression, going to the F&F tab and making a change to the column heading removes the specified length from the SQL.
  • In View Builder, choosing an expression column and then Edit brings the wrong column into the edit window when there are many fields and the expression is in the middle.
  • In View Builder, choosing a file that is not in the specified Group of Favorites causes Runtime Error 0.
  • In the Script Designer, a MONMSG command was mistakenly converted to SCMONMSG command.
  • From the Script Designer, selecting a line in a script, then click on Edit/Delete produces Runtime Error 0.
  • From Script Designer, creating a Script or Script View in Viewpoint Host mode and saving to repository fails.
  • DBList on a variable shows all fields with name of RENAMED when fields have names longer than 10 characters.
  • Designing a *Localsys/*Sequel view, when you hide a column (WDATA) the type and length are changed to the values of the following field. Un-hiding the length does not change back.
  • Excel Add-in drops decimals with some zoned numeric fields. When the problem happens, the integer part to the left of the decimal is correct while the fractional part to the right of the decimal is dropped.

Abstract

Version: R10M42
  • Analysis of free-form RPG has been change to handle free form without free form markers like /free.
  • The LOADXREF encounters the following error MCH4429 automatic storage overflow when we were processing a long procedure name (one that ended with ...) and reached the end of file.

Esend

Version: R03M58
Enhancement
  • When the users default (ESNDUSR) for the SIGN keyword is *YES and the users own signature setting (ESNDSGN) is blank, emails sent by that user will include the *SYSTEM default signature.
Other Fix
  • CPYSPLFDB does not support *LAST for the SPLNBR parameter even though *last is the default.
  • Emailing with EXECUTE without adding TOSTMF corrupts subject in mime note and email does not get sent.

Back to Top

 

Showcase


Showcase 10

Version: R10M11
Enhancement
  • GETLAST and GETLASTLOC functions will now support a blank delimiter.
  • The Viewpoint Universal Driver with a JDE connection was not observing the decimal positions when the field was used on the WHERE or HAVING clause.
  • Script Designer/Warehouse Builder did not allow command strings over 5,000 positions gave MCH1210 ‘receiver value too small to hold result’ error.
  • Scripts/Warehouse Builder Definitions with commands using UNION gave Java exception error in EXPORTSQL.
Other Fix
  • EXECUTE to create of XLSX output produces sets of folder in /tmp that are not removed when errors happen. The process can fail due to IFS1007 user profile space constraints, QRY7018 spreadsheet size constraint, MCH1201 Scalar data cannot be changed to type required, CPF9838 User profile storage limit exceeded, MCH3603 Pointer addresses object type not valid for this operation and probably others. The excess folders will no longer remain in the event of an error.
  • EXECUTE gives CPF2479 ‘Call stack entry not found’ when the user has *STRICT authority, the query does not contain any of the fields that the user is prohibited from using, and the SQL is invalid.
  • Running BLDJDELF multiple times in a job results in ‘CPF4205 Shared open not allowed.’ User had to start a new job in order to run the command again.
  • Directly running the CVTSQTOIFS command does not copy any extra .rpt objects into the repository for CRO reports. It also does not copy extra .json files out there for client tables.
  • CVTSQTOIFS will not attempt to migrate dashboard objects to Repository mode.
  • RUNSCRIPT from a command line with Variables defined longer than 30 are losing the first line of prompt when running a script.
  • EXECUTE to XLSX format will now use the value from the RCDFMT parameter for the sheet name in the spreadsheet.
  • CVTQRY fails with error QRY2301 on CVTANSI when the view contains fields that are SQL keywords like PLAN and TYPE and using SERER(*LOCALSYS) SYNTAX(*SERVER).
  • From Mod 8 to Mod 10, running scripts with an EXPR variable type whose length was less than the maximum length, would send informational message of CPI4314 ‘Comparison of selection operands may never be equal’. This was due to a change where we were truncating trailing blanks on an expression variable value. It has been changed to pass the value with the padded blanks.
  • Running a DYNSQL request to delete records from a file could result in CPF4278 ‘Query definition template not valid’. Then all subsequent DYNSQL requests, even SELECT statements that worked previously in the job now fail with QRY9995 java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0.
  • Email sent using BCHEXECUTE did not resolve variables in view Description.
  • XLSX file would show error -We found a problem with some content in file name.xlsx. Do you want us to try to recover as much as we can- when opening if there were special characters GT LT in the text attribute on a View result.
  • Viewpoint Script Designer gave error CPD0074 “Value 'EXECUTE SQ' for COMMAND exceeds 5000 characters” when trying to run a script/warehouse builder definition with a long command line.
  • Viewpoint Script Designer gave error "An error occurred initializing the script: Index and length must refer to a location within the string. ‘Parameter name:’ Length" trying to edit a script/warehouse builder definition with a long command string that has been saved.
  • A Host Table when user had *SEQUEL authority would give QRY2303 ‘operator follows proper SQL statement from QRYP01’ or if *STRICT would give CPF9898 ‘Data Access restriction instead of QRY9999’.
  • From DSNSCRIPT on the green screen, previously the script could only be run once using F19 if changes were made. Now the script can be run multiple times.
  • Exporting view output in Viewpoint to an Excel file when using SERVER(*LOCALSYS) SYNTAX(*SERVER) and numeric fields that have an edit word or an edits code that places non-numeric characters in the field (such as / or -), causes the export to error out.
  • Passing complex variable values fail with QRY3004 -string never ended or longer than 256 error- in a script or CL program. For instance: SEQUEL/DISPLAY VIEW(library/viewname) SETVAR((&PARM -CSTTE =IL))
  • REPORT command to PDF to the IFS, should not have added a ^ character prior to the & character when an ampersand was use in the file name.
  • BCHPRINT command does not submit for prompted views.
  • EXECUTE to produce XLSX output has skipped the shared strings processing due to performance reasons since R11M09. That meant we did not generate the /x1/sharedStrings.xml portion of the xlsx document. But the [Content_Types].xml we zipped into the xlsx document still made a reference to the missing /x1/sharedStrings.xml. This did not cause Excel to complain when opening the document, but other products such as the ClearSwift email filter can treat the xlsx as defective.
  • The WEEK function over a JDE date field mistakenly started the week on Monday rather than Sunday.
  • Runtime SQL conversion using SERVER(*LOCALSYS) SYNTAX(*SEQUEL) cause error RNX0301 ‘Java exception received when calling java method’ using a sub-query.
  • Presence of an ALIAS name in a view causes the field names to be displayed rather than column headings.
  • Using *LOCALYS/*SEQUEL the converted SQL may have been written to change the ordering of list of join field to try to map with the order of the files in the FROM clause. The should allow a more accurate rebuilding of the FROM/JOIN clause.
  • A migrated ShowCase DBQ that uses the ADS driver and ShowCase aliases. The view displays results in both ViewPoint and SWS-Repository Mode. However, when the view is opened in ViewPoint Design, we get an error when going to the Files & Fields tab: Couldn't find field COLUMN0001.
  • Warehouse Builder scripts that were migrated didn’t run in Repository Mode. The .vptscript objects were created with CCSID 5348 and should have been created with 1252.

Sequel Web Interface

Version: R10M29
Enhancement
  • Improved messages from SWS Repository Mode when an IBMi profile is disabled or password has expired.
  • In SWS Repository Mode, Dashboards will now support the following for action buttons:
    • Display view directly in a new window
    • Print to a PC printer
    • Create a PC file
    • Email the view results
  • In Repository Mode, when a dashboard is run, a file is created in the tmp directory on the IFS. The files will now be cleaned up.
  • In SWS Host and Repository Modes Client Tables will now support Ranking features including Rank Style, Rank On, and Sort Type.
Other Fix
  • A dashboard created for SWS Repository Mode will now allow action buttons that support display in a new window, print to a PC printer, create a PC file and email the results of a view.
  • A dashboard run in SWS Repository Mode will now clean-up the temporary files from the /tmp directory.
  • As dashboard run in SWS Repository mode did not show graphics.
  • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
  • In Repository Mode when running a view with a very large result set saving results to a PC file or e-mailing results with attachment, failed with error "An unknown error occurred on the request. Return status is 500."
  • In Repository Mode using JDE connection, if the UDC field was qualified like f03012." AIAC0401", would receive a column meta-data error.
  • In Repository Mode using Active Directory authentication, the Recent tab would time out for users with user id’s in all uppercase.
  • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
  • In Repository Mode with a JDE connection, custom column headings weren’t displayed when run from the browser.
  • In Repository Mode, views with a || for concatenation on JOIN clause gave Cannot Get Columns Metadata error.
  • In Repository Mode, views with a CONCAT(SUBSTR(. Caused a query parsing error.
  • In Repository Mode, % sign (as used in the LIKE function) not handled properly on WHERE clause , or when entered in Prompt Variable.
  • In Repository Mode, a prompted value that passed a quote/apostrophe failed to run.
  • In Repository Mode, datasource connection that contained trailing spaces caused a connection error.
  • In SWS Repository Mode, requests are run in Native SQL so UNIQUEKEY is not supported and a message has been added to that effect.
  • In both SWI and SWS (Host and Repository) connection, Dashboards containing over 140 action buttons and text boxes did not return all results. Now results are buffered so all objects will be returned.
  • In SWI and SWS connections, if a Host Table produced an error, running the Host Table again ended with an OPNID error.
  • A SWI connection DBlist variable dependent on another variable causes QRY2302 Identifier follows proper SQL statement.
  • In a Dashboard (SW and SWS connections) a Radial Gauge with an edited label ignored the value on the last label.
Automate Schedule/Deployment Bundle
  • Editing a Web Service Job with a JDE connection to change Data source user and password on commands tab causes output file to not be created.
  • Web Service job suite member job against JD Edwards data source did not run, nor could they be edited.
  • Web Service Job in SWS Repository Mode will not send e-mail result files unless default user for Automate is defined.
  • Web Service Job output set to file type "PCFILE" if C&DS job file type was XLS, XLSX or CSV.
  • An extra email not listed as running, completed, failed or results, it simply has a joblog attached when the job 'Output Distribution' notification is checked. This was inadvertently added during the migration and will not longer be included.
  • The interface has been changed to allow you to alter and save the Datasource User or password for a given job when running in repository mode.
  • E-mail notifications on a migrated Web Service Job don't match what was in CADS.
  • Migrating from PES file, most jobs failed to migrate - Logs contain: Error creating Job Notification List.
  • C&DS migrated multi-step jobs with Warehouse Builder scripts create Automate Schedule job but missing job file in SWS repository.
  • C&DS migrated jobs to Automate Schedule did not include JDE Environment, which is required to run the job.
  • Web Service job suite member job against JD Edwards data source not running, can't edit it.
  • C&DS jobs that have multiple steps and each step sends e-mail notifications to multiple people. When these are migrated in Repository Mode, the e-mail addresses aren't added to the jobs correctly.

Viewpoint 10

Version: 10.18.159
Enhancement
  • In Repository mode the JDE connection will not be recycled if the Environment and Role have not been changed in Viewpoint repository mode. This will help in performance after the first connection to a server.�
  • In Repository Mode, Import Query has been added.
  • Improved performance for JDE JDE connections if the role and environment have not been changed in ViewPoint repository mode.
  • From the view results, Export to Excel produces error 'Application-defined error' when fields used edit words.
  • Improved message in Repository Mode when user excluded from IFS directory.
Other Fix
  • Logging in to SWS Repository Mode from the Excel Addin, user is prompted for the wrong repository.
  • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
  • In Repository Mode, Dashboard designer will now allow a Script View to be used.
  • Silent Install will check for locks and prevent the install from running if the product is in use.
  • Opening a very large Warehouse Builder definition or script in Viewpoint results in an error CPD0074 Value 'EXECUTE SQ' for COMMAND exceeds 5000 characters.
  • When view results are display, and "Close & Reprompt" is selected, the prompt screen should redisplay, and the variable values should default to those previously selected. Since updating to VP 11.18.046, if a DBList variable had a default value, and the view is run with that default value still present, when "Close & Reprompt" is selected, there will be no value displayed for that variable
  • In Host Mode Dashboard designer, Save To the Repository was unavailable.
  • In the View Designer using five or more files with the Viewpoint Universal Driver (JDE and ADS connections), Viewpoint wasn't building the joins correctly.
  • In the View Designer, with a *Localsys/*Server view, if a specific length is specified on an expression, going to the F&F tab and making a change to the column heading removes the specified length from the SQL.
  • In View Builder, choosing an expression column and then Edit brings the wrong column into the edit window when there are many fields and the expression is in the middle.
  • In View Builder, choosing a file that is not in the specified Group of Favorites causes Runtime Error 0.
  • In the Script Designer, a MONMSG command was mistakenly converted to SCMONMSG command.
  • From the Script Designer, selecting a line in a script, then click on Edit/Delete produces Runtime Error 0.
  • From Script Designer, creating a Script or Script View in Viewpoint Host mode and saving to repository fails.
  • DBList on a variable shows all fields with name of RENAMED when fields have names longer than 10 characters.
  • Designing a *Localsys/*Sequel view, when you hide a column (WDATA) the type and length are changed to the values of the following field. Un-hiding the length does not change back.
  • Excel Add-in drops decimals with some zoned numeric fields. When the problem happens, the integer part to the left of the decimal is correct while the fractional part to the right of the decimal is dropped.

Esend

Version: R03M58
Enhancement
  • When the users default (ESNDUSR) for the SIGN keyword is *YES and the users own signature setting (ESNDSGN) is blank, emails sent by that user will include the *SYSTEM default signature.
Other Fix
  • CPYSPLFDB does not support *LAST for the SPLNBR parameter even though *last is the default.
  • Emailing with EXECUTE without adding TOSTMF corrupts subject in mime note and email does not get sent.

C&DS Migration Utility

Version: 10.18.159
Other Fix
  • CVTWHBLDR command parameters changed to help prevent Warehouse Builder scripts from being defined with the wrong server name.
  • C&DS Migration Utility should not require Automate server information in Repository Mode.
  • Using Migration Tool for Analysis Only does not prompt for the Data Source.

Back to Top

 

 

Copyright © HelpSystems, LLC.
All trademarks and registered trademarks are the property of their respective owners.
Last Published: 201812060924