cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Profile Data Can Not Be Uploaded to FlexNet Connect If More than 450 Characters

Profile Data Can Not Be Uploaded to FlexNet Connect If More than 450 Characters

Summary

Due to a limitation of SQL server, an index on the Profile table will limit the value length to 450 characters. To work around the problem, this index can safely be dropped allowing a value of up to 2000 characters.

Symptoms

When uploading profile data to FlexNet Connect, the upload will fail if a profile value is longer than 450 characters. This will result in an exception similar to the following being thrown by the multi-platform client when upload is called:

ServerErrorResponseException
A service system error was encountered: Server was not able to process request correctly. FNC Server profile update error. [1,7DF,3,2[7000001C,4003,200100FB]]

Cause

This is due to a limitation in SQL server.

Resolution

To resolve the issue, the index idxProfileValue needs to be dropped from the ProfileCollection collection table in the Flexnet Connect operational DB (by default this is named isus). The following query should be used to drop this index:

drop INDEX profileCollection.idxProfileValue

As Flexnet Connect never does a lookup based on value, dropping this index will not affect performance.

Note that this is only applicable to On Premise (self-hosted) customers.
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Oct 15, 2018 10:30 PM
Updated by: