VMware Cloud Community
TheChristoph
Contributor
Contributor

sqlquery-plugin

I have written a selfmade SQL-Query-PlugIn after this example:

http://support.hyperic.com/display/DOC/SQL+Query+Plugin

If I try to deploy the plugin I got this error:

ERROR [ScannerThread] [org.hyperic.hq.measurement.server.session.TemplateManagerEJBImpl] Unable to add measurements for: ngg-pruef
org.postgresql.util.PSQLException: ERROR: value too long for type character varying(500)

Could it mean that my query only can contain 500 characters?
The query is not very simple.
0 Kudos
2 Replies
jvalkeal_hyperi

Not sure but you are probably right about this. I've seen many of these similar issues on jira, where textbox allows more chars that db can store.

If this indeed is the case, I hope hyperic would do something about it. Db gurus would say that if your query is too large, it's not efficient....
TheChristoph
Contributor
Contributor

OK, thanks. I realized it with a database-view.
0 Kudos