Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Strange Error in PDI Job

  1. #1

    Default Strange Error in PDI Job

    We have a job that runs hourly and it has many SQL Script steps that call stored procedures.

    Every once in a while (about every 3 days), the job fails with an "invalid object" which happens to be a global temp table: ##TEMPTARG.

    I am still trying to determine if this is a SQL Server problem or a PDI problem (release 5.3)

    Anyone see this before ? (see log below)

    2015/11/06 03:07:05 - CONV_HRLY_CALLRPT_RUNALL - Starting entry [CONV_HRLY_CALLRPT_RUNALL]

    2015/11/06 03:07:05 - CONV_HRLY_CALLRPT_RUNALL - Loading transformation from repository [CONV_HRLY_CALLRPT_RUNALL] in directory [/home/Hourly Report]

    2015/11/06 03:07:05 - CONV_HRLY_CALLRPT_RUNALL - Dispatching started for transformation [CONV_HRLY_CALLRPT_RUNALL]

    2015/11/06 03:07:30 - Execute SQL script.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : An error occurred, processing will be stopped:

    2015/11/06 03:07:30 - Execute SQL script.0 - Couldn't execute SQL: [CA_DW_PROD].dbo.CONV_HRLY_RPT_RUNALL 0, 0

    2015/11/06 03:07:30 - Execute SQL script.0 -

    2015/11/06 03:07:30 - Execute SQL script.0 - Invalid object name '##TEMPTARG'.

    2015/11/06 03:07:30 - Execute SQL script.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Error initializing step [Execute SQL script]

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Step [Execute SQL script.0] failed to initialize!

    2015/11/06 03:07:30 - Execute SQL script.0 - Finished reading query, closing connection.

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unable to prepare for execution of the transformation

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleException:

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - We failed to initialize at least one step. Execution can not begin!

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL -

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL -

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1149)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.trans.Trans.execute(Trans.java:607)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1062)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.job.Job.execute(Job.java:716)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.job.Job.execute(Job.java:859)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.job.Job.execute(Job.java:859)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.job.Job.execute(Job.java:598)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:69)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - at java.lang.Thread.run(Unknown Source)

    2015/11/06 03:07:30 - CONV_HRLY_CALLRPT_RUNALL - Finished job entry [CONV_HRLY_CALLRPT_RUNALL] (result=[false])

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Since that seems to be within a Call DB Procedure step, my guess would be that there's a race condition in there somewhere...

    Create Table -> Populate Table -> Query Table -> Drop Table

    If you have two or three things all doing this above process at the same time, one of them might drop the table while another one is trying to Populate it... Throwing the ##Invalid Object error.

    Obviously this is just a wild guess, but it might help you with a place to start looking.

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.