SAP Knowledge Base Article - Public

3310725 - Creating Super Admin User Throws Error:" Exception in creating an admin user:Wrapped Exception: SQLException thrown SAP DBTech JDBC: [260]: invalid column name: USERS_SYS_PRONOUNS" 

Symptom

Creating super admin user from Provisioning returns the error: Exception in creating an admin user:Wrapped Exception: SQLException thrown SAP DBTech JDBC: [260]: invalid column name: USERS_SYS_PRONOUNS  

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Partners/Customer Support try to create a super admin user in Provisioning
  2. Company Settings
  3. Add the required data.
  4. And click save and the error appears:

"Exception in creating an admin user:Wrapped Exception: SQLException thrown SAP DBTech JDBC: [260]: invalid column name: USERS_SYS_PRONOUNS" 

Cause

Database Error

Resolution

  1. Go to Provisioning.
  2. Manage Schedule Jobs.
  3. Create new job.
  • Job Name: (any text which can identify this job)
  • Job Owner: (usually the system admin / super user)
  • Job Type: Company Schema Upgrade Job
  • Rerun Options: the XML file name, example: add_permission_for_ect_benefits_admin.xml
  • Occurrence: Once
  • Click button: Create Job

      4. Run a job of the type of Company Schema Upgrade Job.
      5. From the Manage Scheduled Jobs page find the job you just created.
      6. In the column Actions click the Select button.
      7. Choose Run it Now.

See Also

Keywords

super admin, USERS_SYS_PRONOUNS, Exception in creating an admin user:Wrapped Exception:, Company Schema Upgrade Job , KBA , LOD-SF-PLT-PRVR , Issues with Manage Provisioning Access Tool , Problem

Product

SAP SuccessFactors HCM Suite all versions