on 01-07-2016 7:37 AM
Hello,
Through web messaging we try to send NC CODE and comment that is longer then 1024 we get error "Value is too long (11439 > 1024) (Message 12032).
We have created also custom data field named COMMENT and yes that field lenght is 1024. But Error comes also when we try to send comment to NCDATA table.
BR,
Kalmer
Dear Kalmer,
As far as I know the NVCHAR(MAX) size equals to 4000 charachters. As long as you get the error 'Value us too long (11439 > 1024)' , I am not positive it is thrown against NC_DATA.COMMENTS field.
Could you share the request you send?
Br, Alex.
Message was edited by: Alexander Teslyuk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kalmer,
What database are you using? The predefined data field is called COMMENTS not COMMENT.
Are you using createNC PAPI?
If so, make sure you are using the comments field and not a user defined field in the customValue section where you can specify any fieldName as these are limited to 1024.
Regards,
Andrew.
We are using MSSQL database and yes field is NC_DATA.COMMENTS nvarchar(max);
NC_CUSTOM_DATA.DATA_ATTR nvarchar(1024);
And we have set NC_CUSTOM_DATA.DATA_FIELD as "COMMENTS" also.
But we are trying to send comments against NC_DATA.COMMENTS column.
We are running webservice against: http://<servername>:<port>/manufacturing-services/ProductionServiceService?wsdl
I attached request what we are sending.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.