1. Ensure that your current installation of Mashup Center is at the v3.0.0.1 level because this cumulative fix can only be applied to v3.0.0.1. If you are running v2.0.0.2, you must upgrade to v3.0.0.1 before applying this cumulative fix. This cumulative fix includes all the fixes from previous cumulative fixes, so it does not matter if you have already installed them.
2. Back up the mashupcenterhome directory.
3. This cumulative fix updates the Page Builder 2 theme. IBM recommends that you do not modify the Page Builder 2 theme directly because any changes that you make are overridden by cumulative fixes. If you have modified the Page Builder 2 theme, back it up before applying this cumulative fix. After installing this cumulative fix, you can reapply your customization on the upgraded theme.
   You can back up the Page Builder 2 theme by downloading the resources as a ZIP archive using a web browser with this url:

   http://localhost:9080/mum/mycontenthandler/mm/dav/filestore//public/themes/pageBuilder2?mime-type=application/zip

1. If feed policy processing is enabled for Mashup Center 3.0.0.1, take the following steps to disable it:
   1. Log on to MashupHub as an administrator.
   2. Click Settings at the top of the window.
   3. Select Security > Edit Feed Policies.
   4. Clear Enable feed policy processing.
2. Confirm that WebSphere Application Server is stopped.
   On Windows, take the following steps:

   1. To open the list of services, in the Control Panel, select Administrative Tools > Services.
   2. Open the service entry for IBM WebSphere Application Server V7.0 - node_name.
   3. If the service status is started, click Stop, and wait for the status to indicate that the server is stopped.

   On AIX and Linux, run the stopServer command: mashupcenterhome/AppServer/bin/stopServer.sh server1, where mashupcenterhome is the Mashup Center root directory, for example /opt/ibm/MashupCenter/3.0, and server1 is the name of the Mashup Center server.

3. On the Mashup Center 3.0.0.1 server, locate the MashupCenter_install_root\Config\config.properties file, and modify the following properties:
   • MashupAdmin: Change this value to the user ID that you specified when installing Mashup Center.
   • MashupPass: Change this value to the password that you specified when installing Mashup Center.
   • HubURL: The MashupHub URL, for example: https://localhost:9443/mashuphub
   • catalogFilePath: The path to the catalog_default.xml file, for example C:/IBM/Mashup Center/3.0/mm/config/catalog_default.xml. Only modify this property if the you have moved the catalog_default.xml file from its default location in the MashupCenter_install_root\mm\config directory.
4. Set up the directories for the cumulative fix files:
   • Copy the MashupCenter3001-CF3.pak file to the mashupcenterhome\fixes directory, where mashupcenterhome is the Mashup Center root directory, for example C:\Program Files\IBM\Mashup Center\3.0.
   • Copy the updatemashup.bat and updatemashup.xml files to the mashupcenterhome directory. On AIX and Linux, If the updatemashup.sh file does not have execute permission, run the following command: chmod 755 updatemashup.sh.
     Depending on your operating system, the directories are now structured like this:

     • mashupcenterhome\updatemashup.bat or
     • mashupcenterhome\updatemashup.sh
     • mashupcenterhome\updatemashup.xml
     • mashupcenterhome\fixes\MashupCenter3001-CF3.pak
5. Open a command prompt window, change to the mashupcenterhome directory, and run the updatemashup command:
   • Windows: updatemashup.bat MashupCenter3001-CF3 - WASAdminID WASAdminPassword
   • AIX and Linux: updatemashup.sh MashupCenter3001-CF3 - WASAdminID WASAdminPassword

   Where WASAdminID is the WebSphere Application Server administrator ID, and WASAdminPassword is the administrator password.

6. Start WebSphere Application Server. You can verify that the cumulative fix is installed successfully by starting Mashup Center and confirming that you can access features such as the mashup builder and catalog. You can also re-enable feed policy processing.

For more detailed instructions about installing cumulative fixes in both single server and clustered server environments, known issues, prerequisites, and migrating data, see the document called "Upgrading and migrating data to IBM Mashup Center 3.0.0.1" in the Mashup Center 3.0 Information Center. For accessible HTML translated versions of the guide, go to the 3.0.0.1 version of the product documentation in the Mashup Center wiki. Those instructions are for V3.0.0.1, but the update process is the same for this cumulative fix, except that some of the cumulative fix files have different names.

The following APAR is added with Cumulative Fix v3.0.0.1 CF3:

LO68710

PMR 46699,6Q,000 - Callback function for navStateModel.commit() call is only invoked for first portal widget instance

PMR 39790,082,000 - BSPACE: Some wires lost when exporting a space

PMR 82474,756,000 - the title value isn’t returned in the getAllNames call (only name and mode were)

PMR 27643,122,000 - Incorrect DataViewer Error

PMR 48673,499,000 - Home Space Missing

The following APARs and defect fixes are added with Mashup Center v3.0.0.1 CF2:

IC80780

PMR 46144,122,000 - Hiding the space manager utility on anonymous URLs.

LO67076

PMR 47565,122,000 - Home Space Flashes when you press F5.

LO67678

PMR 39790,082,000 - BSPACE: Some wires lost when you export a space.

LO67342

PMR 25435,122,000 The DataViewer widget preferences do not reflect the actual settings.

9722

The Publish operator sometimes displays an empty Properties tab if you delete an operator without first disconnecting it from other operators.

9600

In the web service creation page, provide the option to pass LTPA tokens during web service execution in an SSO environment.

9739

WSDL that uses import URLs that contain query strings might cause errors in a web service feed.

9741

An error might occur if you create a feed with SQL Server and use the same parameter name multiple times within the SQL query.

The following APARs and defect fixes were originally shipped with Cumulative Fix v3.0.0.1 CF1:

IC76837

An endpoint is allowed in a widget definition URL in catalog.xml.

IC77667

Mashups can now handle a LDAP or other user repository group identifiers, that is, the DN can be longer than 36 characters.

IC77693

This fix updates the Idescriptor value for the widget when the widget title is changed.

IC77896

Fixes page export when shared with groups. Fix for disappearing widgets when page is shared.

IC78102

URL Customizer fires during page load and URL Customizer fails to save setting correctly.

IC78161

Fixes Anonymous URL looping, Space and New page navigation issues and Firefox template issue (Page Navigation error).

IC78184

Feed reader should display default feed.

IC78281

Fixes to chartingWidget display and widget wiring.

LO63399

If the browser is refreshed via refresh button, F5, etc., the current page will be refreshed. Previously, if the user preference is to load the home page, then the home page would be loaded instead.

LO63647

Fixes the situation where the information found in a user repository such as an LDAP is not always cached. This results is many time expensive searches which delays user login.

LO63657

Fixes the situation of clicking a page menu link 2 levels down and the parent link is still visible.

LO63662

Data Viewer Filtering does not work well using IE7, Two problems: a. Javascript error on the page when trying to enter Filter condition, and b. In the Filter section, the column selection drop down was empty.

LO64786

Column names are lost when there is no data.

9558

An Oracle connection error occurs when using a URL in the format: jdbc:oracle:thin:@//host:port/database

9511, 9525

Microsoft NT LAN Manager (NTLM) is now supported for the Excel and Web Services plugins. See the technical support article titled "Enabling and using NTLM with Mashup Center Feeds" at http://www.ibm.com/support/docview.wss?uid=swg27023577.

9585

A password is not set for an authenticated feed with HTTP.

9622

Relational plugin: A feed created from a SQL Server query works in preview but fails when it is saved because of a new line character.

9750

The XML tree widget shows nothing when you edit the feed. The XML tree widget is now displayed correctly for the XML escape sequence.

9589

Data Mashup Builder: an empty parameter value passed into the Numeric Format function results in an error.

9580

Relational plugin: Driver version Optim Connect 5.3.2 is now supported. See the technical support article titled "Installing Optim 7.3 and 8.1 Drivers into Mashup Center" at http://www.ibm.com/support/docview.wss?uid=swg27023231.

9594

ECM plugin: A custom type takes too long to fetch.

9595

LightWeight Widgets: After you upgrade from Mashup Center 2.0.0.2 to 3.0.0.1, there is no way for you to add back the LightWeight widget to your pallette.

9624

Data Mashup Builder: A data mashup hangs when it is previewed.

9646

Credential passthrough Support for WebServices. WebServices plugin now supports Form, NTLM and client credentials for a protected service endpoint. The provided authentication data needs to be applicable to both the protected service endpoint and the WSDL URL being used.

9703

Data Mashup Builder: An empty parameter value passed into a User Defined Function (UDF) results in an error.

The following known issues are added by in Cumulative Fix v3.0.0.1 CF3:

Sandboxing

Issue: When you rename an untrusted widget, such as a sandboxed widget, the loading animation of the widget might not disappear.

Solution: Save the page and reload it in order to display the widget correctly, including its new title.

Sandboxing

Issue: When you modify a page and switch to another page, you are prompted to save the pending modifications. If you chose to save the modifications, an error might be displayed. If you switch back to the page, widgets might not be rendered correctly.

Solution: Refresh the page to have the widgets rendered properly.

The following known issues are added by in Cumulative Fix v3.0.0.1 CF2:

Website Displayer Widget

Issue: For some pages, such as http://www.google.com/ or http://www.yahoo.com/, no content is shown in the Website Displayer.

Solution: Those web sites contain Java script code that secures them from being opened in an iframe. This is a security function of the web site. Website Displayer cannot work around this.

Page Modifications

Issue: When you modify a page and move away from it, you are prompted to either save the pending modifications or cancel the action. If you choose to save the modifications, an error is displayed in the user interface. Although the modifications are saved correctly, when you return to the page, the widgets might not be rendered correctly.

Solution: Refresh the page to render the widgets correctly.

The following known issues were first identified in Cumulative Fix v3.0.0.1 CF1:

Website Displayer Widget

Issue: If you minimize the Website Displayer, some pages the JavaScript console might show errors.

Solution: Do not minimize the Website Displayer. The web site you want to display uses JavaScript code that does not run in minimized mode

Drag & Drop in Column Layouts

Issue: When you relocate a widget on a page, the target drop zone (that is, the gray area above or below widgets) might not activate when you expect.

Solution: Drag the widget to the content area of a widget near the target drop zone. This activates the drop zone area onto which you can now drop the widget.

Changing ownership / removing spaces

Issue: When an administrator deletes pages or spaces or removes ownership for certain users of pages and spaces, these users might see error reports in the user interface if they are working on the pages at the same time. These errors are caused by missing pages or spaces or missing ownership for page or spaces.

Solution: Refresh the browser page to display the changes correctly.

NTML authentication

Issue: The NTML authentication option is displayed for all plugins even though it is supported only for Excel and Webservices feeds.

Solution: Use NTML authentication only for Excel and Webservices feeds.

No documentation fixes were added by Cumulative Fix v3.0.0.1 CF3.

The following documentation fixes are added by Cumulative Fix v3.0.0.1 CF2:

• The Publish Operator "Properties" Tab comes up empty.

  The Publish operator sometimes displays an empty Properties tab if you delete an operator without first disconnecting it from other operators. Additionally, any subsequent attempt to preview operator results might cause the Data Mashup Builder tool to hang. This problem has been fixed for any new mashups that are created after you install Cumulative Fix v3.0.0.1-CF2. However, mashups created before Cumulative Fix v3.0.0.1-CF1 still have the problem.

  To fix a data mashup that was created before you installed Cumulative Fix v3.0.0.1-CF2, edit the data mashup and, before refreshing the Publish operator, disconnect all operators from the Publish, and plug them in again.

  Cumulative Fix v3.0.0.1-CF2 also prevents similar hang situations. Instead of the system hanging, the following message is displayed:

  Encountered an unexpected client-side error (Preview usage count was invalid
  when previewing operator 'operator name'.). This error may affect subsequent
  operations within the data mashup. Please report this error through proper
  support channels and provide as much information as possible about your data 
  mashup, and about the actions you took prior to seeing this error.

• An error might occur if you create a feed with SQL Server and have queries that are stored procedures.

  When you create a SQL feed with a Microsoft SQL Server database, with a stored procedure query that has parameter values and no standard markers, then you might see an error when you save the feed. For example, the following query generates an error:

  EXEC dbo.storedproc @USER='USER1', @HP=10

  You can avoid the error if you revise the query using standard markers, like this:

  EXEC dbo.storedproc @USER=?, @HP=?
         Go to next page.  Provide values for the parameters (User1, 10)

• A new label has been added to the product in English only.
  The label is:

  Parameters with same name should have same values. Correct them
  before saving the feed, otherwise only first occuring set of values will be
  saved.

  When the query is updated, the parameters are re-parsed, and you must manually update the parameters that need to be reused. When you reuse parameters, make sure that the column types are the same.
• Some feeds created from SQL Server that use specific queries show inaccurate results when previewing, but work correctly when they are run.
  For example, if you create a feed from a Microsoft SQL Server database with the following query:

  select * from dbo.fnEthernet9WIP()

  The preview shows ten records and there are misleading values in the count column, although no errors are generated. However, when you execute the same feed, it displays correct results. This problem only occurs with SQL Server.
• WSDL that uses import URLs that contain query strings might cause errors in a web service feed.
  The web service feed creation process displays an error when the Web Services Description Language (WSDL) that it is using (through the URL option) has import URLs that contain query strings, such as this:

  http://.../imported.wsdl?version=2.0

The following documentation fixes were included in Cumulative Fix v3.0.0.1-CF1:

• In Internet Explorer, some artifacts in the MashupHub user interface fail to load correctly because of an Internet Explorer security setting.
  The problem occurs in Windows Enterprise 2003 and Windows Enterprise 2008. It is caused by the Internet Explorer Enhanced Security Configuration setting. To work around the problem, the Windows administrator must take the following steps:

  1. Open the Windows Control Panel.
  2. Select Add or Remove Programs and then select Add/Remove Windows Components.
  3. From the Windows Components Wizard, remove the check mark next to Internet Explorer Enhanced Security Configuration. Click Next and then Finish.
  4. Restart Internet Explorer.
• Form authentication is available for REST services feeds
  The online help for creating a REST services feed does not specify how to implement form authentication. You can find the information under "Form" in this document:

  http://publib.boulder.ibm.com/infocenter/mashhelp/v3/topic/com.ibm.muh.useradmin.doc/userhelp/resthelp/help_rest_editor.htm

• Some browsers have problems when loading source operators
  The following levels of Internet Explorer browser show errors when you load source operators. To work around the problem, try a different browser.

  • Internet Explorer 8: 8.0.6001.18702, update versions: 0
  • Internet Explorer 7: 7.0.5730.13, update versions: 0

For documentation for Mashup Center, see the following websites.

Mashup Center wiki: The Mashup Center wiki contains articles on installing, upgrading, administering, deploying, and using IBM Mashup Center. You can also create new articles or add comments to the documentation.

Mashup Center information center: The Mashup Center information center contains the original edition of the documentation that was completed when the product released. This edition is accessible by screen readers and is available in multiple languages. You can access the Mashup Center release notes from the Mashup Center information center.

© Copyright International Business Machines Corporation 2012. All rights reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.