Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Unable to edit data source - error serializing joins

  1. #1
    Join Date
    Nov 2011
    Posts
    6

    Default Unable to edit data source - error serializing joins

    Hi,

    It appears this may be a bug but I'm hoping I'm wrong or that there's a workaround of some kind.

    We're using BI with a MySQL database in which all of the table and field names are camel-cased (they all start with lower case letters, e.g. userId). When first creating a data source, the fields are fetched with the correct capitalization (e.g. userId) but if we later go back and edit the data source, the fields for tables that were already part of the data source are now always fetched with the first letter capitalized (e.g. UserId). This causes an error when BI tries to serialize the joins, hanging the browser and failing to save the edits.

    Does anyone know if there's possibly something we're doing wrong or if not, whether this issue has already been identified?

    Thanks,

    Jeff

  2. #2
    Join Date
    Jan 2013
    Posts
    1

    Default

    I'm having the same problem, a year and a half after this post was created.
    2013-01-07 19:36:12,578 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.MultitableDatasourceService] Error serializing joins
    org.pentaho.agilebi.modeler.ModelerException: Invalid Relationship

    The way I corrected this was to clear the model before adjusting the joins.

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.