Showcase 9 Client

June 2019

Version 9.1.0.15 Client Patch
Other Fixes
  • An issue editing column headings in the Report Writer that was introduced on Windows 10 with updates has been fixed.
The following patch updates are also included:

9.1.0.14 Client Patch (April 2019)

  • Windows Server 2016 support added.
  • Copy paste from Showcase Query 9.1.0.13 (using Ctrl-C) to either Excel or iSeries screen adds a question mark '?' in front of the data.

9.1.0.13 Client Patch (March 2018)

  • There is a new configuration option where the Showcase 9 server can be setup to reject requests from down level Client version. This is a new feature in the 9.4.0.2 server build and 9.1.0.13 client build. An entry can be added to the configuration file, showcase.cfg, on the server, that would only accept connections from Showcase 9.1.0.13 or higher Client versions.

9.1.0.12 Client Patch (December 2017)

  • Error when connecting to Query using the 9.1.0.11 patch with JDE World A 9.3 when an invalid Environment is selected.
  • Issue resolved when saving query results to Text-Unicode the BOM marker was missing.

9.1.0.11 Client Patch (March 22, 2016)

  • Issue resolved where query client crashed when results were saved to Excel 4.0 if there were zero rows.
  • Unicode Byte Order Marker (BOM) now included when saving results to CSV-Unicode format, ensuring proper translation of double-byte character sets when opening in Excel.

9.1.0.10 Client Patch (August 5, 2015)

  • The default JDE Environment is always the last one in the list presented to EnterpriseOne users in Query. It has been changed to default to the most recent Environment selected.
  • The Query client timeout value set in Warehouse Manager (Resource Settings) now works for times more than 59 minutes.

9.1.0.9 Client Patch (January 6, 2015)

  • Showcase Addin for Excel:
    • Using VBA scripts to refresh queries failed after upgrading Client to 9.1.0.7 or 9.1.0.8.
    • Using the keyboard shortcuts Ctrl-C and Ctrl-V to copy and paste data from a query to Excel, generated an error similar to “Showcase Query The item, Data.R1C1:R3C1637348, does not match the Query application.”

9.1.0.8 Client Patch (November 19, 2014)

  • When editing the SQL of a Warehouse Builder Definition, the user selects Source\Query Editor and making valid changes to the SQL, clicking OK gives ‘X Encountered an improper argument’.
  • Queries with SQLServer data source are crashing or locking up Showcase Query client when the DBQ was created in a version of Showcase prior to version 8.0 (missing database owner name, which was not required in older versions), or if the Collection/Database name have changed (i.e. from lower case to mixed case).
  • Users open and run multiple queries against JDE data at a time. If they open and run a query, then immediately open another one, they get an error similar to ‘Column <”GLDCT01”> is not found in table’ specifying a UDC column.
  • Java Heap memory error when saving Query results to Excel 8.0 or 12.0 when the result set is very large (in excess of 300,000 rows and 160 columns). This requires setting the Java heap size on the client.

9.1.0.7 Client Patch (July 16, 2014)

  • Support added for SQL Server 2012. See the document, SQL Server Fix for Showcase 9.3 for details.

9.1.0.6 Client Patch (June 17, 2014)

  • Support for Roles added to JD Edwards World A9.3 (requires 9.2.0.1 Server Patch).
  • Query title is truncated to 31 characters when printing. Introduced in 9.1.

9.1.0.5 Client Patch (April 16, 2014)

  • One Showcase registry key value refers to IBM – corrected to remove that name.
  • On Windows7 64-bit PC’s, after printing to XPS or PDF output, Excel may hang when adding Showcase Query references.
  • Date format was incorrect when saving Query results to XLSX.

9.1.0.4 Client Patch (February 11, 2014)

  • JDE OneWorld or EnterpriseOne environments using Showcase with non-iSeries JDE profiles had batch jobs fail with SQL error, ‘Column “ XXXXXX” not in specified tables’.
  • The Warehouse Builder SET fails with a non DB2 datasource (SQL Server) with error, “An error was returned from the SQL CLI procedure SQLConnect. The SQL state is: HY000. The native error code is: 0. The message text is Unknown error attempting to access server SCVD02:43419: null..”
  • Enterprise Server log shows passwords in plain text
  • On Windows7 64-bit the File \ Send Mail option is missing from Query. The code was rewritten so that both Query and Report Writer will check for the presence of MAPI configuration in the Windows registry. If it can’t find that, it looks in the win.ini for MAPI settings. Finding either of these will cause the Send Mail option to be displayed.
  • Support for Windows 8.1 added.

9.1.0.3 Client Patch (December 17, 2013)

  • In version 9.1, every time a BATCHQUERY job is run, a QPRINT output file, with “Error opening debug file” in the text, gets created.
  • Pass the IP address for submitted jobs to the Showcase exit point program.
  • Batch query fails with an error similar to ‘The batch job failed due to a SQL error’. This same query will run fine interactively. The QSQSRVR job log attached shows an error, “Library not found.”

9.1.0.2 Client Patch (November 18, 2013)

  • Windows 8 Support.
  • Passwords in the scserver.log file will be encrypted.

9.1.0.1 Client Patch (August 19, 2013)

  • Improved query performance when running the same query simultaneously over large files (million plus records).
  • Saving query results to Excel with more than one million rows gives error: Excel found unreadable content in ‘file1.xlsx’.
  • DBQs created in 9.0.0.3 for SQLServer datasource which were created without OWNER name, now do not open in 9.1.0.0.
  • Report Writer doesn’t display the number of Most Recently Used (MRU) files that is configured in the Tools \ Options settings. It will not display any more than 4 previously open files regardless of what is configured for the number of files to display.
  • Removed nuisance message when creating Data Views (Server patch 9.1.0.1 required).

April 2019

Version 9.1.0.14 Client Patch
Enhancements
  • Windows Server 2016 support added.
Other Fixes
  • Copy paste from Showcase Query 9.1.0.13 (using Ctrl-C) to either Excel or iSeries screen adds a question mark '?' in front of the data.

The following patch updates are also included:

9.1.0.13 Client Patch (March 2018)

  • There is a new configuration option where the Showcase 9 server can be setup to reject requests from down level Client version. This is a new feature in the 9.4.0.2 server build and 9.1.0.13 client build. An entry can be added to the configuration file, showcase.cfg, on the server, that would only accept connections from Showcase 9.1.0.13 or higher Client versions.

9.1.0.12 Client Patch (December 2017)

  • Error when connecting to Query using the 9.1.0.11 patch with JDE World A 9.3 when an invalid Environment is selected.
  • Issue resolved when saving query results to Text-Unicode the BOM marker was missing.

9.1.0.11 Client Patch (March 22, 2016)

  • Issue resolved where query client crashed when results were saved to Excel 4.0 if there were zero rows.
  • Unicode Byte Order Marker (BOM) now included when saving results to CSV-Unicode format, ensuring proper translation of double-byte character sets when opening in Excel.

9.1.0.10 Client Patch (August 5, 2015)

  • The default JDE Environment is always the last one in the list presented to EnterpriseOne users in Query. It has been changed to default to the most recent Environment selected.
  • The Query client timeout value set in Warehouse Manager (Resource Settings) now works for times more than 59 minutes.

9.1.0.9 Client Patch (January 6, 2015)

  • Showcase Addin for Excel:
    • Using VBA scripts to refresh queries failed after upgrading Client to 9.1.0.7 or 9.1.0.8.
    • Using the keyboard shortcuts Ctrl-C and Ctrl-V to copy and paste data from a query to Excel, generated an error similar to “Showcase Query The item, Data.R1C1:R3C1637348, does not match the Query application.”

9.1.0.8 Client Patch (November 19, 2014)

  • When editing the SQL of a Warehouse Builder Definition, the user selects Source\Query Editor and making valid changes to the SQL, clicking OK gives ‘X Encountered an improper argument’.
  • Queries with SQLServer data source are crashing or locking up Showcase Query client when the DBQ was created in a version of Showcase prior to version 8.0 (missing database owner name, which was not required in older versions), or if the Collection/Database name have changed (i.e. from lower case to mixed case).
  • Users open and run multiple queries against JDE data at a time. If they open and run a query, then immediately open another one, they get an error similar to ‘Column <”GLDCT01”> is not found in table’ specifying a UDC column.
  • Java Heap memory error when saving Query results to Excel 8.0 or 12.0 when the result set is very large (in excess of 300,000 rows and 160 columns). This requires setting the Java heap size on the client.

9.1.0.7 Client Patch (July 16, 2014)

  • Support added for SQL Server 2012. See the document, SQL Server Fix for Showcase 9.3 for details.

9.1.0.6 Client Patch (June 17, 2014)

  • Support for Roles added to JD Edwards World A9.3 (requires 9.2.0.1 Server Patch).
  • Query title is truncated to 31 characters when printing. Introduced in 9.1.

9.1.0.5 Client Patch (April 16, 2014)

  • One Showcase registry key value refers to IBM – corrected to remove that name.
  • On Windows7 64-bit PC’s, after printing to XPS or PDF output, Excel may hang when adding Showcase Query references.
  • Date format was incorrect when saving Query results to XLSX.

9.1.0.4 Client Patch (February 11, 2014)

  • JDE OneWorld or EnterpriseOne environments using Showcase with non-iSeries JDE profiles had batch jobs fail with SQL error, ‘Column “ XXXXXX” not in specified tables’.
  • The Warehouse Builder SET fails with a non DB2 datasource (SQL Server) with error, “An error was returned from the SQL CLI procedure SQLConnect. The SQL state is: HY000. The native error code is: 0. The message text is Unknown error attempting to access server SCVD02:43419: null..”
  • Enterprise Server log shows passwords in plain text
  • On Windows7 64-bit the File \ Send Mail option is missing from Query. The code was rewritten so that both Query and Report Writer will check for the presence of MAPI configuration in the Windows registry. If it can’t find that, it looks in the win.ini for MAPI settings. Finding either of these will cause the Send Mail option to be displayed.
  • Support for Windows 8.1 added.

9.1.0.3 Client Patch (December 17, 2013)

  • In version 9.1, every time a BATCHQUERY job is run, a QPRINT output file, with “Error opening debug file” in the text, gets created.
  • Pass the IP address for submitted jobs to the Showcase exit point program.
  • Batch query fails with an error similar to ‘The batch job failed due to a SQL error’. This same query will run fine interactively. The QSQSRVR job log attached shows an error, “Library not found.”

9.1.0.2 Client Patch (November 18, 2013)

  • Windows 8 Support.
  • Passwords in the scserver.log file will be encrypted.

9.1.0.1 Client Patch (August 19, 2013)

  • Improved query performance when running the same query simultaneously over large files (million plus records).
  • Saving query results to Excel with more than one million rows gives error: Excel found unreadable content in ‘file1.xlsx’.
  • DBQs created in 9.0.0.3 for SQLServer datasource which were created without OWNER name, now do not open in 9.1.0.0.
  • Report Writer doesn’t display the number of Most Recently Used (MRU) files that is configured in the Tools \ Options settings. It will not display any more than 4 previously open files regardless of what is configured for the number of files to display.
  • Removed nuisance message when creating Data Views (Server patch 9.1.0.1 required).

March 2018

Version 9.1.0.13 Client Patch

    Enhancement:

  • There is a new configuration option where the Showcase 9 server can be setup to reject requests from down level Client version. This is a new feature in the 9.4.0.2 server build and 9.1.0.13 client build. An entry can be added to the configuration file, showcase.cfg, on the server, that would only accept connections from Showcase 9.1.0.13 or higher Client versions.

  • The following patch updates are also included:

    9.1.0.12 Client Patch (December 2017)

    • Error when connecting to Query using the 9.1.0.11 patch with JDE World A 9.3 when an invalid Environment is selected.
    • Issue resolved when saving query results to Text-Unicode the BOM marker was missing.

    9.1.0.11 Client Patch (March 22, 2016)

    • Issue resolved where query client crashed when results were saved to Excel 4.0 if there were zero rows.
    • Unicode Byte Order Marker (BOM) now included when saving results to CSV-Unicode format, ensuring proper translation of double-byte character sets when opening in Excel.

    9.1.0.10 Client Patch (August 5, 2015)

    • The default JDE Environment is always the last one in the list presented to EnterpriseOne users in Query. It has been changed to default to the most recent Environment selected.
    • The Query client timeout value set in Warehouse Manager (Resource Settings) now works for times more than 59 minutes.

    9.1.0.9 Client Patch (January 6, 2015)

    • Showcase Addin for Excel:
      • Using VBA scripts to refresh queries failed after upgrading Client to 9.1.0.7 or 9.1.0.8.
      • Using the keyboard shortcuts Ctrl-C and Ctrl-V to copy and paste data from a query to Excel, generated an error similar to “Showcase Query The item, Data.R1C1:R3C1637348, does not match the Query application.”

    9.1.0.8 Client Patch (November 19, 2014)

    • When editing the SQL of a Warehouse Builder Definition, the user selects Source\Query Editor and making valid changes to the SQL, clicking OK gives ‘X Encountered an improper argument’.
    • Queries with SQLServer data source are crashing or locking up Showcase Query client when the DBQ was created in a version of Showcase prior to version 8.0 (missing database owner name, which was not required in older versions), or if the Collection/Database name have changed (i.e. from lower case to mixed case).
    • Users open and run multiple queries against JDE data at a time. If they open and run a query, then immediately open another one, they get an error similar to ‘Column <”GLDCT01”> is not found in table’ specifying a UDC column.
    • Java Heap memory error when saving Query results to Excel 8.0 or 12.0 when the result set is very large (in excess of 300,000 rows and 160 columns). This requires setting the Java heap size on the client.

    9.1.0.7 Client Patch (July 16, 2014)

    • Support added for SQL Server 2012. See the document, SQL Server Fix for Showcase 9.3 for details.

    9.1.0.6 Client Patch (June 17, 2014)

    • Support for Roles added to JD Edwards World A9.3 (requires 9.2.0.1 Server Patch).
    • Query title is truncated to 31 characters when printing. Introduced in 9.1.

    9.1.0.5 Client Patch (April 16, 2014)

    • One Showcase registry key value refers to IBM – corrected to remove that name.
    • On Windows7 64-bit PC’s, after printing to XPS or PDF output, Excel may hang when adding Showcase Query references.
    • Date format was incorrect when saving Query results to XLSX.

    9.1.0.4 Client Patch (February 11, 2014)

    • JDE OneWorld or EnterpriseOne environments using Showcase with non-iSeries JDE profiles had batch jobs fail with SQL error, ‘Column “ XXXXXX” not in specified tables’.
    • The Warehouse Builder SET fails with a non DB2 datasource (SQL Server) with error, “An error was returned from the SQL CLI procedure SQLConnect. The SQL state is: HY000. The native error code is: 0. The message text is Unknown error attempting to access server SCVD02:43419: null..”
    • Enterprise Server log shows passwords in plain text
    • On Windows7 64-bit the File \ Send Mail option is missing from Query. The code was rewritten so that both Query and Report Writer will check for the presence of MAPI configuration in the Windows registry. If it can’t find that, it looks in the win.ini for MAPI settings. Finding either of these will cause the Send Mail option to be displayed.
    • Support for Windows 8.1 added.

    9.1.0.3 Client Patch (December 17, 2013)

    • In version 9.1, every time a BATCHQUERY job is run, a QPRINT output file, with “Error opening debug file” in the text, gets created.
    • Pass the IP address for submitted jobs to the Showcase exit point program.
    • Batch query fails with an error similar to ‘The batch job failed due to a SQL error’. This same query will run fine interactively. The QSQSRVR job log attached shows an error, “Library not found.”

    9.1.0.2 Client Patch (November 18, 2013)

    • Windows 8 Support.
    • Passwords in the scserver.log file will be encrypted.

    9.1.0.1 Client Patch (August 19, 2013)

    • Improved query performance when running the same query simultaneously over large files (million plus records).
    • Saving query results to Excel with more than one million rows gives error: Excel found unreadable content in ‘file1.xlsx’.
    • DBQs created in 9.0.0.3 for SQLServer datasource which were created without OWNER name, now do not open in 9.1.0.0.
    • Report Writer doesn’t display the number of Most Recently Used (MRU) files that is configured in the Tools \ Options settings. It will not display any more than 4 previously open files regardless of what is configured for the number of files to display.
    • Removed nuisance message when creating Data Views (Server patch 9.1.0.1 required).

December 2017

Version 9.1.0.12 Client Patch
  • Error when connecting to Query using the 9.1.0.11 patch with JDE World A 9.3 when an invalid Environment is selected.
  • Issue resolved when saving query results to Text-Unicode the BOM marker was missing.

  • The following patch updates are also included:

    9.1.0.11 Client Patch (March 22, 2016)

    • Issue resolved where query client crashed when results were saved to Excel 4.0 if there were zero rows.
    • Unicode Byte Order Marker (BOM) now included when saving results to CSV-Unicode format, ensuring proper translation of double-byte character sets when opening in Excel.

    9.1.0.10 Client Patch (August 5, 2015)

    • The default JDE Environment is always the last one in the list presented to EnterpriseOne users in Query. It has been changed to default to the most recent Environment selected.
    • The Query client timeout value set in Warehouse Manager (Resource Settings) now works for times more than 59 minutes.

    9.1.0.9 Client Patch (January 6, 2015)

    • Showcase Addin for Excel:
      • Using VBA scripts to refresh queries failed after upgrading Client to 9.1.0.7 or 9.1.0.8.
      • Using the keyboard shortcuts Ctrl-C and Ctrl-V to copy and paste data from a query to Excel, generated an error similar to “Showcase Query The item, Data.R1C1:R3C1637348, does not match the Query application.”

    9.1.0.8 Client Patch (November 19, 2014)

    • When editing the SQL of a Warehouse Builder Definition, the user selects Source\Query Editor and making valid changes to the SQL, clicking OK gives ‘X Encountered an improper argument’.
    • Queries with SQLServer data source are crashing or locking up Showcase Query client when the DBQ was created in a version of Showcase prior to version 8.0 (missing database owner name, which was not required in older versions), or if the Collection/Database name have changed (i.e. from lower case to mixed case).
    • Users open and run multiple queries against JDE data at a time. If they open and run a query, then immediately open another one, they get an error similar to ‘Column <”GLDCT01”> is not found in table’ specifying a UDC column.
    • Java Heap memory error when saving Query results to Excel 8.0 or 12.0 when the result set is very large (in excess of 300,000 rows and 160 columns). This requires setting the Java heap size on the client.

    9.1.0.7 Client Patch (July 16, 2014)

    • Support added for SQL Server 2012. See the document, SQL Server Fix for Showcase 9.3 for details.

    9.1.0.6 Client Patch (June 17, 2014)

    • Support for Roles added to JD Edwards World A9.3 (requires 9.2.0.1 Server Patch).
    • Query title is truncated to 31 characters when printing. Introduced in 9.1.

    9.1.0.5 Client Patch (April 16, 2014)

    • One Showcase registry key value refers to IBM – corrected to remove that name.
    • On Windows7 64-bit PC’s, after printing to XPS or PDF output, Excel may hang when adding Showcase Query references.
    • Date format was incorrect when saving Query results to XLSX.

    9.1.0.4 Client Patch (February 11, 2014)

    • JDE OneWorld or EnterpriseOne environments using Showcase with non-iSeries JDE profiles had batch jobs fail with SQL error, ‘Column “ XXXXXX” not in specified tables’.
    • The Warehouse Builder SET fails with a non DB2 datasource (SQL Server) with error, “An error was returned from the SQL CLI procedure SQLConnect. The SQL state is: HY000. The native error code is: 0. The message text is Unknown error attempting to access server SCVD02:43419: null..”
    • Enterprise Server log shows passwords in plain text
    • On Windows7 64-bit the File \ Send Mail option is missing from Query. The code was rewritten so that both Query and Report Writer will check for the presence of MAPI configuration in the Windows registry. If it can’t find that, it looks in the win.ini for MAPI settings. Finding either of these will cause the Send Mail option to be displayed.
    • Support for Windows 8.1 added.

    9.1.0.3 Client Patch (December 17, 2013)

    • In version 9.1, every time a BATCHQUERY job is run, a QPRINT output file, with “Error opening debug file” in the text, gets created.
    • Pass the IP address for submitted jobs to the Showcase exit point program.
    • Batch query fails with an error similar to ‘The batch job failed due to a SQL error’. This same query will run fine interactively. The QSQSRVR job log attached shows an error, “Library not found.”

    9.1.0.2 Client Patch (November 18, 2013)

    • Windows 8 Support.
    • Passwords in the scserver.log file will be encrypted.

    9.1.0.1 Client Patch (August 19, 2013)

    • Improved query performance when running the same query simultaneously over large files (million plus records).
    • Saving query results to Excel with more than one million rows gives error: Excel found unreadable content in ‘file1.xlsx’.
    • DBQs created in 9.0.0.3 for SQLServer datasource which were created without OWNER name, now do not open in 9.1.0.0.
    • Report Writer doesn’t display the number of Most Recently Used (MRU) files that is configured in the Tools \ Options settings. It will not display any more than 4 previously open files regardless of what is configured for the number of files to display.
    • Removed nuisance message when creating Data Views (Server patch 9.1.0.1 required).

June 2013

Version 9.1 Client Install
  • Required for the batch query fix against iASP data.
  • Fixes the ODBC Administrator error when trying to add a new Showcase data source in Windows 7.
  • Fixes the copy/paste problem where a Unicode marker is accidentally copied to the clipboard (shows up as a question mark).
  • Query properties for Last and Total Run Time are empty on a 9.0.0.4 client.
  • Batch Query on IASP data is failing.
  • In 9.0.0.4 clients, you can’t type in a table name and the drop down is blank.
  • “Query Feature Executable” error when doing File \ Open on Windows 7.
Showcase Adapter
  • Internet Explorer error ‘Expected end of statement – openXLR’ when opening a web-enabled addins XLR from Deployment Portal, only when name contains spaces.

 

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