Bug 1654647

Summary: Adding custon info keys to SSM throws Internal Server Error
Product: [Community] Spacewalk Reporter: Laurence Rochfort <laurence.rochfort>
Component: WebUIAssignee: Michael Mráka <mmraka>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: high Docs Contact:
Priority: unspecified    
Version: 2.9CC: tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Linux   
Whiteboard:
Fixed In Version: spacewalk-schema-2.10.2-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-03-19 12:16:19 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1802137    

Description Laurence Rochfort 2018-11-29 10:37:58 UTC 
Description of problem:
Attempting to add custom info keys to a system set produces the following PL/SQL error.

ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
Rolling back
javax.servlet.ServletException: com.redhat.rhn.common.db.WrappedSQLException:
ORA-06550: line 1, column 7:
PLS-00221: 'BULK_SET_CUSTOM_VALUE' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Version-Release number of selected component (if applicable):
2.7, 2.8, 2.9

Steps to Reproduce:
Select Servers --> System Set Manager --> Misc --> Set and Remove values for
selected Systems --> Key-Label: MY_LABEL --> Value: 12345 --> Set Values -->
"Internal Server Error"
Comment 1 Tomas Lestach 2019-11-06 08:28:44 UTC 
https://github.com/spacewalkproject/spacewalk/commit/7f2daa14b87c5228bd7cb6fb83853652ff4307f8
Comment 2 Tomas Lestach 2019-11-06 08:31:20 UTC 
Switching to MODIFIED, since the PR has been accepted to Spacewalk. :-)
Comment 3 Michael Mráka 2020-03-19 12:16:19 UTC 
Spacewalk 2.10 has been released.
https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes210