Err 00 671: SAPSQL_ARRAY_INSERT_DUPREC when creating help desk service mes.
we are setting up SOL MAN 4.0 SP 06, which have BBPCRM 05 SP09
I have followed the below forum, in order to implement the number range for document type SLF1 and SLFN.
(Error when creating system message)
As said in the forum you have to implement number range differenty for SLFN docs and SLF1(ABA msg).
So clearly number ranges internal for SLFN docs are external for SLF1 docs and it works in the opposite way round as well.
If I use the crmd_order trx to generate internally an SLFN doc it works,without any problem. But on the other hand if I try to use the menu Help - Create Support Message, I get the below error:
00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC.
As well BDOC have got a strange status, the yellow triangle of incompleted, and/or in process.
Should I carry out any Bdoc set up? For instance for queues?
After doing an ST05 trace I have found out that system is trying to insert twice the same key record in table CRMD_ACTIVITY_H. The program doesn't fail the first time but at the second attempt it fails.
We have checked many Sap notes, and in one case I have found out that problem was identical to the one I 'm experiencing. So we apply note 754192.
But I still have the same problem. So what am I supposed to do?
Should I raise the BBPCRM SP?
Please advice. Any help will be rewarded.
Many thanks in advance,