Not able to retrieve data using JDBC Data source

[anuj09]

Hi All ,

I am trying to connect Snow with Oracle database using Mid Server and data source.

I am able to connect with Database but once i click on Load data in data source it runs and then end with returning no records.

There is no error message i am getting in mid-server and import set logs.

from the firewall perspective all ports are opened for snow IP address.I am not able to understand whats wrong here.

Please advise...

[tony_barratt]

Hi Anuj,

What confirmation do you have that you can connect to the database?

There should be an indication of what is happening, or not happening, in the MID Server agent logs.

Evidently "no records" could be an expected result if the SQL query you are running actually does not   bring back records.

Best Regards

Tony

[anuj09]

Hi Tony ,

Below are the logs which i got from the mid server :

This one i was getting on 25/Sep

09/25/15 11:33:52 (972) ECCSender.1 Attempt to send ecc_queue.16d202008032020028940ed866b26f32.280.xml failed: file remains enqueued for later sending

09/25/15 11:33:52 (972) ECCSender.1 Sending ecc_queue.742502008032020028940ed866b26f32.272.xml

09/25/15 11:33:54 (345) ECCSender.1 WARNING *** WARNING *** Method failed: (https://dev12864.service-now.com/ecc_queue.do?SOAP&displayvalue=all&redirectSupported=true)HTTP/1.1 401 Unauthorized with code: 401

09/25/15 11:33:54 (345) ECCSender.1 WARNING *** WARNING *** RemoteGlideRecord failed to send data to https://dev12864.service-now.com/ with (Method failed: (https://dev12864.service-now.com/ecc_queue.do?SOAP&displayvalue=all&redirectSupported=true)HTTP/1.1 401 Unauthorized with code: 401)

09/25/15 11:33:54 (345) ECCSender.1 Attempt to send ecc_queue.742502008032020028940ed866b26f32.272.xml failed: file remains enqueued for later sending

And on 28 i am getting only below logs , but outcome is same at snow end "no records retrieved":

09/28/15 15:17:22 (387) LogStatusMonitor.60 stats threads: 28, memory max: 495.0mb, allocated: 134.0mb, used: 30.0mb, queued: 0 probes, processing: 4 probes

09/28/15 15:17:42 (464) Probe: JDBCProbe:21fab0434fa20200f0c944b18110c76b Worker starting: JDBCProbe source: 21fab0434fa20200f0c944b18110c76b

09/28/15 15:17:43 (400) Probe: JDBCProbe:21fab0434fa20200f0c944b18110c76b Waiting for connection semaphore

09/28/15 15:17:43 (400) Probe: JDBCProbe:21fab0434fa20200f0c944b18110c76b Obtained connection semaphore

09/28/15 15:17:43 (400) Probe: JDBCProbe:21fab0434fa20200f0c944b18110c76b SELECT * FROM service_now

09/28/15 15:17:43 (431) Probe: JDBCProbe:21fab0434fa20200f0c944b18110c76b Enqueuing: C:\Users\Admin\Downloads\midserver\agent\work\monitors\ECCSender\output_s\ecc_queue.1501359cbc70000001.xml

09/28/15 15:17:43 (431) Probe: JDBCProbe:21fab0434fa20200f0c944b18110c76b Worker completed: JDBCProbe source: 21fab0434fa20200f0c944b18110c76b time: 0:00:00.967

09/28/15 15:17:44 (945) ECCSender.1 Sending ecc_queue.1501359cbc70000001.xml

[anuj09]

With the above logs i can say that connectivity exist but my instance is not receiving the ecc queue message sent by the mid server for the data.Correct me if i am wrong here Tony

[tony_barratt]

Hi Anuj,

Possibly yes - but there could be some more interesting log entries after the last one you mention.

Can you test again with a query other than select * from service_now?

Maybe just ask for a couple of fields from a couple of records.

Best Regards

Tony