Bug 655509 - ISE on assigning system entitlements to org on spacewalk w/postgresql
Summary: ISE on assigning system entitlements to org on spacewalk w/postgresql
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.2
Hardware: x86_64
OS: Linux
low
low
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space13
TreeView+ depends on / blocked
 
Reported: 2010-11-21 13:20 UTC by Luc de Louw
Modified: 2011-02-08 08:41 UTC (History)
0 users

Fixed In Version: spacewalk-schema-1.3.2-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-08 08:41:16 UTC
Embargoed:


Attachments (Terms of Use)

Description Luc de Louw 2010-11-21 13:20:31 UTC
Description of problem:
When adding system entitlements on /rhn/admin/multiorg/OrgSystemSubscriptions.do, the result is an ISE


Version-Release number of selected component (if applicable):
Spacewalk 1.2

How reproducible:
Always

Steps to Reproduce:
1. Create a new Org
2. Add some entitlements on /rhn/admin/multiorg/OrgSystemSubscriptions.do?oid=XY
3. Internal Server Error 500
  
Actual results:
ISE

Expected results:
Successfully add entitlements

Additional info:
PostgreSQL log show the following error:

Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-1] ERROR:  function modify_org_service(numeric, unknown, unknown) does not exist at character 9
Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-2] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-3] QUERY:  SELECT  modify_org_service( $1 , 'enterprise', 'Y')
Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-4] CONTEXT:  PL/pgSQL function "set_customer_enterprise" line 2 at PERFORM
Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-5]      SQL statement "SELECT  rhn_entitlements.set_customer_enterprise( $1 )"
Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-6]      PL/pgSQL function "assign_system_entitlement" line 69 at PERFORM
Nov 21 13:19:12 spacewalk-pg postgres[5869]: [7-7] STATEMENT:  select * from rhn_entitlements.assign_system_entitlement($1,$2,$3,$4) as result

Comment 1 Michael Mráka 2010-11-22 16:17:00 UTC
Fixed in spacewalk nightly by
commit 77ffaab00aea2d80b6fa92b0987860eff7d72f6a
    655509 - fixed namespace

Comment 2 Luc de Louw 2011-01-20 06:18:20 UTC
confirmed working,

Thanks

Comment 3 Michael Mráka 2011-01-20 10:14:37 UTC
Moving to VERIFIED as per comment above.

Thanks for confirmation.

Comment 4 Tomas Lestach 2011-02-08 08:41:16 UTC
This bug has been fixed in Spacewalk 1.3.


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