Looking at your screen shot I assume the following:
The import uses JDBC batch statements, the batch size is 100. You see 100
messages like
INFO: Inserted tile ......
The real database insert is happening after 100 of these messages.
I see a batch exception, telling me batch entry 0 is the problem. I assume
the first insert already causes the problem. Unfortunately I do not see the
nested exception which would provide a more detailed diagnosis.
Possible reasons:
1) Your tileraster_0 table is not empty --> duplicate primary key. Did you
drop all tables before you restarted the whole procedure ?.
2) The db user does not have the right to insert (unlikely).
3) An invalid tif file causing NULL values which are not allowed
I assume something like 1), maybe you did not drop all your tables before
restarting.
Cheers
Chrstian
2013/5/11 akhilgupta <[email protected]>
> Hi christian
>
> I ran the whole procedure this time, It gives error while importing the
> image data to tables.
>
> I am* inserting the screen shot of error*, kindly view it..
>
> screenshot.zip
> <http://osgeo-org.1560.x6.nabble.com/file/n5052701/screenshot.zip>
>
> Akhil
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Problem-in-importing-raster-data-on-Geoserver-from-PostGIS-tp5051976p5052701.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
