29.9.11

SAP Note 28077 - Update term. in certificate profile, swapped txts

Symptom:

Characteristic short text are not taken over from the certificate profile or the sequence of the characteristic texts is swapped or update termination SAPSQL_ARRAY_INSERT_DUPREC occurs in QC05_QCVMT_INSERT, if the certificate profile contains characteristics with texts (inconsistency of tables QCVM and QCVMT).

Cause and prerequisites

The update termination can occur under the following conditions:

    1. A characteristic has an additional text which was maintained with the function "More texts".
    2. You delete the characteristic.
    3. You then create another characteristic and provide it as well with an additional text.
    4. After you have posted the reference, the text is no longer found when you access the certificate profile again.
    5. If you delete the characteristic again, create a new one again and provide it with an additional text, a update termination occurs when you post.

The texts can be swapped under the following conditions:

    1. You create or change a certificate profile: You enter a new characteristic and provide it with an additional text.
    2. You enter another characteristic with a smaller sort number and also enter an additional text for it.
    3. After you have savedthe the texts of the two new characteristics are swapped in the display transaction or change transaction.
Solution
    1. Change program SAPMQCPA, Includes MQCPAF01 and MQCPAF02: see below
    2. You can detect and correct inconsistencies between the files QCVM and QCVMT with a report that is given below as example program.
    3. Incorrect allocations (characteristic texts are swapped) can only be detected with expert knowledge. You then have to correct the allocations manually with the transaction for changing a certificate profile. A report which lists all characteristics with characteristic texts from certificate profiles is of help here. This report is also given below as example program.
Additional key words

Transactions QC01, QC02, QC03
Alternative texts disappeared
Alternative texts were swapped
Short text
Text
SAPLQC05
LQC05U06

No comments:

Post a Comment