Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
10-04-2019 03:07 AM
Hello Team,
While fetch data from neo4j query using browser , I am getting below error:
Query:
MATCH (a:SITE_CODE_TABLE)<-[:site2sitecode]-(b:SITE)-[:site2container]->(c:CONTAINER)-[:container2mostatic]->(d:MO_STATIC_TABLE),
(e:LTE_ANTENNA)-[:letantenna2enodeb]->(f:ENODEB)-[:enodeb2container]->(G:CONTAINER)<-[:enodebamo2container]-(h:ENODEB_AMO)
RETURN
a.SITE_REGION ,
d.type AS DEVICE_TYPE,
b.CUSTOM_OPERATIONCONTEXT AS EQUIP_OC,
d.STD_OMID AS EQUIP_OMID,
d.STD_EMS_TYPE AS EQUIP_EMS_TYPE,
d.STD_SISID AS EQUIP_SSID,
b.SITE_STATUS AS SITE_STATUS,
b.SITE_COUNTY AS SITE_COUNTY,
b.SITE_LATITUDE AS SITE_LATITUDE,
b.SITE_LONGITUDE AS SITE_LONGITUDE,
b.STRUCTURE_NAME AS STRUCTURE_NAME,
b.SITE_PKEY AS SITE_PKEY,
b.SITE_COUNTRY as SITE_COUNTRY,
b.PARENT_SITE_NAME AS PARENT_SITE_NAME,
b.SITE_AREACODE AS SITE_AREACODE,
b.SITE_CIRCLE AS SITE_CIRCLE,
b.SITE_STATE AS SITE_STATE,
b.POST_CODE AS POST_CODE,
b.SITE_FLOOR AS SITE_FLOOR,
b.SITE_NAME AS SITE_NAME,
b.SITE_ADDRESS AS SITE_ADDRESS,
b.SITE_ROOM AS SITE_ROOM,
b.SITE_TYPE AS SITE_TYPE,
b.SITE_FRIENDLY_NAME AS SITE_FRIENDLY_NAME,
b.SITE_R4G_STATE AS SITE_R4G_STATE,
b.JIO_CENTER AS JIO_CENTER,
b.SITE_DISTRICT AS SITE_DISTRICT,
c.EQUIP_NAME AS EQUIP_NAME,
c.EQUIP_RINGNUMBER AS EQUIP_RINGNUMBER,
c.EQUIP_MM_SERVICEID AS EQUIP_MM_SERVICEID,
c.EQUIP_SITE_NAME AS EQUIP_SITE_NAME,
c.EQUIP_EMS_INSTANCENAME AS EQUIP_EMS_INSTANCENAME,
c.EQUIP_TRACKINGAREA AS EQUIP_TRACKINGAREA,
c.EQUIP_NATIVENAME AS EQUIP_NATIVENAME,
c.EQUIP_STATUS AS EQUIP_STATUS,
c.EQUIP_LEVEL AS EQUIP_LEVEL,
c.EQUIP_CUSTOMERTYPE AS EQUIP_CUSTOMERTYPE,
c.EQUIP_PKEY AS EQUIP_PKEY,
c.EQUIP_EQ_CLS AS EQUIP_EQ_CLS,
c.EQUIP_TYPE AS EQUIP_TYPE,
c.PARENT_EQUIP_NAME AS PARENT_EQUIP_NAME,
c.EQUIP_ECS_SERVICEID AS EQUIP_ECS_SERVICEID,
c.EQUIP_NMS_EMS AS EQUIP_NMS_EMS,
c.EQUIP_MODEL AS EQUIP_MODEL,
c.EQUIP_CLEI AS EQUIP_CLEI,
c.EQUIP_VENDOR AS EQUIP_VENDOR,
c.EQUIP_MAINTENANCEPOINT AS EQUIP_MAINTENANCEPOINT,
b.SITE_CITY AS SITE_CITY,
c.SAPID AS SAPID,
b.CUSTOM_MANAGEDOBJECT AS EQUIP_MO,
h.ENB_INST_NAME AS ENB_INST_NAME,
h.ENB_INST_ID AS ENB_INST_ID,
e.LTEANT_INST_NAME AS LTEANT_INST_NAME,
e.LTEANT_ELECTRICAL_TILT AS LTEANT_ELECTRICAL_TILT,
e.LTEANT_AZIMUTH AS LTEANT_AZIMUTH,
e.LTEANT_MECHANICAL_TILT AS LTEANT_MECHANICAL_TILT,
e.LTEANT_CELL_VALUE AS LTEANT_CELL_VALUE,
e.LTEANT_STATUS AS LTEANT_STATUS,
e.LTEANT_TX_POWER AS LTEANT_TX_POWER,
e.LTEANT_CELL_NUMBER AS LTEANT_CELL_NUMBER,
e.LTEANT_INST_ID AS LTEANT_INST_ID,
e.SEC_SECTOR_ID AS SEC_SECTOR_ID,
f.ENB_STATUS AS ENB_STATUS,
f.ENB_ID AS ENB_ID,
f.ENB_MNC_ID AS ENB_MNC_ID,
f.ENB_PRIMARY_MME_ID AS ENB_PRIMARY_MME_ID,
f.ENB_BTS_TYPE AS ENB_BTS_TYPE,
f.ENB_MCC_ID AS ENB_MCC_ID,
f.ENB_LSMRID AS ENB_LSMRID,
f.ENB_SECONDARY_MME_ID AS ENB_SECONDARY_MME_ID,
f.ENB_DEVICE_CODE AS ENB_DEVICE_CODE,
f.ENB_VENDOR AS ENB_VENDOR,
f.ENB_EMS_TYPE AS ENB_EMS_TYPE,
f.ENB_MODEL AS ENB_MODEL,
f.ENB_TRACKINGAREA AS ENB_TRACKINGAREA,
f.ENB_SITE_NAME AS ENB_SITE_NAME,
f.ENB_EMS_INSTANCENAME AS ENB_EMS_INSTANCENAME,
f.ENB_NATIVENAME AS ENB_NATIVENAME,
f.EMF_STATUS_850 AS EMF_STATUS_850,
f.EMF_STATUS_1800 AS EMF_STATUS_1800,
f.EMF_STATUS_2300 AS EMF_STATUS_2300
Please suggest.
Best Regards
Akshat
10-04-2019 06:23 AM
Maybe add LIMIT 10
on the end of the query to see if you can even have it return that many rows. It could be it's returning so many rows that it crashes the browser
10-04-2019 08:08 AM
Hello Mark ,
I tried to add limit 10 and was getting the output perfectly ( without any error ).
Actually , Output of query contains 80000 rows but Neo4J browser is not able to handle the output load.
May I know why it is crashing and how can we solve this issue?
Regards
Akshat
10-09-2019 06:00 AM
Hello Mark,
Please help in updating.
Regards
Akshat
All the sessions of the conference are now available online