https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127976#M7688 <P>Can anyone give me some help?Thanks a lot.</P> Tue, 02 Jun 2015 03:00:56 GMT zillionlee 2015-06-02T03:00:56Z https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127975#M7687 <P>when i use dbx 1.1.4 ,i got an error</P> <PRE><CODE>2015-05-26 11:44:39.901 dbx9174:ERROR:Scheduler - Error while reloading database input=dbmon-tail://BMS_noteobj/2 com.splunk.config.SplunkConfigurationException: Error validating dbmonTail for monitor=dbmon-tail://BMS_noteobj/2: The column "0" is not present in the result set with query = SELECT id,value,Dtime,No FROM his20150523 at com.splunk.dbx.monitor.DatabaseMonitor.validate(DatabaseMonitor.java:165) at com.splunk.dbx.monitor.DatabaseMonitor.&lt;init&gt;(DatabaseMonitor.java:145) at com.splunk.dbx.monitor.scheduler.Scheduler.loadDatabaseMonitor(Scheduler.java:216) at com.splunk.dbx.monitor.scheduler.Scheduler.reloadDatabaseMonitor(Scheduler.java:196) at com.splunk.dbx.monitor.DatabaseMonitoringManager$Reloader.run(DatabaseMonitoringManager.java:133) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: The column "0" is not present in the result set at com.splunk.util.Utils$SQL.getIndexForColumn(Utils.java:1611) at com.splunk.dbx.sql.type.impl.AbstractDatabaseType.findRisingColumnIndex(AbstractDatabaseType.java:370) at com.splunk.dbx.monitor.impl.TailDatabaseMonitor.performValidation(TailDatabaseMonitor.java:173) at com.splunk.dbx.monitor.DatabaseMonitor.validate(DatabaseMonitor.java:159) ... 11 more </CODE></PRE> <P>the table is very simple, (no bigint ,id varchar,value varchar, dtime varchar), the "no" is Rising_Column. when I click the "save" button,it's no error. but when I edit the database-inputs again,the Rising_Column change to "0". It's quite puzzling to me. the database is MS SQLSERVER. Other table-inputs are normal, like (orderno bigint,id varchar value varchar )<BR /> so I guess maybe it's because "no" is ms sqlserver ODBC reserved keywords. site: msdn.microsoft.com/en-us/library/ms189822</P> <P>If I cannot change the column name , how to solve the question?<BR /> thanks guys!</P> Mon, 28 Sep 2020 20:05:00 GMT https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127975#M7687 zillionlee 2020-09-28T20:05:00Z https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127976#M7688 <P>Can anyone give me some help?Thanks a lot.</P> Tue, 02 Jun 2015 03:00:56 GMT https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127976#M7688 zillionlee 2015-06-02T03:00:56Z https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127977#M7689 <P>probably a JDBC driver problem... I would open a support ticket. If you want to keep trying on your own, try switching from jTDS to Microsoft driver</P> Sun, 14 Jun 2015 02:09:54 GMT https://community.splunk.com/t5/Monitoring-Splunk/Splunk-DB-Connect-1-1-4-Why-am-I-getting-error-quot-java-sql/m-p/127977#M7689 jcoates_splunk 2015-06-14T02:09:54Z