Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: confirming this is a bug before I file a JIRA

  1. #1
    Join Date
    May 2007
    Posts
    128

    Default confirming this is a bug before I file a JIRA

    When I set logging for a job in MSSQL it puts quotes around the table name - this throws the invalid object error. Running the query manually works fine w/ out the quotes but gives the "invalid object" error if I use quotes.

    Is this a bug?

    Code:
    2009/07/08 16:12:44 - Thread[DimCampaign (DimCampaign (Thread-10)),5,main] - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 
    2009/07/08 16:12:44 - Thread[DimCampaign (DimCampaign (Thread-10)),5,main] - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM "audit.KettleJobLog" WITH (TABLOCKX, HOLDLOCK)
    2009/07/08 16:12:44 - Thread[DimCampaign (DimCampaign (Thread-10)),5,main] - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'audit.KettleJobLog'.

    edit: Transform logging does the same thing.
    Last edited by elgabito; 07-08-2009 at 04:38 PM.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    What's the name of the table?

  3. #3
    Join Date
    May 2007
    Posts
    128

    Default

    audit.KettleJobLog

  4. #4
    Join Date
    Feb 2009
    Posts
    296

    Default

    Is audit the schema/database name and KettleJobLog is the actual table name? Some databases like to have the quoting separately: "audit"."KettleJobLog"

    Just a thought
    Fabian,
    doing ETL with his hands bound on his back

  5. #5
    Join Date
    May 2007
    Posts
    128

    Default

    yeah it's the schema name w/in the database... doing it that way works on all the steps I use. If I take it off it doesn't work either.

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    To be clear, the table name is : KettleJobLog
    The schema/db/user name is : audit

    So I guess it was a case of incorrect use, not a bug.

  7. #7
    Join Date
    May 2007
    Posts
    128

    Default

    Quote Originally Posted by MattCasters View Post
    To be clear, the table name is : KettleJobLog
    The schema/db/user name is : audit

    So I guess it was a case of incorrect use, not a bug.
    Yes but as I said it doesn't work with just the table name - which is why i include the schema name as I do in the steps of the transformation.

    There is no field for "schema" and if it simply didn't quote the table name it would work fine...

    Is your answer simply that this is not compatible?

  8. #8

    Default

    I noticed that also elgabito a few months ago but didn't investigate further
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  9. #9
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    SQL Server schemas are sometimes a mystery.
    You just have to read pages like this to know that.
    All we can do is offer all the possibilities that exist.
    In the end it's the database that determines whether or not the schema/table combination exists.

    In any case, the schema that you claim is missing can still be specified by doing one of either:

    - Quote yourself : "audit"."KettleJobLog" (as FabianS mentioned)
    - Specify a default schema in the database dialog (PDI 3.2 or later)

    Matt

  10. #10
    Join Date
    May 2007
    Posts
    128

    Default

    ah - i see - doing what fabians mentioned did work - I think i was interpreting it wrong when I read it the first time.

    Thank you all

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.