DAL in Debugger

DAL, Data Access Layer is a new concept introduced in higher versions of Baan, from Baan V onwards. The very reason of introducing the same, was to have a common platform to write all the common Business Logics, and operations occurring on a table, rather than having the logics scattered in functions, scripts and libraries. This brought to the table a very convenient way of addressing logical changes which happens over time period. So going forward if any changes have to be addressed on a specific table we just have to traverse through the DAL of that table and check the existing logic and then build your logic on top of it or replace the existing logics.

All said and done, debugging a DAL is pretty much easy as debugging any script, library or any other functions.

I am not sure if you have encountered a problem where in you put the DAL in debug mode using the following approach.

Select the table for which the DAL has to be debugged using session table definition, ttadv4520m000.

Double click on the selected table, the following session will open. Here select the appropriate VRC and then click on debugger icon.


Select the appropriate VRC and Right click and select the Compile with Options -> Debugger.

This will put the DAL object in debugger mode.

Now to test whether DAL is in debugger mode, Open General Table Display (ttaad4500), find the table in GTD and ensure DAL is active and in choice input ‘Y’(if user language is English).

If DAL object is in debug mode, then when you input ‘Y’ in the choice field, a debugger screen will open.

In few cases the debugger screen might not open, the reason behind this would be the DAL object might not have gone in to debug mode, when you carried out the above steps.

The Solution to this, when you are compiling the DAL script in debugger mode, ensure that all instances of the table should be closed i.e.

a)      General Table maintenance with the table opened

b)      General Table Display with the table opened

c)      Any session accessing the DAL table

d)      Any function/libraries accessing the DAL table

e)      Any third party applications accessing the DAL table

f)       Any software components accessing the DAL table

We need to ensure any instances of the above probabilities are closed on the server where you are planning to put the object in debugger mode.

In case of UNIX OS, you can use grep the processes which are being run on the server to ensure that no other person is accessing any software components related  to the DAL table under considerations are closed.

Once all instances are closed, you can then go and debug the object as specified in the step above. This will ensure the debug object is created and you can then use the debugging option in the debugger screen to debug the issue step by step or with breakpoints whichever appropriate.

If you have faced similar issues and if there is any better method to trace the users using the components which has dependency on the table, then please use this medium to share across your experience. This will hugely benefit people in Baan World.


  1. Thank you a bunch for sharing this with all people you really know what you’re talking approximately! Bookmarked. Kindly also talk over with my site =). We may have a link exchange arrangement among us!… In addition, I suggest you must include information about web solutions… Thanks so much…


  2. I simply want to mention I am just new to weblog and absolutely liked this blog site. Almost certainly I’m planning to bookmark your blog post . You actually come with perfect article content. Thanks for sharing your web page.


  3. Hey, I think your blog might be having browser compatibility issues. When I look at your blog in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog! just click for source


  4. I have to show some appreciation to you for bailing me out of this particular circumstance. Because of browsing through the the net and seeing ways which are not beneficial, I assumed my life was over. Being alive devoid of the answers to the difficulties you’ve resolved as a result of your good website is a crucial case, as well as the ones which may have in a wrong way affected my entire career if I had not noticed your web page. Your own know-how and kindness in maneuvering every item was precious. I’m not sure what I would have done if I had not come upon such a thing like this. I can at this point look ahead to my future. Thanks for your time so much for your professional and sensible guide. I won’t hesitate to suggest your web sites to anyone who should receive direction about this subject matter.


  5. Excellent read, I just passed this onto a colleague who was doing some research on that. And he just bought me lunch since I found it for him smile Thus let me rephrase that: Thank you for lunch!


  6. I have study some excellent stuff here. Undoubtedly worth bookmarking for revisiting. I wonder how lots attempt you put to create this sort of excellent informative web web-site.


  7. Have you ever thought-about including extra videos to your weblog posts to maintain the readers extra entertained? I imply I just examine by the entire piece of writing of yours along with it was quite good quality but since I’m extra of a visual learner,I discovered that to be more helpful properly let me recognize how it seems! I genuinely like what you guys are all the time up extremely. Such form of clever work as well as reporting! Sustain the excellent works guys I’ve added you guys to my blogroll. It is a terrific piece of writing thanks for sharing this informative information.. I’ll go to your weblog repeatedly for various latest post. Anyway, in my language, there are typically not a lot good quality source comparable this.


  8. Thanks for sharing excellent informations. Your site is so cool. I am impressed by the details that you have on this website. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for extra articles. You, my friend, ROCK! I found just the information I already searched everywhere and just couldn’t come across. What a perfect site.


  9. Fantastic website. Plenty of useful information here. I am sending it to a few friends ans also sharing in delicious. And naturally, thanks for your effort!


  10. It’s really a nice and helpful piece of information. I am glad that you shared this helpful info with us. Please keep us informed like this. Thanks for sharing.


  11. Hi, Neat post. There is a problem along with your web site in web explorer, may check this… IE nonetheless is the marketplace leader and a large section of other folks will pass over your magnificent writing because of this problem.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s