Query string not available or empty for [ArWFIssuanceAuditLogQuery_Insert]

Article Id: 140590
Status: Published
Updated On: 21-11-2019 11:53
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=='
          );