Pentaho: org.pentaho.pms.core.exception.PentahoMetadataException: QueryXmlHelper.ERROR_0009 - Domain Instance returned null

The following exceptions are caused by that the meta data domain used in the Meta Data Editor and the meta data domain used in the Pentaho User Console are different.

Caused by: org.pentaho.reporting.engine.classic.core.ReportProcessingException: InteractiveAdhocReportUtils.ERROR_0002 - Unable to load report query.
at com.pentaho.iadhoc.service.b.b.a(SourceFile:113)
at com.pentaho.iadhoc.service.b.b.a(SourceFile:80)
at com.pentaho.iadhoc.service.b.k.a(SourceFile:501)
at com.pentaho.iadhoc.service.b.k.a(SourceFile:117)
at com.pentaho.iadhoc.service.InteractiveAdhocService.getThinSpec(SourceFile:157)
at com.pentaho.iadhoc.service.InteractiveAdhocService.getReportSpecificationJson(SourceFile:99)
... 88 more
Caused by: org.pentaho.pms.core.exception.PentahoMetadataException: QueryXmlHelper.ERROR_0009 - Domain Instance <Domain Name> returned null
at org.pentaho.metadata.query.model.util.QueryXmlHelper.fromXML(QueryXmlHelper.java:349)
at org.pentaho.metadata.query.model.util.QueryXmlHelper.fromXML(QueryXmlHelper.java:339)
at com.pentaho.iadhoc.service.h.a(SourceFile:64)
at com.pentaho.iadhoc.service.b.b.a(SourceFile:110)

To fix this problem: 

1. From your Pentaho Metadata Editor, click File in the top menu bar and choose Publish to Server.

2. In the pop up window, make sure that the Domain Name matches the domain name in the exception. Click OK.

Or do the following.

1. From your Pentaho Metadata Editor, click File in the top menu bar and choose Publish to Server.

2. Look for the Domain Name in the pop up window,.

3. Go to Pentaho User Console, click the Create New button, and choose Data Source

4. In the pop up window, make sure to use  the Domain Name you saw in step 2 as the Data Source Name. Continue and finish creating the data source.

5. Create your reports using the new data source.

------------------------------------------------------------------------------------------------------------------------

                        
If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book free here.