https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442085#M94619 <P>We configured an Input in homologation and worked perfectly however when we were to implement in the production environment Input is not able to save the data inside Splunk. <BR /> The Query we are using is as follows: <BR /> select DATEDIFF (SECOND, '1970-01-01', Data_inicio_cadastro) as Timestamp, <BR /> * <BR /> from pineonline.dbo.vw_SplunkBaseClients; <BR /> We are using the Input type configured to choose the TimeStampo column with the following DateTime Format: yyyy-MM-dd HH: mm: ss </P> <P>However in production we are receiving the following error message: <BR /> 2018-06-08 21: 22: 50.466 -0300 INFO csdbx.server.task.listeners.JobMetricsListener - action = collect_job_metrics connection = AGLPNHPSQL09-PineOnline jdbc_url = null db_read_time = 34 record_read_error_count = 5312 status = COMPLETED input_name = PineOnlineBaseClient batch_size = 1000 error_threshold = N / A is_jmx_monitoring = false start_time = 2018-06-08_09: 22:50 end_time = 2018-06-08_09: 22: 50 duration = 390 read_count = 5312 write_count = 0 filtered_count = 0 error_count = 5312</P> Tue, 29 Sep 2020 19:52:27 GMT justodaniel 2020-09-29T19:52:27Z https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442085#M94619 <P>We configured an Input in homologation and worked perfectly however when we were to implement in the production environment Input is not able to save the data inside Splunk. <BR /> The Query we are using is as follows: <BR /> select DATEDIFF (SECOND, '1970-01-01', Data_inicio_cadastro) as Timestamp, <BR /> * <BR /> from pineonline.dbo.vw_SplunkBaseClients; <BR /> We are using the Input type configured to choose the TimeStampo column with the following DateTime Format: yyyy-MM-dd HH: mm: ss </P> <P>However in production we are receiving the following error message: <BR /> 2018-06-08 21: 22: 50.466 -0300 INFO csdbx.server.task.listeners.JobMetricsListener - action = collect_job_metrics connection = AGLPNHPSQL09-PineOnline jdbc_url = null db_read_time = 34 record_read_error_count = 5312 status = COMPLETED input_name = PineOnlineBaseClient batch_size = 1000 error_threshold = N / A is_jmx_monitoring = false start_time = 2018-06-08_09: 22:50 end_time = 2018-06-08_09: 22: 50 duration = 390 read_count = 5312 write_count = 0 filtered_count = 0 error_count = 5312</P> Tue, 29 Sep 2020 19:52:27 GMT https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442085#M94619 justodaniel 2020-09-29T19:52:27Z https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442086#M94620 <P>The above message is an info to collect job metrics.</P> <P>If your problem is with indexing data,then check the indexname and check if index is created under indexers.</P> Mon, 11 Jun 2018 07:13:23 GMT https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442086#M94620 ansif 2018-06-11T07:13:23Z https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442087#M94621 <P>Thank you for you answer but We checked It was missing a setting in date format. was missing the milliseconds house where should be "yyyy-MM-dd HH:mm:ss.SSSSSS" we had configured this format "yyyy-MM-dd HH:mm:ss" When we fixed the schedule, it started to work.<BR /> Thank you once again for your help.</P> Tue, 12 Jun 2018 17:42:50 GMT https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442087#M94621 justodaniel 2018-06-12T17:42:50Z https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442088#M94622 <P>Good that it works.You can make your answer as "Accepted Answer".</P> Wed, 13 Jun 2018 07:37:15 GMT https://community.splunk.com/t5/Getting-Data-In/My-input-is-not-able-to-get-data-with-DB-connect/m-p/442088#M94622 ansif 2018-06-13T07:37:15Z