I have following OD config file,
<script cmd='/opt/iw-home/TeamSite/tools/java/bin/java ExecuteDBDeployment $odSourceArea $dbname $filelist $iwdd $ddConfig' as='iwui' async='no'/>
<script cmd='/opt/iw-home/TeamSite/tools/java/bin/java ExecuteDBDeployment $odSourceArea $dbname2nd $filelist $iwdd $ddConfig' as="iwui" async="no"/>
I am invoking DD through DnR on OD success. I am deploying to two different target and database servers in each definition. I am able to get this working and data is getting deployed as well as inserted to different servers. But when I try to test this for failure scenario, it is not working. To test the the rollback scenario, I made changes to the second database and committed these chances so that DD on second database will fail. But when I invoked the deployment, the data from the first database did not get rolled back. Although, the entire OD status given is "FAILED" ... Content deployment from the first and second server is rolled back but database deployment from the 1st DB server is not getting rolled back.
So my question is, does OD support rollback of DnR when entire deployment is transactional? Or I have to write my own logic to handle this scenario?
Environment:
TeamSite : 7.2.1 Solaris
OpenDeploy: 7.2.1
Database: Oracle