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]]
The issue is happening because the ARWFISSUANCEAUDITLOG_INSERT query is missing from the ARWFDBQUERIES table.
Release : 8.1
Component : AuthMinder(Arcot WebFort)
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=='
);