Sequel Web Interface

June 2024

Version: R10M37

June 10, 2024

  • When exporting to Excel from a CRO Report in Sequel Web Server (SWS), a new option is now available to Export Data Only. This option is useful where the CRO report contains many columns.
  • Security updates have been made to the Apache and Tomcat web servers used in Sequel Web Interface.

November 2023

Version: R10M36

November 19, 2023

  • Bar charts in a dashboard displayed in the Sequel Web Interface now show labels above the bars, where applicable.

  • The retention period for Catalina logs generated by Sequel Web Server has been changed to 7 days.

  • A fix has been made to handle date variables correctly in views displayed in Sequel Web Server when running in Repository mode.

  • Security updates have been made to the Apache and Tomcat web servers used in Sequel Web Interface.

  • Sequel Web Server has been enhanced to support TLS 1.2 configuration to secure all endpoints.

August 2023

Version: R10M35

August 15, 2023

  • A fix was made for dashboards when run in SWI where the background color would display with the background color of the last action button added to the dashboard

  • Apache HTTP has been upgraded to 2.4.57 and Tomcat has been upgraded to 9.0.75 to aid in vulnerability mitigation

  • Fixed an issue in SWI where a view with multiple variables with DBLISTS and filters failed to show selection dropdowns.

  • A fix was made to correct a problem with variables using an integrity test referencing another variable in lower case when run in SWI.

  • Prompted view with null-capable variable sometimes failed to display results in SWS and SWI if value was blank

  • A fix was made for install of SWI, if there is a user defined program for SWISTART it will not get overlayed with the shipping program

  • A fix was made to prevent Dashboard charts from incorrectly duplicating data

  • When editing an existing SWS Repository mode credential, the password entry field was previously empty. It now shows a masked password to indicate that the password exists.

September 2022

Version: R10M34

September 13, 2022

  • The Sequel Web Server has been upgraded to Tomcat 9.0.65 and Apache 2.4.54.
  • From SWI, view with DBLIST with a File is not sorting records in drop down as expected when a Description field is used.
  • DBLIST values not sorted correctly when specifying a View and a description field.
  • A fix was made for a View with a QSTRING variable with a defined default value. Qstring default values are saved with double quotes, even if you enter it with single quotes. When run in SWI, the setvar value shows as ' "IL" '. That appears to cause it to error out. When choosing a value from the variables Value list which are entered with single quotes, the setvar shows as ' ' 'IL' ' ' and the process works
  • Scripts erroneously quote *ALL in the SETVAR parameter, i.e. SETVAR((&VAR '''*ALL''')), when run from SWI. It appears 0 are returned records but the error CPD0078 'Value ' ' for parameter DTAARA not a valid name' appears in log.
  • Double byte characters are displayed incorrectly from browser when the field used field which contains both US English and Chinese characters.

  • A fix has been made for Dashboards run from SWI Explorer and SWS Host which can display charts incorrectly where chart2 will display the same as chart1.
  • SWI attempted to use the TITLE parameter rather than the SUBJECT parameter when creating the SQJCRO command when attempting to e-mail the output.

January 2022

Version: R10M33

January 6, 2022

Sequel Web Server 2.9
  • Fixed issue where if after SWS 2.8 was upgrade e-mail notifications for scheduled Web Service Jobs were not being sent.

  • SWS Timestamp of Noon is saved to Excel as 00:00, but is displayed correctly as 12:00 in browser.

August 2021

Version: R10M33

August 23, 2021

  • If a view in a Dashboard returns no records, a message displays stating "No Records" Also, digital gauges no longer just show an empty box, they now show 0.00

  • From Classic SWI or using a URL, prompted views with filters are supported.

  • Sequel Web Server:
    • From SWI, a variable that is filtered on another variable is now supported when run in SWS Repository mode.

  • From SWI, a Drill Down using an IN comparison to select multiple records erroneously returned no records.

  • Calendar does not appear for some Date variables when the date format of the view is *ISO and date separator of "/" from classic SWI.

  • When the second variable has a filter based on variable 1 and the filter has an expression using parenthesis, the second variable was not parsed out properly which de-activated the drop down process.

  • When a *LOCALSYS/*SERVER view with GROUP BY and a quoted field names with spaces such as "Last Year", Re-group or Show Details it would cause an error.

  • Show Details will fail if a record in the output had a blank value.

  • Script View from SWI not handling DBLIST variable values and *ALL at the same time.

  • Script views with prompts will buffer results. This will allow a quick return of records to the browser. This reverts a change previously done in 10.20.

  • Drill Down Application with a Script View with a DBLIST fails CPD0020 character not valid following string.

  • A fix was made to reflect centered text properly in a text box on a dashboard. Previously when displayed in SWI the text was left justified

  • Dynamic Drill Down From SWI Explorer from a Script View using GROUP BY could returns no records.

  • In Repository Mode, Email setting options have been increased from a length of 35 to 256.

  • From SWI, Drill-down with a *LOCALSYS *SERVER view and variables can cause ambiguous references

  • Sequel Web Server:
    • Running a Client Table from SWS that contained field names with a # character, caused an 'Unspecified error has ocurred'.

    • In SWS Repository Mode, Using a pound sign (#) in the name of a PC file is now allowed.

    • The Sequel Web Server install now allows for a choice in for the SQLServer JDBC driver.

    • In SWS Repository mode, a DBLIST using a JDE field only showed the codes and not the descriptioins.

    • SWS Repository Mode a DBLIST using a JDE datasource with a UDC field, did not populate the list.

    • In SWS Repository Mode, creating an Excel file from results inserts a blank column A in some instances when using the ViewPoint Universal Driver and a GROUP BY clause.

    • DBList list not populated in SWS Repository Mode if source view uses datasource of JDE and the description is a UDC field.

    • In SWS Repository Mode, when using the ViewPoint Universal Driver (JDE or ADS) with a view using *ALL for variable selection and totals in results, a blank tab was returned.

    • SWS Repository Mode display results or output to Excel - long character field is blank when line feeds or carriage returns exist in the data.

    • In SWS Repository Mode, Totals are missing, even though they are defined properly in Viewpoint.

    • From Repository Mode, when a view contained fields with the same Alias Name, even from different files, data in the columns would repeat and column headings would be out of line.

    • Illegal group reference error in SWS browser when prompted variable value contains a dollar sign.

June 2020

Version: R10M32

June 29, 2020

  • The location of the JDE Data Source files has been modified to allow support of multiple JDE E1 version including 9.1 and 9.2.

  • In SWS Repository Mode from view results, add 'Copy Cell' ability.

  • In both Host and Repository Mode connections, the Graph Background and Legend background colors is honored. However, the following background properties are not supported because FusionCharts does not support it:

    • Graph Title background

    • Bottom Title background

    • Left Title background

    • Right Title background

  • In both Host and Repository Mode connection, the font and colors in a dashboard will be more consistent with how they were designed in Viewpoint.

  • Web Service jobs now support the CSV file output type.

  • Updated to latest Apache version (2.4.43) to address any known vulnerabilities.

  • Updated to latest Tomcat version to address any known vulnerabilities.

  • SWS Repository mode DBLIST drop down of view with data on iAsp will show list of values.

  • Using a SWS connection Excel output will save dates as date fields and not General format.

  • In SWS Repository mode a Host Report using a QSTRING variable did not run due to a conflict with the quotes.

  • SWS Repository mode data source definitions for JDE or ADS will now allow more than one library in the library list.

  • Changes to Graph axis label controls on a dashboard were not reflected SWI.

  • In some instances, from SWI Explorer, a dashboard would display the message: "Dashboard <library/dashboard> is not a valid Sequel Dashboard".

  • Web Service Job could not be created for Host objects if object name has a space.

  • When creating a job for a Host Table, a Native job must be used—not a Web Service Job.

  • SWS Web Service Jobs with XLSX file output can be invalid at unpredictable intervals.

  • Web Service job failed if prompted variable value is an ampersand.

  • A Web Service job failed to delete if the job that did not have any notifications.

  • SWS 2.6 Web Service jobs cannot output to a network repository.

  • If the scheduled time of a Web Service Job is between 00:00 and 00:30, SWS displayed the time incorrectly. The time is correct in Automate Schedule.

  • When deleting a SWS datasource or credential, we will verify that neither is used in a Web Service job first.

July 2019

Version R10M31
  • From a Web Service Job, the subject line can be modified to apply to the notification for results.
  • All individual prompt field windows will expand when the prompt window is expanded, enabling the entire value to be viewed without scrolling. This is especially helpful when the variable value is greater than 30 positions.
  • In SWS Repository mode, the new/edit data source TEST button should prompt for JDE Environment if data source is a JDE type.
  • In SWS Host and Repository modes, an Integrity test on a variable conditioned on another variable (filter) is now allowed.
  • Web Service jobs will now to allow suppression of email if no output, and custom subject line.
  • WebService Job Properties will now display datasource name.
  • For SWS authentication using Active Directory, there are wo enhancements:
    • Prevent looping when groups are found to be members of other groups in Active Directory.
    • Add a setting to the Authenticator definition that would allow the customer to disable group profile checking in Active Directory.
  • Web Service Jobs will now use Credentials instead of User ID and Password.
  • SWS Repository connections running a CRO report now support replacing *ALL with the values used in the report heading.
  • SWS request not properly translation Sequel 'Contains' function to the SQL 'Like' function.
  • In SWS Repository mode a Dashboard with action buttons gave 'Error while getting and reading.vpt file’ when path had a space.
  • In SWS Host and Repository modes a Script View was not buffering results correctly and looped in the records returned.
  • From SWI, View Output containing CR/LF characters not displaying properly from SWI.
  • From a SWS connection a *LOCALSYS view did not support a subquery on JOIN clause.
  • In SWS host mode or repository mode, using an action button on a dashboard to get view results then from there the 'save results, 'Print Results' 'Email Results' failed with error 'Unknown Host'.
  • Dashboard SWS Repository mode the text in a Text Box does not center, it is left justified.
  • In SWS host and repository mode the following edit word for a 4 digit number was not applied correctly on a *localsys syntax(*server) view: /*<S- EDTWRD('0 : ')-S>*/
  • In SWS Host and Repository modes, the view with an edit work like EDTWRD("0 / ")when run from a script view did not properly apply the edit word.
  • In SWS Host or Repository mode, in a Turkish environment when QZDASOINIT job has ccsid error ‘GETTING OBJECT DEFINITION Unspecified error occurred. Error message: Unterminated object at line 1 column 86 occurred.
  • Continuous running dashboard thru SWI, eventually errors with MCH6903.

November 2018

Version R10M30
  • In SWS Repository Mode when copying a repository object, restrictions set explicitly on the object will be duplicated.
  • In SWS Repository mode a search function has been added to the Explorer tab with will also search across sub-folders.
  • SWS Repository logging has been improved to: 1. Prompt for to download the zip file. 2. Apply a timestamp to the zip file. 3. Include the JDE log when applicable.
  • In SWS Repository mode a Repository folder can be set as a Favorite.
  • In Repository Mode, multi-select of objects (not including jobs) is allowed.
  • Tomcat used for SWS connections has been updgraded from version 7 to version 9.
  • In both SWI and SWS when the results are buffered, the page description will not include the total number of records.
  • Certain complex views would not display any custom headings when run from SWS. This has now been corrected.
  • Several open source components used in SWI and SW have been updated to the latest versions to address both defects and potential security concerns in the earlier versions.
  • A dashboard with multiple views with the same variable name that is saved with results gives error RNP8014 Value for variable &VARNaM exceeds the defined length of x.
  • In SWS Repository Mode, results did not support a blank column heading.
  • SWS Repository mode creates XLSX output with inappropriately sized columns and poorly formatted column headings in some instances.
  • SWS Repository mode Client Tables over JDE connections failed.
  • SWS fails to pass blank value with Values List integrity test like values('I', 'AM',' ' ).
  • SWS Repsository Mode grouping views gave error Invalid object name "SEQUEL.VPTDYNFLTR' using Dynamic Drill Down.
  • From SWS Repository mode, user see spinning wheel when trying to access folder in Repository that IFS security excludes them.
  • Web Service job password stored in plain text ONLY when job imported from a host job.
  • SWI and SWS host and repository modes fail to display calendar on date prompts for scripts and script views
  • SWS Host and Repository modes produce corrupt xlsx from view with subtotals
  • SWS Repository Mode Dashboard with Hide Border setting did not work.
  • From SWS Repository mode a dashboard with a view set to hide menu/tool bar never loads the data when run.
  • From Viewpoint, saving view results to physical file gives message 'Client request-run program *LIBL/VPTJMSG' when NetIQ is in use.
  • In both SWI and SWS results, the 10,000 row display limit has been removed.
  • In SWI and SWS, email subject line is now 80 positions.
Automate Schedule/Deployment Bundle
  • Web Service Jobs allow xlsx as an output type.
  • Running a host job now has all email notifications correct: running email, results email and completed email.
  • Converting SWS Host Job to Web Service Job, schedule and notification settings are lost
  • Incorrect notification if job returns zero rows, job appears to fail
  • Web Service jobs migrated from CADS when a null variable was used failed.
  • Web Service jobs migrated from a C&DS job that runs on specific days is scheduled for the wrong days.
  • Web Service job - e-mailed output file name doesn't match what was defined in the job
  • Web Service jobs migration has improved messaging when migration fails.

June 2018

Version R10M29
  • 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.
  • 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.

February 2018

Version R10M28
  • Sequel Web Server now defaults to 64 bit and requires a 64 bit server.
  • For Client Reports run in SWS, whenever data returned by the query contained an embedded double quote character (e.g. the inches notation ") the report would fail with the error: SQL0104-Token 2086 was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET.
  • In Repository Mode:
    • When using a JDE datasource, customized column headings did not appear.
    • View with a nested CONCAT statement, like CONCAT(CONCAT(RTRIM(FIRSTNAME), ' ') LASTNAME) caused an unspecified error.
    • Views using SERVER syntax with a JOINed file specification followed by a comma and more file specifications gave an unspecified error.
    • Repository restriction for type *all and Principal *all does not block access.
    • The arrow buttons on the Manage Credential Windows have been reversed so they are more logical.
    • Repository objects now support a CRO report that begins with a # character.

December 2017

Version R10M27

This December 2017 release did not increment the version number from the previous release.

  • In Host Mode, the Recent tab was increased to an unlimited number of records.
  • Sub-totals in view results may not be accurate in rare instances.
  • Improved QZDASOINIT job management with a resource cleaner.
  • In Host Mode:
    • The Manage Repositories option as been removed as this mode supports only one repository so a manage option is not needed.
  • In Repository Mode:
    • The Showcase DATA function gave error "Sequel query parsing exception. Cannot get columns metadata for query” when the function was not library qualified.
    • Manually entered column headings in the SELECT clause of the view did not display.
    • Using folder security, if a user was not authorized to a folder, the user would also not see folders he/she should.
    • Using JDE World A9.3 when the user the has a single role defined in JDE, the connection fails.
    • JDE World profiles without *ALLOBJ authority, failed to run views.
    • The method for authentication now establishes the connection immediately instead of using a lock/unlock mechanism in a callback request.
    • The column of created dates displays each date as:
      0NaN-NaN-NaN in some instances.
    • When view or report results are displayed, a toolbar for save, print, email, properties, create chart and subtotals should be visible. IE has been reported to render these buttons using the same color as the background, making the buttons invisible.
    • Local datasource connections were not observed, this was noticeable because the library list parameter of the datasource was not detected.
  • Web Server Jobs that were migrated that should end in a FAILED status end as Completed and incorrectly create an output file.
  • Web Server jobs used the wrong command for Script Views.

Automate Schedule:

  • Automate Schedule jobs running EXECUTEVPT fail to email to designated recipient.
  • Automate jobs running EXECUTEVPT fail to email to designated recipient.

October 2017

Version R10M27
  • Runtime variables with multi-select values list integrity check in views or script were not working in neither SWI nor SWS connections.
  • Custom format setting on a value in a radial gauge does not display with SWI or SWS connections.
  • Using a Classic SWI connection, IN variable list with character values using single quotes only passes the first value; others are ignored.
  • DBLIST value that uses a view with data in specific order does not display the list values in the correct order as defined by the view in both SWI and SWS connections.
  • In SWS, dynamic drill down/show details is not filtering the records correctly based on record chosen when the GROUP BY clause contains ambiguous fields (when the same field name can be in more than one file).
  • Dynamic Drill down show details on LOCALSYS view with WHERE clause fails in SWI and SWS when the QSTRING variable has a default value and the default value is chosen for the drill down value.
  • Scripts and Script Views not passing correct quoted values in SETVAR when run from SWI or SWS connections.
  • SWI and SWS fail to email prompted CRO reports because an invalid RUNRMTCMD that includes parameters TITLE and RECIPIENT was built.
  • In Repository mode:
    • Users without *ALLOBJ authority could run CRO reports.
    • Using a JDE datasource with an unqualified (*LIBL) file on the FROM clause displays a NULL error.
    • Using a file on the FROM with *LIBL for the library generates the error ‘bad SQL grammar’.
    • When the DBLIST of a variables definition is used an unqualified file (*LIBL) generates the error ‘bad SQL grammar’.
    • Setting folder security by excluding all users by default, still allowed specific users are then unable to see it.
    • Print requests generate error 500.
    • Views don't show save sub-totals.
  • In a dashboard, any charts that are designed over a detail view, not summary/GROUP BY data, do not display in SWI Explorer or Classic.

April 2017

Version R10M26
  • 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.
  • 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.

October 2016

Version R10M24
  • From Repository a .vptreport shortcut doing Save Results> Repo File>RTF creates corrupt file.
  • The presence of a slash ( \ ) at the end of any object description text prevents a list of objects including that view from being displayed.
  • Client Reports (SQLRPTC) and Client Tables (SQLTBLC) with a variable using a DBLIST with check(multi) did not properly quote the string.
  • Script View with a DBLIST, multi-select prompt variable not passing variable string correctly.
  • When the Dynamic Drill Down List file (SEQUEL/VPTDYNFLTR) contains a list of fields, only those fields are available for dynamic drilldown. If the file contains fields, but no fields that exist in the files that a grouping view references, then the option to view the complete list should appear in SWI, as it does in ViewPoint and SWS.
  • Reprompt of variable with DBLIST gave error.

April 2016

Version R10M23
  • Using a SWS connection, a variable with a Database List will now be supported for remote database views.
  • The repository now supports dashboard objects as .vptdash objects.
  • I/O Error. Broken Pipe when using remote database connection from SWI in some instances.
  • From a SWI connection, Email sent to a Distribution list is only sent to the first 2 recipients in the list.
  • Using SWI, Right click a CRO report or Display and then Click Download > RTF will now work.
  • When running Dynamic Drill Down ( Regroup / Show Details) on a view with SERVER(*LOCALSYS) SYNTAX(*SEQUEL) in SWI you get CPD4306 ‘field is not unique’ if picking a field name that is found in multiple files.
  • When using Regroup with a SWI connection, the HAVING clause should be removed but should remain when using Show Details.
  • Running a prompted view/report/table in SWI fails if prompt value has an apostrophe in it.
  • Within the repository additional shortcut types were created to distinguish between a Host Report (.vptreporth) and a Client Report (.vptreport), and Host Tables (.vpttableh) and Client Tables (.vpttablec), and Script (.vptscript) and Script Views (.vptscriptv).
  • Using a SWS connection to run a Client Table built over a ViewPoint Universal Driver connection (JDE or *ADS) is now supported.
  • In a SWS and SWI connection, download and email of a Client Report (CRO) now supported.
  • JD Edwards World A9.2 users unable to log in to SEQUEL Web Server, received error ‘Your connection has been expired. Please retry your action.’
  • JD Edwards World A9.3 users unable to log in to SEQUEL Web Server if only 1 Environment assigned to user.
  • SWS will now require ADMIN credentials to change host configurations.
  • Basic users cannot connect with SWI due to authorization to running the CHGCURLIB command
  • Prompt Variables with default values that include decimal amounts are rounded, and do not display the actual value saved with the view.
  • Drill Down Application with a hash symbol (#) in title of object, did not run.
  • From the SWI Explorer displaying of all results, including unbuffered like script views, will honor date sorting when the date style is MDY or DMY or USA or EUR.
  • From a dashboard, Reprompt All button does not display if the last variable has prompt text of *NOPROMPT.
  • When a variable is used for a multi-select DBLIST, the length of the variable will be honored so an unlimited number of values cannot be entered.
  • In Charting:
    • On a bar chart, x-axis labels are now supported to show values under the bar.
    • On a chart with many points, x axis lables can be set to show every nth value. When saved on a dashboard, this attribute is not retained.
    • Charts built over views with sub-totals in the results should not graph subtotals.
    • Bar Chart exported from display to PC file did not render correctly.
    • Right titles are now supported.

November 2015

Version R10M22

The following updates are included in this version:

  • View Subtotals are missing in SWS when Save to Repository is used.
  • SEQUEL Application from SWI or SWS, drill down causes a prompt screen to appear instead of automatically passing the required data to the "drill to" view with NAME or EXPR type variables.
  • When running an Application from SWI or SWS, the text above the Drill down results was coming from the description text defined in the View Definition.
  • Now the title uses the text defined on the Option File entry on the Drill down results.
  • Views with DB list prompt variables that display a value from one field, but pass a value from a different field to the view intermittently pass the description field instead of the value field to the view only on re-prompt.
  • When a dashboard is run from SWI or SWS, the order of the prompt variables appear in no particular order. This is most noticeable when the there are several sequential variables.
  • Using SWS, when a dashboard that has a DBList(s) is launched, the DBList(s) will only show the default value.
  • From SWS, running a Host Table (SQLTBLV) to Save Results/Download/PC file when no records were selected did not send message.
  • Variable with Values List with double quoted values does not pass integrity check when run in SWI.
  • For SWI and SWS, using Right click/Save Results/Download to a PC file on a Host Table that returned no records did not produce a PDF file with the No Records Returned message.
  • Emailing results from a SQLRPTC (CRO) file in SWS sends file with temporary name.
  • Running a view in SWI/SWS, and highlighting some values in a column to see the Total at the bottom right, if there are any negative values highlighted, they are not included in the Total, and they are treated as zero.
  • In a Client Table, a calculation that is based on other calculated columns could show incorrect results in SWS.
  • SWS shows no implied drill option based on options in file with like variable names.
  • When a Client Table with column totals suppressed via Format>Layout> Then Click each of the 'Row' fields and uncheck show footer, is displayed in SWS, the column totals were still visible and in fact are the only level to show initially.
  • From SWS, a Client Table that was designed to have fields with the " visible " box unchecked in Format>Layout>Fields tab so that the field isn't displayed in the results, but the field is available to be used in other calculated fields, was displayed.
  • Client Report should have option for xls when downloading to a pc file.
  • From SWS running a .vptview from the repository and using Dynamic Drill Down options of Regroup or Drill Down gives error ‘object in QRECOVERY not found’.


  • Single quotes in Action Button Text display as 2 single quotes.
  • A chart with an apostrophe in the Title will not display in SWI/SWS.
  • Embedded Excel spreadsheet did not open if using Excel 2013.
  • Made chart titles consistent between SWS and ViewPoint. For instance, in SWS the chart title is {‘Total A/R’ by ‘Sales Region’} but ViewPoint used {Total A/R by Sales Region}.
  • Added support to keep legend on the left side is that’s how it was created in ViewPoint.
  • Bottom legend customized to show every other or every third in VP does not translate to SWI/SWS - all legend info is shown.
  • Trends "Limit lines" and "mean/avg lines" are missing in Line charts
  • Edited – customer legend (labels) not visible.
  • Chart colors changed to match ViewPoint more closely.
  • Line graphs improved to:
    • Show line and not small circles
    • The range defined in the graph is not used - instead it uses a default range (0 - 100) and, depending on the data, can render the graph useless.
    • When a line is displayed, it is too pale, and should be more prominent as in ViewPoint.
  • The graph window title bar is missing in SWS
  • Gauges are showing different value ranges between VP and SWI; range steps are no longer in specified increments.

The following enhancements are included in this version:

  • Properties of a view can be restricted by user.
  • Support for prompting of JDE Environment and Role when using the ViewPoint Universal Driver (JDE Driver) and running views and reports from SEQUEL Web Server.
  • SWIOPEN COLSET parameter length increased from 315 to 512 positons to accommodate longer URL strings being passed.
  • Apache version upgraded to 2.2.29.
  • Implement local variables for Skybot to avoid collision errors when we have several jobs that want to use a variable named &CUSTID for example. With private Skybot variables we could set the CUSTID variable for every job and avoid these collisions. This would also simplify our current prompting scheme, and allow for cleaner web service URLs and variable names.
  • In SWS, limitation of 800 for variables using a DBLIST was removed.
  • SWI/SWS increased email address book drop-down to more than 1500 entries.
  • A Drill Down application that uses an option file where some runtime variables are set to hard coded values fails to pass any values when run in SWI and SWS.
  • SWI/SWS fails to process command in Drill Down options when the command is qualified with a library name.

May 2015

Version R10M21

The following updates are included in this version:

  • User defined title in graph from dashboard not used.
  • Dashboards run with zero values for the speedometer or thermometer values were not displayed.
  • From a dashboard, line graphs were rendered with the wrong series order.
  • Dynamic Drill Down (drill from a GROUP BY view) does not honor 'Dynamic Drill Down List' defined in the ViewPoint Administrator.
  • Dashboard overlaps when using Zooming in or out from Internet Explorer and Firefox.
  • From SWS a value with an apostrophe passed to a prompted view would cause the request to fail.
  • Action buttons from a dashboard did not work when DSPNETA had a different name than the system defined in in SWS.
  • Digital graph not rendering number represent time (HH:MM or HH:MM:SS) with an edit mask correctly.
  • SWI/SWS hangs when rending a gauge created with a blank custom mask.
  • On a dashboard, a text box that contains a single quotes displayed as two single quotes.
  • From a host tables the Download to a PC file in PDF option, both save and open, rendered message that the file could not be opened.
  • From SWS, a SQLIVEWM (with SERVER other than SEQUEL) did not show sub-totals if they were saved with the view.
  • In a dashboard, a radial gauge had the maximum value ignored and the actual gauged cell value became the maximum and the gauge displays maxed out.
  • In a dashboard, and Action Button running a command string for a prompted view with SETVAR should not prompt.
  • Client Tables from SWS with calculated fields without a specific derived field name will not longer end in a ‘Mondrian Error:Internal error’.
  • User based license was not released when view is reprompted and run again from Auto-Prompt window.
  • Multiple fixes for passing prompted values with quotes.
  • Dashboard bar chart not using column/series order the same way as ViewPoint when user changed graph defaults.
  • Skybot Integration:
    • When creating a Skybot job around a Client Report object, the drop down menu for the extension of the output file needs to allow for XLS files.
    • The output location of Skybot jobs in SWS should allow writing to UNC paths outside of the REPOSITORY.
    • Skybot settings button no longer visible when using unsecured URL.
  • Repository:
    • Expanding the repository and drilling into multiple levels of folders, then creating a job, returns you to the high level repository folder.

The following enhancements are included in this version:

  • File type xlsx add to the Save Results\Download to PC\Export to Excel option.
  • Creating a job from a view or a vptview the Output File parameter now has a type of HTML in the drop down.
  • Improved Navigation Pane that is completely collapsible.
  • Additional options added to ViewPoint Administrator for SWI Functions List control.


Back to Showcase Products