IBM Support

JR63299: YOU CAN'T UPGRADE TO IBM BUSINESS AUTOMATION WORKFLOW 20.0.0.2 FROM 20.0.0.1 IF THE DATABASE TYPE IS IBM Db2 FOR Z/OS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

Direct link to fix

8.6.20020002-WS-BPM-IFJR63299

 

APAR status

  • Closed as program error.

Error description

  • If you try to upgrade IBM Business Automation Workflow 20.0.0.1
to 20.0.0.2, and the database type is IBM Db2 for z/OS, no
upgrade SQL files are generated when you run the
BPMGenerateUpgradeSchemaScripts command. As a result, the
databases are not upgraded and you see the following error in
the bootstrapProcesServerData log file when you try to start the
 Deployment Manager (dmgr) server:

[2/1/21 0:27:03:274 CET] 00000001 XmlBeanDefini I
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions Loading XML bean definitions from class path
resource [org/springframework/jdbc/support/sql-error-codes.xml]
[2/1/21 0:27:03:296 CET] 00000001 SQLErrorCodes I
org.springframework.jdbc.support.SQLErrorCodesFactory <init>
SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL,
MySQL, Oracle, PostgreSQL, Sybase, Hana]
[2/1/21 0:27:03:320 CET] 00000001 ProviderTrack I
com.ibm.ffdc.osgi.ProviderTracker AddingService FFDC1007I: FFDC
Provider Installed:
com.ibm.ffdc.util.provider.FfdcOnDirProvider@b5a53504
[2/1/21 0:27:03:326 CET] 00000001 Ffdc          I
com.ibm.ffdc.util.provider.FfdcOnDirProvider logIncident
FFDC1003I: FFDC Incident emitted on
/opt/zpsw04l/IBM/WebSphere/AppServer/profiles/dmgr/logs/ffdc/ffd
c.5199706789139316413.txt null
com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo
rt
[2/1/21 0:27:03:328 CET] 00000001 TWXImportExpo I   CWLLG0162I:
Import Failed
[2/1/21 0:27:03:328 CET] 00000001 ImportFileHel I   File
/opt/zpsw04l/IBM/WebSphere/AppServer/BPM/Lombardi/imports/system
-toolkit.twx failed.....
[2/1/21 0:27:03:329 CET] 00000001 ImportFileHel I
PreparedStatementCallback; bad SQL grammar [select
PROJECT_ID,CREATED_ON,LAST_MODIFIED,ARCHIVED_ON,NAME,DESCRIPTION
,SHORT_NAME,SHARED_ON,SOLUTION_ID,SOLUTION_SERVER_NAME,SOLUTION_
PREFIX,TYPE,ICON,SOLUTION_TARGET_STORE,FIELD1,FIELD2,FIELD3,FIEL
D4,CREATED_BY_USER_ID,LAST_MODIFIED_BY_USER_ID,RELEASE_PROCESS_I
D,RELEASE_PROCESS_BRANCH_ID,SHARED_BY_USER_ID,IS_ARCHIVED,IS_TOO
LKIT,IS_BRANCHING_ENABLED,IS_HIDDEN,IS_SYSTEM,IS_IMMUTABLE,IS_SH
ARED,IS_GOVERNED,IS_GOVERNANCE,IS_TEMPLATE,FIELD5 from
LSW_PROJECT where PROJECT_ID = ?]; nested exception is
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SOLUTION_TARGET_STORE,
DRIVER=4.26.18
[2/1/21 0:27:03:330 CET] 00000001 ImportFileHel E   CWLLG2015E:
An unexpected runtime exception occurred. See exception for more
details.  Error: PreparedStatementCallback; bad SQL grammar
[select
PROJECT_ID,CREATED_ON,LAST_MODIFIED,ARCHIVED_ON,NAME,DESCRIPTION
,SHORT_NAME,SHARED_ON,SOLUTION_ID,SOLUTION_SERVER_NAME,SOLUTION_
PREFIX,TYPE,ICON,SOLUTION_TARGET_STORE,FIELD1,FIELD2,FIELD3,FIEL
D4,CREATED_BY_USER_ID,LAST_MODIFIED_BY_USER_ID,RELEASE_PROCESS_I
D,RELEASE_PROCESS_BRANCH_ID,SHARED_BY_USER_ID,IS_ARCHIVED,IS_TOO
LKIT,IS_BRANCHING_ENABLED,IS_HIDDEN,IS_SYSTEM,IS_IMMUTABLE,IS_SH
ARED,IS_GOVERNED,IS_GOVERNANCE,IS_TEMPLATE,FIELD5 from
LSW_PROJECT where PROJECT_ID = ?]; nested exception is
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SOLUTION_TARGET_STORE,
DRIVER=4.26.18.

org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [select
PROJECT_ID,CREATED_ON,LAST_MODIFIED,ARCHIVED_ON,NAME,DESCRIPTION
,SHORT_NAME,SHARED_ON,SOLUTION_ID,SOLUTION_SERVER_NAME,SOLUTION_
PREFIX,TYPE,ICON,SOLUTION_TARGET_STORE,FIELD1,FIELD2,FIELD3,FIEL
D4,CREATED_BY_USER_ID,LAST_MODIFIED_BY_USER_ID,RELEASE_PROCESS_I
D,RELEASE_PROCESS_BRANCH_ID,SHARED_BY_USER_ID,IS_ARCHIVED,IS_TOO
LKIT,IS_BRANCHING_ENABLED,IS_HIDDEN,IS_SYSTEM,IS_IMMUTABLE,IS_SH
ARED,IS_GOVERNED,IS_GOVERNANCE,IS_TEMPLATE,FIELD5 from
LSW_PROJECT where PROJECT_ID = ?]; nested exception is
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SOLUTION_TARGET_STORE,
DRIVER=4.26.18
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransla
tor.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra
nslator.translate(AbstractFallbackSQLExceptionTranslator.java:73
)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
java:660)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.ja
va:695)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.ja
va:727)
at
com.lombardisoftware.utility.db.spring.BPMJdbcTemplate.query(BPM
JdbcTemplate.java:244)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.ja
va:737)
at
com.lombardisoftware.utility.db.spring.BPMJdbcTemplate.query(BPM
JdbcTemplate.java:187)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.ja
va:787)
at
com.lombardisoftware.utility.db.spring.BPMJdbcTemplate.query(BPM
JdbcTemplate.java:225)
at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(Si
mpleJdbcTemplate.java:227)
at
com.lombardisoftware.utility.db.spring.BPMSimpleJdbcTemplate.que
ry(BPMSimpleJdbcTemplate.java:684)
at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(Si
mpleJdbcTemplate.java:233)
at
com.lombardisoftware.utility.db.spring.BPMSimpleJdbcTemplate.que
ry(BPMSimpleJdbcTemplate.java:226)
at
com.lombardisoftware.server.ejb.persistence.dao.UnversionedPODAO
.findQuietlyByPrimaryKey(UnversionedPODAO.java:492)
at
com.lombardisoftware.server.ejb.persistence.DefaultHandler.findQ
uietlyByPrimaryKey(DefaultHandler.java:132)
at
com.lombardisoftware.server.ejb.persistence.PersistenceServicesC
ore$4.call(PersistenceServicesCore.java:222)
at
com.lombardisoftware.server.ejb.persistence.PersistenceServicesC
ore$4.call(PersistenceServicesCore.java:220)
at
com.lombardisoftware.server.ejb.persistence.versioning.BranchMan
ager.readAccess(BranchManager.java:213)
at
com.lombardisoftware.server.ejb.persistence.versioning.BranchMan
ager.readAccess(BranchManager.java:193)
at
com.lombardisoftware.server.ejb.persistence.PersistenceServicesC
ore.findQuietlyByPrimaryKey(PersistenceServicesCore.java:220)

Local fix

  • 1. Restore the dmgr profile.
2. Go to the BAW_INSTALL_ROOT/BPM/dbscripts/DB2zOS/Upgrade on
the dmgr machine and run the following commands:
cp upgradeSchema20001_PerformanceDW.sql
upgradeSchema862_CF2000.1_PerformanceDW.sql
cp upgradeSchema20001_ProcessServer.sql
upgradeSchema862_CF2000.1_ProcessServer.sql
3. Re-run the BPMGenerateUpgradeSchemaScripts command.
4. Follow the steps in "Upgrading profiles from IBM Business
Automation Workflow V18.0.0.x, V19.0.0.x, or V20.0.0.1 to IBM
Business Automation Workflow V20.0.0.2"
(https://www.ibm.com/support/pages/node/6365899).

Problem summary

  • This problem happens because the upgrade SQL files are not
generated by the BPMGenerateUpgradeSchemaScripts command.

Problem conclusion

  • A fix that will generate the correct upgrade SQL files when the
database type is IBM Db2 for z/OS will be included in a future
release of Business Automation Workflow.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR63299
    • 

  • Reported component name
    BUS AUTO WORKFL
    • 

  • Reported component ID
    5737H4100
    • 

  • Reported release
    K00
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2021-02-05
    • 

  • Closed date
    2021-03-05
    • 

  • Last modified date
    2021-03-05
    • 





    

  • 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
    BUS AUTO WORKFL
    • 

  • Fixed component ID
    5737H4100
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            06 March 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback