Skip to content

HOW TO INCREASE MAX STORAGE LIMIT FOR QUERY HISTORY CONFIGURATION?

HOW TO INCREASE MAX STORAGE LIMIT FOR QUERY HISTORY CONFIGURATION?

NOTE: hist_disabled is the QHIST configuration which will not collect anything. And ALL_HIST is supposed to be the configuration that you want to change. please change the names as per your setup.

1) nzsql -c “SET HISTORY CONFIGURATION hist_disabled”

2) nzstop

3) nzstart

In below step we are increasing the limit to 10GB
4) nzsql – c “ALTER HISTORY CONFIGURATION ALL_HIST STORAGELIMIT=10000”

5) nzsql -c “SET HISTORY CONFIGURATION ALL_HIST”

6) nzstop

7) nzstart

8) Once system is back online run below command to make sure history configuration is changed to ALL_HIST
nzsql -c “SHOW HISTORY CONFIGURATION”

Not able to approve datalab – Viewpoint

Issue:

Cannot approve any new Datalabs request as well as cannot add any user to a datalab.
Error:

Your request has failed. The supplied string array has null, empty, or blank (all whitespace) elements, or is null or empty itself.
You may also see any Datalab approval just hanging and not completing or throwing any error..
Resolution:

When you look at viepoint log file located at /opt/teradata/viewpoint/portal/logs/viewpoint.log you will see errors like below:

2015-10-11 11:11:50,596 ERROR [http-nio-9080-exec-4] {context=/DataLabsPortlet, user=admin} impl.JaxbMessageSender.getHostName(336) – Could not get host name.
Just add the hostname to the host file (/etc/hosts) to resolve the issue:

127.0.0.1 localhost ViewPointServername_VP
NOTE:
You will probably see this issue after upgrading to viewpoint version 15.10.00.07