Problems Accessing Component Integration Services

SAP ASE issues an error message if you issue a command that accesses a remote object and Component Integration Services is not found.

• SAP ASE issues this message:

   cis extension not enabled or installed

  Verify that the enable cis configuration parameter is set to 1 by running:

  sp_configure "enable cis"

• sp_configure returns the following row for the enable cis parameter:

  name         min  max   config value   run value
  enable cis     0    1              1           1

  Both “config value” and “run value” should be 1. If both values are 0, set the enable cis configuration parameter to 1, and restart the server. Use the syntax:

  sp_configure "enable cis" 1

  If “config value” is 1 and “run value” is 0, the enable cis configuration parameter is set, but does not take effect until the server is restarted.

  Note: Component Integration Services is enabled by default beginning with SAP ASE version 12.0.