EPM Agent Is Not Working As Windows Service (Doc ID 2776853.1)

Last updated on OCTOBER 26, 2021

Applies to:

Symptoms

EPM Agent is not working as Windows Service. The Agent is working with Command Line but we have integrations for so many applications that we cant rely on the command lines. We configured the Agent as windows services successfully and it ran without issues but when we execute the data load rule it throws errors:

May-02 20:06:28:168 :: --------------- Executing Custom Event :BefExtract ---------------
May-02 20:06:28:182 :: Error: com.microsoft.sqlserver.jdbc.SQLServerDriver
May-02 20:06:28:188 :: Error: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at oracle.epm.aif.agent.queryprocessor.QueryProcessor.executeQuery(QueryProcessor.java:93)
at oracle.epm.aif.agent.service.JobsServiceExecutor.call(JobsServiceExecutor.java:96)
at oracle.epm.aif.agent.service.JobsServiceExecutor.call(JobsServiceExecutor.java:31)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

May-02 20:06:28:195 :: --------------- Completed execution for sessionId:66 ---------------
May-02 20:06:28:196 :: Job execution failedcom.microsoft.sqlserver.jdbc.SQLServerDriver
May-02 20:06:28:198 :: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unk

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.