Description of problem: I received SQL traceback ORA-00904: "CS"."SSL_CLIENT_KEY_ID": invalid identifier.. when I try to show report of all repositories. >> spacewalk-report repositories SQL error occurred, traceback follows... Traceback (most recent call last): File "/usr/bin/spacewalk-report", line 243, in <module> h.execute(**dict(report.params.items() + the_dict_where.items())) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute return self._execute_wrapper(self._execute, *p, **kw) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 122, in _execute_wrapper raise_with_tb(sql_base.SQLStatementPrepareError(errno, errmsg, self.sql), sys.exc_info()[2]) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 113, in _execute_wrapper retval = function(*p, **kw) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 205, in _execute return self._execute_(args, kwargs) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 167, in _execute_ self._real_cursor.execute(*(None, ), **params) spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('ORA-00904: "CS"."SSL_CLIENT_KEY_ID": invalid identifier\n', 904, 'select * from ( select cs.org_id, cs.id, cs.label as repo_label, cst.label as repo_type, cs.source_url, ck_key.description as client_key_descr, ck_key.crypto_key_type_id as client_key_type, ck_key.key as client_key, ck_cert.description as client_cert_descr, ck_cert.crypto_key_type_id as client_cert_type, ck_cert.key as client_cert, ck_ca.description as ca_descr, ck_ca.crypto_key_type_id as ca_type, ck_ca.key as ca_key from rhncontentsource cs left outer join rhncryptokey ck_key on ck_key.id = cs.ssl_client_key_id left outer join rhncryptokey ck_cert on ck_cert.id = cs.ssl_client_cert_id left outer join rhncryptokey ck_ca on ck_ca.id = cs.ssl_ca_cert_id join rhncontentsourcetype cst on cs.type_id = cst.id where cs.org_id is not null ) X order by org_id, id') Version-Release number of selected component (if applicable): spacewalk-reports-2.7.2-1.el6.noarch How reproducible: always on postgresql and oracle Steps to Reproduce: 1. spacewalk-report repositories Actual results: SQL traceaback Expected results: it works Additional info: On postgresql the traceback looks following: SQL error occurred, traceback follows... Traceback (most recent call last): File "/usr/bin/spacewalk-report", line 243, in <module> h.execute(**dict(report.params.items() + the_dict_where.items())) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute return self._execute_wrapper(self._execute, *p, **kw) File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 306, in _execute_wrapper raise sql_base.SQLStatementPrepareError(self.dbh, e.pgerror, self.sql) spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('ERROR: column cs.ssl_client_key_id does not exist\nLINE 8: ...eft outer join rhncryptokey ck_key on ck_key.id = cs.ssl_cli...\n ^\n', <connection object at 0xe262f0; dsn: 'password=xxxxxxx dbname=spaceschema user=spaceuser', closed: 0>, '\n select * from (\n select cs.org_id, cs.id, cs.label as repo_label, cst.label as repo_type, cs.source_url,\n ck_key.description as client_key_descr, ck_key.crypto_key_type_id as client_key_type, ck_key.key as client_key,\n ck_cert.description as client_cert_descr, ck_cert.crypto_key_type_id as client_cert_type, ck_cert.key as client_cert,\n ck_ca.description as ca_descr, ck_ca.crypto_key_type_id as ca_type, ck_ca.key as ca_key\n from rhncontentsource cs\n left outer join rhncryptokey ck_key on ck_key.id = cs.ssl_client_key_id\n left outer join rhncryptokey ck_cert on ck_cert.id = cs.ssl_client_cert_id\n left outer join rhncryptokey ck_ca on ck_ca.id = cs.ssl_ca_cert_id\n join rhncontentsourcetype cst on cs.type_id = cst.id\n where cs.org_id is not null\n ) X\n -- where placeholder\n order by org_id, id\n')
It looks that it is fixed for SW Nightly (2.7). spacewalk-reports-2.7.5-1.el6.noarch spacewalk-java-2.7.92-1.el6.noarch
Spacewalk 2.7 has been released. https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes27