|
After calling the sa_get_request_times procedure, the satmp_request_hostvar table has only the first hostvar of each statement. Looking at the original request log file, all the host variables are there. It looks like sa_get_request_times is only considering the first one. I reproduced this error in two different database versions: SA_1600_2127 and SA_1700_2053. Am I doing something wrong or should I just open an incident for the SA_17 version? Commands used to activate the request logging: call sa_server_option( 'RequestLogging', 'SQL+hostvars'); call sa_server_option( 'RequestLogFile', '..\\requests.sql'); call sa_server_option( 'RequestLogMaxSize', 50000000); Command used to analyze the generated request log file: call sa_get_request_times('..\\requests.sql.old');
Thanks in advance. |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 27 Oct '20, 15:16
question was seen: 1,953 times
last updated: 13 Nov '20, 07:50
Have you tried with a more current release since both versions are > 4 years old?
Not yet. I am trying to download the build 6175, but I got a message that the file is locked by SAP Export Department for processing. So I am waiting for this. Once I get this build, I will do the tests and report here.
Hi Chris. I tested the SQL Anywhere 17 build 6175 and noticed the same behavior. The procedure still considers only the first hostvar value.
Should I open an incident for this version?