SUSE Manager 2.1 mgr-sync refresh returns a 500 Internal Server Error

This document (7018395) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 2.1

Situation

Attempting to run a mgr-sync refresh on a SUSE Manager 2.1 server returns a 500 Internal Server Error

Resolution

Look for the following error in the /var/log/rhn/rhn_web_api.log:

redstone.xmlrpc.XmlRpcFault: unhandled internal exception: could not delete collection: [com.redhat.rhn.domain.product.SUSEProduct.extensionOf#1629]

Cause

This error is caused by fully patching a SUSE Manager 2.1 server and not running spacewalk-schema-upgrade. To upgrade the schema run the following on the SUSE Manager Server:

1. spacewalk-service stop
2. spacewalk-schema-upgrade

A message similar to the following will appear:

Schema upgrade: [susemanager-schema-2.1.50.16-15.2] -> [susemanager-schema-2.1.50.18-21.1]
Searching for upgrade path to: [susemanager-schema-2.1.50.18-21.1]
Searching for upgrade path to: [susemanager-schema-2.1.50.18]
Searching for start path: [susemanager-schema-2.1.50.16-15.2]
Searching for start path: [susemanager-schema-2.1.50.16]
The path: [susemanager-schema-2.1.50.16] -> [susemanager-schema-2.1.50.17] -> [susemanager-schema-2.1.50.18]
Planning to run schema upgrade with dir '/var/log/spacewalk/schema-upgrade/schema-from-20161215-105938'
Hit Enter to continue or Ctrl+C to interrupt:

Simply press Enter to continue.

3. spacewalk-service start

The mgr-sync refresh should now run without issue.

Additional Information

It should be noted that there are other causes of 500 errors and the current fix described here may not apply in all situations. This document will be updated with additional fixes for 500 errors.

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.