No Error Logs!!

Can you please check if you can any log with ERR.

and also can you confirm the connectivity to the database TNS port.

check if you are able to telnet the DB over TNS service port.

Also confirm if you provided driver path correctly.

may be Query is wrong?

Query must be sorted by the key field and the condition
where key_field > ?

Jamied, please attach full query definition because it's possible that you have incorrect condition there and that's the cause of no results.

The beginning of your main query is: "select top 10 aggregate_id from ..." - in this case you will be able to retrieve only aggregate_id value... so you should verify whether you event identification rule is correct...

Also you can remove "Top 10" from MAX and MIN queries because you will always have only one value as a result (at least you should).

Regards

I am not seeing any error lines in the log. If you right click on my image and click view image you should be able to see my full queries. I am just trying to see if the logs can be read at this point. Thanks for the suggestions. I removed top from my queries, but am still seeing no results.

Have you confirmed your DB connectivity over TNS service port??

You added InitialEndQuery and IntitialBeginningValue parameters but your main query is built in the way that makes impossible to use those values.

Change QuerySet.1.PrimaryQuery.1.Query in following way:
SELECT aggregate_id FROM dbo.scr_fct_web where aggregate_id > ?

Moreover you have used IntitialBeginningValue but as value you used MIN query. Change this in one of two ways:
- put 0 instead of MIN query
- leave MIN query but change parameter name from IntitialBeginningValue to IntitialBeginningQuery

Regards

Yes, I can connect to this DB externally through a different application.

I will try that Antilles. Thank you.

Well, I got a little further.. but still stuck on "reading events" when testing the sensor.

 DEBUG    2012-01-25 13:15:43,496    sensors    AWT-EventQueue-0    Initial read policy: "BEGINNING"
DEBUG    2012-01-25 13:15:43,497    sensors    AWT-EventQueue-0    use URLClassLoader in OpenDevice(), dir=/usr/lib/jvm/jre-1.6.0-openjdk.x86_64/lib/sqljdbc_3.0/enu; files=sqljdbc4.jar;sqljdbc.jar
DEBUG    2012-01-25 13:15:43,498    sensors    AWT-EventQueue-0    URLs are loaded: [jar:file:/usr/lib/jvm/jre-1.6.0-openjdk.x86_64/lib/sqljdbc_3.0/enu/sqljdbc4.jar!/, jar:file:/usr/lib/jvm/jre-1.6.0-openjdk.x86_64/lib/sqljdbc_3.0/enu/sqljdbc.jar!/]
DEBUG    2012-01-25 13:15:43,499    sensors    AWT-EventQueue-0    java.library.path: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
INFO    2012-01-25 13:15:43,834    sensors    AWT-EventQueue-0    Result query(TestQuery) is "select user_id from dbo.scr_dim_user where user_id > ?"
INFO    2012-01-25 13:15:43,835    sensors    AWT-EventQueue-0    Init query is "select min(user_id) from dbo.scr_dim_user" 

Here is my property list I changed the query to point to a smaller table, but it is basically the same with the changes suggested implimented.

Agree with Avkash K. If you specify incorrect driver - collector would log ERROR message in your log.

Can you test your collector in collector studio and check if it returns events?