Unable to used CDA data source in Pentaho CDE Dashboard.
Sumit Bansal
I am trying to using cda data source in my pentaho cde dashboard.But getting always error processing I am unable to understand where I am doing so it will be great helpful if anyone guide me what I am doing wrong here.
Also I have mentioned below my .cda file which I have created and used as data source.
<CDADescriptor>
<DataSources>
<Connection id="FETCH" type="kettle.TransFromFile">
<KtrFile>ktr/test.ktr</KtrFile>
<variables datarow-name="parYear" variable-name="parYear"/>
<variables datarow-name="parLYear" variable-name="parLYear"/>
<variables datarow-name="parLob" variable-name="parLob"/>
<variables datarow-name="parTimestamp_id" variable-name="parTimestamp_id"/>
</Connection>
</DataSources>
<DataAccess access="public" cache="false" cacheDuration="3600" connection="FETCH"
id="FETCH" type="kettle">
<Columns/>
<Parameters>
<Parameter default=" " name="parYear" type="String"/>
<Parameter default=" " name="parLYear" type="String"/>
<Parameter default=" " name="parLob" type="String"/>
<Parameter default=" " name="parTimestamp_id" type="String"/>
</Parameters>
<Query>GetData</Query>
</DataAccess>
</CDADescriptor>
In my ktr file I am using below mention query :
Select KPI_NAME , YTD_CMCY_VALUE as ${parYear} , YTD_CMLY_VALUE as ${parLYear}
FROM DIM_COM_KPI_NEW_UP K,FACT_COM_KPI_NEW_UP F
WHERE k.kpi_id=f.kpi_id and f.lob_id=${parLob}
and timestamp_id=${parTimestamp_id}
Also I have passed all the parameter and listener proper in table component.Please guide me .
Regards
Sumit
Pedro Alves
Logs?
"Doesn't work" is hardly helpful
--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/e8b314c5-98c7-46d8-8ddf-77ad940861da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Sumit Bansal
... 74 more
log4j:ERROR Attempted to append to closed appender named [PENTAHOFILE].
23:54:40,801 WARN [PentahoRepositoryAccess] hasAccess: .cdfde extension not in
acl-files.
log4j:ERROR Attempted to append to closed appender named [PENTAHOFILE].
23:54:43,730 WARN [PentahoRepositoryAccess] hasAccess: .cdfde extension not in
acl-files.
log4j:ERROR Attempted to append to closed appender named [PENTAHOFILE].
INFO 07-11 23:54:44,218 - RepositoriesMeta - Reading repositories XML file: C:\
Users\IAPC-56\.kettle\repositories.xml
23:54:44,233 WARN [EventPublisher] publishToCDV: plugin not available, ignoring
request
log4j:ERROR Attempted to append to closed appender named [PENTAHOFILE].
23:54:44,234 ERROR [CdaContentGenerator] doQuery: Index: 17, Size: 17
pt.webdetails.cda.dataaccess.QueryException: Index: 17, Size: 17
at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAcc
ess.java:178)
at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleD
ataAccess.java:127)
at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataA
ccess.java:263)
at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:77)
at pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:187)
at pt.webdetails.cda.CdaContentGenerator.doQuery(CdaContentGenerator.jav
a:98)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at pt.webdetails.cpf.SimpleContentGenerator.invokeMethod(SimpleContentGe
nerator.java:325)
at pt.webdetails.cpf.SimpleContentGenerator.createContent(SimpleContentG
enerator.java:159)
at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.
java:261)
at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet
.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilte
r(PentahoWebContextFilter.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doF
ilter(PentahoRequestContextFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
--
You received this message because you are subscribed to a topic in the Google Groups "Pentaho Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pentaho-community/b3Go6cQ4ESc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/CAC_LyUjsUJqY3fx3QG63dGWwfRwgj-a6a7XrVg2TYOYh%2Bcdcxw%40mail.gmail.com.