JR40636: WHEN GROUP BY IS SET, CANNOT REOPEN SQL BUILDER WITH "AN ERROR OCCURRED INVOKING THE SQL BUILDER:"

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as fixed if next.

Error description

• When GROUP BY is set, cannot reopen SQL Builder with the
  following message:
  
  
  "An error occured invoking the SQL Builder:"
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users that invoke SQLBuilder and attempt to perform a GROUP BY.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Under 7.5.3 the user attempts to use the GROUP BY clause then it
  is likely to crash the application if used with a non aggregate
  function.
  On 8.x the issue is that the GROUP BY functionality has been
  restricted to no longer allow functions, which is incorrect.
  This was possibly as a result of the GROUP BY issue exhibited
  in 7.5.3.
  ****************************************************************
  RECOMMENDATION:
  Edit the generated GROUP BY SQL statement to include functions
  if they are required.
  ****************************************************************
  

Problem conclusion

Temporary fix

• Edit the generated GROUP BY SQL statement to include functions
  if they are required.
  

Comments

• This is resolved at 8.5 FP3, 8.7 FP1, and 9.1 GA.
  For other releases, use the supplied workaround
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP

• R753 PSN

     UP

• R801 PSN

     UP

• R810 PSN

     UP