Parameter table sos 4.4.0

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Parameter table sos 4.4.0

sanguinela
Hi Carsten,
I have another question. Insert in parameter table is supported in sos v.4.4.0?
I'm trying to call insertObservation with this example parameter:

<om:parameter>
                        <om:NamedValue>
                            <om:name xlink:href="quantityParameter"/>
                            <om:value xsi:type="gml:MeasureType" uom="cm">5.0</om:value>
                        </om:NamedValue>
</om:parameter>

Sos give me this error:

          <ows:ExceptionText>[EXCEPTION]:
Batch entry 0 insert into public.parameter (observationId, name, parameterId) values (62, 'quantityParameter', 5) was aborted.  Call getNextException to see the cause.</ows:ExceptionText>
        </ows:Exception>

and if I try to execute sql command, I receive this error:

null values in the "definition" column violate the constraint not-null

Have you any hints?

thank so much.

S.
Reply | Threaded
Open this post in threaded view
|

Re: Parameter table sos 4.4.0

Carsten Hollmann
Hi,

your parameter table is invalid.
In the previous versions parameter table exists but it was not used and
for v4.4.x the parameter table was refactored.
A "forces update" during the installation does not work in this case.

Therefore, we recommend to install the SOS 4.4.0 into an empty database
and create the tables during the installation.

Best,
Carsten
_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Reply | Threaded
Open this post in threaded view
|

Re: Parameter table sos 4.4.0

sanguinela
Great! Thank Carsten.

Regards.
S.