IBM Support

PI49565: CREATING AN ENVIRONMENT FROM A BLUEPRINT FAILS WITH SQL ERROR SQLSTATE=22018

Fixes are available

IBM UrbanCode Deploy Fix Pack 2 (6.2.0.2) for 6.2
IBM UrbanCode Deploy Interim Fix 1 for 6.2.0.2

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Creating an environment from a blueprint may fail. A
DataException will appear in the logs.

ERROR http-0.0.0.0-8443-7
com.urbancode.commons.web.filter.ExceptionHandlingFilter -
org.hibernate.exception.DataException: could not update:
[com.urbancode.ds.subsys.deploy.config.environment.Environment#3
6a4c5e7-9ed1-46ea-a541-892a9712e76a]
org.hibernate.exception.DataException: could not update:
[com.urbancode.ds.subsys.deploy.config.environment.Environment#3
6a4c5e7-9ed1-46ea-a541-892a9712e76a]
    at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConver
ter.java:102)
    at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptio
nHelper.java:66)
    at
org.hibernate.persister.entity.AbstractEntityPersister.update(Ab
stractEntityPersister.java:2612)
    at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrI
nsert(AbstractEntityPersister.java:2494)
    at
org.hibernate.persister.entity.AbstractEntityPersister.update(Ab
stractEntityPersister.java:2821)
    at
org.hibernate.action.EntityUpdateAction.execute(EntityUpdateActi
on.java:113)
    at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
    at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java
:265)
    at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java
:185)
    at
org.hibernate.event.def.AbstractFlushingEventListener.performExe
cutions(AbstractFlushingEventListener.java:321)
    at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlus
h(DefaultAutoFlushEventListener.java:64)
    at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.j
ava:1185)
    at
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)
    at
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
    at
com.urbancode.ds.subsys.deploy.config.environment.EnvironmentFac
tory.getEnvironmentsWithResourceRecursively(EnvironmentFactory.j
ava:202)
    at
com.urbancode.ds.subsys.resource.domain.ResourceSyncService.sync
Resources(ResourceSyncService.java:211)
    at
com.urbancode.ds.web.rest.config.EnvironmentResource.saveEnviron
ment(EnvironmentResource.java:1449)
...
    at
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
...
Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error:
SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL, DRIVER=3.67.27
    at com.ibm.db2.jcc.am.gd.a(gd.java:741)
    at com.ibm.db2.jcc.am.gd.a(gd.java:66)
    at com.ibm.db2.jcc.am.gd.a(gd.java:135)
    at com.ibm.db2.jcc.am.so.b(so.java:2430)
    at com.ibm.db2.jcc.am.so.c(so.java:2413)
    at com.ibm.db2.jcc.t4.ab.l(ab.java:406)
    at com.ibm.db2.jcc.t4.ab.a(ab.java:62)
    at com.ibm.db2.jcc.t4.o.a(o.java:50)
    at com.ibm.db2.jcc.t4.ub.b(ub.java:220)
    at com.ibm.db2.jcc.am.to.pc(to.java:3415)
    at com.ibm.db2.jcc.am.to.b(to.java:4380)
    at com.ibm.db2.jcc.am.to.hc(to.java:782)
    at com.ibm.db2.jcc.am.to.executeUpdate(to.java:760)
    at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate
(NewProxyPreparedStatement.java:105)
    at
org.hibernate.persister.entity.AbstractEntityPersister.update(Ab
stractEntityPersister.java:2594)
    ... 73 more

Local fix

  • No workaround known.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Creating an environment from a blueprint may fail. A         *
* DataException will appear in the logs.                       *
*                                                              *
* ERROR http-0.0.0.0-8443-7                                    *
* com.urbancode.commons.web.filter.ExceptionHandlingFilter -   *
* org.hibernate.exception.DataException: could not update:     *
* [com.urbancode.ds.subsys.deploy.config.environment.Environme *
* nt#3                                                         *
* 6a4c5e7-9ed1-46ea-a541-892a9712e76a]                         *
* org.hibernate.exception.DataException: could not update:     *
* [com.urbancode.ds.subsys.deploy.config.environment.Environme *
* nt#3                                                         *
* 6a4c5e7-9ed1-46ea-a541-892a9712e76a]                         *
*     at                                                       *
* org.hibernate.exception.SQLStateConverter.convert(SQLStateCo *
* nver                                                         *
* ter.java:102)                                                *
*     at                                                       *
* org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExce *
* ptio                                                         *
* nHelper.java:66)                                             *
*     at                                                       *
* org.hibernate.persister.entity.AbstractEntityPersister.updat *
* e(Ab                                                         *
* stractEntityPersister.java:2612)                             *
*     at                                                       *
* org.hibernate.persister.entity.AbstractEntityPersister.updat *
* eOrI                                                         *
* nsert(AbstractEntityPersister.java:2494)                     *
*     at                                                       *
* org.hibernate.persister.entity.AbstractEntityPersister.updat *
* e(Ab                                                         *
* stractEntityPersister.java:2821)                             *
*     at                                                       *
* org.hibernate.action.EntityUpdateAction.execute(EntityUpdate *
* Acti                                                         *
* on.java:113)                                                 *
*     at                                                       *
* org.hibernate.engine.ActionQueue.execute(ActionQueue.java:27 *
* 3)                                                           *
*     at                                                       *
* org.hibernate.engine.ActionQueue.executeActions(ActionQueue. *
* java                                                         *
* :265)                                                        *
*     at                                                       *
* org.hibernate.engine.ActionQueue.executeActions(ActionQueue. *
* java                                                         *
* :185)                                                        *
*     at                                                       *
* org.hibernate.event.def.AbstractFlushingEventListener.perfor *
* mExe                                                         *
* cutions(AbstractFlushingEventListener.java:321)              *
*     at                                                       *
* org.hibernate.event.def.DefaultAutoFlushEventListener.onAuto *
* Flus                                                         *
* h(DefaultAutoFlushEventListener.java:64)                     *
*     at                                                       *
* org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionIm *
* pl.j                                                         *
* ava:1185)                                                    *
*     at                                                       *
* org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709)   *
*     at                                                       *
* org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)  *
*     at                                                       *
* com.urbancode.ds.subsys.deploy.config.environment.Environmen *
* tFac                                                         *
* tory.getEnvironmentsWithResourceRecursively(EnvironmentFacto *
* ry.j                                                         *
* ava:202)                                                     *
*     at                                                       *
* com.urbancode.ds.subsys.resource.domain.ResourceSyncService. *
* sync                                                         *
* Resources(ResourceSyncService.java:211)                      *
*     at                                                       *
* com.urbancode.ds.web.rest.config.EnvironmentResource.saveEnv *
* iron                                                         *
* ment(EnvironmentResource.java:1449)                          *
* ...                                                          *
*     at                                                       *
* javax.servlet.http.HttpServlet.service(HttpServlet.java:803) *
* ...                                                          *
* Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL      *
* Error:                                                       *
* SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL,              *
* DRIVER=3.67.27                                               *
*     at com.ibm.db2.jcc.am.gd.a(gd.java:741)                  *
*     at com.ibm.db2.jcc.am.gd.a(gd.java:66)                   *
*     at com.ibm.db2.jcc.am.gd.a(gd.java:135)                  *
*     at com.ibm.db2.jcc.am.so.b(so.java:2430)                 *
*     at com.ibm.db2.jcc.am.so.c(so.java:2413)                 *
*     at com.ibm.db2.jcc.t4.ab.l(ab.java:406)                  *
*     at com.ibm.db2.jcc.t4.ab.a(ab.java:62)                   *
*     at com.ibm.db2.jcc.t4.o.a(o.java:50)                     *
*     at com.ibm.db2.jcc.t4.ub.b(ub.java:220)                  *
*     at com.ibm.db2.jcc.am.to.pc(to.java:3415)                *
*     at com.ibm.db2.jcc.am.to.b(to.java:4380)                 *
*     at com.ibm.db2.jcc.am.to.hc(to.java:782)                 *
*     at com.ibm.db2.jcc.am.to.executeUpdate(to.java:760)      *
*     at                                                       *
* com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUp *
* date                                                         *
* (NewProxyPreparedStatement.java:105)                         *
*     at                                                       *
* org.hibernate.persister.entity.AbstractEntityPersister.updat *
* e(Ab                                                         *
* stractEntityPersister.java:2594)                             *
*     ... 73 more                                              *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to UCD version 6.2.0.2                               *
****************************************************************

Problem conclusion

  • Fixed in UCD version 6.2.0.2

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI49565
    • 

  • Reported component name
    UC DEPLOY
    • 

  • Reported component ID
    5725M5400
    • 

  • Reported release
    611
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2015-09-29
    • 

  • Closed date
    2015-12-18
    • 

  • Last modified date
    2015-12-18
    • 





    

  • 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
    UC DEPLOY
    • 

  • Fixed component ID
    5725M5400
    • 



Applicable component levels


    

  • R600  PSN
       UP
    • 

  • R600  PSY
       UP
    • 

  • R601  PSN
       UP
    • 

  • R601  PSY
       UP
    • 

  • R610  PSN
       UP
    • 

  • R610  PSY
       UP
    • 

  • R611  PSN
       UP
    • 

  • R611  PSY
       UP
    • 

  • R612  PSN
       UP
    • 

  • R612  PSY
       UP
    • 

  • R613  PSN
       UP
    • 

  • R613  PSY
       UP
    • 

  • R620  PSN
       UP
    • 

  • R620  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"611","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            17 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback