Re: API command "listNetworks" error
Daan, Thanks a ton!! updating the relevant entries in the table "networks" created on the specific date, has resolved the issue. regards, Thomas Joseph On 28/11/13 16:05, Daan Hoogland wrote: H Thomas, attachments won't work on this list, I'm sorry. You say you have editted the 'physical_network' table. Then you say listNetworks doesn't work. the networks that should be returned with this call are not in the table 'physical_network'. These are in 'networks'. This table does refer to 'physical_network' so maybe some logical key relation is broken? make sure you don't have any existing networks where physical_network_id==205 good hunting,
Re: API command "listNetworks" error
H Thomas, attachments won't work on this list, I'm sorry. You say you have editted the 'physical_network' table. Then you say listNetworks doesn't work. the networks that should be returned with this call are not in the table 'physical_network'. These are in 'networks'. This table does refer to 'physical_network' so maybe some logical key relation is broken? make sure you don't have any existing networks where physical_network_id==205 good hunting,
Re: API command "listNetworks" error
Daan, I'm currently using: ACS version 4.1.1 running on CentOS v6.4 Hypervisor: XCP v1.6 The "listNetworks" command is invoked while accessing the "Network" tab in default view and while accessing a project under "Project View". I've attached the screen captures for both the errors. Please let me know if you require further data. regards, Thomas Joseph On 28/11/13 10:28, Daan Hoogland wrote: Thomas can you elaborate on your environment? what version of ACS on what os etc. also, it seems you are asking about physical networks and 'normal' networks at the same time. Do you have them confused? regards, Daan On Wed, Nov 20, 2013 at 11:53 AM, Thomas Joseph wrote: Hello I was unable to delete a POD & the "Physical Network 1" from a basic zone from the CS MGMT UI v4.1.1, therefore I had to manually update the "removed" & "state" coloumns for the CS DB table "physical_network" id 205. mysql> select * from physical_network; +-+--+++-+---+---++--+-+-+ | id | uuid | name | data_center_id | vnet| speed | domain_id | broadcast_domain_range | state | created | removed | +-+--+++-+---+---++--+-+-+ | 200 | 584c70ea-d8b7-47a4-90a7-24bdee311224 | Physical Network 1 | 1 | NULL| NULL | NULL | POD| Enabled | 2013-09-17 14:53:39 | NULL| | 201 | c8b2cbb2-a553-4059-b11e-c3454560b74c | Physical Network 1 | 2 | NULL| NULL | NULL | ZONE | Disabled | 2013-09-24 12:32:48 | 2013-09-24 13:17:05 | | 202 | 29d4f2f8-abdd-4d43--81a0a18fe858 | Physical Network 1 | 3 | NULL| NULL | NULL | ZONE | Disabled | 2013-09-24 14:13:05 | 2013-09-25 09:53:56 | | 203 | 421283e4-746a-4a2b-88b9-83cd669f92dd | cloud-private | 4 | 750-801 | NULL | NULL | ZONE | Disabled | 2013-09-26 11:15:37 | 2013-10-02 09:52:52 | | 204 | 07cafc6e-d424-4664-9c8b-6f02057f8387 | cloud-public | 4 | NULL| NULL | NULL | ZONE | Disabled | 2013-09-26 11:15:37 | 2013-10-02 09:52:55 | | 205 | 46746864-61ab-490a-bb53-6c1bc48917bd | Physical Network 1 | 5 | NULL| NULL | NULL | POD| Disabled | 2013-10-11 14:46:39 | 2013-11-19 17:29:00 | | 206 | c3057ff2-4872-4a5f-9b33-c1abfb6a573a | Physical Network 1 | 6 | NULL| NULL | NULL | POD| Enabled | 2013-11-19 12:54:02 | NULL| +-+--+++-+---+---++--+-+-+ 7 rows in set (0.00 sec) After which the "Network" tab in CS MGMT UI displays "Error" and when we try to access a Project via Project View, the following error is displayed: == 2013-11-20 09:39:32,418 ERROR [cloud.api.ApiServer] (http-8443-6:null) unhandled exception executing api command: listNetworks java.lang.NullPointerException at com.cloud.network.guru.DirectNetworkGuru.updateNetworkProfile(DirectNetworkGuru.java:255) at com.cloud.network.NetworkManagerImpl.convertNetworkToNetworkProfile(NetworkManagerImpl.java:2684) at com.cloud.api.ApiDBUtils.getNetworkProfile(ApiDBUtils.java:894) at com.cloud.api.ApiResponseHelper.createNetworkResponse(ApiResponseHelper.java:2109) at org.apache.cloudstack.api.command.user.network.ListNetworksCmd.execute(ListNetworksCmd.java:157) at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:162) at com.cloud.api.ApiServer.queueCommand(ApiServer.java:505) at com.cloud.api.ApiServer.handleRequest(ApiServer.java:355) at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:302) at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.a
Re: API command "listNetworks" error
Thomas can you elaborate on your environment? what version of ACS on what os etc. also, it seems you are asking about physical networks and 'normal' networks at the same time. Do you have them confused? regards, Daan On Wed, Nov 20, 2013 at 11:53 AM, Thomas Joseph wrote: > Hello > > I was unable to delete a POD & the "Physical Network 1" from a basic zone > from the CS MGMT UI v4.1.1, therefore I had to manually update the "removed" > & "state" coloumns for the CS DB table "physical_network" id 205. > > > mysql> select * from physical_network; > +-+--+++-+---+---++--+-+-+ > | id | uuid | name | > data_center_id | vnet| speed | domain_id | broadcast_domain_range | state >| created | removed | > +-+--+++-+---+---++--+-+-+ > | 200 | 584c70ea-d8b7-47a4-90a7-24bdee311224 | Physical Network 1 | >1 | NULL| NULL | NULL | POD| Enabled | > 2013-09-17 14:53:39 | NULL| > | 201 | c8b2cbb2-a553-4059-b11e-c3454560b74c | Physical Network 1 | >2 | NULL| NULL | NULL | ZONE | Disabled | > 2013-09-24 12:32:48 | 2013-09-24 13:17:05 | > | 202 | 29d4f2f8-abdd-4d43--81a0a18fe858 | Physical Network 1 | >3 | NULL| NULL | NULL | ZONE | Disabled | > 2013-09-24 14:13:05 | 2013-09-25 09:53:56 | > | 203 | 421283e4-746a-4a2b-88b9-83cd669f92dd | cloud-private | >4 | 750-801 | NULL | NULL | ZONE | Disabled | > 2013-09-26 11:15:37 | 2013-10-02 09:52:52 | > | 204 | 07cafc6e-d424-4664-9c8b-6f02057f8387 | cloud-public | >4 | NULL| NULL | NULL | ZONE | Disabled | > 2013-09-26 11:15:37 | 2013-10-02 09:52:55 | > | 205 | 46746864-61ab-490a-bb53-6c1bc48917bd | Physical Network 1 | >5 | NULL| NULL | NULL | POD| Disabled | > 2013-10-11 14:46:39 | 2013-11-19 17:29:00 | > | 206 | c3057ff2-4872-4a5f-9b33-c1abfb6a573a | Physical Network 1 | >6 | NULL| NULL | NULL | POD| Enabled | > 2013-11-19 12:54:02 | NULL| > +-+--+++-+---+---++--+-+-+ > 7 rows in set (0.00 sec) > > After which the "Network" tab in CS MGMT UI displays "Error" and when we try > to access a Project via Project View, the following error is displayed: > > == > 2013-11-20 09:39:32,418 ERROR [cloud.api.ApiServer] (http-8443-6:null) > unhandled exception executing api command: listNetworks > java.lang.NullPointerException > at > com.cloud.network.guru.DirectNetworkGuru.updateNetworkProfile(DirectNetworkGuru.java:255) > at > com.cloud.network.NetworkManagerImpl.convertNetworkToNetworkProfile(NetworkManagerImpl.java:2684) > at com.cloud.api.ApiDBUtils.getNetworkProfile(ApiDBUtils.java:894) > at > com.cloud.api.ApiResponseHelper.createNetworkResponse(ApiResponseHelper.java:2109) > at > org.apache.cloudstack.api.command.user.network.ListNetworksCmd.execute(ListNetworksCmd.java:157) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:162) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:505) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:355) > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:302) > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.cat
API command "listNetworks" error
Hello I was unable to delete a POD & the "Physical Network 1" from a basic zone from the CS MGMT UI v4.1.1, therefore I had to manually update the "removed" & "state" coloumns for the CS DB table "physical_network" id 205. mysql> select * from physical_network; +-+--+++-+---+---++--+-+-+ | id | uuid | name | data_center_id | vnet| speed | domain_id | broadcast_domain_range | state | created | removed | +-+--+++-+---+---++--+-+-+ | 200 | 584c70ea-d8b7-47a4-90a7-24bdee311224 | Physical Network 1 | 1 | NULL| NULL | NULL | POD| Enabled | 2013-09-17 14:53:39 | NULL| | 201 | c8b2cbb2-a553-4059-b11e-c3454560b74c | Physical Network 1 | 2 | NULL| NULL | NULL | ZONE | Disabled | 2013-09-24 12:32:48 | 2013-09-24 13:17:05 | | 202 | 29d4f2f8-abdd-4d43--81a0a18fe858 | Physical Network 1 | 3 | NULL| NULL | NULL | ZONE | Disabled | 2013-09-24 14:13:05 | 2013-09-25 09:53:56 | | 203 | 421283e4-746a-4a2b-88b9-83cd669f92dd | cloud-private | 4 | 750-801 | NULL | NULL | ZONE | Disabled | 2013-09-26 11:15:37 | 2013-10-02 09:52:52 | | 204 | 07cafc6e-d424-4664-9c8b-6f02057f8387 | cloud-public | 4 | NULL| NULL | NULL | ZONE | Disabled | 2013-09-26 11:15:37 | 2013-10-02 09:52:55 | | 205 | 46746864-61ab-490a-bb53-6c1bc48917bd | Physical Network 1 | 5 | NULL| NULL | NULL | POD| Disabled | 2013-10-11 14:46:39 | 2013-11-19 17:29:00 | | 206 | c3057ff2-4872-4a5f-9b33-c1abfb6a573a | Physical Network 1 | 6 | NULL| NULL | NULL | POD| Enabled | 2013-11-19 12:54:02 | NULL| +-+--+++-+---+---++--+-+-+ 7 rows in set (0.00 sec) After which the "Network" tab in CS MGMT UI displays "Error" and when we try to access a Project via Project View, the following error is displayed: == 2013-11-20 09:39:32,418 ERROR [cloud.api.ApiServer] (http-8443-6:null) unhandled exception executing api command: listNetworks java.lang.NullPointerException at com.cloud.network.guru.DirectNetworkGuru.updateNetworkProfile(DirectNetworkGuru.java:255) at com.cloud.network.NetworkManagerImpl.convertNetworkToNetworkProfile(NetworkManagerImpl.java:2684) at com.cloud.api.ApiDBUtils.getNetworkProfile(ApiDBUtils.java:894) at com.cloud.api.ApiResponseHelper.createNetworkResponse(ApiResponseHelper.java:2109) at org.apache.cloudstack.api.command.user.network.ListNetworksCmd.execute(ListNetworksCmd.java:157) at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:162) at com.cloud.api.ApiServer.queueCommand(ApiServer.java:505) at com.cloud.api.ApiServer.handleRequest(ApiServer.java:355) at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:302) at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) 2013-11-20 09:39:32,420 DEBUG [cloud.