List of changes for portingset: 9.1c ------------------------------------------------------------------------ Geminiani: # 73372 (BDNT68407): new lndbc.jar files Date: Mon, 13 Mar 2017 15:36:47 +0100 Created on: Franck Type: enhancement _Problem Description (Customer terms)_ New lndbc.jar files ------------------------------------------------------------------------ Geminiani: # 73294 (BDUX68268): Bshell: BDB_DEBUG=02: Show column names in update actions Date: Tue, 07 Mar 2017 14:59:53 +0100 Created on: Geminiani Type: enhancement _Problem Description (Customer terms)_ When tracing with BDB_DEBUG=2 the update actions are hard to correlate with the table because the column names are not shown. Example: Update actions on ttaad260000 [lng]1 [lng]6 [lng]3145728 [str(22)]infor [str(80)]host.infor.com This makes problem analysis more difficult. _Test Procedure_ Set BDB_DEBUG=02 and observe that update actions are traced with column names. _Affected Executables_ bshell ------------------------------------------------------------------------ Geminiani: # 73218 (BDUX68223): Crash with sending trace to msg window Date: Wed, 01 Mar 2017 16:58:06 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ When selecting in ttstpbshedebug "show trace in Message Window" the bshell crashes _Test Procedure_ select "show trace in Message Window" and enable any other tracing option like "Program Flow" _Affected Executables_ bshell6.2 ------------------------------------------------------------------------ Geminiani: # 72922 (BDNT67824): Reconfiguring string column that is part of an index Date: Wed, 01 Feb 2017 18:22:36 +0100 Created on: Franck Type: porting specific change _Problem Description (Customer terms)_ A reconfguration on SQL server failed if: - a column was small (i.e. below the varchar threshold) - was created with threshold enabled (i.e. non zero) - a new portingset was used with a lower or zero threshold The reason is that the portingset expects that a column was VARCHAR, but it was not. SQL Server does not allow reconfiguration of table fields if the data type was not VARCHAR. An error is raised: _Workaround_ Manually pre/post involved tables (see below) which causes CHAR to be changed to VARCHAR. Involved tables in customer incident: ttaud330 ttdba030 ttdba035 _Affected Executables_ SQL server driver (msql7_srv.dll and msq7_srv.exe) _Motive source_ Defect 582266 ------------------------------------------------------------------------ Geminiani: # 72849 (BDNT67812): MT: tenant_admins resource must be read from tenant BSE Date: Thu, 26 Jan 2017 11:50:22 +0100 Created on: Geminiani Type: enhancement _Problem Description (Customer terms)_ tenant_admin must be loaded from the tenant_resource _Affected Executables_ rexecd.exe _Motive source_ JIRA:LND2-15779 ------------------------------------------------------------------------ Geminiani: # 72772 (BDNT67655): When a Fixed Byte Array is full, e is not set. Date: Thu, 19 Jan 2017 13:32:37 +0100 Created on: Geminiani Type: bugfix _Problem Description (Customer terms)_ No useful information is given to end-users/admins if bytes written exceeds fixed byte array. _Workaround_ N/A _Test Procedure_ ims_check_fba_size_overflow.test _Affected Executables_ bshell _Motive source_ TCS:800-211134 ------------------------------------------------------------------------ Geminiani: # 72613 (BDNT67550): update copyright year Date: Wed, 04 Jan 2017 13:55:01 +0100 Created on: Geminiani Type: enhancement _Problem Description (Customer terms)_ update copyright year to 2017 ------------------------------------------------------------------------ Geminiani: # 72393 (BDUX67319): oracle: password verification Date: Tue, 13 Dec 2016 14:17:45 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ When password verification has been enabled in Oracle, the ora8_maint -r/-R commands fail with ORA-028221 "REPLACE not specified" when the authentication is done using the old password (-o option). _Workaround_ Invoke ora8_maint -r using DBA authentication (-c dba-user -i dba-pwd) instead of the current password ( -o oldpwd ). _Affected Executables_ ora8_maint _Motive source_ InforXtreme:573788 ------------------------------------------------------------------------ Geminiani: # 72132 (BDUX66936): Show bshell timeout as Warning instead of Error in eventviewer Date: Mon, 21 Nov 2016 12:43:59 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ Show bshell timeout as Warning instead of Error in eventviewer _Affected Executables_ bshell6.2 _Motive source_ TCS:800-211680 ------------------------------------------------------------------------ Geminiani: # 72046 (BDUX66901): New timezone files 2016i Date: Thu, 10 Nov 2016 16:25:48 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ On September 7th 2016, there were some changes made regarding Turkeys timezone: Turkey will permanently stay on UTC+3 _Workaround_ Download and compile manually _Affected Executables_ $BSE/lib/timezone files _Motive source_ InforXtreme:571478 ------------------------------------------------------------------------ Geminiani: # 72007 (BDNT66532): Fast conversion to unicode: create mapping, no disguised raw conversion in multibyte environments Date: Wed, 09 Nov 2016 07:34:29 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ Creation of a mappingfile for fast conversion to unicode fails in a multibyte environment (eg SHIFTJIS), resulting in an inability to convert disguised raw columns. Therefore these columns should no longer be present when generating the mappingfile and consequently neither when performing the fast conversion to unicode. _Test Procedure_ Existing regression tests have been adapted. _Affected Executables_ bdbreconfig, msql server and oracle server. ------------------------------------------------------------------------ Geminiani: # 72004 (BDUX66765): CDF Arrays Date: Tue, 08 Nov 2016 17:04:09 +0100 Created on: Geminiani Type: enhancement _Problem Description (Customer terms)_ Support arrays for CDF _Test Procedure_ regtests _Affected Executables_ bshell6.2 bdbpost6.2 bdbpre6.2 _Motive source_ JIRA:LND2-14265 ------------------------------------------------------------------------ Geminiani: # 71978 (BDUX66805): enhance 32 bit overvflow message with db.columns.to.record Date: Fri, 04 Nov 2016 14:05:27 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ fatal long signed 32-bit serialization overflow: Message. Hard to find out which table field is causing this message _Test Procedure_ reg tests _Affected Executables_ bshell6.2 _Motive source_ TCS:800-212018 ------------------------------------------------------------------------ Geminiani: # 71947 (BDNT66776): Barcode generation with bc\$() may fail Date: Thu, 03 Nov 2016 11:05:32 +0100 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ A barcode was not correctly generated with the 3GL bc$() function in some cases. _Workaround_ NA _Affected Executables_ bshell _Motive source_ InforXtreme:570167 ------------------------------------------------------------------------ Geminiani: # 71853 (BDNT66687): fast conversion to unicode: possibly too long string columns, right trim them Date: Wed, 26 Oct 2016 18:01:26 +0200 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ When using the fast conversion to unicode, with too many characters (spaces) in a multibyte column, a truncation error was reported by MSSQL. _Workaround_ n/a _Test Procedure_ All our current regression tests still succeed. _Affected Executables_ database servers for Oracle and MSQL. ------------------------------------------------------------------------ Geminiani: # 71848 (BDNT66616): Fast conversion to unicode: unqualified table name when select on source table Date: Wed, 26 Oct 2016 16:40:41 +0200 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ When using fast conversion to unicode, where source and target are in different database instances, the source table was not selected correctly. _Workaround_ n/a _Test Procedure_ Our regression tests still succeed. An external test was done with two different database instances. _Affected Executables_ msql database driver ------------------------------------------------------------------------ Geminiani: # 71815 (BDUX66627): DF569158:Address record could be deleted despite of existing reference Date: Tue, 25 Oct 2016 17:41:21 +0200 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ A parent record can be deleted though being referenced if 1.) the parent table is in Audit mode 2.) the user has no authorization for the reference table _Workaround_ Disable audit _Test Procedure_ setup normal user without permissions for the child table. Setup a parent record that is used in the child table. Setup the audit action for the table ( or change the tabledef so for both tables a different driver is used ) then try to delete the parent record where you do have permissions on, it should still see the reference in the child even if you do ot have permissions for that table. _Affected Executables_ bshell _Motive source_ InforXtreme:569158 ------------------------------------------------------------------------ Geminiani: # 71750 (BDUX65956): D549786: error 201 when deleting a parent record that has child with MLE field and delete child as reference Date: Thu, 20 Oct 2016 14:04:45 +0200 Created on: Faure Type: bugfix _Problem Description (Customer terms)_ When trying to delete a record in table tipcf100, the following error occurs: * error 201 "record modified by other user" The error only happens when there are child records in tipcf110 and tipcf101. And only when MLE has been enabled for table tipcf110. As the issue can also happen with different tables, the general prerequisiteies for the issue are: - The parent record has child records and the child itself has a child record. - The reference is mandatory and of delete-type "Child will be deleted" - The midle tabble needs to have MLE enabled for one field. _Workaround_ Disable MLE _Test Procedure_ * Start session "Product Features by Configurable Item" (tipcf1101m000) * Select record item = 00000000ZVT, Sequence = 40 (feature bz9996) (, or any other record that hasn "select option" checked) * Press "delete" or * Start ttaad4100 general table maintenance * open table tipcd100 in company 101 (with disbaled DAL) * goto record 00000000ZVT - 40 * Press D to delete it _Affected Executables_ Database Drivers _Motive source_ InforXtreme:549786 ------------------------------------------------------------------------ Geminiani: # 71623 (BDNT66370): Conversion error at BW login diaglog in event viewer Date: Wed, 12 Oct 2016 15:06:42 +0200 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ When login diaglog comes up then an error is logged in the Windows Event viewer: GetString(char *, size_t): error in conversion of string, characters are not available in the current locale This occurs on some Japanese installations of Windows. _Motive source_ InforXtreme:558778 ------------------------------------------------------------------------ Geminiani: # 71616 (BDNT66370): Conversion error at BW login diaglog in event viewer Date: Wed, 12 Oct 2016 12:01:44 +0200 Created on: Franck Type: bugfix _Problem Description (Customer terms)_ When login diaglog comes up then an error is logged in the Windows Event viewer: GetString(char *, size_t): error in conversion of string, characters are not available in the current locale This occurs on some Japanese installations of Windows. _Motive source_ InforXtreme:558778 ------------------------------------------------------------------------