Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
Add SQL in Configuration.LoggedEvents |
Mon, Apr 8 2019 5:41 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Yusuf Zorlu MicrotronX | Hi Tim,
an news if this will be possible with one of your next updates? Yusuf Zorlu MicrotronX |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |