When creating User Profile Service Application,gives invalid column name 'RecordId' error.

Error I tried following action,

  • create user profile service with powershell but same result
  • create user profile service Configuration Wizards but same result
  • Manage Service Application add new service on Central Admin but same result
  • added February 2019 CU(KB4462171-KB4462170) and again create service but same result

I checked ULS Viewer with Correlation ID;

High Error; High Error

Exception; Exception Error

Unexpected;Unexpected Error

1 Answer 1


This problem is big I and small i(Maybe due to language mismatch between farm and db). There is syntax eror on sql query file.

For Solution,

  • Open Query File (profilesrp.sql)(C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\TEMPLATE\SQL\SPS )
  • take backup this file. enter image description here
  • Edit this file on line 16583 and 16635

enter image description here

enter image description here

4)Start Configuration Wizard on Central Admin and create UserProfile Service. Best regard.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.