summaryrefslogtreecommitdiffstats
path: root/kubernetes
AgeCommit message (Collapse)AuthorFilesLines
2018-04-26Merge "Policy Nexus component needs persistent volume"Mike Elliott4-0/+114
2018-04-26Merge "Policy Config Correction"Mike Elliott8-11/+10
2018-04-26Remove namespace from clamp valuesac25501-10/+10
Templating system seems to fail when included in json. As namespace isn't required, use current namespace as default. Change-Id: Ic9936054c2285cd79004bc94c1aa8b6ee544324d Issue-ID: OOM-920 Signed-off-by: ac2550 <ac2550@intl.att.com>
2018-04-26Policy Nexus component needs persistent volumeMahendra Raghuwanshi4-0/+114
Issue-ID: OOM-849 Change-Id: I86692b520f9661fac06cb0e9ea1d0373eb04df27 Signed-off-by: Mahendra Raghuwanshi <mahendra.raghuwanshi@amdocs.com>
2018-04-26Policy Config CorrectionMahendra Raghuwanshi8-11/+10
Issue-ID: OOM-1011 Change-Id: I85444ebb9df9368d96f55bb968291351c9d286d5 Signed-off-by: Mahendra Raghuwanshi <mahendra.raghuwanshi@amdocs.com>
2018-04-25Merge "Fix a typo in chart name"Mike Elliott1-1/+1
2018-04-25Merge "Fix the janus graph cached properties"Mandeep Khinda2-4/+4
2018-04-25Merge "Remove the duplicate volume mounts"Mandeep Khinda1-8/+0
2018-04-25Fix the janus graph cached propertiesKajur, Harish (vk250x)2-4/+4
missing the global release name Change-Id: Ieebed34bd115763dadd4452cf91ab1205f0f9c53 Issue-ID: AAI-1100 Signed-off-by: Kajur, Harish (vk250x) <vk250x@att.com>
2018-04-25Fix a typo in chart nameLusheng Ji1-1/+1
Issue-ID: OOM-1007 Change-Id: Ie8e6243fd7068d796a0bf77f9e3c25b937f0b86a Signed-off-by: Lusheng Ji <lji@research.att.com>
2018-04-25Merge "Update ROBOT DCAE healthcheck endpoint"Jerome Doucerain2-2/+2
2018-04-25Merge "Add OOM dependency on Champ"Mandeep Khinda1-0/+2
2018-04-25Merge "Synch ete-k8s.sh and ete.sh"Mike Elliott1-2/+10
2018-04-25Merge "Fix demo-k8"Mike Elliott1-3/+9
2018-04-25Merge "Adding sdc-onboarding-be to OOM"Borislav Glozman32-79/+861
2018-04-25Update ROBOT DCAE healthcheck endpointMike Elliott2-2/+2
See Jira issue for details. Change-Id: Iacdb5d7f73610ceeaf60b1b09d8cf3cd755b5391 Issue-ID: OOM-1007 Signed-off-by: Mike Elliott <mike.elliott@amdocs.com>
2018-04-25Merge "Add new model loader config parameters"Mandeep Khinda2-4/+11
2018-04-25Adding sdc-onboarding-be to OOMMandeep Khinda32-79/+861
-adding sdc-onboarding-be chart -sdc-cs and es are now in a cluster format -using the sdc provided ready probe script for readiness -increasing the initial delay as per sdc project team k8s specs -fixed logging bugs. logs for be, fe, onboard-be are now in /var/log/onap/sdc/blah -sdc-be readiness health check is failing which prevents sdb-be from becoming "ready". -the commit that changes the template is: Add cluster resiliance support (c033cdce906efc3b6ccd1d2f45544af47e328ed4) Issue-ID: OOM-1002 Change-Id: Ib231cb1e7daa287a41e04db95528edecbdbbf7bc Signed-off-by: Mandeep Khinda <mandeep.khinda@amdocs.com>
2018-04-25Add new model loader config parametersDaniel Silverthorn2-4/+11
Change-Id: I347f78d8d911664befcf35dbf1c5edd56b493a66 Issue-ID: AAI-1094 Signed-off-by: Daniel Silverthorn <daniel.silverthorn@amdocs.com>
2018-04-25Remove the duplicate volume mountsKajur, Harish (vk250x)1-8/+0
AAI Create widget models are not successfully created since for the update query data job the right config maps were not loaded due to the duplicate of volume mounts Issue-ID: OOM-1005 Change-Id: I79c9b0e5c5679b990f63aa200430739938deb272 Signed-off-by: Kajur, Harish (vk250x) <vk250x@att.com>
2018-04-24Fix cloudify manager image versionJack Lucas1-1/+1
Change-Id: Iab5c73fc9ebcef5b31a44adc7ce2d39d754f4aee Issue-ID: OOM-1003 Signed-off-by: Jack Lucas <jflucas@research.att.com>
2018-04-24Merge "Make all services independent of helm Release.Name"Mike Elliott159-386/+449
2018-04-24Merge "updated the MR image version"Mandeep Khinda1-1/+1
2018-04-24Merge "changing portal liveness/readiness probe"Mike Elliott1-4/+14
2018-04-24updated the MR image versionsu622b1-1/+1
Issue-ID: DMAAP-433 Change-Id: If47a4ea3fb1f3614e06dbdedc360e1bbee7d2a23 Signed-off-by: su622b <sunil.unnava@att.com>
2018-04-24Make all services independent of helm Release.NameBorislavG159-386/+449
Issue-ID: OOM-906 Change-Id: Ic65127d3981cb0a696c784392cab59fbf06b1e66 Signed-off-by: BorislavG <Borislav.Glozman@amdocs.com>
2018-04-24Update VID imageSonsino, Ofir (os0695)1-1/+1
Change-Id: I70cbe0b60816a370b5dabb9e9819b538a44213ef Issue-ID: VID-218 Signed-off-by: Sonsino, Ofir (os0695) <os0695@intl.att.com>
2018-04-24Merge "Update vfc charts configutation"Mandeep Khinda3-1/+10
2018-04-24changing portal liveness/readiness probeMandeep Khinda1-4/+14
Inspired by aai-cassandra's stateful set Using nodetool instead of a port. Issue-ID: MUSIC-72 Change-Id: I877300d772c3357855756a9dcac6f148381615da Signed-off-by: Mandeep Khinda <mandeep.khinda@amdocs.com>
2018-04-23Synch ete-k8s.sh and ete.shBrian Freeman1-2/+10
Issue-ID: OOM-989 Change-Id: I8db1ea5919d15d4213367cf1acca7b2e63651355 Signed-off-by: Brian Freeman <bf1936@att.com>
2018-04-23Fix demo-k8Brian Freeman1-3/+9
Issue-ID: OOM-794 Change-Id: I07674d726496f7d30350033b4a3ad0ad337f4b28 Signed-off-by: Brian Freeman <bf1936@att.com>
2018-04-23Merge "Add DCAE Bootstrap support"Mike Elliott16-0/+556
2018-04-23Merge "Add DCAE Cloudify-Manager support"Mike Elliott18-110/+559
2018-04-23Merge "Fix DCAE Redis"Mike Elliott10-9/+10
2018-04-23Merge "Fix Log logstash healthcheck port number"Mike Elliott2-3/+3
2018-04-23Fix Log logstash healthcheck port numberNeal Chatterley2-3/+3
Issue-ID: OOM-914 Change-Id: Iccb699def449a49fb184c8d0426fb51bf239f010 Signed-off-by: Neal Chatterley <nealch@amdocs.com>
2018-04-23Merge "Fix multicloud service registration in MSB"Mike Elliott1-1/+1
2018-04-22Add DCAE healthcheckJack Lucas5-0/+207
Change-Id: Icd3839ae7570547550cf9a3df3a129181f187f24 Issue-ID: DCAEGEN2-461 Signed-off-by: Jack Lucas <jflucas@research.att.com>
2018-04-22Add DCAE Bootstrap supportBorislavG16-0/+556
** Changes to add readiness checks for all dependencies, make copyright notices consistent. This commit adds a job that is supposed to spin-up DCAE Few problems: Bootstrap fails looking for consul service, which has Release.Name prefix. Release.Name will soon be removed everywhere. Meanwhile can run helm insall/upgrade providing parameter: --set dcaegen2.dcae-bootstrap.config.address.consul.host=<Release.Name>-consul-server backoffLimit: 0 in the job does not seem to work on my environment therefore left it in a comment There are many TODO, which need to be cleaned-out (by DCAE team) Change-Id: If54440544cb9c8f4ac9aff59ac6752023fb3e670 Issue-ID: OOM-854 Signed-off-by: BorislavG <Borislav.Glozman@amdocs.com> Signed-off-by: Jack Lucas <jflucas@research.att.com>
2018-04-22Add DCAE Cloudify-Manager supportBorislavG18-110/+559
22/Apr: This review is ready to merge. ** Resolves issue by using the k8s-provided secret. No longer need to map .kube/config. Change-Id: I0f51f7d8bb9ed9a5653089e77be495dc7456ef22 Issue-ID: OOM-855 Signed-off-by: BorislavG <Borislav.Glozman@amdocs.com> Signed-off-by: Jack Lucas <jflucas@research.att.com>
2018-04-22Fix DCAE RedisBorislavG10-9/+10
Change-Id: Ie9375030601961ee6975f49acddb9822e1eb067c Issue-ID: OOM-985 Signed-off-by: BorislavG <Borislav.Glozman@amdocs.com>
2018-04-20Revert policy keystoreMike Elliott1-0/+0
See comment posted April 20th at 5:46pm under patch https://gerrit.onap.org/r/#/c/43601/ for details. Change-Id: I5b669b02b9b5a3a95aa7040847153564807d05df Issue-ID: POLICY-747 Signed-off-by: Mike Elliott <mike.elliott@amdocs.com>
2018-04-20Fix multicloud service registration in MSBjasmineWen1-1/+1
Issue-ID: OOM-912 Change-Id: I296ffe80a4c886f6d8888f3862d715fa0f59d1f3 Signed-off-by: jasmineWen <jasmine.wen@amdocs.com>
2018-04-20Merge "Support truststore with AAF root certs"Mike Elliott1-0/+0
2018-04-20Merge "Fix startODL.sh"Mandeep Khinda1-5/+7
2018-04-20Merge "getting portal-cassandra music to start"Mike Elliott3-34/+13
2018-04-20Fix startODL.shTrevor Tait1-5/+7
Issue-ID: SDNC-286 Change-Id: I223e97c634deac5d235701f30e755b86b13a27ad Signed-off-by: Trevor Tait <rtait@amdocs.com>
2018-04-20Add OOM dependency on Champsblimkie1-0/+2
Champ needs to wait for kafka to come up Change-Id: I0a5fef89a08fc5cd538bf949403927987fcb14c0 Issue-ID: AAI-1085 Signed-off-by: sblimkie <steven.blimkie@amdocs.com>
2018-04-20Merge "Fix message router config for UUI"Mandeep Khinda2-2/+2
2018-04-20fixing sdc health checkMandeep Khinda12-58/+98
-Basically compared docker_run.sh from sdc master branch with charts/values in OOM -disabling sdc-kb liveness until we tune the timing of it Issue-ID: OOM-964 Change-Id: I7447eed47c919d5d64786f45e01b5f2a3bc490a0 Signed-off-by: Mandeep Khinda <mandeep.khinda@amdocs.com>
3c1f14b7682","lcpCloudRegionId":"mtn6"},"requestParameters":{"subscriptionServiceType":"MSO-dev-service-type","userParams":[{"name":"someUserParam","value":"someValue"}],"aLaCarte":true,"autoBuildVfModules":false,"cascadeDelete":false,"usePreload":true,"alaCarteSet":true,"alaCarte":true}}', null, 'APIH', null, null, null, null, null, null, null, null, 'mtn6', null, null, null, null, null, 'service', 'createInstance', null, 'MSODEV_1707_SI_vSAMP10a_011-4', 'xxxxxx', null, null, null, null, 'http://localhost:8080/onap/so/infra/serviceInstantiation/v7/serviceInstances'), ('001619d2-a297-4a4b-a9f5-e2823c88458f', '001619d2-a297-4a4b-a9f5-e2823c88458f', 'CREATE_VF_MODULE', 'COMPLETE', 'COMPLETED', '100', '2016-07-01 14:11:42', '2017-05-02 16:03:34', 'PORTAL', null, 'test-vscp', 'elena_test21', null, null, '381b9ff6c75e4625b7a4182f90fc68d3', null, null, null, STRINGDECODE('<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<vnf-request xmlns=\"http://org.onap.so/mso/infra/vnf-request/v1\">\n <request-info>\n <request-id>001619d2-a297-4a4b-a9f5-e2823c88458f</request-id>\n <action>CREATE_VF_MODULE</action>\n <source>PORTAL</source>\n </request-info>\n <vnf-inputs>\n <vnf-name>test-vscp</vnf-name>\n <vf-module-name>moduleName</vf-module-name>\n <vnf-type>elena_test21</vnf-type>\n <vf-module-model-name>moduleModelName</vf-module-model-name>\n <asdc-service-model-version>1.0</asdc-service-model-version>\n <service-id>a9a77d5a-123e-4ca2-9eb9-0b015d2ee0fb</service-id>\n <aic-cloud-region>mtn9</aic-cloud-region>\n <tenant-id>381b9ff6c75e4625b7a4182f90fc68d3</tenant-id>\n <persona-model-id></persona-model-id>\n <persona-model-version></persona-model-version>\n <is-base-vf-module>false</is-base-vf-module>\n </vnf-inputs>\n <vnf-params xmlns:tns=\"http://org.onap.so/mso/infra/vnf-request/v1\"/>\n</vnf-request>\n'), 'NONE', 'RDBTEST', '2016-07-01 14:11:42', 'VNF', null, null, null, 'MODULENAME1', 'moduleModelName', 'a9a77d5a-123e-4ca2-9eb9-0b015d2ee0fb', 'mtn9', null, null, null, null, null, 'vfModule', 'createInstance', null, null, null, null, null, null, null, 'http://localhost:8080/onap/so/infra/serviceInstantiation/v7/serviceInstances'); INSERT INTO PUBLIC.INFRA_ACTIVE_REQUESTS(REQUEST_ID, CLIENT_REQUEST_ID, ACTION, REQUEST_STATUS, STATUS_MESSAGE, PROGRESS, START_TIME, END_TIME, SOURCE, VNF_ID, VNF_NAME, VNF_TYPE, SERVICE_TYPE, AIC_NODE_CLLI, TENANT_ID, PROV_STATUS, VNF_PARAMS, VNF_OUTPUTS, REQUEST_BODY, RESPONSE_BODY, LAST_MODIFIED_BY, MODIFY_TIME, REQUEST_TYPE, VOLUME_GROUP_ID, VOLUME_GROUP_NAME, VF_MODULE_ID, VF_MODULE_NAME, VF_MODULE_MODEL_NAME, AAI_SERVICE_ID, AIC_CLOUD_REGION, CALLBACK_URL, CORRELATOR, NETWORK_ID, NETWORK_NAME, NETWORK_TYPE, REQUEST_SCOPE, REQUEST_ACTION, SERVICE_INSTANCE_ID, SERVICE_INSTANCE_NAME, REQUESTOR_ID, CONFIGURATION_ID, CONFIGURATION_NAME, OPERATIONAL_ENV_ID, OPERATIONAL_ENV_NAME, REQUEST_URL) VALUES ('00164b9e-784d-48a8-8973-bbad6ef818ed', null, 'createInstance', 'COMPLETE', 'Service Instance was created successfully.', '100', '2017-09-28 12:45:51', '2017-09-28 12:45:53', 'VID', null, null, null, null, null, '19123c2924c648eb8e42a3c1f14b7682', null, null, null, '{"modelInfo":{"modelCustomizationName":null,"modelInvariantId":"52b49b5d-3086-4ffd-b5e6-1b1e5e7e062f","modelType":"service","modelNameVersionId":null,"modelName":"MSO Test Network","modelVersion":"1.0","modelCustomizationUuid":null,"modelVersionId":"aed5a5b7-20d3-44f7-90a3-ddbd16f14d1e","modelCustomizationId":null,"modelUuid":null,"modelInvariantUuid":null,"modelInstanceName":null},"requestInfo":{"billingAccountNumber":null,"callbackUrl":null,"correlator":null,"orderNumber":null,"productFamilyId":null,"orderVersion":null,"source":"VID","instanceName":"DEV-MTN6-3100-0927-1","suppressRollback":false,"requestorId":"xxxxxx"},"relatedInstanceList":null,"subscriberInfo":{"globalSubscriberId":"MSO_1610_dev","subscriberName":"MSO_1610_dev"},"cloudConfiguration":{"aicNodeClli":null,"tenantId":"19123c2924c648eb8e42a3c1f14b7682","lcpCloudRegionId":"mtn6"},"requestParameters":{"subscriptionServiceType":"MSO-dev-service-type","userParams":[{"name":"someUserParam","value":"someValue"}],"aLaCarte":true,"autoBuildVfModules":false,"cascadeDelete":false,"usePreload":true,"alaCarte":true},"project":null,"owningEntity":null,"platform":null,"lineOfBusiness":null}', null, 'CreateGenericALaCarteServiceInstance', '2017-09-28 12:45:52', null, null, null, null, null, null, null, 'mtn6', null, null, null, null, null, 'service', 'createInstance', 'b2f59173-b7e5-4e0f-8440-232fd601b865', 'DEV-MTN6-3100-0927-1', 'md5621', null, null, null, null, 'http://localhost:8080/onap/so/infra/serviceInstantiation/v7/serviceInstances'), ('00173cc9-5ce2-4673-a810-f87fefb2829e', null, 'createInstance', 'FAILED', 'Error parsing request. No valid instanceName is specified', '100', '2017-04-14 21:08:46', '2017-04-14 21:08:46', 'VID', null, null, null, null, null, 'a259ae7b7c3f493cb3d91f95a7c18149', null, null, null, '{"modelInfo":{"modelInvariantId":"ff6163d4-7214-459e-9f76-507b4eb00f51","modelType":"service","modelName":"ConstraintsSrvcVID","modelVersion":"2.0","modelVersionId":"722d256c-a374-4fba-a14f-a59b76bb7656"},"requestInfo":{"productFamilyId":"LRSI-OSPF","source":"VID","requestorId":"xxxxxx"},"subscriberInfo":{"globalSubscriberId":"a9a77d5a-123e-4ca2-9eb9-0b015d2ee0fb"},"cloudConfiguration":{"tenantId":"a259ae7b7c3f493cb3d91f95a7c18149","lcpCloudRegionId":"mtn16"},"requestParameters":{"subscriptionServiceType":"Mobility","userParams":[{"name":"neutronport6_name","value":"8"},{"name":"neutronnet5_network_name","value":"8"},{"name":"contrailv2vlansubinterface3_name","value":"false"}]}}', null, 'APIH', null, null, null, null, null, null, null, null, 'mtn16', null, null, null, null, null, 'service', 'createInstance', null, null, null, null, null, null, null, 'http://localhost:8080/onap/so/infra/serviceInstantiation/v7/serviceInstances'), ('0017f68c-eb2d-45bb-b7c7-ec31b37dc349', null, 'activateInstance', 'UNLOCKED', null, '20', '2017-09-26 16:09:29', null, 'VID', null, null, null, null, null, null, null, null, null, '{"modelInfo":{"modelCustomizationName":null,"modelInvariantId":"1587cf0e-f12f-478d-8530-5c55ac578c39","modelType":"configuration","modelNameVersionId":null,"modelName":null,"modelVersion":null,"modelCustomizationUuid":null,"modelVersionId":"36a3a8ea-49a6-4ac8-b06c-89a545444455","modelCustomizationId":"68dc9a92-214c-11e7-93ae-92361f002671","modelUuid":null,"modelInvariantUuid":null,"modelInstanceName":null},"requestInfo":{"billingAccountNumber":null,"callbackUrl":null,"correlator":null,"orderNumber":null,"productFamilyId":null,"orderVersion":null,"source":"VID","instanceName":null,"suppressRollback":false,"requestorId":"xxxxxx"},"relatedInstanceList":[{"relatedInstance":{"instanceName":null,"instanceId":"9e15a443-af65-4f05-9000-47ae495e937d","modelInfo":{"modelCustomizationName":null,"modelInvariantId":"de19ae10-9a25-11e7-abc4-cec278b6b50a","modelType":"service","modelNameVersionId":null,"modelName":"MSOTADevInfra_Configuration_Service","modelVersion":"1.0","modelCustomizationUuid":null,"modelVersionId":"ee938612-9a25-11e7-abc4-cec278b6b50a","modelCustomizationId":null,"modelUuid":null,"modelInvariantUuid":null,"modelInstanceName":null},"instanceDirection":null}}],"subscriberInfo":null,"cloudConfiguration":{"aicNodeClli":null,"tenantId":null,"lcpCloudRegionId":"mtn6"},"requestParameters":{"subscriptionServiceType":null,"userParams":[],"aLaCarte":false,"autoBuildVfModules":false,"cascadeDelete":false,"usePreload":true,"alaCarte":false},"project":null,"owningEntity":null,"platform":null,"lineOfBusiness":null}', null, 'APIH', '2017-09-26 16:09:29', null, null, null, null, null, null, null, 'mtn6', null, null, null, null, null, 'configuration', 'activateInstance', '9e15a443-af65-4f05-9000-47ae495e937d', null, 'xxxxxx', '26ef7f15-57bb-48df-8170-e59edc26234c', null, null, null, 'http://localhost:8080/onap/so/infra/serviceInstantiation/v7/serviceInstances'); INSERT INTO PUBLIC.INFRA_ACTIVE_REQUESTS(REQUEST_ID, CLIENT_REQUEST_ID, ACTION, REQUEST_STATUS, START_TIME, END_TIME, SERVICE_INSTANCE_ID, SERVICE_INSTANCE_NAME ) VALUES ('a5294d37-21db-4e3a-ae04-57412adcb4ac', null, 'createInstance', 'COMPLETE', '2019-01-01 12:45:00', '2019-01-01 12:50:00', 'f7712652-b516-4925-a243-64550d26fd84', 'ShouldReturnInSearchQuery_1'), ('9383dc81-7a6c-4673-8082-650d50a82a1a', null, 'createInstance', 'IN_PROGRESS', '2019-01-01 12:55:00', null, 'f7712652-b516-4925-a243-64550d26fd84', 'ShouldReturnInSearchQuery_2'), ('a1abeab2-f8ef-43ab-b76c-9c3c2cb9980f', null, 'activateInstance', 'FAILED', '2019-01-01 13:00:00', '2019-01-01 14:00:00', 'f7712652-b516-4925-a243-64550d26fd84', 'ShouldReturnInSearchQuery_3'), ('81b8e152-ee89-49f4-b82b-08b0dcae27cd', null, 'createInstance', 'COMPLETE', '2019-01-01 14:10:00', '2019-01-01 15:00:00', 'f7712652-b516-4925-a243-64550d26fd84', 'SHOULD_NOT_RETURN_1'), ('0c28cad2-ff79-4dfa-a04a-9e44996fd7f7', null, 'createInstance', 'IN_PROGRESS', '2019-01-01 13:30:00', '2019-01-01 15:00:00', 'f7712652-b516-4925-a243-64550d26fd84', 'SHOULD_NOT_RETURN_2'), ('d0d995a7-549b-4e7e-9101-2bab17ec24ea', null, 'createInstance', 'IN_PROGRESS', '2019-01-01 11:15:00', null, 'f7712652-b516-4925-a243-64550d26fd84', 'SHOULD_NOT_RETURN_3'); CREATE CACHED TABLE PUBLIC.ARCHIVED_INFRA_REQUESTS( REQUEST_ID VARCHAR NOT NULL SELECTIVITY 100, CLIENT_REQUEST_ID VARCHAR SELECTIVITY 6, ACTION VARCHAR SELECTIVITY 1, REQUEST_STATUS VARCHAR SELECTIVITY 1, STATUS_MESSAGE longtext SELECTIVITY 36, ROLLBACK_STATUS_MESSAGE longtext SELECTIVITY 36, FLOW_STATUS longtext SELECTIVITY 36, RETRY_STATUS_MESSAGE longtext SELECTIVITY 36, PROGRESS VARCHAR SELECTIVITY 1, START_TIME VARCHAR, END_TIME VARCHAR, SOURCE VARCHAR SELECTIVITY 2, VNF_ID VARCHAR SELECTIVITY 15, VNF_NAME VARCHAR SELECTIVITY 11, VNF_TYPE VARCHAR SELECTIVITY 5, SERVICE_TYPE VARCHAR SELECTIVITY 1, AIC_NODE_CLLI VARCHAR SELECTIVITY 1, TENANT_ID VARCHAR SELECTIVITY 2, PROV_STATUS VARCHAR SELECTIVITY 1, VNF_PARAMS VARCHAR SELECTIVITY 1, VNF_OUTPUTS VARCHAR SELECTIVITY 3, REQUEST_BODY VARCHAR SELECTIVITY 79, RESPONSE_BODY VARCHAR SELECTIVITY 7, LAST_MODIFIED_BY VARCHAR SELECTIVITY 2, MODIFY_TIME VARCHAR, REQUEST_TYPE VARCHAR SELECTIVITY 1, VOLUME_GROUP_ID VARCHAR SELECTIVITY 2, VOLUME_GROUP_NAME VARCHAR SELECTIVITY 3, VF_MODULE_ID VARCHAR SELECTIVITY 5, VF_MODULE_NAME VARCHAR SELECTIVITY 8, VF_MODULE_MODEL_NAME VARCHAR SELECTIVITY 3, AAI_SERVICE_ID VARCHAR SELECTIVITY 1, AIC_CLOUD_REGION VARCHAR SELECTIVITY 1, CALLBACK_URL VARCHAR SELECTIVITY 1, CORRELATOR VARCHAR SELECTIVITY 1, NETWORK_ID VARCHAR SELECTIVITY 2, NETWORK_NAME VARCHAR SELECTIVITY 4, NETWORK_TYPE VARCHAR SELECTIVITY 1, REQUEST_SCOPE VARCHAR SELECTIVITY 1, REQUEST_ACTION VARCHAR SELECTIVITY 1, SERVICE_INSTANCE_ID VARCHAR SELECTIVITY 34, SERVICE_INSTANCE_NAME VARCHAR SELECTIVITY 25, REQUESTOR_ID VARCHAR SELECTIVITY 2, CONFIGURATION_ID VARCHAR SELECTIVITY 1, CONFIGURATION_NAME VARCHAR SELECTIVITY 2, OPERATIONAL_ENV_ID VARCHAR SELECTIVITY 1, OPERATIONAL_ENV_NAME VARCHAR SELECTIVITY 1, INSTANCE_GROUP_ID VARCHAR SELECTIVITY 1, INSTANCE_GROUP_NAME VARCHAR SELECTIVITY 1, REQUEST_URL VARCHAR SELECTIVITY 1 ); CREATE CACHED TABLE PUBLIC.SITE_STATUS( SITE_NAME VARCHAR NOT NULL, STATUS VARCHAR, CREATION_TIMESTAMP VARCHAR ); INSERT INTO PUBLIC.SITE_STATUS(SITE_NAME, STATUS, CREATION_TIMESTAMP) VALUES ('testSite', '0', '2017-11-30 15:48:09'), ('test name', null, null), ('test name2', '1', null), ('test name3', '1', null), ('test name4', '1', '2017-11-30 15:48:09'), ('test name update', '0', null); CREATE CACHED TABLE PUBLIC.WATCHDOG_DISTRIBUTIONID_STATUS( DISTRIBUTION_ID VARCHAR NOT NULL, DISTRIBUTION_ID_STATUS VARCHAR, LOCK_VERSION int, CREATE_TIME VARCHAR, MODIFY_TIME VARCHAR ); INSERT INTO PUBLIC.WATCHDOG_DISTRIBUTIONID_STATUS(DISTRIBUTION_ID, DISTRIBUTION_ID_STATUS, LOCK_VERSION, CREATE_TIME, MODIFY_TIME) VALUES ('1533c4bd-a3e3-493f-a16d-28c20614415e', '', 0, '2017-11-30 15:48:09', '2017-11-30 15:48:09'), ('55429711-809b-4a3b-9ee5-5120d46d9de0', '', 0, '2017-11-30 16:35:36', '2017-11-30 16:35:36'), ('67f0b2d1-9013-4b2b-9914-bbe2288284fb', '', 0, '2017-11-30 15:54:39', '2017-11-30 15:54:39'); CREATE CACHED TABLE PUBLIC.WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS( DISTRIBUTION_ID VARCHAR NOT NULL, COMPONENT_NAME VARCHAR NOT NULL, COMPONENT_DISTRIBUTION_STATUS VARCHAR, CREATE_TIME VARCHAR, MODIFY_TIME VARCHAR ); INSERT INTO PUBLIC.WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS(DISTRIBUTION_ID, COMPONENT_NAME, COMPONENT_DISTRIBUTION_STATUS, CREATE_TIME, MODIFY_TIME) VALUES ('1533c4bd-a3e3-493f-a16d-28c20614415e', 'MSO', 'COMPONENT_DONE_OK', '2017-11-30 15:48:09', '2017-11-30 15:48:09'), ('55429711-809b-4a3b-9ee5-5120d46d9de0', 'MSO', 'COMPONENT_DONE_ERROR', '2017-11-30 16:35:36', '2017-11-30 16:35:36'), ('67f0b2d1-9013-4b2b-9914-bbe2288284fb', 'MSO', 'COMPONENT_DONE_OK', '2017-11-30 15:54:39', '2017-11-30 15:54:39'); CREATE CACHED TABLE PUBLIC.WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP( DISTRIBUTION_ID VARCHAR NOT NULL, SERVICE_MODEL_VERSION_ID VARCHAR NOT NULL, CREATE_TIME VARCHAR, MODIFY_TIME VARCHAR ); INSERT INTO PUBLIC.WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP(DISTRIBUTION_ID, SERVICE_MODEL_VERSION_ID, CREATE_TIME, MODIFY_TIME) VALUES ('1533c4bd-a3e3-493f-a16d-28c20614415e', '7e813ab5-88d3-4fcb-86c0-498c5d7eef9a', '2017-11-30 15:48:08', '2017-11-30 15:48:08'), ('55429711-809b-4a3b-9ee5-5120d46d9de0', 'cc031e75-4442-4d1a-b774-8a2b434e0a50', '2017-11-30 16:35:36', '2017-11-30 16:35:36'), ('67f0b2d1-9013-4b2b-9914-bbe2288284fb', 'eade1e9d-c1ec-4ef3-bc31-60570fba1573', '2017-11-30 15:54:39', '2017-11-30 15:54:39'); ALTER TABLE PUBLIC.INFRA_ACTIVE_REQUESTS ADD CONSTRAINT PUBLIC.CONSTRAINT_E PRIMARY KEY(REQUEST_ID); ALTER TABLE PUBLIC.SITE_STATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_C PRIMARY KEY(SITE_NAME); ALTER TABLE PUBLIC.WATCHDOG_DISTRIBUTIONID_STATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_7 PRIMARY KEY(DISTRIBUTION_ID); ALTER TABLE PUBLIC.WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_D PRIMARY KEY(DISTRIBUTION_ID, COMPONENT_NAME); ALTER TABLE PUBLIC.WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP ADD CONSTRAINT PUBLIC.CONSTRAINT_6 PRIMARY KEY(DISTRIBUTION_ID, SERVICE_MODEL_VERSION_ID); ALTER TABLE PUBLIC.WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_DE FOREIGN KEY(DISTRIBUTION_ID) REFERENCES PUBLIC.WATCHDOG_DISTRIBUTIONID_STATUS(DISTRIBUTION_ID) NOCHECK;