After upgrade otk ,Oauth authentication can not be performed

Products

• API SECURITY
• CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway
• CA API Gateway

Issue/Introduction

After upgrade otk 4.1 -> 4.3,

Oauth authentication can not be performed with the following error

<?xml version="1.0" encoding="UTF-8"?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

    <soapenv:Body>

        <soapenv:Fault>

            <faultcode>soapenv:Server</faultcode>

            <faultstring>Error in assertion processing</faultstring>

            <faultactor>https://{url}/auth/oauth/v2/token</faultactor>

            <detail>

                <l7:policyResult

                    status="Assertion not available: Code not available for assertion: CustomAssertion" xmlns:l7="http://www.layer7tech.com/ws/policy/fault"/>

            </detail>

        </soapenv:Fault>

    </soapenv:Body>

</soapenv:Envelope>

Environment

Release :

Component : API GATEWAY

OTK tool kit

Cause

The following index has been disabled：　

　OAIDT_IDX_AZP UNUSABLE

　OAIDT_IDX_EXPIRATION UNUSABLE

　PK_MAG_ID_TOKEN UNUSABLE

　OCK_IDX_CLIENTIDENT UNUSABLE

　SYS_C003995 UNUSABLE

 

Resolution

The problem was solved after the indexes rebilud.

Run the following SQL

　alter index OAIDT_IDX_AZP rebuild;

　alter index PK_MAG_ID_TOKEN rebuild;

　alter index OAIDT_IDX_EXPIRATION rebuild;

　alter index OCK_IDX_CLIENTIDENT rebuild;

　alter index SYS_C003995 rebuild;

　alter index SYS_C009926 rebuild;