Guest

Preview Tool

Cisco Bug: CSCvu17768 - Historic API RBAC aggregation not working

Last Modified

Jun 04, 2020

Products (1)

  • Cisco Kinetic for Cities

Known Affected Releases

CKC5.0_AC1

Description (partial)

Symptom:
Historic API RBAC aggregation not working.
Getting below error.
"errorMessage": "Internal server error while processing API request"

And I can see below error in historic api logs

2020-05-08T08:46:33,351 GMT ERROR (http-nio-8090-exec-8) [HistoricApiExceptionHandler(handleException:30)] Tenant: SQL Exception is = : ERROR: column lightstate_hour_table.null does not exist
  Position: 9
2020-05-08T08:46:33,351 GMT ERROR (http-nio-8090-exec-8) [HistoricApiExceptionHandler(handleException:31)] Tenant: Got SQL Exception as = : ERROR: column lightstate_hour_table.null does not exist
  Position: 9

Conditions:
Historic API RBAC aggregation not working.
Getting below error.
"errorMessage": "Internal server error while processing API request"

And I can see below error in historic api logs

2020-05-08T08:46:33,351 GMT ERROR (http-nio-8090-exec-8) [HistoricApiExceptionHandler(handleException:30)] Tenant: SQL Exception is = : ERROR: column lightstate_hour_table.null does not exist
  Position: 9
2020-05-08T08:46:33,351 GMT ERROR (http-nio-8090-exec-8) [HistoricApiExceptionHandler(handleException:31)] Tenant: Got SQL Exception as = : ERROR: column lightstate_hour_table.null does not exist
  Position: 9
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.