List of changes for portingset: 8.4a MaintChopin: # 35690 (BDUX27764): Buffer overflow in COMBO mode when buffered transaction becomes too large Date: Tue, 5 Jun 2007 16:50:05 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) "Message Buffer overflow in combined Bshell/driver" in compute phase numbers Workaround do not use combo mode to run this session. Test Procedure run regression tests (lib/sql/Test/*) Affected Executables almostall Motive source SDIS:ERP-00000-18799 MaintChopin: # 35645 (BDUX27813): TECH-00000-02029: QP: Distributed ORDER BY corrupts array values Date: Thu, 31 May 2007 11:19:25 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) If two tables of a query are handled by different database drivers and the query contains an ORDER BY and the SELECT clause contains an array column, then the values of the array column are corrupted. Test Procedure Execute a query as the following in a distributed environment. The column dbtst191.bytearr is an array of type byte. select dbtst120.empno, dbtst191.key, dbtst191.bytearr, dbtst191.flotarr from dbtst120, dbtst191 where dbtst120.empno = 10 and dbtst191.key >= 10 order by dbtst120.empno, dbtst191.key Observe that the result is as expected. To use the "classic" QP in a LN environment use the -p 100 option with qptool. Affected Executables bshell MaintChopin: # 35631 (BDNT27801): OpenWorld (infor integration 6.2) rebranding Date: Wed, 30 May 2007 16:26:33 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) OpenWorld (infor integration 6.2) rebranding DevChopin: # 35570 (BDUX27517): DB2 installation fails on DB2 V9.1 Date: Thu, 24 May 2007 16:03:18 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Installation against DB2 V9.1 not possible on AIX Workaround Manually create a database a use that one. Test Procedure Try an installation against DB2 V9.1 on AIX (and possible the same will occurr for DB2 V9.1 on Windows) Affected Executables db2v5_adm binary Motive source TCS:200-156697 MaintChopin: # 35491 (BDNT27678): Better construction of library name in SLI Date: Mon, 21 May 2007 11:17:34 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) Incorrect detection of shared library version may result in failure loading combo driver. MaintChopin: # 35489 (BDNT27671): Renaming BSE in baanman did not use - if any - new product names Date: Mon, 21 May 2007 10:48:58 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) Baan management snapin did not properly rename BSEs in some cases. Workaround NA Affected Executables baan management snapin Motive source TCS 800/156616 MaintChopin: # 35469 (BDNT27663): Filter locked DLLs during SLM installation Date: Wed, 16 May 2007 16:30:51 +0200 (CEST) Created on: MaintChopin Type: enhancement Problem Description (Customer terms) ASM DLL's were reported as locked during SLM installation which was true but not relevant Workaround Stop ASM during SLM installation Test Procedure Lock ASM and SLM specific DLL's and install SLM: locked DLL's of SLM only should be reported Affected Executables SLM 7.0 installer MaintChopin: # 35444 (BDUX27636): Crash while compiling a session Date: Tue, 15 May 2007 15:47:53 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) The customer got a "connection to server lost" while compiling the program script "tswcs2100" Workaround A workaround is to place the following line in the file $BSE/lib/defaults/all: bshell_max_strbuf_size:200000 Test Procedure testcases Affected Executables bshell Motive source SDIS:ERP-00000-19723 MaintChopin: # 35437 (BDUX27611): MLE: Support just one available language Date: Tue, 15 May 2007 13:56:09 +0200 (CEST) Created on: MaintChopin Type: bugfix Problem Description (Customer terms) It should be possible to have an MLE environment with just one available language. This is required for a proper roll-out of the MLE project, because if a customer wants to enable an environment for MLE, then the down-time must be minimized and the following procedure could be used: - define the columns that should be MLE - define the additional languages (status "being added") - create the runtime datadictionary and reorganize the tables - open the environment for use (with only one available language) (!) - run bdbmlf to create default translations - close the environment - switch the status of the additional language to "available" - open the environment for use (with all languages available) Test Procedure Create an MLE environment with some MLE columns and only one language available. Start sessions using this column, update the column, and so on. Affected Executables bshell all drivers DevChopin: # 35367 (BDUX27553): MLE: failing bdbpost on raw data Date: Wed, 9 May 2007 11:18:19 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) bdbpost looses data on tables with disguised raw columns (like tttxt010.text) Workaround Use bdbpre -t (dump with separator) Test Procedure bdbpre6.2 -N tttxt010 -C 0 > dump bdbpost6.2 -k -n < dump bdbpre6.2 -N tttxt010 -C 0 > dump.1 dump and dump.1 should be identical (except for the timestamp). Affected Executables bdbpost DevChopin: # 35358 (BDUX27539): TECH-00000-02270: shdbdbapi: incompatibility with Corelli version Date: Wed, 9 May 2007 08:11:59 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) The integration with CR XI Release 2 fails with a 8.3a.01 porting set with the following error message: The connection failed. Details: Undefined column! Test Procedure Upgrade the porting set and the shdbapi.dll. Connecting through CR XI should go without problems. Affected Executables shdbapi.dll Motive source SDIS:TECH-00000-02270 DevChopin: # 35285 (BDUX27383): Call Graph Profiler causes bshell to hang Date: Thu, 3 May 2007 15:04:58 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Call Graph Profiler hangs or causes other problems during close of bshell Affected Executables bshell6.2 DevChopin: # 35274 (BDUX27442): Core dump with Informix combo driver on AIX platforms Date: Thu, 3 May 2007 15:00:04 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Core dumps with Informix combo driver on AIX platforms. Workaround n/a Test Procedure n/a DevChopin: # 35260 (BDNT26923): Oracle collation INFOR_GENERIC_M Date: Tue, 1 May 2007 17:11:05 +0200 (CEST) Created on: DevChopin Type: porting specific change Problem Description (Customer terms) The Oracle GENERIC_M collation has problems with leading spaces. The collation INFOR_GENERIC_M contains some modifications on this Oracle collation to be used in Unicode mode. This project only contains the definition of INFOR_GENERIC_M A support solution will be written for deploying this collation at customer sites. Workaround Avoid leading spaces in your data Motive source SDIS:TECH-00000-01475 DevChopin: # 35243 (BDUX27412): permission check fails Date: Thu, 26 Apr 2007 16:14:07 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) I have made changes to the form of session tfgld1431m000. I have next problem: 1. Start session tfgld1431m000 from Sessions (ttadv2500m000). 2. Close session tfgld1431m000. 3. Select tfgld1431m000 in Sessions and press Specific. 4. Select Edit Form. 5. Getting next error: Fatal Error : [MR_NO_PERMS] No permission for ttstpoledaem 6. I have to kill Sessions to continue. Test Procedure See problem text Affected Executables bshell DevChopin: # 35201 (BDUX27388): MLE: invalid contents pointer Date: Wed, 25 Apr 2007 10:52:17 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Error: "[MR_NULL_POINTER] Use of NULL pointer on ''" or "symbol has invalid contents pointer" Test Procedure regression tests Affected Executables bshell Motive source TCS:800-157249 DevChopin: # 35058 (BDUX27190): Fix problem in bdbpost with import Date: Thu, 12 Apr 2007 09:17:22 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Single Byte Fields with high ascii cannot be imported sometimes. Test Procedure 1. create a new entry in ecedi2310 with the first field with one or more high ascii charaters and fill the field completely 2. create a dump of the table 3. reimport the table Affected Executables bdbpost6.2 Motive source TCS:800-1566045 DevChopin: # 34941 (BDNT27057): Implement proper unload TssConvert.dll Date: Mon, 2 Apr 2007 14:37:31 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Installshield temporay directories cannot be deleted after the install has ended. Test Procedure Run the installer. Install on a Unix host. Cancel installation in the Destionation Directory dialog. Installshield temporary directory in %TEMP% should be deleted (to be recognized by the name, it's a GUID) DevChopin: # 34914 (BDNT27002): Make SQLserver resources conform documentation and enable EnvVars also via resources Date: Fri, 30 Mar 2007 12:26:19 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Documentation is wrong about resource msql_lock_timeout. The value 0 is support to mean 'wait without timeout' but it is implemented as no wait. The values -1 should mean 'wait without timeout' but this value is not suppoted. To enable msql_array_fetch/insert one needs to specify an environment variable most people in field expect that this is a resources as well, resulting in a lot of confusion. Workaround For possible 'wait without timeout' take very high timeout value. Use environment variable in tabledef for msql_array_fetch/insert Test Procedure Set environment variable DBSLOG=01400. Add resources to $BSE/lib/default/db_resouce: msql_lock_timeout:-1 msql_array_fetch:1 msql_array_insert:1 Run a query via bsql.exe Check dbs.log for resource settings and queries to SQLserver Repeat with different resource values. NOTE: environment vars set in e.g. tabledef6.2 overrule the values in resource file. Affected Executables msql7_srv.dll msql7_srv.exe msql7_maint.exe msql7_adm.exe DevChopin: # 34886 (BDUX26608): prevent bshell crash when out of memory Date: Thu, 29 Mar 2007 09:18:42 +0200 (CEST) Created on: DevChopin Type: enhancement Problem Description (Customer terms) bshell comes to a hard stop when there is no more memory available to allocate Workaround add physical memory and/or allow to allocate more memory by means of ulimit -d Test Procedure start buscomponent call a session which allocates a lot of memory Affected Executables bshell Motive source IND238 DevChopin: # 34770 (BDNT26872): Error mapping in MSQL2005 is different. Map some errors to bdb error 506 Date: Mon, 19 Mar 2007 16:09:39 +0100 (CET) Created on: DevChopin Type: porting specific change Problem Description (Customer terms) SQL2005 introduced some new errors, causing failures now. Test Procedure Run bdbreconfig on SQL2005 on a empty/non-existing table. No error should occur now anymore. Affected Executables msql7_srv.[exe|dll] DevChopin: # 34708 (BDNT26387): Infor Branding for BW Date: Thu, 15 Mar 2007 17:24:36 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Infor Branding for BW Affected Executables bw.exe becs.exe setup.exe DevChopin: # 34707 (BDUX26793): dbms user is required in output file from RDBMS sessions. Date: Thu, 15 Mar 2007 14:47:10 +0100 (CET) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Run session "ttdba0515m000". - Press new. - Introduce data for a new user. - Save. - Convert User. If you enter a wrong password for this step, the user "Baan" changes it's status in the session to "Not yet created in RDBMS" Workaround n/a Affected Executables xxx_maint6.x binaries Motive source SDIS:TECH-00000-02053 DevChopin: # 34627 (BDUX26732): new timezone files Date: Thu, 8 Mar 2007 15:31:48 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) New timezone rules are created and for this new files should be included in the portingset also Workaround download the files manually and compile these with zic6.1 manually Test Procedure check if the number of files and directories are now 577 Affected Executables files in $BSE/lib/zoneinfo and $BSE/lib/zonerules DevChopin: # 34614 (BDNT26656): fill java.library.path property Date: Thu, 8 Mar 2007 10:09:04 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Starting tmboaserver via BW works fine. 1) Windows: But when trying to start openworld via bshell in the background (started from command line or via ASM), it fails. The bshell is hanging. Dbgjvmi shows the following lines: B:0000026:::(00001):Exception occured in start (I)V B:0000027:::(00001):Exception cleared 2) Linux: When trying to start tmboaserver in the background (via commandline, or via ASM), it is needed to extra add $BSE/shlib to the LD_LIBRARY_PATH. Otherwise tmboaserver doesn't start. Result of this is, that the ASM server has to be hard linked to a specific BSE environment, and cannot be used anymore for multiple BSE environments. * when ASM is started with: LD_LIBRARY_PATH=/usr/java/j2sdk1.4.2_06/jre/lib/i386:/usr/java/j2sdk1.4.2_06/jre/lib/i386/client or with unset LD_LIBRARY_PATH error "Cannot start, failed to start JAVA, wrong JDK version" * when ASM is started with: LD_LIBRARY_PATH=/usr1/baan4/bse/shlib:/usr/java/j2sdk1.4.2_06/jre/lib/i386:/usr/java/j2sdk1.4.2_06/jre/lib/i386/client works fine Workaround In $BSE\java\jvm_options: -Djava.library.path=\shlib On Windows: append PATH with \bin;\bin\client in system environment variabeles append PATH with %BSE%\bin;%BSE\shlib in environment variabeles of each BSE by means of baanman snapin the ASM service will use these PATHs On Linux: append LD_LIBRARY_PATH with /shlib in each $BSE/lib/bse_vars append LD_LIBRARY_PATH with /lib/i386:/lib/i386/client:/lib/i386/native_threads before starting ASM server from command line before starting a bshell, ASM server will read its bse_vars file Test Procedure See Problem description Motive source TCS:800-156464 TCS:800-156465 DevChopin: # 34608 (BDNT26717): Wrong service name used for SHM Date: Wed, 7 Mar 2007 16:26:49 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Wrong service name used, resulting in failure to start (e.g.) SHM service. Workaround NA DevChopin: # 34601 (BDNT26703): Add option to pass install directory to setup Date: Wed, 7 Mar 2007 13:53:10 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) When using the unattended install for the BW client you are unable to select the directory to install the new client in. When running the BW setup.exe /s /u from the command line. This defaults to install in Program files\baan\Baan ERP There is no way to install it in another directory. Workaround Use attented install. Test Procedure See problem description. Affected Executables setup.exe Motive source SDIS:TECH-00000-02018 DevChopin: # 34586 (BDUX26565): password expired if baan login daemon used Date: Tue, 6 Mar 2007 15:11:12 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Baanlogin returns password expired even when it is not expired. Workaround Decrease Maximum Password Age. Affected Executables blogind6.x badmin6.x Motive source SDIS:TECH-00000-02050 DevChopin: # 34532 (BDUX26597): Use of field errno via macro and special function Date: Fri, 2 Mar 2007 14:44:12 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Global variable "errno" used always, even in shared library used in a multi-threading process Workaround NA Test Procedure Use OpenWorld (via JVM) to obtain a license via SLM Affected Executables In theory many; in practice just shared libaries called in a multi-threaded process DevChopin: # 34498 (BDUX26606): Fix as/400 pam build Date: Thu, 1 Mar 2007 12:30:13 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Compile error due to header mismatch Test Procedure compile Motive source SDIS:TECH-00000-01742 DevChopin: # 34479 (BDUX26587): PAM enhancements Date: Wed, 28 Feb 2007 15:34:09 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) It is not always clear what kind of error is given by PAM when changing passwords Affected Executables bshell6.1 badmin6.1 Motive source SDIS:TECH-00000-01742 DevChopin: # 34475 (BDUX26570): Loop in call graph profiler Date: Wed, 28 Feb 2007 13:25:40 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Call Graph Profiler hangs during a session close Test Procedure start tdsls4102m000 and close bshell shouldn't hang any more Affected Executables bshell6.1 Motive source TCS:800-156455 DevChopin: # 34446 (BDUX26484): set.fmax returns wrong values Date: Mon, 26 Feb 2007 16:03:43 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) On a non-unicode installation, the bshell function set.max and set.fmax returns values which can not be stored in the database. Workaround gh_ascii_tolerance_mode:1 in $BSE/lib/defaults/al Test Procedure Pre conditions: 1. Non unicode system, ($BSE/lib/tss_mbstore6.2 contains: * ) 2. high_ascii_tolerance:0 ($BSE/lib/defaults/all) function main() { string str(10) set.fmax(str) | str=~~~~~~~~~~ } Maximum characters: Z Unicode ~ Non Unicode and high_ascii_tolerance_mode=0 ˙ Non Unicode, ISO8859-1 and high_ascii_tolerance_mode= Affected Executables bshell6.2 Motive source SDIS:ERP-00000-13267 DevChopin: # 34396 (BDUX26486): SQL: join on company_nr/_compnr with column Date: Thu, 22 Feb 2007 13:28:38 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) It is not possible to join the "company_nr" column with an ordinary other column. It is not possible to join the _compnr column with an ordinary column reference. It neither is possible to join a _compnr column with another _compnr column. Test Procedure Using bsql6.2 -p16 (this uses the ANSI parse mode of the SQL processor), execute queries such as the following and observe correct results: select a.int, b.lastname, b.company_nr , c.deptno from dbtst106 a left join dbtst120 b on b.company_nr = a.int left join dbtst100 c on c.company_nr = b.company_nr and c.deptno = b.workdept where a.int in (0,1) and a.company_nr = 0 and b.empno in ( 10,20 ) From the bshell, execute queries such as the following and observe correct results: select a.int, b.lastname from dbtst106 a left join dbtst120 b on b._compnr = a.int select a.firstnme, b.deptname from dbtst120 a, dbtst100 b where a._compnr = b._compnr and a._compnr = 001 Affected Executables jbdb bshell bsql Motive source SDIS:TECH-00000-01965 DevChopin: # 34391 (BDNT26480): TCS 800-156074 Grey square when scrolling Date: Thu, 22 Feb 2007 11:13:00 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) In session "Planned Inventory Transactions (whinp1500m000)", when scrolling down (or up) the records, a grey square is visible above the grid. This grey square is just below the (dropdown listbox) field: Order Type. Test Procedure See problem description. Affected Executables bw.exe Motive source TCS:800-156074 DevChopin: # 34384 (BDUX26453): AS400 does not pick up specified user name for ASM Date: Wed, 21 Feb 2007 15:58:13 +0100 (CET) Created on: DevChopin Type: porting specific change Problem Description (Customer terms) Several ASM1.3 issues addressed: - on AS/400: started process not running under right account - on Windows: installer crash when correct runtime was not installed Workaround NA Test Procedure WIN32: run ASM setup. Check that installer works in Windows AS400: check that started instance runs under provided account Affected Executables Asm setup + asm server itself. Motive source TCS:800-155295 DevChopin: # 34381 (BDNT26080): TCS800-155949 Focus issues with date/time in grid Date: Wed, 21 Feb 2007 15:44:09 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Run a session with date/time fields in an editable grid (for example session: tcgr1135m000). Select a date or time field in the grid and then move the focus to another field using the mouse. Now the focus still seams to be on the date/time control. Also any characters entered are also inserted into the date/time control. Workaround Use the Tab key to move the focus through the grid. Test Procedure See problem description. Also look at the related TCS defect. Affected Executables bw.exe Motive source TCS:800-155949 DevChopin: # 34334 (BDNT26391): JDBC null date issue Date: Fri, 16 Feb 2007 11:08:20 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Using JDBC, customer gets date '0002-11-30' when QP returns 0 as date. In fact 0 is not a valid date. In MS SQL Server this corresponds with '1753-01-01'. So the user was expecting to get '1753-01-01' but is getting '0002-11-30'. Workaround Interpret '0002-11-30' as NULL. Affected Executables jbdb shared library DevChopin: # 34318 (BDNT26278): Several ASM issues Date: Wed, 14 Feb 2007 17:31:22 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Asm did not always show proper state of started instances. Added refresh timer. Asm was not rebranded to Infor naming. Workaround NA Affected Executables asm installer + asm daemon Motive source SDIS:DTECH-00000-00412 DevChopin: # 34313 (BDNT26393): BW Setup for Windows Vista Date: Wed, 14 Feb 2007 16:07:33 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) BW Setup on Windows Vista fails. Test Procedure Try to install BW on Windows Vista. Affected Executables setup.exe DevChopin: # 34305 (BDNT26382): Product ID 0 error Date: Wed, 14 Feb 2007 13:29:01 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Product ID 0 for ottstptclose when in shared memory Event viewer messages in th event viewer Test Procedure print any session and there should be no message about Product ID 0 Affected Executables bshell6.2 Motive source TCS:800-156262 DevChopin: # 34296 (BDUX26383): Barcode texts need to escaped if quotes are in barcode text Date: Wed, 14 Feb 2007 10:28:09 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Barcode on unix not correctly printed if barcode contains double quote or dollar sign (or any other character interpreted by shell) Workaround Postpone barocode processing to $BSE/lib/barocde/type%d script. Do not pass non-ascii data in barcode (bc$()). Test Procedure Write a 3GL script which call bc$() with double quote in barcode caption. Affected Executables filter6.x Motive source SDIS:TECH-11111-99999 (no defect yet created) DevChopin: # 34290 (BDNT26366): Informix driver crash on delete statement Date: Tue, 13 Feb 2007 15:01:31 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Informix driver crashs when “delete from” is executed. Workaround increase inf_prepare_cache_length value in db_resource file until error does not appear anymore. Test Procedure This easy test procedure can be used with a modified database driver only ! Database driver needs to be compiled with DEFAULT_INF_STMT_POOL_LENGTH 1 in dbs_informix.h For reproduction use following db_resource setting : inf_prepare_cache_length:1 Enter some values to ttaad050 table and run following 3gl program. function do_delete(string str(10) ) { delete from ttaad050 where syst = :str deleteempty enddelete abort.transaction() } function main() { do_delete("test1") select ttaad050.* from ttaad050 selectdo endselect do_delete("test2") } Affected Executables inf_srv DevChopin: # 34284 (BDUX26105): Handle SB fields with high_tolerance to generate single bytes Date: Tue, 13 Feb 2007 14:40:20 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) SB high ascii characters are not imported correctly in SB strings when high tolerance is enabled Affected Executables bdbpost6.2 Motive source TCS:800-156005 DevChopin: # 34170 (BDUX26253): DTECH-00000-01820: QP: query with unsupported operator in subqueries in OR predicate gives wrong result Date: Mon, 5 Feb 2007 17:08:48 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) A query that contains an OR condition with a subquery with a LIKE predicate, results in an incorrect result. The following query does not result in any rows if the second subquery results in an empty set. select * from ttaad300 where (ttaad300.loca in ( select tttss002.name from tttss002 where tttss002.descr LIKE ".*Europe.*") ) OR ( ttaad300.loca in ( select tttss002.name from tttss002 where tttss002.bidi=0) ) The following query results in error -1 with no message. select * from ttaad300 where (ttaad300.loca in ( select tttss002.name from tttss002 where ttaad300.loca=tttss002.name and tttss002.descr LIKE ".*Europe.*") ) OR (ttaad300.loca in ( select tttss002.name from tttss002 where tttss002.bidi=2) ) Workaround Avoid using the LIKE predicate inside subqueries. This project offers the new ALIKE functionality. Test Procedure Execute the first query in the "Problem Description (Customer terms)". The correct result should be returned. Replace the expression "tttss002.descr LIKE '.*Europe.*'" with "tttss002.descr ALIKE '%Europe%'" in the second query in the "Problem Description (Customer terms)" and execute the query. The correct result should be returned. Affected Executables bshell all database drivers Motive source SDIS:TECH-00000-01820 DevChopin: # 34148 (BDNT26235): Use infenv_lock_timeout for group sessions also Date: Mon, 5 Feb 2007 09:14:56 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) During bdbreconfig sometimes error 113 (table locked) appears. Workaround n/a Test Procedure This is difficult to test. The problem was seen on big tables, but it was more a random issue. Affected Executables inf_srv DevChopin: # 34105 (BDNT26193): Informix level 2 error 215 Date: Thu, 1 Feb 2007 09:46:16 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Informix level 2 customers are faced somtimes to error -215 (illegal state) Workaround Set inf_open_cursors:100 in db_resource file. If the problem still exist increase the value until error 215 disapears. Affected Executables inf_srv DevChopin: # 34060 (BDNT26145): MSQL: invalid cursors after deadlock recovery Date: Tue, 30 Jan 2007 13:49:19 +0100 (CET) Created on: MaintCage Type: porting specific change Problem Description (Customer terms) On SQL2000: E_BDB_ABORT (error 850) with invalid MSQL cursors after returning to a db.retry.point() on deadlock recovery. Workaround Upgrade to SQL2005 Test Procedure Using 2 bshells run the following two scripts on SQL2000: | BSHELL 1 table tdbtst100 table tdbtst120 function deadlock1() { db.retry.point() if db.retry.hit() > 0 then message("User1: Jumped to retry point %d, e = %d", db.retry.hit(), e ) endif select * from dbtst100 for update where deptno = "A00" selectdo dbtst100.deptname="HET ROMMELHOK" db.update(tdbtst100,db.retry) db.flush() message("User1: After 1st db.flush point ") endselect select * from dbtst120 for update where empno = 10 selectdo dbtst120.lastname = "KONIJN" db.update(tdbtst120,db.retry) db.flush() message("User1: After 2nd db.flush point ") endselect commit.transaction() } function main() { deadlock1() } | BSHELL 2 table tdbtst100 table tdbtst120 function deadlock2() { db.retry.point() if db.retry.hit() > 0 then message("User2: Jumped to retry point %d, e = %d", db.retry.hit(), e ) endif select * from dbtst120 for update where empno = 10 selectdo dbtst120.lastname = "RABBIT" db.update(tdbtst120,db.retry) db.flush() message("User2: After 1st db.flush point ") endselect select * from dbtst100 for update where deptno = "A00" selectdo dbtst100.deptname="DUMP STORE" db.update(tdbtst100,db.retry) db.flush() message("User2: After 2nd db.flush point ") endselect commit.transaction() } function main() { deadlock2() } - Start both bshells and the different sessions till both show the message "after 1st ..." - continue the 1st bshell (it blocks) - continue the 2nd bshell (it blocks too) - a deadlock detection by the database will cause both to continue to the 2nd message. - both will jump to the retry point. In the old situation one with e = 850 and one with e = 201 - continue with the session having e = 201 and run till completion - continue with the other (e = 850). This one keeps on failing and the event log shows invalid cursor errors With this fix both sessions jump to the retry point (with e = 201) and do not get invalid cursors anymore. Affected Executables msql7_srv Motive source SDIS:TECH-00000-01859 DevChopin: # 34045 (BDNT26133): Add Minidump to Portingset Date: Mon, 29 Jan 2007 12:04:31 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Analyzing problems on Windows is hard without a core dump like on Unix. Workaround Debugging at customer site. Test Procedure write a 3gl program: function main() { toggle.cpu(15) } will destroy the proces_header of the current process and the bshell will crash somewhere. This will result in a minidump being written in ${BSE_TMP} Affected Executables all DevChopin: # 33979 (BDNT26060): Change compile time defines into run-time decisions Date: Tue, 23 Jan 2007 16:58:34 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) ERP installer requires ASM/SLM selection during run-time Workaround NA Test Procedure Use ERP installer and install both ASM and SLM Affected Executables Installer(s) DevChopin: # 33972 (BDNT26048): Wrong user permissions on BSE/tmp let crash bshell Date: Tue, 23 Jan 2007 12:16:06 +0100 (CET) Created on: DevChopin Type: porting specific change Problem Description (Customer terms) Bshell crashes when trying to create a file in $BSE/tmp but failed due to strict permissions on file level. Workaround Set right permissions on $BSE/tmp (and $BSE/log for unix). Affected Executables bshell and others who use HAL_access_ex(). DevChopin: # 33936 (BDUX26028): iSeries: initialization error in combo driver Date: Fri, 19 Jan 2007 16:08:31 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) On iSeries the combo driver shows a bdb_error 700 and terminates. Workaround Use stand alone driver in stead of a combo driver. Test Procedure use combo driver in stead of a stand alone driver Affected Executables DB4_SRV6.2.SRVPGM DevChopin: # 33825 (BDUX25895): Domain checks: new error type NOHI for high-ascii-tolerance Date: Wed, 10 Jan 2007 11:31:53 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Domain checks that fail because of the HIGH_ASCII_TOLERANCE check are reported as ILCH. A new label must be introduced to distinguish this type of errors. Affected Executables bshell bdbvalidate DevChopin: # 33745 (BDUX25814): Remove compiler warnings from bdb_tools Date: Fri, 5 Jan 2007 12:25:48 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Resolve compiler warnings Workaround NA Test Procedure Compile Affected Executables NR DevChopin: # 33726 (BDUX25696): Fix Warning messages in ba and cu_4 Date: Thu, 4 Jan 2007 16:36:30 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Fix compile warnings Test Procedure compile ba and cu_4 Affected Executables ba6.2 nlsedit6.2 DevChopin: # 33635 (BDNT25419): DB2 installation problem Date: Tue, 2 Jan 2007 13:57:39 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Initialize datbase fails during Baan installation. Workaround Create database manually. Test Procedure Install Baan on DB2 and let the installer create the database. Affected Executables db2v5_adm DevChopin: # 33594 (BDUX25651): Logging comes in log.sh_server instead of invoked binary Date: Fri, 22 Dec 2006 11:16:05 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Any bshell started with run.[baan.]prog logs on Unix in log.sh_server. Test Procedure start a bshell by calling run.prog from a 3GL script. Be sure that bshell doesn't log in log.sh_server if an error occurred (e.g. provide invalid arguments for the bshell) Affected Executables bshell, sh_server. DevChopin: # 33536 (BDUX25565): Add process context in XML in bshell Date: Mon, 18 Dec 2006 14:04:35 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) not applicable DevChopin: # 33524 (BDUX25568): SQL: Support ml_lang_of and ml_check_in_lang (MLE) Date: Fri, 15 Dec 2006 15:18:31 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) This project introduces basic support for the ml_lang_of() and ml_check_in_lang() functions for use on MLE columns. The syntax of the functions is: ml_lang_of( [ , [ ,) hint now default Date: Wed, 13 Dec 2006 10:42:04 +0100 (CET) Created on: MaintCage Type: porting specific change Problem Description (Customer terms) The oracle driver generates the depricated FIRST_ROWS hint Affected Executables ora8_srv DevChopin: # 33436 (BDUX25428): Sensitivy labeling Date: Mon, 11 Dec 2006 10:38:41 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Sensitivity labels for reports, sessions and table fields wanted by Boeing Workaround NA. This is new functionality. Affected Executables bshell DevChopin: # 33428 (BDUX25370): Make taxapi less dependent on libraries provided Date: Fri, 8 Dec 2006 14:23:48 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Due to a compiler dependency the SUSE8 libraries cannot be use on SUSE9 Test Procedure clearmake libs DevChopin: # 33421 (BDNT25464): Wrong QP layer used by tmboa object Date: Fri, 8 Dec 2006 09:51:46 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) After upgrade porting set to 8.2b, customer is finding this error while transfering data form scheduler to ERP 5c through ITK. Error on line 1: "SQLState 42I12: Combined reference operand must contain only constants or only columns (error 302)" That means the Baan DB driver doesn't understand something in this query. It works with 7.1d portingsets. Workaround n/a Affected Executables bshell6.2 Motive source SDIS:TECH-00000-01566 DevChopin: # 33382 (BDNT25450): Characters in password dialog shown as bars Date: Tue, 5 Dec 2006 08:07:01 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) On some systems the characters in a password dialog in BECS or BW appear as vertical bars instead of a large dot character. Test Procedure See problem description. Affected Executables bw.exe bwc.dll becs.exe DevChopin: # 33380 (BDNT25449): Expand environment variables in application start Date: Mon, 4 Dec 2006 14:37:02 +0100 (CET) Created on: MaintSchoenberg Type: bugfix Problem Description (Customer terms) When in a program script an client side environment variable is used (for instance ${windir}) with one of the client access functions (for instance start.application.local()), this client side environment variable is not expanded anymore. This worked fine with older version of BW (7.6a.02.4) however with newer version (7.6b.10 and onwards) this does not work anymore. Test Procedure See problem description. In addition the test program: "tewhrodm" on system nlbautd4 can be used. See also SDIS request: TECH-00000-01770 Affected Executables bw.exe Motive source SDIS:TECH-00000-01770 DevChopin: # 33371 (BDUX25337): Password aging on Solaris 10 does not work Date: Mon, 4 Dec 2006 10:03:40 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) 1. When password aging is invoked on Solaris 10 the user is not able to change the password with session ttstppwdaging. The badmin binary returns an unknown error. 2. The password change dialog is always popping up when password aging is invoked. Workaround Remove the line with the pam_dial_auth_so.1 module from the /etc/pam.conf file. Test Procedure Invoke password aging. Start the Baan application using a user with password aging. In it's warn period the session ttstppwdaging should popup for password change. Outside the warn period the password change dialog should not popup. When the password is changed a message should be displayed confirming the password change. Affected Executables badmin6.x Motive source SDIS:TECH-00000-01694 DevChopin: # 33365 (BDUX25437): Setuid binaries cannot find shared libraries with relative path Date: Mon, 4 Dec 2006 10:01:38 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) When a binary with the setuid bit set (-rwsr-xr-x) is started from it's own direcrtory the shared libraries cannot be found. Workaround Use an absolute path when running the binary. Test Procedure Go to the $BSE/bin directory and run badmin6.2 -v. version information should be displayed, not an error loading a shared library. Affected Executables badmin6.x Motive source SDIS:TECH-00000-01718 DevChopin: # 33328 (BDUX25339): Allow absolute paths pass secu mechanism Date: Tue, 28 Nov 2006 10:07:15 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) 1. custom path in exchange do not work 2. OPD doesn't work Workaround Nome Affected Executables bshell6.2 Motive source TECH-00000-01698 DevChopin: # 33265 (BDUX25331): Better algoritm for shared memory mapping Date: Fri, 17 Nov 2006 16:50:47 +0100 (CET) Created on: MaintBaanIVc Type: porting specific change Problem Description (Customer terms) SHM attach on DEC may fail during installation. Workaround provide a shm_start value in $BSE/lib/shm_config file which has an address high enough to be used by all binaries. The attach address is system dependent. See log file of shm manager for suggestions. Test Procedure Run installation. DevChopin: # 33242 (BDNT25324): add or change registry vars Date: Fri, 17 Nov 2006 09:39:47 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Can't add or change environment variabeles in baanman. Workaround regedit HKLM\SOFTWARE\Baan\\Environment Test Procedure start baanman rightclick envname select properties add or change environment variabeles DevChopin: # 33238 (BDNT25317): ftp needs messageloop function for preventing white screens Date: Thu, 16 Nov 2006 17:07:18 +0100 (CET) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Customer gets white screen from installshield if a large file is transferred. DevChopin: # 33213 (BDNT25052): baanman can not attach to shared memory Date: Tue, 14 Nov 2006 16:31:41 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Windows only. In SSA Manager no info about shared memory is shown in next scenario:. Start SSA Manager Show properties of BaanSharedMemory service Show "Loaded Shared Memory" and/or "Shared Memory Area" Workaround Adjust start address of shared memory to 0x30000000 iso 0x20000000. Test Procedure See Problem Description Affected Executables baanman shmserv DevChopin: # 33199 (BDNT25269): Graphics Server problem in BW Date: Tue, 14 Nov 2006 12:26:17 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Sessions like cprmp2701m000, cprmp3701m000 and cprrp0731m000 create charts and are using files from the graphics server (3rd party software). However, regularly cases have been logged, in the past and still now, that an error message is given related to the Graphics Server, usually like: "Failed to open Graphics Server" and/or "Create window failed for widget "DsCgraph" of widget class "TsGraphWidgetClassRec"" Workaround Make sure c:\winnt\baan\bin is in the PATH environment variable. Test Procedure See problem description. Start the mentioned session with a PATH variable withoud the c:\winnt\baan\bin directorry. Start the session from Worktop. Affected Executables bw.exe Motive source SDIS:ERP-00000-12499 DevChopin: # 33196 (BDUX25287): Update cogdmod.ini files to reflect new SQL/ODBC functionality Date: Tue, 14 Nov 2006 11:43:57 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) The cogdmod.ini files need to be updated to reflect the new functionality offered by the SQL processor using the ODBC solution. Affected Executables None DevChopin: # 33190 (BDUX25277): Fix problem in bclm.getproductidfromobject Date: Mon, 13 Nov 2006 16:49:28 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) both bclm.getproductidfromobject and bic_info cannot handle full pathnames to determine product id based on secu files Test Procedure bic_info6.2 -S ottaad2500 and bic_info6.2 -S `explode6.2 ottaad2500` should return the same product id. Affected Executables bshell6.2 bic_info6.2 DevChopin: # 33183 (BDNT25270): some function calls must be byref for the path variable Date: Mon, 13 Nov 2006 11:30:34 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) log files sometimes contain forward and backward slashes in the path Affected Executables setup.exe DevChopin: # 33182 (BDUX25088): Errno 32 (Broken pipe) bdb_errno 0 Date: Mon, 13 Nov 2006 11:29:59 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Error when session has no authority for table Workaround N/A Test Procedure Tested the database server with 3GL script function main() { select whinh310.rcno from whinh310, tccom100, tcmcs003 where whinh310._index1 = {:whinh312.rcno} and whinh310.cwar refers to tcmcs003 path whwmd200.cwar as set with 1 rows selectdo endselect } Motive source SDIS:TECH-00000-01536 DevChopin: # 33138 (BDNT25223): Login with rexec protocol failed Date: Wed, 8 Nov 2006 15:45:45 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Repaired badfix: Rexec protocol did not work anymore after a previous fix for SSPI. Test Procedure Try logon to baan using rexec protocol. DevChopin: # 33112 (BDUX25199): SQL: Better native support for Informix IDS Date: Mon, 6 Nov 2006 16:31:09 +0100 (CET) Created on: DevChopin Type: bugfix Problem Description (Customer terms) The SQL processor does not fully exploit the functionality offered by the underlying database. Especially when it is used for the Cognos/ODBC solution, then performance is far from optimal, if one of the following constructions is used: - general expressions in the SELECT clause - derived tables (a.k.a. "inline views" or "subselects") - full support of left and right outer joins - simple or searched case function (in a filter) - trim function (in a filter) - cast specification - coalesce - extract Performance would improve dramatically when the capabilities of the underlying database were used to support these constructions. This is what is implemented in this project. Note: optimizations already applied when using the Cognos/ODBC solution and when the underlying database is Oracle, Microsoft SQL server, DB2 UDB or MySQL. Now these optimisation also apply for Informix IDS (with the ODBC solution). Test Procedure Execute a query with any of the constructions mentioned above. Either use the Cognos/ODBC solution or add the -p16 flag to bsql6.2. Set DBSLOG=01570 and observe that the construction is pushed to the database. For example, executing the following query: bsql6.2 -p16 -q "select salary + bonus from ( select * from dbtst120 ) dt" results in the following query on Oracle: SELECT (t0.t$salary+t0.t$bonus) FROM b61a.tdbtst120000 t0 (Note that the optimizer of the SQL processor eliminated the redundant derived table.) Note that certain constructions simply cannot be pushed to the database, because the database does not support them. For instance, MSQL does not support the TRIM function with any character other than a space. Affected Executables bsql jbdb inf_srv6.2 DevChopin: # 33111 (BDNT24746): Could not login on w2k3 server with SSPI authentication Date: Mon, 6 Nov 2006 15:37:37 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) SSPI logon did not work anymore from remote system since 8.3a Test Procedure Try to logon to baan from remote system to baan server, using SSPI protocol (see BW configuration). Affected Executables all client binaries using SSPI protocol, mainly BW. DevChopin: # 33089 (BDNT25116): reconfigured parameters not used by Informix database Date: Fri, 3 Nov 2006 13:35:06 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Baan installation takes very long (days) on Windows systems when installation wizard is used. Workaround - manual database instance setup - install application Test Procedure do Baan installation in one step (portingset and application) Affected Executables inf_adm DevChopin: # 33045 (BDUX24986): SQL: Informix, MSQL and MySQL sort NULLs before any other data (wrong result for UNION with ORDER BY) Date: Tue, 31 Oct 2006 10:45:21 +0100 (CET) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Informix, Microsoft and MySQL sort NULL values before any other data. If a query contains a UNION and an ORDER BY that sorts NULL values as well as 'normal' data, then the result of the query could be incorrect. Test Procedure With a debugable database driver, set the environment variable BAAN_SQL_NO_UNION_OPTIM=1 and execute the following query: select a.empno, b.firstnme as str from dbtst190 a left join dbtst120 b on a.empno = b.empno where a.empno in ( 10, 100, 100000 ) union select a.empno, b.projno as str from dbtst190 a left join dbtst180 b on a.empno = b.empno where a.empno in ( 50, 100, 100000 ) order by str, empno (Note that some rows in dbtst190 have no match in dbtst120 and dbtst180, so NULLs are generated) Observe that no duplicate rows are returned. Affected Executables bshell bsql all database drivers DevChopin: # 33000 (BDNT25077): Not able to user BwPrint as user Administrator Date: Thu, 26 Oct 2006 10:51:58 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) BwPrint cannot be started as user Administrator due to an extra check on long usernames. When the username is longer than 8 characters an application event is logged and the application will not start. Workaround Use a username with a maximum of 8 characters Test Procedure Right click on bwprint.exe. Choose 'Run as...'. Choose for user Administrator and enter the correct password. When BwPrint does not start look in the eventviewer and check the events for bwprint. Affected Executables BwPrint.exe Motive source SDIS:TECH-00000-01583 DevChopin: # 32989 (BDUX25090): utc.add error when DST border is crossed Date: Wed, 25 Oct 2006 13:52:14 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Hours can not be registered in bptmm1120m000. Test Procedure function main () { long ret_val long today today = date.to.utc(2006, 10, 23, 8, 0, 0) ret_val = utc.add( today, 0, 0, 7, 0, 0, 0, today) } Affected Executables bshell Motive source TCS:800-155185 DevChopin: # 32948 (BDNT25049): Baanman not running with Administrator account Date: Mon, 23 Oct 2006 11:50:11 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Because of a new check on username (max length 8 characters) baanman does not run anymore when user is 'Administrator'. Workaround Run as Baan user, not as administrator Test Procedure Start baanman.msc, which uses baanman.dll. Use 'Run as....' to choose user 'Administrator'. The SSE ES Service Manager should start. Affected Executables baanman.dll Motive source SDIS:TECH-00000-01517 DevChopin: # 32944 (BDUX25047): JVMI: missing dir in LD_LIBRARY_PATH Date: Mon, 23 Oct 2006 09:48:38 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) bshell hangs when JRE 1.3 is used on DEC/OSF Workaround add to $BSE/lib/bse_vars: LD_LIBRARY_PATH=/lib/alpha:/lib/alpha/classic:/lib/alpha/native_threads where is the directory of the installed JRE most times this is /usr/opt/java131 Test Procedure OW on DEC/OSF with JRE 1.3 Affected Executables bshell bjvmi.jar DevChopin: # 32817 (BDUX24911): new zoneinfo files Date: Fri, 13 Oct 2006 16:17:23 +0200 (CEST) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) The DST switch had been moved from 15 okt to 5 nov in Brazil Workaround change the files manualli or download the files. Then compile with the zic compiler (Fill this in) Test Procedure install portingset, check if new files are there, new rule for brazil for 2006 and 2007 Affected Executables zonerule files, Motive source SDIS:tech-00000-01519 DevChopin: # 32708 (BDUX24826): merge 24742 Date: Fri, 6 Oct 2006 16:29:58 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Added the UPPER and LOWER functions to the query language. Test Procedure sample query: select upper('abc') from dbtst120 where empno=10 this should return ABC DevChopin: # 32674 (BDUX24806): Add locale and strings in UTF-8 in bdbpre and bdbpost Date: Thu, 5 Oct 2006 16:24:01 +0200 (CEST) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Currently the values of the high ascii plane without the context of a locale in a bdbpre dump is undetermined. Therefore a new format is needed to make the pre dump locale independent by using utf-8. Affected Executables bdbpre6.2 bdbpost6.2 DevChopin: # 32666 (BDUX24673): Files with .dbg extension cause problems with report objects Date: Thu, 5 Oct 2006 14:44:17 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) When compiling report objects with 4GL Studio, the debug report objects end up in a strange place. Affected Executables bic6.2 bic_pre6.2 explode6.2 bic_info6.2 bshell6.2 DevChopin: # 32654 (BDNT24781): Drag and drop in edit box not correct Date: Thu, 5 Oct 2006 07:36:32 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Open a single-occ session. Select text in an edit field. Drag the selected text using the mouse to another edit field in a single-occ session. Now the dragged text is visually removed from the first edit field. However this change in the first field is not saved. Workaround Use copy/paste using the keyboard. Test Procedure See problem description. Affected Executables bw.exe Motive source SDIS:TECH-00000-01449 DevChopin: # 32632 (BDUX24674): Audit trail sometimes incomplete Date: Wed, 4 Oct 2006 10:08:04 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Audit trail sometimes incomplete when mixing delayed inserts with actions that explicitly request an error condition. Test Procedure .../tests/bshell_integration/audit/004 Affected Executables bshell Motive source TCS:800-154786 DevChopin: # 32617 (BDNT24763): Suppress harmless compiler warnings Date: Tue, 3 Oct 2006 16:59:12 +0200 (CEST) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Suppress compiler warnings Workaround NA Test Procedure Check build warnings Affected Executables Several DevChopin: # 32602 (BDUX24743): JVMI: core dump within debug logging Date: Tue, 3 Oct 2006 12:00:29 +0200 (CEST) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) bshell crashes on Solaris when JVMI logging is enabled with -dbgjvmi Test Procedure start tmboaserver 2.7 on Solaris with enabled logging Affected Executables bshell libjvm2bvm DevChopin: # 32583 (BDNT24728): SQL Support UNION Date: Fri, 29 Sep 2006 16:29:29 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Our SQL language did not support UNION; only UNION ALL. Workaround ? Test Procedure Run the test scripts in: \db\lib\sql\Test\tests\ansi92\union_distinct Affected Executables QP DevChopin: # 32576 (BDUX24729): SQL: disable new keywords (COALESCE, CHAR, INT, ...) in non-ANSI mode Date: Fri, 29 Sep 2006 12:17:58 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) The addition of new key words may give unwanted side effects for existing installations that perform a porting set upgrade. The following key words are now only available in ANSI mode (e.g. through the ODBC solution): - char - character - coalesce - day - extract - hour - int - integer - interval - minute - month - second - substring - varchar - varcharacter - year Consequently, certain SQL features are now available in ANSI mode only: - coalesce - extract - cast as char/character/int/varchar/varcharacter - substring - interval literals Workaround Use a different name for an alias that is now a keyword, or qualify the column name. For example: select int from dbtst107 may be rewritten as: select dbtst107.int from dbtst107 And select hiredate - birthdate as interval from dbtst120 may be rewritten as: select hiredate - birthdate as an_interval Test Procedure Execute the following command: bsql6.2 -c0 -q"select clan as int from ttaad110" This should work fine. Execute the following command: bsql6.2 -p16 -c0 -q"select clan as int from ttaad110" This should give the error: SqlState=42I00, 'Unexpected token 'int'', NativeError=302, Line=1 (The option -p16 switched the SQL parser to ANSI mode) In the same fashion, try some or all of the keywords listed above. Affected Executables bshell bsql DevChopin: # 32574 (BDUX24709): Problem in sort with unicode Date: Fri, 29 Sep 2006 12:16:21 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Sorting of a BOM doesn't work Test Procedure cat <s1.u 10|1|1 |1 10|1|.2 |2 10|1|.2 |3 10|1|1 |4 10|1|1 |5 EOF sort6.2 -t'|' +0 -1 +1n -2 +3n -4 s1.u -o s1.snu should not change the file. Affected Executables sort6.2 Motive source SDIS:ERP-00000-10112 DevChopin: # 32545 (BDUX24711): SQL: implement extract Date: Thu, 28 Sep 2006 17:05:13 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) Added the EXTRACT function to the SQL language. Syntax: EXTRACT( FROM ) datetimeField can be: YEAR, MONTH, DAY, HOUR, MINUTE or SECOND datetime expression can be a TIMESTAMP or a DATE The result is an INTEGER. Test Procedure bsql -p 16 -q "select extract(year from current_timestamp) from dual" Affected Executables jbdb, all db drivers DevChopin: # 32522 (FRUX24668): iSeries: vertex api Date: Thu, 28 Sep 2006 08:40:29 +0200 (CEST) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) Error in session tccom4530m000 When Jurisdiction is executed. Workaround the workaround solves part of the problem: add the VERTEX library to the user part of the system liblist Test Procedure see problem description Affected Executables api6.2 DevChopin: # 32491 (BDUX24649): Blocking audit_srv when shared memory is full Date: Tue, 26 Sep 2006 16:09:02 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Audit_srv blocking when shared memory is full. Affected Executables audit_srv DevChopin: # 32483 (BDUX24618): SQL: Better native support for Db2 and MySQL Date: Tue, 26 Sep 2006 14:15:49 +0200 (CEST) Created on: DevChopin Type: bugfix Problem Description (Customer terms) The SQL processor does not fully exploit the functionality offered by the underlying database. Especially when it is used for the Cognos/ODBC solution, then performance is far from optimal, if one of the following constructions is used: - general expressions in the SELECT clause - derived tables (a.k.a. "inline views" or "subselects") - full support of left and right outer joins - simple or searched case function (in a filter) - trim function (in a filter) - cast specification - coalesce Performance would improve dramatically when the capabilities of the underlying database were used to support these constructions. This is what is implemented in this project. Note: optimizations already applied when using the Cognos/ODBC solution and when the underlying database is Oracle, Microsoft SQL server. Now these optimisations also apply for DB2 UDB and for MySQL (with the ODBC solution). Test Procedure Execute a query with any of the constructions mentioned above. Either use the Cognos/ODBC solution or add the -p16 flag to bsql6.2. Set DBSLOG=01570 and observe that the construction is pushed to the database. For example, executing the following query: bsql6.2 -p16 -q "select salary + bonus from ( select * from dbtst120 ) dt" results in the following query on Oracle: SELECT (t0.t$salary+t0.t$bonus) FROM b61a.tdbtst120000 t0 (Note that the optimizer of the SQL processor eliminated the redundant derived table.) Note that certain constructions simply cannot be pushed to the database, because the database does not support them. For instance, MSQL does not support the TRIM function with any character other than a space. Affected Executables bsql jbdb db2v5_srv6.2 mysql_srv6.2 DevChopin: # 32479 (BDUX24634): SHM improved logging Date: Tue, 26 Sep 2006 10:31:42 +0200 (CEST) Created on: MaintCage Type: porting specific change Problem Description (Customer terms) Better error message if no SHM available. DevChopin: # 32468 (BDUX24207): Blogind keeps file descriptors open after startup Date: Mon, 25 Sep 2006 16:48:46 +0200 (CEST) Created on: DevCage Type: bugfix Problem Description (Customer terms) Blogin (and ASM) daemon on Unix does not close file descriptors stdin/out/err. This may cause problems to close the shell which started blogind. Problem was found on Linux. Test Procedure on Linux: - start a shell (as user root) - be sure that env. var USER is not set (unset USER) - as root: start blogind6.x - as root: run lsof | grep blogind -> check that file descriptors 0, 1, 2 have been mapped to /dev/null instead of stdin/err/out Affected Executables blogind/asm_srv Motive source SDIS:TECH-00000-00949 DevChopin: # 32463 (BDUX24623): QP: Error 201 on float values that are not according to diga Date: Mon, 25 Sep 2006 16:00:29 +0200 (CEST) Created on: MaintSchoenberg Type: bugfix Problem Description (Customer terms) When using the 8.2b porting set on Corelli applications, error 201 is given. The problem occurs due to FLOAT values in the database that are not according to the domain definition (in particular the "diga" constraint: the number of digits after the decimal point) Test Procedure A script like the following can be used to reproduce the problem: table tdbtst120 function set.up() { select * from dbtst120 for update where empno = 10 selectdo endselect dbtst120.bonus=46.316399 db.update(tdbtst120,db.retry) commit.transaction() } function tear.down() { select * from dbtst120 for update where empno = 10 selectdo endselect dbtst120.bonus=1000 db.update(tdbtst120,db.retry) commit.transaction() } function main() { set.up() select * from dbtst120 for update where empno = 10 selectdo endselect dbtst120.salary=100000 db.update(tdbtst120,db.retry) db.flush() tear.down() } Affected Executables bshell DevChopin: # 32447 (BDUX24607): suppress No Table error message in refint Date: Mon, 25 Sep 2006 11:04:00 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) I do get the following errors in log.aad4225 after reorganizing the tables. After installing ERPln with DB2 and portingset 7.6b.01 I find the following errors like. ttadv176050 R [0] SQLState QP999: Table does not exist (error 506) Workaround Ignore messages. Test Procedure reorganize tables Affected Executables refint Motive source TCS:800-149108 TCS:800-149271 TCS:800-152263 DevChopin: # 32436 (BDUX24591): AIX use default type for enum Date: Mon, 25 Sep 2006 08:36:57 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Unknown Server Mode was reported during ERP LN 6.1 installation on AIX. Workaround n/a Test Procedure install portingset on AIX. Affected Executables inf_adm6.x DevChopin: # 32411 (BDNT24585): MSQL Unicode: performance problem on type mismatch Date: Thu, 21 Sep 2006 16:34:53 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Unicode MSQL only: Performance problems SQLserver is using 100% cpu while the bshell/msq7_srv is doing almost nothing Test Procedure full install Affected Executables msql7_srv DevChopin: # 32409 (BDNT24583): SHM manager fails to start if username is 8 characters Date: Thu, 21 Sep 2006 16:24:31 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) SHM service on windows did not start if username length is exactly 8 characters. Username field of SHM properties becomes empty, if username of 8 characters is filled in. Workaround use shorter username as baan user under which SHM service runs on windows. Test Procedure 1. modify shm properties (via baan management snapin): fill in a user name of 8 characters 2. try to start SHM (assuming filled in user is a valid baan user). Affected Executables shmserv.exe/shmcfg.dll DevChopin: # 32397 (BDNT24487): SQL SUM() on intervals Date: Wed, 20 Sep 2006 15:57:58 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) The SQL processor did not support SUM(). E.g.: select sum(endtime-startime) from dbtst206 From now on this construct can be used in SQL. Test Procedure Execute a query like this one: select sum(endtime-startime) from dbtst206 Affected Executables QP DevChopin: # 32318 (BDUX24480): Unicode: PLEN not valid after function call Date: Fri, 15 Sep 2006 12:25:59 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Unicode: error 205 (generated by the database driver) on INSERT or UPDATE because strings are passed to the database driver that are longer than the defined column length. The problem popped up on the assignment of a longer MB domain to a shorter one in combination with return values of 3GL function calls. Test Procedure See demo source above. Without the fix, the ASSERTs on line 19 and line 21 fail. Affected Executables bshell Motive source SDIS:ERP-00000-10235 Inq:411840 DevChopin: # 32310 (BDUX24464): SQL NQP cast function Date: Fri, 15 Sep 2006 11:12:35 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) The SQL language lacks proper support for the CAST specification. At a minimum support for the following combinations should be supported: CAST( AS CHARACTER( ) ) CAST( AS VARCHARACTER( ) ) CAST( AS INTEGER ) CAST( AS TIMESTAMP ) CAST( AS DATE ) As a shorthand the type "CHAR", "VARCHAR" and "INT" can be used as well. Test Procedure For example, try the following SQL statement: select cast( 3 as char(2) ) || 'biggetjes' from dbtst120 where empno = 10 This results in 3 biggetjes Affected Executables bshell bsql all database drivers jbdb library DevChopin: # 32282 (BDUX24450): Core dump in database drivers when started by bdbpost in an almost full shm context Date: Wed, 13 Sep 2006 13:37:46 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Database drivers crash when the shared memory is full. The SIGSEGV occurs in the function creat_hash_tbl() on a NULL pointer dereference. Affected Executables all database drivers Motive source TCS:800-154556 DevChopin: # 32270 (BDNT24437): Too strict checks when no real BSE is available. ERP installer stopped unexpected Date: Tue, 12 Sep 2006 16:00:36 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) Too strict length check (of 8 characters) on user names, causing the ERP installer to stop DevChopin: # 32261 (BDUX24432): SQL: searched CASE and COALESCE Date: Tue, 12 Sep 2006 11:45:00 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) The ERP LN SQL language lacks support for both the SEARCHED CASE and the COALESCE expression. Workaround -- Test Procedure Try, for example the following commands: bsql6.2 -q "select case when salary > 25000 then 'Fairly high' when salary > 15000 then 'Moderate' else 'Well...' end from dbtst120" Or, bsql6.2 -q "select coalesce( b.empno, a.empno ) from dbtst190 a left join dbtst120 b on a.empno = b.empno" Affected Executables bshell bsql jbdb library (ODBC) DevChopin: # 32249 (BDNT24389): Test for valid C-runtime DLLs during local installation Date: Mon, 11 Sep 2006 11:07:19 +0200 (CEST) Created on: DevChopin Type: enhancement Problem Description (Customer terms) Detect missing Visual Studio 2005 runtime libraries for Visual C++ Workaround Install Visual C++ runtime lirbaries before running SLM installation Test Procedure Install SLM 2.6 on a machine where Visual C++ runtime lirbaries are missing Affected Executables SLM installer DevChopin: # 32229 (BDNT24386): MSQL Unicode: right truncation errors Date: Fri, 8 Sep 2006 14:26:42 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) MSQL Unicode mode only: Right truncation errors in the application event log Test Procedure full FP3 install Affected Executables msql_srv DevChopin: # 32184 (BDUX24375): Added message queue termination in api.c Date: Thu, 7 Sep 2006 09:48:14 +0200 (CEST) Created on: MaintCorelli Type: bugfix Problem Description (Customer terms) A few months ago we were having api issues of the processes hanging on our servers. A reboot of each application server was needed in order to clean up these api hung processes. We received a new version of api (7.1d.13) in order to fix this issue. Since the new version went into production, we have not had to reboot the application servers. Workaround Reboot Affected Executables Tax libraries Motive source SDIS:TECH-00000-01332 DevChopin: # 32178 (BDNT24360): Unicode: MSQL error 205 during reconfiguration Date: Wed, 6 Sep 2006 16:24:57 +0200 (CEST) Created on: MaintCage Type: bugfix Problem Description (Customer terms) MSQL Unicode only: error 205 during upgrade to ERP LN FP3 Test Procedure FP3 upgrade Affected Executables msql7_srv Motive source TCS:800-154665 DevChopin: # 32163 (BDNT24234): Default changed in msql_driver_param file Date: Tue, 5 Sep 2006 11:31:35 +0200 (CEST) Created on: DevCage Type: bugfix Problem Description (Customer terms) The installation wizard consumed a lot of times. Database is in LEVEL 2 mode but I see in $BSE/lib/msql/msql_driver_param that query optimization is 011. Workaround n/a Test Procedure install ERP LN. Affected Executables msql7_adm.exe Motive source SDIS:TECH-00000-01296