Page History

...

MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| clampacm           |
| information_schema |
| migration          |
| mysql              |
| operationshistory  |
| performance_schema |
| policyadmin        |
| policyclamp        |
| pooling            |
| sys                |
+--------------------+
10 rows in set (0.005 sec)

MariaDB [policyadmin]> SHOW TABLES;
+------------------------------------------------------+
| Tables_in_policyadmin                                |
+------------------------------------------------------+
| jpapdpgroup_properties                               |
| jpapdpstatistics_enginestats                         |
| jpapdpsubgroup_policies                              |
| jpapdpsubgroup_properties                            |
| jpapdpsubgroup_supportedpolicytypes                  |
| jpapolicyaudit                                       |
| jpatoscacapabilityassignment_attributes              |
| jpatoscacapabilityassignment_metadata                |
| jpatoscacapabilityassignment_occurrences             |
| jpatoscacapabilityassignment_properties              |
| jpatoscacapabilitytype_metadata                      |
| jpatoscacapabilitytype_properties                    |
| jpatoscadatatype_constraints                         |
| jpatoscadatatype_metadata                            |
| jpatoscadatatype_properties                          |
| jpatoscanodetemplate_metadata                        |
| jpatoscanodetemplate_properties                      |
| jpatoscanodetype_metadata                            |
| jpatoscanodetype_properties                          |
| jpatoscapolicy_metadata                              |
| jpatoscapolicy_properties                            |
| jpatoscapolicy_targets                               |
| jpatoscapolicytype_metadata                          |
| jpatoscapolicytype_properties                        |
| jpatoscapolicytype_targets                           |
| jpatoscapolicytype_triggers                          |
| jpatoscarelationshiptype_metadata                    |
| jpatoscarelationshiptype_properties                  |
| jpatoscarequirement_metadata                         |
| jpatoscarequirement_occurrences                      |
| jpatoscarequirement_properties                       |
| jpatoscaservicetemplate_metadata                     |
| jpatoscatopologytemplate_inputs                      |
| pdp                                                  |
| pdpgroup                                             |
| pdpgroup_pdpsubgroup                                 |
| pdppolicystatus                                      |
| pdpstatistics                                        |
| pdpsubgroup                                          |
| pdpsubgroup_pdp                                      |
| sequence                                             |
| toscacapabilityassignment                            |
| toscacapabilityassignments                           |
| toscacapabilityassignments_toscacapabilityassignment |
| toscacapabilitytype                                  |
| toscacapabilitytypes                                 |
| toscacapabilitytypes_toscacapabilitytype             |
| toscadatatype                                        |
| toscadatatypes                                       |
| toscadatatypes_toscadatatype                         |
| toscanodetemplate                                    |
| toscanodetemplates                                   |
| toscanodetemplates_toscanodetemplate                 |
| toscanodetype                                        |
| toscanodetypes                                       |
| toscanodetypes_toscanodetype                         |
| toscapolicies                                        |
| toscapolicies_toscapolicy                            |
| toscapolicy                                          |
| toscapolicytype                                      |
| toscapolicytypes                                     |
| toscapolicytypes_toscapolicytype                     |
| toscarelationshiptype                                |
| toscarelationshiptypes                               |
| toscarelationshiptypes_toscarelationshiptype         |
| toscarequirement                                     |
| toscarequirements                                    |
| toscarequirements_toscarequirement                   |
| toscaservicetemplate                                 |
| toscatopologytemplate                                |
+------------------------------------------------------+
70 rows in set (0.052 sec)

MariaDB [policyadmin]>

SELECT * FROM `pdpstatistics`;
ID
name
version
timeStamp
pdpGroupName
pdpSubGroupName
policyDeployCount
policyDeploySuccessCount
policyDeployFailCount
policyUndeployCount
policyUndeploySuccessCount
policyUndeployFailCount
policyExecutedCount
policyExecutedSuccessCount
policyExecutedFailCount

SELECT * FROM `sequence`
SEQ_NAME
SEQ_COUNT
 VALUES('SEQ_GEN', 
(SELECT COALESCE(max(id),0) 
FROM pdpstatistics));

jpapdpstatistics_enginestats;
ID     
name     
version
AVERAGEEXECUTIONTIME
ENGINEID     
ENGINETIMESTAMP     
ENGINEWORKERSTATE     
EVENTCOUNT     
LASTENTERTIME     
LASTEXECUTIONTIME     
LASTSTART     
UPTIME

Affected Components:

Removing model and statistics service from PAP
Models PdpStatistics , JpaPdpStatistics
Pap PdpStatisticsService (*)

Api ApiStatisticsManager (Spring)
Distribution DistributionStatisticsManager (Prometheus)
Apex-pdp ApexPolicyStatisticsManager (Prometheus)
Drools-pdp PolicyStatsManager (drools/metrics/Metric.java)
Xacml XacmlPdpStatisticsManager (**)

...

Removing Statistics endpoints: PAP API DISTRIBUTION DROOLS-PDP XACML-PDP
Removing DB-Migrator sequence and pdpstatistics tables

CISIT Runs after removing PAP statistics code:
Image Added
PAP CSIT
Image Added

APEX CSIT
Image Added

XACML CSIT
Image Added

Simulator error

policy-pap                    | org.policy-pap                    | org.onap.policy.pap.main.PolicyPapException: Failed to register PDP. No matching PdpGroup/SubGroup Found - PdpStatus(super=PdpMessage(messageName=PDP_STATUS, requestId=7364a2c2-e85f-4f10-8827-3628282d0e00, timestampMs=1677767874574, name=drools-apps.c8e40082-75bb-414a-a278-fcdec702f80c, pdpGroup=defaultGroup, pdpSubgroup=null), pdpType=drools, state=PASSIVE, healthy=HEALTHY, description=null, policies=[], deploymentInstanceInfo=null, properties=null, statistics=PdpStatistics(pdpInstanceId=drools-apps.c8e40082-75bb-414a-a278-fcdec702f80c, timeStamp=2023-03-02T14:37:54.574896Z, generatedId=null, pdpGroupName=defaultGroup, pdpSubGroupName=null, policyExecutedCount=0, policyExecutedSuccessCount=0, policyExecutedFailCount=0, policyDeployCount=0, policyDeploySuccessCount=0, policyDeployFailCount=0, policyUndeployCount=0, policyUndeploySuccessCount=0, policyUndeployFailCount=0, engineStats=null), response=null)
policy-xacml-pdp              | [2023-03-06T10:07:13.183+00:00|INFO|HttpClient|DMAAP-source-POLICY-PDP-PAP] GET http://message-router:3904/events/POLICY-PDP-PAP/31197308-8836-4e7d-9dd5-a905cb5a665f/policy-xacml-pdp (anonymous) ... 
policy-pap                    | [2023-03-06T10:07:13.265+00:00|ERROR|PdpStatusMessageHandler|DMAAP-source-POLICY-HEARTBEAT] Operation Failed 
policy-pap                    | org.onap.policy.pap.main.PolicyPapException: Failed to register PDP. No matching PdpGroup/SubGroup Found - PdpStatus(super=PdpMessage(messageName=PDP_STATUS, requestId=fa94a3cc-489c-4540-b3f5-029350f0a574, timestampMs=1678097233050, name=xacml-2aba354c-5a42-4940-9975-4efb1fee0fb2, pdpGroup=defaultGroup, pdpSubgroup=null), pdpType=xacml, state=PASSIVE, healthy=HEALTHY, description=null, policies=[], deploymentInstanceInfo=null, properties=null, statistics=PdpStatistics(pdpInstanceId=null, timeStamp=+55146-10-09T17:23:27Z, generatedId=null, pdpGroupName=defaultGroup, pdpSubGroupName=null, policyExecutedCount=0, policyExecutedSuccessCount=0, policyExecutedFailCount=0, policyDeployCount=0, policyDeploySuccessCount=0, policyDeployFailCount=0, policyUndeployCount=0, policyUndeploySuccessCount=0, policyUndeployFailCount=0, engineStats=null), response=null) 
policy-apex-pdp               | [2023-03-06T10:08:09.761+00:00|INFO|CambriaSimplerBatchPublisher|pool-2-thread-1] cambria reply ok (104 ms):{"serverTimeMs":0,"count":1} 
policy-pap                    | [2023-03-06T10:08:09.855+00:00|WARN|ErrorPacket|DMAAP-source-POLICY-HEARTBEAT] Error: 1146-42S02: Table 'policyadmin.statistics_sequence' doesn't exist 
policy-pap                    | [2023-03-06T10:08:09.858+00:00|ERROR|TableGenerator|DMAAP-source-POLICY-HEARTBEAT] HHH000351: Could not read or init a hi value 
policy-pap                    | java.sql.SQLSyntaxErrorException: (conn=307) Table 'policyadmin.statistics_sequence' doesn't exist

Space shortcuts

Page tree

Versions Compared

Old Version 11

New Version Current

Key