Failure to save Questionnaire results in RPM

[guillaume_fagernes-turpin]

Hi,

We are using RPM 4.5 version. Most of the time, saving questionnaire results works fine, but it appears that sometimes the questionnaire results are not saved to the database when saving the Item.

When the problem happens, there is no message on the frontend (portal), but a runtime error is generated in the backend.

The runtime error is of type SAPSQL_ARRAY_INSERT_DUPREC with exception CX_SY_OPEN_SQL_DB not caught in procedure "/RPM/QNNR_SAVE_DB".

Checking in SM13 what caused the failure, it seems that there are multiple records that violate the primary key of hte table /RPM/QNNR.

Eg 4 records for the same field ZZ_BS_BUSCORE_D when there should be only one.

DF2CB8F02F1899F18F4B001A4BBF3B7A ZZ_BS_BUSCORE_D ZBSQNNR001 646016 202 DF2CB8F02F1899F18F4B001A4BBF3B7A ZZ_BS_BUSCORE_D ZBSQNNR001 646016 203 DF2CB8F02F1899F18F4B001A4BBF3B7A ZZ_BS_BUSCORE_D ZBSQNNR001 646016 204 DF2CB8F02F1899F18F4B001A4BBF3B7A ZZ_BS_BUSCORE_D ZBSQNNR001 646016 20

This is typically a case for OSS support (and there is one), but here the issue is that it is a challenge to try reproducing the error, since we can not see any pattern. Though the issue happens from time to time...

Has any of you epxerienced the same issue, and if yes, could share experience on the case?

Thanks for yoru help,

Guillaume

[guillaume_fagernes-turpin]

SAP recognized a bug in the programs, and a note was delivered to fix the issue.