Bug 1316642

Summary: spacewalk-dump-schema ORA-24334 @ s390x
Product: Red Hat Satellite 5 Reporter: Lukáš Hellebrandt <lhellebr>
Component: UpgradesAssignee: Tomáš Kašpárek <tkasparek>
Status: CLOSED WONTFIX QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: tlestach, xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-03-22 08:29:15 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:

Description Lukáš Hellebrandt 2016-03-10 16:30:32 UTC 
Description of problem:
When running spacewalk-dump-schema as part of upgrade (doc/satellite-and-os-upgrade-postgresql.txt , step 1), on a s390x machine with satellite 5.4.1 with EmbOracle (maybe others, but NOT x86_64 with sat 5.4.1 on EmbOracle, tested), the following error occurs:

DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from rhnpackageevr"] at ./spacewalk-dump-schema line 369.

There exists some dump as a result but importing it as per doc results in WebUI ISEs and impossible spacewalk-schema-upgrade, so the exported dump is just broken.

Version-Release number of selected component (if applicable):
rhn-upgrade-5.7.0.29-1.el6sat (and probably others)

How reproducible:
Deterministic

Steps to Reproduce:
1. Have a sat 5.4.1 @ s390x with EmbOracle, up to date
2. Have rhn-upgrade package installed
3. Run /etc/sysconfig/rhn/satellite-upgrade/scripts/spacewalk-dump-schema

Actual results:
Broken dump, ORA error

Expected results:
Importable dump, no errors reported