03-16-2012 9:12 AM
Dear All Experts,
I want to HELD multiple line items on budgeting workbench FMBB, it was success and keep under HELD folder. But when i pushed "BACK" button, it showed pop up message "Update was terminated" received from author..." and when i checked on ST22, it said :
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Exception CX_SY_OPEN_SQL_DB
Does anybody know why this is happen only on HELD? (Prepost and Post can be done in multiple line items).
We're on SAPK-60410INEAPS package.
Many thanks on your responses.
Message was edited by: Serenity Lin
03-21-2012 4:17 AM
03-20-2012 5:04 AM
Hi
Check with the same with your technical person, as per your error message it seems the same record/reference was available (duplicate), other wise it should stop for posting held documents.
Regards
Rao
03-21-2012 1:54 AM
Mr Rao,
I had checked with our ABAP team, and no data on FMHBL table (this is the table for hold doc isnt it?). Only some documents from 1 line item exists on the table. And i had try SAP note 1064023. Do know any other table or anything i should check?
Thanks.
03-21-2012 5:55 AM
Hi
We als tried to post Hold document with multiple line items but don't have any problems.
The table is correct (FMHBL), I red the notes and it is relevant for this error. As Eli said we will wait for OSS reply.
Regards
Rao
03-20-2012 2:48 PM
Wow, interesting.
Could you please send more details about that error?
Thanks!
03-21-2012 1:48 AM
Mr Lopez,
I had edit my message and put some screen shot regarding this error. Do you need another screen shot?
Thanks ^^
03-21-2012 12:56 PM
All right, thanks for the info.
Now, could you hold document "two" for example?
But, before u held it, please see this image:
Thanks!
Regards.
03-21-2012 1:17 PM
Hi
If we hold budget document (thru FMBB) as mentioned for the above attached image (hold document with blank line item), while posting of Hold document system will pass error mesage i.e., 'Enter a non-zero amount for at least one period.'
Mr. Serenity,Please check the table FMHBL, Is there any other document posted with with similar blank line item?
Regards
03-22-2012 2:25 AM
Mr Lopez,
The HELD folder was updated at first, but after pushed back button, it still showed express document.
I agree with Mr. Rao, when line item was empty there should be an error message, but well it didn't happen also on my case -_-"
Mr Rao,
The FMBHL table only consists of 2 documents numbers, those documents were the single line item documents.
Anything else i should check?
Many Thanks.
03-20-2012 3:04 PM
Hi,
We have the same package, but don't have any problems with holding budgetary documents with multiple lines. I'd create an OSS message...
Regards,
Eli
03-21-2012 1:50 AM
Mr Klovski,
Many many thanks. I'll wait for your reply. And i had edit and put some error screen shot on my message.
03-21-2012 4:17 AM
03-22-2012 2:28 AM
Ms Rahmawati,
I did change the document number as instructed on sap note 1064023. But it still didn't work. Any other advise? Or do you think it is because my configuration? Or basis? Let me know if you have any idea?
Thanks
03-23-2012 3:21 PM
Hi,
This does not look like configuration. Unless you have some badi/exit active which may be an issue if it's either changing data unexpectedly or adding a commit work (which would be wrong)
can you please see if you have this note: 1636796 ?.
If it is missing, please apply it and let us know if anything changes.
Thanks!
kind regards,
Mar.
03-26-2012 10:04 AM
Mr Novalbos,
It works ^o^ your SAP Note suggestion is what we need. Thanks a lot.
Mr Klovski, Mr Rao, Mr Lopez, Ms Rahmawati,
Thank you very much to all of you.