Workflow and Task Deletions Error in a new development clien t.

["Schrader N., Claude (Enap Refinerías)]

Hi Mike!

Thank you for your support. 

I am glad to share what finally happened: 
We traced what caused the DUMP in PFTC and PFAC: It was an Infotype.
In the old client someone  created test infotypes, those infotypes where
copied to the new development client. One of those infotypes was recorded
in table T777D and this record had no value in field:
 T777D-PAPD(HR: Indicator Personnel Adminstration or Personnel Planning).
By giving 'x' value to this field the DUMP did not hapen.
As soon as we deleted this particular test infotype we had no more DUMPs.

Claude


-----Mensaje original-----
De: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] En nombre de
Mike Pokraka
Enviado el: martes, 24 de octubre de 2006 5:37
Para: SAP Workflow Users' Group
Asunto: Re: Workflow and Task Deletions Error in a new development client.

Hi Claude,
Glad to see someone calls it a 'long dump'. Never understood the 'short'
bit, some twisted sense of humour on the part of SAP. In fact it still
tells the user to print the bleeding thing (and abusers still do it).

Anyway, onto your question. Run the reports, it's not dangerous. They are
recommended as part of your WF customising (SWU3). RHSOBJCH supplements
missing table entries, nothing gets destroyed. Execute, select all, click
on 'Adjust' - can't harm.
I think you need to be a little more careful with RHTTCP77, but it has a
test mode and setting for new entries only, I don't think it overwrites
anything without asking.

Cheers,
Mike


On Mon, October 23, 2006 20:54, "Schrader N., Claude (Enap Refinerías)"
wrote:
> Hi,
>
> We have SAP R\3 620 version.
> I created a new workflow in our new development client DEV(310) and then
> transported it to test and production clients, everything worked well.
>
> Then in PFTC I wanted to delete the newly created workflow and the
> deletion
> failed with a long DUMP explaining:
>
> Program =  SAPLRHDB.
>
> Runtime errors               SAPSQL_INVVALID_FIELDNAME
> Exeption                     CX_SY_DYNAMIC_OSQL_SEMANTICS.
>
> The reason for the exception is:
>
>
> The SELECT clause was specified in an internal table at runtime.
>
> It contains the field name "OTJID", but this does not occur in any of
>
> the database tables listed in the FROM clause.
>
> The hard fact is: WorkFlow and Task deletion fails, task agent update
> fails
> the same way.
>
> Then I came back to transaction SWU3 read SAP Note 31621 and other notes
> related to tables T777*. Reports RHTTCP77 and RHSOBJCH.
>
> I am not sure those reports will solve this problem.
> I am not sure those reports are not dangerous.
> I am not sure WF deletion failed due to T777* tables.
>
> Did someone experience a similar problem?
>
> Thank You,
>
> Claude
>
>
>

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