org.pentaho.pms.core.exception.PentahoMetadataException: org.xml.sax.SAXParseException; Premature end of file.

Pentaho BI Platform Tracking | Roland Bouman | 3 years ago
  1. 0

    Repo path: 0) edit pentaho-solutions/steel-wheels/metadata.xmi and make it invalid (f.e. change encoding to UTF-88) 1) open File > Manage datasources 2) In the datasource admin dialog, do New > Metadata 3) In the import dialog, choose pentaho-solutions/steel-wheels/metadata.xmi, set domain to steel-wheels and import. 4) This fails as as expected (BISERVER-9104) 5) Correct the error in pentaho-solutions/steel-wheels/metadata.xmi (or import a another, valid xmi file) 6) Try to import again. This fails again. The log shows: [Fatal Error] :-1:-1: Premature end of file. 14:54:56,902 ERROR [PentahoMetadataDomainRepository] org.xml.sax.SAXParseException; Premature end of file. 14:54:56,908 ERROR [MetadataDatasourceService] Error import metadata: org.pentaho.pms.core.exception.PentahoMetadataException: org.xml.sax.SAXParseException; Premature end of file. at org.pentaho.metadata.util.XmiParser.parseXmi(XmiParser.java:932) at org.pentaho.platform.plugin.services.metadata.PentahoMetadataDomainRepository.storeDomain(PentahoMetadataDomainRepository.java:228) at org.pentaho.platform.plugin.services.importer.MetadataImportHandler.processMetadataFile(MetadataImportHandler.java:75) at org.pentaho.platform.plugin.services.importer.MetadataImportHandler.importFile(MetadataImportHandler.java:50) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:70) Re-attempting the sequence after closing the datasource admin dialog doesn't fix the problem. But after refresh of the entire page, it works again (indicating the file is valid).

    Pentaho BI Platform Tracking | 3 years ago | Roland Bouman
    org.pentaho.pms.core.exception.PentahoMetadataException: org.xml.sax.SAXParseException; Premature end of file.
  2. 0

    Repo path: 0) edit pentaho-solutions/steel-wheels/metadata.xmi and make it invalid (f.e. change encoding to UTF-88) 1) open File > Manage datasources 2) In the datasource admin dialog, do New > Metadata 3) In the import dialog, choose pentaho-solutions/steel-wheels/metadata.xmi, set domain to steel-wheels and import. 4) This fails as as expected (BISERVER-9104) 5) Correct the error in pentaho-solutions/steel-wheels/metadata.xmi (or import a another, valid xmi file) 6) Try to import again. This fails again. The log shows: [Fatal Error] :-1:-1: Premature end of file. 14:54:56,902 ERROR [PentahoMetadataDomainRepository] org.xml.sax.SAXParseException; Premature end of file. 14:54:56,908 ERROR [MetadataDatasourceService] Error import metadata: org.pentaho.pms.core.exception.PentahoMetadataException: org.xml.sax.SAXParseException; Premature end of file. at org.pentaho.metadata.util.XmiParser.parseXmi(XmiParser.java:932) at org.pentaho.platform.plugin.services.metadata.PentahoMetadataDomainRepository.storeDomain(PentahoMetadataDomainRepository.java:228) at org.pentaho.platform.plugin.services.importer.MetadataImportHandler.processMetadataFile(MetadataImportHandler.java:75) at org.pentaho.platform.plugin.services.importer.MetadataImportHandler.importFile(MetadataImportHandler.java:50) at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:70) Re-attempting the sequence after closing the datasource admin dialog doesn't fix the problem. But after refresh of the entire page, it works again (indicating the file is valid).

    Pentaho BI Platform Tracking | 3 years ago | Roland Bouman
    org.pentaho.pms.core.exception.PentahoMetadataException: org.xml.sax.SAXParseException; Premature end of file.
  3. 0

    Repro: Create/Save a new report in the RDW inside of PDI Publish it to the BI Server Login to BI Server and try to view the report - fails Error in server console: ParentException: org.pentaho.pms.core.exception.PentahoMetadataException: QueryXmlHelper.ERROR_0009 - Domain Instance steel-wheels/reports/resources/metadata\jake.xmi returned null at org.pentaho.metadata.query.model.util.QueryXmlHelper.fromXML(QueryXmlHelper.java:298) at org.pentaho.metadata.query.model.util.QueryXmlHelper.fromXML(QueryXmlHelper.java:288) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.parseQuery(PmdDataFactory.java:241) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:482) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:460) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1351) at org.pentaho.reporting.platform.plugin.output.PageableHTMLOutput.generate(PageableHTMLOutput.java:97) at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1126) at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createReportContent(ReportContentGenerator.java:203) at org.pentaho.reporting.platform.plugin.ReportContentGenerator.createContent(ReportContentGenerator.java:114) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66) at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:256) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) 16:10:40,734 ERROR [o] Ticket Number: 1272658240734 16:10:40,750 ERROR [o] Exception in AJAX handler. com.pentaho.analyzer.service.h: Unable to find catalog: SALES_DATA Model at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:74) at com.pentaho.analyzer.service.impl.c.getConnection(SourceFile:33) at com.pentaho.analyzer.service.impl.OlapMetaDataManager.getConnection(SourceFile:43) at com.pentaho.analyzer.content.a.f.clearCache(SourceFile:334) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:162) at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220) at $Proxy24.createContent(Unknown Source) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:256) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

    Pentaho BI Platform Tracking | 7 years ago | Jake Cornelius
    org.pentaho.pms.core.exception.PentahoMetadataException: QueryXmlHelper.ERROR_0009 - Domain Instance steel-wheels/reports/resources/metadata\jake.xmi returned null
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Created a parameterized query adding a parameter called 'ProductLine' and a default value of 'Classic Cars' Hit preview, stack trace in console: Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS at org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:468) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:464) at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274) at org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104) at org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorS erviceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632) at org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuer y(SwtMqlEditor.java:145) at org.pentaho.pms.ui.QueryBuilderDialog.viewSql(QueryBuilderDialog.java :467) at org.pentaho.pms.ui.QueryBuilderDialog$6.widgetSelected(QueryBuilderDi alog.java:197) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732) at org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577) org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS at org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:468) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:464) at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274) at org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104) at org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorS erviceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632) at org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuer y(SwtMqlEditor.java:145) at org.pentaho.pms.ui.QueryBuilderDialog.viewMql(QueryBuilderDialog.java :454) at org.pentaho.pms.ui.QueryBuilderDialog.access$400(QueryBuilderDialog.j ava:51) at org.pentaho.pms.ui.QueryBuilderDialog$5.widgetSelected(QueryBuilderDi alog.java:187) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732) at org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577)

    Pentaho BI Platform Tracking | 7 years ago | Jake Cornelius
    org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS
  6. 0

    This is due to the definition of row level security in the steel-wheels metadata model. Here is the stack trace: 11:39:50,015 ERROR [SqlOpenFormula] an exception occurred org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Extra content at org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse(FormulaParser.java:64) at org.pentaho.reporting.libraries.formula.Formula.<init>(Formula.java:57) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:227) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201) 11:39:50,031 ERROR [MetadataQueryComponent] error org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE(); at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:235) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201)

    Pentaho BI Platform Tracking | 7 years ago | Will Gorman
    org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE();

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.pms.core.exception.PentahoMetadataException

      org.xml.sax.SAXParseException; Premature end of file.

      at org.pentaho.metadata.util.XmiParser.parseXmi()
    2. org.pentaho.metadata
      XmiParser.parseXmi
      1. org.pentaho.metadata.util.XmiParser.parseXmi(XmiParser.java:932)
      1 frame
    3. org.pentaho.platform
      PentahoPlatformImporter.importFile
      1. org.pentaho.platform.plugin.services.metadata.PentahoMetadataDomainRepository.storeDomain(PentahoMetadataDomainRepository.java:228)
      2. org.pentaho.platform.plugin.services.importer.MetadataImportHandler.processMetadataFile(MetadataImportHandler.java:75)
      3. org.pentaho.platform.plugin.services.importer.MetadataImportHandler.importFile(MetadataImportHandler.java:50)
      4. org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:70)
      4 frames