[SOLVED] API-response error
Hi,
I'm writing a script to update certain fields in Windows workstation CI's.
I got it working on our development server running SDP 9425 but i get an error when running it on our production server with SDP 9335.
Is there a workaround to get around the error on 9335? I need the script working asap, and we haven't scheduled an update for SDP until next yer.
On 9335 i get this API response:
{"API":{"response":{"operation":{"result":{"message":"java.sql.SQLException: The data types ntext and nvarchar are incompatible in the equal to operator.","status":"Unknown error.","statuscode":3001},"name":"update"}},"version":1}}
It seems like it's the pick-list fields that genererates the error above. The script works for other aditional fields.
Here is the XML-input data (Works in 9425 but not in 9335):
<?xml version='1.0' encoding='UTF-8'?>
<API version='1.0' >
<citype>
<name>Windows Workstation</name>
<criterias>
<criteria>
<parameter>
<name compOperator="IS">CI Name</name>
<value>rgsit0259</value>
</parameter>
</criteria>
</criterias>
<newvalue>
<record>
<parameter>
<name>Motpart</name>
<value>3010 Regionservice</value>
</parameter></record>
</newvalue>
</citype>
</API>