data deployment failure/success..?

Hi all,
I am again asking the same question but in diffrent way. Sorry.. but its urgent.

1. My data deployment is not updating the DB, as the content is beyond the capacity of table column. It is raising exception ORA-12899 in log file. But the return status is completed in OD-GUI and on command prompt also.

2. If the DB does not updates then how to inform the user that something went wrong? I mean how to get the result where deployment is succeded or failed?

3. on running the 'iwodcmd start ViewerCategory_en_US ' the corresponding deployment log is gets written in src.ViewerCategory_dd_en_US.basearea.USLAXCMSDEV.to.database.log

under $ODHOME\log\..

Is there any way to capture the latest log(only for the current deployment)
and parse so that can get idea of deployment status.

Please help me out in these issues...

Thanks,
-Parag

Find more posts tagged with

Comments

Ambuj

Hi all,
I am again asking the same question but in diffrent way. Sorry.. but its urgent.

1. My data deployment is not updating the DB, as the content is beyond the capacity of table column. It is raising exception ORA-12899 in log file. But the return status is completed in OD-GUI and on command prompt also.

2. If the DB does not updates then how to inform the user that something went wrong? I mean how to get the result where deployment is succeded or failed?

3. on running the 'iwodcmd start ViewerCategory_en_US ' the corresponding deployment log is gets written in src.ViewerCategory_dd_en_US.basearea.USLAXCMSDEV.to.database.log

under $ODHOME\log\..

Is there any way to capture the latest log(only for the current deployment)
and parse so that can get idea of deployment status.

Please help me out in these issues...

Thanks,
-Parag

You can surely get the result of the deployment. In below example $deploy_command contains the entire command string with iwodcmd start and parameters. $results will store the output of the execution of this command. Try this out and I hope you will be able to solve your issue.

my $results= "$iwhome/tmp/results.$wfid";

my $results = `$deploy_command > $results`;

cute_guy

Hi all,
I am again asking the same question but in diffrent way. Sorry.. but its urgent.

1. My data deployment is not updating the DB, as the content is beyond the capacity of table column. It is raising exception ORA-12899 in log file. But the return status is completed in OD-GUI and on command prompt also.

2. If the DB does not updates then how to inform the user that something went wrong? I mean how to get the result where deployment is succeded or failed?

3. on running the 'iwodcmd start ViewerCategory_en_US ' the corresponding deployment log is gets written in src.ViewerCategory_dd_en_US.basearea.USLAXCMSDEV.to.database.log

under $ODHOME\log\..

Is there any way to capture the latest log(only for the current deployment)
and parse so that can get idea of deployment status.

Please help me out in these issues...

Thanks,
-Parag

After googling for ORA-12899 it says value too large for column string , you should have given the error msg in the post. When this type of errors occur usually the datadeploy skips the insertion of tuple based on the default datadeploy configuration and other tuples will have been inserted/updated.

So you need to post ur configuration file so that can be analysed.

Is there any way to capture the latest log(only for the current deployment)
and parse so that can get idea of deployment status.

The latest logs will be stored in the opendeploy log directory in ODhome/log folder

Parag

yes, the exception is due the field having too large content. I am doing it purposfully.
My project requirement is to send an email on failure of deployment.
In this case the datadeployment fails,(exception occurs and the DB doesnt update) but it returns completed/Success.

tried with '$iwodcmd 2>$results';
but no way as it says " Status: Completed".

Anybody catched these errors? how?
can anybody help me?
Thanks
-Parag

cute_guy

yes, the exception is due the field having too large content. I am doing it purposfully.
My project requirement is to send an email on failure of deployment.
In this case the datadeployment fails,(exception occurs and the DB doesnt update) but it returns completed/Success.

tried with '$iwodcmd 2>$results';
but no way as it says " Status: Completed".

Anybody catched these errors? how?
can anybody help me?
Thanks
-Parag

check the datadeploy admin pdf and add the necessary configuration to throw the error.

Parag

check the datadeploy admin pdf and add the necessary configuration to throw the error.

Thats i am looking for.
But did not have any clue.

I came to a conclusion that whenever the database deployment raises the exception and fails to update the DB, the DB gets rolled back and always the result of this process is Completed. Not the Failed or Completed with Errors.

If anybody gets any of these errors for data deployment please let me know.

Thnx,
-Parag