WSO2 API Manager 2.0.0 和分析配置，错误:“api_request_summary" [英] WSO2 API Manager 2.0.0 and analytics configuraton, Error : "api_request_summary"

问题描述

我已按照以下文档配置 WSO2 API 管理器和 WSO2 AM 分析 - https://docs.wso2.com/display/AM200/Configuring+APIM+Analytics

I have configured WSO2 API Manager and WSO2 AM Analytics as per following document - https://docs.wso2.com/display/AM200/Configuring+APIM+Analytics

我可以在 Home>Manage>Interactive Analytics>Data Explorer 下的分析服务器 carbon admin 仪表板上看到生成的分析数据，但是当我在 API Publisher 或 store 上尝试统计时，它在 api manager 的日志中出现以下错误:请告知.谢谢.

I could see generated analytics data on analytics server carbon admin dashboard under Home>Manage>Interactive Analytics>Data Explorer but when I try Statistics on API Publisher or store it is giving following error in the log of api manager: please advise. thanks.

[2017-01-06 03:56:34,768] 错误 - 用法:jag org.wso2.carbon.apimgt.usage.client.exception.APIMgtUsageQueryServiceClientException:从 JDBC 数据库查询时出错错误:关系api_request_summary"没有存在职位:34[2017-01-06 03:56:48,820] 错误 - 用法:jag org.wso2.carbon.apimgt.usage.client.exception.APIMgtUsageQueryServiceClientException:从 JDBC 数据库查询时出错错误:关系api_request_summary"不存在

[2017-01-06 03:56:34,768] ERROR - usage:jag org.wso2.carbon.apimgt.usage.client.exception.APIMgtUsageQueryServiceClientException: Error occurred while querying from JDBC databaseERROR: relation "api_request_summary" does not exist Position: 34 [2017-01-06 03:56:48,820] ERROR - usage:jag org.wso2.carbon.apimgt.usage.client.exception.APIMgtUsageQueryServiceClientException: Error occurred while querying from JDBC databaseERROR: relation "api_request_summary" does not exist

推荐答案

谢谢@Bhathiya，我能够弄清楚.我为 wso2am_stats_db 定义了两个不同的数据库，并配置了 API 管理器和 API 管理器分析的数据源，因为两者都应该配置为相同的数据库.一旦我将 API 管理器的数据源 (WSO2AM_STATS_DB) 更改为配置了分析的相同数据库.它起作用了，我能够看到商店和出版商的所有分析.

Thanks @Bhathiya, I was able to figure out. I was having two different database for wso2am_stats_db defined and configured with data-sources for API manager and API Manager analytics, where as both should be configured to same db. Once i changed the data-source (WSO2AM_STATS_DB) of API manager to same database which is configured with analytics. It worked and i was able see all analytics on store and publisher.

从以下参考资料中得到了一些帮助:如何使用 WSO 2 AM (2.0.0.0)

got some help from following references: How to manage billing with WSO 2 AM (2.0.0)

这篇关于WSO2 API Manager 2.0.0 和分析配置，错误:“api_request_summary"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！