3 Replies Latest reply on Sep 13, 2017 11:30 AM by Gustavo del Gerbo

    SCCM Database Timeout Issue

    Kunal Shah

      Hi All,

       

      I hope your day is going well for you.

       

      There is an issue with SCCM database time out error for some class. Ex  Sofware Product. It has around 1 million records in SCCM Software table.

       

      It fetches records around 30k and runs about 5 to 6 mins and gives time error as shown below.

       

      To validate I ran the SCCM product query in the Database server to check any time out in DB side. But it executed with any time out error and took around 3 to 4 min to get the result.

       

      "

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : Unexpected error :

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : org.pentaho.di.core.exception.KettleDatabaseException:

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : Couldn't get row from result set

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : I/O Error: DB server closed connection.

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : org.pentaho.di.core.database.Database.getRow(Database.java:3027)

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : org.pentaho.di.core.database.Database.getRow(Database.java:2942)

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : org.pentaho.di.trans.steps.tableinput.TableInput.processRow(Unknown Source)

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : org.pentaho.di.trans.step.RunThread.run(Unknown Source)

      2017/08/03 19:42:59 - Table Source.0 - ERROR (version 4.1.0, build 1 from 2015-12-09 16.13.21) : java.lang.Thread.run(Unknown Source)"

       

      Please let me we have any setting or configuration in SCCM or  Database time out setting.

       

       

      Regards

      Kunal Shah