Release notes for portingset: 7.1d


MaintCorelli: # 15787 (BDNT9286): Fixed bug in bshell process affinity list. Do 
not write entries with socket name in it in the registry, causing a full 
registry

Date: Tue, 29 Oct 2002 11:00:43 +0100

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
Fixed bug introduced by project BDUX7093. 
Wrong values were written in Windows registry for processor affinity.
Each process got a new value, which might cause a registry which runs out of space in worst case.

Test Procedure
Run a bshell on a fat client and check that no keys in the form <user@host:port> are created under HKLM\Software\Baan\<BSE>\ProcessAffinity



DevCorelli: # 15786 (BDNT9286): Fixed bug in bshell process affinity list. Do 
not write entries with socket name in it in the registry, causing a full 
registry

Date: Tue, 29 Oct 2002 11:00:15 +0100

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
Fixed bug introduced by project BDUX7093. 
Wrong values were written in Windows registry for processor affinity.
Each process got a new value, which might cause a registry which runs out of space in worst case.

Test Procedure
Run a bshell on a fat client and check that no keys in the form <user@host:port> are created under HKLM\Software\Baan\<BSE>\ProcessAffinity



MaintCorelli: # 15783 (BDUX8929): licd, ignore SIGPIPE and extra logging (merge 
from bugf_BDUX8142)

Date: Tue, 29 Oct 2002 09:41:51 +0100

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
In a cluster of two and more cooperating licd6.1 processes on Digitals OSF1,
the licd6.1 processes could go exit unexpectedly. Also they could loose
track of each other.


Workaround
Signal handler for SIGPIPE, watermark mechanisme to decrease communication
between license servers.


Test Procedure
Run licd6.2 in cluster on Tru64


DevCorelli: # 15777 (BDUX9288): cd.read does not work on SUN

Date: Mon, 28 Oct 2002 17:05:42 +0100

Created on:  DevCorelli
Type:        porting specific change

Problem Description (Customer terms)
The cd.read6.2 file doesn't work on SUN


MaintCorelli: # 15776 (BDUX9285): Repair argv[0] setting

Date: Mon, 28 Oct 2002 17:01:54 +0100

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Stack traces of the bshell were no longer logged in ${BSE}/log/log.bshell.


Workaround
Do not change argv[0].



DevCorelli: # 15760 (BDNT9253): Stack overflow in bshell when dumping process 
info

Date: Mon, 28 Oct 2002 12:01:13 +0100

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
2 problems caused by this problem:
1) The problem is that the bshell process is stopped indeed by ds_timeout_detect, but the licence is not released. (DF129427)
2) When using the L command in the 4GL debugger, the bshell crashes. (DF210597)


Workaround
1) Restart the Baan Licensing service.
2) Do not use the L command.

Test Procedure
problem 1:
1) on the Baan server: set ds_timeout_detect to 1 minute
2) using BW log in Baan, from a client pc
3) on the Baan server check that the licence count is increased with 1 (licmon -u), and check if pid of the newly started ntbshell.exe process.
4) now pull out the network cable from the client pc. Bw will show the message "Connection with server lost", 
select "No" to avoid reconnecting, and connect the network cable again.
5) on the Baan server: after about 1 minute the ntbshell.exe should be stopped. When the ntbshell.exe process is stopped:
5) check the licence count is decreased with 1. (licmon -u)

problem 2:
1) Run a voluntary Baan session in debugmode (or a reportobject).
2) In the debugger use the L command to view all variables.
this should work without any problems (no bshell crash)




DevCorelli: # 15758 (BDNT9271): Bshell messages from mrtext files not used

Date: Mon, 28 Oct 2002 11:58:34 +0100

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The texts from $BSE/lib/textinf/mrtextxx  files are not taken.
Hardcoded text is taken instead.

Workaround
No workaround

Test Procedure
Using an editor open the file $BSE/lib/textinf/mrtext02

E.g. in the file %BSE%\lib\textinf\mrtest02, modify the following line:

MR_BAD_USER           "Not authorized to run as user '%s'"

to:

MR_BAD_USER           "TEST Not authorized to run as user '%s'"

now, when generating this error (having language english), the following text should pop up:

TEST Not authorized to run as user <username>

Also when logging in having set BSE_LANG=4 (french language), the text should come up in french, because there is the mrtext04 file.
 






MaintCorelli: # 15756 (BDNT9271): Bshell messages from mrtext files not used

Date: Mon, 28 Oct 2002 11:57:20 +0100

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The texts from $BSE/lib/textinf/mrtextxx  files are not taken.
Hardcoded text is taken instead.

Workaround
No workaround

Test Procedure
Using an editor open the file $BSE/lib/textinf/mrtext02

E.g. in the file %BSE%\lib\textinf\mrtest02, modify the following line:

MR_BAD_USER           "Not authorized to run as user '%s'"

to:

MR_BAD_USER           "TEST Not authorized to run as user '%s'"

now, when generating this error (having language english), the following text should pop up:

TEST Not authorized to run as user <username>

Also when logging in having set BSE_LANG=4 (french language), the text should come up in french, because there is the mrtext04 file.
 







MaintCorelli: # 15723 (HYUX9220): Removal of Statement Cache Functionality

Date: Wed, 23 Oct 2002 13:34:41 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Core dump during import process.

Workaround
Disable the statement cache functionality by including the following in
db_resource file.

inf_use_prepare_cache:0

Test Procedure
Enable the statement cache functionality and try running a query. Check the
dbslog file and ensure statement cache functionality is ignored.





MaintCorelli: # 15719 (BDUX9235): Add log message when text resources are not 
supported for a platform

Date: Wed, 23 Oct 2002 12:40:12 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Added log message if text resources from $BSE/lib/textinf are not supported on a platform

Test Procedure
see defect text in scopus





DevCorelli: # 15715 (BDUX9232): HOME and USER are not correctly set when using 
baan login daemon

Date: Wed, 23 Oct 2002 12:31:26 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Environment variables HOME and SHELL where not correctly set, when logging in with Baan Logon Daemon 
on a Unix system (e.g. AIX/HP). Or the variable(s) are sometimes set.

Workaround
use rexec protocol.





MaintCorelli: # 15712 (BDUX9232): HOME and USER are not correctly set when using 
baan login daemon

Date: Wed, 23 Oct 2002 12:05:55 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Environment variables HOME and SHELL where not correctly set, when logging in with Baan Logon Daemon 
on a Unix system (e.g. AIX/HP). Or the variable(s) are sometimes set.

Workaround
use rexec protocol.





DevCorelli: # 15697 (BDUX9219): bshell hangs when it can not start JVM

Date: Tue, 22 Oct 2002 15:09:32 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Wnen the correct java version was not available or could not be started, the beshell would hang or core dump.

Workaround
Do not call destroyJavaQueue(execJavaRequestQueue) after stopJavaVM().

Test Procedure
Start bshell and try to run tmboaserver with an incorrect jvm_options file.





MaintCorelli: # 15696 (BDUX9219): bshell hangs when it can not start JVM

Date: Tue, 22 Oct 2002 15:09:02 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Wnen the correct java version was not available or could not be started, the beshell would hang or core dump.

Workaround
Do not call destroyJavaQueue(execJavaRequestQueue) after stopJavaVM().

Test Procedure
Start bshell and try to run tmboaserver with an incorrect jvm_options file.





MaintCorelli: # 15678 (BDUX9186): DB2: Fixing the problem with the db2 maint 
binary when run from the Corelli installer

Date: Fri, 18 Oct 2002 15:24:17 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The db2 maint binary searches for the DB2 shared library in the wrong path.
The Corelli installer fails with this error
/usr/lib/dld.sl: Can't open shared library: /opt/IBMdb2/V5.0/lib/libdb2.sl
/usr/lib/dld.sl: No such file or directory
/usr1/db2inst1/bse/bin/db2v5_install6.2[56]: 4504 Abort(coredump)
at the point of group file creation.
 
Test Procedure
Try the test on a system which does not have DB2v5(Corelli binaries still 
link with Db2v5). There should be no /opt/IBMdb2/V5.0 directory on the test 
system. It could be /opt/IBMdb2/V7.1

Set the SHLIB_PATH to point to the correct shared library path. In case
Db2v7.1 is installed on the system,
export SHLIB_PATH=/opt/IBMdb2/V7.1/lib
Also create soft link for the DB2 library in /usr/lib using the db2ln utility.

Try running the db2v5_maint6.2 binary from the shell and it will fail with
the following error
$ ./db2v5_maint6.2 -V
/usr/lib/dld.sl: Can't open shared library: /opt/IBMdb2/V5.0/lib/libdb2.sl
/usr/lib/dld.sl: No such file or directory
Abort(coredump) 
Try with the maint binary with the fix and the maint binary should run fine.
The same test can be tried on the db2 driver as well.
 




MaintCorelli: # 15649 (BDUX9138): Enable java 1.2 for AS/400

Date: Mon, 14 Oct 2002 15:05:00 +0200

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
On AS/400 default Java version 1.1.8 was used when running the bshell java integration.

Workaround
Compile with the JNI_VERION_12 define and use option -Djava.version=1.2.2 when starting java subsystem.

Test Procedure
Create a bse environment to run the bshell.





DevCorelli: # 15619 (BDNT9116): Windows installer for SQLServer does not 
recognize build 1000 and higher

Date: Thu, 10 Oct 2002 09:43:16 +0200

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
Installation on SQLServer 7.0 SP4 (bulid 1063) fails as this build is rejected. 

Workaround
Install on SQL Server SP3 and upgrade after the Baan installation.

Test Procedure
Install on SQLServer 7.0 SP4 (build 1063)
Install on SQLServer 2000





MaintCorelli: # 15613 (BDUX9131): Fixed compilation errors on Unix after merge 
of BDNT9029

Date: Wed, 9 Oct 2002 14:14:55 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Fixed compilation errors on Unix

Test Procedure
Compile audit stuff (db/server/AUDIT)





MaintCorelli: # 15611 (BDNT9055): Repair of project BDNT5642 (Filegroups MSQL 
driver)

Date: Wed, 9 Oct 2002 13:56:11 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Because of cleanup (project BDNT5623) MSQL7 pre processor definition was removed.
Therefor the fix of project BDNT5642 (Filegroups) was not working anymore.

Workaround
not applicable

Test Procedure
Refer to Test Procedure of project BDNT5642.





MaintCorelli: # 15605 (BDNT9121): Fixed bug in SHM caused by project BDNT9029

Date: Wed, 9 Oct 2002 10:59:09 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Bug in creating mutex for Shared memory. Using wrong name.

Test Procedure
Very difficult to test. If using terminal services, the SHM mutex is now created in the global namespace. This is OS dependent, for W2k + terminal services.





DevCorelli: # 15601 (BDUX9077): enable report language for UTC time and date

Date: Tue, 8 Oct 2002 16:10:22 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The maintain language session is set up with different seperators for germany language. In maintain date formats I choose language separator ( Help says that it then will take the user!! language, which always is English, but again in Baan 4 it takes the report language). We convert to runtime DD, but the formats are English formats all over. 

Workaround
Specify the date as last option of a field ( make 2 fields, one for time and one for date ) and force a language option in the session.

Test Procedure
compile a report with format %u001 %U002 in an other language of the user, start this report also in the other language and see if the date is displayed in the correct language. also check the output of the next line:
function main()
{
	string rjr(32)
	rjr = sprintf$("%u001,1", 1033040301)
	rjr = sprintf$("%U002,1", 1033040301)
	rjr = sprintf$("%u001 %U002,1", 1033040301, 1033040301)
}
execute this as a user in an other language the language 1 and see if the correct language seperators are used for all 3 lines.









DevCorelli: # 15581 (BDNT9029): Fixed problems in release builder. Shm failed to 
create mutex.

Date: Tue, 8 Oct 2002 10:01:10 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Release builder didn't work correctly.

Workaround
Put the right tape dump there, and no error will occurr.

Test Procedure
actually no bug was fixed, only logging.
You can test this:
1. put a wrong tss_c6.2 file in $BSE/lib. SHM should now exit whith a clear log message in the Event viewer.
2. remove an entry e.g. pacc: in u<user> file in $BSE/lib. A clear log message should be put to Event viewer.
3. Run release builder: dialogs should not be but on top of other dialogs (progress indicators). No broken texts in dialogs anymore.
4. Although not fully confirmed: made creation of Mutexes for SHM more Windows 2000 (Terminal Server) compliant. 
   Add Global\\ directive. See also MSDN on CreateMutex() function.





MaintCorelli: # 15578 (BDNT9029): Fixed problems in release builder. Shm failed 
to create mutex.

Date: Tue, 8 Oct 2002 09:31:04 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Release builder didn't work correctly.

Workaround
Put the right tape dump there, and no error will occurr.

Test Procedure
actually no bug was fixed, only logging.
You can test this:
1. put a wrong tss_c6.2 file in $BSE/lib. SHM should now exit whith a clear log message in the Event viewer.
2. remove an entry e.g. pacc: in u<user> file in $BSE/lib. A clear log message should be put to Event viewer.
3. Run release builder: dialogs should not be but on top of other dialogs (progress indicators). No broken texts in dialogs anymore.
4. Although not fully confirmed: made creation of Mutexes for SHM more Windows 2000 (Terminal Server) compliant. 
   Add Global\\ directive. See also MSDN on CreateMutex() function.






MaintCorelli: # 15564 (BDNT9051): improve Delivering on NT systems

Date: Fri, 4 Oct 2002 15:12:11 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Cameo examples doesn't compile.

Workaround
Fix a typo in delivery.lst, add one header more to the delivered headers and modify deliver.exe for compile the delivered examples.
Make deliver.exe capable to compress the delivered data into one tar.Z file.

Test Procedure
Do a nightly build with the new deliver.exe and use the new functions which are described in sample.cfg.





MaintCorelli: # 15540 (BDNT8819): Textwidth not calculated correctly because of 
vertical scrollbar in multiline text window.

Date: Wed, 2 Oct 2002 15:29:52 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
When in a multiline textwindow the maximum number of columns is determined to 80 
and no vertical scrollbar is present the number of characters a user can type is 82.
After savng the text and reopening it all lines are cut off at collumn 80,
possibly resulting in a wrong layout.
To prevent this the vertical scrollbar should always be present, but disabled when the
number of lines exceeds the maximum number of lines per page, then the scrollbar needs
to be enabled.

Workaround
Not applicable

Test Procedure
Run Baan (Corelli) from any server using BW and start session tttxt1100m000.
Search or create a text with textgroup 'text' (meaning the text is editted using the
Baan editor). Choose 'Edit Text' form the specific menu. Look at the textwindow and 
check if there is a vertical scrollbar. If not, you can type more than the defined
number of characters on one line. If the number of lines exceeds the maximum number
of lines per page a vertical scrollbar is made visible. Characters positioned on the
last two columns of the textwindow are moved to the next line.





MaintCorelli: # 15531 (BDNT8979): Core dump during exchange import/export as 
normal user

Date: Tue, 1 Oct 2002 16:12:58 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Normal users trying to Import/Export data with exchange lose 
their connection to the Baan environment (session and Menu Browser disconnect).


Workaround
n/a

Test Procedure
1.) Compile following program (bic test.src -o testo)

    Source of test.src:

    function main()
    {

      long ret

      ret = exec_dll_function("C:\tmp\extra_long_path_for_exchange_core_file_test\mydll","func_in_dll")

      if ret = 0 then
        message ("Okay")
      endif

    }

2.) Create the directory used in previous exec_dll_function() call. If you are
    using another directory ensure that the length of the directory name is
    longer as 22 characters.

3.) Compile following DLL (bic mydll.src -o mydll)

    Source of mydll.src :

    function extern func_in_dll()
    {
    }

4.) Ensure that you are a normal user with permission to do everything.
5.) Run program testo from GUI. The message "Okay" should be displayed.






MaintCorelli: # 15499 (BDNT8991): BDBLib functions export

Date: Wed, 25 Sep 2002 17:44:53 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The user cannot use several functions from our shared library because they aren't exported.

Workaround
Add these missing function names and do a little function to export user_info variable.

Test Procedure
Use the exported functions in an external binary






MaintCorelli: # 15476 (BDUX8926): reconfig does not always flush dbs_dd cache

Date: Tue, 24 Sep 2002 14:58:01 +0200

Created on:  DevEscher
Type:        bugfix

Problem Description (Customer terms)
Some tables that are reconfigured are not invalidated in the shared memory cache 
of the database drivers resulting in error E_BDB_DD_CORRUPT (error 512).

Workaround
restart the shared memory after reconfigurations that result in E_BDB_DD_CORRUPT (error 512).

Test Procedure
Copy a dd to dd.new: eg ttadv200.new
Add to $BSE/lib/compnr6.2:  ttadv200:300:100

run 1: DBSLOG=1000 BDB_DEBUG=02 USE_SHM_INFO=1 bdbreconfig6.2 -n -N ttadv200 -C 000 002 005 100

The output should contain lines like:
	-> EXE_SYSTEM on server 400ffe80 code 8 msglen 12 (ttadv200.000)
	<- EXE_SYSTEM answer len 0 ()
	-> EXE_SYSTEM on server 400ffe80 code 8 msglen 12 (ttadv200.002)
	<- EXE_SYSTEM answer len 0 ()
	-> EXE_SYSTEM on server 400ffe80 code 8 msglen 12 (ttadv200.005)
	<- EXE_SYSTEM answer len 0 ()
	-> EXE_SYSTEM on server 400ffe80 code 8 msglen 12 (ttadv200.100)
	<- EXE_SYSTEM answer len 0 ()
dbs.log should contain lines like:
	Msg_type 7 received.
	Invalidate DBS_DD in shared memory. tname = 'ttadv200', compnr = 0
        	dbs_dd_env = '. . .', dbs_dd 'ttadv200000'
	Msg_type 7 received.
	Invalidate DBS_DD in shared memory. tname = 'ttadv200', compnr = 2
        	dbs_dd_env = '. . .', dbs_dd 'ttadv200002'
	Msg_type 7 received.
	Invalidate DBS_DD in shared memory. tname = 'ttadv200', compnr = 5
        	dbs_dd_env = '. . .', dbs_dd 'ttadv200005'
	Msg_type 7 received.
	Invalidate DBS_DD in shared memory. tname = 'ttadv200', compnr = 100
        	dbs_dd_env = '. . .', dbs_dd 'ttadv200300'

Note that the physical company (300) is invalidated instead of the logical company 100.

run 2: DBSLOG=1000 BDB_DEBUG=02 USE_SHM_INFO=1 bdbreconfig6.2 -n -N ttadv200 -C 100-120
The output and dbs.log should contain invalidates for all companies in the specified range.






MaintCorelli: # 15450 (BDUX8059): problems with selecting jvmi version

Date: Mon, 23 Sep 2002 09:49:54 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Customer installed the 7.1c.03 portingset and OpenWorld no longer works.
Get the message:
"Cannot start tmboaserver: wrong JDK or Java version" when trying to start tmboaserver.

Workaround
use the old version of the portingset

Test Procedure
start the tmboaserver on some AS400 system and see if the mentioned error is comming.





MaintCorelli: # 15438 (BDUX8847): Audit must write client types into the audit 
trail

Date: Fri, 20 Sep 2002 13:08:17 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The 3/4 GL code that handles the audit data breaks on columns containing
multi-byte strings.

Test Procedure
Exchange regression test





DevCorelli: # 15427 (BDUX8924): Fixes for multibyte on AS400 - DB2/400.

Date: Thu, 19 Sep 2002 13:12:40 +0200

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
The multibyte solution did not work properly, because the CCSID for multibyte fields were not defined
in the sqlda structure in DB2/AS400.

Test Procedure
In Corelli there is no current test procedure for this, because it should be tested on a multibyte
system. However the regression test was run to test the affect to single byte environment.





MaintCorelli: # 15396 (BDNT8897): 2002 Certificate from Verisign for BI

Date: Mon, 16 Sep 2002 13:26:41 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Yearly update of certificate for BI Applet required.

Workaround
Normal usage of BI can still continue.
New BI builds cannot be made.






MaintCorelli: # 15369 (BDUX8863): wrong LD_LIBRARY_PATH

Date: Wed, 11 Sep 2002 15:56:46 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
bshell crashes when tmboaserver is started

Workaround
Put next line in $BSE/lib/bse_vars:
LD_LIBRARY_PATH=/bse_dir_of_customer/shlib:/usr/baan/shared/shlib:/usr/java/lib
or
LD_LIBRARY_PATH=/bse_dir_of_customer/shlib:/usr/baan/shared/shlib:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/client:/usr/j2se/jre/lib/sparc/native_threads

Test Procedure
start tmboaserver on Solaris with JRE1.3





MaintCorelli: # 15364 (BDNT8895): Fix function call convention for ARM shlib: 
affects only NT

Date: Wed, 11 Sep 2002 15:02:53 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
1: Lost connection with BW when ARM is enabled on Windows.
2: Ntbshell can not find/open arm.dll. Should look for libarm32.dll

Workaround
1: not possible
2: rename LIBARM32.DLL to ARM.DLL

Test Procedure
Install Corelli on NT.
Enable ARM in $BSE/lib/defaults/all (art_enable:1 art_trace:3)
Install ARM software
Notice ARM DLL not found
Rename ARM DLL to ARM.DLL
Notice ntbshell will break.





MaintCorelli: # 15350 (BDUX8852): Add keyword __OBJECT__ to bic.

Date: Tue, 10 Sep 2002 16:58:30 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
There is no way to determine the current object name from withing Baan 3GL.
Having this name available would give some benefits in the tools (e.g. in
better assert() and in dal.file.to.class.name()).

Test Procedure
Create a small 3GL program that outputs the stringvalue of __OBJECT__.





MaintCorelli: # 15305 (BDUX8641): Investigate core dump in bshell

Date: Wed, 4 Sep 2002 16:21:18 +0200

Created on:  DevEscher
Type:        bugfix

Problem Description (Customer terms)
1. Core dump in bshell when calling dll functions with illegal number of arguments
2. Whith -dbgobj, -dbgcpu, -dbgsym and tracelevel >= 2, a core dump occurs.

Test Procedure
Problem 1:
test for programmes: write a scripts which calls a dll function with wrong number of arguments. Check that no core-dump occurs.
Normal customers do not have the possibility to check this problem.
Problem 2:
Run bshell with tracelevel >=2 , -dbgsym, -dbgobj, -dbgcpu and check that no coredump will occur (the problem was found while running
session: 





MaintCorelli: # 15298 (BDUX8830): Increase the size for send.message().

Date: Wed, 4 Sep 2002 15:04:19 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
For a new tax integration, the buffer used for send.message() and recv.message()
are too small (1K). Must be enlarged to 4K.

Test Procedure
None





MaintCorelli: # 15291 (BDUX8833): Error handling changes in bdbreconfig

Date: Wed, 4 Sep 2002 13:11:43 +0200

Created on:  DevBaanIVc
Type:        bugfix

Problem Description (Customer terms)
1. "bdbreconfig -I inputfile" immediately stops after an error occurs.
   All tables that are not processed yet are not reconfigured. This is not workable for customers, as the 
   reconfiguration process has to be many times to get a single problem at the time.

2. Restarting bdbreconfig might lead to dataloss when a dump file is not removed because the restore action of 
   first run did fail. The second run will overwrite (truncate) the saved dump.

3. When a table does not exist in the RDBMS, the reconfiguration is logged as error (when -i option is not set)

Workaround
Do not reconfigure everything in one big batch, but run multiple smaller batches.

Test Procedure
Test procedures of projects:
BDUX5851: exit code for bdbreconfig
BDUX6247: exit code rcf and -i flag
BDUX6691: Bdbreconfig changes





MaintCorelli: # 15266 (BDUX8671): Multiple printouts after changing paper type

Date: Mon, 2 Sep 2002 14:43:36 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
When someone sends a print job to a device of type printer and the printer is
currently down, e.g. the papertype will be changed (ttaad3102m000), sometimes
the report will be printed several times if the printer returns to online.

Workaround
n/a





DevCorelli: # 15257 (BDUX8771): buffer overflow

Date: Mon, 2 Sep 2002 12:31:42 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
bshells dumps core when SHLIB_PATH, LIBPATH or LD_LIBRARY_PATH contains more than 255 bytes.

Workaround
Make sure your PATH is short

Test Procedure
Put a very long library path in your environment and start Open World.





MaintCorelli: # 15254 (BDUX8771): buffer overflow

Date: Mon, 2 Sep 2002 12:30:29 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
bshells dumps core when SHLIB_PATH, LIBPATH or LD_LIBRARY_PATH contains more than 255 bytes.

Workaround
Make sure your PATH is short

Test Procedure
Put a very long library path in your environment and start Open World.





MaintCorelli: # 15252 (BDUX8803): Manual merge of project BDUX8785 (LTOE problem 
in bic).

Date: Mon, 2 Sep 2002 10:42:54 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Bic compiler refuses passing a domain via ltoe() to a ref-argument of
a function. This construction was previously allowed.

Test Procedure
Please compile the following example with   'bic6.2 -u -f my_wh -o./tst tst.bc'

function negate(ref domain tcyesno n)
{
	n = (n = tcyesno.yes ? tcyesno.no : tcyesno.yes)
}

function f ( domain tcyesno yn)
{
}

function main ()
{
	domain tcyesno  flag
	string a(10)

	a(1;2) = "hallo"	| Make sure the other usage of 'longexp' in
				|   bic still works.

	f( ltoe( 2))		| Original call: coredump when compiling
				|   this construction with -u option.

	flag = tcyesno.yes	| Resulting call: this construction was refused
	negate(ltoe(etol(flag)))|   Should work now.
}





MaintCorelli: # 15244 (BDUX8793): UTC date problem fix modification

Date: Fri, 30 Aug 2002 15:37:43 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
The variable copy was disturbing when you just clicking on it.

Workaround
Do this event only when the user clicked with the right mouse button.

Test Procedure
See the difference, when you select a variable with the left or the right mouse button.





MaintCorelli: # 15224 (BDNT8781): Fixed problems in release builder

Date: Wed, 28 Aug 2002 16:39:32 +0200

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
Release builder did not fill package combination in u<user> files.
Also the fd6.[12].<pacc comb> was not created (but a fd6.[12]. file (which is incorrect)

Workaround
manual adjust u<user> file and rename fd6.[12]. to fd6.[12].<pack. comb>

Test Procedure
Run release builder, and check user file and fd file after release builder finished






MaintCorelli: # 15222 (BDUX8780): Oracle 8.1.7 library update

Date: Wed, 28 Aug 2002 15:29:02 +0200

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
Oracle 8 binaries should be linked with new client libraries.






MaintCorelli: # 15217 (BDNT8270): TSS: extend Trad. and Simpl. Chinese

Date: Wed, 28 Aug 2002 15:02:14 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
Traditional and Simplified Chinese should be extended.






MaintCorelli: # 15212 (BDNT8776): Added Datacenter certification logo to MMC 
snapin

Date: Wed, 28 Aug 2002 14:50:25 +0200

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
Added Windows 2000 Datacenter logo in Baan Manager MMC snapin

Workaround
N/A

Test Procedure
Start Baan MMC manager, and check that a W2k datacenter logo is existent





DevCorelli: # 15206 (BDUX8753): Error handling changes in bdbreconfig

Date: Tue, 27 Aug 2002 15:48:06 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
1. "bdbreconfig -I inputfile" immediately stops after an error occurs.
   All tables that are not processed yet are not reconfigured. This is not workable for customers, as the 
   reconfiguration process has to be many times to get a single problem at the time.

2. Restarting bdbreconfig might lead to dataloss when a dump file is not removed because the restore action of 
   first run did fail. The second run will overwrite (truncate) the saved dump.

3. When a table does not exist in the RDBMS, the reconfiguration is logged as error (when -i option is not set)

Workaround
Do not reconfigure everything in one big batch, but run multiple smaller batches.

Test Procedure
Test procedures of projects:
BDUX5851: exit code for bdbreconfig
BDUX6247: exit code rcf and -i flag
BDUX6691: Bdbreconfig changes







MaintCorelli: # 15166 (BDUX8617): Can not login with blogind when rlogin is 
disabled on AIX platforms.

Date: Thu, 22 Aug 2002 10:27:43 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
It is not possible to login with blogind when rlogin is disallowed in user
security settings on AIX platforms.

Workaround
n/a





DevCorelli: # 15161 (BDNT8043): Oracle 9 install for NT

Date: Wed, 21 Aug 2002 17:15:10 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
NT installers do not support Oracle 9i

Test Procedure
Follow the install manual





DevCorelli: # 15143 (BDUX8080): Merge DB2/400 Level 2 changes to Corelli 
Development branch.

Date: Fri, 16 Aug 2002 17:14:29 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
The Level 2 DB driver was not supported on AS400 until now.

Test Procedure
Installation, conversion and regression test should be run to test Level 2 mode.





DevCorelli: # 15109 (BDUX7119): One bdb_errno in shlib and tool on Sun.

Date: Wed, 14 Aug 2002 14:49:13 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
The variable bdb_errno is zero after a failing clear table.

Workaround
No workaround.

Test Procedure
Create on a Sun system in the directory "$BSE/api/examples/db" the cameo1 program with
the command:
  $ make -f Makefile.SUN cameo1
Set the environment variable that defines the path of the shared libraries to
$BSE/shlib. 
  $ export LD_LIBRARY_PATH=$BSE/shlib
Create the next gvommand script to drop table ttexa100.
  $ cat drop_table
  #1 ttexa100 TDRTBL 0
Drop table ttexa100 in company 000.
  $ gcommand6.2 drop_table 000
Run the program cameo1.
  $ cameo1

With the old and wrong BDB-API shared library the output lines are:
  company# from cursor : 0
  Error 0

With the new and correct BDB-API shared library the first output lines are:
  company# from cursor : 0
  Command : clear_table (rc = -1)
  Command : create_table (rc = 0)
  Number of rows : 0
  




DevCorelli: # 15108 (BDUX7514): SQL: As prepared set with x rows fetches too 
many rows

Date: Wed, 14 Aug 2002 14:27:27 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Bad performance of "as prepared set with <n> rows" queries.


Test Procedure
Execute the query "select * from dbtst120 as prepared set with 3 rows".
Make a dbs.log file (DBSLOG=010) and observe that only 3 rows are 
fetched:

	> rm dbs.log; DBSLOG=010 qptool6.2 -q "select * from dbtst120
	    as prepared set with 3 rows"
	> echo `egrep "R_|Output Row" dbs.log | wc -l`" rows fetched"
	3 rows fetched
	>

With the "old" driver you would get "32 rows fetched".





DevCorelli: # 15107 (BDNT8122): Fix memory leak in the Grid code

Date: Wed, 14 Aug 2002 14:26:14 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
After running BW for a long time it seams to leak some memory.

Test Procedure
To test this you must run BW in debug mode from Visual Studio.
Start a session with an editable grid.
Click on an editable cell.
Close all sessions.
Visual Studio should not report any memory leaks now.





MaintCorelli: # 15105 (BDUX8652): r.s.footer and r.s.header section too large in 
reportscript generated by repgen

Date: Wed, 14 Aug 2002 14:12:35 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Compiling a certain report that has more that 10 footer entries in the layout with debug option generates an 
error:r.s.footer too large.

Workaround
To work around the problem the number of header and/or footers must be limited.

Test Procedure
To test the solution find a suitable report with 1 or more headers and footers. Compile the report in debug and find
the tmp file in the $BSE/tmp directory. Two tmp files are generated, one script and one message report. Find the script
tmp file and use an editor to view the file. Search for the header and footer functions. They look like following:
	function extern r.s.header.1()
	{
		<source code>
	}

Further in the script a following general part is present, looking like this:
	function extern r.s.header()
	{
		r.s.header.1()
		return
	}

Finally the report must be tested by executing it (print the report).





DevCorelli: # 15078 (BDUX8639): Can not retrieve java-functions on HP-UX

Date: Mon, 12 Aug 2002 15:33:32 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
On HP-UX customer gets message in log file:
Load of symbol failed 'JNI_GetDefaultJavaVMInitArgs'

Test Procedure
tmboaserver





DevCorelli: # 14933 (BDUX8466): Error 254 upon db.clear.table without rollback

Date: Tue, 30 Jul 2002 14:11:42 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Error 254: Commit transaction has failed in the audit server.

The following error is displayed in the message dialogue of BW:
	Error: ttaud.comt not according to MUST_BE_FILLED (value 0)
	Insert into ttaud110 compnr 000 failed. Can't create transaction notification ABORT

Workaround
Disable the auditing on a table, but that might not be possible.
Otherwise modify the session code:
replace
	db.clear.table( <tbl>, NO.ROLLBACK)
by
	db.clear.table( <tbl>, WITH.ROLLBACK)

Test Procedure
Test the following 3GL code
	db.clear.table(ttaad050, NO.ROLLBACK)
	commit.transaction()

or gcommand script
	#1 ttaad050 TCLTBL      1
	#1 ttaad050 DCOMMIT     1
	
When AUDIT has been enabled for the table, error 254 occurs for the current porting set,
while the problem is fixed in this project.

Please verify the contents of the audit files and table ttaud110 as well.





DevCorelli: # 14928 (BDUX8504): Licmon, remove orphaned licences option, fix 
cleaning twice

Date: Tue, 30 Jul 2002 13:07:29 +0200

Created on:  DevBaanIVc
Type:        bugfix

Problem Description (Customer terms)
When using licmon6.X -c for cleaning up orphaned licences from a license cluster, a 30 seconds deadlock between license deamons could occur.

Workaround
Save and restore the receiver address.

Test Procedure
Use 2 clustered licd6.X deamons and generate orphaned licences. Try cleaning up licenses using the interactive clean option.





DevCorelli: # 14909 (BDUX8041): database server termination error

Date: Fri, 26 Jul 2002 12:48:30 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
When running the session cprrp1210m000 by job, with multiple bshells and after
restart of baan, the system comes up with detected database server termination.

Workaround
n/a

Test Procedure
Test is difficult. You need a system with this kind of error. Tests was done
on three different systems. Result - no database termination anymore.






DevCorelli: # 14610 (BDUX8251): Informix:Fix for error 1210 in 
import:TCS-100/127588

Date: Thu, 4 Jul 2002 09:34:40 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
Not Applicable

Test Procedure
Create a table with  date column (ttadv998 is used here as an example).
Run the following gcommand script

#1 ttadv998 RINS 0 -i -p
=  ttadv998.date = 0
=  ttadv998.time = 0
=  ttadv998.name = tttadv111
#1 ttadv998 DCOM 0

With a driver that does not contain this fix error -1210 will be returned on DEC. With this fix, the insertion would go through successfully.





DevCorelli: # 14573 (BDUX8163): SQL: CLEARUNREF on empty key

Date: Tue, 2 Jul 2002 09:44:11 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
When executing some specific queries when the parameter "max_tables_joined"
(default value is -1, unlimited) in the file db_resource is set, the resulting
output differs from the output when the parameter max_tables_joined is NOT set.

Workaround
Do not set MAX_TABLES_JOINED or do not use the clearunref mode.

Test Procedure
Create a file 'query.txt' that contains the following query:

select mgrno, firstnme
from   dbtst100, dbtst120
where  mgrno refers to dbtst120 unref clearunref
and    mgrno = 0

Execute this query as follows:

MAX_TABLES_JOINED=1 DBSLOG=400 qptool6.2 -c 0 -f query.txt

The file dbs.log should contain two queries:

SQL> SELECT /*+ FIRST_ROWS  */ a.t$mgrno FROM b50lev2.tdbtst100000 a WHERE a.t$mgrno = :1
SQL> SELECT /*+ FIRST_ROWS index(b tdbtst120000$idx1)  */ b.t$firstnme FROM b50lev2.tdbtst120000 b WHERE b.t$empno = :1





DevCorelli: # 14559 (BDUX8193): JDK1.3 support

Date: Mon, 1 Jul 2002 15:12:22 +0200

Created on:  MaintBaanIVc
Type:        porting specific change

Problem Description (Customer terms)
Can not use JRE1.3 on Solaris to load libjava.so

Workaround
Use JRE 1.1.8 or 1.2.x

Test Procedure
Run tmboaserver on a platform with JRE1.3.
Create a file $HOME/jvm_options or $BSE/java/jvm_options.
When $HOME/jvm_options is found $BSE/java/jvm_options will not be read.
In that way a certain user can use its own options.
$ java  -help or java -X shows which options are availlable.
For example: put in jvm_options:
-Xmx=128000000
-hotspot





DevCorelli: # 14546 (BDUX8201): Merge of project BDUX8190

Date: Mon, 1 Jul 2002 12:22:13 +0200

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
"BW exits when we try to create very large number of records in Baan using a 
BOI."

The insertion of a Purchase Order leads to starting a new session in the
bshell (function server), the insertion of records, and the ending of the
session. For each Purchase Order this procedure is followed.
Each time a session is ended, an amount of memory is not freed. When a large
amount of Purchase Orders is inserted, the bshell will abort because of
memory exhaustion.

This only happens when auditing is enabled on the table on which the inserts 
are done.


Workaround
If possible, disable auditing.

Test Procedure
Use the following test scripts (Baan3gl):

Source t.c:

	function main()
	{
			  long i, pid

			  for i=1 to 1000
						 pid = activate("./s.o")
						 wait( pid, WTHANG )
			  endfor
	}

Source s.c (if needed, modify the source to use another table):

	table tdbtst120

	function main()
	{
			  error.bypass = 1

			  dbtst120.empno = 17
			  dbtst120.workdept = "A00"

			  db.insert( tdbtst120, db.retry )
			  db.first( tdbtst120 )

			  abort.transaction()
	}

Compile the scripts:

	bic6.1 ./t.c -o ./t.o
	bic6.1 ./s.c -o ./s.o

Run the object t.o:

	bshell6.1 -server ./t.o

Now observe the size of the bshell process (e.g. using ps -l). After an
initial growth, it should very quickly stabilize.






DevCorelli: # 14531 (HYNT8091): MSQL:Tool to migrate L1 database to 
L2:enhancement

Date: Mon, 1 Jul 2002 11:14:36 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
Customer wants a tool to migrate his huge SQL Server database in baan level 1 driver
to level 2 in a faster way. 
bdbpre and bdbpost are slow.

Workaround
use bdbpre and bdbpost to migrate level 1 database to level 2.

Test Procedure
Execute the migration tool successfully and run the baan environment using
level 2 driver for SQL Server





DevCorelli: # 14514 (BDUX8179): Fixing licmon clean functionality on NT

Date: Fri, 28 Jun 2002 11:40:03 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
Cleanup unused licences on NT (licd)

Test Procedure
Compile on NT and run licmon -c





DevCorelli: # 14484 (BDUX8155): Licmon, remove orphaned licences option

Date: Wed, 26 Jun 2002 14:38:31 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
Licences registered to bshell that have crashed can not be removed from licd.

Workaround
Licmon has been outfitted with a -c flag to enable it to check if all registered
bshells are still running. If it encounters a bshell licence that is no longer
in use, it will try to revoke the licence.

Test Procedure
Use the licbsh process to generate an orphaned licence at try to remove it with the
licmon -c option.





DevCorelli: # 14476 (BDUX8081): JVM startup arguments

Date: Tue, 25 Jun 2002 16:59:44 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Can not use JRE1.3 on Solaris to load libjava.so

Workaround
Use JRE 1.1.8 or 1.2.x

Test Procedure
Run tmboaserver on a platform with JRE1.3.
Create a file $HOME/jvm_options or $BSE/java/jvm_options.
When $HOME/jvm_options is found $BSE/java/jvm_options will not be read.
In that way a certain user can use its own options.
$ java  -help or java -X shows which options are availlable.
For example: put in jvm_options:
-Xmx=128000000
-hotspot





DevCorelli: # 14323 (BDUX8022): One bdb_errno in shlib and tool on Sun.

Date: Wed, 12 Jun 2002 08:35:34 +0200

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
The variable bdb_errno is zero after a failing clear table.

Workaround
No workaround.

Test Procedure
Create on a Sun system in the directory "$BSE/api/examples/db" the cameo1 program with
the command:
  $ make -f Makefile.SUN cameo1
Set the environment variable that defines the path of the shared libraries to
$BSE/shlib. 
  $ export LD_LIBRARY_PATH=$BSE/shlib
Create the next gvommand script to drop table ttexa100.
  $ cat drop_table
  #1 ttexa100 TDRTBL 0
Drop table ttexa100 in company 000.
  $ gcommand6.2 drop_table 000
Run the program cameo1.
  $ cameo1

With the old and wrong BDB-API shared library the output lines are:
  company# from cursor : 0
  Error 0

With the new and correct BDB-API shared library the first output lines are:
  company# from cursor : 0
  Command : clear_table (rc = -1)
  Command : create_table (rc = 0)
  Number of rows : 0
  




DevCorelli: # 14296 (BDUX7999): seq.skip fix

Date: Fri, 7 Jun 2002 14:48:20 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
seq.skip does not always work properly

Workaround
Remapping seq.skip(n,fp) to seq.seek(n,1,fp)





DevCorelli: # 14291 (BDUX7991): option 2 for open.message does not a correct 
check.

Date: Fri, 7 Jun 2002 11:23:24 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
According to the Baan help, open.message(...) should return -1 and not create a new mailbox when the parameter action is 2 and a mailbox does not already exist.  This is not how open.message(...) seemed to be working

Test Procedure
execute the next command:
function main()
{
	long    ret
	string  in.queue(132)

	in.queue   = creat.tmp.file$(bse.tmp.dir$())
	ret  = open.message(1, in.queue, 2)
	ret  = open.message(1, in.queue, 0)
	ret  = open.message(1, in.queue, 2)

	if len(in.queue) <= 128 then
		ret = seq.unlink(in.queue)
	endif
}
the ret should be -1 the first, the next time a value should be returned, and the last time the same value should be returned






DevCorelli: # 14265 (BDUX7959): Informix:Fixing error 410 on 
insert:TCS-100/127391

Date: Tue, 4 Jun 2002 16:37:03 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
None

Test Procedure
Run the following gcommand script
#1 ddcts531 TDRTBL 0 -c 621
#1 ddcts531 RINS 0 -i -c 621 -E NO_TABLE
=  ddcts531.int1 = 1
#1 ddcts531 DABORT 0
#1 ddcts531 RINS 0 -i -c 622
=  ddcts531.int1 = 1

(Company 622 has to be a logical company referring to the physical company 621)

The driver should return error 506 ( Table does not exist ) for the second insert command. A driver without this fix would return the native error -401.





DevCorelli: # 14234 (BDUX7964): Oracle driver should translate ORA-24345 into 
Baan error 512

Date: Fri, 31 May 2002 14:20:48 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
When a table column in Baan is shorter than the actual size in Oracle,
truncation occurs during fetch.
Depending on resource settings and Oracle version this can return error ORA-24345.
Error ORA-24345 should be returned as E_BDB_DD_CORRUPT (bdb_errno 512)

Test Procedure
Modify the dtt.pd file. Change the length of ttdsca from 30 to 10 and run the following command:
qptool6.2 -c 0 -q "select * from ttaad100"
The old driver causes the following output containing the native Oracle error:
	Error 25345 Msg ''
The new driver causes the expected error to occur:
	Error 512 Msg ''
Do not forget to restore the dtt.pd file!





DevCorelli: # 14222 (BDUX7963): Force compiler to use ANSI setting, since the 
default is K&R

Date: Fri, 31 May 2002 09:39:41 +0200

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
Due to compiler settings imake/cpp didn't compile, and therefore no build of the portingset could be started.

Workaround
Make ANSI the default since old compiler versions take K&R as default (or upgrade compiler)

Test Procedure
Build!





DevCorelli: # 14174 (BDUX7929): Informix:Error 214 in drop table:100-127317

Date: Wed, 29 May 2002 08:36:51 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
None

Test Procedure
Run the following gcommand script 
1 ddcts502 TDRTBL -0
1 ddcts502 TDRTBL -1024

The first drop table command will fail due to references. The second one will succedd due to the IGNORE REFERENCES (1024) flag. A driver without this fix would cause the second command to fail as well.






DevCorelli: # 14168 (BDNT7917): Bshell: fmax should take number of digits into 
account

Date: Tue, 28 May 2002 14:15:55 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
domain min and max do not take 'Digits before Decimal' en 'Digits after Decimal' into account

Test Procedure
see TCS call





DevCorelli: # 14112 (HYUX7889): Informix:Database server 
termination:Scopus-119619

Date: Wed, 22 May 2002 16:51:24 +0200

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
Create some items using the session tiitm0101m000. Delete a bunch of items using tiitm0203m000. The session terminates with the error "Detected Database Server Termination."

Workaround
Turn off the prepare statement cache. 
Set inf_use_prepare_cache:0 in $BSE/lib/defaults/db_resource.

Test Procedure
Delete a bunch of items (5 or more) using the session tiitm0203m000. With a driver that does not contain this fix, the session terminates with the message "Detected database server termination" and the user loses connection with the bshell. 

With this fix, the deletion of items will go through successfully.





DevCorelli: # 13890 (BDNT7667): (Re)added stacktraces on NT

Date: Tue, 23 Apr 2002 11:26:21 +0200

Created on:  DevCorelli
Type:        porting specific change

Problem Description (Customer terms)
Re added stacktrace on NT for remaining files which are not in the maintenance release branch.

Test Procedure
Let crash (if you can) a binary (e.g. bwprint, bshell etc) and check that a stack trace
will be reported in the event viewer.





DevCorelli: # 13872 (BDUX7644): double drop table problem.

Date: Fri, 19 Apr 2002 15:30:31 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
A drop table table on an existing table give error 506 "BDB_NO_TABLE" but the table
doesn't exist anymore after the action.


Workaround
No workaround.

Test Procedure
Create for example table ttaad050 in company 001.
This is possible with the next gcommand script.

$ cat gc_create
#1 ttaad050 TCRTBL 0
$ gcommand6.2 gc_create 001

Drop the table with the next gcommand script.

#1 ttaad050 TDRTBL 0
$ gcommand6.2 gc_drop 001

Check the commlog file for errors.





DevCorelli: # 13822 (BDUX7600): Clear table on a self-referencing table.

Date: Wed, 17 Apr 2002 17:15:25 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
The delete of a parent row that is (restricted) refered by a child row succeed.
However this delete action should fail with bdb_errno 605 "E_BDB_REF_EXISTS".


Workaround
No workaround.


Test Procedure
Create table ddcts505 from the database regression test.
Fill the table with the folowing row's:
int	int1	int2	int3	int4
4	0	3	0	0
3	0	4	0	0
5	0	0	0	0
6	0	0	5	0

Create a gcommand command-file with the next command's:
$ cat gc_clr_del
#1 ddcts505 TCLTBL 0
#1 ddcts505 DCOM 0
#1 ddcts505 REQUAL* 0 -i
=  ddcts505.int = 5
#1 ddcts505 RDEL 0
#1 ddcts505 DCOM 0

Execute the commands on the next way (611 is the company number):
$ gcommand6.2 gc_clr_del 611
Server 1 --> Command: TCLTBL 
Server 1 --> Command: DCOM   Error  
Server 1 --> Command: REQUAL* 
Server 1 --> Command: RDEL   Error  
Server 1 --> Command: DCOM 

$ cat commlog
#1 ddcts505 TCLTBL    0
#1 ddcts505 DCOM      0 bdb_errno = 520
!!! Test failed: error should be 0 !!!
File positions: 
#1 ddcts505 REQUAL*   0
        Assignment: ddcts505.int         = <5>
#1 ddcts505 RDEL      0 bdb_errno = REF_EXISTS
!!! Test failed: error should be 0 !!!
File positions: 
#1 ddcts505 DCOM      0

Without the fix the delete action (RDEL) succeed.
With the fix the delete action fails with error 605 "REF_EXISTS".






DevCorelli: # 13756 (BDUX7567): Load of java system library fails

Date: Wed, 10 Apr 2002 08:05:40 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
tmboaserver can not be started.

Workaround
Rename  the directory.

Test Procedure
cd $BSE
bshell6.x -server tmboaserver





DevCorelli: # 13689 (BDUX7503): Manual merge of BDUX7481 (Scopus defect 122612)

Date: Tue, 2 Apr 2002 11:23:42 +0200

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
Query returns wrong result

Workaround
No clear workaround available

Test Procedure
Run a query which needs a input binding for a special column. For example,
select  tuxch999.cpac,tuxch999.cmod,tuxch999.flno
from    tuxch999
where   tuxch999._index1 = {'tc','mcs','037'} and
tuxch999.cpac & tuxch999.cmod & tuxch999.flno between :line.f and :line.f






DevCorelli: # 13637 (BDUX7196): error handling in some situations not handled 
correct.

Date: Tue, 26 Mar 2002 14:21:39 +0100

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Running session "convert to runtime data dictionary" (ttadv5215m000) or "create runtime data dictionary" (ttadv5210m000).
When during the process the database gets full (error 523), the process goes on without an error on the screen, and a lot of records are lost.
Afterwards the temporary dump of the table is removed, and the process completes "successfully"

Workaround
change the size of the database.

Test Procedure
Testing this is very hard.
the situation where the error is occurring is if the database is full at the moment the record number being handled is a modules from an internal counter value, and that record is the one giving the error 523.
Internally the update actions are kept in a buffer. if the number of records in the buffer is the same as a predefined number ( in this situation 100 ) the records will be flushed to database ( not yet committed ) if during this action the error 523 is returned it is not handled correctly.
if the error is coming during the commit action, also done after every x number of records, there is a error returned and bdbreconfig will stop.






DevCorelli: # 13411 (BDUX7169): Error 215: Illegal state on Informix

Date: Wed, 27 Feb 2002 12:13:12 +0100

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
Error 215 : Illegal state on select for Informix Level 2

Workaround
Turn off the Prepare Statement Cache.
Set inf_use_prepare_cache:0 in $BSE/lib/defaults/db_resource

Test Procedure
Run the session tiitm0203m000 and delete a bunch of items.





DevCorelli: # 13207 (BDNT6978): BDB-API dll for Corelli on NT.

Date: Tue, 5 Feb 2002 11:54:10 +0100

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
After the installation of a new portingset error 511 (WRONG_VERSION) can
occur by using thirdparty-tools that are build with the (static) bdb-library.

Workaround
No workaround

Test Procedure
Generate the shdbapi.dll and check for errors.
Copy the shdbapi.ddl to the directory %BSE%\shlib.
Copy the shdbapi.lib to the directory %BSE%\api\lib.
Compile the three cameo example programs and link them to the generated shdbapi.dll.
Add the path of the shdbapi.dll to the PATH environment variable.
Run the three cameo example programs and check for errors.
Check specially what happens if the table ttexa100 in company 000 doesn't exist and cameo1 is started. The clear_table should fail and a create_table should be executed.





DevCorelli: # 13169 (BDUX6731): Oracle driver array fetching

Date: Thu, 31 Jan 2002 15:33:58 +0100

Created on:  MaintCorelli
Type:        bugfix

Problem Description (Customer terms)
a)  See also VHUX2666 for a similar problem.
Undefined behavior and erros due to data corruption
The problem only occurs with array fetching enabled and on queries with "array size"
or "buffer size" (rds_full) hint.
When the array size is bigger than 500 similar problems as reported in VHUX2666 might occur:
   At a customer site error ORA-972 occured because of the following SQL statement:
        SQL> SELECT . . .  FROM baandb.ttccom011101ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ a WHERE . . .
Application code checks indicate that array size hints of 1000 are passed in some queries.

b) the "array size" hint is only effective when the array interface is explicitely enabled.
Queries with a "array size" hint should always use array interfacing unless it is explicitely 
disabled in the hints.

Workaround
a) Disable array fetching. This means that the 0100000 flag should
not be set in the ora_init resource.

b) Enable array fetching. This means that the 0100000 flag should
be set. Please note that this might cause problem a) on queries that contain
array or buffer size hints.

Test Procedure
a) Run a query with a big array size hint on a table with a lot of rows ( > 10000 ).
DBSLOG=01000 ORA_INIT=0111000 qptool6.2 -c 0 -q "select * from ttadv999 hint array size 88888"
In the old situation all rows are fetched, and there will probably be problems as internal data is overwritten.
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 88888
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 14132
In the new situation the array size is limitted and there should be no errors
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 1000
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 1000

b) Without array size or buffer size (rds_full) hint there is no difference between the old and
new situation.

DBSLOG=01000 qptool6.2 -c 0 -q "select * from ttadv999 as set with 10 rows"
old and new: one row is fetched at the time
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 1
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 1 
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 1
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 1 
        ... ETC ...

DBSLOG=01000 ORA_INIT=0111000 qptool6.2 -c 0 -q "select * from ttadv999 as set with 10 rows"
old and new: rows are fetched in "ora_max_array_fetch" chunks
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 5
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 5 
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 5
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 5 

With hints there should be differences

DBSLOG=01000 qptool6.2 -c 0 -q "select * from ttadv999 as set with 10 rows hint array size 10"
old: one row is fetched at the time
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 1
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 1 
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 1
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 1 
        ... ETC ...

new: rows are fetched in "array size" chunks
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 10
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 10 


DBSLOG=01000 ORA_INIT=0111000 qptool6.2 -c 0 -q "select * from ttadv999 as set with 10 rows hint array size 10"
old: rows are fetched in "ora_max_array_fetch" chunks
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 5
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 5 
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 5
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 5 

new: rows are fetched in "array size" chunks
dbslog snapshot:
        SQL> ora_multi_fetch( 0x400e15f8 ) no_rows 10
        ora_multi_fetch( 0x400e15f8 ) done - rows fetched 10 






DevCorelli: # 13122 (BDUX6941): No BDB-API shared library for Siemens and OS390.

Date: Tue, 29 Jan 2002 12:06:24 +0100

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
After the installation of a new portingset error 511 (WRONG_VERSION) can
occur by using thirdparty-tools that are build with the (static) bdb-library.

Workaround
No workaround.

Test Procedure
Create in the directory "$BSE/api/examples/db" static cameo programs with
"make -f Makefile.SEQUENT static".
Move the cameo example programs to prevent overwriting.
Create in the same directory dynamic cameo programs with
"make -f Makefile.SEQUENT all".
Install a different portingset with the belonging shared DB-API library that
cause error 511 with the static cameo programs.
Set the environment variable LD_LIBRARY_PATH to define the path of the shared
libraries to $BSE/shlib.
Check that the dynamic cameo programs can run without error 511 with this
portingset.






DevCorelli: # 13061 (BDUX6894): Oracle 8.1.7 based driver

Date: Tue, 22 Jan 2002 12:31:45 +0100

Created on:  MaintCorelli
Type:        porting specific change

Problem Description (Customer terms)
Big performance difference on Tru64 between 8.0.x and 8.1.7 linked oracle driver.






DevCorelli: # 12993 (BDUX6803): Removed some duplicate code in sli library and 
removed AIX4.1 stuff.

Date: Thu, 17 Jan 2002 11:07:55 +0100

Created on:  ShuttleReger
Type:        bugfix

Problem Description (Customer terms)
Initially, this project was opened to check passing Environment variables to bshell (TCS call 100/122533), however
this bug could not be solved. During reproduce phase of this bug, some other minor things were discovered.

Workaround
N/A

Test Procedure
N/A (nothing changed functionally)





DevCorelli: # 12966 (BDNT6831): Scrolling down in a Grid with a total line

Date: Wed, 16 Jan 2002 08:18:08 +0100

Created on:  ShuttleReger
Type:        bugfix

Problem Description (Customer terms)
When scrolling down in a grid with a totalline, no additional record is
read/shown when scrolling down with the arrow-down key from the lowest record to
the totalsline.


Workaround
Use page-down.

Test Procedure
See problem description.





DevCorelli: # 12957 (BDNT6753): Domain Expressions: compute extremes

Date: Tue, 15 Jan 2002 14:22:12 +0100

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
Domain min and max are incorrect for integer and float domains with a domain expression

Test Procedure
see TCS call





DevCorelli: # 12948 (BDUX6789): problem with a generic unit

Date: Tue, 15 Jan 2002 09:05:24 +0100

Created on:  ShuttleReger
Type:        bugfix

Problem Description (Customer terms)
Format %AQ07,1 is not recognised.
It does appear in $BSE/lib/datecurr

Test Procedure
function main()
{
	double	a

	a = 3.44

	string	s(20)
	s = sprintf$("%AQ07,pcs", a)

	s = sprintf$("%AQ07,l", a)		| SHOULD WORK NOW
	s = sprintf$("%AQ50,cm", a)		| IDEM!
}








DevCorelli: # 12873 (BDUX6743): DB driver loops on DD retrieval

Date: Tue, 8 Jan 2002 13:10:16 +0100

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Hanging bshell on db.check.restricted() while bshell and DB-driver keep
on using CPU time.
When BDB_DEBUG=02 (database actions) has been enabled the logfile shows the
following actions:
	<- EXE_ROW_CNTR: Some DD missing: 0:
	<- EXE_ROW_CNTR: Some DD missing: 0:
	<- EXE_ROW_CNTR: Some DD missing: 0:
	<- EXE_ROW_CNTR: Some DD missing: 0:
	. . . Etc . . .

Test Procedure
See the reproduction scenario in Scopus DF111655
Please note the compnr mapping that is needed to reproduce the problem.





DevCorelli: # 12788 (BDUX6707): JIT compiler switch

Date: Thu, 3 Jan 2002 13:50:25 +0100

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
For debugging purposes it is needed to be able to switch off JIT compiler on HPUX.

Test Procedure
Put JAVA_JIT=0 in environment.
1. --set JAVA_JIT=0 in .bwc file
2. JAVA_JIT=0 in bse_vars file





DevCorelli: # 12749 (BDUX6691): Bdbreconfig changes

Date: Mon, 31 Dec 2001 15:10:32 +0100

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
bdbreconfig generates an unneeded error in the following situations:
- a newly defined table ( only a xxyyy999.new file present)
- a corrupt current DD file and a valid .new file

Test Procedure
Define a new table and run convert to runtime session.





DevCorelli: # 12627 (BDUX6596): Some problem with set.max

Date: Tue, 18 Dec 2001 11:16:15 +0100

Created on:  MaintReger
Type:        bugfix

Problem Description (Customer terms)
In remote cases set.max() returns incorrect results.

Workaround
use:
	long 	array.long(10)
	long	tmp.long.val

	tmp.long.val = array.long(1)

	set.max( tmp.long.val )
	
	array.long(1) = tmp.long.val

Test Procedure
Difficult.





DevCorelli: # 12578 (BDUX6618): Error 201 on Informix level-2

Date: Wed, 12 Dec 2001 15:30:42 +0100

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Error 1201 occurs when running session tdrpl0120m000. This occurs with
Informix level-2.

Test Procedure
Use qptool6.1 to execute the query described above. Execute the query on
a level-2 Informix database. Verify that the query returns the correct result
and that it does not return error 1201.





DevCorelli: # 12553 (BDNT6608): Paste in BECS when no environment selected

Date: Tue, 11 Dec 2001 15:59:10 +0100

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
Paste does not work in BECS when no environment selected.
Reproduction scenario:

-Select an environment
-select right mouse button -> copy
-paste becomes disabled as soon a no environment is selected


Workaround
Select the target environment before pasting.

Test Procedure
See problem description.





DevCorelli: # 12543 (BDNT6597): Edit field in Grid maxlen behaviour

Date: Tue, 11 Dec 2001 14:39:45 +0100

Created on:  DevReger
Type:        bugfix

Problem Description (Customer terms)
I can not change the description of existing companies.
Start session ttaad1100m000 and click somewhere in the description of 
company 911. Now enter some characters. Notice that the cursor is moving, but nothing
you type will get entered into the field. 


Test Procedure
See problem description.





DevCorelli: # 12530 (BDNT6593): Resource files updates

Date: Tue, 11 Dec 2001 11:56:15 +0100

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
Some strings where not in the resource file but hard coded.
Some spelling mistakes in resource texts.






DevCorelli: # 12407 (BDNT6473): Right mouse button in Edit grid

Date: Tue, 20 Nov 2001 11:24:40 +0100

Created on:  Reger
Type:        bugfix

Problem Description (Customer terms)
In an edit-grid session, when a record is marked and you click the right mouse 
button on the marked record, a menu should pop up, but is does not.


Workaround
Use main-menu.





DevCorelli: # 12405 (BDNT6471): Sound when pressing CNTRL key in Grid

Date: Tue, 20 Nov 2001 10:26:21 +0100

Created on:  Reger
Type:        bugfix

Problem Description (Customer terms)
When I use the shortcut-key <CTRL>-s to save one or more records, then I
hear a ping (BELL). When I save these records using the Save menu-option
or toolbarButton then I don't hear this.
This only happens in an editable grid when the keyboard focus is in an edit cell.

Test Procedure
See problem description.





DevCorelli: # 12282 (BDUX6321): Increased linked Oracle client library version

Date: Mon, 29 Oct 2001 11:37:51 +0100

Created on:  MaintBaanIVc
Type:        porting specific change

Problem Description (Customer terms)
Data corruption with drivers linked with 8.0.5.x or lower
Crash during session startup in a distributed environment with 8.0.6.2 or lower.

Workaround
Make max_array_insert not too high ( <= 20 )





DevCorelli: # 12215 (BDUX6247): exit code rcf and -i flag

Date: Thu, 11 Oct 2001 10:07:17 +0200

Created on:  Reger
Type:        bugfix

Problem Description (Customer terms)
Bdbreconfig can give an exit code of 1 when the end result is ok.

Workaround
No workaround

Test Procedure
Choose a table that doesn't exist for a certain company.
For example ttaad050 in company 001.
Run bdbreconfig without and with the -i flag and test the exit code.

$ bdbreconfig6.2 -Z -N ttaad050 -C 001
$ echo $?
1
$ bdbreconfig6.2 -i -Z -N ttaad050 -C 001
$ echo $?
0





DevCorelli: # 12190 (BDUX6209): Oracle driver returns wrong results on blank 
SUBSTR() expr

Date: Fri, 5 Oct 2001 17:10:18 +0200

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
The Oracle level-2 drivers returns wrong results on queries
containing a SUBSTRING expression.

Test Procedure
cd /vobs/db/test/SQLREG/qptst
REL=6.1 ./chk -t tests/blank_padding

Using the old driver results in:
	Unexpected result for query tests/blank_padding/007b.query             
	Unexpected result for query tests/blank_padding/007c.query             
	Unexpected result for query tests/blank_padding/007d.query              
	Unexpected result for query tests/blank_padding/008b.query             
	Unexpected result for query tests/blank_padding/008c.query             
	Unexpected result for query tests/blank_padding/008d.query              
	6 test(s) failed:
		Wrong result:
			tests/blank_padding/007b.query
			tests/blank_padding/007c.query
			tests/blank_padding/007d.query
			tests/blank_padding/008b.query
			tests/blank_padding/008c.query
			tests/blank_padding/008d.query

Using the new driver with fix results in:
	Okay
	





DevCorelli: # 12177 (BDUX6203): load of libjava fails

Date: Thu, 4 Oct 2001 13:20:51 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
Customer will be deploying Corelli on HPUX 11.0 and Oracle 8.1.7.
This version of Oracle requires java version 1.2.
Please rebuild the bshelljava6.2 to support the above environment conditions.
Also perform the link on the bshell to insure the shared library list are all dynamic.
The current release of the bshelljava6.2 (7.1c PA1612) the libjava.sl has a static library designation.
We are currently trying to use the PA1612 version that appears to have been built on HPUX 10.20 using java 1.1 and cannot get it to run on HPUX 11 with java 1.2 libraries.
It also gets the error "/usr/lib/dld.sl: Unresolved symbol: pthread_mutexattr_init (code)from /opt/java1.2/jre/lib/PA_RISC/classic/libjvm.sl" before core dumping.The pthread_mutexattr_init is in the /usr/lib directory but the dynamic loader cannot find it when trying to start Baan object otmboaserver from run program within bshellorb6.2

Workaround
When using a PA_8000/PA_RISC2.0 portingset substitute "green_threads" by "native-threads"
When running on a PA_RISC machine substitute PA_RISC2.0 by PA_RISC

# Create a "JDK1.1 like" directory
$ mkdir -p /opt/java/lib/PA_RISC/green_threads

# Create a softlink to the JDK1.2 shared library
$ ln -s /opt/java1.2/jre/lib/PA_RISC/libjava.sl /opt/java/lib/PA_RISC/green_threads/libjava.sl

# add some additional paths to SHLIB_PATH
# add next line to $BSE/lib/bse_vars
# when it has already a SHLIB_PATH line, append the path. (Do not use $SHLIB_PATH in bse_vars)
SHLIB_PATH=original_SHLIB_PATH_value:/opt/java1.2/jre/lib/PA_RISC2.0/classic:/opt/java1.2/jre/lib/PA_RISC2.0

# In stead of using bse_vars it is also possible to create a script which is called by ipc_info

#!/bin/ksh
export SHLIB_PATH=$SHLIB_PATH:/opt/java1.2/jre/lib/PA_RISC2.0/classic:/opt/java1.2/jre/lib/PA_RISC2.0
$BSE/bin/bshelljava6.2 $*

Test Procedure
Be sure the mentioned patches are installed.
Install JRE1.2 or JDK1.2 .
Be sure environment variables SHLIB_PATH (HPUX), LIBPATH (AIX) or LD_LIBRARY_PATH (other) points to the directories with libjvm.a, libjava.a, libjvm.so, libjava.so, libjvm.sl or libjava.sl .
$BSE/lib/bse_vars contains for example:
SHLIB_PATH=/opt/java1.2/jre/lib/PA_RISC2.0/classic:/opt/java1.2/jre/lib/PA_RISC2.0
LIBPATH=/usr/java/jre/bin/classic:jre/bin
LD_LIBRARY_PATH=/usr/opt/jre130/lib/alpha/classic:/usr/opt/jre130/lib/alpha
LD_LIBRARY_PATH=/usr/java/jre/lib/sparc

Run Program otmboaserver





DevCorelli: # 12172 (BDUX6099): Oracle driver supports ANSI query syntax

Date: Wed, 3 Oct 2001 15:32:03 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
Oracle9 supports ANSI syntax for queries.

Test Procedure
Use the following query (test 040a from New QP regression test):
	select *
	from dbtst120 b, dbtst190 a
	where a.empno refers to b.empno

run:	DBSLOG=0400 ANSI_OUTER_JOIN=0 qptool6.2 -c 0 -f 040a.query
the file dbs.log will contain the following Oracle query:
	SELECT . . .
	FROM	baan.tdbtst190000 a,baan.tdbtst120000 b
	WHERE	b.t$empno (+) = a.t$empno

run:	DBSLOG=0400 ANSI_OUTER_JOIN=1 qptool6.2 -c 0 -f 040a.query
the file dbs.log will contain the following Oracle query:
	SELECT . . .
	FROM ( baan.tdbtst190000 a LEFT JOIN  baan.tdbtst120000 b ON b.t$empno = a.t$empno)





DevCorelli: # 12064 (BDUX6090): Use Oracle9 timeout feature SELECT ... FOR 
UPDATE WAIT 

Date: Mon, 17 Sep 2001 17:04:05 +0200

Created on:  DevCorelli
Type:        enhancement

Problem Description (Customer terms)
Make use of the new  SELECT ... FOR UPDATE WAIT 999 feature of Oracle 9.

Test Procedure
Make the following gcommand script (gc):
#1 dbtst100	RFIRST*	0
#2 dbtst100	RFIRST*	0 -ELOCKED

Run the following command:
ORAPROF=1 DBSLOG=01400 ORA_TIMEOUT={5,1,1,1,0} LOCK_RETRY=0 gcommand6.2 gc 0

When connected to an Oracle9 database the following output is expected:
    oraprof
	Time (multi_exec) : 5.138838 seconds
	SELECT . . . . FOR UPDATE WAIT 5
    commlog
	#1 dbtst100 RFIRST*   0
	#2 dbtst100 RFIRST*   0 bdb_errno = LOCKED  --> ok
    dbs.log
	>> No alarm handling in the logfile

When connected to an Oracle8 database you should see the old behavior:
    oraprof
	Time (multi_exec) : 6.020027 seconds
	SELECT . . . . FOR UPDATE
    commlog
	#1 dbtst100 RFIRST*   0
	#2 dbtst100 RFIRST*   0 bdb_errno = LOCKED  --> ok
    dbs.log
	ora_interrupt done.
	ora_alarm_signal_handler called : ret 0.





DevCorelli: # 12031 (BDNT6057): CNTRL TAB not correctly passed when focus on 
Grid

Date: Tue, 11 Sep 2001 11:11:56 +0200

Created on:  Reger
Type:        bugfix

Problem Description (Customer terms)
When opening session "Project Template Codes", you cannot use the "CNTRL
TAB" to go to another tab anymore. Other sessions like tppdm6500m000 do
not have this problem.


Workaround
Use mouse to switch to another TAB

Test Procedure
See problem description





DevCorelli: # 12022 (HYNT6013): Error 0 Msg

Date: Fri, 7 Sep 2001 12:20:22 +0200

Created on:  DevCorelli
Type:        bugfix

Problem Description (Customer terms)
SQL Statement	"select avg(edlevel) from dbtst120 where empno < 0 " fails giving Error 0 Msg


Test Procedure
Execute the above select statement with new driver.