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.
