Automic Workload Automation

  • 1.  SQL CONN Object test fails

    Posted Jul 23, 2018 01:00 AM

    Team,

     

    We are testing a CONN object for MS SQL. The test fails as below:

     

    U02000112 Remote System is not available via Connection Object

     

    The MS SQL DB Agent is running on a Windows Server. AE Engine is Linux/Oracle.

     

    The CONN object for Oracle works fine for a DB agent that is running on Linux.

     

    Any ideas how to debug this? 

     

    Regards

    Pothen



  • 2.  Re: SQL CONN Object test fails

    Posted Jul 23, 2018 02:38 AM

    MS SQL DB Server is up and the user id used for connection, works when we directly connect from management studio. 



  • 3.  Re: SQL CONN Object test fails

    Broadcom Employee
    Posted Jul 23, 2018 10:50 AM

    Hi Pothen,

     

    Could you please check in the Service Manager Dialog if the path of the MS SQL DB Agent is correct ?

     

     

     

    Thanks

    Bob



  • 4.  Re: SQL CONN Object test fails

    Broadcom Employee
    Posted Jul 23, 2018 06:57 PM

    Hi Pothen ,

     

    Is the DB agent running on Linux or Windows?

    Did you add the jdbc driver for MS SQL databases (folder \agent\sql\bin\jdbc?

     

    Cheers,

    Alexander



  • 5.  Re: SQL CONN Object test fails

    Posted Jul 23, 2018 09:15 PM

    This DB agent is running on Windows and is on the same server where MS SQL Server is running. There is no problem with DB agent itself and it is registered with AE. We can stop and start with local SM. We have created a the JDBC folder and copied the latest sqljdbc42.jar file here and the supported 64 bit sqljdbc_auth.dll file is placed under the bin folder.  

     

    But whenever we try with CONN object, the same message comes.

     

    Rgds

    Pothen



  • 6.  Re: SQL CONN Object test fails

    Posted Jul 24, 2018 01:56 PM

    Hi Pothen,

     

    With Alexander and Bobby suggestion, those are the most common things in which can cause the error... not having the jdbc jar file in the right Agent ../jdbc folder or starting up the wrong *** Database Agent (which doesn't have the sql jdbc in it)...

     

    We have even seen other user who have reported this error when there system hdd space were full...

     

    As you mention that "We are testing a CONN object for MS SQL" - When you say testing... are you seeing this when you are running a JOBS.SQL using that connection object or hitting the "Test" button within the Connection Object.. or both?  as I am not sure which version you are one... but on certain version that test button on the Connection object will use the DB services agent for the testing (so you will also need to have that SQL jdbc jar file in the DB services Agent also) 



  • 7.  Re: SQL CONN Object test fails

    Posted Jul 25, 2018 12:38 AM

    Hi Luu,

     

    The above error is when we test the connection. The agent is the latest i,e 12.2

     

     

     

    This is an agent which is installed along with OS agent on a Windows Server. The DB Service agent is not deployed on this server but on AE hosted on Linux machine. 

     

    Please share your views based on above.

     

    Regards

    Pothen



  • 8.  Re: SQL CONN Object test fails

    Posted Jul 25, 2018 05:26 PM

    Hi Pothen,


    Make sure the jdbc jar file is in the ....bin\jdbc folder for the SQL Agent (and the DB Services Agent) - Restart the agent after file are added.

    -If you don't want to put the JDBC file in the DB Services Agent, then instead of using the "Test" button - Use that CONN object in a SQL job instead as your test.

    -Make sure that the Agent is using/Starting up with a JRE version that compatible with that version of the sqljdbc

    Microsoft JDBC Driver for SQL Server Support Matrix | Microsoft Docs 

    System Requirements for the JDBC Driver | Microsoft Docs 

    -Also the agent will use the highest version of the jdbc file, so make sure the highest one is the one that compatible with your version of SQL Server.

     

    If after checking/doing all those and you still have the error.  I would recommend opening up a ticket with support for them to go over with you in full detail of your setup.



  • 9.  Re: SQL CONN Object test fails
    Best Answer

    Posted Jul 27, 2018 07:55 AM

    Hi,

     

    We opened an issue and we got a very specific version as below from support:

     

     

     

    With the above we could run the SQL Jobs on MSSQL. The test on CONN object did not work.

     

    Regards