Previous versions

Neue Funktionen und Verbesserungen in Version 10.6/10.7 > Previous versions

Zurück zu

Neue Funktionen und Verbesserungen in Version 10.6/10.7

Ebenfalls in diesem Abschnitt

Behobene Fehler in den Versionen 10.6/10.7

Bekannte Probleme in Query Version 10.6 GA

Previous versions

Neue Funktionen in 10.5 GA

Joins zwischen allen Feldern werden von dem Winshuttle-Funktionsmodul für QUERY unterstützt.
Falls falsch zugeordnete Felder in der Abfrage enthalten sind, erscheint vor Anzeige der Abfrageergebnis-Vorschau und der Anzahl der Einträge eine Warnung.
Winshuttle QUERY ist zu Windows 8 kompatibel.
Winshuttle QUERY ist zu Microsoft Office 2013 kompatibel.
Winshuttle CENTRAL ist zu Microsoft SharePoint 2013 kompatibel. Hinweis: SharePoint 2013 läuft nur mit Produkten von Winshuttle Version 10.5.
Das Winshuttle RUNNER-Add-in läuft unter Microsoft Excel 2013.
Winshuttle QUERY ist kompatibel mit SAP GUI 7.30.
Es steht eine Stopp-Schaltfläche zur Verfügung, um Auto-Join-Prozesse anzuhalten, wenn keine Joins gefunden werden.
Die Dokumentation für Winshuttle-Produkte ist in der Webhilfe des Produkts verfügbar . PDF-Dokumente sind nicht länger verfügbar.
Abfrageergebnisse können vorab angezeigt werden, sofern das Adaptive Query Throttling aktiviert wurde. (Hotfix 10.4.1)
Die Anzahl der Einträge kann angezeigt werden, sofern das Adaptive Query Throttling aktiviert wurde. Beachten Sie, dass die Resultate von denen eines SQL-Laufs abweichen können, wenn das Adaptive Query Throttling nicht aktiviert wurde. (Hotfix 10.4.1)

In Version 10.5

QUERY und RUNNER für QUERY

Alle Mehrtabellen-Skripte mit Kriterien verursachen eine SQL Lite-Ausnahme auf NON-FM-Server W4I
Die Abfrage mehrerer Tabellen verursacht eine ZEITÜBERSCHREITUNG, wenn sowohl „Alle Extrahieren" als auch EAQT im WFB 10.4 GA unter W4Q zusammen markiert werden
Bei Ausführung von XML, die Felder mit negativen Werten enthalten, wird ein Minuszeichen hinter dem Wert angezeigt (Nur bei FM-Lauf)
Excel-Ausdrücke funktionieren nicht mehr, wenn nach dem ersten Lauf "Daten an Ergebnisdatei anhängen" verwendet wird
Störungsmeldung beim Ausführen in WFM, wenn Datentypfelder LANG und DECIMAL verknüpft werden.
Störungsmeldung beim Ausführen in WFM, wenn Datentypfelder DECIMAL und STRING verknüpft werden.

QUERY

„Ungültige Select"-Anweisung tritt in Skripten auf, die mit QUERY verknüpft sind

CENTRAL/SERVER

Unterstützung der Funktion WFB-Trace in Server

Behobene Fehler in Version Winshuttle Funktionsmodul 10.4 Hotfix 1

Abfrageergebnisse können vorab angezeigt werden, sofern das Adaptive Query Throttling aktiviert wurde.
Die Anzahl der Einträge kann angezeigt werden, sofern das Adaptive Query Throttling aktiviert wurde. Beachten Sie, dass die Resultate von denen eines SQL-Laufs abweichen können, wenn das Adaptive Query Throttling nicht aktiviert wurde.

10.4 GA

QUERY und RUNNER für QUERY

Mehrtabellen-Joins ohne Winshuttle Funktionsbaustein (WFB)
Unterstützung von Left Outer Joins auf dem Nicht-WFB-System
Unterstützung von Alias-Tabellen auf dem Nicht-WFB-System
Einzelfeldsortierung für XML und SharePoint-Ausgabeziel
Dynamisches Generieren des Ausgabedateinamens möglich
Neue Integration zur Scheduler-Komponente
Verbesserung bei der „Hintergrundverarbeitung auf SAP" von Mehrtabellen-Querys
Option zur Hintergrundverarbeitung auf „Run"-Bildschirm
Chunking-Begrenzung entfällt

QUERY

Zulassen von JOINS zwischen nicht übereinstimmenden Feldern
Identifikator Query Auto-Tabelle
Sortieren des Selektionskriterienbereichs möglich
Direktes Hinzufügen von Tabellen zu QB ohne Suchen
Zulassen von Extrahieren von Langtextfeldern

Version 10.4 GA

QUERY und RUNNER

Pflichtfelder im Eingabeformular für die Laufzeitvariablen

CENTRAL/SERVER

Ein neuer Parameter für die Query-Entwicklerleistungsstufe wurde hinzugefügt: „Manuelle Erstellung von Joins zwischen falsch zugeordneten Feldern erlauben." Version 10.4 GA

QUERY und RUNNER

Pflichtfelder im Eingabeformular für die Laufzeitvariablen

CENTRAL/SERVER

Ein neuer Parameter für die Query-Entwicklerleistungsstufe wurde hinzugefügt: „Manuelle Joins-Erstellung zwischen falsch zugeordneten Feldern erlauben."

Behobene Fehler

QUERY und RUNNER

Bei Instanzen von Server W4I ohne Winshuttle-Funktionsmodul verursachen alle Mehrtabellen-Skripte mit Kriterien eine SQLITE-Störungsmeldung.
Die Mehrtabellen-Abfrage verursacht eine ZEITÜBERSCHREITUNG, wenn sowohl „Alle Extrahieren" als auch EAQT im WFB 10.4 GA unter W4Q zusammen markiert werden.
Bei Umgebungen mit Winshuttle-Funktionsmodul wird bei Ausführung von XML für Felder mit negativen Werten ein Minuszeichen hinter dem Wert angezeigt.
Bei Verwendung der Einstellung „Daten an Ergebnisdatei anhängen" funktionieren Excel-Ausdrücke nach dem ersten Ausführen nicht.
Störungsmeldung beim Ausführen einer Abfrage mit Winshuttle Funktionsmodul, wenn Datentypfelder LANG und DECIMAL verknüpft werden.
Störungsmeldung beim Ausführen einer Abfrage mit Winshuttle Funktionsmodul, wenn Datentypfelder DECIMAL und STRING verknüpft werden.

QUERY

Ungültige Select"-Anweisung tritt in Skripten auf, die mit QUERY verknüpft sind.

Added in Version 10.3

NEW FEATURES/MINOR IMPROVEMENTS

QUERY and RUNNER for QUERY

Support for run-time variables for all linked QUERY scripts in a chain.
When calling a query-as-a-service:
- A method is implemented that returns the number of entries.
- A parameter in the query input is added that limits the number of records returned.
Ability to abort a running QUERY script execution.
- On aborting a QUERY, the process is also killed on the SAP side and lingering chunks are removed.

QUERY

Users have the option to apply padding or leading zeros.
SharePoint lists are added to the available output destinations for SAP data.
For multiple-table QUERY scripts, the WFM can process the RFC in the background.

Bugs fixed

QUERY and RUNNER in version 10.3

Improvement to manage multi-table query execution on SAP version 4.7 to fix issue related to GENERATE_SUBPOOL_DIR_FULL
SSO works with QUERY as a Service.

CENTRAL/SERVER

Query Caching for Web Services – in Web Service Designer you can specify to cache a particular query either in memory or in a database. Subsequent requests to the Winshuttle Server will return results from the cache.
Support for Query autopost using Windows username and password (SSO) for 32-bit/64-bit computers.
Support for using Windows username and password (SSO) for consuming web services.
Support for passing SAP Credentials Object as a part of autopost call for Query.
The Web Service Autopost API in CENTRAL for Query has been exposed.
New site preference to allow users to manage String Padding of criteria. The default value will be false.

Added in Version 10.2

NEW FEATURES/MINOR IMPROVEMENTS

QUERY and RUNNER for QUERY

Link Script setting has been introduced to automatically launch and execute another QUERY script in sequence a current QUERY script has finished running.
QUERY Log Viewer will display execution logs for jobs with two additional fields Output fields and Selection fields. Failed jobs will appear in Red.
Proper Warning message is shown when Exchange Server information is Wrong to send an E-mail for Scheduler
Dutch and Spanish locales are now supported
QUERY can be scheduled on Winshuttle Server
Separate installers available for machines with MS Office 32 bit and 64 bit.

QUERY

You can now record the Transaction Codes in QUERY to capture Tables and the fields that are being modified. A category has been provided in the Data Dictionary, called Recorded Transactions
Left outer joins for SAP tables are now supported.
Search in SAP Data Dictionary - to bring back the Table Descriptions. When searching for SAP tables using wild cards or by field name, users will be able to see the table text description.
Auto Joins are improved and default join is now provided between Primary key & Index Key.
An option is provided to restrict query to be published as a web service.
Orphan Chunk records in SAP from terminated chunking queries are now cleared automatically
Custom Security Check is incorporated in WFM (Winshuttle Functional Module) where a customer can add custom code with custom authorization check for security check.
You can restrict access to SAP tables for users through Winshuttle CENTRAL Administration.

BUGS FIXED

QUERY and RUNNER

Function module "SXMS_TIMEDIFF_SEC" not found message when attempting table joins, can’t find SAP tables, Admin Defaults not retained.
On Autoposting a large query file the SERVER usage climbs upto 90%
Unable to read and write to same excel file
Custom Tables not displaying in 10.1 in different SAP version environments

CENTRAL/SERVER

Localization Support – French, German, Spanish and Dutch for SharePoint 2007 & 2010
Central License Administrator can delete the Expired License
Published Web Services will be visible to all Users with delete permissions to only self-owned services. Site Collection Admin can delete all the published Web Services
Configurable Email Templates
NINTEX Activity for Autopost on SharePoint 2007 & 2010
32 bit and 64 bit Installer for Winshuttle Server
Ability to pass Windows User Name and Password to use SSO in case of SAP
Variable target URL in published web services.
Support for Load Balancer for Winshuttle Server
Support for UTF character in Web Service Name
Run later (Server) for Excel/SQL destination type QUERY scripts
QUERY policies for Restricted Table access
Linked QUERY Support in CENTRAL
Scheduling a query script on SERVER via Add-In
Run with SAP credentials for QUERY web services.

Added in Version 10.1

NEW FEATURES/MINOR IMPROVEMENTS

QUERY & RUNNER

Support for MS Office 2010
The number of tables you can join in your query has been increased from 9 to 25
The number of WHERE clause values which can be used in a QUERY has been increased
Tables used in the QUERY to be listed in the log viewer
New comprehensive list of T-codes and their related tables have been added
User will be notified whenever query output is filtered as per user authorizations

BUGS FIXED

QUERY and RUNNER

Infoset/SAP Queries security – User can now run only those Infosets/SAP Queries which are associated with the user group he belongs to
Unable to run SQL query using SSO logon
Log Viewer displays log of only one query when two queries are run simultaneously
Unable to query tables starting with "/"
Incorrect SAP details should not allow user to go ahead in query schedule wizard
Unable to run SQL queries on CRM (when router string is used)
An error occurs after generating support shuttle file
Log records not written for unsuccessful scheduled Runs on sqlSHUTTLE using SSO logon
Default table joining doesn’t happen with alias table when base table is deleted and then added

Added in Version 10

Note: In version 10.0 querySHUTTLE is rebranded as Winshuttle QUERY and xSHUTTLE as Winshuttle RUNNER for QUERY.

NEW FEATURES

QUERY & RUNNER

Queries can be created using 2 new data sources
Infosets
Logical databases
Even the SAP queries predefined on SAP servers can be run using Winshuttle QUERY
Renovated criteria builder pane for better usability experience
Enhanced QUERY performance with optimization in both QUERY and Winshuttle function module (WFM)
Usage of Microsoft Excel formulae in mapping stage to transform data before downloading
Support for queries of lengths more than 4000 chars with maximum limit of 65536 chars
Ability to run Queries using Excel macros
Advanced encryption standard used for ALF encryption
All admin restrictions will be shown to users while creating a query
Ability to delete user specified tables of the local data dictionary
Size of application window can now be changed
New application option to get the debug information for quick problem resolution

BUGS FIXED

QUERY and RUNNER

Limit of 250 records for evaluation license not respected while downloading records in case of command prompt
Adding any Table to favorite’s category -- the table description is always truncated
Incorrect Query Manager Search
Combination of Write Headers option with "Append data" or "Overwrite Data" doesn't write the headers in the result file
In QM Search, it is impossible to search a query without entering wildcards with table / field name criteria
In excel add-in all fields are clickable (working) during the run process (Extraction and writing of data).
Excessive flickering of screens
Time out setting – least of values set on WFM or client to be respected

Added in querySHUTTLE version 6.2:

BUGS FIXED

querySHUTTLE & xSHUTTLE

Unlimited download to SQL server with evaluation license
By default SQL Server destination type name doesn't get enabled in mapper screen
Query which is suppose to extract records with field not null, extracts all records with null field
Latest version of Windows Live Messenger affects querySHUTTLE and xSHUTTLE
Incorrect functionality of e-mail settings in application options in few cases
Running a query having fields with '/' in their name sends an exception
Advanced run option "Overwrite Existing Data" does not save its state once control is out of it
The RFC Read table had a bug which would cause an alignment error on trying to read MARD and other tables from SAP release 4.7
In QM Search, it is impossible to search a query without entering wildcards with table / field name criteria

querySHUTTLE

Queries can be scheduled for date even after license expiry when SQL server is the destination type
After removing a join, if another table is added, the join comes back
Unable to use the wildcard ‘*’ while setting the field criteria
VIEWS not supported by standard SAP (SQ02 transaction) allowed to be used in query builder
Search in Winshuttle Data Dictionary does not show unique values of the results
Not able to run a SQL Server query in VISTA (as Virtual PC)

xSHUTTLE

Query builder options shown in admin options which is of no significance
xSHUTTLE add-in crashes when graphical object exists with macros in MS excel 2007

NEW FEATURES

querySHUTTLE & xSHUTTLE

querySHUTTLE and xSHUTTLE are now available in French and German languages
Backward compatible of querySHUTTLE and xSHUTTLE clients with older Winshuttle Function Module (WFM) versions (till WFM version 6.1)
No. of entries for multi-table queries
Chunking for multi-table queries
Default chunk size for single table queries which enhances query performance
Customizable path for SAP logon.ini file
A more comprehensive Data Dictionary with additional tables which are commonly used
Delete option provided on Authorization fields table in admin options
Validation checks added in WFM while adding authorization objects on WFM
Zoom in feature on the query builder area and also on individual tables
To aid in troubleshooting, trace file can be written for queries
Option to run queries directly on the SAP server or to use the Winshuttle adaptive query throttling algorithm. Running a query directly on the SAP server can improve query performance
Improvements to command line functionality
Download data to SQL Server
Suppress application window while the query is running
View WFM version on querySHUTTLE/xSHUTTLE client
Undo option in mapper screen
Query scheduling - attaching the data file to an email
querySHUTTLE extracts do not seem to respect field formats in Excel

querySHUTTLE

An online library of templates that represent commonly used queries across various SAP components
Joining a table to itself or its aliases
Restore Winshuttle master Data Dictionary
Listing all possible joins between tables added in query builder area
Query files can be published to both excel files and templates
F4 (help) retrieves field descriptions
Automatic padding of leading zeroes while setting field criteria
Prominence given to table views, index fields and primary key fields. Warning messages thrown whenever non-index fields used in join creation and setting criteria
Operators ‘<’ and ‘>’ can be used in criteria pane

xSHUTTLE

Allow update mapping
Redesign of xSHUTTLE add-in
xSHUTTLE add- in support for MS Excel 2002 and 2003

Added in querySHUTTLE version 6.1:

BUGS FIXED

querySHUTTLE & xSHUTTLE

In the Query Builder, using criteria for a SAP field of data type ‘decimal’ in a multiple table query sends an error in certain scenarios
Advanced Run Options: Query Execution Timeout is not functioning correctly
‘Scheduled Run’ notification email format is incorrect
Unable to set ‘TAB’ delimiter in text output
‘IN’ operator using a value containing ‘AND’ enclosed with spaces causes an error in ECC 6 and ECC 5 Winshuttle Function Module
"Clear result file" option clears the entire spreadsheet instead of only clearing the data portion of the excel file
While extracting data from the ‘PCL2’ HR table, the long text field data is encrypted
'Disable / Enable querySHUTTLE add-in in ‘Options’ does not work correctly
When using macro-enabled workbooks in Office 2007, querySHUTTLE automatically adds a file extension

querySHUTTLE

The publish button is disabled on opening a file. This appears enabled again after ‘Run’
The button 'Add selected Table(s) to Query builder' is not disabled while adding tables to the Query Builder
Auto mapping a file having more than 255 fields does not send a warning message when MS Office 2003 is used

xSHUTTLE

‘Show query text’ button is not disabled

NEW FEATURES

querySHUTTLE & xSHUTTLE

querySHUTTLE and xSHUTTLE are now compatible with SAP release 4.7
querySHUTTLE and xSHUTTLE are now compatible with SAP CRM
Log Viewer - The ‘run reason’ column is added
SSO (Single Sign On) and EP (Enterprise Logon) options are now compatible
Progress indicators have been changed and added in relevant locations
Users can now extract data to SQL server databases
Users can now specify the ‘Log Column’ in the command line
Query execution timeout parameter has now been added to the Winshuttle Function Module
sqlSHUTTLE – this has been designed and developed for the ability to schedule a query to execute when the user is either not connected to the enterprise or when they do not want the query to be executed from their workstation/PC
querySHUTTLE and xSHUTTLE have now been designed to work without the Winshuttle Function Module being present on the SAP system. Single table queries will only be possible if the Winshuttle Function Module is absent. The SAP profile security functionality present through the Winshuttle Function Module is now applicable through the client also.
Regional settings support across application for date/time/number formats
supportSHUTTLE has been added into querySHUTTLE and xSHUTTLE
An Excel file can now be used to hold a list of values for SAP field criteria
Implementation of manual De-Activation process
Implementation for evaluation extension key support
CD image distribution – consolidation of all files including installation files into a single MSI based installer
The HR data cluster table PCL2 can now be used to extract data (long text)
‘query execution time out’ is now added in the ‘Admin Options’
From the Application options, it is now possible (configurable) to specify where the Data Dictionary should be picked up from
New tables have been added to the standard Winshuttle Data Dictionary

querySHUTTLE

In the Data Dictionary, users can now add their own transaction codes

Added in querySHUTTLE version 6.0 Update 1:

BUGS FIXED

querySHUTTLE & xSHUTTLE

Users cannot extend their evaluation licenses using extension keys

NEW FEATURES

querySHUTTLE & xSHUTTLE

querySHUTTLE and xSHUTTLE are now compatible with SAP release ECC 5.0
The deactivation process has been improved to allow users to deactivate licenses manually if they are unable to use automatic deactivation due to loss of internet connectivity