Description of problem: When adding a package to an errata, ISE occures. Version-Release number of selected component (if applicable): Spacewalk 1.2 How reproducible: Always Steps to Reproduce: 1. Add an errata 2. http://spacewalk.example.com/rhn/errata/manage/Packages.do?eid=XY and click on "Add 3. Internal Server Error 500 Actual results: ISE Expected results: Adding pkg to errata Additional info: POstgreSQL log shows: Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-1] ERROR: function decode(numeric, integer, integer, unknown) does not exist at character 148 Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-2] HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-3] STATEMENT: SELECT AC.channel_id AS ID, Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-4] AC.channel_name AS NAME, Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-5] rhn_channel.user_role_check(AC.channel_id, $1, 'subscribe') AS HAS_PERM, Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-6] DECODE( Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-7] rhn_channel.org_channel_setting(AC.channel_id, $2,'not_globally_subscribable'), Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-8] 0, Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-9] 1, Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-10] NULL Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-11] ) AS GLOBALLY_SUBSCRIBABLE Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-12] FROM rhnAvailableChannels AC Nov 21 13:32:12 spacewalk-pg postgres[6016]: [5-13] WHERE AC.org_id = $3 Nov 21 13:32:16 spacewalk-pg postgres[6016]: [5-14] ORDER BY UPPER(AC.channel_name)
Fixed in spacewalk nightly by commit 16279c453c08f0eb6366e6225f1bad22d31d3028 655515 - changed DECODE to ANSI CASE (PG)
confirmed working, thanks
Moving to VERIFIED as per comment above. Thanks for confirmation.
This bug has been fixed in Spacewalk 1.3.