Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th December 2003, 14:46
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
bdb_errno 215

Hi,
Has anyone seen this error? We got this session today when trying to open some sessions. I see that there is a thread on this board which kinda talks about this error but it did not help me much.

******* S T A R T of Error message *******
Log message called from /port.6.1c.03.01/vobs/tt/ba/ba/baerrhand.c: #115 keyword: bshell message
Pid 799 Uid 3290 Euid 3290 Gid 47 Egid 47
user_type S language 2 user_name fawaz100 tty locale ISO88591/NULL
Errno 0 bdb_errno 0
Log_mesg: Error: bdb_errno 215 on ttadv999
^M
******* E N D of Error message *******

Appreciate your help.

Thanks,
NS
Reply With Quote
  #2  
Old 17th December 2003, 20:49
nick_rogers nick_rogers is offline
Senior Member
 
Join Date: Feb 2002
Location: Toronto, Canada
Posts: 249
nick_rogers is on a distinguished road
Baan: BaanIVb2 - DB: Oracle 7.3 - OS: Unix 11
215 EDBDILLEGAL - Illegal internal condition

--------------------------------------------------------------------------------
Description:
This error indicates an illegal internal state in the BaanERP database layers that should never occur.
Solution:
Carefully note a reproduction scenario that leads to the error and log a case in Baan's support system
__________________
NR
Reply With Quote
  #3  
Old 17th December 2003, 20:55
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Thanks Nick
Reply With Quote
  #4  
Old 18th December 2003, 05:14
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
check this solution

VERSION(S):
BaanIVc
iBaanERP5.0b
iBaanERP5.0c
iBaanERP5.2a

SITUATION IDENTIFIED IN:
Configuring storage of audit data.


SITUATION DESCRIPTION:
Using a special format for the database definition you can specify that the audit data should be stored on a remote server.

A typical situation would be a configuration existing of one or more Application Servers and a Database Server, containing a centralized location of your storage of your audit data.

The endusers usually log on to Baan via the Application Server. At the Application Server the bshell processes are running, and depending on the way things are configured, the database driver process runs also on the Application Server or on the Database Server.

The Database Server has also a BSE environment installed, so it would be possible to log in Baan via the Database Server as well.


SOLUTION DESCRIPTION:
This solution specifies how the format of an entry in the file $BSE/lib/tabledef6.x should to setup remote storage of audit data. (Regarding BaanIV, take notice of Note 2. "Availibility of the format for remote audit setup for BaanIVc")

The generic format of an entry in the $BSE/lib/tabledef6.x at the Application Server is:

<tablename>:<company nr>:<database type>[(parameters)]:<name of remote
system>

E.g.: cpcom000:100:informix(INFORMIXSERVER=ol_srv_nld_test1,INFORMIXSQLHOSTS=\\SRV
_NLD_TEST1):srv_nld_test1


And at the Database Server, the file $BSE/lib/tabledef6.x contains the standard format. So for this example:

E.g.: cpcom000:100:informix(INFORMIXSERVER=ol_srv_nld_test1,INFORMIXSQLHOSTS=\\SRV
_NLD_TEST1):Y

At the Application Server the 4th column (also the last column) specifies now the name of the remote system. Because it does not contain a "Y" or "N" now, but the name of the remote system, the bshell will replace the name of the remote system for: &<name of remote system>!audit:N (This is according the old format, refer to NOTE 3).

An audit driver will be started at the remote server specified, and therefore the audit data is stored also at the remote server. (According the paths as specified in the file $BSE/lib/auditdef6.x at the remote server). So the tabledef6.x at the remote server is not read in this case.


NOTES:
1) Do not share directories / file system to enable multiple BSE environments to write their audit data to the same location.

The way this solution describes is the correct way of setting up centralized storage of the audit data, to keep the audit data consistent. It is not supported that multiple audit drivers, running at seperate, multiple BSE environments all write to same audit files via a shared directory or file system. This is because information regarding unique audit id's are maintained in shared memory. In that case each BSE environments maintains it own unique audit id's in its own shared memory. In this way it can happen that, when storing audit data, unique id's are messed up. This does not happen when audit data is written only from one BSE environment, like happens when configuring tabledef6.x in the way explaned in this solution.


2) Availibility of the format for remote audit setup for BaanIVc (For iBaanERP this format was already available)

The format, as described in this solution, became at a later stage available for BaanIVc. For BaanIVc this format is supported from portingset 6.1c.07.01 and higher


3) Alternative format of remote audit storage setup.

There is also another format of specifying remote audit storage setup. This format is somewhat more comprehensive to use.

This format is:
<tablename>:<company nr>:<database type>[(parameters)]&<name of remote
system>!audit:N

Because of a bug, this format did not work on BaanIVc, and resulting in Error 215 (Illegal state). This bug is solved in portingset version 6.1c.07.01 and higher

4) Testing
Using function rdi.audit.hosts() you can test whether the correct remote system is used for storing audit data.

function main()
{
string tname(16)
string audhost(255)
long ret
long company

tname = "tdilc301"

company = 100
ret = rdi.audit.hosts( tname, company, audhost )
message( sprintf$( "%d %-18s (ret %d) ", company, audhost, ret ) )
}


============================================================================
==============================================
Below is the explanation of the defect solved in porting set 6.1c.07.01.


PROBLEM DESCRIPTION :
Error 215 (Illegal state) on t
(example tdilc301210) in lock_table, when remote audit is setup on application-server

Details: Customer has setup remote auditing on application-server, that all auditing was done centralized on DB-server. Example with table tdilc301210 tabledef6.1 (app-server):
tdilc301:210racle8(ORACLE_HOME=c:\orant,ORACLE_SERVICE_NAME=BAANIVC.WORLD)
&HMBBCLUA!audit:N
tabledef6.1 (db-server HMBBLUA): tdilc301:210racle8(ORACLE_HOME=c:\oracle\ora81,ORACLE_SID=BAAN):Y

If they run now a session on application-server which makes a
db.lock.table(ttdilc301) you get this error: Fatal error: Error 215 (Illegal
state) on tdilc101210 in lock_table

When they remove the remote setup (&HMBBCLUA!audit) that auditing works again local on the application-server, everything is fine.

By the way: On both servers is PS 6.1c.06.05 installed. I checked terra, but no issue found regarding to latest PS 6.1c.06.06

SPECIFIC PARAMETER SETUP :

STEPS TO BE FOLLOWED :
To get this easily reproduced I have created a 3GL-script with contents:

function main()
{
table ttdilc301

db.lock.table(ttdilc301)

commit.transaction()

message("testlock done")
}

and have compiled this as session otdilclocktest at the application-server. So simply running that session there results in the error

OBSERVED RESULT :
remote auditing with db.lock.table does not work

EXPECTED RESULT :
remote auditing with db.lock.table should work.

IMPACT ON CUSTOMERS :
remote auditing with db.lock.table does not work


************END OF SOLUTION *************

We did encounter this error once only. The problem appears to have been resolved in 6.1c.07.01 with changes in tbaledef6.1 .

Hope this helps.
Reply With Quote
  #5  
Old 18th December 2003, 21:21
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Thanks for your help Hitesh.
Reply With Quote
  #6  
Old 18th December 2003, 21:34
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
bdb_errno 509...

Hi,
I was wondering if the following error is anyway related to the bdb_errno 215?

2003-12-18[15:05:18]:E:flaschmp: ******* S T A R T of Error message *******
2003-12-18[15:05:18]:E:flaschmp: Log message called from /port.6.1c.03.01/vobs/tt/mir/ds_link/li_init.c: #351 keyword: ds_close_server
2003-12-18[15:05:18]:E:flaschmp: Pid 27477 Uid 3687 Euid 3687 Gid 96 Egid 96
2003-12-18[15:05:18]:E:flaschmp: user_type N language 2 user_name flaschmp tty ote locale ISO88591/NULL
2003-12-18[15:05:18]:E:flaschmp: Errno 0 bdb_errno 509 (Bad memory cursor; bad table pointer specified)
2003-12-18[15:05:18]:E:flaschmp: Log_mesg: Detected Display Server Termination
2003-12-18[15:05:18]:E:flaschmp: ******* E N D of Error message *******

Both the errors seem to happen rarely although they don't seem to appear one after the other.

Please let me know if you guys have any ideas.

Thanks,
NS
Reply With Quote
  #7  
Old 19th December 2003, 07:11
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
509

We do have a case pending with Baan support for error 509 . We made normal users to super users. Then the incidence of error 509 reduced to some extent. Ours is porting set 6.1c.07 and users use windows 98.
Reply With Quote
  #8  
Old 19th December 2003, 20:07
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Thanks Hitesh
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
error 215 tianalita Tools Development 4 30th July 2003 21:19


All times are GMT +2. The time now is 04:07.


©2001-2017 - Baanboard.com - Baanforums.com