Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error reading next value of sequence from database

  1. #1
    Join Date
    Nov 2014
    Posts
    3

    Default Error reading next value of sequence from database

    I am facing the below error when I am trying to access database sequence through 'Add Sequence' step. I have tested the DB connection and connection type (MS SQL Server) and access (Native(JDBC)) and everything is correct. I can fetch the next value of sequence directly in database. But Kettle is throwing the below error.

    2014/11/14 16:16:21 - Add sequence[itemv].0 - ERROR (version 4.4.3-GA from 2014/11/14 10:33:52.022) : Because of an error, this step can't continue:
    2014/11/14 16:16:21 - Add sequence[itemv].0 - ERROR (version 4.4.3-GA from 2014/11/14 10:33:52.022) : Error reading next value of sequence [item_seq1] from database
    2014/11/14 16:16:21 - Add sequence[itemv].0 - ERROR (version 4.4.3-GA from 2014/11/14 10:33:52.022) :
    2014/11/14 16:16:21 - Add sequence[itemv].0 - ERROR (version 4.4.3-GA from 2014/11/14 10:33:52.022) : Unable to get next value for sequence : item_seq1
    2014/11/14 16:16:21 - Add sequence[itemv].0 - ERROR (version 4.4.3-GA from 2014/11/14 10:33:52.022) : The SQL statement must not be null or empty.


    I have gone through the forum and I did not find any solutoion. Any help would be appreciated.
    Thanks.

  2. #2
    Join Date
    May 2012
    Posts
    110

    Default

    VKB,

    In the: 'Get Value From sequence' Step you make the Connection. You then select the Scheme Name from the Schema List. You then select the Sequence Name from the Sequence List.
    Regards Vince

  3. #3
    Join Date
    Nov 2014
    Posts
    3

    Default

    Quote Originally Posted by vincepop01 View Post
    VKB,

    In the: 'Get Value From sequence' Step you make the Connection. You then select the Scheme Name from the Schema List. You then select the Sequence Name from the Sequence List.


    Hi,

    Thanks for the reply. I am able to select schema name from schema list but the Sequence list is disabled. If I give the sequence name manually, it shows the error as explained in my first post.

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.