Correct syntax for NWDI track replication using replication tool

[daniel_robinson2]

I'm trying to replicate a track from a source NWDI to a traget NWDI using replication tool

http://help.sap.com/saphelp_nw70/helpdata/en/46/5d032c1e661cbee10000000a11466f/frameset.htm

I've sucessfully copied the track definition by pointing the DTR URL of a copied track in the source to the target and then deleted the track in the source (points 1-4)

I've created a text file on UNIX based on what the track definitions are in source and target:

connect <target>:50200 NWDI_user <pwd> targetID

connect <source>:50200 NWDI_user <pwd> sourceID

replicate -r -d track_copy_target_nwdi.txt /ws/trk1/cust_DICTIONARY/dev/inactive targetID /ws/trkcpy/cust_DICTIONARY/dev/inactive

replicate -r -d track_copy_target_nwdi.txt /ws/trk1/cust_DICTIONARY/dev/active targetID /ws/trkcpy/cust_DICTIONARY/dev/active

replicate -r -d track_copy_target_nwdi.txt /ws/trk1/cust_DICTIONARY/cons/inactive targetID /ws/trkcpy/cust_DICTIONARY/cons/inactive

replicate -r -d track_copy_target_nwdi.txt /ws/trk1/cust_DICTIONARY/cons/active targetID /ws/trkcpy/cust_DICTIONARY/cons/active

./run.sh

>script command file

But I get the error :

Error: Execution of command sequence failed.

How can I troubleshoot? I don't see an error log.

Regards

Daniel

[ErvinSzolke · Accepted solution]

Hi Daniel,

first please try to specify the script without the .txt ending. In the guide I can see that in the example there is a replicate.txt, but in the command the txt ending is not added. Eventually attempt specify absolute path to the script file like c:\track_copy_target_nwdi

Further, please doublecheck in DTR webui if you wrote the tracknames correctly. You wrote trkcpy, but is it not TRKCPY ? I believe this should be case sensitive.

Else I don't see any other problem in the script you provided.

I hope this helps.

Best Regards,

Ervin

[daniel_robinson2 · Accepted solution]

Hi Ervin,

I removed .txt suffix from file and script but got the same problem. When I run the commands within run.sh prompt,  1 by 1,  I get the following error on the 1st replicate command:

Caused by: java.lang.RuntimeException: Specified tempDir exists but is not a directory

        at com.sap.dtr.console.commands.Replicate.setTempDir(Replicate.java:73)

Any idea what tempDir is in this case?

Regards

Daniel

[daniel_robinson2 · Accepted solution]

I changed the replicate command to use a local temp dir as follows:

SourceID>; replicate -r -d temp /ws/trk1/cust_DICTIONARY/dev/inactive targetID /ws/trkcpy/cust_DICTIONARY/dev/inactive

This time the command creates a login (JSESSIONID) but then errors out  on:

Caused by: java.lang.RuntimeException: Class com.sap.dtr.console.deltav.MacroStatusResponse does not have mandatory constructor with the following parameter types: com.sap.dtr.console.deltav.ResponseStatus, java.util.Map, java.io.InputStream, com.sap.dtr.console.deltav.HttpRequest

        at com.sap.dtr.console.deltav.ResponseFactory.createResponse(ResponseFactory.java:52)

        at com.sap.dtr.console.deltav.Connection.readResponse(Connection.java:198)

        ... 15 more

Caused by: java.lang.NoSuchMethodException: com.sap.dtr.console.deltav.MacroStatusResponse.<init>(com.sap.dtr.console.deltav.ResponseStatus, java.util.Map, java.io.InputStream, com.sap.dtr.console.deltav.HttpRequest)

        at java.lang.Class.getConstructor0(Class.java:1937)

        at java.lang.Class.getDeclaredConstructor(Class.java:1303)

        at com.sap.dtr.console.deltav.ResponseFactory.createResponse(ResponseFactory.java:39)

        ... 16 more

[ErvinSzolke · Accepted solution]

Hi Daniel,

strange indeed. Could you please make an attempt to use this DTR console instead?

-- DTR Console "replicate command" don't work

This note includes a fixed DTR console.

I hope this helps.

Best Regards,

Ervin

[ErvinSzolke · Accepted solution]

by the way no need to deploy anything, just rename the sda to zip, extract it and you can use it right away.

[daniel_robinson2 · Accepted solution]

Hi Ervin,

I extracted and corrected the syntax of run.sh for UNIX and that got me past the error. Thanks. It connected to the target NWDI and started to import but failed on the following error.

It looks like note.959218 applies - option 1 applies

{0}#1#javax.servlet.ServletException: The SQL statement "UPDATE "DAV_RESOURCE"

SET "RESOURCETYPE" = ?,"MODIFICATIONTIME" = ? WHERE "RESOURCEID" IN (SELECT "VSE

1"."VERSIONID" FROM "PVC_ACTVERSVIEW" "VSE1" INNER JOIN "PVC_ACTVERSVIEW" "VSE2"

ON "VSE1"."VERSIONID" = "VSE2"."VERSIONID" WHERE "VSE1"."VERSIONSETID" = ? AND

"VSE2"."VERSIONSETID" = ?) AND "RESOURCETYPE" <> ?" contains the semantics error

[s]: - 1:139 - the table or view >>PVC_ACTVERSVIEW<< does not exist

[ErvinSzolke · Accepted solution]

Hi Daniel,

first of all Happy New Year! 😉

you are absolutely right, the mentioned note applies. Can you please make an attempt redeploying the DTR database schema as described in the note? That should resolve the above error.

Best Regards,

Ervin