Bug 1012963 - 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')
Summary: spacewalk-archive-audits: spacewalk.server.rhnSQL.sql_base.SQLError: (1745, '...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 560
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
Assignee: Grant Gainey
QA Contact: Jiří Mikulka
URL:
Whiteboard:
Depends On:
Blocks: sat560-blockers
TreeView+ depends on / blocked
 
Reported: 2013-09-27 13:06 UTC by Jan Hutař
Modified: 2014-10-06 13:45 UTC (History)
2 users (show)

Fixed In Version: spacewalk-utils-2.0.2-12-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-10-01 21:51:14 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jan Hutař 2013-09-27 13:06:22 UTC
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.

Comment 2 Jan Hutař 2013-09-27 13:13:23 UTC

*** This bug has been marked as a duplicate of bug 1012934 ***

Comment 3 Jan Hutař 2013-09-27 13:18:36 UTC
This is different issue than bug 1012934, waiting for updated packages.

Comment 4 Grant Gainey 2013-09-27 13:55:03 UTC
SW 0fa1cacce00f4fd1c8c53ac4143871aa247c459c

Comment 8 Clifford Perry 2013-10-01 21:51:14 UTC
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


Note You need to log in before you can comment on or make changes to this bug.