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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 25th October 2016, 14:12
ramanasree.v ramanasree.v is offline
Junior Member
 
Join Date: Dec 2013
Posts: 3
ramanasree.v is on a distinguished road
Baan: Baan4, LN - DB: oracle - OS: Windows 7
Error 2000 (bdb_errno 2000) in db.first
Baan: Baan IVc
C/S: Client

Hi,
Hi,
I am getting below fatal error in db_first.

Quote:
Fatal error: Error 2000 (bdb_errno 2000) on tdilc900404 in db_first
Fatal error: Can not continue in tdslso950m000 (<26>)[db.first]
Corresponding code is:

Code:
function open.archive.ilc900()
{
        long    row_length
        string  buffer  based

        lfn.sls.orig=db.bind("ttdilc900")
        db.row.length(ttdilc401,row_length)
        alloc.mem(buffer,row_length)
        db.columns.to.record(ttdilc900)
        buffer = rcd.ttdilc900
        lfn.sls.arch = db.bind ("ttdilc900",rcd.ttdilc900,arch.comp)

        if  db.first (lfn.sls.arch) =        enotable then
                commit.transaction()
                if db.create.table (lfn.sls.arch) then
                        mess("tcmcss0346",1,"ttdilc900")
                        exit()
                endif
        endif
        rcd.ttdilc900 = buffer
        db.record.to.columns(ttdilc900)
}

Any idea how to avoid this fatal error? I searched on net but didnt get any relevant information.

Last edited by bhushanchanda : 25th October 2016 at 14:29. Reason: Added code tags
Reply With Quote
  #2  
Old 25th October 2016, 14:33
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
You may try unbinding the first db.bind() if the companies are same.

Also, I see you are directly passing table codes to db.columns.to.record() and db.row.length() instead of the id obtained by db.bind(). Try modifying these parts and I guess it should not be an issue anymore.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
  #3  
Old 1st December 2016, 11:39
ramanasree.v ramanasree.v is offline
Junior Member
 
Join Date: Dec 2013
Posts: 3
ramanasree.v is on a distinguished road
Baan: Baan4, LN - DB: oracle - OS: Windows 7
db.unbind is not used since both are different companies. I tried passing the return variable from db.bind to the functions you mentioned. But it didn't work. It gave the same fatal error.
Reply With Quote
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
Question Regarding Data Conversion From Oracle 7.3.4 to MS-SQL 2000 terryw Operating Systems & Databases 0 5th November 2003 22:14
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 14:22
New Install SQL 2000 & Win 2000 IKGPAT Operating Systems & Databases 3 13th March 2003 11:48
Trying to authenticate Win 2000 users on domain sarosh Tools Administration & Installation 1 23rd September 2002 15:07
Baan IVc2 BackOffice with Windows 2000 grobbiano Tools Administration & Installation 1 1st August 2002 12:25


All times are GMT +2. The time now is 14:09.


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