OTMM installation failed with MSSQL

Jayaram Ponnusamy

Hello,

I tried to install the OTMM 21.4 on Windows 2016 with MSSQL (I created DB, user using the sql script which is available in the OTMM's utility folder). However, The Installation failiing continously at schema creation level. Please advise if I missed anything here.

Thanks,

E:\Binaries\OTMM\install\ant\build.xml:50: The following error occurred while executing this line:

E:\Binaries\OTMM\install\ant\sqlserver.xml:11: The following error occurred while executing this line:

E:\Binaries\OTMM\install\ant\sqlserver.xml:47: The following error occurred while executing this line:

E:\Binaries\OTMM\install\ant\sql.xml:235: exec returned: 1

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:575)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:443)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)

at jdk.internal.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:435)

at org.apache.tools.ant.Target.performTasks(Target.java:456)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)

at org.apache.tools.ant.Project.executeTarget(Project.java:1376)

at com.zerog.ia.installer.util.AntUtility.go(Unknown Source)

at com.zerog.ia.installer.actions.AntRunner.installSelf(Unknown Source)

at com.zerog.ia.installer.util.GenericInstallPanel$2.run(Unknown Source)

Caused by: E:\Binaries\OTMM\install\ant\sqlserver.xml:11: The following error occurred while executing this line:

E:\Binaries\OTMM\install\ant\sqlserver.xml:47: The following error occurred while executing this line:

E:\Binaries\OTMM\install\ant\sql.xml:235: exec returned: 1

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:575)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:443)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)

at jdk.internal.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:435)

at org.apache.tools.ant.Target.performTasks(Target.java:456)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1260)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)

... 14 more

Caused by: E:\Binaries\OTMM\install\ant\sqlserver.xml:47: The following error occurred while executing this line:

E:\Binaries\OTMM\install\ant\sql.xml:235: exec returned: 1

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:575)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:443)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)

at jdk.internal.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:435)

at org.apache.tools.ant.Target.performTasks(Target.java:456)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1260)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)

... 27 more

Caused by: E:\Binaries\OTMM\install\ant\sql.xml:235: exec returned: 1

at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:644)

at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:670)

at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:496)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)

at jdk.internal.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:435)

at org.apache.tools.ant.Target.performTasks(Target.java:456)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1260)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)

... 40 more

Jeremy Naylor

Hi Jayaram,

Verify that SQLcmd can be run from the command line, it looks like it can't find that, and is failing. If it can't you may need to install the tools for SQL server. You can install it either via installing sql management studio, or the command individually. Regardless, the scripts require it to be available. I'm assuming your SQL server is hosted somewhere other then your OTMM server.

Janakiraman_Rajaram

SQL server permission is not proper