GeoServer
  1. GeoServer
  2. GEOS-4279

java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds with Geoserver 2.1 Beta 3 20 Dec release and SqlSever 2008

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Not A Bug
    • Affects Version/s: 2.1-beta3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Windows Server 2008, SqlServer 2008, Geoserver 2.1 Beta 3
    • Number of attachments :
      1

      Description

      1. Shapefile is imported successfully in SqlServer 2008.
      2. Added a new store in GeoServer 2.1 Beta3.
      3. Trying to add a new layer but exception is thrown when try get bounding box by clicking 'compute from data'

        Activity

        Hide
        Andrea Aime added a comment -

        This is SQL Server specific so assignign to Justin,though by the logs contents it looks like a data validity issue

        Show
        Andrea Aime added a comment - This is SQL Server specific so assignign to Justin,though by the logs contents it looks like a data validity issue
        Hide
        Justin Deoliveira added a comment -

        Hmmm... never seen this error before. I agree with Andrea in that it looks like maybe the case of an invalid geometry in the database.

        @Sandeep: Can you run a query checking the validity of any geometries in the database? If any come back as invalid that is probably where the problem lies.

        We could potentially add a configuration option to call MakeValid in the query as well.

        Show
        Justin Deoliveira added a comment - Hmmm... never seen this error before. I agree with Andrea in that it looks like maybe the case of an invalid geometry in the database. @Sandeep: Can you run a query checking the validity of any geometries in the database? If any come back as invalid that is probably where the problem lies. We could potentially add a configuration option to call MakeValid in the query as well.
        Hide
        Sandeep Sharma added a comment -

        Hi Justin,Andrea,

        Thanks for looking into it, I used MakeValid function and it worked, there were multiple invalid geometry. , I thought its SQL specific as Postgres was working fine on similar data.

        and thanks again for pointing it out. Issue can be closed.

        Regards,
        Sandeep

        Show
        Sandeep Sharma added a comment - Hi Justin,Andrea, Thanks for looking into it, I used MakeValid function and it worked, there were multiple invalid geometry. , I thought its SQL specific as Postgres was working fine on similar data. and thanks again for pointing it out. Issue can be closed. Regards, Sandeep
        Hide
        Justin Deoliveira added a comment -

        Thanks Sandeep!

        Show
        Justin Deoliveira added a comment - Thanks Sandeep!
        Hide
        Andrea Aime added a comment -

        Bulk closing all resolved issue that have not gotten any more feedback or comment in the last month

        Show
        Andrea Aime added a comment - Bulk closing all resolved issue that have not gotten any more feedback or comment in the last month
        Hide
        sunny morales morales added a comment -

        How did you do?
        How did you use " MakeValid function"?

        Bye

        Show
        sunny morales morales added a comment - How did you do? How did you use " MakeValid function"? Bye
        Hide
        sunny morales morales added a comment -

        I did.
        BYE

        Show
        sunny morales morales added a comment - I did. BYE

          People

          • Assignee:
            Justin Deoliveira
            Reporter:
            Sandeep Sharma
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: