Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Add SQL in Configuration.LoggedEvents
Mon, Apr 8 2019 5:41 PMPermanent Link

Yusuf Zorlu

MicrotronX

if we have error 700 with a problem in sql, we want to see the SQL, at the moment we see only the error i.e.

An error was found in the statement at line 1 and column 89 (Expected Date or Timestamp expression but instead found '08.04.2019')

but which sql was that? With enabled customer side scripts we need more information to find the problematic sql.

thanks a lot,

Yusuf Zorlu
MicrotronX
Wed, Apr 17 2019 2:28 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Yusuf,

<< if we have error 700 with a problem in sql, we want to see the SQL, at the moment we see only the error i.e.

An error was found in the statement at line 1 and column 89 (Expected Date or Timestamp expression but instead found '08.04.2019')

but which sql was that? With enabled customer side scripts we need more information to find the problematic sql. >>

The logged events use a fixed-size record format in order to allow for a circular queue, so the SQL is not logged with the events.

If you want to find out the exact SQL that is causing a problem, you can enable tracing on the server:

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Starting_Configuring_Server

(Trace* settings in the edbsrvr.ini file toward the bottom under "Configuration Reference")

to find out which SQL is causing the problem.

However, it should be pretty clear in your development setup which script/statement is causing the problem.  Are you allowing customers to write scripts, themselves ?

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Apr 18 2019 2:34 AMPermanent Link

Yusuf Zorlu

MicrotronX

Tim Young [Elevate Software] wrote:

<< However, it should be pretty clear in your development setup which script/statement is causing the problem.  Are you allowing customers to write scripts, themselves ?

Yes, customers can write their own scripts and we have also "Triggers" where they can change existing queries i.e. for tableviews ...

Yusuf Zorlu
MicrotronX
Wed, Jun 19 2019 4:48 AMPermanent Link

Yusuf Zorlu

MicrotronX

Hi Tim,

an news if this will be possible with one of your next updates?
Yusuf Zorlu
MicrotronX
Image