New installation of Toad Data Point 4.0 (first tried with 3.8 )
Tas created and scheduled from scratch with that version
NET 4.6 (also tested with net 4.5.1)
How are the tas set up:
Customer has several tas scheduled and each of them runs 4 times a day.
The tas are all the same: run a select, send some parameters to a report and send emails (the reports contain a couple of queries to the database).
Each tas takes at most 2 minutes to be completed. They have never had issues when running them manually.
The problem now is as follow:
Some of the tas fail randomly with the error:
-- 21/09/2016 18:09:08: testTas.log: Connection description = PROD (TEST), TEST
-- 21/09/2016 18:09:08: testTas.log: Connection node found
-- 21/09/2016 18:09:08: testTas: ORA-12560: TNS:error del adaptador de protocolo
This happens with all the tas .One time fails one, one time the other…Also the one/s that fail in the morning work fine the next time… It looks like the tas looses connection randomly
There are not network issues , nor antivirus/firewall or any tools dropping connections.
All the checks and best practices detailed on other KB articles and documentation have been followed.
The tas also has problems connecting to the mail server.
Please have a look at the documentation below: