Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Error:SELECT MAX(ID_REPOSITORY_LOG) FROM R_REPOSITORY_LOG

  1. #1

    Default Error:SELECT MAX(ID_REPOSITORY_LOG) FROM R_REPOSITORY_LOG

    Hi,

    I am frequently getting the below error and am unable to save the changes in Transformations sometimes.

    Error saving transformation to repository!
    An error occurred executing SQL:
    SELECT MAX(ID_REPOSITORY_LOG) FROM R_REPOSITORY_LOG
    I/O Error: Connection reset

    I checked the databases when i got this error so many times .DB is up and running status only but still i am getting this error.

    Regards,
    Pradeep.
    Last edited by pradeep06; 11-11-2008 at 03:37 AM. Reason: added some more text for clear understanding

  2. #2

    Default Any idea

    Hi,

    Anyone have idea about this error.


    Regards,
    Pradeep.

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

    Default

    connection or database time-out.

  4. #4

    Post Error

    Hi Matt,

    Thanks for u r reply matt.I am getting this error for every 30 mins when i am actively working with Pentaho only.I confirmed so many times that my Database is up and running and network is also fine.
    Is there any changes required in settings.I supposed to rework for the whole mapping some times.Please look into this issue.


    Regards,
    Pradeep

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

    Default

    Your database connection times out after 30 minutes. You need to fix that.

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.