Licence Warning

Post Reply
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

Licence Warning

Post 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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Licence Warning

Post 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.
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

Licence Warning

Post 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?
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Licence Warning

Post 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.
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

Licence Warning

Post 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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Licence Warning

Post by mark »

That doesn't update the index on querylog. Try dropping
that index. It will be automatically rebuilt when needed.

"drop index xmmquerylogInfo"
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Licence Warning

Post by mark »

An alternative would be to visit the query report which would force an update of that index.
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

Licence Warning

Post by michel.weber »

Alls back to normal.

Thanks
Post Reply