000033314 - In RSA Via Lifecycle and Governance there are multiple occurrence of the following error message in the aveksaServer.log:  Error in encryption/decryption method

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033314
Applies ToRSA Product Set: RSA Via Lifecycle and Governance (RSA Via L&G)
RSA Version/Condition: 6.9.1+
Platform: WebSphere
IssueThe following error message occurs repeatedly in the aveksaServer.log:
09/08/2015 10:52:52.024 ERROR (Worker_actionq#ActionQ1#WPDS_7) [org.hibernate.hql.PARSER] line 1:119: unexpected token: null
09/08/2015 10:52:52.027 ERROR (Worker_actionq#ActionQ1#WPDS_7) [com.aveksa.server.core.DataCollector] Error in encryption/decryption
method=ManagePasswordTypeProperties com.aveksa.server.db.PersistenceException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token:
null near line 1, column 119 [from com.aveksa.server.core.CollectorType CollectorType where CollectorType.name = :name0 and CollectorType.version = ]

Review RSA Via Lifecycle & Governance - Artifacts to gather to find the location of the aveksaServer.log in your deployment.
 
CauseThis issue occurs when the COLLECTOR_TYPE_VERSION for COLLECTOR_TYPE of LocalEntitlementCollectors is null in the T_DATA_COLLECTORS database table.
ResolutionPlease run the following SQL query to set the COLLECTOR_TYPE_VERSION for LocalEntitlementColectors to 1 in the T_DATA_COLLECTORS database table:
UPDATE "AVUSER"."T_DATA_COLLECTORS" SET COLLECTOR_TYPE_VERSION = 1 WHERE COLLECTOR_TYPE = 'LocalEntitlementCollector';
COMMIT;


 

Attachments

    Outcomes