[Mondrian] RE: I need help conecting to Teradata (Julian Hyde)

Julian Hyde jhyde at pentaho.org
Sun Feb 17 13:52:05 EST 2008


Really?

        <Table name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/>

isn't even valid XML and shouldn't parse.

Use the 'schema' attribute, and take those dots out of the table names. Let
me know if that fixes the problem.

Julian

> -----Original Message-----
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Francisco Martín C.
> Sent: Sunday, February 17, 2008 6:38 AM
> To: mondrian at pentaho.org
> Subject: [Mondrian] RE: I need help conecting to Teradata 
> (Julian Hyde)
> 
> The base .xml I'm using is the one created with cube 
> designer, the reason I
> use '"."' is because Teradata doen't support table names 
> longer tan 30 bytes
> so I have to put them like that (in the query). Im not in the 
> office right
> now so I can't check, but I think that when I putt he names with a '.'
> insteade of '"."' I got the 'Can't create native connection' 
> error from
> mondrian. The file definition of the cube is:
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <Schema name="cubosimple">
>     <Cube name="cubosimple">
>         <Table name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/>
>         <Dimension name="Sexo">
>             <Hierarchy name="Sexo" hasAll="true" 
> allMemberName="All sexo">
>                 <Table 
> name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/>
>                 <Level 
> name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000.SEXO"
> table="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000" column="SEXO"
> uniqueMembers="false"/>
>             </Hierarchy>
>         </Dimension>
>         <Measure name="Monto" column="MONTO_CHEQUE" aggregator="sum"
> datatype="Numeric" formatString="#.##0,###"/>
>     </Cube>
> </Schema>
> 
> Thanks.
> 
> 	FmC
> 
> 
> 
> Message: 1
> Date: Fri, 15 Feb 2008 13:03:13 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] RE: I need help conecting to Teradata (Julian
> 	Hyde)
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <27980DD428C24149B59AEFD732ABA466 at mackerel>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> Are you using the 'schema' attribute of the <Table> element? 
> You should be.
> I have a feeling that you're doing funny stuff like putting 
> '"."' in table
> names - if so, that's bound to confuse things.
>  
> Julian
> 
> 
>   _____  
> 
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On
> Behalf Of Francisco Martmn
> Sent: Friday, February 15, 2008 7:35 AM
> To: mondrian at pentaho.org
> Subject: [Mondrian] RE: I need help conecting to Teradata 
> (Julian Hyde)
> 
> 
> Apparently I screwed up the previous message because i 
> attached a file...
> Sorry about that, Anyway, here it goes again without 
> attachment... (In case
> that the message is duplicate I am Double sorry, I'm just new 
> here and need
> help)
>  
> Julian, thanks for the response, unfortunately I am still 
> having problems, I
> now don't have the problem with the '>' delimiter. What I did 
> was create a
> new cube definition, very simple so I can test it. I modified 
> the xml so it
> includes de Database name, but none of the .xml worked. 
> Teradata is not case
> sensitive so that isn't a problem, but the query that 
> mondrian is creating
> is not working, Maybe I added the DB name in too may places 
> (I added in
> every 'Table' and 'Table name' field). I modified the query from the
> modified definition so that it would work in teradata, the 
> 'correct' query
> would be:
> 
> select 
> sum("GC_LiDEr_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as
> "m0" 
> from "TBL_CUBO_CLIENTES_MCL_3000"
> 
> Instead of the original:
> 
> select 
> sum("GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as
> "m0" from "GC_LIDER_WRK"."
> TBL_CUBO_CLIENTES_MCL_3000" as 
> "GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"
> 
> I hope you can help me a bit more, I feel I'm getting close. Thanks a
> million.
>  
> PS: I dont think it matters, but the JDBC driver I use in 
> cube designer is
> older that the one in Design Studio, for some reason the new 
> one does not
> connect in CD and the old one doesn't connect in DS.
> PSS: Apparently I can't attach files here and to post the 
> entire error logs
> + the definitions would be a bother to everyone, If more 
> information is
> needed just ask.
> 
> 
> 
> Message: 1
> Date: Thu, 14 Feb 2008 09:12:15 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] I need help conecting to Teradata
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <459B0A2691BA494D8316BDD1BACB1082 at mackerel>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> 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.
> 
> 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?
> 
> Julian
> 
> 
> _____
> 
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On
> Behalf Of Francisco Martmn
> Sent: Thursday, February 14, 2008 4:48 AM
> To: mondrian at pentaho.org
> Subject: [Mondrian] I need help conecting to Teradata
> 
> 
> 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:
> 
> 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
> 03.01.00.102, If I use newer ones I can't connect... So far so good
> 
> Now to actually SEE the cube, The JDBC drivers defined in 
> Jboss are version
> 12.0, here the version 3.01.00.102 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:
> 
> 
> 10:23:15,865 INFO  [STDOUT] , exec+fetch 47 ms, 0 rows
> 10:23:15,865 ERROR [MondrianModel] Parse Failure
> mondrian.olap.MondrianException: Mondrian Error:Failed to 
> parse query '
>         select NON EMPTY {[Measures].[SUM of
> TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY 
> {([Sexo.Sexo].[All
> sexo], [Rango.Rango].[All r
> ango])} ON rows from [cubo0902]
> '
>        at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
> .
> .
> .
> .
>        at java.lang.Thread.run(Thread.java:595)
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while
> parsing MDX statement '
>         select NON EMPTY {[Measures].[SUM of
> TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY 
> {([Sexo.Sexo].[All
> sexo], [Rango.Rango].[All r
> ango])} ON rows from [cubo0902]
> '
>        at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
> .
> .
> .
> .
> 10:23:15,865 ERROR [MondrianModel] [NCR] [Teradata DBMS] : Object
> 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.
> 10:23:15,865 ERROR [OlapModelProxy]
> com.tonbeller.jpivot.olap.model.OlapException: [NCR] [Teradata DBMS] :
> Object 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.
> 
> 
> (...And a lot more)
> 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:
> 
> 
> 
> 10:27:51,940 ERROR [Logger] Error: Pentaho Pentaho BI 
> Platform 1.6.0.GA.863
> 10:27:51,940 ERROR [Logger]
> misc-org.pentaho.data.connection.mdx.MDXConnection: 
> MDXConnection.ERROR_0002
> - "Unable to create a native connection for c
> onnection string: "Mondrian Error:Internal error: while 
> parsing catalog
> solution:samples/analysis/cuboprueba.mondrian.xml"
> mondrian.olap.MondrianException: Mondrian Error:Internal error: while
> parsing catalog solution:samples/analysis/cuboprueba.mondrian.xml
>        at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
> .
> .
> .
> 
>        at java.lang.Thread.run(Thread.java:595)
> Caused by: org.eigenbase.xom.XOMException: Document parse 
> failed: [Fatal
> Error] :32:88: Element type "Level" must be followed by 
> either attribute
> spec
> ifications, ">" or "/>".
> 
>        at 
> org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(Unknown
> Source)
>        at 
> org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(Unknown
> Source)
>        at 
> org.eigenbase.xom.wrappers.GenericDOMParser.parse(Unknown Source)
>        at mondrian.rolap.RolapSchema.load(RolapSchema.java:303)
>        ... 94 more
> 10:27:51,956 ERROR [Logger] Error end:
> 10:27:51,956 ERROR [Logger] misc-MondrianModelComponent:
> MondrianModel.ERROR_0001 - [es_82] getInitialQuery(): 
> Connection is not
> valid: {PoolNeeded=fa
> lse, dataSource=java:TeradataDS, Provider=mondrian,
> Catalog=solution:samples/analysis/cuboprueba.mondrian.xml}
> 10:27:51,956 ERROR [PivotViewComponent] Error Start: Pentaho 
> Pentaho BI
> Platform 1.6.0.GA.863
> 10:27:51,956 ERROR [PivotViewComponent]
> 79ff1a2b-da37-11dc-ad54-931a72ea8013:COMPONENT:context-1735417
8-120290927190
> 9:cuboprueba.xactionBase.ERROR_000
> 2 - Ejecuci>n fallida del Componente
> java.lang.NullPointerException
>        at java.util.regex.Matcher.getTextLength(Matcher.java:1127)
> 
> .
> 
> .
> 
> .
> 
> 10:27:51,956 ERROR [PivotViewComponent] Error end:
> 10:27:51,956 ERROR [RuntimeContext]
> 79ff1a2b-da37-11dc-ad54-931a72ea8013:RUNTIME:context-17354178-
1202909271909:
> cuboprueba.xaction RuntimeContext.ERRO
> R_0012 - [es_33] ActionDefinition for PivotViewComponent did 
> not execute
> successfully
> 
> 
> (Again, the error itself is a lot longer, but that seems like the most
> important part)
> 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!!
> 
> Thanks.
>   Francisco Martmn C.
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/200802
> 14/a16cf8d4/at
> tachment-0001.html
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 14 Feb 2008 11:45:52 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] High Cardinality for Mondrian
> To: <luis.canals at stratebi.com>
> Cc: mondrian at pentaho.org
> Message-ID: <2A840341C8ED4706A866F2BCCA09AF1A at mackerel>
> Content-Type: text/plain; charset="us-ascii"
> 
> I have logged a bug to track this issue:
> 
> http://sourceforge.net/tracker/index.php?func=detail
> <http://sourceforge.net/tracker/index.php?func=detail&aid=1893
985&group_id=3
> 5> &aid=1893985&group_id=35
> 302&atid=414616
> 
> I have attached the code after I integrated it with the head 
> revision. It is
> in the format produced by the packChange utility, so it 
> should be easy to
> re-integrate with head in future.
> 
> Packchange is described here:
> 
> http://p4web.eigenbase.org/open/util/index.html
> 
> and can be downloaded from here:
> 
> http://p4web.eigenbase.org/open/util/bin/
> 
> It runs on linux and windows/cygwin.
> 
> Julian
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: changelist10559-large-dimension-support.tar.gz
> Type: application/x-gzip
> Size: 496848 bytes
> Desc: not available
> Url :
> http://lists.pentaho.org/pipermail/mondrian/attachments/200802
> 14/1f200d91/ch
> angelist10559-large-dimension-support.tar.gz
> 
> ------------------------------
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 
> 
> End of Mondrian Digest, Vol 15, Issue 19
> ****************************************
> 
> 
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/200802
> 15/f2951773/at
> tachment-0001.html
> 
> ------------------------------
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 
> 
> End of Mondrian Digest, Vol 15, Issue 23
> ****************************************
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 




More information about the Mondrian mailing list