Automic Workload Automation

Expand all | Collapse all

SQL Agent on Windows doesn't start

  • 1.  SQL Agent on Windows doesn't start

    Posted 06-06-2017 10:34 AM
    Hello All,
    I have installed a SQL agent on Windows server but when I try to start the agent from serviceManagerDialog nothing happens and following messages are recorded in the log file.

    20170606/060657.598 - U00022005 ... with command line  'java -jar -Xmx256M C:\Automic\ServiceManager\bin\..\..\Agents\sql\bin\ucxjsqlx.jar -service -iC:\Automic\ServiceManager\bin\..\..\AutomationEngine\bin\ucsrv.ini'.
    20170606/060657.598 - U00022006 ... and start directory  'C:\Automic\ServiceManager\bin\..\..\Agents\sql\bin'.
    20170606/060657.604 - U00022007 Process 'UC4 DATABASE-SERVICE01' (ID '8408') successfully started.
    20170606/060717.604 - U00022023 No associated window can be found for process 'UC4 DATABASE-SERVICE01'.
    20170606/060717.604 - U00022012 Process 'UC4 DATABASE-SERVICE01' (ID '8408') ended.
    20170606/060717.604 - U00022022 Process 'UC4 DATABASE-SERVICE01' ended, exit code='2'.
    20170606/090720.279 - U00022015 Command file 'C:\Automic\ServiceManager\bin\UC4.smc' was re-created.
    20170606/091205.504 - U00022019 Client statement: process 'UC4 DATABASE-AGENT01' should be started.
    20170606/091205.505 - U00022031 Client data: User 'U166044\Administrator' of computer 'U166044'.

    I have checked the paths for all the files used and all looks good, not sure where to look for more information.

    Appreciate inputs.

    Regards, Zafar 



  • 2.  SQL Agent on Windows doesn't start

    Posted 06-06-2017 02:29 PM
    does this command work if you copy-paste (and run) it from CMD?
    I pasted my commands as reference here.

    change directory to Startpath out of SMGR Dialog e.g.:
    C:\uc4\V112\agents\V112_DBSERVICE\bin

    and run the command, e.g.
    java -jar C:\uc4\V112\agents\V112_SQL01\bin\ucxjsqlx.jar -service -iC:\uc4\V112\automationengine\bin\ucsrv.ini

    Pls check, if UAC and Firewall are disabled for testing purposes.


  • 3.  SQL Agent on Windows doesn't start

    Posted 06-06-2017 04:12 PM
    Here is output of the command.

    C:\Automic\Agents\sql\bin>java -jar -Xmx256M C:\Automic\ServiceManager\bin\..\..
    \Agents\sql\bin\ucxjsqlx.jar -service -iC:\Automic\ServiceManager\bin\..\..\Auto
    mationEngine\bin\ucsrv.ini
    java.io.FileNotFoundException: C:\Automic\ServiceManager\bin\..\..\AutomationEng
    ine\bin\ucsrv.ini (The system cannot find the path specified)
            at java.io.FileInputStream.open0(Native Method)
            at java.io.FileInputStream.open(Unknown Source)
            at java.io.FileInputStream.<init>(Unknown Source)
            at com.uc4.ex.INIConfigFile.<init>(INIConfigFile.java:49)
            at com.uc4.ex.ExecutorType.<init>(ExecutorType.java:31)
            at com.uc4.ex.sql.UCXJSQLX.main(UCXJSQLX.java:49)

    Windows Firewall and UAC are disabled and same machine has functional Windows Automic agent.

    I don't see 'AutomationEngine\bin\ucsrv.ini' file anywhere on the Agent, is there a need to copy this file from Server?

    Thanks in advance.

    Zafar


  • 4.  SQL Agent on Windows doesn't start

    Posted 06-07-2017 02:48 AM
    Hi,

    as far as I know the SQL Agent needs to be installed on the server where the Automation Engine is running.



  • 5.  SQL Agent on Windows doesn't start

    Posted 06-07-2017 03:08 AM
    zafar said:
    I don't see 'AutomationEngine\bin\ucsrv.ini' file anywhere on the Agent, is there a need to copy this file from Server?
    If this is not the Server your Automation Engin is running on, YES, you will need a copy of the UCSRV.INI file here.

    MatthiasSchelp
    Usually the DB service agent runs on the AE server but its not mandatory. If not you have to provide a copy of the ucsrv.ini file to be able starting the agent.


  • 6.  SQL Agent on Windows doesn't start

    Posted 06-07-2017 03:22 AM
    Thanks FrankMuffke. I was already wondering if there is a technical necessity.


  • 7.  SQL Agent on Windows doesn't start

    Posted 06-07-2017 03:53 AM
    You are welcome MatthiasSchelp its more a matter of laziness :-)
    If the agent is not running on the AE Server you have to provide the ucsrv.ini as mentioned and it should be kept updated too on the agent side.
    So as far as I observed, most DB Service agents were installed on the AE Server.

    ...such as mine :-)


  • 8.  SQL Agent on Windows doesn't start

    Posted 06-08-2017 04:11 AM
    I have tried copying the .ini file on the agent but agent service still won't start.
     
    Now, I have installed the agent directly on AE server and see a similar behavior.

    C:\Automic\jre\bin>java -jar -Xmx256M C:\Automic\Automation.Platform\ServiceMana
    ger\bin\..\..\Agents\sql\bin\ucxjsqlx.jar -service -iC:\Automic\Automation.Platf
    orm\ServiceManager\bin\..\..\AutomationEngine\bin\ucsrv.ini
    Error: Unable to access jarfile C:\Automic\Automation.Platform\ServiceManager\bi
    n\..\..\Agents\sql\bin\ucxjsqlx.jar

    Am I missing something simple?

    Thanks for all the responses so far.

    Zafar


  • 9.  SQL Agent on Windows doesn't start

    Posted 06-08-2017 05:15 AM
    There is a misconfig in your Folder structure: C:\Automic\Automation.Platform\ServiceMana
    ger\bin\..\..\Agents\sql\bin\ucxjsqlx.jar

    As suggested please remove the uneeded \..\.. Structure and enter your path definitions explicit   - like in my example:

    change directory to Startpath out of SMGR Dialog e.g.:
    C:\uc4\V112\agents\V112_DBSERVICE\bin

    and run the command, e.g.
    java -jar C:\uc4\V112\agents\V112_SQL01\bin\ucxjsqlx.jar -service -iC:\uc4\V112\automationengine\bin\ucsrv.ini

    please make sure to change the paths according to your directory structure.