SQL Profile Provider Error "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"

SecureAuth Idp Version affected: All

Description:  

When using SQL to store some of the Profile entries for a user, the following error occurs

SqlProfileProvider.SetPropertyValues: Error received when saving data to user storage, exception: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 37 ("@DigitalFP"), row 0, column 0: Data type 0xF3 (user-defined table type) has a non-zero length database name specified. Database name is not allowed with a table-valued parameter, only schema name and type name are valid.

Cause:  The Standard SQL Stored Procedures expects a value for certain attributes. This isn't a problem when using SQL as the complete profile store but when only using it for a few attributes, if these values are missing, it throws an error. 

Resolution:

1. Open the Admin Console
2. On the Realm in question, click on the Data tab
3. Set the follow 4 Attributes to be stored in SQL

• Fingerprints
• Push Notification Tokens
• Oath Tokens
• Access Histories.

SecureAuth Knowledge Base Articles provide information based on specific use cases and may not apply to all appliances or configurations. Be advised that these instructions could cause harm to the environment if not followed correctly or if they do not apply to the current use case.

Customers are responsible for their own due diligence prior to utilizing this information and agree that SecureAuth is not liable for any issues caused by misconfiguration directly or indirectly related to SecureAuth products.