<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.17052" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=107570217-14022008><FONT face=Verdana
color=#000080 size=2>Two errors here. First, it can't find the object. Have you
maybe spelled the table in lowercase in your schema file, and it is uppercase in
Teradata; or perhaps it needs to be qualified by a schema name in teradata. Turn
on SQL tracing (mondrian.trace.level=1) and see what SQL mondrian generates,
then try running that SQL using teradata's command line.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=107570217-14022008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=107570217-14022008><FONT face=Verdana
color=#000080 size=2>Second, when you changed the schema.xml file you made it
into invalid XML. I think you forgot to terminate the <Level> element with
/>. Maybe you tried to put comments inside the Level
element?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=107570217-14022008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=107570217-14022008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Francisco
Martín<BR><B>Sent:</B> Thursday, February 14, 2008 4:48 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] I need help conecting to
Teradata<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hello, I've been using Mondrn with Pentaho BI Suite and for some reason I
can't connect to Teradata with Mondrian, I can make reports using my DB, the
problem only comes with Mondrian. Here's what I do:</DIV>
<DIV> </DIV>
<DIV>I use Cube Designer to design and publish a cube, at this point I have no
problem accesing the data from Teradata, I can use the graphic interface
perfectly. In Cube designer I have to use the JDBC drivers version <A
href="http://03.01.00.102">03.01.00.102</A>, If I use newer ones I can't
connect... So far so good</DIV>
<DIV> </DIV>
<DIV>Now to actually SEE the cube, The JDBC drivers defined in Jboss are
version 12.0, here the version <A href="http://3.01.00.102">3.01.00.102</A>
simply don't work. So, I go to localhost/samples/analysis and when I click on
a SampleData cube I can see it perfectly, but, a Teradatya cube... NOTHING,
The only thing I see is the message from Jboss that goes like this:</DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><EM><FONT face="courier new,monospace" size=2>10:23:15,865 INFO
[STDOUT] , exec+fetch 47 ms, 0 rows<BR>10:23:15,865 ERROR [MondrianModel]
Parse Failure<BR>mondrian.olap.MondrianException: Mondrian Error:Failed to
parse query '<BR> select NON
EMPTY {[Measures].[SUM of TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns,
NON EMPTY {([Sexo.Sexo].[All sexo], [Rango.Rango].[All r<BR>ango])} ON rows
from [cubo0902]</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace"
size=2>'<BR> at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace"
size=2> at
java.lang.Thread.run(Thread.java:595)<BR>Caused by:
mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX
statement '<BR> select NON
EMPTY {[Measures].[SUM of TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns,
NON EMPTY {([Sexo.Sexo].[All sexo], [Rango.Rango].[All r<BR>ango])} ON rows
from [cubo0902]<BR>'<BR> at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>.</FONT></EM></DIV>
<DIV><EM><FONT face="courier new,monospace" size=2>10:23:15,865 ERROR
[MondrianModel] [NCR] [Teradata DBMS] : Object 'TBL_CUBO_CLIENTES_MCL_3000'
does not exist.<BR>10:23:15,865 ERROR
[OlapModelProxy]<BR>com.tonbeller.jpivot.olap.model.OlapException: [NCR]
[Teradata DBMS] : Object 'TBL_CUBO_CLIENTES_MCL_3000' does not
exist.</FONT></EM></DIV>
<DIV><EM><FONT face="Courier New" size=2></FONT></EM> </DIV></BLOCKQUOTE>
<DIV dir=ltr><FONT face="" size=2>(...And a lot more)</FONT></DIV>
<DIV dir=ltr><FONT face="" size=2>Which seems to be because the name of the
Database itself is nowehre to be found, it just references the tables. So, my
natural instinct suggest me to change the .xml and add the reference to the
table... at this point I get the following error:</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV dir=ltr><FONT face="courier new,monospace"><EM>
<DIV><EM><FONT face="courier new,monospace">10:27:51,940 ERROR [Logger]
Error: Pentaho Pentaho BI Platform 1.6.0.GA.863<BR>10:27:51,940 ERROR
[Logger] misc-org.pentaho.data.connection.mdx.MDXConnection:
MDXConnection.ERROR_0002 - "Unable to create a native connection for
c<BR>onnection string: "Mondrian Error:Internal error: while parsing catalog
solution:samples/analysis/cuboprueba.mondrian.xml"<BR>mondrian.olap.MondrianException:
Mondrian Error:Internal error: while parsing catalog
solution:samples/analysis/cuboprueba.mondrian.xml<BR>
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)</FONT></EM></DIV></EM></FONT><FONT
face="courier new,monospace"><EM>.</EM></FONT></DIV>
<DIV dir=ltr><FONT face="courier new,monospace"><EM>.</EM></FONT></DIV>
<DIV dir=ltr><FONT face="courier new,monospace"><EM>.</EM></FONT></DIV>
<DIV dir=ltr>
<P><FONT
face="courier new,monospace"><EM>
at java.lang.Thread.run(Thread.java:595)<BR>Caused by:
org.eigenbase.xom.XOMException: Document parse failed: [Fatal Error] :32:88:
Element type "Level" must be followed by either attribute
spec<BR>ifications, ">" or "/>".</EM></FONT></P>
<P><FONT
face="courier new,monospace"><EM>
at org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(Unknown
Source)<BR> at
org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(Unknown
Source)<BR> at
org.eigenbase.xom.wrappers.GenericDOMParser.parse(Unknown
Source)<BR> at
mondrian.rolap.RolapSchema.load(RolapSchema.java:303)<BR>
... 94 more<BR>10:27:51,956 ERROR [Logger] Error end:<BR>10:27:51,956 ERROR
[Logger] misc-MondrianModelComponent: MondrianModel.ERROR_0001 - [es_82]
getInitialQuery(): Connection is not valid: {PoolNeeded=fa<BR>lse,
dataSource=java:TeradataDS, Provider=mondrian,
Catalog=solution:samples/analysis/cuboprueba.mondrian.xml}<BR>10:27:51,956
ERROR [PivotViewComponent] Error Start: Pentaho Pentaho BI Platform
1.6.0.GA.863<BR>10:27:51,956 ERROR [PivotViewComponent]
79ff1a2b-da37-11dc-ad54-931a72ea8013:COMPONENT:context-17354178-1202909271909:cuboprueba.xactionBase.ERROR_000<BR>2
- Ejecucižn fallida del
Componente<BR>java.lang.NullPointerException<BR>
at java.util.regex.Matcher.getTextLength(Matcher.java:1127)</EM></FONT></P>
<P><FONT face="courier new,monospace"><EM>.</EM></FONT></P>
<P><FONT face="courier new,monospace"><EM>.</EM></FONT></P>
<P><FONT face="courier new,monospace"><EM>.</EM></FONT></P>
<P><FONT face="courier new,monospace"><EM>10:27:51,956 ERROR
[PivotViewComponent] Error end:<BR>10:27:51,956 ERROR [RuntimeContext]
79ff1a2b-da37-11dc-ad54-931a72ea8013:RUNTIME:context-17354178-1202909271909:cuboprueba.xaction
RuntimeContext.ERRO<BR>R_0012 - [es_33] ActionDefinition for
PivotViewComponent did not execute
successfully</EM></FONT></P></DIV></BLOCKQUOTE>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>(Again, the error itself is a lot longer, but that seems like the
most important part)</DIV>
<DIV dir=ltr>PLEASE, at this point Im desesperate, I've searched every forum
I've found and I found nothing to help me, We have a lot of hope in this
platform, but at this point it's begining to be a lot of trouble. HELP!!</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Thanks.</DIV>
<DIV dir=ltr> Francisco Martín C.</DIV></BLOCKQUOTE></BODY></HTML>