Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

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 have created sequence object in MS SQL database and I am trying to use it through 'Add Sequence' step in Kettle.
    I am able to get the next value for the sequence directly in the database. But when I am facing the below error while trying to fetch the sequence value from Kettle.
    I have checked/tested the DB connection to the server [Used Connection Type: MS SQL Server and Access: Native (JDBC)] and the user credentials. Everything seems correct.

    Error:

    2014/11/14 14:54:56 - 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 14:54:56 - 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_seq] from database
    2014/11/14 14:54:56 - Add sequence[itemv].0 - ERROR (version 4.4.3-GA from 2014/11/14 10:33:52.022) :
    2014/11/14 14:54:56 - 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_seq
    2014/11/14 14:54:56 - 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 searched the entire forum and didn't find any solution. Any help would be appreciable.

  2. #2
    Join Date
    Feb 2014
    Posts
    4

    Default

    I am getting this issue too with the latest pentaho release 5.3. Although, Sql Server 2012 supports sequences Pentaho new version is not.

Tags for this Thread

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.