Unspecified error invoking method or accessing property "onChangeDocID" " when refreshing a new WebI report after choosing query elements

Environment

• SAP BusinessObjects Business Intelligence 4.1

Symptom

• A new Web Intelligence (WebI) report is created in BI Launchpad, using the Web Intelligence application or BI launchapad (in 4.1)
• When the report is refreshed for the first time after selecting the data source and choosing the fields for the query, an error occurs:

• When the Details button is clicked, the following stack trace is displayed:

com.sap.webi.client.toolkit.exception.WIException: Unspecified error invoking method or accessing property "onChangeDocID"
 at
com.sap.webi.client.toolkit.exception.WIExceptionFactory.create(WIExceptionFactory.java:18)
 at com.sap.webi.ui.jrp.JRPUtil.callJSOnEDT(JRPUtil.java:183)
 at com.sap.webi.ui.jrp.JRPUtil.callJS(JRPUtil.java:154)
 at com.sap.webi.ui.jrp.JRPUtil.onChangeDocID(JRPUtil.java:54)
 at
com.sap.webi.ui.context.managers.DocumentManager.openDoc(Document Manager.java:165)
 at
com.sap.webi.ui.tasks.workflows.NewDocumentWorkflow.openDocument(NewDocumentWorkflow.java:399)
 at
com.sap.webi.ui.tasks.workflows.NewDocumentWorkflow.getNextTask(NewDocumentWorkflow.java:378)
 at
com.sap.webi.ui.tasks.workflo ws.DocumentWorkflow.getNextTask(DocumentWorkflow.java:163)
 at
com.sap.webi.toolkit.ui.tasks.TaskWorkflow.startNextTask(TaskWorkflow.java:63
 at
com.sap.webi.toolkit.ui.tasks.TaskWorkflow.propertyChange(TaskWorkflow.java:90)
 at java.beans.PropertyChangeSupport.fire(Unknown Source)
 at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
 at
com.sap.webi.toolkit.ui.tasks.WebITask.firePropertyChange(WebITask.java:66)
 at
com.sap.webi.toolkit.ui.tasks.WebITaskManager$TaskPCL.propertyChange(WebITaskManager.java:275)
 at  java.beans.PropertyChangeSupport.fire(Unknown Source)
 at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
 at
javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport.firePropertyChange(Unknown Source)
 at
javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport$1.run(Unknown Source)
 at
javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source) at sun.swing.AccumulativeRunnable.run(Unknown Source)
 at
javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
 at javax.swing.Timer.fireActionPerformed(Unknown Source)
 at javax.swing.Timer$DoPostEvent.run(Unknown Source)
 at java.awt.event.InvocationEvent.dispatch(Unknown Source)
 at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
 at java.awt.EventQueue.access$200(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at
java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: netscape.javascript.JSException: Unspecified error invoking method or accessing property "onChangeDocID"
 at
sun.plugin2.main.client.MessagePassingJSObject.newJSException(Unknown Source)
 at
sun.plugin2.main.client .MessagePassingJSObject.waitForReply(Unknown Source)
 at sun.plugin2.main.client.MessagePassingJSObject.call(Unknown Source)
 at com.sap.webi.ui.jrp.JRPUtil.callJSOnEDT(JRPUtil.java:178)
 ... 35 more

Fix

Issue got fixed after uninstalling the Java 7 update 45 from user machine and installing 6_25 or little bit higher. (like Java 7_0_51 or current JAVA version) Make sure you have 32 bit Java  for 32 IE

This is also reported as bug

Differences between BO 3.1 and BI 4.1

What’s New in BI 4.1

In the latest BI 4.1,  many changes have been made to the existing tools and few new tools have been introduced.

• Common query interface across all reporting tools built in the Information Design Tool.
• Many new features here including multiple data connection. (Even though some limitations there while connecting Multi data connections)
• Data Federation included.
• New abstraction layer for multi-dimensional data sources.
• Native multi-source support.
• Crystal Reports Enterprise – online report development based on universes built /converted in Information Design Tool.
• Alert information through SAP Solution Manager support
• CMC monitoring of servers and thresholds related to their performance.
• New Search Engine.
• Promotion management Tool (Which we use to call Life Cycle Management which is already existing in 3.1 and also until BI 4.0 intial release ) installed by default.  Promotion management tool is like IMPORT wizard in 3.1

SAP Business Objects Enterprise 3.1 is changed to SAP Business Objects Business Intelligence platform 4.0 and later to 4.1.

SAP Business Objects Enterprise XI4.0/4.1,  is the Business Intelligence platform that supports the entire range of Performance Management, Reporting, Querying, and Analysis Applications. It has proven architecture and platform support for Semantic Layers, Data Integration, and Security. SAP Business Objects Enterprise XI4.0 provides full web-based administration and configuration of the entire system.

Software Development Kit (SDK)

The software development kit included in the new version has many new features, such as support for security, support for alerting, support for role based authentication.

Architecture

•  64-bit Architecture.
• Native support for 64-bit Operating System for BI 4.0 server side components.
• Allows handling large reports: no more 2 GB memory limitation.
• 64-bit database middle-ware support.
• Java Application server utilizing 64-bit JDK’s (Java Development Kit).
• Desktop products and client tools support Windows 32-bit and 64-bit OS platforms.

Changes

New version of BI 4.0 which are shown in the comparison table below.

	BO 3.1 Naming	BI 4.0 Naming
1.	Business Objects Enterprise	Business Objects Business Intelligence Platform
2.	Infoview	BI Launch Pad
3.	Business Objects Xcelsius Platform	SAP Business Objects Dashboard Design
4.	Universe Designer	Information Design Tools and Universe Design Tool
5.	Crystal Reports 2008	Crystal Reports for Enterprise, Crystal Reports 2011
6.	Business Objects Voyager	Business Objects Analysis, Edition for OLAP
7.	Dashboard Builder	BI Workspaces
8.	Web Intelligence	SAP Business Objects Interactive Analysis
9.	Translation Manager	Translation Management Tool

10	No change in Web Intelligence Rich client

Above screen shot gives the different Tools names from 4.1 and 3.1

Also decommissioned (no more in new BI 4.1)

1. Performance Manager
2. Desktop Intelligence
3. Import Wizard

Building a dashboard, and connecting it to a database using Query as a Web Service

If you’re building a dashboard, and connecting it to a database using Query as a Web Service

Query as a Web Service: 

QaaWS is a Business Objects client tool that creates a web service, based on a query, that connects directly to a universe

QaaWS

With QaaWS, you first create a query using the familiar query panel. QaaWS will convert this into a web services and provide you with a WSDL. This is a URL that points to the definition of the query, which is stored in the Business Objects repository.

1. From the Windows start menu, locate Query As A Web Service.
2. Log onto the repository. If you’re not sure how, check the help for details. The QaaWS guide that you’ll find at help.sap.com doesn’t actually explain how to create a query. That can be found in Building Queries with SAP BusinessObjects Web Intelligence Query - HTML
3. Go through the steps of the wizard to create the query. First I’ll create Revenue by Category which is simply one dimension and one measure.
    
4. Next up is Top 10 Cities by Revenue, again, fairly simple since there is a Rank function built in to QaaWS.
   
5. Lastly, we will create the query that returns the top 20 products based on sales for the last three months, and for each shows the average revenue per sale per month, over the last 12 months.

Consuming the Data in Xcelsius

Query as a Web Service

With your web service defined and stored in the repository, now you only need to create a connection to that web service and define what cells the output belongs in.

1. Open Xcelsius.
2. Click Data > Connections.
3. Click Add > Query as a Web Service.
4. Paste the WSDL into the WSDL URL field and click import.
   
   
   This URL can be found in the QaaWS interface when you have your web service selected.
   
5. Now bind the output of the connection to the cells in your spreadsheet.

C:\Users\\Analysis-workspace\.metadata\ An error has occured

While opening design studio release 1.3 or vesrion 13.0.3 getting error

An error has occured. See the log file

C:\Users\<USERNAME>\Analysis-workspace\.metadata\

Fix: 3 ways to fix

1.  Delete the .metadata file from the above path. It will get recreated when you retries to open the DesignStudio
or
2. 
1. Change the folder settings in Windows, that you can see all system files.
2. Go to: C:\Users\<USERNAME>\Analysis-workspace\.metadata\.plugins\org.eclipse.core.runtime\.settings
3. Open the File com.sap.ip.bi.zen.ui with notepad
4. Search for "Startup.mode"
5. Logon to BOE has the value 1. Switch it to 0 and save it.
6. Start SAP Design Studio again.
This fixes your issue

or 3

Run the installation file with repair mode