Technote

(troubleshooting)
Unable to create more than 11 workspaces at one time.
Problem(Abstract)
While creating a staging instance you have the option to enable workspaces and specify the number of workspaces you need for this instance. Depending on your business case, this number may need to be great than 11. However, even if you specify a number greater than 11, only 11 workspaces are created.
Cause Never attempt to specify the number of workspaces larger then the counter value in the keys table. The default value is 10. Resolving the problem The fix (APAR IY99570) is included in Fix Pack 6.0.0.3 or newer. You can obtain Fix Pack 6.0.0.3 or newer from the Fixes by version page.

You can also work around the problem with the following solutions:

Workaround (1):
The ANT task below can be run many times. If create 15 workspaces and the counter value is 10, run the tool twice, the first time specifying 10 and the next time specifying five. This creates 15 workspaces.

  1. Start (or restart) the WebSphere Commerce Server (the server must be running) and run the following example (all on one line) :
    config_ant.bat -buildfile <WC_InstallDir>\components\Workspaces\xml\configureWorkspaces.xml -DinstanceName=instancename -DdbaPassword=password -DcmNumWorkspaces=xxx CreateWorkspace

    where DcmNumWorkspaces specifies the number of additional workspaces you would like created, which in this example would be 10 and the next time would be five.


Workaround (2):

As another workaround, if for example, you need 20 workspaces in total you can do the following:

  1. Create an instance with five workspaces during instance creation.

  2. After the instance is successfully created, increase the COUNTER (add 100 to it) and the PREFETCHSIZE to 30 by doing an UPDATE to the KEYS table for the cmwsschema tablename.

  3. Start (or restart) the WebSphere Commerce Server (the server must be running) and run the following example (all on one line) :

    config_ant.bat -buildfile <WC_InstallDir>\components\Workspaces\xml\configureWorkspaces.xml -DinstanceName=instancename -DdbaPassword=password -DcmNumWorkspaces=xxx CreateWorkspace

    where DcmNumWorkspaces specifies the number of additional workspaces you would like created, which in this example is 15.

 

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21294252