JIRA Issue

Summary

Description

Workaround

Fix version

PG-17855 - Getting issue details... STATUS

BTM rest can not handle Dot Character

using the agent rest api with dot character causes trouble with the request handler and returns 404 not found

Replace dot with %2E

PG-17907 - Getting issue details... STATUS

Unable to Create Network app

Save is defect

Just use close instead

PG-17906 - Getting issue details... STATUS

performance fix not applicable

only working on SQL 2019

Removed hints

Click here to expand...

-- create procedure
CREATE PROCEDURE Hotfix81091 AS
BEGIN
    BEGIN TRY

        --idx0
        IF EXISTS (SELECT 1  FROM sys.indexes  WHERE name='agent_traffic_aggr_idx0'
                                                 AND object_id = OBJECT_ID('agent_traffic_aggr_monitored'))
            BEGIN
                DROP INDEX agent_traffic_aggr_idx0 ON agent_traffic_aggr_monitored
            END

        CREATE CLUSTERED INDEX agent_traffic_aggr_idx0 ON agent_traffic_aggr_monitored
            (
             protocol_id ASC,
             ip_address ASC,
             port ASC,
             timestamp ASC
                ) ON pguard_data_large

--idx1
        IF EXISTS (SELECT 1  FROM sys.indexes  WHERE name='agent_traffic_aggr_idx1'
                                                 AND object_id = OBJECT_ID('agent_traffic_aggr_monitored'))
            BEGIN
                DROP INDEX agent_traffic_aggr_idx1 ON pguard.agent_traffic_aggr_monitored
            END

        CREATE NONCLUSTERED INDEX agent_traffic_aggr_idx1 ON pguard.agent_traffic_aggr_monitored
            (
             timestamp ASC,
             group_id ASC
                )  ON pguard_indx_big

--idx2
        IF EXISTS (SELECT 1  FROM sys.indexes  WHERE name='agent_traffic_aggr_idx2'
                                                 AND object_id = OBJECT_ID('agent_traffic_aggr_monitored'))
            BEGIN
                DROP INDEX agent_traffic_aggr_idx2 ON pguard.agent_traffic_aggr_monitored
            END

        CREATE NONCLUSTERED INDEX agent_traffic_aggr_idx2 ON pguard.agent_traffic_aggr_monitored
            (
             timestamp ASC,
             ip_address ASC
                ) ON pguard_indx_big

        IF NOT EXISTS(SELECT 1 FROM db_version_history WHERE version = 81091)
            BEGIN
                INSERT INTO db_version_history(Status, Time, Version, Rollup, Message, Patch) VALUES('applied', pguard.t2d(pguard.CurrentTimestamp()), 81091, 'no', '', 'yes')
            END
    END TRY
    BEGIN CATCH
        SELECT
            ERROR_NUMBER() AS ErrorNumber,
            ERROR_STATE() AS ErrorState,
            ERROR_SEVERITY() AS ErrorSeverity,
            ERROR_PROCEDURE() AS ErrorProcedure,
            ERROR_LINE() AS ErrorLine,
            ERROR_MESSAGE() AS ErrorMessage;
    END CATCH
END
GO

-- exeucte procedure
BEGIN TRY
    EXECUTE Hotfix81091;
END TRY
BEGIN CATCH
    SELECT
        ERROR_NUMBER() AS ErrorNumber
         ,ERROR_MESSAGE() AS ErrorMessage;
END CATCH;

Browser not supported