PH15135: POTENTIALLY MALFORMED SQL STATEMENTS WHEN USING THE GENERAL REPORTING TAB

APAR status

• Closed as program error.

Error description

• When using the general reporting tab of UrbanCode Build to
  create reports, either via the graphical user interface or the
  text-based entry, selecting certain columns from certain tables
  may result in a malformed SQL statement that is missing
  necessary join statements.
  An example stack trace would look like the following:
  
  java.lang.RuntimeException: java.sql.SQLSyntaxErrorException:
  ORA-00904: "T_6"."NAME": invalid identifier
          at
  com.urbancode.ureport.server.database.DatabaseQuery.run(Database
  Query.java:143)
          at
  com.urbancode.ureport.web.rest.resources.QueryResource.query(Que
  ryResource.java:48)
          at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown
  Source)
          at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:43)
  

Local fix

• Where possible, use alternative columns from other tables that
  provide the equivalent values (e.g. IDs or Names).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Potentially malformed SQL statements when using the general  *
  * reporting tab to create reports.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix for this issue is included in UrbanCode Build fix pack
  version 6.1.5.1. Upgrading to this version will fix the issue.
  

Temporary fix

Comments

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

  URBANCODE BUILD

• Fixed component ID

  5725P5700

Applicable component levels