Troubleshooting
Problem
Setting the parameters UseSQLFetch = T in the tm1s.cfg causes verbose log file entries in tm1server.log..
Symptom
Info messages similar to this seen in log:
16666 [52d] INFO 2014-8-8 10:14:21.265 TM1.SQLAPI fetched 1 row
Cause
Using parameter UseSQLFetch = T
Resolving The Problem
Two options:
1. In the tm1s-log.properties file add the following lines:
log4j.logger.TM1.SQLAPI=OFF
log4j.logger.TM1.Sql=OFF
OR
2. In the tm1s.cfg set the following:
UseSQLExtendedFetch=T
Note: option 2 may have a slight performance hit as compared to
UseSQLFetchScroll
[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF010","label":"HP-UX"}],"Version":"9.5.2;9.5.1;9.5;10.1.0;10.1.1;10.2;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21681325