List of changes for portingset: 6.1c.08 DevSweelinck: # 42338 (BDUX34099): SQL processor fails to optimize statemtent in combo mode (ABB) Date: Fri, 13 Feb 2009 15:26:52 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The following SQL statement is split into several database SQL statements: select tcibd001.cuni:cuni, tcibd200.opol:bom.opol, tiipd001.oltm:oltm, tiipd001.oltu:oltu, tiipd001.unom:child.unom, cprpd100.plni:bom.child, cprpd100.mrph:phase, cprpd100.clus:clus, cprpd100.cwar:ord.cwar, cprpd100.osys:mpsp, cprpd120.code:itm.code from tcibd001, tcibd200, tiipd001, cprpd100, cprpd120 where tcibd001._index1 = {:3} and tcibd200.item refers to tcibd001 unref skip and tiipd001.item refers to tcibd001 unref clear and cprpd100._index9 = {:3} and cprpd100.plni = cprpd120.plni The execution time of this SQL statement is dramatic. The problem is found at customer ABB, who is using AIX53, 8.4c.02. And disappears when using a stand-alone driver, or when enabling tracing. Test Procedure Since this problem is so hard to reproduce, this solution is tested at the customer site. Affected Executables bshell all database drivers DevSweelinck: # 42334 (BDUX34085): Compile errors with SLM Adaption Date: Thu, 12 Feb 2009 17:13:02 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) errors with sli tests Test Procedure clearmake portingset should be without errors DevSweelinck: # 42291 (BDUX33856): LNCPE-176 Baan IVc SLM adoption Date: Mon, 9 Feb 2009 14:59:22 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) SLM enabling for Baan IVc Affected Executables bshell6.1 bic_info6.2 and many others... Motive source ScrumStory:LNCPE-176 DevSweelinck: # 42090 (BDUX33890): Empty export with blob results in wrong header Date: Tue, 20 Jan 2009 13:47:47 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) A multiple table dump with BLOBs fails to import Test Procedure chk tests/blob/dbtools/blob08 Affected Executables bdbpre6.1 DevSweelinck: # 42089 (BDUX33887): LNCPE-145 make exec_function etc. case insensitive Date: Tue, 20 Jan 2009 13:47:36 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) exec_dll_function, get_function, parse_and_exec_dll_function only work with lowercase function names. This should be made case insensitive. Workaround Use tolower$() in 3GL. Test Procedure Run chk tests_bshell/exec_fun/ Affected Executables bshell6.1 Motive source ScrumStory:LNCPE-145 DevSweelinck: # 42069 (BDUX33852): LNCPE-186: Solve JVMI-2 hang on Windows Date: Fri, 16 Jan 2009 19:07:47 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) On Windows starting the tmboaserver with JVMI-2 fails. When a second tm= boaserver=20 is started with the same bshell both the first and second tmboaserver s= tart and=20 both work as expected. Workaround Set the resource "jvmi_arch:1", which means that the JavaVM is started = as a=20 shared library (dll), and not as a seperate process. Test Procedure Start the tmboaserver. Affected Executables bshell bjvmi.jar Motive source ScrumStory:LNCPE-186 DevSweelinck: # 42060 (BDNT33663): BwPrint: errors when run as server printer Date: Fri, 16 Jan 2009 16:50:54 +0100 (CET) Created on: MaintStrauss Type: bugfix Problem Description (Customer terms) Windows Server Printing on some HP printer drivers sometimes causes "StartDoc failed" events in Event Viewer. Test Procedure Use Windows Server Printer. Use HP P3005 PS or HP Universal Printing PS driver Connect to the bshell as a domain user. Take care that that same domain user is NOT logged in interactively on the windows machine where the bshell is running. You may connect with Remote Desktop, but then DO NOT USE that same domain user. You may connect to the (shared) printer to see its queue. You may use your local event viewer to see whether events are logged on the remote machine. You may use a normal print session, or you may use a simple 3GL script like this: function main() { run.prog( "C:\Infor\FatClients\BaanIV\bse\bin\bwprint.exe", "/s /p c:\shared\sdis\tech4619\fonttest0.bpf", RP_WAIT ) } First use an old bwprint to see whether you can reproduce the "StartDoc failed" events. Then use the new bwprint and see that no "StartDoc failed" event is generated. Affected Executables bwprint.exe Motive source SDIS:TECH-00000-04619 DevSweelinck: # 41977 (BDUX33796): extra test for compnr mapping + fix Date: Thu, 8 Jan 2009 10:48:34 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Project BDUX33126 introduced some wrong error messages on correct compnr6.1 files. Please note that only a message is written in the logfile, but that the actual functionallity is not affected. Affected Executables bshell DevSweelinck: # 41905 (BDUX33762): TECH-00000-04650: LNCPE-206: ODBC/JDBC: jbdb reads too many DD files Date: Tue, 30 Dec 2008 16:17:16 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The ODBC/JDBC solution is too slow when the network latency is high. Test Procedure Using the ODBC/JDBC solution prepare/execute a simple statement, for example on table tcmcs023 beacause this table has a lot of related tables. Use a high latency network (a wireless VPN connection is sufficient). Observe that with this solution the waiting time is considerably reduced. Affected Executables jbdb Motive source SDIS:TECH-00000-04650 DevSweelinck: # 41851 (BDUX33713): TECH-00000-04250: SQL processor: Starting multiple parallel drivers with clean shared memory fails Date: Mon, 22 Dec 2008 15:26:21 +0100 (CET) Created on: DevBeethoven Type: bugfix Problem Description (Customer terms) Starting multiple parallel bshells with clean shared memory fails. The SQL processor in the bshell aborts with the following log message: SQLNetAgentClient::Fetch: Expected return packet The problem reproduces with an MRP run and on HPIA64, although the problem is not related to the hardware. Workaround One work-around is to set the resource use_shm_info:0. This prevents the database driver from using DDs stored in shared memory. Another work-around is to guarantee that all DDs are storted in shared memory. This can be done by first running the session with a single bshell. Test Procedure A better reproduction scenario than the following is not kwown: - in session "Performance Boosters" (tcmcs0197s000, started from tcmcs0597m000) set the number of parallel bshells to 2; - restart the environment (rc.stop followed by rc.start); - start an MRP run (cprrp1210m000); - note that 2 (extra) bshells are started. These should remain running. Affected Executables All database drivers Motive source SDIS:TECH-00000-04250 DevSweelinck: # 41841 (BDUX33723): TECH-00000-04561: company_nr join predicate is not allowed in a FULL OUTER JOIN Date: Mon, 22 Dec 2008 09:59:52 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The SQL processor forbids to have a company_nr predicate in the ON clause of a FULL OUTER JOIN. This restriction makes no sense, it should just act as a filter on the company_nr column. Here follows an example of an SQL statement that contains a company_nr predicate in the ON clause of a FULL OUTER JOIN: -- Powered by General SQL Parser (www.sqlparser.com) SELECT emps.company_nr, emps.workdept, emps.lastname, emps.max_salary, depts.company_nr, depts.deptname FROM (SELECT emps_salary.company_nr, workdept, lastname, "max_salary" FROM (SELECT company_nr, workdept, MAX(salary) AS "max_salary" FROM dbtst120 WHERE company_nr IN (0,1) AND salary > 30000 GROUP BY company_nr,workdept) emps_max_salary INNER JOIN (SELECT company_nr, salary, lastname FROM dbtst120) emps_salary ON emps_max_salary."max_salary" = emps_salary.salary AND emps_salary.company_nr = emps_max_salary.company_nr) emps FULL JOIN (SELECT company_nr, deptno, deptname FROM dbtst100 WHERE company_nr IN (0,1)) depts ON emps.workdept = depts.deptno AND emps.company_nr = depts.company_nr Test Procedure Write an SQL statement that contains a company_nr predicate in the ON clause of a FULL OUTER JOIN. It should execute nicely. Affected Executables bshell bsql jbdb Motive source SDIS:TECH-00000-04561 DevSweelinck: # 41826 (BDUX33705): TECH-00000-04677: Failure to start remote database driver when remote tabledef contains multiple entries Date: Thu, 18 Dec 2008 16:34:35 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) If the tabledef file is read from a remote BSE and it contains multiple entries, the remote database driver may fail to start. The log/event viewer reveals that an attempt is made to start a local database driver. This problem is most likely to occur with the ODBC/JDBC connectivity, because then the tabledef file is always read from a remote BSE and never from the local BSE. Workaround Copy the remote tabledef to the local BSE and prefix every driver name with the hostname of the remote BSE. For example: local BSE on host nlbawcpm1 remote BSE on host nlbaumn4 --------------------------- --------------------------- bse/lib/tabledef bse/lib/tabledef tccom000:*:nlbaumn4!oracle8 tccom000:*:oracle8 tiitm001:*:nlbaumn4!oracle8 tiitm001:*:oracle8 Note: for the ODBC/JDBC connectivity this will *not* help, because files in the local BSE are ignored. Test Procedure See Problem Description (Technical Terms). Affected Executables All database clients (bshell, bsql, jbdb, bdbpre, ...) Motive source SDIS:TECH-00000-04677 DevSweelinck: # 41695 (BDUX33593): LNCPE-188: ODBC/JDBC: Support long user names Date: Mon, 8 Dec 2008 19:51:19 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The ODBC/JDBC solution does not support long user names. It should be possible to have the $BSE/lib/user/c/c file on the LN server, and let ODBC/JDBC use that file to find out the (short) application user name. Normally, with the bshell, the c file _must_ reside on the client side and _not_ on a remote BSE, because the (short) application user name must be known before we can connect to the remote BSE (because we must open the correct r file). With ODBC/JDBC this is not needed when the connection parameters are supplied. The parameters suffice to connect to the remote BSE. Workaround Create a $BSE/lib/user/c/c in the local (mini) BSE. Test Procedure Use the ODBC/JDBC solution to connect to a remote BSE using a long user name. Affected Executables jbdb Motive source ScrumStory:LNCPE-188 DevSweelinck: # 41652 (BDUX33544): JVMI-2: Vertex integration fails to start on Unix/Linux - empty bucket is not accepted (receive) Date: Fri, 5 Dec 2008 11:46:00 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The Vertex integration fails to start. This may be observed as follows: - Start the "Addresses" session (tccom4530m000) - Create a new address - Save the new address Workaround Set the following resource in $BSE/lib/defaults/all: jvmi_arch:1 This causes the JavaVM to be started as a shared library, and not as a separate process. Future note: on 64-bit builds this fallback is not available. Test Procedure Unset the jvmi_arch:1 resource (or set jvmi_arch:2) and observe that the Vertex integration starts successfully. Affected Executables bshell DevSweelinck: # 41646 (BDUX33549): JVMI-2: tmboaserver fails to start on Unix/Linux - empty bucket is not accepted Date: Fri, 5 Dec 2008 10:26:34 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The tmboaserver fails to start up. Test Procedure Write a small 3GL programm that contains the following statement: ret = java.put.bucket( queue.t, "", 0, "H" ) If the queue (queue.t) is properly created, the call should succeed. Affected Executables bshell DevSweelinck: # 41639 (BDUX33533): oracle: tag v\$session with ERPLN information Date: Thu, 4 Dec 2008 17:01:17 +0100 (CET) Created on: MaintBaanIVc Type: porting specific change Problem Description (Customer terms) Consultants and DBA's can not correlate the information in Oracle's v$session table to actual database driver processes and users. Affected Executables ora_srv Motive source ScrumStory:LNCPE-179 DevSweelinck: # 41455 (BDNT33383): Interface was changed by accident, affecting installer Date: Fri, 21 Nov 2008 12:16:33 +0100 (CET) Created on: DevBeethoven Type: bugfix Problem Description (Customer terms) The installer may fail to install a new BSE, due to a bug in the baanreg.dll. DevSweelinck: # 41367 (BDUX33302): TECH-00000-04547: SQL: Prepare of SQL statement with join of grouped query with renamed rcd_utc column and base table results in crash Date: Mon, 17 Nov 2008 11:03:20 +0100 (CET) Created on: MaintStrauss Type: bugfix Problem Description (Customer terms) Preparing the following SQL statement results in a crash ("Unexpected exception"): SELECT a."cwoc" AS work_center_id, a."dsca" AS work_center_nm, a."crmp" AS critical_wc_cd, CASE a."crmp" WHEN 1 THEN a."dsca" ELSE NULL END AS critical_wc_dsc, CASE a."kowc" WHEN 4 THEN 0 ELSE a."ccap" END AS prime_load_cd, Enum_description(a."ccap",'2') AS prime_load_dsc_temp, a."noop" AS wc_emp_cnt, a."nomc" AS wc_mchn_cnt, c.currency_cd AS currency_cd, c.direct_labor_rt AS direct_labor_rt, c.setup_labor_rt AS setup_labor_rt, c.machine_run_rt AS machine_run_rt, c.labor_var_ovrhd_rt AS labor_var_ovrhd_rt, c.labor_fxd_ovrhd_rt AS labor_fxd_ovrhd_rt, c.mchn_var_ovrhd_rt AS mchn_var_ovrhd_rt, c.mchn_fxd_ovrhd_rt AS mchn_fxd_ovrhd_rt, CASE a."mnwc" WHEN '' THEN CASE a."kowc" WHEN 4 THEN 0 ELSE 1 END ELSE 2 END AS wc_hier_lvl_no, CASE a."mnwc" WHEN '' THEN a."cwoc" ELSE a."mnwc" END AS wc_lvl1_id, a."cwoc" AS wc_lvl2_id, CASE a."mnwc" WHEN '' THEN a."dsca" ELSE e."dsca" END AS wc_lvl1_nm, a."dsca" AS wc_lvl2_nm, a."company_nr" AS company_cd FROM tirou001 AS a INNER JOIN ticpr000 AS b ON (a."company_nr" = b."company_nr" AND b.indt = 0) LEFT OUTER JOIN (SELECT "company_nr", "cpcc", "oprc", SUM(CASE "orty" WHEN 1 THEN "rate(1)" ELSE 0 END) AS direct_labor_rt, SUM(CASE "orty" WHEN 1 THEN "rate(1)" ELSE 0 END) AS setup_labor_rt, SUM(CASE "orty" WHEN 2 THEN "rate(1)" ELSE 0 END) AS machine_run_rt, SUM(CASE "orty" WHEN 1 THEN "rate(1)" ELSE 0 END) AS setup_labor_rt, SUM(CASE "orty" WHEN 2 THEN "rate(1)" ELSE 0 END) AS machine_run_rt, SUM(CASE "orty" WHEN 4 THEN CASE "vaco" WHEN 1 THEN "rate(1)" ELSE 0 END ELSE 0 END) AS mchn_var_ovrhd_rt, SUM(CASE "orty" WHEN 4 THEN CASE "vaco" WHEN 2 THEN "rate(1)" ELSE 0 END ELSE 0 END) AS mchn_fxd_ovrhd_rt, MAX("ccur") AS currency_cd, MAX("rcd_utc") AS rcd_utc FROM ticpr150 WHERE "company_nr" IN (90) AND "cprj" = '' GROUP BY "company_nr","cpcc","oprc") AS c ON (a."oprc" = c."oprc" AND b."sccc" = c."cpcc" AND b."kort" <> 2) LEFT OUTER JOIN tirou001 AS e ON (e."cwoc" = a."mnwc" AND e."company_nr" = a."company_nr" AND e."mnwc" = '') WHERE a.company_nr IN (90) AND ((a."rcd_utc" BETWEEN TIMESTAMP '1970-01-01 00:00:00' AND TIMESTAMP '2008-10-27 14:02:38') OR (c.rcd_utc BETWEEN TIMESTAMP '1970-01-01 00:00:00' AND TIMESTAMP '2008-10-27 14:02:38')) Test Procedure Run the SQL statement stated in the Problem Description (Customer terms). You can use bsql as follows: bsql6.2 -p464 -f It should produce a result (possibly empty). Affected Executables bshell bsql jbdb Motive source SDIS:TECH-00000-04547 DevSweelinck: # 41126 (BDUX33083): JVMI-2: java.lang.UnsatisfiedLinkError: bvmPutBucket if \$BSE/java/thin_odm.jar exists Date: Tue, 28 Oct 2008 17:54:20 +0100 (CET) Created on: DevBeethoven Type: bugfix Problem Description (Customer terms) If $BSE/java/thin_odm.jar exists, the JMVI integration fails. Workaround Supply you own classpath in $BSE/java/jvm_options where bjvmi.jar is in front of thin_odm.jar. Affected Executables bshell jvm2bvm shared library bjvmi.jar DevSweelinck: # 41108 (BDUX33075): JVMI: Integration stops unexpectedly Date: Mon, 27 Oct 2008 16:06:44 +0100 (CET) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The JVMI integration stops abruptly, if the java.execute.static.method.async function (the *asynchronous* variant) is used to start the listener and immediately thereafter a number of buckets is put in the queue. Workaround Use the java.execute.static.method.sync() function (the *synchronous* variant) to start the listener on the Java side. Test Procedure See Problem Description (Customer Terms), or see regression test /vobs/db/lib/sql/Test/tests_bshell/jvmi/async_listener_start.test. Affected Executables bshell DevSweelinck: # 40989 (BDUX32961): LNCPE-152: Implement JVMI-2 (JVM as a separate process per bshell) Date: Wed, 15 Oct 2008 10:07:49 +0200 (CEST) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) Historically the JVMI solution is perceived as hard to configure and error prone. Also, supporting different operating systems and new Java VM versions is development intensive. Test Procedure Write 3GL programs that use the java (jvmi) interface (java.new.queue(), java.execute.static.method.sync(), java.put.bucket(), java.get.bucket(), ...). Observe that a seperate process is started, called "java". The resource "jvmi_arch" can be used to switch back to the old behavior, but this is only supported with 32-bit builds. The resource has can have the following values: 1 - old architecture (the Java VM is started in the bshell process) 2 - new architecture (the Java VM is started as a seperate process) (default) Inside the bshell a listener thread is started. The stack size of this thread is 64K bytes by default. You can tune this thread's stack size with the resource "jvmi2_listener_thread_stack_size" (size in bytes). Affected Executables bshell Motive source ScrumStory:LNCPE-152 DevSweelinck: # 40815 (BDUX32790): LNCPE-...: Support REGEXP_LIKE on Oracle10g and LOWER function (easy filtering) Date: Wed, 1 Oct 2008 11:52:32 +0200 (CEST) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) When using "easy filtering" from the WebTop and the search mode is "Case Insensitive" the performance is far worse than when using the "Case Sensitive" search mode. Test Procedure Execute an SQL statement containing a (regexp) like predicate. Observe that: - on Oracle 10g the expression is handled by the database; - on older Oracle versions the expression is handled by the database driver; - on other databases the expression is handled by the database driver. For example: select deptname from dbtst100 where deptname like '[^AEIOU].*' order by 1 Execute an SQL statement containing the LOWER function. It should work. For example: select empno from dbtst120 where lower(lastname) alike 'haas%' Affected Executables bshell bsql all database drivers Motive source ScrumStory:LNCPE-000 DevSweelinck: # 40724 (BDUX32722): HPIA64 nm linker version B.12.48 Date: Wed, 24 Sep 2008 12:11:07 +0200 (CEST) Created on: DevAlbinoni Type: porting specific change Problem Description (Customer terms) Linker update Itanium to version B.12.48 Workaround Util/Boot -x Test Procedure Util/Boot should work now again DevSweelinck: # 40597 (BDNT32592): BwPrint: /s option with remote HP LJ P1505 causes crash Date: Mon, 15 Sep 2008 11:13:19 +0200 (CEST) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Windows Server Printer with remote HP LJ P1505 printer causes crash in BwPrint Test Procedure Start BwPrint with /s option ('silent'; this option is used by Windows Server Printer), and print to a remote HP LJ P1505 printer driver. Affected Executables bwprint Motive source SDIS:TECH-00000-04115 DevSweelinck: # 40595 (BDUX32551): oracle hint for delete statements Date: Mon, 15 Sep 2008 11:10:13 +0200 (CEST) Created on: MaintBaanIVc Type: porting specific change Problem Description (Customer terms) Add-on on project BDUX30757 (March 17, 2008) 'simple' oracle queries get index hints with a table alias, but this alias is not defined in the query. Test Procedure Old driver (DBSLOG 400) SQL> SELECT /*+FIRST_ROWS(1) INDEX_ASC(a tdbtst106288$idx1)*/ a.t$desc,a.t$int FROM b40c.tdbtst106288 a WHERE (a.t$int >= :1) ORDER BY 2 SQL> SELECT /*+ index(a tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 WHERE t$int=:1 FOR UPDATE NOWAIT SQL> DELETE /*+ index(a tdbtst106288$idx1) */ FROM b40c.tdbtst106288 WHERE t$int=:1 New driver (DBSLOG 400) SQL> SELECT /*+FIRST_ROWS(1) INDEX_ASC(a tdbtst106288$idx1)*/ a.t$desc,a.t$int FROM b40c.tdbtst106288 a WHERE (a.t$int >= :1) ORDER BY 2 SQL> SELECT /*+ index(a tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 a WHERE t$int=:1 FOR UPDATE NOWAIT SQL> DELETE /*+ index(a tdbtst106288$idx1) */ FROM b40c.tdbtst106288 a WHERE t$int=:1 Affected Executables ora8_srv Motive source SDIS:TECH-00000-04252 DevSweelinck: # 40513 (BDUX32556): Bshell: SQL select items cannot be bound to array elements Date: Wed, 10 Sep 2008 15:06:08 +0200 (CEST) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) The following construct compiles successfully, but it is not properly executed: select firstnme :1, lastname :2 from dbtst120 where empno = 10 selectbind(1,names(1,1)) selectbind(2,names(1,2)) selectdo ASSERTSEQ( strip$(names(1,1)), "CHRISTINE" ) ASSERTSEQ( strip$(names(1,2)), "HAAS" ) selectempty ASSERT( 0 ) endselect Only one of the array elements is updated, the other remains untouched. Workaround Bind to a variable, and in the "selectdo" copy from the variable to the array element. Test Procedure Write a construct such as in the Problem Description (Customer terms) and observe that the array elements are properly filled. Affected Executables bshell Motive source TCS:800-166525 DevSweelinck: # 40492 (BDUX32510): SQL: Support generic value expressions as LIKE pattern Date: Tue, 9 Sep 2008 15:02:24 +0200 (CEST) Created on: MaintStrauss Type: bugfix Problem Description (Customer terms) The following SQL statement (ANSI dialect) is not accepted by the SQL processor: select distinct "tfgld008"."leac" "n_9569" from "tfgld008" "tfgld008" where "tfgld008"."company_nr" in (519) and lower ("tfgld008"."leac") like lower ('10') || '%' order by 1 asc It replies with the following error message: Unexpected token 'lower', SQLState='42I00', VendorCode=302 Workaround Try to rewrite the query so that the pattern of the LIKE predicate is either a string literal or a parameter. Test Procedure Execute an SQL statement such as in the Problem Description (Customer terms). Affected Executables bsql bshell jbdb (the component used by the ODBC/JDBC integrations, aka the DB Connector) DevSweelinck: # 40447 (BDUX32499): change dump limit bdbpre Date: Thu, 4 Sep 2008 12:56:21 +0200 (CEST) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) Hi, we are using the session copy data tccom0214m000 to rename the companies within files created by a database export. We have noticed that when it is ran against very large files, i.e. split over two or three .S files then the first file is deleted and lost. Workaround use smaller files or the cp action of the OS Test Procedure create a file of 2147483647 bytes large and do a file.cp Affected Executables bshell Motive source SDIS:erp-00000-44334 DevSweelinck: # 40283 (BDUX32311): BLOB support: Database driver crashes on insert on BLOB table Date: Fri, 15 Aug 2008 11:39:44 +0200 (CEST) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) The database driver crashes on an insert on a table that contains a BLOB column. Currently a BLOB column is used only in the tlesb100 table. Test Procedure Create a table containing a BLOB column. Insert and update on this table. Affected Executables all database drivers. DevSweelinck: # 40093 (BDUX32143): retry_delay does not work Date: Tue, 22 Jul 2008 15:38:18 +0200 (CEST) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) retry_delay does not work. Affected Executables bshell DevSweelinck: # 39959 (BDUX31969): SQL: Crash on nested derived tables with select distinct Date: Wed, 9 Jul 2008 16:49:22 +0200 (CEST) Created on: MaintStrauss Type: bugfix Problem Description (Customer terms) The following query results in a crash of the database client (jbdb, bshell, bsql), or in a crash of the database driver: select "WarehouseCurrencies20"."HomeCurrency2" "C0" from ( select distinct "tcmcs00318"."cwar" "Warehouse" , "tcmcs00318"."dsca" "Warehouse_Description" , "tcemm17019"."fcua" "HomeCurrency1" , "tcemm17019"."fcub" "HomeCurrency2" , "tcemm17019"."fcuc" "HomeCurrency3" from ( select "tcmcs003"."cwar" "cwar" , "tcmcs003"."dsca" "dsca" , "tcmcs003"."comp" "comp" , "tcmcs003"."company_nr" "company_nr" from "tcmcs003" "tcmcs003" where "tcmcs003"."company_nr" in (590) ) "tcmcs00318" , ( select "tcemm170"."comp" "comp" , "tcemm170"."fcua" "fcua" , "tcemm170"."fcub" "fcub" , "tcemm170"."fcuc" "fcuc" , "tcemm170"."company_nr" "company_nr" from "tcemm170" "tcemm170" where "tcemm170"."company_nr" in (590) ) "tcemm17019" where "tcmcs00318"."cwar" in ('WHMUFS') and "tcmcs00318"."comp" = "tcemm17019"."comp" and "tcmcs00318"."company_nr" = "tcemm17019"."company_nr" ) "WarehouseCurrencies20" The following characteristics are required: - nested derived tables; - the outermost select clause does not select all columns from the contained derived tables; - a derived table specifies the "distinct" keyword in the select clause, and selects columns from another derived table. Test Procedure Execute a query such as above, or a query that resembles the following: select "Sex" from ( select distinct "dbtst120"."sex" "Sex" , "dbtst120"."workdept" "WorkDept" from ( select "dbtst120"."sex" , "dbtst120"."workdept" "workdept" from "dbtst120" "dbtst120" ) "dbtst120" ) "dbtst120" Affected Executables bshell bsql jbdb all database drivers DevSweelinck: # 39822 (BDUX31861): Oracle 11 support Date: Thu, 26 Jun 2008 09:16:43 +0200 (CEST) Created on: MaintBaanIVc Type: porting specific change Problem Description (Customer terms) Oracle 11 support Test Procedure Regression tests Affected Executables ora8_srv ora8_inst Motive source ScrumStory:LNPLA-172 DevSweelinck: # 39802 (BDUX31839): Merge OpenSSL/cURL from LN Date: Mon, 23 Jun 2008 16:59:53 +0200 (CEST) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) Elements in BaanIV were not the same as on LN. Test Procedure ReviewProject Compile Affected Executables bshell DevSweelinck: # 39702 (BDUX31703): Build OpenSSL and cURL on BaanIV Date: Thu, 12 Jun 2008 14:30:16 +0200 (CEST) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) Make OpenSSL and cURL build on BaanIV portingset platforms. Workaround NA Test Procedure Compile on all supported systems Affected Executables NA Motive source ScrumStory:LNCPE-120 DevSweelinck: # 39590 (BDUX31617): SQL: Error 312 (Invalid parameter type) on multi-company join Date: Mon, 2 Jun 2008 16:53:23 +0200 (CEST) Created on: DevStrauss Type: bugfix Problem Description (Customer terms) The following query: SELECT tirou001.cwoc, tirou001.dsca, tirou001.nomc, tirou001.noop, tirou001.crmp, tirou001.ccap, tcemm124.grid :dgrid, tcmcs065.ccal :deccal, tgbrg030.ccal :euccal FROM tirou001 join tcemm124 on tcemm124._index1 = {198, tctypd.workcentre, tirou001.cwoc} join tcmcs065 on tcmcs065._index1 = {tirou001.cwoc} left join tgbrg000 on 1=1 left join tgbrg035 on (tgbrg035._compnr = tgbrg000.comp AND 1=1) left join tgbrg030 on (tgbrg030._compnr = tgbrg000.comp AND tgbrg030._index1 = {tgbrg035.motp, tgbrg035.erfm, tgbrg035.vers, tcemm124.grid}) WHERE tirou001._index1 INRANGE {""} AND {"ZZZZZZZZZZZZZ"} AND tirou001.kowc INRANGE tckowc.main.wc AND tckowc.subcontracting AND tgbrg035.motp = tgbrg.mdtp.project.model AND tirou001.stty = tirou.stty.not.appl result in the error: SqlState=QP010, 'SQL: Invalid parameter type', NativeError=312 Test Procedure Execute the query in the Problem Description (Customer Terms). The query should run without problems. Affected Executables bshell bsql jbdb DevSweelinck: # 39126 (BDUX31126): IVd: NQP: Support multiple company_nr filters and company_nr column aliasing Date: Thu, 24 Apr 2008 08:45:24 +0200 (CEST) Created on: DevSweelinck Type: bugfix Problem Description (Customer terms) It is not possible to have multiple company_nr IN predicates in one SQL statement specification. For example, the following statement gives an error: select * from ( select * from dbtst120 where company_nr in ( 100, 200, 300 ) ) dt where dt.company_nr in ( 100, 200 ) This restriction should be lifted. Also, it is not possible to rename a renamed company_nr column as "company_nr". For example, the following statement gives an error: select dt."C001" as company_nr from ( select company_nr as "C001" from dbtst120 ) dt This restriction should be lifted too. Affected Executables bshell bsql jbdb Motive source ScrumStory:LNCPE-99 DevSweelinck: # 38747 (BDUX30757): oracle: wrong hint for delete statements Date: Mon, 17 Mar 2008 16:21:14 +0100 (CET) Created on: MaintBaanIVc Type: bugfix Problem Description (Customer terms) 'simple' oracle queries get index hints with a table alias, but this alias is not defined in the query. Test Procedure Old driver (DBSLOG 400) SQL> SELECT /*+FIRST_ROWS(1) INDEX_ASC(a tdbtst106288$idx1)*/ a.t$desc,a.t$int FROM b40c.tdbtst106288 a WHERE (a.t$int >= :1) ORDER BY 2 SQL> SELECT /*+ index(a tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 WHERE t$int=:1 FOR UPDATE NOWAIT SQL> DELETE /*+ index(a tdbtst106288$idx1) */ FROM b40c.tdbtst106288 WHERE t$int=:1 New driver (DBSLOG 400) SQL> SELECT /*+FIRST_ROWS(1) INDEX_ASC(a tdbtst106288$idx1)*/ a.t$desc,a.t$int FROM b40c.tdbtst106288 a WHERE (a.t$int >= :1) ORDER BY 2 SQL> SELECT /*+ index(tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 WHERE t$int=:1 FOR UPDATE NOWAIT SQL> DELETE /*+ index(tdbtst106288$idx1) */ FROM b40c.tdbtst106288 WHERE t$int=:1 Affected Executables ora_srv Motive source SDIS:ERP-00000-35541 DevSweelinck: # 38735 (BDUX30728): SOA for BaanIV - FunctionUsage Date: Fri, 14 Mar 2008 10:32:17 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) No FunctionUsage / EndFunctionUsage blocks allowed in BaanIV This is required for OpenSOA Workaround Use comments (the '|' character) for local functions Use DllUsage / EndDllUsage for external functions Test Procedure Run chk tests/bic/function_usage from /vobs/tt/lib/sql/Test Affected Executables bic* Motive source ScrumStory:LNCPE-56 DevSweelinck: # 38713 (BDUX30691): SOA for Baan IVc: BLOB support for bdbpre and post Date: Thu, 13 Mar 2008 09:48:48 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) Merge the BLOB bdbpre and post support to Baan IVc Affected Executables bdbpre6.1 bdbpost6.1 bshell6.1 Motive source ScrumStory:LNCPE-48 DevSweelinck: # 38661 (BDUX30657): SOA for BaanIV: context directives Date: Fri, 7 Mar 2008 08:37:23 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) No #context_on and #context_off directives available on BaanIV. This must be merged from LN. Test Procedure Run chk tests/bic/context from /vobs/tt/lib/sql/Test. All should succeed. Affected Executables bic6.1 repgen6.1 Motive source ScrumStory:LNCPE-56 DevSweelinck: # 38614 (BDUX30476): SOA for BaanIV: child transactions Date: Tue, 4 Mar 2008 11:32:04 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) function db.set.child.transaction() not available on BaanIV. This is required for SOA. Test Procedure run chk -V tests_bshell/db.set.child.transaction.test from /vobs/tt/sql/Test Affected Executables bshell6.1 Motive source ScrumStory:LNCPE-55 DevSweelinck: # 38571 (BDUX30571): SOA for BaanIV: Uniform startup for JCA requires ipc_boot name change Date: Thu, 28 Feb 2008 17:52:48 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) SOA for BaanIV: Uniform startup for JCA requires ipc_boot name change. Workaround Manually copy ipc_boot6.1 to ipc_boot6.2 Test Procedure 1) Check if ipc_boot6.2 exists in the Baan IV bin directory 2) Check if al permissions are set correctly Affected Executables ipc_boot6.1 Motive source ScrumStory:LNCPE-69 DevSweelinck: # 38233 (BDUX30255): Uuid port from ES8.4.1 Date: Thu, 31 Jan 2008 11:38:03 +0100 (CET) Created on: DevSweelinck Type: enhancement Problem Description (Customer terms) Function uuid.generate$() and uuid.format$() are required on BaanIV for OpenSOA. Test Procedure Run uuid.test with test framework Affected Executables bshell