Transactional deployment not working

Hi,

I wanna make openDeploy and DatadeployTransactional.
now I have one opendeploy task and two datadeployments to do.
Opendeploy will push the file to target server and first datadeploy will delete entry of a particalar dcr in database and second will insert it(Its a kinda Update fuctionality I m implementing)I have used dnr to call the

Now the problem is If my delete works n insert fails there in no roll back of database.I lose the record since the delete has done its work.which shd not be the case.

But whenever any datadeploy fail,OpenDeploy Rolls back.So I guess the data deployments are not transactional

Can anyone help me out with this issue.
I have pasted the code below.

<script cmd="d:\iwperl.exe data_Deploy_delete.ipl $job_id^ $task_id^ $workarea^ $files^ $passtask^ $dd_type^" async="no"/>

<script cmd="d:\iwperl.exe data_Deploy_insert.ipl $job_id^ $task_id^ $workarea^ $files^ $passtask^" async="no"/>

Find more posts tagged with

Comments

Bhagya

oops the code:::

<script cmd="d:iwperl.exe d:\data_Deploy_delete.ipl $job_id^ $task_id^ $workarea^ $files^ $passtask^ $dd_type^" async="no"/>

<script cmd="d:\iwperl.exe d:\data_Deploy_insert.ipl $job_id^ $task_id^ $workarea^ $files^ $passtask^" async="no"/>

Bhagya

I m unable to paste the code ....so I m attaching a file containig the code.

Help needed.

Thanks in advance

Bhagya

Pawan

You can do the same delete and insert through the same ipl file, if that is not a constraint and if you are doing this for the same database.
I think this should solve your problem.
Are you doing a commit in your delete ipl file before exit ?

Bhagya

Hey hi Pawan.

I m actually doing delete n insert in the same ipl.I had changed the code for better understanding of functionality.And it is for the same database

there is no commit for delete since I am using a do-sql stmt for deletion of the content.
and for insertion I m using datadeploy

I m attaching the delete code

Bhagya

Can anybody suggest me a solution ...I need it urgently..

thanks in Advance

Regards,
Bhagya