|
|
| Subject: | Error when acknowledging and closing events |
| Author: | [Not Specified] |
| Posted: | 2015-11-23 10:18 |
Hello, I am testing our app's compatibility with Zenoss 5.0. We make acknowledge and close event API calls from Java which all work on 4.2.3 r26484 but not on 5.0.8. They fail with an error:
Acknowledge event:
ServiceResponseError: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [UPDATE event_summary SET status_id=,status_change=,closed_status=,update_time=,current_user_uuid=,current_user_name=,cleared_by_event_uuid=,fingerprint_hash=,audit_json= WHERE uuid=]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'closed_status' in 'field list'
Close event:
ServiceResponseError: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [UPDATE event_summary SET status_id=,status_change=,closed_status=,update_time=,cleared_by_event_uuid=,fingerprint_hash=,audit_json= WHERE uuid=]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'closed_status' in 'field list'
The reopen call probably fails as well. I have also just noticed that acknowledging the event from Zenoss UI is failing with the same error.
| Subject: | if you use firebug or similar |
| Author: | Andrew Kirch |
| Posted: | 2015-12-30 12:21 |
if you use firebug or similar, you should be able to get the correct syntax by performing the action in the UI. It is possible there were minor changes in 5.x JSON API. If so, the latest documentation for 5.x is here:http://www.zenoss.com/resources/documentation. Please refer specifically to:Zenoss Platform JSON API
Andrew Kirch
akirch@gvit.com
Need Zenoss support, consulting or custom development Look no further. Email or PM me!
Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard
| Subject: | It fails when doing the |
| Author: | [Not Specified] |
| Posted: | 2016-01-04 08:48 |
It fails when doing the action in the UI (from the Events tab).
ServiceResponseError: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [UPDATE event_summary SET status_id=,status_change=,closed_status=,update_time=,current_user_uuid=,current_user_name=,cleared_by_event_uuid=,fingerprint_hash=,audit_json= WHERE uuid=]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'closed_status' in 'field list'
| < |
Previous Zenoss Core 5 - Source Code (Resolved) |
Next Zenoss Thresholds and Hysteresis Possibilities? |
> |