One Star

Problem with PostGIS Import (sPostgisOutput) when using TOS 5.5.1

Hello!
I installed TOS 5.5.1 and installed the latest SDI version.
I did some testing and most of the jobs seem to work without problems. Unfortunately I found a problem with the sPostgisOutput component:
Starte Job Copy_of_test_PostGis am 10:27 04/07/2014.
connecting to socket on port 3546
connected
2014-07-04 10:27:40,417 INFO Factory implementations for category MathTransformFactory:
org.geotools.referencing.operation.DefaultMathTransformFactory
: org.geotools.factory - Factory implementations for category MathTransformFactory:
org.geotools.referencing.operation.DefaultMathTransformFactory
2014-07-04 10:27:40,429 INFO Factory implementations for category DatumFactory:
org.geotools.referencing.factory.ReferencingObjectFactory
org.geotools.referencing.factory.DatumAliases
: org.geotools.factory - Factory implementations for category DatumFactory:
org.geotools.referencing.factory.ReferencingObjectFactory
org.geotools.referencing.factory.DatumAliases
2014-07-04 10:27:40,431 INFO Factory implementations for category CSFactory:
org.geotools.referencing.factory.ReferencingObjectFactory
: org.geotools.factory - Factory implementations for category CSFactory:
org.geotools.referencing.factory.ReferencingObjectFactory
2014-07-04 10:27:40,433 INFO Factory implementations for category CRSFactory:
org.geotools.referencing.factory.ReferencingObjectFactory
: org.geotools.factory - Factory implementations for category CRSFactory:
org.geotools.referencing.factory.ReferencingObjectFactory
2014-07-04 10:27:40,433 DEBUG Setting the EPSG factory org.geotools.referencing.factory.epsg.DefaultFactory to a 1800000ms timeout
: org.geotools.referencing.factory - Setting the EPSG factory org.geotools.referencing.factory.epsg.DefaultFactory to a 1800000ms timeout
2014-07-04 10:27:40,549 DEBUG Setting the EPSG factory org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory to a 1800000ms timeout
: org.geotools.referencing.factory - Setting the EPSG factory org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory to a 1800000ms timeout
2014-07-04 10:27:40,626 INFO Factory implementations for category CRSAuthorityFactory:
org.geotools.referencing.factory.epsg.DefaultFactory
org.geotools.referencing.factory.epsg.FactoryUsingWKT
org.geotools.referencing.factory.epsg.LongitudeFirstFactory
org.geotools.referencing.factory.epsg.CartesianAuthorityFactory
org.geotools.referencing.factory.wms.AutoCRSFactory
org.geotools.referencing.factory.wms.WebCRSFactory
org.geotools.referencing.factory.URN_AuthorityFactory
org.geotools.referencing.factory.HTTP_AuthorityFactory
org.geotools.referencing.factory.HTTP_URI_AuthorityFactory
org.geotools.referencing.factory.epsg.LongitudeFirstEpsgDecorator
org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory
org.geotools.referencing.crs.EPSGCRSAuthorityFactory
: org.geotools.factory - Factory implementations for category CRSAuthorityFactory:
org.geotools.referencing.factory.epsg.DefaultFactory
org.geotools.referencing.factory.epsg.FactoryUsingWKT
org.geotools.referencing.factory.epsg.LongitudeFirstFactory
org.geotools.referencing.factory.epsg.CartesianAuthorityFactory
org.geotools.referencing.factory.wms.AutoCRSFactory
org.geotools.referencing.factory.wms.WebCRSFactory
org.geotools.referencing.factory.URN_AuthorityFactory
org.geotools.referencing.factory.HTTP_AuthorityFactory
org.geotools.referencing.factory.HTTP_URI_AuthorityFactory
org.geotools.referencing.factory.epsg.LongitudeFirstEpsgDecorator
org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory
org.geotools.referencing.crs.EPSGCRSAuthorityFactory
2014-07-04 10:27:40,627 DEBUG Building new data source for org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory
: org.geotools.referencing.factory.epsg - Building new data source for org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory
2014-07-04 10:27:40,632 DEBUG Building backing store for org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory
: org.geotools.referencing.factory.epsg - Building backing store for org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory
2014-07-04 10:27:41,026 INFO Connected to EPSG database "jdbc:hsqldb:file:/C:/Users/ms/AppData/Local/Temp/Geotools/Databases/HSQL/v7.9.0/EPSG;shutdown=true" on "HSQL Database Engine".
: org.geotools.referencing.factory - Connected to EPSG database "jdbc:hsqldb:file:/C:/Users/ms/AppData/Local/Temp/Geotools/Databases/HSQL/v7.9.0/EPSG;shutdown=true" on "HSQL Database Engine".
No authority was defined for code "-1". Did you forget "AUTHORITY:NUMBER"?
2014-07-04 10:27:41,164 INFO Factory implementations for category FilterFactory:
org.geotools.filter.FilterFactoryImpl
: org.geotools.factory - Factory implementations for category FilterFactory:
org.geotools.filter.FilterFactoryImpl
2014-07-04 10:27:41,177 INFO Factory implementations for category FeatureFactory:
org.geotools.feature.LenientFeatureFactoryImpl
org.geotools.feature.ValidatingFeatureFactoryImpl
: org.geotools.factory - Factory implementations for category FeatureFactory:
org.geotools.feature.LenientFeatureFactoryImpl
org.geotools.feature.ValidatingFeatureFactoryImpl
INFO: Table public.my_table_name dropped.
2014-07-04 10:27:41,704 DEBUG Failure in the primary factory: No code "EPSG:0" from authority "European Petroleum Survey Group" found for object of type "CoordinateReferenceSystem". Now trying the fallback factory...
: org.geotools.referencing.factory - Failure in the primary factory: No code "EPSG:0" from authority "European Petroleum Survey Group" found for object of type "CoordinateReferenceSystem". Now trying the fallback factory...
2014-07-04 10:27:41,704 DEBUG Failure in the primary factory: No code "EPSG:0" from authority "EPSG" found for object of type "EngineeringCRS". Now trying the fallback factory...
: org.geotools.referencing.factory - Failure in the primary factory: No code "EPSG:0" from authority "EPSG" found for object of type "EngineeringCRS". Now trying the fallback factory...
2014-07-04 10:27:41,749 DEBUG Read lock: file:/C:/temp/div_1.shp by org.geotools.data.shapefile.shp.ShapefileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.shp by org.geotools.data.shapefile.shp.ShapefileReader
2014-07-04 10:27:41,751 DEBUG Read lock: file:/C:/temp/div_1.shx by org.geotools.data.shapefile.shp.IndexFile
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.shx by org.geotools.data.shapefile.shp.IndexFile
2014-07-04 10:27:41,755 DEBUG Read lock: file:/C:/temp/div_1.dbf by org.geotools.data.shapefile.dbf.DbaseFileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.dbf by org.geotools.data.shapefile.dbf.DbaseFileReader
2014-07-04 10:27:41,758 DEBUG Read lock: file:/C:/temp/div_1.prj by org.geotools.data.shapefile.prj.PrjFileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.prj by org.geotools.data.shapefile.prj.PrjFileReader
2014-07-04 10:27:41,766 DEBUG Loading datum aliases from "jar:file:/C:/Talend/TOS_5_5_1/TOS_DI-Win32-r118616-V5.5.1/workspace/.Java/lib/gt-referencing-8.5.jar!/org/geotools/referencing/factory/DatumAliasesTable.txt".
: org.geotools.referencing.factory - Loading datum aliases from "jar:file:/C:/Talend/TOS_5_5_1/TOS_DI-Win32-r118616-V5.5.1/workspace/.Java/lib/gt-referencing-8.5.jar!/org/geotools/referencing/factory/DatumAliasesTable.txt".
2014-07-04 10:27:41,948 INFO Factory implementations for category MathTransformProvider:
org.geotools.referencing.operation.transform.LogarithmicTransform1D$Provider
org.geotools.referencing.operation.transform.ExponentialTransform1D$Provider
org.geotools.referencing.operation.transform.ProjectiveTransform$ProviderAffine
org.geotools.referencing.operation.transform.ProjectiveTransform$ProviderLongitudeRotation
org.geotools.referencing.operation.transform.GeocentricTranslation$Provider
org.geotools.referencing.operation.transform.GeocentricTranslation$ProviderSevenParam
org.geotools.referencing.operation.transform.GeocentricTranslation$ProviderFrameRotation
org.geotools.referencing.operation.transform.GeocentricTransform$Provider
org.geotools.referencing.operation.transform.GeocentricTransform$ProviderInverse
org.geotools.referencing.operation.transform.MolodenskiTransform$Provider
org.geotools.referencing.operation.transform.MolodenskiTransform$ProviderAbridged
org.geotools.referencing.operation.transform.NADCONTransform$Provider
org.geotools.referencing.operation.transform.NTv2Transform$Provider
org.geotools.referencing.operation.transform.SimilarityTransformProvider
org.geotools.referencing.operation.transform.WarpTransform2D$Provider
org.geotools.referencing.operation.projection.EquidistantCylindrical$Provider
org.geotools.referencing.operation.projection.EquidistantCylindrical$SphericalProvider
org.geotools.referencing.operation.projection.PlateCarree$Provider
org.geotools.referencing.operation.projection.Mercator1SP$Provider
org.geotools.referencing.operation.projection.Mercator2SP$Provider
org.geotools.referencing.operation.projection.MercatorPseudoProvider
org.geotools.referencing.operation.projection.TransverseMercator$Provider
org.geotools.referencing.operation.projection.TransverseMercator$Provider_SouthOrientated
org.geotools.referencing.operation.projection.ObliqueMercator$Provider
org.geotools.referencing.operation.projection.ObliqueMercator$Provider_TwoPoint
org.geotools.referencing.operation.projection.HotineObliqueMercator$Provider
org.geotools.referencing.operation.projection.HotineObliqueMercator$Provider_TwoPoint
org.geotools.referencing.operation.projection.AlbersEqualArea$Provider
org.geotools.referencing.operation.projection.LambertConformal1SP$Provider
org.geotools.referencing.operation.projection.LambertConformal2SP$Provider
org.geotools.referencing.operation.projection.LambertConformalBelgium$Provider
org.geotools.referencing.operation.projection.LambertAzimuthalEqualArea$Provider
org.geotools.referencing.operation.projection.Orthographic$Provider
org.geotools.referencing.operation.projection.Stereographic$Provider
org.geotools.referencing.operation.projection.ObliqueStereographic$Provider
org.geotools.referencing.operation.projection.PolarStereographic$ProviderA
org.geotools.referencing.operation.projection.PolarStereographic$ProviderB
org.geotools.referencing.operation.projection.PolarStereographic$ProviderNorth
org.geotools.referencing.operation.projection.PolarStereographic$ProviderSouth
org.geotools.referencing.operation.projection.NewZealandMapGrid$Provider
org.geotools.referencing.operation.projection.Krovak$Provider
org.geotools.referencing.operation.projection.CassiniSoldner$Provider
org.geotools.referencing.operation.projection.EquidistantConic$Provider
org.geotools.referencing.operation.projection.Polyconic$Provider
org.geotools.referencing.operation.projection.Robinson$Provider
org.geotools.referencing.operation.projection.WinkelTripel$WinkelProvider
org.geotools.referencing.operation.projection.WinkelTripel$AitoffProvider
org.geotools.referencing.operation.projection.EckertIV$Provider
org.geotools.referencing.operation.projection.Mollweide$MollweideProvider
org.geotools.referencing.operation.projection.Mollweide$WagnerIVProvider
org.geotools.referencing.operation.projection.WorldVanDerGrintenI$Provider
org.geotools.referencing.operation.transform.EarthGravitationalModel$Provider
: org.geotools.factory - Factory implementations for category MathTransformProvider:
org.geotools.referencing.operation.transform.LogarithmicTransform1D$Provider
org.geotools.referencing.operation.transform.ExponentialTransform1D$Provider
org.geotools.referencing.operation.transform.ProjectiveTransform$ProviderAffine
org.geotools.referencing.operation.transform.ProjectiveTransform$ProviderLongitudeRotation
org.geotools.referencing.operation.transform.GeocentricTranslation$Provider
org.geotools.referencing.operation.transform.GeocentricTranslation$ProviderSevenParam
org.geotools.referencing.operation.transform.GeocentricTranslation$ProviderFrameRotation
org.geotools.referencing.operation.transform.GeocentricTransform$Provider
org.geotools.referencing.operation.transform.GeocentricTransform$ProviderInverse
org.geotools.referencing.operation.transform.MolodenskiTransform$Provider
org.geotools.referencing.operation.transform.MolodenskiTransform$ProviderAbridged
org.geotools.referencing.operation.transform.NADCONTransform$Provider
org.geotools.referencing.operation.transform.NTv2Transform$Provider
org.geotools.referencing.operation.transform.SimilarityTransformProvider
org.geotools.referencing.operation.transform.WarpTransform2D$Provider
org.geotools.referencing.operation.projection.EquidistantCylindrical$Provider
org.geotools.referencing.operation.projection.EquidistantCylindrical$SphericalProvider
org.geotools.referencing.operation.projection.PlateCarree$Provider
org.geotools.referencing.operation.projection.Mercator1SP$Provider
org.geotools.referencing.operation.projection.Mercator2SP$Provider
org.geotools.referencing.operation.projection.MercatorPseudoProvider
org.geotools.referencing.operation.projection.TransverseMercator$Provider
org.geotools.referencing.operation.projection.TransverseMercator$Provider_SouthOrientated
org.geotools.referencing.operation.projection.ObliqueMercator$Provider
org.geotools.referencing.operation.projection.ObliqueMercator$Provider_TwoPoint
org.geotools.referencing.operation.projection.HotineObliqueMercator$Provider
org.geotools.referencing.operation.projection.HotineObliqueMercator$Provider_TwoPoint
org.geotools.referencing.operation.projection.AlbersEqualArea$Provider
org.geotools.referencing.operation.projection.LambertConformal1SP$Provider
org.geotools.referencing.operation.projection.LambertConformal2SP$Provider
org.geotools.referencing.operation.projection.LambertConformalBelgium$Provider
org.geotools.referencing.operation.projection.LambertAzimuthalEqualArea$Provider
org.geotools.referencing.operation.projection.Orthographic$Provider
org.geotools.referencing.operation.projection.Stereographic$Provider
org.geotools.referencing.operation.projection.ObliqueStereographic$Provider
org.geotools.referencing.operation.projection.PolarStereographic$ProviderA
org.geotools.referencing.operation.projection.PolarStereographic$ProviderB
org.geotools.referencing.operation.projection.PolarStereographic$ProviderNorth
org.geotools.referencing.operation.projection.PolarStereographic$ProviderSouth
org.geotools.referencing.operation.projection.NewZealandMapGrid$Provider
org.geotools.referencing.operation.projection.Krovak$Provider
org.geotools.referencing.operation.projection.CassiniSoldner$Provider
org.geotools.referencing.operation.projection.EquidistantConic$Provider
org.geotools.referencing.operation.projection.Polyconic$Provider
org.geotools.referencing.operation.projection.Robinson$Provider
org.geotools.referencing.operation.projection.WinkelTripel$WinkelProvider
org.geotools.referencing.operation.projection.WinkelTripel$AitoffProvider
org.geotools.referencing.operation.projection.EckertIV$Provider
org.geotools.referencing.operation.projection.Mollweide$MollweideProvider
org.geotools.referencing.operation.projection.Mollweide$WagnerIVProvider
org.geotools.referencing.operation.projection.WorldVanDerGrintenI$Provider
org.geotools.referencing.operation.transform.EarthGravitationalModel$Provider
2014-07-04 10:27:41,970 INFO Factory implementations for category FunctionFactory:
org.geotools.filter.function.DefaultFunctionFactory
: org.geotools.factory - Factory implementations for category FunctionFactory:
org.geotools.filter.function.DefaultFunctionFactory
2014-07-04 10:27:42,114 INFO Factory implementations for category Function:
org.geotools.filter.function.PropertyExistsFunction
org.geotools.filter.AreaFunction
org.geotools.filter.LengthFunction
org.geotools.filter.function.CategorizeFunction
org.geotools.filter.function.ClassifyFunction
org.geotools.filter.function.EqualIntervalFunction
org.geotools.filter.function.StandardDeviationFunction
org.geotools.filter.function.QuantileFunction
org.geotools.filter.function.UniqueIntervalFunction
org.geotools.filter.function.Collection_AverageFunction
org.geotools.filter.function.Collection_BoundsFunction
org.geotools.filter.function.Collection_CountFunction
org.geotools.filter.function.Collection_MinFunction
org.geotools.filter.function.Collection_MedianFunction
org.geotools.filter.function.Collection_MaxFunction
org.geotools.filter.function.Collection_SumFunction
org.geotools.filter.function.Collection_UniqueFunction
org.geotools.filter.function.EnvFunction
org.geotools.filter.function.FilterFunction_contains
org.geotools.filter.function.FilterFunction_isEmpty
org.geotools.filter.function.FilterFunction_parseDouble
org.geotools.filter.function.FilterFunction_parseInt
org.geotools.filter.function.FilterFunction_parseLong
org.geotools.filter.function.FilterFunction_intersects
org.geotools.filter.function.FilterFunction_isClosed
org.geotools.filter.function.FilterFunction_geomFromWKT
org.geotools.filter.function.FilterFunction_setCRS
org.geotools.filter.function.FilterFunction_toWKT
org.geotools.filter.function.FilterFunction_geomLength
org.geotools.filter.function.FilterFunction_isValid
org.geotools.filter.function.FilterFunction_geometryType
org.geotools.filter.function.FilterFunction_numPoints
org.geotools.filter.function.FilterFunction_isSimple
org.geotools.filter.function.FilterFunction_distance
org.geotools.filter.function.FilterFunction_isWithinDistance
org.geotools.filter.function.FilterFunction_area
org.geotools.filter.function.FilterFunction_centroid
org.geotools.filter.function.FilterFunction_interiorPoint
org.geotools.filter.function.FilterFunction_dimension
org.geotools.filter.function.FilterFunction_boundary
org.geotools.filter.function.FilterFunction_boundaryDimension
org.geotools.filter.function.FilterFunction_envelope
org.geotools.filter.function.FilterFunction_disjoint
org.geotools.filter.function.FilterFunction_touches
org.geotools.filter.function.FilterFunction_crosses
org.geotools.filter.function.FilterFunction_within
org.geotools.filter.function.FilterFunction_overlaps
org.geotools.filter.function.FilterFunction_relatePattern
org.geotools.filter.function.FilterFunction_relate
org.geotools.filter.function.FilterFunction_bufferWithSegments
org.geotools.filter.function.FilterFunction_buffer
org.geotools.filter.function.FilterFunction_convexHull
org.geotools.filter.function.FilterFunction_intersection
org.geotools.filter.function.FilterFunction_union
org.geotools.filter.function.FilterFunction_difference
org.geotools.filter.function.FilterFunction_symDifference
org.geotools.filter.function.FilterFunction_equalsExactTolerance
org.geotools.filter.function.FilterFunction_equalsExact
org.geotools.filter.function.FilterFunction_numGeometries
org.geotools.filter.function.FilterFunction_getGeometryN
org.geotools.filter.function.FilterFunction_getX
org.geotools.filter.function.FilterFunction_getY
org.geotools.filter.function.FilterFunction_getZ
org.geotools.filter.function.FilterFunction_pointN
org.geotools.filter.function.FilterFunction_startAngle
org.geotools.filter.function.FilterFunction_startPoint
org.geotools.filter.function.FilterFunction_endPoint
org.geotools.filter.function.FilterFunction_endAngle
org.geotools.filter.function.FilterFunction_isRing
org.geotools.filter.function.FilterFunction_exteriorRing
org.geotools.filter.function.FilterFunction_numInteriorRing
org.geotools.filter.function.FilterFunction_minimumCircle
org.geotools.filter.function.FilterFunction_minimumRectangle
org.geotools.filter.function.FilterFunction_interiorRingN
org.geotools.filter.function.FilterFunction_octagonalEnvelope
org.geotools.filter.function.FilterFunction_minimumDiameter
org.geotools.filter.function.FilterFunction_strConcat
org.geotools.filter.function.FilterFunction_strEndsWith
org.geotools.filter.function.FilterFunction_strStartsWith
org.geotools.filter.function.FilterFunction_strCapitalize
org.geotools.filter.function.FilterFunction_strEqualsIgnoreCase
org.geotools.filter.function.FilterFunction_strIndexOf
org.geotools.filter.function.FilterFunction_strLastIndexOf
org.geotools.filter.function.FilterFunction_strLength
org.geotools.filter.function.FilterFunction_strToLowerCase
org.geotools.filter.function.FilterFunction_strToUpperCase
org.geotools.filter.function.FilterFunction_strMatches
org.geotools.filter.function.FilterFunction_strPosition
org.geotools.filter.function.FilterFunction_strReplace
org.geotools.filter.function.FilterFunction_strSubstring
org.geotools.filter.function.FilterFunction_strSubstringStart
org.geotools.filter.function.FilterFunction_strTrim
org.geotools.filter.function.FilterFunction_strTrim2
org.geotools.filter.function.FilterFunction_parseBoolean
org.geotools.filter.function.FilterFunction_roundDouble
org.geotools.filter.function.FilterFunction_int2ddouble
org.geotools.filter.function.FilterFunction_int2bbool
org.geotools.filter.function.FilterFunction_double2bool
org.geotools.filter.function.FilterFunction_if_then_else
org.geotools.filter.function.FilterFunction_equalTo
org.geotools.filter.function.FilterFunction_notEqualTo
org.geotools.filter.function.FilterFunction_lessThan
org.geotools.filter.function.FilterFunction_greaterThan
org.geotools.filter.function.FilterFunction_greaterEqualThan
org.geotools.filter.function.FilterFunction_lessEqualThan
org.geotools.filter.function.FilterFunction_isLike
org.geotools.filter.function.FilterFunction_isNull
org.geotools.filter.function.FilterFunction_between
org.geotools.filter.function.FilterFunction_not
org.geotools.filter.function.FilterFunction_in2
org.geotools.filter.function.FilterFunction_in3
org.geotools.filter.function.FilterFunction_in4
org.geotools.filter.function.FilterFunction_in5
org.geotools.filter.function.FilterFunction_in6
org.geotools.filter.function.FilterFunction_in7
org.geotools.filter.function.FilterFunction_in8
org.geotools.filter.function.FilterFunction_in9
org.geotools.filter.function.FilterFunction_in10
org.geotools.filter.function.FilterFunction_dateParse
org.geotools.filter.function.FilterFunction_dateFormat
org.geotools.filter.function.FilterFunction_numberFormat
org.geotools.filter.function.FilterFunction_numberFormat2
org.geotools.filter.function.FilterFunction_Convert
org.geotools.filter.function.FilterFunction_vertices
org.geotools.filter.function.FilterFunction_offset
org.geotools.filter.function.FilterFunction_isometric
org.geotools.filter.function.FilterFunction_property
org.geotools.filter.function.IDFunction
org.geotools.filter.function.InterpolateFunction
org.geotools.filter.function.RecodeFunction
org.geotools.filter.function.math.FilterFunction_IEEEremainder
org.geotools.filter.function.math.FilterFunction_abs
org.geotools.filter.function.math.FilterFunction_abs_2
org.geotools.filter.function.math.FilterFunction_abs_3
org.geotools.filter.function.math.FilterFunction_abs_4
org.geotools.filter.function.math.FilterFunction_acos
org.geotools.filter.function.math.FilterFunction_asin
org.geotools.filter.function.math.FilterFunction_atan
org.geotools.filter.function.math.FilterFunction_atan2
org.geotools.filter.function.math.FilterFunction_ceil
org.geotools.filter.function.math.FilterFunction_cos
org.geotools.filter.function.math.FilterFunction_exp
org.geotools.filter.function.math.FilterFunction_floor
org.geotools.filter.function.math.FilterFunction_log
org.geotools.filter.function.math.FilterFunction_max
org.geotools.filter.function.math.FilterFunction_max_2
org.geotools.filter.function.math.FilterFunction_max_3
org.geotools.filter.function.math.FilterFunction_max_4
org.geotools.filter.function.math.FilterFunction_min
org.geotools.filter.function.math.FilterFunction_min_2
org.geotools.filter.function.math.FilterFunction_min_3
org.geotools.filter.function.math.FilterFunction_min_4
org.geotools.filter.function.math.FilterFunction_pow
org.geotools.filter.function.math.FilterFunction_random
org.geotools.filter.function.math.FilterFunction_rint
org.geotools.filter.function.math.FilterFunction_round
org.geotools.filter.function.math.FilterFunction_round_2
org.geotools.filter.function.math.FilterFunction_sin
org.geotools.filter.function.math.FilterFunction_sqrt
org.geotools.filter.function.math.FilterFunction_tan
org.geotools.filter.function.math.FilterFunction_toDegrees
org.geotools.filter.function.math.FilterFunction_toRadians
org.geotools.filter.function.math.ModuloFunction
org.geotools.filter.function.math.PiFunction
org.geotools.filter.function.string.ConcatenateFunction
org.geotools.filter.function.JenksNaturalBreaksFunction
: org.geotools.factory - Factory implementations for category Function:
org.geotools.filter.function.PropertyExistsFunction
org.geotools.filter.AreaFunction
org.geotools.filter.LengthFunction
org.geotools.filter.function.CategorizeFunction
org.geotools.filter.function.ClassifyFunction
org.geotools.filter.function.EqualIntervalFunction
org.geotools.filter.function.StandardDeviationFunction
org.geotools.filter.function.QuantileFunction
org.geotools.filter.function.UniqueIntervalFunction
org.geotools.filter.function.Collection_AverageFunction
org.geotools.filter.function.Collection_BoundsFunction
org.geotools.filter.function.Collection_CountFunction
org.geotools.filter.function.Collection_MinFunction
org.geotools.filter.function.Collection_MedianFunction
org.geotools.filter.function.Collection_MaxFunction
org.geotools.filter.function.Collection_SumFunction
org.geotools.filter.function.Collection_UniqueFunction
org.geotools.filter.function.EnvFunction
org.geotools.filter.function.FilterFunction_contains
org.geotools.filter.function.FilterFunction_isEmpty
org.geotools.filter.function.FilterFunction_parseDouble
org.geotools.filter.function.FilterFunction_parseInt
org.geotools.filter.function.FilterFunction_parseLong
org.geotools.filter.function.FilterFunction_intersects
org.geotools.filter.function.FilterFunction_isClosed
org.geotools.filter.function.FilterFunction_geomFromWKT
org.geotools.filter.function.FilterFunction_setCRS
org.geotools.filter.function.FilterFunction_toWKT
org.geotools.filter.function.FilterFunction_geomLength
org.geotools.filter.function.FilterFunction_isValid
org.geotools.filter.function.FilterFunction_geometryType
org.geotools.filter.function.FilterFunction_numPoints
org.geotools.filter.function.FilterFunction_isSimple
org.geotools.filter.function.FilterFunction_distance
org.geotools.filter.function.FilterFunction_isWithinDistance
org.geotools.filter.function.FilterFunction_area
org.geotools.filter.function.FilterFunction_centroid
org.geotools.filter.function.FilterFunction_interiorPoint
org.geotools.filter.function.FilterFunction_dimension
org.geotools.filter.function.FilterFunction_boundary
org.geotools.filter.function.FilterFunction_boundaryDimension
org.geotools.filter.function.FilterFunction_envelope
org.geotools.filter.function.FilterFunction_disjoint
org.geotools.filter.function.FilterFunction_touches
org.geotools.filter.function.FilterFunction_crosses
org.geotools.filter.function.FilterFunction_within
org.geotools.filter.function.FilterFunction_overlaps
org.geotools.filter.function.FilterFunction_relatePattern
org.geotools.filter.function.FilterFunction_relate
org.geotools.filter.function.FilterFunction_bufferWithSegments
org.geotools.filter.function.FilterFunction_buffer
org.geotools.filter.function.FilterFunction_convexHull
org.geotools.filter.function.FilterFunction_intersection
org.geotools.filter.function.FilterFunction_union
org.geotools.filter.function.FilterFunction_difference
org.geotools.filter.function.FilterFunction_symDifference
org.geotools.filter.function.FilterFunction_equalsExactTolerance
org.geotools.filter.function.FilterFunction_equalsExact
org.geotools.filter.function.FilterFunction_numGeometries
org.geotools.filter.function.FilterFunction_getGeometryN
org.geotools.filter.function.FilterFunction_getX
org.geotools.filter.function.FilterFunction_getY
org.geotools.filter.function.FilterFunction_getZ
org.geotools.filter.function.FilterFunction_pointN
org.geotools.filter.function.FilterFunction_startAngle
org.geotools.filter.function.FilterFunction_startPoint
org.geotools.filter.function.FilterFunction_endPoint
org.geotools.filter.function.FilterFunction_endAngle
org.geotools.filter.function.FilterFunction_isRing
org.geotools.filter.function.FilterFunction_exteriorRing
org.geotools.filter.function.FilterFunction_numInteriorRing
org.geotools.filter.function.FilterFunction_minimumCircle
org.geotools.filter.function.FilterFunction_minimumRectangle
org.geotools.filter.function.FilterFunction_interiorRingN
org.geotools.filter.function.FilterFunction_octagonalEnvelope
org.geotools.filter.function.FilterFunction_minimumDiameter
org.geotools.filter.function.FilterFunction_strConcat
org.geotools.filter.function.FilterFunction_strEndsWith
org.geotools.filter.function.FilterFunction_strStartsWith
org.geotools.filter.function.FilterFunction_strCapitalize
org.geotools.filter.function.FilterFunction_strEqualsIgnoreCase
org.geotools.filter.function.FilterFunction_strIndexOf
org.geotools.filter.function.FilterFunction_strLastIndexOf
org.geotools.filter.function.FilterFunction_strLength
org.geotools.filter.function.FilterFunction_strToLowerCase
org.geotools.filter.function.FilterFunction_strToUpperCase
org.geotools.filter.function.FilterFunction_strMatches
org.geotools.filter.function.FilterFunction_strPosition
org.geotools.filter.function.FilterFunction_strReplace
org.geotools.filter.function.FilterFunction_strSubstring
org.geotools.filter.function.FilterFunction_strSubstringStart
org.geotools.filter.function.FilterFunction_strTrim
org.geotools.filter.function.FilterFunction_strTrim2
org.geotools.filter.function.FilterFunction_parseBoolean
org.geotools.filter.function.FilterFunction_roundDouble
org.geotools.filter.function.FilterFunction_int2ddouble
org.geotools.filter.function.FilterFunction_int2bbool
org.geotools.filter.function.FilterFunction_double2bool
org.geotools.filter.function.FilterFunction_if_then_else
org.geotools.filter.function.FilterFunction_equalTo
org.geotools.filter.function.FilterFunction_notEqualTo
org.geotools.filter.function.FilterFunction_lessThan
org.geotools.filter.function.FilterFunction_greaterThan
org.geotools.filter.function.FilterFunction_greaterEqualThan
org.geotools.filter.function.FilterFunction_lessEqualThan
org.geotools.filter.function.FilterFunction_isLike
org.geotools.filter.function.FilterFunction_isNull
org.geotools.filter.function.FilterFunction_between
org.geotools.filter.function.FilterFunction_not
org.geotools.filter.function.FilterFunction_in2
org.geotools.filter.function.FilterFunction_in3
org.geotools.filter.function.FilterFunction_in4
org.geotools.filter.function.FilterFunction_in5
org.geotools.filter.function.FilterFunction_in6
org.geotools.filter.function.FilterFunction_in7
org.geotools.filter.function.FilterFunction_in8
org.geotools.filter.function.FilterFunction_in9
org.geotools.filter.function.FilterFunction_in10
org.geotools.filter.function.FilterFunction_dateParse
org.geotools.filter.function.FilterFunction_dateFormat
org.geotools.filter.function.FilterFunction_numberFormat
org.geotools.filter.function.FilterFunction_numberFormat2
org.geotools.filter.function.FilterFunction_Convert
org.geotools.filter.function.FilterFunction_vertices
org.geotools.filter.function.FilterFunction_offset
org.geotools.filter.function.FilterFunction_isometric
org.geotools.filter.function.FilterFunction_property
org.geotools.filter.function.IDFunction
org.geotools.filter.function.InterpolateFunction
org.geotools.filter.function.RecodeFunction
org.geotools.filter.function.math.FilterFunction_IEEEremainder
org.geotools.filter.function.math.FilterFunction_abs
org.geotools.filter.function.math.FilterFunction_abs_2
org.geotools.filter.function.math.FilterFunction_abs_3
org.geotools.filter.function.math.FilterFunction_abs_4
org.geotools.filter.function.math.FilterFunction_acos
org.geotools.filter.function.math.FilterFunction_asin
org.geotools.filter.function.math.FilterFunction_atan
org.geotools.filter.function.math.FilterFunction_atan2
org.geotools.filter.function.math.FilterFunction_ceil
org.geotools.filter.function.math.FilterFunction_cos
org.geotools.filter.function.math.FilterFunction_exp
org.geotools.filter.function.math.FilterFunction_floor
org.geotools.filter.function.math.FilterFunction_log
org.geotools.filter.function.math.FilterFunction_max
org.geotools.filter.function.math.FilterFunction_max_2
org.geotools.filter.function.math.FilterFunction_max_3
org.geotools.filter.function.math.FilterFunction_max_4
org.geotools.filter.function.math.FilterFunction_min
org.geotools.filter.function.math.FilterFunction_min_2
org.geotools.filter.function.math.FilterFunction_min_3
org.geotools.filter.function.math.FilterFunction_min_4
org.geotools.filter.function.math.FilterFunction_pow
org.geotools.filter.function.math.FilterFunction_random
org.geotools.filter.function.math.FilterFunction_rint
org.geotools.filter.function.math.FilterFunction_round
org.geotools.filter.function.math.FilterFunction_round_2
org.geotools.filter.function.math.FilterFunction_sin
org.geotools.filter.function.math.FilterFunction_sqrt
org.geotools.filter.function.math.FilterFunction_tan
org.geotools.filter.function.math.FilterFunction_toDegrees
org.geotools.filter.function.math.FilterFunction_toRadians
org.geotools.filter.function.math.ModuloFunction
org.geotools.filter.function.math.PiFunction
org.geotools.filter.function.string.ConcatenateFunction
org.geotools.filter.function.JenksNaturalBreaksFunction
2014-07-04 10:27:42,131 DEBUG Read lock: file:/C:/temp/div_1.prj by org.geotools.data.shapefile.prj.PrjFileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.prj by org.geotools.data.shapefile.prj.PrjFileReader
2014-07-04 10:27:42,131 DEBUG Read lock: file:/C:/temp/div_1.dbf by org.geotools.data.shapefile.dbf.DbaseFileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.dbf by org.geotools.data.shapefile.dbf.DbaseFileReader
2014-07-04 10:27:42,131 DEBUG Read lock: file:/C:/temp/div_1.shp by org.geotools.data.shapefile.shp.ShapefileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.shp by org.geotools.data.shapefile.shp.ShapefileReader
2014-07-04 10:27:42,132 DEBUG Read lock: file:/C:/temp/div_1.shx by org.geotools.data.shapefile.shp.IndexFile
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.shx by org.geotools.data.shapefile.shp.IndexFile
No source CRS found nor forced.
2014-07-04 10:27:42,140 DEBUG Read lock: file:/C:/temp/div_1.shp by org.geotools.data.shapefile.shp.ShapefileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.shp by org.geotools.data.shapefile.shp.ShapefileReader
2014-07-04 10:27:42,141 DEBUG Read lock: file:/C:/temp/div_1.shx by org.geotools.data.shapefile.shp.IndexFile
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.shx by org.geotools.data.shapefile.shp.IndexFile
2014-07-04 10:27:42,142 DEBUG Read lock: file:/C:/temp/div_1.dbf by org.geotools.data.shapefile.dbf.DbaseFileReader
: org.geotools.data.shapefile - Read lock: file:/C:/temp/div_1.dbf by org.geotools.data.shapefile.dbf.DbaseFileReader
Exception in component sPostgisOutput_1_SO
java.lang.IllegalStateException: Must call hasNext before calling next
at org.geotools.jdbc.JDBCFeatureReader.ensureNext(JDBCFeatureReader.java:252)
at org.geotools.jdbc.JDBCUpdateFeatureWriter.next(JDBCUpdateFeatureWriter.java:66)
at org.geotools.jdbc.JDBCUpdateInsertFeatureWriter.next(JDBCUpdateInsertFeatureWriter.java:71)
at org.geotools.jdbc.JDBCUpdateInsertFeatureWriter.next(JDBCUpdateInsertFeatureWriter.java:33)
at org.geotools.data.InProcessLockingManager$1.next(InProcessLockingManager.java:318)
at org.geotools.data.InProcessLockingManager$1.next(InProcessLockingManager.java:306)
at spatial_test.copy_of_test_postgis_0_1.Copy_of_test_PostGis.sShapefileInput_1_GIProcess(Copy_of_test_PostGis.java:1259)
at spatial_test.copy_of_test_postgis_0_1.Copy_of_test_PostGis.runJobInTOS(Copy_of_test_PostGis.java:1721)
at spatial_test.copy_of_test_postgis_0_1.Copy_of_test_PostGis.main(Copy_of_test_PostGis.java:1535)
I tried this with different shapefiles (and columns). The Problem also appeared when I tried to import a shapefile without any columns. The problem is the same in Version 5.4.0.
I then tested your test_PostGIS job and found the following error:
Source CRS is: GEOGCS],
AUTHORITY],
PRIMEM],
UNIT,
AXIS,
AXIS,
AUTHORITY]
Exception in component tPostgresqlOutput_1
java.sql.BatchUpdateException: Batch-Eintrag 0 INSERT INTO "public"."ne_countries" ("the_geom","scalerank","featurecla","labelrank","sovereignt","sov_a3","adm0_dif","level","type","admin","adm0_a3","geou_dif","geounit","gu_a3","su_dif","subunit","su_a3","brk_diff","name","name_long","brk_a3","brk_name","brk_group","abbrev","postal","formal_en","formal_fr","note_adm0","note_brk","name_sort","name_alt","mapcolor7","mapcolor8","mapcolor9","mapcolor13","pop_est","gdp_md_est","pop_year","lastcensus","gdp_year","economy","income_grp","wikipedia","fips_10","iso_a2","iso_a3","iso_n3","un_a3","wb_a2","wb_a3","woe_id","adm0_a3_is","adm0_a3_us","adm0_a3_un","adm0_a3_wb","continent","region_un","subregion","region_wb","name_len","long_len","abbrev_len","tiny","homepart") VALUES (GeomFromText(MULTIPOLYGON (((61.210817091725744 35.650072333309225, 62.230651483005886 35.270663967422294, 62.98466230657661 35.40404083916762, 63.19353844590035 35.857165635718914, 63.98289594915871 36.0079574651466, 64.5464791197339 36.31207326918427, 64.7461051776774 37.111817735333304, 65.58894778835784 37.30521678318564, 65.74563073106683 37.66116404881207, 66.21738488145934 37.39379018813392, 66.51860680528867 37.36278432875879, 67.07578209825962 37.35614390720929, 67.82999962755952 37.144994004864685, 68.13556237170138 37.02311513930431, 68.85944583524594 37.344335842430596, 69.19627282092438 37.15114350030743, 69.51878543485796 37.60899669041342, 70.11657840361033 37.58822276463209, 70.27057417184014 37.735164699854025, 70.3763041523093 38.13839590102752, 70.80682050973289 38.486281643216415, 71.34813113799026 38.25890534113216, 71.23940392444817 37.953265082341886, 71.54191775908478 37.905774441065645, 71.44869347523024 37.06564484308052, 71.8446382994506 36.73817129164692, 72.1930408059624 36.948287665345674, 72.63688968291729 37.047558091778356, 73.26005577992501 37.495256862939, 73.9486959166465 37.4215662704908, 74.98000247589542 37.419990139305895, 75.15802778514092 37.13303091078912, 74.57589277537298 37.02084137628346, 74.06755171091783 36.83617564548845, 72.92002485544447 36.72000702569632, 71.84629194528392 36.50994232842986, 71.26234826038575 36.074387518857804, 71.49876793812109 35.650563259416, 71.61307620635071 35.153203436822864, 71.11501875192164 34.733125718722235, 71.15677330921346 34.34891144463215, 70.8818030129884 33.98885590263852, 69.9305432473596 34.02012014417511, 70.3235941913716 33.35853261975839, 69.68714725126486 33.105498969041236, 69.26252200712256 32.5019440780883, 69.31776411324256 31.901412258424443, 68.92667687365767 31.620189113892067, 68.55693200060932 31.713310044882018, 67.79268924344478 31.58293040620963, 67.68339358914747 31.30315420178142, 66.93889122911847 31.304911200479353, 66.38145755398602 30.738899237586452, 66.34647260932442 29.887943427036177, 65.0468620136161 29.472180691031905, 64.35041873561852 29.560030625928093, 64.14800215033125 29.340819200145972, 63.55026085801117 29.468330796826166, 62.54985680527278 29.31857249604431, 60.87424848820879 29.829238999952608, 61.781221551363444 30.735850328081238, 61.69931440618083 31.379506130492672, 60.94194461451113 31.548074652628753, 60.863654819588966 32.18291962333443, 60.536077915290775 32.98126882581157, 60.963700392506006 33.52883230237626, 60.52842980331158 33.676446031218006, 60.80319339380745 34.40410187431986, 61.210817091725744 35.650072333309225))), 4326),1,Admin-0 country,3.0,Afghanistan,AFG,0.0,2.0,Sovereign country,Afghanistan,AFG,0.0,Afghanistan,AFG,0.0,Afghanistan,AFG,0.0,Afghanistan,Afghanistan,AFG,Afghanistan,,Afg.,AF,Islamic State of Afghanistan,,,,Afghanistan,,5.0,6.0,8.0,7.0,2.84E7,22270.0,-99.0,1979.0,-99.0,7. Least developed region,5. Low income,-99.0,,AF,AFG,004,004,AF,AFG,-99.0,AFG,AFG,-99.0,-99.0,Asia,Asia,Southern Asia,South Asia,11.0,11.0,4.0,-99.0,1.0) wurde abgebrochen. Rufen Sie 'getNextException' auf, um die Ursache zu erfahren.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
at zz_test_spatial.test_postgis_0_1.test_PostGis.sShapefileInput_1_GIProcess(test_PostGis.java:7702)
at zz_test_spatial.test_postgis_0_1.test_PostGis.runJobInTOS(test_PostGis.java:8002)
at zz_test_spatial.test_postgis_0_1.test_PostGis.main(test_PostGis.java:7822)
disconnected
Job test_PostGis endet am 11:10 04/07/2014.
The problem is also appearing in version 5.4.0 (as well as in Version 5.5.1). Could you help me please? I have migrated all my projects to 5.4.0 (not 5.5.1) and now can not downgrade to older versions where the PostGIS-Import was working correct.
Thanks in advance!
Best regards,
Michael Steigemann

2 REPLIES
One Star

Re: Problem with PostGIS Import (sPostgisOutput) when using TOS 5.5.1

Is moving to tPostgresqlOutput an option ? this component will be much more flexible than sPostgisOutput.
Francois
One Star

Re: Problem with PostGIS Import (sPostgisOutput) when using TOS 5.5.1

Hello Francois!
Sorry for late reply! I did not need to work on this issue in the last months.
If it is possible to upload a shapefile including the Geometry-Column by using tPostgresqlOutput   it is no problem for me to migrate to this component. 
Do you have an example how the tPostgresqlOutput component works in combination with the sShapefileInput component?
Thanks in advance,
Michael