Event Trace - RFC Status: "The ABAP/4 Open SQL array insert results in duplic"

Tue Oct 24 09:20:08 EDT 2006

THIS HAS NOW BEEN RESOLVED, Thanks for your input.

Sherie,

I was not dealing with HR events, sorry for not being more specific. It
is actually an event from a custom business object (in the PM area) I am
dealing with.

Koenraad,

I did check the ST22 dumps as you suggested. I should have done this
before sending the mail out in hindsight. Anyway, this pointed out
exactly where the problem lay. 

SOLUTION: The dump was happening in FM 'SWW_WI_CONTAINER_INSERT'. An
insert was being done on a DB table when an entry already existed for
that key. With this being in standard SAP, I therefore searched OSS, and
having found little of use raised a message with SAP. They got back to
me to point out that the problem could have been caused by a client copy
so that the Work Item ID numbers proposed by the system were not high
enough, giving the conflict. Having compared the highest number in table
SWWWIHEAD with the 'Current number' in the work item number range
maintenance (transaction SNRO) I raised the value of 'Current Number'
and this has fixed my problem.

Thanks again for your help. 

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of sap-wug-request at mit.edu
Sent: 23 October 2006 13:41
To: sap-wug at mit.edu
Subject: SAP-WUG Digest, Vol 23, Issue 67

Send SAP-WUG mailing list submissions to
	sap-wug at mit.edu

To subscribe or unsubscribe via the World Wide Web, visit
	http://mailman.mit.edu/mailman/listinfo/sap-wug
or, via email, send a message with subject or body 'help' to
	sap-wug-request at mit.edu

You can reach the person managing the list at
	sap-wug-owner at mit.edu

When replying, please edit your Subject line so it is more specific
than "Re: Contents of SAP-WUG digest..."

Today's Topics:

   1. Re: Event Trace - RFC Status: "The ABAP/4 Open SQL array
      insert	results	in duplic" (koenraad.janssens at arcelor.com)
   2. RE: Event Trace - RFC Status: "The ABAP/4 Open SQL array
      insert	resultsin duplic" (Munday,Sherie J.)

----------------------------------------------------------------------

Message: 1
Date: Mon, 23 Oct 2006 13:26:10 +0200
From: koenraad.janssens at arcelor.com
Subject: Re: Event Trace - RFC Status: "The ABAP/4 Open SQL array
	insert	results	in duplic"
To: sap-wug at mit.edu
Message-ID:

<OFA7D6FE3F.B9B4C914-ONC1257210.003EC415-C1257210.003ED1BB at sidmar.arcelo
r.com>

Content-Type: text/plain; charset="iso-8859-1"

duplicate keys?
Have you checked for dumps around the time you trigger the events?

Met vriendelijke groeten,
Salutations,
Best regards,
Mit freundlichen Gr?ssen,
Atentos saludos,
Agur bero bat, 

Koenraad Janssens
Sidmar N.V. - ISM
Leverage Team - Programmer 
Tel: +32 9 347 35 76
email: koenraad.janssens at arcelor.com 

Living on Earth may be expensive, but it includes an annual free trip 
around the Sun. 

henry.lowe at logicacmg.com 
Sent by: sap-wug-bounces at mit.edu
23/10/2006 13:17
Please respond to
sap-wug at mit.edu

To
sap-wug at mit.edu
cc

Subject
Event Trace - RFC Status: "The ABAP/4 Open SQL array insert results
in 
duplic"

Hi All,

I have recently been having problems getting a work item to kick off
from 
an event. I have tweaked SWU3 workflow customising this morning so that
I 
now have all green ticks (I am working on version 4.6C). However, the
work 
items are still not being generated from the events. In SWEL Event Trace
I 
am getting the message in the subject line of this mail next to the RFC 
Status (?The ABAP/4 Open SQL array insert results in duplic?) which I am

assuming is the root cause of my problem. I do not fully understand what

this means however.

Hopefully someone out there can enlighten me ?

Thanks in advance,

Henry. 

Henry Lowe
SAP Technical Consultant
_________________________________________

LogicaCMG

Kingston House 
Towers Business Park 
Wilmslow Road 
Didsbury, Manchester 

M20 2LX

Tel: +44(0)161 438 8126
Fax: +44(0)161 438 8100
Mob: +44 (0) 7711 934474
Email:  Henry.Lowe at logicacmg.com
www.logicacmg.com

This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be
copied, 
disclosed to, retained or used by, any other party. If you are not an 
intended recipient then please promptly delete this e-mail and any 
attachment and all copies and inform the sender. Thank you.
_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

**** 
This message and any attachment are confidential, intended solely for
the use of the individual or entity to whom it is addressed and may be
protected by professional secrecy or intellectual property rights. 
If you have received it by mistake, or are not the named recipient(s),
please immediately notify the sender and delete the message. You are
hereby notified that any unauthorized use, copying or dissemination of
any or all information contained in this message is prohibited. 
Arcelor shall not be liable for the message if altered, falsified, or in
case of error in the recipient. 
This message does not constitute any right or commitment for Arcelor
except when expressly agreed otherwise in writing in a separate
agreement.  
****
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.mit.edu/pipermail/sap-wug/attachments/20061023/7625f24d/a
ttachment-0001.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 8723 bytes
Desc: not available
Url :
http://mailman.mit.edu/pipermail/sap-wug/attachments/20061023/7625f24d/a
ttachment-0001.jpg

------------------------------

Message: 2
Date: Mon, 23 Oct 2006 08:38:14 -0400
From: "Munday,Sherie J." <MUNDAYSJ at airproducts.com>
Subject: RE: Event Trace - RFC Status: "The ABAP/4 Open SQL array
	insert	resultsin duplic"
To: "SAP Workflow Users' Group" <sap-wug at mit.edu>
Message-ID:

<B3D052C7FA25934B94BA33FC2080CA165CB386 at us0355exmp.america.apci.com>
Content-Type: text/plain; charset="us-ascii"

Henry,
Are you dealing with HR events?  There is an OSS note on HR events not
triggering workflows.
Cheers,
Sherie

Sherie Munday
Workflow Developer/Analyst
Air Products & Chemicals, Inc.

________________________________

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Lowe, Henry
Sent: Monday, October 23, 2006 7:18 AM
To: sap-wug at mit.edu
Subject: Event Trace - RFC Status: "The ABAP/4 Open SQL array insert
resultsin duplic"

Hi All,

I have recently been having problems getting a work item to kick off
from an event. I have tweaked SWU3 workflow customising this morning so
that I now have all green ticks (I am working on version 4.6C). However,
the work items are still not being generated from the events. In SWEL
Event Trace I am getting the message in the subject line of this mail
next to the RFC Status ('The ABAP/4 Open SQL array insert results in
duplic') which I am assuming is the root cause of my problem. I do not
fully understand what this means however.

Hopefully someone out there can enlighten me ...

Thanks in advance,

Henry. 

Henry Lowe
SAP Technical Consultant
_________________________________________

LogicaCMG

Kingston House 

Towers Business Park 

Wilmslow Road 

Didsbury, Manchester 

M20 2LX

Tel: +44(0)161 438 8126

Fax: +44(0)161 438 8100

Mob: +44 (0) 7711 934474

Email:  Henry.Lowe at logicacmg.com
<blocked::mailto:nameinitial at logica.com> 
www.logicacmg.com

This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you are
not an intended recipient then please promptly delete this e-mail and
any attachment and all copies and inform the sender. Thank you.

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.mit.edu/pipermail/sap-wug/attachments/20061023/00319454/a
ttachment.htm

------------------------------

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

End of SAP-WUG Digest, Vol 23, Issue 67
***************************************