Uploaded image for project: 'Configuration Persistence Service'
  1. Configuration Persistence Service
  2. CPS-1126 CmHandle creation performance degradation
  3. CPS-1246

Investigation SQL Error fetching Resource Ids by Module References

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Medium Medium
    • London Release
    • None
    • CPS-Core
    • None

      Problem : We were passing the list of only existing Module References (eliminating the new ones from the list) which is in turn used to insert schema set yang resources.

      Fix : Pass all the module references and no need to discard the new ones from the list.

       

      Possible Changes :

      org/onap/cps/ncmp/api/inventory/sync/ModuleSyncService.java#syncAndCreateSchemaSetAndAnchor  --> 

      existing : createSchemaSetAndAnchor(yangModelCmHandle, newModuleNameToContentMap, existingModuleReferencesFromCmHandle);

      new :      createSchemaSetAndAnchor(yangModelCmHandle, newModuleNameToContentMap, allModuleReferencesFromCmHandle); // similar logic change as per the intention

       

      Also have a check in org/onap/cps/spi/repository/YangResourceNativeRepositoryImpl.java#getResourceIdsByModuleReferences to return an empty list of ids if there are no module references to prevent the SQL Error: 0, SQLState: 02000"

       

       

            mpriyank Priyank Maheshwari
            mpriyank Priyank Maheshwari
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: