List of changes for portingset: 7.1d.12 MaintCorelli: # 29427 (BDUX21147): SLM adoption and SHM based Secu Files Date: Thu, 9 Feb 2006 09:17:38 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Port of SLM adoption in order to facilitate a smoother upgrade to the 8.2b porting sets in a later stage. This will be a porting set that supports both SLM and the old licensing mechanism. The Product ID's will be based on the Security Files for the product ID's The Security Files will be Shared Memory based. Test Procedure See test document for this project. Affected Executables bshell6.2 srdd_init6.2 bic6.2 and friends licd.6 2 and friends MaintCorelli: # 29382 (BDUX21394): Never allocate level-1 row cache for level-2 drivers Date: Fri, 3 Feb 2006 16:38:40 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Level-2 drivers might allocate too much memory. Workaround For level-2 drivers explicitely set the field refresh_time to 0. Test Procedure regression tests Affected Executables all database drivers MaintCorelli: # 29340 (BDUX21383): return value position qss search incorrect Date: Wed, 1 Feb 2006 13:03:54 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) When an item is searched in an array using qss functionality the returned position is not correct when the item to be searched is not present in the array and the searchflags QSS.LESS or QSS.EQLE is used and duplicates are present in the array. Workaround Create an indexed array. Test Procedure Create the following 4GL script, compile and run it: |****************************************************************************** |* gatst9004 0 VRC B60 a |* |* sdvries |* 05-12-16 [12:40] |****************************************************************************** |* Script Type: 0 |****************************************************************************** #ident "@(#)gatst9004 gaB60a sprinter Rev.No. 2 16 Dec 05 sdvries" function extern main() { long search.def(1,4) #define MAX_NO 12 long a(MAX_NO) |* Fill search def qss.start( search.def, 1,1 ) qss.way( search.def, 1, QSS.UP ) |* Search upwards? qss.type( search.def, 1, DB.LONG ) |* Fill the array with values a(1) = 732292 a(2) = 733292 a(3) = 733292 a(4) = 733292 a(5) = 733293 a(6) = 733293 a(7) = 733293 a(8) = 733293 a(9) = 733295 a(10) = 733295 a(11) = 733295 a(12) = 733295 long i |* Found index long v |* To be found value. boolean found v = 733294 |* This value is not in the array.... i = qss.search( QSS.LESS+QSS.SRC.IS.SORTED+QSS.SRC.DUPL.ALLOWED, v, |* value to find a, |* Array search.def, MAX_NO) |* expect 733293 at position 8, 733293 is the first value |* that is less then 733294 and position 8 is the first |* position to be found if searched upwards. if i = 8 then |* last value in the array. found = true else |* No, no, this is not correct, the last value |* should be found. found = false endif |* Try it for an other value this is in the array. v = 733293 i = qss.search( QSS.LESS+QSS.SRC.IS.SORTED+QSS.SRC.DUPL.ALLOWED, v, |* value to find a, |* Array search.def, MAX_NO) |* expect 733292 at position 4, smaller then 733292. |* And the first value found if searched upwards (ascending). if i = 4 then |* last value in the array. found = true else |* No, no, this is not correct, the value 4 |* should be found. found = false endif } Affected Executables bshell Motive source SDIS:ERP-00000-00555 MaintCorelli: # 29324 (BDUX21397): Informix CSDK 2.90 for DEC platform Date: Tue, 31 Jan 2006 13:01:09 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Update to Informix CSDK 2.90 for DEC platform necessary. Affected Executables inf_srv6.2 MaintCorelli: # 29295 (BDUX21350): UPDATE STATISTICS for Informix implemented Date: Thu, 26 Jan 2006 17:05:42 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) To ensure that the Informix optimizer selects a query plan that best reflects the current state of your tables UPDATE STATISTICS is necessary. Workaround manual database administrator task Affected Executables inf_srv6.2 MaintCorelli: # 29288 (BDUX21170): Oracle 10g install for Windows Date: Thu, 26 Jan 2006 15:10:01 +0100 (CET) Created on: MaintCorelli Type: porting specific change Problem Description (Customer terms) Windows install media for BaanIV and Corelli will be created again. These new media must support Oracle 10g as well. Test Procedure Full install Affected Executables full windows install MaintCorelli: # 29253 (BDUX21301): iSeries: V5R3 install problem Date: Mon, 23 Jan 2006 18:59:29 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Install on V5R3 fails with CPF3025 Test Procedure install on V5R3 Affected Executables db4* MaintCorelli: # 29170 (BDUX21132): Password aging check (-checkpwd) failed on some AIX (5.3?) versions Date: Tue, 17 Jan 2006 17:13:21 +0100 (CET) Created on: MaintBaanIVc Type: porting specific change Problem Description (Customer terms) badmin6.x -chkpwd failed on getting age of password. Workaround Set all attributes, which is not really a workaround. We only found this problem on a customer (AIX5.3) system. Test Procedure Run badmin6.x -chkpwd and check that valid info (age etc) will be shown Affected Executables badmin6.x MaintCorelli: # 29124 (BDUX21202): DB: error 509 with mirrored database Date: Fri, 13 Jan 2006 13:49:02 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Error 509 is issued on database actions if database mirroring is used. The chance on this error is bigger of some tables are mirrored and some other tables are not mirrored. Test Procedure See the regression tests (mirrored_cursors/001a & mirrored_cursors/001b) for reproduction scenarios. Affected Executables bshell Motive source TECH-00000-00227 MaintCorelli: # 29110 (BDUX21157): iSeries: enhance installer Date: Wed, 11 Jan 2006 16:57:38 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) lp6.2.PGM is not installed correctly some files were left in directory /BAAN/BAANLIB/AS400Tools after installation Workaround BAANLIB/RSTFRMSTMF RSTLIB(BAANLIB) STMF('/BAAN/BAANLIB/AS400Tools/pgm/lp6.2') if needed create symlink in qshell: ln -s /QSYS.LIB/BAANLIB.LIB/LP6.2.PGM $BSE/bin/lp6.2 Test Procedure install portingset MaintCorelli: # 29103 (BDUX21180): intern Dont check for development license 10146 in bic. Date: Wed, 11 Jan 2006 15:06:34 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) It is not possible to do customizations on reports or create scripts for exchange if no development license is available. MaintCorelli: # 29070 (BDUX21144): Bdbreconfig: Adding a column to an empty table should never give error 205 (domain constraint violation) Date: Mon, 9 Jan 2006 14:34:02 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) If a column with the following properties is added to a table, then the reconfiguration fails with error 205, even if the table is empty (or does not exist). - no initial value (no default value); - mandatory input: yes If a table is empty then adding a column should never fail with error 205, because only data can result in a domain constraint violation. Test Procedure Create an empty table. Add a column with "mandatory input: yes" and without an "initial value" (default value). Reconfigure the table and observe that error 205 is not reported. Affected Executables bdbreconfig6.2 MaintCorelli: # 29052 (BDUX21124): Bdbreconfig: Adding a column to an empty table should never give error 205 (domain constraint violation) Date: Fri, 6 Jan 2006 16:43:03 +0100 (CET) Created on: MaintDvorak Type: bugfix Problem Description (Customer terms) If a column with the following properties is added to a table, then the reconfiguration fails with error 205, even if the table is empty (or does not exist). - no initial value (no default value); - mandatory input: yes If a table is empty then adding a column should never fail with error 205, because only data can result in a domain constraint violation. Test Procedure Create an empty table. Add a column with "mandatory input: yes" and without an "initial value" (default value). Reconfigure the table and observe that error 205 is not reported. Affected Executables bdbreconfig6.2 MaintCorelli: # 29004 (BDUX21092): add version info to bjvmi.jar Date: Wed, 4 Jan 2006 10:20:44 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Version info required for bjvmi.jar Test Procedure java -cp bjvmi.jar BJVMIVersion Affected Executables bjvmi.jar MaintCorelli: # 28996 (BDUX21076): MySQL: implement mysql_retained_cursors Date: Tue, 3 Jan 2006 14:39:33 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) The resource mysql_retained_cursors does not have any effect on the number of inactive cursors. Test Procedure Using qptool execute the following script (the 'i' option is new in qptool and sets the "statement id" so that it later in the script can be reused): @i0pefb select empno from dbtst120 where empno = 10; @i1pefb select empno from dbtst120 where empno = 20; @i2pefb select empno from dbtst120 where empno = 30; @i1ef; @i0ef; @i0bc ; @i1bc ; @i2bc ; If mysql_retained_cursors is set to 0, then each execute of a query will result in taking an inactive cursor from the break list. Set DBSLOG=1000 and use the following egrep: egrep "_open_cursor|break list" dbs.log The result should be something like: MySQL_open_cursor _mysql_open_cursor 0x8238490 MySQL_open_cursor : id 0x8245008 Cursor 0x8238490 put in break list [1]. MySQL_open_cursor Cursor 0x8238490 removed from break list [0]. MySQL_open_cursor : id 0x8245c08 Cursor 0x8238490 put in break list [1]. MySQL_open_cursor Cursor 0x8238490 removed from break list [0]. MySQL_open_cursor : id 0x8246808 Cursor 0x8238490 put in break list [1]. Cursor 0x8238490 removed from break list [0]. Cursor 0x8238490 put in break list [1]. Cursor 0x8238490 removed from break list [0]. Cursor 0x8238490 put in break list [1]. Cursor 0x8238490 removed from break list [0]. Note that only the first MySQL_open_cursor is followed by a _mysql_open_cursor (the one that opens a 'real' MySQL cursor). The next MySQL_open_cursors are followed by "removed from break list", which means that an inactive cursor was, well, removed from the break list. Now re-run the script with mysql_retained_cursors set to 10. This time the pattern should look like: MySQL_open_cursor _mysql_open_cursor 0x8238490 MySQL_open_cursor : id 0x8245008 Cursor 0x8238490 put in break list [1]. MySQL_open_cursor _mysql_open_cursor 0x8238580 MySQL_open_cursor : id 0x8245c08 Cursor 0x8238580 put in break list [2]. MySQL_open_cursor _mysql_open_cursor 0x8238670 MySQL_open_cursor : id 0x8246808 Cursor 0x8238670 put in break list [3]. Taking cursor from break list. Cursor 0x8238580 removed from break list [2]. Cursor 0x8238580 put in break list [3]. Taking cursor from break list. Cursor 0x8238490 removed from break list [2]. Cursor 0x8238490 put in break list [3]. Cursor 0x8238490 removed from break list [2]. Cursor 0x8238580 removed from break list [1]. Cursor 0x8238670 removed from break list [0]. Note that each MySQL_open_cursor is followed by _mysql_open_cursor. Affected Executables mysql_srv6.2 MaintCorelli: # 28966 (BDUX21049): MySQL: Create all indexes in one ALTER TABLE statement (bdbpost -f) Date: Wed, 28 Dec 2005 16:01:47 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) If the -f option of bdbpost is used then all indexes are created after data loading. The MySQL driver creates the indexes one by one, which makes this very slow. It would be much better if one ALTER TABLE statement were used to create all indexes in one go. Test Procedure Create a table dump of a table containing more than one index. Import this table using the -f option of bdbpost, while setting DBSLOG=400. Observe in the dbs.log file that there is one ALTER TABLE statement that creates all indexes after data loading. Affected Executables mysql_srv6.2 MaintCorelli: # 28948 (BDUX21031): Correction of BDNT20517/BDNT21009: empy/non-existing USER environment varialbe causes start-up failure for many binaries. Date: Fri, 23 Dec 2005 11:25:03 +0100 (CET) Created on: DevSchoenberg Type: bugfix Problem Description (Customer terms) If the USER environment variable is empty or not set, bic6.2 tries to use Baan user '' (i.e., the empty string). This makes bic fail. Workaround Set USER to the same values as LOGNAME (on UNIX) or USERNAME (on Windows). Test Procedure On UNIX in a ksh, run "USER= bic6.2 -V"; before this fix the error message "Current user is not a valid Baan user" is printed. Affected Executables many MaintCorelli: # 28946 (BDUX20821): QP: distributed query with order by corrupts array column values Date: Fri, 23 Dec 2005 11:08:56 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) A query that selects an array column, is distributed (fetches its data from two or more databases), has an order by defined on two or more of these database and selects an array column, produces a wrong result. Test Procedure See Problem Description (Technical terms) Affected Executables bshell qptool bdb library Motive source DDEF-00000-00149 MaintCorelli: # 28916 (BDUX20408): Error 305 on AS/400 Date: Wed, 21 Dec 2005 11:43:27 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Error 305 (wrong row returned) occurs during run of jobs with multiple bshells on AS/400. The error occurs sometimes and at random points. Test Procedure It's virtually impossible to test this, without explicit synchronisation of the two database drivers (for example using an AS/400 debugger). This error only occurs in a specific situation. Affected Executables db4_srv6.2 Motive source DF:150930 MaintCorelli: # 28912 (BDNT20517): Wrong user mentioned in audit files Date: Wed, 21 Dec 2005 10:20:56 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) I have a 3 tier environment. I installed solution 200463 and had to re-create the run time for my users plus the 'remote' user. I keep my audit files centrally on my database server and now all entries have the user id 'audit' instead of the individual users login. Workaround n/a Test Procedure Setup remote audit and use a remote user file with following format : Change a record on a table that will be audited. Check if the correct user is mentioned in audit reports. Affected Executables several Motive source DF:227039 MaintCorelli: # 28864 (BDUX20577): SLM Make slm functions available for 3GL Date: Fri, 16 Dec 2005 15:31:04 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) The problem is that customers don't want to add named users one by one to the SLM server. Therefore an upload of user from the Enterprise Server to the SLM server must be made possible. Therefore some extra functions of the SLM api must be made available for 4GL programmers. Test Procedure Test new session ttslm0230m100 MaintCorelli: # 28858 (BDUX20930): bdbreconfig can fail Date: Fri, 16 Dec 2005 14:15:43 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Convert to runtime does not work correct. After reconfigure tables the new table fields are not available. The problem was found on AS400. Workaround n/a Test Procedure Convert data dictionary with reconfigure tables. Affected Executables bdbreconfig6.2 MaintCorelli: # 28826 (BDUX20925): Merge context_on repair-fix to Corelli. Date: Thu, 15 Dec 2005 14:00:52 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) In portingset 7.1d.11, compiling reports with Output Conditions and PrintExpressions that contain a string, will result in a syntax error in bic. Test Procedure Compile a report that has an Ouput Condition containing a quoted string. Affected Executables repgen6.2 MaintCorelli: # 28774 (BDNT20840): db.error.message does not return message when domain check fail Date: Fri, 9 Dec 2005 14:26:49 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Function db.error.message() does not return message when db.check.row.domain() fails with out of range error. Workaround n/a Test Procedure use following 3gl test program and trace variable m. function main() { table ttdsls401 long ret string fld_name(18) string m(255) ret = db.check.row.domains(ttdsls401, fld_name) m = db.error.message() } Affected Executables bshell6.x MaintCorelli: # 28772 (BDUX20886): z/OS: make blogind non-swappable Date: Thu, 8 Dec 2005 16:36:08 +0100 (CET) Created on: MaintCorelli Type: porting specific change Problem Description (Customer terms) z/OS: The BaanLogin daemon is still not non-swappable, despite an earlier fix. Workaround n/a Test Procedure z/OS: use "ps -el" and look in the "S" output column to see that no I (swapped out) is shown for blogind6.2, also not some time after it is started. Affected Executables blogind6.2 licd6.2 MaintCorelli: # 28765 (BDUX20880): blogind shows wrong user name in proceslist Date: Thu, 8 Dec 2005 15:13:00 +0100 (CET) Created on: MaintCorelli Type: porting specific change Problem Description (Customer terms) Solved issue with blogind (unix) or logic service (windows) Workaround remove variable LOGNAME/USERNAME from env. before starting blogind (Unix)/logic service (Windows) Test Procedure Unix: run ps -ef on bshell and database driver: before this fix (mark the name between square brackets): bsp 7671 7670 0 13:18:50 ? 0:00 oracle8 (bsp[root]:7670/LSOCKET) 7670 289 12 bsp 7670 7421 0 13:18:49 ? 0:00 /baan/b61a/bse/bin/bshell_bin6.2 -1 545 0 1 -set BSHELL_TAG=bsh bsp 7673 1 0 13:18:50 ? 0:00 oracleora10 (DESCRIPTION=(LOCAL=YES)(SDU=8192)(TDU=8192)(ADDRES after this fix: bsp 17274 1 0 13:52:17 ? 0:00 oracleora10 (DESCRIPTION=(LOCAL=YES)(SDU=8192)(TDU=8192)(ADDRES bsp 17272 17270 0 13:52:16 ? 0:00 oracle8 (bsp:17270/LSOCKET) 17270 289 13 13 bsp 17270 21714 0 13:52:14 ? 0:00 /baan/b61a/bse/bin/bshell_bin6.2 -1 545 0 1 -set BSHELL_TAG=bsh Affected Executables all db drivers, bshell and more MaintCorelli: # 28746 (BDUX20832): z/OS: Fix blogind: setuid() correctly for created address space, and make non-swapable Date: Thu, 8 Dec 2005 10:14:10 +0100 (CET) Created on: MaintCorelli Type: porting specific change Problem Description (Customer terms) z/OS: The BaanLogin daemon creates an address space for the started ipc_boot6.2, and that address space has the authorization of the user id that started blogind6.2. This causes the DB2 AuthID to *also* be that same user id (e.g., 'root'), leading to an authorization issue. z/OS: Make blogind6.2 non-swappable, just like the license daemon. Workaround n/a Test Procedure Login through blogind6.2, and check the AuthID of the DB2 connection. Affected Executables blogind6.2 MaintCorelli: # 28737 (BDUX20858): Removed kermit and dpt from portingset Date: Wed, 7 Dec 2005 12:29:56 +0100 (CET) Created on: MaintCorelli Type: porting specific change Problem Description (Customer terms) Removed obsolete binaries MaintCorelli: # 28708 (BDUX20767): cannot delete database user on AS400 Date: Tue, 6 Dec 2005 10:39:57 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Whilst testing portingset 7.1d.11 I found that when deleting a user I get the following error ttdbadll02 Error from Database: [User 'Tum 'is not the member of group Baan. Workaround n/a Test Procedure Check situations mentioned in comments. Affected Executables db4_maint6.2 Motive source DF:161006 MaintCorelli: # 28602 (BDUX20742): MySQL: error 111 on update Date: Fri, 25 Nov 2005 15:53:27 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) If a session is opened and closed, then error 111 is returned and the following error message is shown in the BW messages window: 131 : process 6 - Fatal error : Error 111 (No record found) on ttadv990000 (Max retries (10) exceeded) 132 : process 6 - Fatal error : Can not continue in whinh2100m000 in DLL: ottstpstandard (save.grid.state)[commit.transaction] Problem occurs only if the user uses the "save defaults" functionality. Workaround Don't use the "save defaults" functionality. Test Procedure Enable the "save defaults" functionality. Open and close a session, _don't_ do anything else. This will case the some defaults to be saved again. Affected Executables all database drivers Motive source TCS:800-150368 MaintCorelli: # 28505 (BDNT20637): Bwprint: Improve registry access check Date: Fri, 18 Nov 2005 15:33:08 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) A normal Windows user (member of group Users), cannot use the drop-down menu's in Bwprint: they are disabled. After assigning "Full Control" permission for this normal user to key HKLM\SOFTWARE, the menu's are enabled. It should be enough if the user has "Full Control" for the key HKLM\SOFTWARE\Baan for example. But now the user needs to have "Full Control" for a much global key, HKLM\SOFTWARE. Workaround Give user Full Control for HKLM\SOFTWARE Test Procedure As an administrator: Install the BW client After doing this the following keys should be present: HKLM\SOFTWARE\Baan HKLM\SOFTWARE\Baan\BwPrint Assign "Full Control" to key HKLM\SOFTWARE\Baan for the normal user Log in as the normal user Now it should be possible for the normal user to use the drop down menu's in Bwprint, like changing Font (Spacing) settings. Affected Executables Bwprint Motive source DF:160397 MaintCorelli: # 28470 (BDUX20219): Uppercase users on Unix cannot login Date: Thu, 17 Nov 2005 10:24:50 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Because of a previous fix for Windows where users with one or more uppercase characters could not login, now user with uppercase character(s) on Unix are not able to login. Test Procedure Create a user with uppercase characters in its name on Windows and Unix. Try to login. Affected Executables bshell6.1 ntbshell.exe Motive source DF:158525 MaintCorelli: # 28457 (BDUX20615): bdbvalidate dumps core Date: Wed, 16 Nov 2005 13:47:41 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) bdbvalidate crashes on tables having rare data types like DB.BITSET Test Procedure bdbvalidate6.2 -Ntdsmi000702 -pb50csp17 -C702 on system nlbauad1.ssainternal.net Affected Executables bdbvalidate MaintCorelli: # 28410 (BDUX20575): Password aging on HP-UX Date: Mon, 14 Nov 2005 16:08:43 +0100 (CET) Created on: MaintMahler Type: bugfix Problem Description (Customer terms) HPUX Trusted Security is used. The password of the user is going to be expired. Therefore the following message is given by the operating system when trying to log in (e.g. using telnet): "your password will expire on .... (date)". But when logging into Baan using Worktop, the user is not notified about this and is not prompted to change the password. Workaround Do not use password expiration. Test Procedure It is required to have an HP-UX system, running in Trusted Security mode. Configure the following (you can do this via SAM): * Time Between Password Changes * Password Expiration Time * Password Expiration Warning Time * Password Life Time And have some accounts for which the following conditions are met: - an account which is expired: It should not be possible to log in Baan, and you cannot change the password. - an account which is in the warning period (going to be expired, but not yet) When logging into Baan, you will be asked if you want to change the password. When answering Yes you can change the password via the Terminal Emulator. - an account which is not expired and not in the warning period. You should be able to log in Baan without getting any messages. You can run also badmin6.2 -chkpwd to check and log in Baan and check. (Assuming that you have set up Password Expiratioin) Affected Executables badmin6.2 blogind6.2 Motive source DF:158752 MaintCorelli: # 28402 (BDUX20583): z/OS: switch to ARCH(6) and IEEE floats Date: Mon, 14 Nov 2005 15:28:23 +0100 (CET) Created on: MaintCorelli Type: porting specific change Problem Description (Customer terms) z/OS 1.6: Optimize the porting set for the highest architecture (ARCH(6)), since Komatsu is the only customer, and they will run on a model 2084-C24 system. To simplify internal testing: switch to IEEE floats, which will give less false mismatches on one of our regression test suites. Test Procedure No specific test. Affected Executables all MaintCorelli: # 28325 (BDUX20536): QP: distributed query with not exists not working Date: Thu, 10 Nov 2005 10:42:20 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) The following query gives an incorrect result if tables tdsls045 and tccom010 are handled by different database drivers: select orno,pono,srnb,cuno from tdsls045 where tdsls045.orno inrange 203000 and 709003 and not exists ( select * from tccom010 where tccom010.cuno=tdsls045.cuno and tccom010.comp=550 and _compnr = :1) order by tdsls045._index1 Effectively, the exists subquery will always return FALSE, meaning that the not exists subquery never filters out any row. Under the following condition the exists subquery is evaluated wrongly: 1. The subquery is handled by a different database driver than the main query; 2. The select in the subquery contains a "*" or the _compnr column; 3. The subquery contains a _compnr = ... expression. Workaround The simplest work-around is to replace the "*" in the subquery by any other field of the table (excluding the _compnr column), e.g: select orno,pono,srnb,cuno from tdsls045 where tdsls045.orno inrange 203000 and 709003 and not exists ( select cuno from tccom010 where tccom010.cuno=tdsls045.cuno and tccom010.comp=550 and _compnr = :1) order by tdsls045._index1 Test Procedure Set-up tabledef so that the tables are handled by different database drivers, e.g: tccom010:*:oracle8(ORACLE_HOME=/oracle/app/product/ora9.2,TWO_TASK=I3):N tdsls045:*:oracle8(ORACLE_HOME=/oracle/app/product/ora9.2,ORACLE_SID=B1):N Now run the query in the Problem Description (Customer terms) and observe that the proper rows are filtered out by the not exists expression. Affected Executables all database drivers Motive source DF:227642 MaintCorelli: # 28308 (BDNT20485): Crashing bwc.dll when using published environment from ADS Date: Wed, 9 Nov 2005 15:44:49 +0100 (CET) Created on: MaintDvorak Type: bugfix Problem Description (Customer terms) Cannot use ERP environment information published in ADS : the BW / BECS software is crashing. STEPS TO BE FOLLOWED: 0 - Cannect using a domain user on "ELTONBV" Active Directory domain 1 - Open BECS. 2 - In "Options" menu, verify that Active Directory support is enabled. The Active Directory server can be left blank, or set to "DS1KA", this yield the same result. 3 - Open a BW connection to server MS1KA, or create a new one. 4 - Click on the "Published" button. 5 - You can choose two different env. : "baan" or "erpln61" Choose environment "baan". 6 - Click OK The BW configuration window and the SSA BECS window disappear. In the Application log, new event below is added : 21-7-2005 12:00:06 Application Error Error (100) 1000 N/A MS1KA Faulting application becs.exe, version 7.6.1.4, faulting module bwc.dll, version 7.6.1.4, fault address 0x00012fdb. Workaround No workaround. Test Procedure To test this you need to have: - 2 Baan environments (at least fat client's) installed on a Windows ADS (Active Directory Server) - the 2 Baan environments should be published into the ADS. (You can do this using the dssetup.exe utility) - in BECS (Tools->Options), enable Active Directory Open BECS Press New button, BW Configuration window is opened now Select Published Select one of the environments from the services drop down list Press OK Now the "Save As" dialog window should appear, and BECS/bwc.dll should not crash. Affected Executables bwc.dll Motive source DF:157969 MaintCorelli: # 28277 (BDNT20498): DF159418 BW Login dialog hangup when changing Windows input language Date: Tue, 8 Nov 2005 15:09:57 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) The Windows input language can not be changed when password dialog appears in BW. This problem appears when BW is started from Worktop only. If BW is started from BECS no problem found. The problem is reproducable with latest BW for Corelli and onwards. Workaround Save password in .bwc file. Test Procedure See problem description. Affected Executables bw.exe Motive source DF:159418