search

wso2 / product-iots

Welcome to the WSO2 IoT Server source code! For info on working with the WSO2 IoT Server repository and contributing code, click the link below.
http://wso2.github.io/
Apache License 2.0
184 stars 181 forks source link

APIs stay in created state #1870

Open prithvi66 opened 6 years ago

prithvi66 commented 6 years ago

Configure the server for mysql database in datasources xml and start the server with -Dsetup. Some of the APIs go in created state and these APIs cannot be used.

I have worked on WSO2 IOT server version 3.1.0 with MySQL database on Windows Machine for quit some time now. WSO2 has recently released Server version 3.3.0. So now I want to upgrade my server. I tried running the WSO2 IoT server 3.3.0 by pointing the database to mysql in the datasources xml file. The problem I am facing when I run the server is, some of the APIs fail to get published with the exception and APIs stay in CREATED state and I am not able to use those APIs

WSO2 IoT server 3.3.0

Windows 10/ Linux

Configure WSO2IOT Server 3.3.0 with mysql database in datasources xml files. Run the server with -Dsetup as parameter to create all the tables and publish all the APIs.

Following query can be run on WSO2AM_DB to get the APIs in CREATED state SELECT DISTINCT p.reg_path_value, p.reg_path_id, pr.reg_id, pr.reg_name, pr.reg_value FROM wso2carbon_DB.reg_path p INNER JOIN wso2carbon_DB.reg_resource r ON p.reg_path_id = r.reg_path_id

INNER JOIN wso2carbon_DB.reg_resource_property rp
ON rp.reg_version = r.reg_version

INNER JOIN wso2carbon_DB.reg_property pr
ON rp.reg_property_id = pr.reg_id

WHERE r.reg_name='api' AND pr.reg_name='STATUS';

stale[bot] commented 6 years ago

This issue has been automatically marked as stale because it has not had recent activity.