Hi Vishal, I used to face a similar issue in VID when moving it to common DB.
"Table '*vid_openecomp_epsdk.VID_JOB' doesn't exist"* The above error is due to VID expecting "case-insensitiveness" in the DB. More info here ( https://mariadb.com/docs/reference/mdb/system-variables/lower_case_table_names/ ) As a part of the change, I moved mariadb to use "lower_case_table_names=1" in the mariadb-galera/values.yaml <https://gerrit.onap.org/r/c/oom/+/113597/15/kubernetes/common/mariadb-galera/values.yaml> This option can be set only at init time of the DB and not at runtime. Can you check if this is set in your DB instance running. Without it VID will not work. The above link has details on how to check it in a running DB (by logging into one of the DB instance pod) In case it is not set, then you need to set it to "1" and re-deploy ONAP. thanks, -RP On Fri, Apr 30, 2021 at 1:48 PM <[email protected]> wrote: > > > We are facing issue when deploying VID component in Guilin release also > from Master branch but facing issues, due to this we are totally stuck to > run vFW demo. Below the background given: > > > > *Background*: We are setting up the ONAP components (from the Guilin > release) on the OKD cluster and able to setup all the components except VID. > > We tried with various VID releases, but none of them is working for one or > another reason. > > > > *Option1*: Tried to setup the VID from the Guilin release 7.0.0, but the > vid pod is crashing with below error. > > > > > > > *Localizing the VID quartz configurationERROR: Could not process template > file /usr/local/tomcat/webapps/vid/WEB-INF/conf/quartz_template.properties > into /usr/local/tomcat/webapps/vid/WEB-INF/conf/quartz.propertiessed: -e > expression #5, char 27: unknown option to `s'[t974240@chdcovh01 > /appl/codebase/testrepo/oom/kubernetes]$* > > > > *Option2*: Installed VID from the master branch. Though, Pods are up and > running but seeing DB errors in the vid pod logs and VID UI is not coming > up due to these errors (Details are available in the ticket). > > > > Raised ticket https://jira.onap.org/browse/VID-983 > <https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fjira.onap.org%2Fbrowse%2FVID-983&data=04%7C01%7CVishal.Sharma%40spark.co.nz%7Cc90b499a86ab427ea8d208d90b16b75f%7Cf6b3cec6a8624a409ab400d6e11e6f0f%7C0%7C0%7C637553014520805602%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=r0vpc9o8ejI%2FvcOfUJtiAmekbQsuoxib37M0ffjMETE%3D&reserved=0> > but not getting any response. > > > > > -- *CRN Top 10 Coolest Edge Computing Startups of 2020 <https://www.crn.com/slide-shows/networking/the-10-coolest-edge-computing-startups-of-2020/2>* -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#23172): https://lists.onap.org/g/onap-discuss/message/23172 Mute This Topic: https://lists.onap.org/mt/82476408/21656 Mute #vid:https://lists.onap.org/g/onap-discuss/mutehashtag/vid Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
