What's New in SAP Accelerators by Syniti 6.6.1

This topic contains:

Enhancements

Advanced Data Migration (ADM)

Target Design

A warning message has been added when deactivating a key field in Target Design. The KEY FIELD check box must be unchecked before the field can be deactivated.

Online Help

Data Stewardship Platform (DSP)®

Common

Excel Integration has been enhanced on the User Management page to allow an Administrator to add and manage user accounts. Fields required for account maintenance were added to the Excel spreadsheet downloaded from the User Management page. Refer to Create and Manage User Accounts in Common for more information.

dspCompose™

A Template Administrator can now set the target system connection for each process template in a request or external request scenario by clicking the Connections Icon on the following pages:

The connections set for process templates associated with a request can also be viewed by clicking the Connections icon on the Request (Post) page.

The following pages have been added for use with this setting:

  • Template (External Request Scenarios Connections
  • Request Post Connections
  • Request Connections

Resolved Issues

Advanced Data Migration (ADM)

Console

An issue occurred when selecting the Report Column Qualifier setting while configuring Transform parameters in Console. The qualifier is used to delineate column data containing spaces or special characters. When the user selected a pipe (|) for the qualifier, the downloaded report data used a comma as a delimiter instead of a pipe. With the fix, the pipe character is used correctly as a delimiter in the downloaded .txt file. [DSP-7531]

SQL AutoGen

An error that prevented a user from rebuilding a Full Construction source table and page has been corrected. [DSP-9183]

Transform

  • An issue occurred in Transform where the Instruction column was not formatted correctly. With this fix, the Rule Book report in Transform has been improved by removing the improperly formatted Instruction column and adding the Rule SQL and Rule Where Clause columns. In addition, the Rule Book report on the Target Source Rule Book page in Map has been improved by adding the Rule SQL and Rule Where Clause columns. [DSP-7362]

  • An issue occurred in Transform with cached reports that used the Report Order By setting. The reports were not sorted correctly. With the fix, reports sort as configured in the Report Order By field. [DSP-6498]

  • The field description for the Source Rule Table field on the Target Source Rules page has been improved with a note that informs users that the Source Rule Table field must be blank to insert or delete rules. [DSP-9439]

Data Stewardship Platform (DSP)®

  • An issue occurred with the location of the Admin item in the Navigation pane. It displayed incorrectly below Reports. With the fix, the Admin item displays below the System item. [DSP-9174]
  • When the user clicked the help icon in DSP Add Ons, the product help opened, which did not contain help for DSP Add Ons. With the fix, the DSP Add Ons help displays correctly when the user clicks the help icon on any DSP Add Ons page. [DSP-9055]
  • An issue occurred in the DSP Platform where custom authentication would fail with passwords that contained uppercase letters. With this fix, custom authentication allows passwords with uppercase letters. Refer to the BOA Solutions Configuration Authentication Manual for Windows Server 2008 and 2012 for more information about authentication methods.[DSP-8166]

  • An issue occurred in System Administration when installing 6.6 where the Audit Table Exists service page failed because of invalid records in the CranSoft.dbo.Audit table. With this fix for 6.6.1, the invalid records have been removed and the service page runs as expected.[DSP-9402]

Collect

  • An issue occurred in Collect with table refresh when the Recycle Job Max parameter was set to 0 on the Parameters – Collect page in Common. The Recycle Job Max parameter controls the number of times the download process is recycled. If the job fails, the table is recycled into the job queue at the end of the current cycle. With this fix, any working table registrations are refreshed as expected. If Recycle Job Max is set to 0, the job isn’t recycled, as expected. [DSP-9170]
  • On the Parameters - Collect page, DBMoto Settings tab, the field name Server Address has been updated to Server Name for clarity.[DSP-9217]

  • An issue occurred in Collect where the default column delimiters for ODBCSYBASE connection types were not automatically configured in the Left Column Delimiter and Right Column Delimiter values on Source Connection Types page's Vertical View. With this fix, the correct values are defaulted on the Vertical View. [DSP-9154]

  • An issue occurred in Collect on the Tables page where an error would display when a user accessed the page's Vertical View if many (in excess of 300) sources were registered. The issue was caused by the views used to calculate the Record Count for the table. With this fix, the following updates have been made to correct the issue:

    • Inactive sources are no longer counted.

    • The Max Record Sources For Union View parameter has been added in Common to the Parameters – Collect page, General Settings tab. If the number of sources registered exceeds the threshold set by this parameter, no Record Count is calculated and the Record Count field on the Tables page’s Vertical View is 0. [DSP-9085]

Common

  • An issue caused an error in Common on the User Management page's Vertical View when updates were saved. The calendar ID parameter was not being supplied. With this fix, the calendar ID parameter is supplied and user information can be saved. [DSP-9176]

  • An issue occurred in Common on the System Types Model Group Tables page that allowed duplicate tables to be assigned to a Model Group. This caused the System Type Model Group import to fail. With this fix, duplicate tables have been removed from the delivered System Type Models and validation prevents users from adding the same table to a group multiple times.[DSP-9094]

  • An issue occurred in Common when importing a System Type from a System Type Model Group. Lookup and description tables associated with the tables in the Model Group were not imported. With this fix, when importing a table from a model group, all tables along with their associated descriptions and lookup tables are imported. Refer to Import a Model for more information. [DSP-7519]

  • An issue occurred in Common > Configuration > System Type Models where the Value field in the MODEL VIEW: TABLE FIELD STATIC VALUE LIST was limited to NVARCHAR(10). With this fix, the Value field is now set to, NVARCHAR(128). Refer to View Fields Required for System Type Tables for more information. [DSP-9219]

  • An issue occurred in Common where the table names were not displayed on the System Types Groups page. A GUID was displayed in place of the table name. With this fix, the System Types Groups page is not populated by the import process until the System Type Tables have been populated and a System Type Table ID exists. [DSP-9231]

  • An issue occurred in Common when importing a System Type model with a NULL language field in the description table. The description table fields were not imported. With this fix, the description table and field with a NULL value for the language column is imported. Refer to Import a Model for more information. [DSP-9257]

  • An issue occurred in Common on the System Type Models page where validation was failing for fields in views when the fields were correct. With this fix the correct view is validated and only fields that are missing or incorrect are marked as invalid. [DSP-9232]

  • An issue occurred when adding a record on the System Types Tables page in Common when a user accessed the page from the Horizontal View of the System Types page. The user could enter data and attempt to save, but the record was not added to the database. With this fix, records added on the System Types Tables page are now saved to the database as expected. [DSP-9220]

  • An issue occurred when importing a System Type from a System Type Model in Common. If the data source for the System Type Model was not DSPCommon, the import failed. With the fix, a System Type imports successfully, using the data source from the System Type Model, whether it is DSPCommon or not. [DSP-9258]

  • An issue occurred when importing a non-SAP System Type Model into a System Type. SAP was hard coded as the source connection type, preventing field data types from importing properly. A field has been added to the System Types Models page to allow the user to select a source connection type for the System Type Model. The available source connection types are configured in Collect and provide a mapping from the data type supplied in the Table Field Model View to a valid SQL Server data type. If a mapping does not exist in the connection type, DSP will directly pass the data type from the Table Field Model View into the System Type on import. [DSP-9230]

Integrate

In Integrate, an issue that caused slow performance while loading data with large record sets has been corrected with the addition of SQL indexes. [DSP-7532]

Online Help

  • In the topic Keyboard Shortcuts, the Date Time picker shortcuts have been updated because they were incorrect. [DSP-8984]
  • In the topic View the Construction Page in Construct, the typo "Contract" was corrected to "Construct." [DSP-9186]
  • When the user clicked the help icon in DSP Add Ons, the product help opened, which did not contain help for DSP Add Ons. With the fix, the DSP Add Ons help displays correctly when the user clicks the help icon on any DSP Add Ons page. [DSP-9055]
  • The topic Synchronize a Template Role’s Excel Column Control Settings with the Template Role’s Assigned Platform Page has been replaced with Import a Column Added to the Role’s Assigned Page to reflect current functionality. The description of the Import Columns button on the Template (Role Excel Column Control) page has also been updated. [DSP-9290]
  • The steps for the All Objects page have been updated to reflect the correct navigation. In the topic Append Columns to all Target or Source Tables in Target Design,"or edited" was removed from the note below as there is no Edit button on the page.
    NOTE: The zSource column is installed with the platform and cannot be deleted. [DSP-9329]

dspCompose™

  • Any dspCompose™ Archive Compare tables - rtxxxCompare - that were created prior to 6.6 have ArchiveID defined as an Identity field. In 6.6, the Compare tables do not have the ArchiveID as an Identity field.
    • During the upgrade, these Compare tables should be modified to drop the Identity field for the existing Compare tables.
    • Templates in 6.6 and later will create rtxxxCompare tables with a foreign key from ArchiveID to rt table ArchiveID. [DSP-9331]
  • An Internal Error occurred when a posting failed for a dspCompose™ request under certain conditions. During the posting process, if no record was written into the rt table, the process still attempted to insert a record into the rt Compare table, causing the error. With the fix, the process does not attempt to insert a record into the rt Compare table, and the Internal Error no longer occurs. [DSP-9337]

Enhancement Request From the User Base

Fields have been added to dspCompose™ and Integrate pages to provide users with more details about when scheduled posts will run.

  • On the dspCompose™ Request (Roles) page, these fields have been added to the Vertical View:
    • Scheduled Post Start Time — Displays the time the schedule background post runs.
    • Integrate Posting ID — Click the link to open the Post Monitor page in Integrate for details about this posting.
  • On Integrate’s Post Monitor page, these fields have been added to the Vertical View:
    • Posting Placed In Queue — Displays the time when a user clicked the Schedule Post icon on the Request (Post) page
    • Post Scheduled To Start — Displays the post start time as set on the Request (Post) page’s Vertical View.
    • Post Scheduled By — Displays the user ID of the user who clicked the Schedule Post icon on the Request (Post) page.

 

WARNING: Customizations made to any component of the delivered Syniti Solutions will be overwritten in the next upgrade. To preserve customizations, make a copy of the customizations prior to applying any upgrade.

A customization is a change to the underlying source code, which differs from configuration – normal setup of the software, such as setting up workflows and defining parameters via the configuration pages.

Previous Versions

NOTE: 6.5.4 and 6.5.5 versions of SAP Accelerators by Syniti were not released. The immediately prior release to 6.5.6 was version 6.5.3.

NOTE: A 6.4 version of SAP Accelerators by Syniti was not released. The immediately prior release to 6.5 was version 6.3.1.

Help Build Date: March 08, 2022 12:37:51 PM