Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-13964

MSSQL Explicit table with custom attributes throws 500 on every query

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a defect
    • Affects Version/s: 7.0.0
    • Fix Version/s: None
    • Labels:
    • Environment:
      Windows-8-6.2.9200-SP0
      OPENIDM 7.0.0-SNAPSHOT (a035f5b)
      OpenJDK 1.8.0_222

      Description

      IDM return 500 Internal Server Error, if was add a column to an explicit table.

      org.forgerock.openidm.script.ScriptThrownException: Wrapped org.forgerock.json.resource.InternalServerErrorException: DB reported failure executing query. {code=500, reason=Internal Server Error, message=DB reported failure executing query., detail={}}
      

      Set up PyForge to reproduce:
      1. Remove comments pyforge/lib/products/servers/forgerock/openidm/IDMMSSQL.py :

              # if explicit:  # For repo with explicit mapping, we add extra columns required by some tests
              #     IDMRepositories.add_columns_in_script(idm_instance)
              #     IDMRepositories.add_columns_in_config(idm_instance)
      

      2. config.cfg

      Fill MSSQL part and

      repo_type = mssql_explicit_table
      

      3. Run:

      run-pybot.py -t managed_user_queries_should_be_recorded openIDM
      

      Curl which throws error:

      curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --header "Content-Type: application/json" --data "{\"givenName\": \"Steven\", \"sn\": \"Carter\", \"mail\": \"scarter@example.com\", \"telephoneNumber\": \"444-444-4444\", \"password\": \"Passw0rd\", \"displayName\": \"Steven.Carter\", \"description\": \"Managed User\", \"userName\": \"scarter\"}" -X POST http://idm-win2012641.ad.idm-robot-windows.com:8080/openidm/managed/user?_action=create
      

      See the log file for more details.

        Attachments

        1. openidm0.log.0
          2.26 MB
        2. repo.jdbc.json
          27 kB
        3. sample-explicit-managed-user.sql
          3 kB

          Activity

            People

            • Assignee:
              brmiller Brendan Miller
              Reporter:
              petr.bednar Petr Bednar [X] (Inactive)
              QA Assignee:
              Petr Bednar [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: