|
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. |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
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: 2,340 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?