Home > The Specified > The Specified Query Is Not Executable Here

The Specified Query Is Not Executable Here

GeoTools & Shapefile: How to rename column (attribute) name Generalization of winding number to higher dimensions Is the use of username/password in a mobile app needed? Also found this error "Could not parse the element meta-data description file". The transformation creates a 64 byte file with no data. Show Jens Bleuel added a comment - 10/Oct/12 2:59 PM Andy, please use PDI 4.2 or later and NOT the old plug-in download. http://juicecoms.com/the-specified/the-specified-task-executable-location-csc-exe-is-invalid.html

It was also verified that it works in standard 4.4 and 5.0 builds. Reload to refresh your session. I have an input paramater that is a dropdown list and gets its values from a query called Vertical-List. here is the query that generates the drop down SELECT `verticals`.`vertical_id`, `verticals`.`vertical_name` FROM `verticals` pentaho share|improve this question edited May 11 '12 at 18:11 asked May 11 '12 at 1:43 Shahin check my site

Alignment of single- and multi-line column headers in tabular (LaTeX) more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile Same results, an empty pdf file. We verified that the reporting libraries are up to date in these releases. Does Kettle 4.3 not have the most up to date version of the plugin?

  • Digital Hardness of Integers A few rebus puzzles undo a gzip recursively Keeping windshield ice-free without heater Output N in base -10 Print all ASCII alphanumeric characters without using them Ultimate
  • It was also verified that it works in standard 4.4 and 5.0 builds.
  • The transformation runs without any errors.
  • share|improve this answer answered Jun 18 '13 at 14:02 user65439 3,02063168 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign
  • OptionsSort By NameSort By DateAscendingDescendingDownload AllAttachments Hide AMS_ClaimsByMonthDept.prpt 05/Oct/12 1:38 PM 6 kB Andy Sutton mimetype 0.0 kB META-INF/manifest.xml 1 kB meta.xml 1 kB content.xml 0.3 kB datadefinition.xml 3 kB dataschema.xml
  • You can upgrade easily by removing all old reporting libraries from the kettle-lib directory and by replacing them with the newer counterparts (which you can get easily from any PRD installation).
  • Thank you in any case for your help, it got me thinking in the right direction. +1 –user65439 Jun 18 '13 at 14:01 | show 1 more comment 1 Answer 1
  • Try JIRA - bug tracking software for your team.
  • You can upgrade easily by removing all old reporting libraries from the kettle-lib directory and by replacing them with the newer counterparts (which you can get easily from any PRD installation).

I deleted the plugin and tried running the transformation in Spoon. Please help a brother out. GeoTools & Shapefile: How to rename column (attribute) name What time does "by the time" mean? How did Adebisi make his hat hanging on his head?

Terms Privacy Security Status Help You can't perform that action at this time. The report runs just fine in the user console, as well as PRD. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed the BI Server –Shahin Khani May 11 '12 at 3:38 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted Double check your datasource and query,

All rights reserved. Added the driver and it worked like a charm. Show Andy Sutton added a comment - 10/Oct/12 10:17 AM Just so I'm 100% clear, you're saying to copy the report-designer\lib folder to the kettle\plugins\PentahoReporting\lib folder? You deserve the // exception in that case ..

I have an input paramater that is a dropdown list and gets its values ... https://github.com/pentaho/pentaho-reporting/blob/master/engine/core/source/org/pentaho/reporting/engine/classic/core/cache/CachingDataFactory.java do i need to restart anything? –Shahin Khani May 11 '12 at 4:04 Have you defined the datasource in your BI server? –Cyril Pangilinan May 11 '12 at 4:07 I ran it in Pan and I got an error that said a jdbc driver couldn't be found. What early computers had excellent BASIC (or other language) at bootup?

DASFAA '97 focused on advanced database technologies and their applications. Enter a topic, @name, or fullname Settings Help Back to top · Turn images off Minha contaPesquisaMapsYouTubePlayNotíciasGmailDriveAgendaGoogle+TradutorFotosMaisShoppingDocumentosLivrosBloggerContatosHangoutsOutros produtos do GoogleFazer loginCampos ocultosLivrosbooks.google.com.br - This volume contains the proceedings of the The Reporting Output Plugin that I'm using is from this link: http://forums.pentaho.com/showthread.php?79085 Looking at the source code logs ( http://source.pentaho.org/viewvc/svnkettleroot/plugins/ReportingPlugin/trunk/?view=log ) it doesn't look like the plugin has been updated to it was actually i typo of me typing it here.

CachingDataFactory.logger.debug( "Query returned a data-set for query '" + query + '\'' ); return dataFromQuery; } } finally { final long queryTime = System.currentTimeMillis(); if ( profileDataSources && CachingDataFactory.logger.isDebugEnabled() ) { The 55 papers in this volume cover a wide range of areas in the field of database systems and applications – including the rapidly emerging areas of the Internet, multimedia, and key.makeReadOnly(); } } else { logger.debug( "No Referenced fields, caching is disabled for query '" + query + "'." ); key = null; } return key; } catch ( final MetaDataLookupException Opening or * Closing one data factory must not affect the other factories. * * @return nothing, the method dies instead. * @throws UnsupportedOperationException * as this class is not derivable.

Hide Permalink Andy Sutton added a comment - 10/Oct/12 7:56 AM Sorry, I should have added that info. People Assignee: Andy Sutton Reporter: Andy Sutton Votes: 0 Vote for this issue Watchers: 2 Start watching this issue Dates Created: 05/Oct/12 1:36 PM Updated: 28/Feb/13 9:08 AM Resolved: 28/Feb/13 9:08 You signed in with another tab or window.

Show Jens Bleuel added a comment - 28/Feb/13 9:08 AM Closing as Not a Bug.

However, when I publish the report to the Online interface and try to access it, I get a message that says "The Specified query 'Vertical-List' is not executable here". Old versions of the reporting engine cannot execute reports created by future versions of the report designer. Hide Permalink Andy Sutton added a comment - 10/Oct/12 4:17 PM Hi Jens, I'm using PDI 4.3. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

Does Kettle 4.3 not have the most up to date version of the plugin? Now the drop down works on my machine. Privacy| Legal Notices| Contact Us| Site Map DashboardsProjectsIssuesAgile Help Online Help JIRA Agile Help Agile Poker Help Agile Answers Keyboard Shortcuts About JIRA JIRA Credits What’s New Log In Export The compatibility level of the report is 3.9.

Basically, check your pentaho BI server version (check about Menu), mine was Pentaho 4.1.0 stable (which is technically speaking BI server 3.10) But Pentaho report designer 3.9 cannot publish on this Pesquisar em todas as ediçõesVisualizar esta revista » Navegar por todas as edições198019902000 16 jan. 199030 jan. 199013 fev. 199027 fev. 199013 mar. 199027 mar. 199010 abr. 199024 abr. 199015 maio If you have parameters, remember that a parameter is read in the Pentaho Report Designer as ${parameter_name}. The Reporting Output Plugin that I'm using is from this link: http://forums.pentaho.com/showthread.php?79085 Looking at the source code logs (http://source.pentaho.org/viewvc/svnkettleroot/plugins/ReportingPlugin/trunk/?view=log) it doesn't look like the plugin has been updated to use the

Output N in base -10 A few rebus puzzles Preserving Vertices Rent clothing in Frankfurt / Being warm without cold weather clothing Does every data type just boil down to nodes Same results, an empty pdf file. You may have to register before you can post: click the register link above to proceed. Is there a reason why similar or the same musical instruments would develop?

How can "USB stick" online identification possibly work? I can see the value passed when I $SubLocationId as a field in the report. –user65439 Jun 17 '13 at 11:46 The query is populating a line chart and If your engine inside kettle is NOT 3.9, then you cannot execute the report in that environment. The 55 papers in this volume cover a wide range of areas in the field of database...https://books.google.com.br/books/about/Database_Systems_for_Advanced_Applicatio.html?hl=pt-BR&id=Qw7tCgAAQBAJ&utm_source=gb-gplus-shareDatabase Systems for Advanced Applications '97Minha bibliotecaAjudaPesquisa de livros avançadaComprar e-Livro - TRY240,79Obter este livro

Products Pentaho BI Suite - Pentaho Reporting - Pentaho Analysis - Pentaho Dashboards - Pentaho Data Integration (ETL) - Pentaho Data Mining On-Demand BI Subscription Demos / Recordings, White Papers Test more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Show Thomas Morgner added a comment - 10/Oct/12 4:06 AM Chances are high that your Kettle has a old reporting engine installed. It looks like my source of confusion here is the difference in logging between Spoon and Pan.

Join them; it only takes a minute: Sign up Specified query not executable here - pentaho reporting up vote 2 down vote favorite So I've designed a report in Pentaho Report is not of expected type interface .... The time now is 12:15 PM. I deleted the plugin and tried running the transformation in Spoon.

the report runs fine on desktop but when its published i get the error. asked 3 years ago viewed 858 times active 3 years ago Related 1Can I use a user defined database function in a query in Pentaho Report Designer?1Generate Column Total In Main