List of changes for portingset: 8.9a.01 Couperin: # 58740 (BDUX51134): defect 367457: Request to log 3GL return code for dal2 field hooks Date: Fri, 23 Aug 2013 16:28:22 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) Return values are not traces when using -dbgflow -tracelevel 1 in case of DAL hooks. The same happes also for Dbcm hooks, xmlexecutedllmethod and dll calls. Affected Executables bshell6.2 Motive source Infor365:367457 Couperin: # 58678 (BDNT51069): Minidump is not created when ABORT_PROGRAM is called in case of a critical error Date: Mon, 19 Aug 2013 15:40:11 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) When using CRASH_ON_FPE=1 on Windows no minidump is produced Affected Executables all Motive source Infor365:415081 Couperin: # 58543 (BDNT50898): Login as current user from BW4 does not work anymore Date: Tue, 30 Jul 2013 17:24:16 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) Login with BW4 to 8.9a portingset failed when logging in with 'login as current user'. Workaround Use BaanLogin or Rexec protocol in the BW4 client. Test Procedure Logon with BW4 using named pipes/logon as current user. This should succeed without error if the user is permitted to logon to the system and allowed to use the BSE. Motive source Infor365:413126 Couperin: # 58479 (BDNT50872): Cannot make changes in subapplication modeler Date: Wed, 24 Jul 2013 16:13:51 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) It is no longer possible to make any changes in the subapplication modeler in a specific DEM business process. This occurs when there are many sub-applications in the model. Motive source Infor365:409828 Couperin: # 58405 (BDNT50692): Fix finding new installed objects when also in SHM Date: Tue, 16 Jul 2013 16:12:44 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) On windows new installed objects were not loaded from disk when objects with same name was also in SHM. Workaround Restart SHM Test Procedure Run chk tests_bshell/shm Affected Executables shmserv ntbshell Motive source ScrumStory:LNTECH-218 Couperin: # 58382 (BDNT50763): Error deleting file version.info Date: Fri, 12 Jul 2013 16:26:53 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) Error deleting file version.info Test Procedure Install or update SLM by means of the Installation Wizard Motive source TCS:800-191585 Couperin: # 58304 (BDUX50651): SQL: Unicode: text_content() function stuffs data with 9bbc81 sequence Date: Thu, 4 Jul 2013 17:13:22 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) In Unicode mode, the text_content() function returns incorrect data if the text contains high ASCII or multi-byte characters. If all code points are in the range 0x01-0x7e (1-126), "low ASCII", then the text_content() function works as expected. Also, if the tttxt010.text column is a binary column, there is no problem. Workaround The tttxt010.text column should be created as a binary column. Create a sequential file (using bdbpre) of the following tables: ttadv304 ttadv335 ttadv364 tttxt010 Set the following resource: use_binary_columns:1 Note that the following columns are then treated as binary: ttadv304.layo ttadv335.layo ttadv364.layo tttxt010.text Import the sequential file containing the tables listed above. Observe that the table columns are created using a binary (or raw) type. Test Procedure Insert international characters in a text, and observe that the text can be retrieved using the text_content() function. Affected Executables bshell all database drivers Motive source D382321 Couperin: # 58274 (BDUX50648): SQL: VARCHAR: Comparison of column with LOWER applied to space padded value fails Date: Tue, 2 Jul 2013 13:14:41 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) The following SQL condition evaluates to FALSE when used on Oracle in VARCHAR mode: LOWER( column ) = "value " In comparisons all trailing spaces should be ignored. Because the column is stored as VARCHAR, Oracle does not ignore trailing spaces, meaning that the space padded values should be stripped from trailing spaces. Workaround Strip the value. Test Procedure Write a SQL statement with a condition such as the following: LOWER( column ) = "value " Run it on Oracle using VARCHAR and observe that the correct result is returned. Affected Executables ora8_srv Couperin: # 58178 (BDUX50472): D408015: QP: IVc/Corelli compatibility: Using substring operator in query makes other comparisons fail Date: Mon, 24 Jun 2013 17:11:38 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) Using the 8.8a porting set in Corelli convergence mode and VARCHAR mode, some queries fail that contain a substring operator and a simple comparison on the same column. An example of such a query is the following: select pcsql116.*,tipcc008.* from pcsql116,tipcc008 where pcsql116.date between :dat.f and :dat.t and tipcc008.dept between :dept.f and :dept.t and tipcc008.dept < "600 " and pcsql116.cwoc(1;2) <> "AT" and tipcc008._index1 = {pcsql116.cwoc} and tipcc008.cwoc = pcsql116.cwoc order by tipcc008.dept,pcsql116.cwoc Note the substring operator on column pcsql116.cwoc, and the simple comparison on the same column. The problem occurs on Oracle only, because when the VARCHAR data type is used in Oracle then trailing spaces are not ignored. Test Procedure Write a query such as the following: select pcsql116.*,tipcc008.* from pcsql116,tipcc008 where pcsql116.date between :dat.f and :dat.t and tipcc008.dept between :dept.f and :dept.t and tipcc008.dept < "600 " and pcsql116.cwoc(1;2) <> "AT" and tipcc008._index1 = {pcsql116.cwoc} and tipcc008.cwoc = pcsql116.cwoc order by tipcc008.dept,pcsql116.cwoc Using Oracel, VARCHAR and the porting set in Corelli compatibility mode observe that the correct result is returned. Please test with a non-empty result set. Affected Executables All database drivers Couperin: # 58143 (BDUX50414): Fix finding __ domain in SHM Date: Fri, 21 Jun 2013 11:02:20 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) Table definitions are not read from SHM but always from disk Workaround Not available Test Procedure run test tests_bshell/shm/dd_should_be_read_from_shm.test Affected Executables srdd_init shmverv bshell bic Motive source ScrumStory:LNCPE-813 Couperin: # 58063 (BDUX50409): SQL: MLE: Redundant join on shadow table using current data language in EXISTS subquery Date: Fri, 14 Jun 2013 14:21:58 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) If the current data language is not the base language, and a query contains an EXISTS predicate containing an MLE column in the SELECT clause (or *), then a redundant join with the translations table (shadow table) is included in the SQL statement sent to the database. This may impact performance negatively. Test Procedure Write a SQL select containing an EXISTS predicate with SELECT * on a table that has an MLE column. Execute the statement while the current data language is not the base language, while DBSLOG=400 is set. Observe that the EXISTS subquery sent to the database does not contain a join with the shadow table (whose name starts with an 's'). The SQL statement should look like: SELECT FROM WHERE EXISTS ( SELECT 0 FROM
) Affected Executables bshell Couperin: # 58007 (BDNT50376): UAC, exit if Staging Wizard started and button position corrected Date: Wed, 12 Jun 2013 11:27:25 +0200 (CEST) Created on: Charpentier Type: bugfix Problem Description (Customer terms) Version 1.26, UAC added, exit if Staging Wizard started and button position corrected Couperin: # 57993 (BDUX50318): Defect 403873: crash in repgen Date: Tue, 11 Jun 2013 16:02:16 +0200 (CEST) Created on: Charpentier Type: bugfix Problem Description (Customer terms) repgen crashes when compiling a report Affected Executables repgen6.2 Motive source Infor365:403873 Couperin: # 57984 (BDNT50367): Fix uninitialized warning Date: Tue, 11 Jun 2013 12:46:18 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) N.A. Test Procedure Build gcommand on Windows Release, x64 Affected Executables Many Couperin: # 57968 (BDUX50347): SQL processor: Optimize use of array indexing Date: Mon, 10 Jun 2013 13:38:03 +0200 (CEST) Created on: Couperin Type: enhancement Problem Description (Customer terms) Filtering on an element of an array column is slow. The database driver fetches all rows of the table and performs the filtering itself. Test Procedure Execute a SQL select statement as the following, while DBSLOG=400 is set: SELECT ... FROM ... WHERE col(2) = 123 Observe in the dbs.log file that the filter is pushed to the database. Affected Executables All database drivers Couperin: # 57879 (BDNT50255): Win32: Correct fix for finding tl objects in SHM Date: Mon, 3 Jun 2013 08:44:48 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) TL package is on Windows not regonized as tools package, so always loaded from disk iso SHM Test Procedure Run test tests_bshell/shm/all_tools_packages_should_be_found.test Affected Executables ntbshell Motive source ScrumStory:LNCPE-713 Couperin: # 57868 (BDNT50219): bshell crash when audit enabled Date: Fri, 31 May 2013 15:12:57 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) The audit of the table tfgld004 makes impossible to open the session tdsls4100m900 and tdpur4100m900. Workaround This issue can be solved with adding a default in the audit_host file: 090:NLBAVWTLS16 *:NLBAVWTLS16 Test Procedure start the sessions like mentiond in the table, tdsls4100m999 when audit is enabled for tfgld004 Affected Executables bshell Motive source Infor365:404786 Couperin: # 57864 (BDUX50240): Bshell: Underflow exception on execution of large SQL statement Date: Fri, 31 May 2013 12:08:16 +0200 (CEST) Created on: Couperin Type: bugfix Problem Description (Customer terms) When a large SQL statement is executed, involving a long list of expressions (that altogether are handled by the database driver and not passed to the RDBMS) the database driver generates an underflow. The bshell catches this underflow and aborts the process. Test Procedure Run session tfgld1101m000. Affected Executables all database drivers