Hi @Firdous ,
From the error message, it could be that the relationships have a property value which is expected to be a number, but may be a string on some relationships.
There's a good discussion about checking the types of a property here Data type of a property - #3 by mike.r.black
As an example, I modified the classic Movie graph to add some :REVIEWED relationships where the rating property is a string instead of a number. To check the property value types, I then ran this query...
MATCH ()-[r:REVIEWED]->(:Movie) RETURN collect(distinct(apoc.meta.type(r.rating)))
Revealing...
["INTEGER", "STRING"]
That verifies that I have successfully created bad data. 🙂 I could then find which relationships have a string value in the rating property like this...
MATCH ()-[r:REVIEWED]->(:Movie)
WHERE apoc.meta.type(r.rating) = "STRING"
RETURN r
Checking the data values like this may be a good first step. If it turns out there is some inconsistent data, we can then write some more queries to fix them.
Best,
ABK
