When you use SAS Customer Intelligence Studio, validation of a business context fails when you use the BULKLOAD=YES and the PARALLEL=TRUE options in the Append to table options text box, as shown in the following example:

The validation of the business context fails because the temporary table that is used to validate the arguments has an index. For additional information, see SAS Note 18184, "SQL*Loader-951 received bulkloading to Oracle table with an index using PARALLEL=TRUE."

To obtain a workaround for this problem, contact SAS Technical Support.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Note: After you apply the hot fix, the following new Java argument is introduced:

This new argument gives you the option to append to tables that have indexes.

• In Microsoft Windows operating environments, the wrapper.conf file is available in the SAS-configuration-directory\Lev1\Web\WebAppServer\SASServer6_1\conf directory. In wrapper.conf, add the arguments as shown below:
  wrapper.java.additional.XX=-Dsas.ci.add.append.options=”bl_options=’parallel=true’”

  Note: In the wrapper.java.additional.XX property, XX specifies the next number in the sequence that already exists in the file. Modify XX to be the next number in that sequence.

• In Linux and other UNIX operating environments, the setenv.sh file is located in the SAS-configuration-directory/Lev1/Web/WebAppServer/SASServer6_1/bin directory. Add the argument to the JAVA_OPTS= property, as shown below:
  JAVA_OPTS="$JAVA_OPTS =-Dsas.ci.add.append.options=”bl_options=’parallel=true’”

  After you add the argument to the appropriate file for your operating system, restart the middle tier in order for the settings to take effect.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.5 is available at:

A fix for this issue for SAS Marketing Automation 6.4 is available at: