Page 1 of 1

Licence Warning

Posted: Fri Apr 23, 2010 12:23 pm
by michel.weber
Hi

I have had a warning for several days now saying that we exceeded the licence limit of 500000 docs.
In fact it was the querylog table of one of our profiles.
I have cleaned it out (<10 000 records) but the licence warning persists.

Do i have to do something else ?

NB.: this is an 'open' appliance, and i deleted the rows with tsql.

Licence Warning

Posted: Fri Apr 23, 2010 12:48 pm
by mark
Once the metamorph index updates on the violating table the violation should clear itself after a day. Make sure any metamorph index on that table is up to date and that there are no other violating tables.

For reference the standard way to reduce the query log is to use query log rotation.

Licence Warning

Posted: Fri Apr 30, 2010 6:29 pm
by michel.weber
The warning still has not gone away, after looking at the tables, the only one i can find with more than 500000 rows is the error table in our biggest profile.

How can i get the number of rows down in that table?

Licence Warning

Posted: Mon May 03, 2010 10:46 am
by mark
The error table shouldn't have a metamorph index. Look for tables with metamorph index on them.

You can look in SYSSTATISTICS to see what texis thinks about the row counts.

Licence Warning

Posted: Tue May 04, 2010 12:14 pm
by michel.weber
According to SYSSTATISTICS the querylog table still contains over 500 000 records.

Te querylog is set to cycle every night. (i get the e-mail every night and the last had 1200 lines

I have already rebuilt the indexes on the the profile via /rebuild.txt.

Licence Warning

Posted: Tue May 04, 2010 1:35 pm
by mark
That doesn't update the index on querylog. Try dropping
that index. It will be automatically rebuilt when needed.

"drop index xmmquerylogInfo"

Licence Warning

Posted: Tue May 04, 2010 3:59 pm
by mark
An alternative would be to visit the query report which would force an update of that index.

Licence Warning

Posted: Thu May 06, 2010 12:23 pm
by michel.weber
Alls back to normal.

Thanks