Workflow and Task Deletions Error in a new development client.

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

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




-----Mensaje original-----
De: Schrader N., Claude (Enap Refinerías) 
Enviado el: martes, 03 de octubre de 2006 18:07
Para: 'SAP Workflow Users' Group'
Asunto: RE: Transaction SWU3 .. Maintain prefix Numbres.

Hi,

We have a sap client =DEV(310) created as a copy of former DEV(200) no
longer available, so there is only one development client.

I Finally created a new prefix with SWU3, using a Request as follows:
 Workbench request.
 Target = /CURTOMIZ/. 

Thanks to Mike and to Aziz for their support.

Claude

-----Mensaje original-----
De: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] En nombre de
Mike Pokraka
Enviado el: lunes, 02 de octubre de 2006 7:05
Para: SAP Workflow Users' Group
Asunto: Re: Transaction SWU3 .. Maintain prefix Numbres.

Hi Claude,
You only need to maintain prefix numbers in systems where you are going to
develop workflows. Are you saying you are moving development to a new
client? This is not a small job...

If you are going to develop in the new client you will need a prefix
number. Development in two clients is probably going to be a bit chaotic.
It may even be a good idea to create a new prefix number for your new
environment.

Cheers,
Mike

On Fri, September 29, 2006 21:42, "Schrader N., Claude (Enap Refinerías)"
wrote:
> Hello Wugers:
>
>
>
> We are in  620 SAP version.
>
>
>
> We made a new copy of the development client(MANDT), former name was 100,
> actual name is 310.
>
> I supose that now we must use SWU3 transaction (Automatic WorkFlow
> Customizing) go to
>
>  "Maintain Prefix Numbers" ... and update the client field to 310:
>
>
>
> Prefix no = 920
>
> Sap System = DEV
>
> Client = 200   --- ---update to ------- > 310
>
> Pack = ZWKF
>
>
>
> But as I am not an expert I fear it is not right to do it this way
>
>  - Is it right or is there a better way to do it?
>
>
>
> Thank You,
>
>
>
> Claude
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>


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