DRM Errata Close Version

Here’s a quick little post on some errata in the DRM documentation. I was recently looking at setting up a process to unload versions as part of my automation scripts. I was using regular batch utility execution, instead of the configuration file method (see here).

According to the documentation, the way to do this is:

28_1_Doc1

I set up a test version to test the execution out.

28_2_Ver

And, the code that I use looks like this:

When I run the script, though, nothing happens. The version remains loaded.

28_2_Ver

I wasn’t sure why this was. Using a configuration file does give me the right results though. I then realized that I should probably check the logs.

28_3_Error

In most applications, 0 indicates successful completion. This is also how it is for DRM. There are some other result codes as well collected in the documentation. For instance, the documentation tells us that 210 is reserved for incorrect parameters.

28_4_Doc2

The DRM batch log also tells us that there is a problem with a parameter.

28_5_Log1

I couldn’t figure what I was doing wrong and I tried a few different things, like putting double quotes around the version name and the like. But no dice. I then realized that anywhere that the version name is referred to, in the documentation, the switch used is “/vabbrev”. As an example:

28_6_Doc3

So, I changed the switch from “/abbrev” to “/vabbrev”…

…and it worked!

28_7_Success

So there you have it. A bit of errata on the Oracle documentation that probably needs to be corrected in case you run into the same issue that I did.

About Vijay Kurian

Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years (increment years if reading post-2015). Having worked with Essbase, Planning, DRM and other assorted technologies during that time, he’s made the frankly, average decision, to write about them. He hopes to contribute frequently to US Weekly, People and Sensible Chuckle magazines on improving reporting solutions, creating master data management systems and zzz…

Leave a Reply

Your email address will not be published. Required fields are marked *