Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: not allow to add datasource in admin and user console

  1. #1
    Join Date
    Feb 2010
    Posts
    114

    Question not allow to add datasource in admin and user console

    Hi All,

    I am beginner in pentaho, going through community edition 3.5 ,
    In the administrative console and user console i am going to add new data source, When i click on test connection , connection tested succefully but it is not allowed add new data source it gives following error

    Code:
    "PacService.Error_007"
    please see the attachment....
    Attached Images Attached Images  
    Last edited by nileshp; 02-03-2010 at 01:44 AM.

  2. #2
    Join Date
    Jan 2006
    Posts
    245

    Default

    Post a log file to have a better understanding about what happens you
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  3. #3
    Join Date
    Feb 2010
    Posts
    114

    Question

    log file path is biserver-ce\tomcat\bin\pentaho.log

    Code:
    2010-02-03 15:14:13,992 ERROR [com.tonbeller.jpivot.tags.MondrianModelFactory] Datasource java:comp/env/SampleData is not configured properly
    javax.naming.NameNotFoundException: Name SampleData is not bound in this Context
        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
        at javax.naming.InitialContext.lookup(InitialContext.java:351)
        at com.tonbeller.jpivot.tags.MondrianModelFactory.testDataSource(MondrianModelFactory.java:104)
        at com.tonbeller.jpivot.tags.MondrianModelFactory.makeConnectString(MondrianModelFactory.java:81)
        at com.tonbeller.jpivot.tags.MondrianModelFactory.instance(MondrianModelFactory.java:137)
        at com.tonbeller.jpivot.tags.MondrianOlapModelTag.getOlapModel(MondrianOlapModelTag.java:84)
        at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:62)
        at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:884)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)

  4. #4
    Join Date
    Jan 2006
    Posts
    245

    Default

    The error exception seems unrelated with your problem. It is related to SampleData ds (it is the default sample ds shipped with the demo). In any case it is better that you'll check you configuration files....

    S.
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  5. #5
    Join Date
    Feb 2010
    Posts
    114

    Question

    is the log file path is " biserver-ce\tomcat\bin\pentaho.log " right ????

  6. #6
    Join Date
    Jan 2006
    Posts
    245

    Default

    Yes
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  7. #7
    Join Date
    Feb 2010
    Posts
    114

    Smile

    Hi sramazzina,

    Problem solved... thanks for help

  8. #8
    Join Date
    Jan 2006
    Posts
    245

    Default

    What's happened?? Just to know what's wrong.....
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  9. #9
    Join Date
    Feb 2010
    Posts
    114

    Thumbs up

    Hi sramazzina,

    Sorry for late reply, The problem is in DB Table i.e. "pro_files" table which is created in hibernate schema,

    In this table "directory" column is having boolean value but it stores 1 or 0 value so i change boolean to tinyint in mysql db.....

    thats why it gives error.....

  10. #10

    Default

    i too end with the same error .plz help me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.