Error "Failed to run Risk Analysis" in the CC BackgroundJob

[Former Member]

Hi everyone, I need a little help, it's urgent.

When running the Background job in the Compliance Calibrator, it fails

with the following error that can be found in the log of the job.

WARNING: Job ID:30 : Failed to run Risk Analysis

com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String

object of length 1,731,062,864 to host variable 9 which has JDBC type

VARCHAR(50).

Someone can expalin me how to resolve it.

Regards,

Filipe.

[Former Member · Accepted solution]

Hi Entidades ,

Upload attached file from going to Rule ARch -> Import rule

Then Paste below link in explore

http://bsw6517.wdf.sap.corp:52900/webdynpro/dispatcher/sap.com/grc~ccappcomp/BgJobStart?debug=1

Then Run query

select * from virsa_cc_config and update following rows in the table.

M VIRSA_CC_CONFIG CNFGPARAM CNFGSEQ CNFGVALUE COMMENT

D VIRSA_CC_CONFIG 105 0 http J2EE EngineProtocol

D VIRSA_CC_CONFIG 106 0 56200 J2EE Engine Port

D VIRSA_CC_CONFIG 107 0 http://localhost:56200 /webdynpro/dispatcher/sap.com/grc~ccappcomp/BgJobStart BgJobStart URL

Then paste following link into iexplore and check threads are running, if they are not running then start them, Your background job will get picked up after start of thread.

http://Localhost:52900/sap/CCADStatus.jsp?debug=1

Regards,

Jagat