IBM Support

JR64092: THE BPMCONFIG -CREATE COMMAND FAILS WITH SQL0554N, AND THE SQL SCRIPTS DO NOT GET GENERATED

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.

 

APAR status

  • Closed as program error.

Error description

  • When you try to create the IBM Integration Designer unit test
environment and database type is DB2, the BPMConfig -create
command might fail with SQL0554N, and the database scripts do
not get generated as the database was not created correctly.

Since the command includes the -s parameter, and DB2 does not
allow permissions to be granted to the user itself,
db2cmd /c /w /i db2 -stf "./createDatabase_ECM.sql"
the execution of createDatabase_ECM.sql stops when an error is
encountered.

PRODUCTS AFFECTED:
IBM Business Automation Workflow

Local fix

  • 



Problem summary


    

  • No additional information is available.

    



Problem conclusion


    

  • A fix is available or will be available that will tolerant the
SQL0554N error.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR64092
    • 

  • 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-08-20
    • 

  • Closed date
    2023-11-20
    • 

  • Last modified date
    2023-11-20
    • 





    

  • 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


    








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            22 November 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback