Query string not available or empty for [ArWFIssuanceAuditLogQuery_Insert]

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Strong Authentication
• CA Rapid App Security
• CA Risk Authentication
• CA Advanced Authentication

Issue/Introduction

We can see below SQL Exception in the logs due to which queries are not returning the result.

Can you please check, why this error comes and what is the remediation process?

 

11/06/19 00:57:26.464 WARN  TXN_WS       -282088592 215685520 - ArDBM::Query string not available corresponding to the query-id : [ARWFISSUANCEAUDITLOG_INSERT] for [ArWFIssuanceAuditLogQuery_Insert]. Number of available queries : 124

11/06/19 00:57:26.464 WARN  TXN_WS       -282088592 215685520 - ArDBM::Query string not available or empty for [ArWFIssuanceAuditLogQuery_Insert]

11/06/19 00:57:26.464 WARN  TXN_WS       -282088592 215685520 - ArDBM::Caught ArDBMSQLException in _DbOp!. err : [ArDBM::Query string not available or empty for [ArWFIssuanceAuditLogQuery_Insert]]

 

Cause

The issue is happening because the ARWFISSUANCEAUDITLOG_INSERT query is missing from the ARWFDBQUERIES table.

Environment

Release : 8.1

Component : AuthMinder(Arcot WebFort)

Resolution

Run the below query in database to address the issue -

INSERT INTO ARWFDBQUERIES(DMDV, QUERYID, QUERYSTR)
  VALUES (70, 'ARWFISSUANCEAUDITLOG_INSERT',
              'OZ7pQysmb8rHkqBjD+5QIM7K0vMKfXqwFtijp5wPA46sZluztEpSgRtQ5Ir7YMcuGFfwjr6RFvYif1q/0Zp1shBRkPeAaZ2isA6buBP3VpJl8Dm+dxJ0Gxw2Af9VEF2/sFviiQ4uDHkwOPZwAAuhXF+RLsRgHVn28CMd3ymVv5rWrxnh/pdQ9kKP2408YjLWaWiG+ILeuEctI7wLdfWSJw8mowRbC57NW1vQ1emrZfYXk3wm+fTrliGJdrOB0+2gFrDjID0Q0mVIzm4zu1Wtnkn3qgW5xj0BekN4apdid4xsg8PAA+79QzyAfh0hUW/TgQlsmOjZg3NNsyDH4k9gml0TIDOFkmmszHpxeMD3mPE32WnqWND3lVYa/DI3a7clyb0sW0tl9eTqLvVLz/086B4xAGbu3otGAL0SymFOdP8U4lBpYPRnh3IZUeOvoxrTot5crn8KUqx8GOTbbWvFHpJ68N0faPg4b/LMhw9M83bByalbj6Y604e3Z3T0rVZyyDgQj1IRQnFjq3k6nGmWCIaANPPovxOIujylWg5DMrHkjo8f9ZiLQgtwGDS9Jz/debiQ9lgvmGUvlwKrA7GitbJv/4hWcyLjfZbX0Tm/ARYTm9P4TIYEpb0SL0rB7IJwmkOfu9pFK4rNo7Wke4pKSEFG5wXYCNs4o8daeaXQwMKCX4KJeOnVBM9mbefSVcA2WhkoaTVC0WTKx+VxTF/l4rER86DcPGTZN4HkEsbefpHSw4KINjSdXFtIMNWp2Ot2isabJbDrJBbMJabcGiHicCoqGLEmeDEKbIGZaK0SXcGTgthgRRZSzSq3Ym6p0jUYewCcAeNFHVWivwqXd4rW0aqh9dYzoCpMdgy+xH539WuSCAQvq0km/bWtGGN867NRsswgwr6fv6Oczaunhwqjzj8sW7Gq4PfanWL6eQmJLh0YoGpIAqTilkCId2pGhOOqmkr/UoGewrJ2pzKc++J+aliDwlg+RKVzCofEYvycJncLNRpRKtnVV+wMl857nlcYgKre+NZeGRG7UWFT7ZduAIyn2XB3IXPW9L7aSGg7zmGCjqhAuQwU757JeswoUB0c7E+Fo+PiT9qOFSMlFRXF/k2I8r9JuOMtuu4c+saVU+mx2RY7XI51l0d/eLAE7VR0Pw5XhhAU9bnlHrNpqmE029xEZnLvcZpEGE9d3HHnMOuKwfku6HnvHr6XUi8zdZ3jpNRsQv4Dj+D95KuK7Yfx9/Fvo+iJ6ls5tYbiJ3v6oIcu0F6pPUWnNw7yiWRKJgH/2ViSbJY14HALsM0ELjoG+j5zIzprl3sxVlS/R9bUCj8xwCC63B48B3QGc/SSE/TXjPiGfNJD+6W/RGZWenCJBKS/nsC4nh5SbAkL8tTIc/BeiydrzlKcLbZyaf9hIKEWxUzbWPW8pUAzXEmWXAZJwcIzf4QPMtxZ5Y+P6tXCa1Qdj6cnp8aEAeFD8emGB0N1PSuNxKPyNEIdjwqYtbaeBP5FBKGAkDOuhv8aOlz4AEE6Qn6/jarLub1xh4GLozxPyIpQtIEYBIV+FrJ+/OHBVg=='
          );