Management Report - Cannot assign an empty string to host variable 10

[Former Member]

We ran a Management Report for the first time after completing the User/Role/Profile Full Sync and the user/Role/Profile Batch Risk Analysis. The job failed with the following error:

Oct 16, 2008 12:13:29 PM com.virsa.cc.xsys.bg.BatchRiskAnalysis runBkgMgmReport

WARNING: Exception in Management Report Job: Cannot assign an empty string to host variable 10.

com.sap.sql.log.OpenSQLException: Cannot assign an empty string to host variable 10.

We are on GRC 5.3 support pack 4. Has anybody encountered this error? What does host variable 10 refer to?

[Former Member]

Yes. This could be due to fields that are set to be not null, has Null values. For instance, when you upload USOBT_C txt from SAP to CC, it might have empty fields such as From VAL or TOVAL. If I am not mistaken, almost all fields in the CC tables are set to be NOT NULL. Somewhere, your table values has empty values, for which CC is throwing an error message.

Thanks

[Former Member]

I checked our USOBT_C table and we have a lot of empty values. If this is allowed to be empty in SAP and this is the table that is uploaded into CC, why would all the fields in CC tables then be defined as NOT NULL? We suspect that since we had uploaded USOBT_C under 5.2 and if this had been an issue before, it may have been corrected when we upgraded to 5.3 but then the old data is still in our system. Is there an easy way to get around or correct this?

Thanks.

[former_member9720]

Hi,

can you give a little bit more information about your issue? Especially if you have noticed some warning on uploading files, e.g. rules ones, or if you have users/roles id,names that sound strange or empty.

Thanks

Emilio