User creation on Satellite fails with 'ERROR: relation "rhnresetpassword" does not exist"'

Solution Unverified - Updated -

Environment

  • Red Hat Satellite 5.7

Issue

  • User creation on Satellite 5.7 fails with ERROR: relation "rhnresetpassword" does not exist"
[TP-Processor9] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: com.redhat.rhn.common.db.WrappedSQLException: ERROR: relation "rhnresetpassword" does not exist

Resolution

  • Check the Satellite schema version, if its 5.7.0.19-1 and below, then upgrade it to the latest.
  • Refer How do I upgrade the database schema of a Red Hat Satellite server?
  • If issue is still observed even after applying the said errata,please open a support case with Red Hat Technical Support and share output of below commands with them:
# spacewalk-sql -i
rhnschema=# select V.label, EVR.version, EVR.release, V.created, V.modified from rhnVersionInfo V, rhnPackageEvr EVR  WHERE V.evr_id = EVR.id order by modified;

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.