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

Fix DB syntax errors on load of database schemas for sdnc docker container bring-up

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Medium Medium
    • Amsterdam Release
    • None
    • sdnc-oam
    • None
    • SDNC Sprint 5

      On sdnc container bring-up the following errors are printed to console while loading database schemas:
      "

      sdnc_controller_container | ERROR 1064 (42000) at line 66: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `NETWORK_MODEL` ENABLE KEYS */' at line 2
      {{}}

      sdnc_controller_container | mysql: [Warning] Using a password on the command line interface can be insecure.

      sdnc_controller_container | ERROR 1064 (42000) at line 48: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('00e50cbd-ef0f-4b28-821e-f2b583752dd3','!!com.att.sdnctl.uebclient.SdncNetworkS' at line 2

      "

      It appears these errors are present due to missing commas and semi-colons and affect: 

      1. sdnc\oam\installation\sdnc\src\main\resources\network_model.data.dump
      2. sdnc\oam\installation\sdnc\src\main\resources\service_model.data.dump

            mgkwill mgkwill
            mgkwill mgkwill
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: