Skip Headers

Oracle Demantra Implementation Guide
Release 7.3
Part Number E05136-11
Go to Table of Contents
Go to previous page
Go to next page

Tips and Troubleshooting

For reference, the first section describes the first-time login procedure for Demantra applications, followed by several sections of tips. After that, this chapter lists possible errors that users may encounter and describes how to resolve them. The errors are listed alphabetically by message text or general description.

See Also

Oracle Demantra Release Notes Oracle Demantra Installation Guide

This chapter covers the following topics:

Initial Logon to Demantra

The first time you log onto Demantra Web applications, Demantra downloads and installs software. For reference, this section repeats and expands on the details from the user guides.

Initial Logon to Collaborator Workbench

This operation is necessary only once for each computer.

  1. Launch a supported web browser.

  2. Enter the URL for Collaborator Workbench:

    http://server name/virtual directory/portal/loginpage.jsp

  3. In the Log On dialog box, enter your user name and password.

  4. Click Login.

  5. If you are prompted to install JRE, do so. Choose the Typical installation and accept all the default values, or follow your own site practices.

    After you install this software, Collaborator Workbench comes up, displaying your personal page.

    Demantra displays a dialog box that asks if you want to trust the signed application distributed by Oracle.

    Note: This dialog box is sometimes displayed as soon as Collaborator Workbench comes up. In other cases, you do not see it until you click a worksheet name.

  6. Click Yes, (or Always) or Start, depending on which dialog box is displayed.

Initial Logon to the Web Client

This operation is necessary only once for each computer.

  1. Launch a supported web browser.

  2. Enter the web address for the Web client:

    http://server name/virtual directory/portal/partnerLogin.jsp

  3. Type your name and password and click Login.

    Demantra prompts you to install JRE.

  4. When you are prompted to install JRE, do so. Choose the Typical installation and accept all the default values, or follow your own site practices.

    Demantra next displays a dialog box that asks if you want to trust the signed application distributed by Oracle.

  5. Click Yes (or Always) or Start, depending on which dialog box is displayed.

Initial Setup and Logon of Offline Environment

This operation is necessary only once for user on a given computer.

Note: When you perform these steps, you must have network access to the Demantra server, which must be running.

  1. Within a normal Demantra worksheet, click File > Export for Offline Use.

    Demantra displays the following screen:

    the picture is described in the document text

    Here you specify the directory where Demantra will store your offline information. By default, this is c:/Documents and Settings/username, but you can choose a different location. The offline directory itself is always named Demantra.

  2. Specify the offline directory location and click OK.

    Demantra then displays the following screen:

    the picture is described in the document text

    Here you specify which data to take offline. You might want to work with only a single combination, for example.

  3. Choose one of the options and click OK.

  4. Log off Demantra.

  5. Enter the web address supplied by your system administrator for offline access.

    This URL probably has the following format:

    http://server name/virtual directory/portal/launchDPWeb.jsp

    For example:


    Depending on what is already installed on this computer, Demantra then briefly displays a screen titled Java Web Start, which shows its progress in scanning and downloading the required JAR file.

    the picture is described in the document text

    After that, Demantra displays a dialog box that asks if you want to trust the signed application distributed by Oracle:

    the picture is described in the document text

    Note: If Demantra does not display this screen, that means that you have already downloaded the applet to this machine. You do not need to download it again.

    Note: Depending your system configuration, the screen might be slightly different, with the following options instead: Yes, Always, and No.

  6. Click Start or Yes (or Always), depending on which dialog box is displayed.

    Next, Demantra displays the following prompt:

    the picture is described in the document text

  7. Click Yes.

    Demantra creates a shortcut labeled Demantra Offline Worksheets, which you use to access your offline worksheets in the future. This shortcut is on your desktop and on your Start menu.

    This user is now configured to use worksheets offline on this machine.

About Demantra Configuration Settings

The core Demantra configuration details are stored in multiple locations:

Demantra_root\Demand Planner\Security Management\ds.ini

Parts of this are encrypted and must be edited with a utility provided by Demantra (encryption.exe); see “Redirecting Demantra to a Different Database”.

Note: Almost all the parameters of this file can be edited from within the Business Modeler, and it is better to use the Business Modeler to make changes so that the audit trail can record them. The Business Modeler also provides drop-down menus of possible options, where applicable.

Note: To access these parameters within Business Modeler, click Parameters > System Parameters.

Key Settings Controlled by the Installer

This section summarizes the key settings that the installer controls and indicates where those settings are stored.

Installer Screen Installer Option In the APS_PARAMS table In ds.ini
DBA Information DBA username (to access database as DBA and load data) Not saved here Not saved in this file.
TNS Name Tnsname
Configure Oracle Database User Database type DBType DBType
User (to store Demantra data) DBUser LogID**
Password DBPassword LogPassword**
Configure JDBC Connection Server name (host machine or IP address on which database resides) ServerName ServerName
Port DBPort DBPort
Oracle SID (Oracle only)* DBName Database
Specify Web Address Root address and virtual directory AppServerURL
Not saved in this file.
**Encrypted in the ds.ini file.

APSMode Parameter

The APSMode parameter (stored only in the ds.ini file) controls whether to use the Stand-Alone Integration Tool (aps.bat). This tool consists of a subset of the APS, packaged as an executable file.

The installer automatically sets this parameter. This parameter has the following effect:

For information on using aps.bat, see “Executing an Integration Interface”.

Other Parameters

The installer also sets parameters for the following purposes:

For these parameters, see “Database” and “Email”.

JAVA_HOME System Environment Variable

Tomcat requires JDK, which means that the JAVA_HOME system environment variable must be set (not a user environment variable). The installer automatically installs JDK if appropriate and sets this environment variable. JAVA_HOME should be set equal to the directory that contains the bin directory of JDK.

Other Configuration Files

The installer also makes edits to the following files. If you make a change to a port or protocol or other, you must be sure to make the change in the following files:

Redirecting Demantra to a Different Database

Oracle does not support Microsoft SQL Server in this release. Please monitor My Oracle Support for versions supporting SQL Server. Items marked with ** are not valid unless support for Microsoft SQL Server is available.

In Demantra 7.3.0, the database connection (and data source configuration) is controlled by the Java Naming Directory Interface (JNDI).

To point Demantra to a different database without rerunning the installer, complete the following steps:

  1. Make a backup copy of server.xml. This file is located in …\Oracle Demantra\Collaborator\Tomcat\conf\.

  2. Open server.xml for editing.

  3. Locate the following sections:

    Context path="/demantra" 
    	docBase="E:\Program Files\Oracle Demantra 73b37\Collaborator\demantra"      
  4. Modify the “username” and “password” sections to point to the new schema and to use the new password.

  5. To point to a different DB, modify the DB host and SID within the URL, which in this example are “” and “ORCL”, respectively.

  6. Restart the web server. (If you are not using Apache Jakarta Tomcat, refer to your application server’s version-specific documentation to learn how to modify the database hostname, username, password, and SID (system identifier) specified by the JNDI.)

Java Tips

This section contains background information about how Demantra uses Java. The Demantra Web client (Demand Planner Web, Promotion Effectiveness, or Settlement Management) uses JRE. Each machine that runs the Web client should have JRE, which Demantra automatically downloads when necessary.

Note: JDK is needed only if you are using Tomcat. The JDK is needed on the machine that runs Tomcat, not on the client machines. For information on Tomcat, see the Oracle Demantra Installation Guide.

Java Versions and Older Demantra Installations

JRE versions are generally backwards compatible. If you are using an older version of the Web client, you can use the same JRE as the current Demantra. This means that, from a single machine, you can log into different Demantra installations, even if they use different versions of Java.

If the client machine either does not have a version of JRE installed or the latest installed version is older than what Demantra currently supports, the user will be prompted to download and install the latest supported version. If the machine has at least one supported version installed, Demantra will use the latest supported version.

Tips for a Clean Java Installation

It is possible, but tricky, to keep multiple versions of Java running on a single machine. Oracle recommends that you carefully remove all Java versions other than the current version used by Demantra; to remove them, use the Add or Remove Programs control panel.

It is also useful to check your PATH system environment variable. Java is added to this, and you should make sure it includes only the Java that you intend to use. Note that Oracle provides Java as well; you do not need to uninstall these, but you should probably remove those versions from the PATH system environment variable.

Finally, you should make sure that the supported web browser is configured to use the correct Java version:

  1. Click Tools > Internet Options.

  2. Click the Advanced tab.

  3. Within the Java item, make sure that the correct version of Java is selected for use with applets, as specified in the Oracle Demantra Installation Guide.

Setting client.JREMaxMemory with configureEnv.jsp

The configureEnv.jsp tool sets JRE maximum memory on each client’s installed java plugin {located at: user home directory}/Application Data/Sun/Java). It affects all applications that run with that plugin. To run this utility, use the following url (filling in the appropriate server and port number): http://application_server_host:port/application_root/portal/configureEnv.jsp For example, if running the client on port 8080 of the local machine, you would use: http://localhost:8080/demantra/portal/configureEnv.jsp.

Tomcat Tips

For demos or in production you can use Tomcat as the Web server, and the installer supports this option for convenience. Oracle has tested with Apache Jakarta Tomcat 6.x.

Installing with Tomcat

This section briefly notes the differences between a demo installation and the usual installation.

  1. Apache Jakarta Tomcat 6.x requires JDK 1.5 (This can be obtained free at You do not have to pre-install this, but you should make sure you do not have an earlier version of JRE on the machine. If so, uninstall that.

  2. Run the installer like usual, except choose Demo for Web Server type.

  3. If prompted, specify the desired value for the JAVA_HOME system environment variable. The installer prompts you for this if more than one Java is installed on the machine.

Changing the Default Tomcat Port

The Tomcat default port is 8080. The installer does not change the default configuration for the port. This must be done manually in the file Demantra_root/Collaborator/Tomcat/conf/server.xml.

Note: If you do use the 8080 port, note that the Oracle XDB database user tries to use that port. See “Port Collision with Oracle XDB User”.

Starting the Server if Using Tomcat

If you chose the Demo Web Server type, the installer adds Start menu options to start and stop Tomcat.

  1. In Windows, click Start and click Programs.

  2. Click Demantra > Demantra Spectrum release > Start Web Server.

Clearing the Tomcat Cache

To clear the Tomcat cache, delete the directory Demantra_root/Collaborator/Tomcat/work/standalone/localhost.

You may need to do this if you receive the “Object Error” message; see “Object Error”.

Renaming the Installation Root Directory

It is safest to reinstall Demantra rather than to rename the root directory where it is installed. However, if you are using Tomcat, you can rename the Demantra root directory and redirect Tomcat. To redirect Tomcat, edit the file Demantra_root/Collaborator/Tomcat/conf/server.xml. In this file, edit the parameter docBase. This parameter should specify the full path to the Demantra virtual directory.

Writing the Tomcat Log to a File

By default, the Tomcat log is written to the console. To reconfigure Tomcat to write its log to a file, edit the file Demantra_root/Collaborator/Tomcat/conf/server.xml.

Find the Logger section and edit it as follows:

<Logger name="tc_log"
		verbosityLevel = "INFORMATION" /> f

Error Messages or Trouble Descriptions

APS.bat Runs, Then Disappears - ClassNotFoundException


When running the standalone integration from a custom batch file other than a direct call to APS.bat, incorrect specification of the path can lead to failures. In other words, the command window opens and then immediately disappears. Nothing apparently happens.


Example of an invalid call, creating a new batch file with the following syntax will fail:

"C:\Demantra Spectrum\Demand Planner\Integration\aps.bat" IMPORT_DATA TEST TEST

Since the APS.bat file relies on relative paths to connect to the Java class path and call the aps.jar main class, if the call comes from a different batch file or command line window that is located outside of the APS.bat file folder, these calls may fail with a 'ClassNotFoundException' error.


To resolve the issue, several solutions ensure the process will use the correct directory:

  1. Make sure that the calling batch file switches to the APS.bat folder before calling the APS.bat file with the parameters. For example:

    CD "C:\Demantra\Demand Planner\Integration" APS.bat IMPORT_DATA TEST TEST"
  2. Use the START command to call the APS.bat file and pass in the APS.bat folder location with the parameters. For example:

    Start /B /D "C:\Demantra\Demand Planner\Integration\" aps.bat IMPORT_DATA TEST TEST

    Note: Note: This second option is most useful when the calling batch file includes more commands and avoids the need to change the current directory back to its original location.

  3. The third option leverages the workflow to run the .bat file. The workflow can run with a relative path (leveraging the token) to the application server root parameter.

    Note: For information about relative path requirements, see Parameters Used as Arguments for a Workflow.

Cannot Connect to Database


A user tries to log into a Demantra desktop product but receives the following message:

				Cannot connect to database

This message is also displayed in the DOS window on the server.


The database is not running.


Start the database.

Cannot Connect to Server


A user receives the following message when trying to run a worksheet in one of the Web products:

				Cannot connect to server

The worksheet is not displayed.


There is a Java problem on this user's machine.


  1. Stop the Web server.

  2. On the user's machine, open the Java Plug-in control panel, clear the Java cache, and remove the certificate.

  3. Restart the Web server.

  4. When the user next opens a worksheet, he or she should accept a new certificate as usual.

Could Not Allocate Space


When you started the Web server, you received a message complaining that Demantra could not allocate space.


The tablespaces assigned to Demantra are not large enough.


Contact the database administrator and increase all the Demantra tablespaces.

Data Is Exported as Text, Not Currency


In the Web products, the user exports to Excel, and some of the values are formatted as text (General) rather than as currency.


When receiving data from an external source, Microsoft Excel uses the Regional Options in the Windows Control Panel to determine whether a given cell should be formatted as Currency or General (as is or text).


Later versions of Excel provide an option for converting problematic cells that it recognizes. If Excel does not provide any such option, do the following:

  1. Open the Windows Control Panel.

  2. Double-click Regional and Language Options.

  3. On the Regional Options tab, make sure that the Currency setting uses the same currency symbol as Demantra.

  4. Export again from Demantra.

DOL Link to Excel Uses Wrong Link


The user tries to link Demantra data into Excel via DOL, but the wrong link is provided.

Specifically, in Excel, the user clicks Data > Get External Data > New Web Query, and then browse to the file DOLLogin.jsp. The user then logs in and selects the query. When the user returns to Excel, the link shown is the wrong one.


This problem is caused by a defect in older versions of Excel.


Copy and paste the link from the web page directly.

Error in Process Execution

See “Workflow Process Has Failed”.

Error Loading Tasks, Error on Page


In the My Tasks area of Collaborator Workbench, a user sees one of the following messages:

				error on page error
				loading tasks


On this machine, the Regional Settings are not US English.


Change the Regional Settings to US English., as described in “Date Dialog Boxes Behave Strangely”.

Error When Opening a Worksheet from the Members Browser


The user tries to use the Open or Open With menu options to open a worksheet from the Members Browser (or a content pane that uses the Members Browser). An error occurs.


There may be an underlying problem with the Java plug-in.


  1. Make sure that only the correct version of JRE is installed on your machine (see “Initial Logon to Demantra”).

  2. If you are using Tomcat, clear the Tomcat cache on the server by deleting the directory Demantra_root/Collaborator/Tomcat/work/standalone/localhost.

  3. Restart the Web server and try again to open the worksheet.

  4. If this does not fix the problem, then uninstall JRE from the user's machine. To do so, use Add/Remove Programs and restart the machine if prompted to do so.

  5. Then complete the steps in “Initial Logon to Demantra”.

Error While Running Worksheet Window: Object Error

See “Object Error”.

File Download When Using launchDPWeb.jsp or partnerLogin.jsp


When the user accesses either of these URLs (http://server name/virtual directory/portal/partnerLogin.jsp or http://server name/virtual directory/portal/launchDPWeb.jsp), the following dialog box is displayed:

				File download 
				Do you want to save or open this file 
				Name: partnerLogin.jsp [or launchDPWeb.jsp]


This message is displayed if Web Start is not installed on this computer. Normally, the latest version of Java Web Start is installed automatically along with the JRE when you first run Collaborator Workbench or any of the Web client interfaces.


  1. Log into Collaborator Workbench and check to see if it has a link labeled Click here to install Java Web Start.

    1. If so, click that link.

    2. This installs Java Web Start 1.4.2_10.

    3. Demantra next prompts you to install JRE.

  2. On the other hand, if JRE is already installed on this computer, uninstall it. To do so, use Add/Remove Programs and restart the machine if prompted to do so.

  3. Log onto Collaborator Workbench.

  4. Follow the steps in “Initial Logon to Collaborator Workbench”.

Internal Error: Please Check Database and Network Connections

See “Workflow Internal Error”.

Invalid Argument to Function


When a user tries to run a specific worksheet in the desktop (Demand Planner), the following message is displayed:

				Invalid argument to function


There is an error in the client expression of at least one series used in this worksheet.


  1. Make a list of all the series in the affected worksheet.

  2. Within the Business Modeler, check the client expressions of those series. You can click the Verify Expressions button in the toolbar to verify all server and client expressions.

  3. Correct the client expression, save the changes, and reload the changes to Demand Planner.

Java Out of Memory


The user receives a message from Java saying that it is out of memory.

Possible Resolutions

License File Has Expired


After logging into a Demantra Web product, a user receives the following message:

				Your Security License File has expired

The user is not able to proceed further.

Possible Explanations

This message can occur for several reasons:


  1. If the user tried to log onto Workflow Manager, make sure that the user is a member of the workflow group, as specified by the parameter; see “Providing Access to the Workflow Editor”.

  2. Make sure that the database is running.

  3. Make sure that the DBName parameter has been set correctly. Typically, with an Oracle installation, the problem is that you have set this parameter to the host name of the database machine, rather than the Oracle SID. See the Oracle Demantra Installation Guide.

  4. Contact Oracle and get a new license.

No Shortcut to Access Offline Worksheets


A user is trying to log into an offline worksheet but does not have a shortcut set up on the machine to do this.


The user either deleted the shortcuts or failed to create them when prompted.


First make sure that the following directory exists on this user's machine:

C:\Documents and Settings\username\.javaws\cache\indirect\

This directory should include a file with a name such as indirect46519.ind. The filename will include a different number.

No Suitable Driver (Integration)


A user tries to perform import or export via the Stand-Alone Integration Tool (Demantra_root/Demand Planner/Integration/aps.bat), but gets the following message in the DOS shell:

				Error in Connection to Database, No suitable driver. 
				Retrying to Connect...


This error occurs if you have the incorrect setting of the ApsMode parameter.


See the Oracle Demantra Installation Guide.

Object Error


A user receives the following message when trying to launch a worksheet in one of the Web products:

				error while running Worksheet Window: object error

Possible Explanations

This message can occur for several reasons:


  1. First make sure that the Web server is pointing to the correct location.

    1. On the server, open the following file:

      Demantra_root/Collaborator/virtual_directory/WEB-INF/web.xml For example: Demantra_root/Collaborator/demantra/WEB-INF/web.xml

    2. In this file, check the value of the parameter electric.http.url. This parameter should have the following format and value:

      http://server name/virtual_directory/glue

      For example: http://frodo/demantra/glue

    3. Edit the file if necessary, save the changes, and then restart the Web server.

  2. Then try to resolve a Java problem on the user's machine:

    1. Make sure that the browser option "Use Java2 v1.4.1_03 for applet" is unchecked. To access this option in the browser, click Tools > Internet Options...and click the Advanced tab.

    2. Stop the Web server, clear the user's Java cache and certificate, and restart the Web server, as described in “Cannot Connect to Server”.

    3. If this does not fix the problem, then uninstall JRE. To do so, use Add/Remove Programs and restart the machine if prompted to do so.

    4. Then see “Initial Logon to Demantra”.

  3. Clear the Tomcat cache on the server. To do so, delete the directory Demantra_root/Collaborator/Tomcat/work/standalone/localhost.

Page Cannot Be Displayed


A user accesses one of the Demantra URLs and receives the following message:

				The page cannot be displayed


The Web server is not running.


Start the Web server.

Please Handle Recovery


A user receives an email message that includes the following text:

				Please handle recovery for the following process


This error message is the default message that the Workflow Engine sends when asking a user how to recover from a failed workflow instance. (The message itself is controlled by the mail.strings.recovery parameter.)


Identify the workflow instance that failed. The Workflow Manager shows all workflows and all workflow instances.

Recovery depends on the workflow and on your environment.

Port Collision with Oracle XDB User


When the user tries to log on, he or she receives the following message:

the picture is described in the document text


In Oracle 9i, the XDB database user tries to use port 8080. If you use port 8080 for Demantra, then users will encounter the message described above.


Reconfigure the Oracle XDB user to use a different port, as follows:

  1. Open the Oracle Enterprise Manager and log in as a DBA.

  2. On the left side of the screen, expand the XML Database item and click the Configuration item.

  3. On the right side of the screen, edit the http-port field and change the value from 8080 to another four-digit number.

  4. Save the change.

  5. To verify the fix, try to access http://localhost:8080. You should get a blank page.

Possible Jar Problem

Scenario and Explanation

If Java is not using the correct jar files on a user's machine, different errors can occur, specifically:


  1. Check the dates of the jar files that Demantra is using:

    1. Start the Web server.

    2. Note the messages that the APS writes into the DOS window. Look for the line that is similar to the following example:

      Starting Service Demantra Application Server/7.0.0 (27)

    3. The number in parentheses indicates the jar version that the APS is using.

  2. Check the dates of the jar files that Java is actually using, as follows:

    1. Open the Java plug-in control panel.

    2. Click the Cache tab.

    3. Click View.

Process Is Terminated


A user receives an email message with the following subject line:

				The following process is terminated


This error message is the default message that the Workflow Engine sends when a workflow instance is terminated. (The message itself is controlled by the mail.strings.processterminated parameter.)


Ask your Demantra administrator if he or she terminated the workflow instance.

Tasks Timed Out


A user receives an email message that includes the following subject line:

				Task(s) timed out in workflow

Depending on the workflow, the text of the message includes one of the following lines:

Treatment period for this task(s) was finished and one or more of the group members haven't respond. The process moved to alternative treatment.
Treatment period for this task(s) was finished and the process moved to alternative treatment


These error message are the default message that the Workflow Engine sends when a User Step or a Group Step times out. (The messages themselves are controlled by the mail.strings.taskstimedoutsubject, mail.strings.timeout.user, and parameters.)

The workflow definition defines the timeout periods and the timeout behavior.


Identify which workflow step was timed out, and consult your Oracle implementors for details on that workflow. Depending on how the workflow was defined, the alternative treatment may be sufficient for your needs.

Treatment Period Was Finished

See “Tasks Timed Out”.

Unable to Launch Desktop from Collaborator


A user tries to launch the desktop from Collaborator Workbench, but encounters an error.


There may be a problem with the TNS configuration.


Make sure the TNS name matches the server name. To do so:

  1. Make sure you have no spaces in your path to dp.exe OR put dp.exe in your path (able to launch it from a command prompt). The menu should be set up correctly as follows:

    Program Target: dp.exe

    Type: desktop initiation

  2. Set up a TNS on your machine whose name is the same as the database server name. For example, if your database server is WYSIWYG, create a TNS named WYSIWYG. Make sure the corresponding TNS exists on the database server.

  3. Edit the ServerName parameter in the Business Modeler. This parameter is on the Application Server > App Server tab.

Unable to Log into Collaborator After Expired Session


A user has logged into Collaborator Workbench and the session has expired. Now the user cannot log in again.


The browser has not been updated correctly with the user status.


Close the browser window and open a new browser. In the new browser, the user will be able to log on again.

User Does Not Receive Email


A user fails to receive an email message, either from an automated workflow or from another user of Collaborator Workbench.


Demantra uses the email addresses configured in the Business Modeler.


In the Business Modeler, make sure that the email address is configured correctly for this user. See “Creating or Modifying a User”.

Also check with IT department to make sure that the Demantra administrative user is configured with the appropriate permissions on the mail server.

User Is Already Active


A user tries to log into one of the Web products and receives the following message:

				User is already active


Any given user can open only one session at a time. This applies whether or not the user is trying to log on from the same computer.


Either wait for the user session to time out or manually end the user session. Contact Oracle Support Services for details.

Workflow Internal Error


A user receives an email message with the following subject line:

				Workflow internal error

The text of the message itself includes the following:

				Internal error: please check database and network connections.


This error message is the default message that the Workflow Engine sends when an internal error occurs in the workflow module. (The message itself is controlled by the mail.strings.internalerror.subject and mail.strings.internalerror.message parameters.)


First try to determine if the error was caused by a database communication failure, lost network connection, or unavailability of the Web server. Correct the situation and re-execute the workflow instance.

If you cannot determine the cause of the error, gather as much information as possible and contact Oracle Support Services.

Workflow Process Has Failed


A user receives an email message with the following subject line:

				Workflow process has failed

The text of the message itself includes the following:

				Error in process execution


This error message is the default message that the Workflow Engine sends to the initiator of a workflow when it fails to execute any step in that workflow. (See “Fail-To-Execute Step”. (The message itself is controlled by the mail.strings.taskfailuresubject and mail.strings.processfailuresubject parameters.)

In such cases, the Workflow Engine also sends a selection task to the My Tasks module for the same user. This task provides options for continuing.


  1. Identify the workflow that failed and try to identify the cause of the failure.

    A failure can happen for a variety of reasons, for example, an invalid worksheet or user, a database communication error, the Web server being down, or failure of an invoked external application. Check for such error conditions.

  2. The user who initiated the workflow should log onto Collaborator Workbench, go to My Tasks, and specify how to proceed.

    Then click the Save & Refresh link at the bottom of the task list.

  3. If you cannot determine the cause, gather as much related information as possible, and contact Oracle Support Services.

Worksheet Is Empty


A user opens a worksheet, but the worksheet is empty.


The worksheet contains no data. There are multiple possible reasons:


  1. Try increasing the span of time of the worksheet.

  2. Check the user's permissions.

  3. Check the worksheet's filter and exception filter. Remember that if you launch a worksheet via the Open With menu option, the worksheet is filtered by the member from which you started. This additional filter is not visible in the worksheet designer.

Worksheet Runs Slowly


Your system has a large number of series, and worksheets take a long time to run.


The tables that store the series might benefit from being rebuilt.


Run the REBUILD_TABLES procedure, which rebuilds the sales_data and mdp_matrix tables by default. You can pass a table name as an argument to the procedure.

Zero Length Column Error


When working with a cached worksheet, the following error is encountered:

				Zero length column


For technical reasons, a worksheet cache cannot be created if any server expressions in that worksheet return null or zero-length values.


Check the server expressions for all series and modify them if any return such values. Use the expression to_number(null,0) to express null values that can be cached.

ORA-4043 Error When Running MSDDEMLD

Loader Worker fails with the following: Creating dummy log file ... Parent Program Name: MSDDEMLD This IS part of a Plan run. Username:SQL*Loader-941: Error during describe of table DMTRA_TEMPLATE.T_SRC_SALES_TMPL ORA-04043: object DMTRA_TEMPLATE.T_SRC_SALES_TMPL does not exist SQL*Loader: Release - Production on Wed Dec 12 16:03:29 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Program exited with status 1

The control file ($MSC_TOP/patch/115/import/T_SRC_SALES_TMPL.ctl) used to load Shipment and Booking Data from flat files to the Demantra schema table T_SRC_SALES_TMPL has the schema name 'DMTRA_TEMPLATE' hardcoded in it

If the demantra schema name is other than 'DMTRA_TEMPLATE' and the customer wants to use the Self Service program for loading Shipment and Booking History through flat files, then this control file should be manually updated to use the correct Demantra schema name.