nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

calling DNR script from data deploy script - Urgent

Richu

Hi All,
I have a requirement of calling a DNR script from a data deploy script.I am calling DNR scripts from other Open deploy scripts and it is working fine. Is there any way to call the DNR script from the data deploy script. I have gone through the manuals but no help..
Please advice on how to call a DNR script froma data deploy script.

Thanks in advance
Richa

Find more posts tagged with

Comments

vpatel

What version of OD/DD?

computed.jpg

Adam Stoller

Hi All,
I have a requirement of calling a DNR script from a data deploy script.I am calling DNR scripts from other Open deploy scripts and it is working fine. Is there any way to call the DNR script from the data deploy script. I have gone through the manuals but no help..
Please advice on how to call a DNR script froma data deploy script.

Thanks in advance
Richa

As I recall, DD doesn't support DNR.
- For source-side scripts you could handle it by wrapping your call to DD with some other script to do something either before or after the DD process was run.
- For target-side scripts, it doesn't really apply - instead you would be using a trigger script process in your DB

What, precisely, are you trying to accomplish?

Richu

Thanks Adam.
I tried to wrap my DD script in Open Deploy Script. PFA the same file. I am also using the DNR to call a perl file. But my perl file is not getting called. Please look into the file and let me know if i need to add anything in the script.

Thanks,
Richa

Adam Stoller

Thanks Adam.
I tried to wrap my DD script in Open Deploy Script. PFA the same file. I am also using the DNR to call a perl file. But my perl file is not getting called. Please look into the file and let me know if i need to add anything in the script.

Thanks,
Richa

You provided:[html]

<script cmd="g:\\Interwoven\\teamsite\\iw-perl\\bin\\iwperl.exe C:\\TestPerl\\Invoke_BatchScript.ipl" async="no" />

[/html]If I read the DTD correctly:

Also - please note the distinction between the words "script" and "configuration" - what you posted was a "configuration", what I was talking about was a wrapper "script" around the invocation of DD - either as a stand-alone script or invoked as part of a DNR from an OD configuration.

Richu

Hi Adam,
Sorry for the misunderstanding in the words "script" and "configurations". I have modified my config file as per your suggestions. PFA the modified file. It is calling the data deploy file but still the perl file is not getting called.
Also can you provide more details on wrapper "script" method and which pdf to refer for this.

Thanks,
Richa

Adam Stoller

Hi Adam,
Sorry for the misunderstanding in the words "script" and "configurations". I have modified my config file as per your suggestions. PFA the modified file. It is calling the data deploy file but still the perl file is not getting called.
Also can you provide more details on wrapper "script" method and which pdf to refer for this.

Thanks,
Richa

Your configuration file is still wrong - I suggest you read the ODHOME/dtd/conf/odddeployment.dtd - if you don't know how to read a DTD, ask someone at your site or learn.

The wrapper script is probably mentioned in passing in the various OD manuals, and almost certainly within various threads on this forum - I have neither the time or inclination to provide you free hand-holding training in a public forum - read the manuals, get training, or hire someone who knows what they're doing.

nipper

How are you invoking OD ?

I will try to re-explain what Adam could not get you to understand.

DataDeploy does not support DNR basically because DNR expects to run something on the receiver. Since your receiver is a RDB server, it does not have OD client and Perl loaded. Thus no DNR

If you want to run something on the TS server, then you need to do it in whatever process you start OD. That could be a script (like the perl script that kicks off OD in a WFT), or a new java program and external task if you run OD from WFM. If you are using the OD GUI or a custom menu item, then it is tougher.

Richu

I am running the Opendeploy script through the teamsite UI- deployments
Please find below the flow of my deployment.
I am using an Open Deploy script say content.xml which is using a DNR to call a perl file say a.ipl. This a.ipl will run another OpenDeploy script(the one which is attached in this thread) using iwodcmd start command. Now in this attached open deploy script , i am calling a data deploy script(which is successful) and a DNR to call a perl file say b.ipl.
You are absolutely right that DataDeploy does not support DNR. But my file(the one attached in this thread) is an open deploy script and not the DataDeploy. So it should support the DNR. right?
But it is not calling the perl file through DNR.
I hope you got the scenario?
Please let me know in case you need more information.
I am using OpenDeploy - version 7.1

Thanks,
Richa

Adam Stoller

...
You are absolutely right that DataDeploy does not support DNR. But my file(the one attached in this thread) is an open deploy script and not the DataDeploy. So it should support the DNR. right?
But it is not calling the perl file through DNR.
...

What's the first element within your deploymentConfiguration container in your posted configuration file?
Is it "dataDeploy"? - if so - YOU CANNOT USE A DNR IN A DATADEPLOY CONFIGURATION FILE - like I said, learn how to read a DTD, read the DTD, and then rethink your approach and do something different - because if you keep doing the same thing over and over again, you're going to keep getting the same results over and over again.

Richu

I went throught the DTD, you are absolutely right, we can have either datadeploy element or definition-deployment element.
Actually the only reason i want to use DNR with data deploy is that if the perl script called by DNR fails then the data deploy should roll back.

I am looking into the manuals, but i am not getting any solution.
Can u please give some advice on this problem so that i can go in a right direction.

Thanks,
Richa

Adam Stoller

I went throught the DTD, you are absolutely right, we can have either datadeploy element or definition-deployment element.
Actually the only reason i want to use DNR with data deploy is that if the perl script called by DNR fails then the data deploy should roll back.

I am looking into the manuals, but i am not getting any solution.
Can u please give some advice on this problem so that i can go in a right direction.

Thanks,
Richa

You create a wrapper script around the call to DD.
The wrapper script checks the exit status of the DD deployment and then passes that information back to its caller.
If the wrapper script is being run by an OD DNR you need to print the requisite XML snippet to STDOUT to signal failure to OD (this is documented).

If DD fails - nothing gets committed, so there is no need to rollback the database (that's the beauty of databases)

ISCBorisB

...If DD fails - nothing gets committed

It seems to me that his problem is revrsed, eg
"...if the perl script called by DNR fails then the data deploy should roll back..."

Not sure if that can be done just by DD/OD, he needs to code some sort of two-phase Commit

nipper

It seems to me that his problem is revrsed, eg
"...if the perl script called by DNR fails then the data deploy should roll back..."

Not sure if that can be done just by DD/OD, he needs to code some sort of two-phase Commit

Then he should run it before the DD not after. If DD is configured correctly, then it will complete or rollback. His "DNR" should not affect the DB (though I do not know what it is supposed to do) and it should be able to run before the DD not after.

Richu

Hey do you have any idea on "how to call a perl script from a data deploy script?" is it possible??

Thanks,
Richa

curiousmaverick

u mean from a datadeploy configuration file?

Richu

yes, from data deploy config file..

Adam Stoller

Hey do you have any idea on "how to call a perl script from a data deploy script?" is it possible??

Thanks,
Richa

I believe you're talking about DNR - which doesn't exist for DataDeploy.

If you're trying to do something just before, or just after, the DataDeploy is run - wrap a script around the call to DataDeploy.

If you're trying to set data information to be deployed - look in the manuals for information on TuplePreProcessors.

Richu

Now I have changed the approach. I am using dbLoader in my open deploy config file(dd_metadata.txt). It first deploys the content and then metadata using dbLoader. But it is not working. It is showing Status:Failed. But If I use the config file without dbLoader it works perfectly fine. As per my requirements, the content should be deployed to the target file system, metadata to be deployed to the database and using DNR , a perl file should be called which will further call a batch script. Now, if the batch script fails, the metadata and content deployment should rollback.
PFA the files and let me know where I am going in wrong direction. Please guide me!!

Thanks,
Richa

Richu

One more question:
can I use dnrDeploymentJob element in data deploy config file? I feel that we can use it as it contains "Deployment" element.
Please confirm.
And if we can use then please tell me the exact location where can I use the dnrDeploymentJob element.

Thanks,
Richa

monu1

Hi ,

I think your opendeploy script is wrong thats why its not able to call the .ipl file.
try this :-

Richu

It do calls the perl file if i remove the dbLoader element from my script. And it also deploys content successful. But when I put back the dbLoader element, it gices Status:failed. So, the problem is with the dbLoader.

Adam Stoller

...
As per my requirements, the content should be deployed to the target file system, metadata to be deployed to the database and using DNR , a perl file should be called which will further call a batch script. Now, if the batch script fails, the metadata and content deployment should rollback.

I cannot comment on why the use of dbLoader is failing - however there is an assumption in the above which is, I believe, incorrect: If you run a DNR after the DataDeploy process has completed and the data changes have been committed to the database, I do not believe that the failure of the DNR will cause the data in the database to be rolled back; the files that were deployed via OpenDeploy will be rolled back, but I don't think the database will be.

If your DNR does not need the database changes to be in effect in order to succeed, you should probably use two (possibly three) DNRs (I believe they run in the order listed, though I'm not 100% sure of that) where the first one is your batch script (running on the target?) and the second one is a wrapper script around a call to DataDeploy.

Adam Stoller

One more question:
can I use dnrDeploymentJob element in data deploy config file? I feel that we can use it as it contains "Deployment" element.
Please confirm.
And if we can use then please tell me the exact location where can I use the dnrDeploymentJob element.

Thanks,
Richa

Read the DTD - DataDeploy provides no script calling features other than TuplePreProcessors.

Richu

Hi Adam,
I have a doubt in the third point:
1. If OD fails - neither DNR should get called (I again am assuming facts not in evidence).
2. If OD succeeds but the first DNR fails (and correctly signals such failure to OD), then OD should rollback the changes and the second DNR should not get called.
3. If OD succeeds and the first DNR succeeds, the second DNR should kick off DataDeploy; if DataDeploy fails, then the files deployed by OD should be rolled back (you might register a third DNR, replicating the first one, but set only to run on "failure" to re-do whatever the first one did now that the content has been rolled back)
4. If OD succeeds, and the first DNR succeeds, and the second DNR / DD succeeds (and the optional third DNR is not called) - you have a success

Doubt: If the data deploy fails will the first DNR (which was success) rollback?? I tried the same scenario. But the first DNR didnt rollback. I have already posted this problem. Please have a look and advice.

Thanks,
Richa