IMPORTANT WARNING: Please note that the release notes below are divided into two sections. The first section describes fixes specific to Gentran:Server for Windows product, whereas the second describes fixes associated with the Common Component Translator shared with other Gentran products. To ensure you understand all the changes affecting your product version for a given patch number, you need to review both sections. ========================================================================= PATCH RELEASE NOTES IBM® Sterling Gentran:Server® for Microsoft Windows 5.3 Patch 4 ========================================================================= ************************************************************************** PATCH 1 ************************************************************************** QC DEFECT: 1420 DATE: 5/23/11 MODULE: Mercury.exe, MClient.exe, Mercui30.dll, MBoxArc.exe, MailboxArchive.dll, XAGENT30.DLL, Mbfile30.dll, MBMAPI30.dll, fpi.dll, GentranAdapter.dll, SAPAdapter.dll, SAPServer.exe, Gencom97.exe, GenComUI.dll, ComStart.exe, InsCnvrt.exe, PROBLEM DESCRIPTION: The install program has an issue with Windows XP 32-bit client joining to a Windows 2008 64-bit server. The reason for this error is because the client is unable to access the server's registry. On a 64-bit GSW server, the "HKEY_LOCAL_MACHINE\SOFTWARE\Sterling Commerce" registry key does not exist. 64-bit Windows automatically redirected it to "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sterling Commerce" instead. This is not an issue for a Win2003, Vista, or Win7 client. Those newer operating systems automatically handled the remote registry redirections. This only happens on a XP client. FIX DESCRIPTION: Modified the core registry class to use the KEY_WOW64_32KEY flag in registry calls. This allows the XP client to access the 32-bit registry section on the 64-bit server. _______________________________________________________________________________ QC DEFECT: 1285 DATE: 6/3/2011 MODULE: XPAgnt30.dll, Xprocess.exe PROBLEM DESCRIPTION: 5 lines of MIME header are not stripped on Inbound HTTP file from Commerce:Center . FIX DESCRIPTION: Added functionality to XProcess to allow for the stipping off of MIME Headers from inbound files through the mailbox. Option "14" was added and needs to be supplied with the data start tag (i.e. "14 ISA"). XProcess will then strip everything from the file that preceeds the "ISA" tag. _______________________________________________________________________________ QC DEFECT: 1630 DATE: 6/3/11 MODULE: sapint.exe PROBLEM DESCRIPTION: SAP Extension does not put the correct version in the SAPStat table. -Extract creates a 0-byte file if SAP Version =7xx (700,701). The -Translate will add the statuses to the table and -Update will update the statuses. But when -Extract runs the Version needs to be changed to a 6xx (600,601) version to be able to create information in the Status iDoc. Otherwise the rows are removed from the table and the iDoc will not have the information added. FIX DESCRIPTION: Added logic to include idoc version 7xx so that it matches what 6xx does during the extract process. _______________________________________________________________________________ QC DEFECT: 1439 DATE: 6/6/2011 MODULE: Partnred.exe PROBLEM DESCRIPTION: Edifact UNB/UNH Control Numbers do not allow Alpha characters in Partner Editor FIX DESCRIPTION: Added functionality to allow Edifact standards to use Alpha-numeric characters in the "Last Used Control Number" Field for outbound interchanges. It will also verify that the last value of the entry is a number and not an alphabetic character. _______________________________________________________________________________ QC DEFECT: 1613 DATE: 6/8/11 MODULE: Partnred.exe PROBLEM DESCRIPTION: Cannot use Extended ASCII characters in Partner Editor for any separator in the Outbound ISA Envelope. This restriction is not notated in X12 standards. FIX DESCRIPTION: Extended ASCII characters (hex codes 80 thru FF) are now allowed. So any ASCII character with hex code 00 thru FF is now valid for Element Separator, Sub-Element Separator, Segment Terminator, and Repetition Separator. _______________________________________________________________________________ QC DEFECT: 1602 DATE: 6/8/11 MODULE: RpcSrv.exe PROBLEM DESCRIPTION: When automatic file concatenation is enabled, the system is concatenating files of different file extensions during Mailbox Import. This was causing issues because they might use different system import maps to process data. FIX DESCRIPTION: Added logic to only concatenate files with the same file extension. _______________________________________________________________________________ QC DEFECT: 1288 DATE: 6/8/2011 MODULE: SAPINT.exe PROBLEM DESCRIPTION: One SAP status file contains idoc status records for two different systems. FIX DESCRIPTION: Added code to the DoExtractProcess that writes the .dat file to verify that the date/time stamp is not already being used for another file. If it is, we'll sleep for a second and get a new date/time stamp to use. The should fix the problem of multiple extracts running in the same second writing to the same file. _______________________________________________________________________________ QC DEFECT: 1142 DATE: 6/15/11 MODULE: Unattend.exe PROBLEM DESCRIPTION: Duplicate interchanges sent by GDW_Send and GSW_Send_Receive after failed communication sessions. FIX DESCRIPTION: Added check for a corresponding mailbox message with an Unread status. If found, the interchange in question was previous sent and will not be sent again. As a result, the interchange status will be changed from "Ready to Send" to "Queued" and audit message 1-3-1605 will be written. _______________________________________________________________________________ QC DEFECT: 1636 DATE: 6/28/2011 MODULE: XPAgnt30.dll, Xprocess.exe PROBLEM DESCRIPTION: New XPAgent function to strip Mime headers did not work with mixed case strings FIX DESCRIPTION: Added code to make the string comparison fuction ignore case when comparing string values _______________________________________________________________________________ QC DEFECT: 1394 DATE: 6/28/2011 MODULE: TxAckGen.dll PROBLEM DESCRIPTION: IK5 segments for 999 Acknowlgements was not outputting an error code "5" when an error was reported on the inbound data. FIX DESCRIPTION: Hard coded the 999's to input an error code "5" in the IK5 segment for all errors reported when processing an inbound doc. _______________________________________________________________________________ QC DEFECT: 1645 DATE: 08/12/11 MODULE: EDIMGR.exe PROBLEM DESCRIPTION: Interchange window displays wrong data for specific partner when viewing data at the group level. FIX DESCRIPTION: Discovered that the pop-up menu state for the tree view of the interchange browser was not refreshing as you moved through the tree. This would result in the previous menu state for the interchange level being maintained for the group level which was allowing the user to select the view option which should be grayed out. I have updated this so that each time the pop-up menu is called, it refreshes and gets the correct menu state _______________________________________________________________________________ QC DEFECT: 1643 DATE: 08/12/2011 MODULE: Aleserver.exe PROBLEM DESCRIPTION: ALESERVER is not reconnecting on the check connection interval when the connection is lost. FIX DESCRIPTION: Added code to ensure the connection handle gets closed if the connection is lost allowing Aleserver to reconnect when set to automatically. _______________________________________________________________________________ QC DEFECT: QC 1646 DATE: 08/15/2011 MODULE: ProcCntl.exe PROBLEM DESCRIPTION: User is able to make changes to a session without suspending event in ProcCntl. FIX DESCRIPTION: Added controls to the Sessions tab of procctrl to prevent the user from making changes to sessions tied to active events. _______________________________________________________________________________ QC DEFECT: 1635 DATE: 8/19/11 MODULE: Edimgr.exe PROBLEM DESCRIPTION: On 64-bit Windows 2008 R2, edimgr.exe hangs when opening Interchange Browser. FIX DESCRIPTION: Displaying the sort arrow in the list view column headers was causing the hang. Added code to not display the sort arrow on a 64-bit OS (users can still click on the column headers to sort though). _______________________________________________________________________________ QC DEFECT: 1647 DATE: 8/19/11 MODULE: GentranAdministrator.exe PROBLEM DESCRIPTION: GentranAdministrator.exe does not report correct OS version when OS is 64-bit. FIX DESCRIPTION: Consolidated Database version into a multi-line output, as well as OS version can handle any version. Also, changed date time formats and ordered several lists to make analysis easier. 1) Removed conditional logic that ignored Windows version data that was > 5. 2) Reformatted date/time strings to: YYYY/MM/DD HH:MM:SS... this makes it easier to sort files. 3) Put ORDER BY clauses in several SQL statements to get an order that makes for easier analysis. 4) Added version of GenAdmin to report. 5) Reformatted the filename to include a datetime stamp on default, client, and case. Filename format: GenAdminSvr_yyyymmdd_hhmmss.txt GenAdminClient_yyyymmdd_hhmmss.txt GenAdmin__yyyymmdd_hhmmss.txt _______________________________________________________________________________ QC DEFECT: 1654 DATE: 9/13/11 MODULE: Edimgr.exe, Config.exe, Commpost.exe, rpcsrv.exe, Partnred.exe, Proccntl.exe, Gensec.dll, Unattend.exe, ArchiveManager.exe, ArchiveEngine.exe, GICheck.exe, GentranEx.dll, GNTSTART.exe, AckServer.exe, GNTXEng.exe, TxAckGen.dll, TxAckRec.dll, tx32.exe, TXTrace.exe, TXUtility.exe, Mercury.exe, MClient.exe, Mercui30.dll, MBoxArc.exe, MailboxArchive.dll, XAGENT30.DLL, Mbfile30.dll, MBMAPI30.dll, fpi.dll, GentranAdapter.dll, SAPAdapter.dll, SAPServer.exe, Gencom97.exe, GenComUI.dll, ComStart.exe, InsCnvrt.exe, [RosettaNet] PIPprofiler.exe, PIPViewer.exe, PIPMonitorService.exe, RN20Agent.dll, SCPartnerContactInfo.exe, SCRException.dll, SCRN4PIPServer.dll, [HTTP/Email Gateways] SCDeliveryQuery.dll, SCEMailGateway.dll, SCHttpGateway.dll, SCMailData.dll, [HTTP Message Forwarder] SCMsgForwarderConfig.dll, SCHttpMessageForwarder.dll [SAP] sapint.exe, aleserver.exe, SAPConfg.exe PROBLEM DESCRIPTION: After applying 5.2 Patch 17 on a Windows 2000 Server, Mailbox service starts then stops. Running Mercury.exe -C from command prompt reports the following error "Unable to open registry key". FIX DESCRIPTION: A new 64-bit registry flag that was added is not recognized on Windows 2000. Added code to check for Windows 2000. If detected, the 64-bit registry flag will not be used. _______________________________________________________________________________ QC DEFECT: 1660 DATE: 10/21/11 MODULE: GenCom97.exe PROBLEM DESCRIPTION: Firewall login in FTP Mailbox fails while executing on a very fast server on Win2008 R2 (x64). FIX DESCRIPTION: Added sleep command (for 0.1 seconds) to the end of send and receive functions. _______________________________________________________________________________ QC DEFECT: 1661 DATE: 11/10/11 MODULE: Unattend.exe PROBLEM DESCRIPTION: GDW_Send and GDW_Send_Receive is checking for "Ready to Send" and Queued messages without checking at creation time leading to duplicate interchanges being sent. FIX DESCRIPTION: During check for "Ready to Send" and Queued, added a restriction to only look at interchanges older than 5 minutes. Also checked that this is not in the send queue already. _______________________________________________________________________________ QC DEFECT: 1669 DATE: 11/17/11 MODULE: ArchiveEngine.exe, ArchiveAuditMsgs.xml PROBLEM DESCRIPTION: ExternalData Archive aborts due to file access exception... Errors: 7-1-102, 7-1-49, 7-1-54, 7-1-57. Need to add more logging to the exception handling. FIX DESCRIPTION: Added extra logging to exception code. Audit message 7-1-57 modified to include more exception details. _______________________________________________________________________________ QC DEFECT: 1674 DATE: 11/23/2011 MODULE: Compost.exe PROBLEM DESCRIPTION: Unable to process data with < in the ISA data when XML Splitter is in Splitter table FIX DESCRIPTION: Updated fix for defect 1160. If compost encounters a < in the data, it checks to see if it is working with XML data. Previous fix had to be modified to make checking for a valid XML end tag more complete so if compost was not looking at valid XML data it would exit out of XML processing. _______________________________________________________________________________ QC DEFECT: 1631 DATE: 12/1/11 MODULE: RpcSrv.exe PROBLEM DESCRIPTION: In 5.2, if automatic file concatenation is turned on, some interchanges are lost and others are duplicated when processing multiple files from multiple partners at the same time. FIX DESCRIPTION: Fixed file concatenation logic that was supposed to remove matching files from the queue. _______________________________________________________________________________ QC DEFECT: 1657 DATE: 12/5/2011 MODULE: STXBRK.MAP (& .TPL) PROBLEM DESCRIPTION: When a tradacoms document contained multiple interchanges, and one of the interchanges was missing a valid "END" segment, the translator would enter an infinite loop and hang. FIX DESCRIPTION: Modified the STXBRK.MAP to be able to catch interchanges that contain more than 1 STX segment and flag the interchange as non-compliant with compliance errors written to the audit log. The updated rule received from mapping does not allow both combined interchanges to in up in the ?InBox, only the first interchange it was processing when it encountered the 2nd STX segment. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! NOTE: TO USE THIS FIX, YOU MUST MANUALLY REGISTER THE TPL FILE LOCATED IN THE "Support" FOLDER OF THE PATCH INSTALL IMAGE. THE PATCH SETUP WILL NOT INSTALL IT. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ************************************************************************** PATCH 2 ************************************************************************** RTC DEFECT: 70525 QC DEFECT: 1671 DATE: 01/06/2012 MODULE: ArchiveManager.exe PROBLEM DESCRIPTION: Archive Manager fails to display tracking information for documents containing multiple TX reports FIX DESCRIPTION: Archive Manager was incorrectly building the display to allow for the displaying of multple TX entries for a given document entry. This has been modified and now builds correctly displaying all TX report entries. _______________________________________________________________________________ RTC DEFECT: 70529 QC DEFECT: 1670 DATE: 1/11/12 MODULE: ArchiveManager.exe PROBLEM DESCRIPTION: ExtDataXref_tb Data does not restore with Restored interchanges. The information is in the Archive Viewer under the EDI Archive. However when restored a couple of oddly formatted rows are added to the database table. FIX DESCRIPTION: The code responsible for restoring the ExtDataXreb_tb entries was not correctly setting all the table entry variables correctly for entries that do not contain TXReport info. This has been fixed and all rows now restore correctly. _______________________________________________________________________________ RTC DEFECT: 70526 QC DEFECT: 1677 DATE: 1/18/12 MODULE: Partnred.exe PROBLEM DESCRIPTION: When creating a new inbound relationship in Partner Editor, if the last relationship selected has 'Export to Mailbox' settings, they will also appear in the new relationship. These setting cannot be removed if the new relationship is not using an export template. FIX DESCRIPTION: The 'Export to Mailbox' settings were not getting re-initialized when the 'New' button was pressed. This has now been fixed. _______________________________________________________________________________ ******************************************************************************* PATCH 3 ******************************************************************************* RTC DEFECT: 318239 APAR: IC81995 DATE: 3/12/12 MODULE: Compost.exe PROBLEM DESCRIPTION: Data fails with Invalid Data when the following characters appear in the data ÊÀ¼ FIX DESCRIPTION: The logical OR statement added to Compost in patch 19 for XML Validation could return a false positive causing non-XML data to get processed as XML. This statement has been broken into two preventing the false postive. _______________________________________________________________________________ RTC DEFECT: 324908 APAR: IC82799 DATE: 4/20/12 MODULE: GenComPC.dll PROBLEM DESCRIPTION: On a 5.3 clustered system (Win2008 R2), when starting the mailbox service, the Communications gateway (GenComPC.dll) fails to load with audit log error 6-2-50010: "RpcBindingFromStringBinding failed at line 507: The network address is invalid." FIX DESCRIPTION: On Win2008 R2, the cluster name is not valid as the host name parameter of the RpcBindingFromStringBinding Windows API call. Modified code to use a blank host name instead on a clustered system. The API call will assume the local host in that scenario. _______________________________________________________________________________ RTC DEFECT: 317856 APAR: IC81928 DATE: 5/11/12 MODULE: tx32.exe (gntxbase.lib), edimgr.exe, unattend.exe PROBLEM DESCRIPTION: TA1 and 997 acknowledgements cannot be sent together in one outbound interchange. They are sent in separate interchanges. While the standards allow this and some users prefer it that way, others have a requirement where they have to be combined together. FIX DESCRIPTION: Removed code from Edimgr.exe and Unattend.exe that forced TA1 and 997s to be sent separately. Added coded to the translator to allow switching between document build maps that had different group types. To send them together, the TA1 and 997 partner relationships must be configured to use the same interchange definition entry. After they're sent, they will appear together in the document list in the Interchange Browser. _______________________________________________________________________________ RTC DEFECT: 320362 APAR: IC83775 DATE: 5/25/12 MODULE: ArchiveManager.exe PROBLEM DESCRIPTION: When displaying Tracking Information in Archive Manager, document level of Outbound Tracking information does not always display, and instead displays "No Tracking Info". FIX DESCRIPTION: Enhanced the Archive Manager to build and display Tracking Information records from ExtDataXref records when the ExtData record is not found in the .arv file. The only relevant fields the ExtDataXref record contains include ExtDataKey and TimeStamp. The other fields in the Tracking Information record will contain the text "No Tracking Info". _______________________________________________________________________________ RTC DEFECT: 315615 APAR: IC83908 DATE: 6/5/2012 MODULE: MBFile30.dll PROBLEM DESCRIPTION: Warning message reports wrong mailbox during start up of services. 2-4-1019: 1019: Unable to begin collection for mailbox FIX DESCRIPTION: Added new informational audit message to DB for file collection mailboxes. This new message will notify users that the system file collection mechanism will not be used for collection mailboxes starting at mailbox #63. Instead, the collection interval set within the file system properties will be used. _______________________________________________________________________________ RTC DEFECT: 331595 APAR: DATE: 6/7/12 MODULE: SCEmailGateway.dll PROBLEM DESCRIPTION: When an Email Gateway mailbox is configured to receive inbound messages from a POP3 server, the audit log is getting flooded with 16-3-9 info audits ("POP3 collection thread e-mail collection ended for mailbox POP3 Inbound. 0 e-mail messages collected and delivered") that are written to the audit log every 30 seconds. This still happens even if the mailbox settings logging level is set to "Errors only" or "Errors and Warnings only". FIX DESCRIPTION: Corrected the audit call that classified it as an error audit instead of an informational audit. _______________________________________________________________________________ RTC DEFECT: 325856 APAR: IC83907 DATE: 6/29/12 MODULE: Patch install (setup.exe) PROBLEM DESCRIPTION: When patching cluster with 5.2 patch 17 or later, patch install gets popup error message: "Data source name not found and no default driver specified" FIX DESCRIPTION: Updated patch install to handle DNS lookup on a cluster. Also adjusted fix for Vantive SR#1366717 that checks the registry for ClusterName. _______________________________________________________________________________ ******************************************************************************* PATCH 4 ******************************************************************************* RTC DEFECT: 340892 APAR: DATE: 7/30/12 MODULE: Config.exe PROBLEM DESCRIPTION: System Imports list allows for use of *.* for the File Path Configuration. If this is not the last entry found in the list, it will over-ride all those that follow resulting in translation failures FIX DESCRIPTION: Added a new "Yes / No" pop-up dialog and warning about the use of *.* in the System Imports list. This dialog will only appear to the user if a *.* entry is found anywhere other than the last entry. Selecting YES allows the user to save and leave the system imports tab. Selecting NO cancels the save and prevents them from leaving the imports tab. _______________________________________________________________________________ RTC DEFECT: 70010 APAR: IC87459 DATE: 9/17/2012 MODULE: GICheck.exe PROBLEM DESCRIPTION: Customers that implement database login security cannot use the command line/batch functionality of the GICheck utility. FIX DESCRIPTION: When GICheck.exe is invoked from the command line the ODBC DSN name, user id, and password are now loaded from the registry. _______________________________________________________________________________ RTC DEFECT: 351228 APAR: IC87515 DATE: 10/26/2012 MODULE: Commpost.exe PROBLEM DESCRIPTION: When Commpost attempts to process bad data it attempts to retry processing that data 5 times. This can cause Commpost to continue attempting to process the bad data for an inordinate amount of time and consume large amounts of memory. FIX DESCRIPTION: Have the default remain at 5 however have an override set in the registry so the customer can set it to a number they would like to have. This registry setting is named CommPostMaxRetryCount and is a DWORD entry and defaults to 5. It is stored under the following registry key: 32-bit OS: HKEY_LOCAL_MACHINE\SOFTWARE\Sterling Commerce\GENTRAN\Server\\Systems\ 64-bit OS: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sterling Commerce\GENTRAN\Server\\Systems\ When Commpost runs it attempts to read this value in and use it as the Max retry count, if it does not find it, it creates the value and sets it to 5. _______________________________________________________________________________ RTC DEFECT: RTC 343543 APAR: IC87657 DATE: 10/30/12 MODULE: gntstart.exe PROBLEM DESCRIPTION: Some commands are unable to execute in 64-bit OS through GNTStart and Unattend from command line FIX DESCRIPTION: Added code to fix the physical GSW login portion for when the silent signon fails. This was not previously working so even when the user was prompted to login on Win7 or Server 2008, the DSN information was not being set correctly and genstart could not access it. Also added code to allow for gntstart to exit correctly if it can not access the DB. This was causing gntstart to crash. _______________________________________________________________________________ RTC DEFECT: 354271 APAR: IC87651 DATE: 10/30/12 MODULE: Partnred.exe PROBLEM DESCRIPTION: In the Partner Editor's Outbound Interchange dialog, when you uncheck the "Use the default Mailbox and E-mail Address" checkbox, the "Set Max Number of Documents per Interchange" checkbox unchecks also. FIX DESCRIPTION: An UpdateData command to retrieve the current values of the dialog controls was missing in the if-else clause. Moved it to the start of the function. _______________________________________________________________________________ RTC DEFECT: 353247 APAR: IC87818 DATE: 10/31/12 MODULE: tx32.exe (GNTXBASE.lib) PROBLEM DESCRIPTION: Outbound document has duplicate Document Name checking turned on but no warning message is received in the audit log. FIX DESCRIPTION: Updated duplicate document checking on outbound documents to write to the same error message to the Audit Log that we'd get when recieving duplicate inbound docs. _______________________________________________________________________________ RTC DEFECT: 352952 APAR: IC87997 DATE: 11/7/2012 MODULE: Commpost.exe PROBLEM DESCRIPTION: In CommPost, When data comes in with unprintable terminators it causes compost to hang. FIX DESCRIPTION: In CommPost, when a UNB segment is detected and the segment terminator defined in the Splitter table is not found in the data, we now flag the interchange as bad, write an Audit message and continue processing the file. _______________________________________________________________________________ RTC DEFECT: 328135 APAR: DATE: 11/7/12 MODULE: Patch Install PROBLEM DESCRIPTION: Don't need "If you use positional maps that utilize the Loop Start/Loop End functionality..." popup warning in the 5.3 patch install anymore since the hotfix is now in the 5.3 base product. FIX DESCRIPTION: Removed Positional Loop popup warning from 5.3 patch install. _______________________________________________________________________________ RTC DEFECT: 348251 APAR: IC88106 DATE: 11/9/2012 MODULE: GNTXBase.lib PROBLEM DESCRIPTION: Pad character outputs as space instead of "0" for empty numeric fields in Export maps FIX DESCRIPTION: Added check condition in export translation to look for new "PadFillEmptyNum" DWORD value in registry. If it does not exist, we create it and set it to "0". If it exists and is "0", we pad empty numeric map segments using the default setting which is spaces. Otherwise, if it's set to "1", we pad with the pad character the customer has specified. This registry key cannot be changed through the UI and must be manually changed in the registry. This key is located in: 32 bit OS: HKLM \ SOFTWARE \ Sterling Commerce \ Gentran \ Server \ 64 bit OS: HKLM \ SOFTWARE \ Wow6432Node \ Sterling Commerce \ Gentran \ Server \ _______________________________________________________________________________ RTC DEFECT: APAR: DATE: MODULE: PROBLEM DESCRIPTION: FIX DESCRIPTION: _______________________________________________________________________________ ===================>> End Patch Release Notes GSW 5.3 <<===================== PATCH RELEASE NOTES Common Component Translator ************************************************************************** PATCH 1 ************************************************************************** QC DEFECT: 1527 DATE: 6/13/2011 MODULE: TXEngine PROBLEM DESCRIPTION: ODBC POS to DB maps to MySQL databases fail to write to MySQL because of the pressence of double quotes around the table name and column names. FIX DESCRIPTION: Added a process to TXEngine to check what kind of DB the ODBC map is writing to, and if it is a MySQL Database, remove any double quotes from the SQL Statements writing data to the database _____________________________________________________________ VANTIVE SR: 1365267 DATE: 6/6/2007 MODULE: tx32.exe (txengine.lib) PROBLEM DESCRIPTION: References to previous and future elements/fields using indexes in extended rules at the field/element level are not returning correct results. The current value of the element is returned regardless of the indexing used. The output is correct for rules in the 'On End' of a group, or for groups that are only one nesting deep, IE, accessed using a single index such as [1]. FIX DESCRIPTION: Check the results of the iteration comparison. If the comparison failed because the end of the index was reached, pull the data value from the translator registry store (temporary storage). If the comparison fails because the index values do not match, the value is pulled from translator main storage (permanent storage). ************************************************************************** PATCH 2 ************************************************************************** QC DEFECT: 1668 DATE: 12/14/2011 MODULE: TXEngine.lib PROBLEM DESCRIPTION: Date validation in the translator was not throwing an error when encountering an invalid date. If the first value in the date field was a digit, but the second was a character, the translator would flag the date as being valid. FIX DESCRIPTION: Fixed the date validation so that when a character value is found anywhere within a date field, the translator will flag as an invalid date and the file will be sent to the ?inbox as non-compliant. _____________________________________________________________ RTC DEFECT: 148167 DATE: 1/25/12 MODULE: TXEngine.lib PROBLEM DESCRIPTION: Repeating elements in EDI Maps were causing inbound data to process as non-compliant and report "Too Many Elements" in the TX report if the repeating element was the last field in the data segment even though the data was valid and the number of data elements were equal to or less than the repeat count. The TX report was also reporting this error against the wrong segment in the data. FIX DESCRIPTION: Modified the data extraction routine for repeating elements in the translator to only error with "Too Many Elements" if the number of data elements extracted from the segment exceeds the total number of expected fields in the Map. An element number will no longer be associated with this error in the TX report and we will now only report this against the segment. The "Data" field of the TX report will now contain the rest of the data segment starting with the first data element that exceeded the expected number of elements. _____________________________________________________________ RTC DEFECT: 311667 DATE: 2/1/12 MODULE: TXEngine.lib PROBLEM DESCRIPTION: Logic was missing from repeating composites that prevented the translator from accounting for all remaining composite itterations if the repeating composite was the last element in the segment. Because of this, the Translator would not error correctly if the elements preceding the repeating composit had more data than what the map was expecting. FIX DESCRIPTION: Added that same logic from repeating elements to repeating composites to account for all remaining composite itterations if the composite was the last element in the segment. This will ensure that we have an accurate count of all the fields extacted and error correctly if we have too many. ************************************************************************** PATCH 3 ************************************************************************** RTC DEFECT: 315611 APAR: IC82168 DATE: 3/21/12 MODULE: Mapper.exe PROBLEM DESCRIPTION: When creating a link in the map editor, if whitespace is clicked on the output side rather than a field, it crashes/closes the map editor. FIX DESCRIPTION: Ported SI fix for QC 255708 to GSW to resolve this issue _____________________________________________________________ QC DEFECT: 1668 DATE: 6/21/12 MODULE: TXEngine.lib PROBLEM DESCRIPTION: Fix for QC 1668 causes translator errors with formatted single digit dates containing /, -, or : separators as reported in RTC 336545 FIX DESCRIPTION: Backed out previous fix for 1668 as a result of RTC 336545 ************************************************************************** PATCH 4 ************************************************************************** There were no new Core Translator fixes in this patch. _____________________________________________________________ RTC DEFECT: APAR: DATE: MODULE: PROBLEM DESCRIPTION: FIX DESCRIPTION: _____________________________________________________________