PH09307: DDL NOT GENERATED FOR JAVA SP WHEN DEFINING APPLICATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DOE doesn't generate the DDL for Java SP when defining an
  application in DOE, then also fails to provision an instance
  for that application with Java SP.
  Problem Description
  The text file under applications/.git/<application uuid>/SP
  is an empty file with size 0 after the application is created
  successfully and shown on DOE GUI.
  Then click "provision a new instance" against that new
  application on DOE GUI, returned the following error:
  Error
  DOES002E - Internal server error: 'DB2 SQL Error: SQLCODE=-104,
  SQLSTATE=42601, SQLERRMC=);ROW NEXTVAL PREVVAL NEXT
  PREVIOUS <BXSTRING> DATE TIME, DRIVER=3.72.44'
  (Thread.java:1154).
  Same result even I manually hack and put the DDL into the
  text file.
  Json file content which I used to create the application in
  DOE (also tried pointing the uri field to a textual file which
  has SP ddl, same result):
  {
  "__yamlClass": "com.rocketsoft.newton.policy.Application",
  "name": "TPCDwithSP",
  "description": "TPCDwithJavaSP",
  "hexColor": "0x00cccc",
  "ownedByTeam": "0fa5bb0d-6489-4147-b587-fbebd2edf64f",
  "requiredApps": [],
  "db2objects": [
  { "__yamlClass": "com.rocketsoft.newton.policy.Db2Object",
    "qualifier": "STPDGM", "name": "GETEMP", "subsystem":
    "73e38728-2e9a-4ea5-b4f5-6d50b9b10f90", "type": "SP", "uri":
  null }
  ]
  }
  DDL of JavaSP:
  set current schema = 'STPDGM';
  CREATE PROCEDURE GETEMP(IN DEPTNAME CHAR(4))
  DYNAMIC RESULT SETS 1
  EXTERNAL NAME 'getEmp.x_getEmp'
  LANGUAGE Java
  PARAMETER STYLE JAVA
  NOT DETERMINISTIC
  COLLID NULLID
  WLM ENVIRONMENT WLMJAVA;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Application Discovery                   *
  *                      Most notably, in this release we        *
  *                      refactored application discovery        *
  *                      functionality for enhanced performance  *
  *                      and usability.                          *
  *                      We have redesigned the graph display    *
  *                      and selection mechanism with a tabular  *
  *                      format populated from user-specified    *
  *                      search criteria.                        *
  *                      Users can select individual objects and *
  *                       add them to a list of objects to be    *
  *                       included in an application. Upon       *
  *                       submission, the system automatically   *
  *                       adds any required object(s) to ensure  *
  *                       the application definition is valid.   *
  *                       In this release, objects that depend   *
  *                       upon selected objects are also         *
  *                       automatically added.                   *
  *                      Additional improvements to application  *
  *                      discovery will be included in a future  *
  *                      PTF.                                    *
  *                                                              *
  *                      Site Rules                              *
  *                      Optionally, site rules can now be       *
  *                      applied to future applications by       *
  *                      default. We corrected an issue with the *
  *                      INDEX UNIQUE must_be_absent/present     *
  *                      rule.                                   *
  *                                                              *
  *                      DDL Management                          *
  *                      We made a cosmetic usability            *
  *                      enhancement and minor content           *
  *                      corrections to the DDL Diff page.       *
  *                      We corrected an issue with adding       *
  *                      objects to existing applications.       *
  *                      We fixed an issue with the state of the *
  *                      "Apply these DDL changes" button.       *
  *                      We addressed an issue with nested views *
  *                      when generating DDL.                    *
  *                      We fixed an issue with aliases when     *
  *                      generating DDL.                         *
  *                      We addressed issues with the DDL Change *
  *                      Report content.                         *
  *                                                              *
  *                      Application and Instance Management     *
  *                      Users can now refresh page content for  *
  *                      Application Management and Instance     *
  *                      Management.                             *
  *                      We addressed issues with application    *
  *                      deprovisioning.                         *
  *                      We fixed an issue that arose when       *
  *                      provisioning applications without a     *
  *                      database or tablespace.                 *
  *                      We addressed an issue with stored       *
  *                      procedure qualifiers during instance    *
  *                      provisioning.                           *
  *                                                              *
  *                      Pull Request Management                 *
  *                      We corrected an issue with the list of  *
  *                      pull requests to approve.               *
  *                      We fixed a problem with viewing stored  *
  *                      procedure changes in pull requests.     *
  *                                                              *
  *                      Cosmetic Changes                        *
  *                      We enhanced hover behavior to ensure    *
  *                      all data is visible.                    *
  *                      We corrected the Application tile       *
  *                      header color behavior.                  *
  *                      We corrected selected application       *
  *                      highlight behavior.                     *
  *                      We corrected the position of the status *
  *                      bar.                                    *
  *                                                              *
  *                      User and Team Management                *
  *                      We fixed a performance issue with the   *
  *                      user and team management pages.         *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI62271

Modules/Macros

• ADB1000  ADB27AC  ADB27ACR ADB28MC  ADB2CIX  ADB2CMP  ADB2GEN
  ADB2RE   ADB2USCO ADB2USOP ADB2USRO ADB2UTCO ADB2UTLV ADB2W1
  ADB7000  ADBCDCX  ADBCEXX  ADBCVEZ  ADBETEP  ADBGAJOB ADBSUSU3
  ADBTCL   ADBTEP2  ADBTEPA  ADBTEPX  ADBTIMC  ADBTREO  ADBTRUN
  DOESERVE DOEUI    DOEZOWE  GOC00    GOC0001  GOC01    GOC02
  GOC2000  GOC2DTC  GOC4000  GOCCCM   GOCCM    GOCCMM
  

Fix information

• Fixed component name

  DB2 DEVOPS EXPR

• Fixed component ID

  5698DEX00

Applicable component levels

• R110 PSY UI62271

     UP19/04/04 P F904

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.