Uploaded image for project: 'Network Controller'
  1. Network Controller
  2. SDNC-463

Macro instantiation flow fails in generate-unique-name DG

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: High High
    • Casablanca Release
    • Casablanca Release
    • sdnc-oam
    • HEAT deployment in integration lab SB07

      Below is log excerpt, the full log is in attachment.

       

      2018-09-18T20:32:48,053 | DEBUG | qtp1173655953-127 | CachedDataSource | 211 - org.onap.ccsdk.sli.core.dblib-provider - 0.3.0.SNAPSHOT | SvcLogicGraph [module=GENERIC-RESOURCE-API, rpc=generate-unique-name, mode=sync, version=1.4.0-SNAPSHOT, md5sum=d7d1d7fca0cac99603bc3091ca060ed6] - 1 (block) | Obtained connection <sdnctldb01>: ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@3298f4c6]]
      2018-09-18T20:32:48,056 | DEBUG | qtp1173655953-127 | CachedDataSource | 211 - org.onap.ccsdk.sli.core.dblib-provider - 0.3.0.SNAPSHOT | SvcLogicGraph [module=GENERIC-RESOURCE-API, rpc=generate-unique-name, mode=sync, version=1.4.0-SNAPSHOT, md5sum=d7d1d7fca0cac99603bc3091ca060ed6] - 1 (block) | SQL FAILURE. time(ms): 3
      2018-09-18T20:32:48,057 | ERROR | qtp1173655953-127 | CachedDataSource | 211 - org.onap.ccsdk.sli.core.dblib-provider - 0.3.0.SNAPSHOT | SvcLogicGraph [module=GENERIC-RESOURCE-API, rpc=generate-unique-name, mode=sync, version=1.4.0-SNAPSHOT, md5sum=d7d1d7fca0cac99603bc3091ca060ed6] - 1 (block) | <sdnctldb01> Failed to execute: insert into GENERIC_RESOURCE_NAME values ( 'SERVICE_INSTANCE' , 'Service_Ete_Namee442a997-e904-4d96-a834-32a420330ff9' , null , null, null ) with no arguments.
      java.sql.SQLException: (conn=39946) Column count doesn't match value count at row 1
      at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:179) [197:org.mariadb.jdbc:2.1.1]
      at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118) [197:org.mariadb.jdbc:2.1.1]
      at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235) [197:org.mariadb.jdbc:2.1.1]
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224) [197:org.mariadb.jdbc:2.1.1]
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159) [197:org.mariadb.jdbc:2.1.1]
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:192) [197:org.mariadb.jdbc:2.1.1]
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[?:?]
      at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) [155:org.apache.tomcat.jdbc:8.5.14]
      at com.sun.proxy.$Proxy58.executeUpdate(Unknown Source) [155:org.apache.tomcat.jdbc:8.5.14]
      at org.onap.ccsdk.sli.core.dblib.CachedDataSource.executeUpdatePreparedStatement(CachedDataSource.java:222) [211:org.onap.ccsdk.sli.core.dblib-provider:0.3.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.dblib.CachedDataSource.writeData(CachedDataSource.java:134) [211:org.onap.ccsdk.sli.core.dblib-provider:0.3.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeDataNoRecovery(DBResourceManager.java:556) [211:org.onap.ccsdk.sli.core.dblib-provider:0.3.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeData(DBResourceManager.java:509) [211:org.onap.ccsdk.sli.core.dblib-provider:0.3.0.SNAPSHOT]
      at Proxyd2f9e276_0a8e_4cd3_8d9e_e425afe58a47.writeData(Unknown Source) [?:?]
      at Proxy04b705fc_2bcb_43d6_b4ff_eea79f20abc1.writeData(Unknown Source) [?:?]
      at org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource.executeSqlWrite(SqlResource.java:238) [210:org.onap.ccsdk.sli.adaptors.sql-resource-provider:0.3.0.SNAPSHOT]
      at org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource.save(SqlResource.java:344) [210:org.onap.ccsdk.sli.adaptors.sql-resource-provider:0.3.0.SNAPSHOT]
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[?:?]
      at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:54) [97:org.apache.aries.proxy:1.1.1]
      at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:119) [97:org.apache.aries.proxy:1.1.1]
      at org.onap.ccsdk.sli.adaptors.resource.sql.$SqlResource820174330.save(Unknown Source) [210:org.onap.ccsdk.sli.adaptors.sql-resource-provider:0.3.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.sli.provider.SaveNodeExecutor.execute(SaveNodeExecutor.java:86) [214:org.onap.ccsdk.sli.core.sli-provider:0.3.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.sli.provider.SvcLogicServiceImpl.executeNode(SvcLogicServiceImpl.java:181) [214:org.onap.ccsdk.sli.core.sli-provider:0.3.0.SNAPSHOT]
      74549,14-21 93%

            djtimoney Dan Timoney
            xuyang11 xuyang11
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: