SAP Knowledge Base Article - Preview

2786465 - When read ZR log output, 'sa_get_request_times' does truncate more than 65515 characters -- SAP IQ

Symptom

Customer needs to audit all SQL statements using "-zr SQL+hostvars" to log everything on 16.0 SP11 p20. They have statements with more then 100.000 characters and when we take a look at the server request log file, the statement is completely in the file. But when read the file with 'sa_get_request_times', the statement in the temporary table satmp_request_time is truncated after 65515 characters.

It looks anything over 32KB needs a LOB license as that is considered long varchar/long varbinary data, but given neither you nor me get any error or message about the truncation.  Is there a resolution or Work-around ?


Read more...

Environment

SAP IQ 16.0 SP11.x

Product

SAP IQ 16.0

Keywords

sa_get_request_times , truncate , CR819000, 819000, , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.