Bug 1012963
| Summary: | spacewalk-archive-audits: spacewalk.server.rhnSQL.sql_base.SQLError: (1745, 'ORA-01745: invalid host/bind variable name\n', 'select column_name from user_tab_columns where table_name = :table') | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Jan Hutař <jhutar> |
| Component: | Server | Assignee: | Grant Gainey <ggainey> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jiří Mikulka <jmikulka> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 560 | CC: | cperry, jmikulka |
| Target Milestone: | --- | Keywords: | Reopened |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | spacewalk-utils-2.0.2-12-sat | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2013-10-01 21:51:14 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: | 924171 | ||
*** This bug has been marked as a duplicate of bug 1012934 *** This is different issue than bug 1012934, waiting for updated packages. SW 0fa1cacce00f4fd1c8c53ac4143871aa247c459c Satellite 5.6 has been released. This bug was tracked under the release. This bug was either VERIFIED or RELEASE_PENDING (re-verified prior shortly before release). Moving to CLOSED CURRENT_RELEASE. Text from Upgrade Erratum follows: Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHEA-2013-1395.html |
Description of problem: Getting traceback when I attempt to archive on external Oracle Version-Release number of selected component (if applicable): spacewalk-utils-2.0.2-11.el5sat How reproducible: always Steps to Reproduce: 1. Take Satellite 5.6.0 with external Oracle 2. # spacewalk-archive-audits --archive --timestamp '2033-09-13 10:35:26' Actual results: # spacewalk-archive-audits --archive --timestamp '2033-09-13 10:35:26' Archiving... select table_name from user_tables where table_name like '%!_LOG' escape '!' RHNSERVERGROUP_LOG select column_name from user_tab_columns where table_name = :table Traceback (most recent call last): File "/usr/bin/spacewalk-archive-audits", line 232, in ? archive(options) File "/usr/bin/spacewalk-archive-audits", line 178, in archive hdr_names = _get_allcols(name) File "/usr/bin/spacewalk-archive-audits", line 122, in _get_allcols all_cols.extend(columns(name)) File "/usr/bin/spacewalk-archive-audits", line 143, in columns stmt = rhnSQL.execute(_get_sql('FIND_COLS'), table=tbl) File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py", line 172, in execute return apply(db.execute, (sql, ) + args, kwargs) File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 490, in execute apply(cursor.execute, args, kwargs) File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute return apply(self._execute_wrapper, (self._execute, ) + p, kw) File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 108, in _execute_wrapper retval = apply(function, p, kw) File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute return self._execute_(args, kwargs) File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 161, in _execute_ self._real_cursor.execute(*(None, ), **params) spacewalk.server.rhnSQL.sql_base.SQLError: (1745, 'ORA-01745: invalid host/bind variable name\n', 'select column_name from user_tab_columns where table_name = :table') Expected results: Tables should be archived.