Hi,

i installed saiku-adhoc-plugin-1.0-RC1 from 'http://ci.analytical-labs.com/job/saiku-adhoc-plugin/lastSuccessfulBuild/artifact/saiku-adhoc-plugin/target/' and when i run on bi-server 3.10 i receive the message: 'ReportGenerator.ERROR_0001 - The CDA Datafactory could not process the query'.

Looking at the catalina log show me the errors: 07:21:13,216 ERROR [SolutionRepositoryBase] SolutionRepository.ERROR_0023 - Invalid publish location: Root Folder 07:21:13,226 ERROR [ReportGeneratorService] org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to send request 07:21:13,226 ERROR [QueryResource] Cannot generate report (67D1E0AA-545C-F797-B3B6-51C0D118E00B) org.saiku.adhoc.exceptions.SaikuAdhocException: ReportGenerator.ERROR_0001 - The CDA Datafactory could not process the query

any help ?

Thanks.

asked 13 Mar '12, 09:27

jagnaldo's gravatar image

jagnaldo
1334
accept rate: 0%


I'm having the same error, running on bi-server 3.7, Saiku analytical tools are working, but ad hoc reporting isn't.

I have a feeling this is related to the properties file ../saiku-adhoc/saiku-adhoc.properties, related to the metadata.xmi file.

link

answered 19 Apr '12, 04:09

Cyril's gravatar image

Cyril
1111
accept rate: 0%

did you install the ctools (cda etc) as well? using the ctools installer: https://github.com/pmalves/ctools-installer

link

answered 19 Apr '12, 07:04

pstoellberger's gravatar image

pstoellberger ♦♦
2.5k211
accept rate: 8%

Cyril: do you get exactly that error: SolutionRepository.ERROR_0023 - Invalid publish location: Root Folder ?

Or just: ReportGenerator.ERROR_0001 - The CDA Datafactory could not process the query ?

We do not test saiku-reporting with anything < 3.10GA so I am not sure if it is possible to get it working in 3.7

link

answered 19 Apr '12, 08:39

mgiepz's gravatar image

mgiepz
9613
accept rate: 15%

That error was my fault, I was selecting a wrong model based on a newly created datasource, I just removed it from my temp/cda folder so that it won't come out on the Models dropdown. I have a different problem now, the Row Limit drop down doesn't work for me, it only shows data when it is set to NONE, but when I select 10 or 100 or 1000, I get the error Caused by: java.lang.NoSuchMethodError: org.pentaho.metadata.query.model.Query.setLimit(I)V at org.saiku.adhoc.model.builder.CdaBuilder.build(CdaBuilder.java:160), that's no typo, there is a V after setLimit(I)

(23 Apr '12, 05:26) Cyril

Cyril. You are using the old metadata API in 3.8 right? that wont work i am afraid. please switch to biserver 3.10

link

answered 23 Apr '12, 09:03

mgiepz's gravatar image

mgiepz
9613
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×75
×14

Asked: 13 Mar '12, 09:27

Seen: 1,920 times

Last updated: 23 Apr '12, 09:03

powered by OSQA