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 31st October 2002, 19:08
mraja71 mraja71 is offline
Junior Member
 
Join Date: Jan 2002
Location: USA
Posts: 22
mraja71 is on a distinguished road
Baan: BaanERP5 5.0c - DB: Oracle - OS: Unix
Question SQL Trace

I am using the Sql Trace option to trace on the baan seesions using the set commands in the bw client

The dbs log trace gives me the query output but not the actual values passed to that query. Our database is sql2000 and
type 1 driver. Is there is any way I can catch the actual values passed to the query in the trace options. I have attached the
sample output i am seeing on the trace log file.

1524> 2002-10-31[09:55:30]: Logging started mode 04460
---- LOG TABLE INFO [0000020] ----
---- LOG DB INFO [0000040] ----
---- LOG SQL INFO [0000400] ----
---- LOG DUB INFO [0004000] ----



1524> baan [41]--------- D_START_TRANS on session ------------


SQL> {call dbo.Pttfgld430400_1( ?, ? )}


SQL> {call dbo.Pttfgld014400_1( ?, ? )}


SQL> {call dbo.Pttfgld014400_1( ?, ? )}


SQL> UPDATE dbo.ttfgld014400 SET t_year = ?, t_lbno = ?, t_prun = ?, t_Refcntd = ?, t_Refcntu = ?, hash1 = ? WHERE hash1 = ?


SQL> {call dbo.Pttfgld100400_1( ?, ? )}


SQL> {call dbo.Pttfgld006400_1( ?, ? )}


SQL> INSERT INTO dbo.ttfgld100400 (t_year, t_btno, t_stat, t_user, t_tedt, t_trdt, t_itbc, t_fprd, t_rprd, t_vprd, t_vyer, t_bref, t_btyp, t_trun, t_tstt, t_selt, t_Refcntd, t_Refcntu, hash1, hash2, hash3, hash4, hash5) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Reply With Quote
  #2  
Old 31st October 2002, 21:17
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
Hi mraja71 - I recently had to figure the same thing out.

I used DBSLOG=0100, then in the dbs.log file I searched on the "“DBMS Update Input” phrase, there it gave me the exact record it was "trying" to insert in my table.

Attached is a good doc on tracing.
Attached Files
File Type: pdf baaniv tracing.pdf (510.2 KB, 196 views)
__________________
NR

Last edited by patvdv : 10th August 2005 at 23:36.
Reply With Quote
Sponsored Links
  #3  
Old 5th November 2002, 15:41
guilmor's Avatar
guilmor guilmor is offline
Member
 
Join Date: Sep 2002
Location: Spain
Posts: 50
guilmor is on a distinguished road
Baan: Baan IVc4, BaanERP - DB: Oracle - OS: Windows NT Server/2000
Arrow Try this:

Hello mraja71

You need row information, so you should add value 010 to your DBSLOG value. I think 04470 should be useful.

Guilmor
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
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11


All times are GMT +2. The time now is 13:41.


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