Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Hi everyone, I have a problem running the rehost process.
The log gives the following message:
[DBValidator] Connecting to jdbc:sqlserver://gama
[DBValidator] com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Repository'.
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:868)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
[DBValidator] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
[DBValidator] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:693)
[DBValidator] at com.ptc.wc.rehost.validate.DBConnectionValidator.performTask(DBConnectionValidator.java:50)
[DBValidator] at com.ptc.wc.rehost.javatask.AbstractRehostTask.execute(AbstractRehostTask.java:73)
[DBValidator] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[DBValidator] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at org.apache.tools.ant.Target.execute(Target.java:449)
[DBValidator] at org.apache.tools.ant.Target.performTasks(Target.java:470)
[DBValidator] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
[DBValidator] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:36)
[DBValidator] at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
[DBValidator] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:437)
[DBValidator] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[DBValidator] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at java.base/java.util.Vector.forEach(Vector.java:1394)
[DBValidator] at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:67)
[DBValidator] at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:155)
[DBValidator] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[DBValidator] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at java.base/java.util.Vector.forEach(Vector.java:1394)
[DBValidator] at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:67)
[DBValidator] at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:155)
[DBValidator] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[DBValidator] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at java.base/java.util.Vector.forEach(Vector.java:1394)
[DBValidator] at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:67)
[DBValidator] at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:155)
[DBValidator] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[DBValidator] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at org.apache.tools.ant.Target.execute(Target.java:449)
[DBValidator] at org.apache.tools.ant.Target.performTasks(Target.java:470)
[DBValidator] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
[DBValidator] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:36)
[DBValidator] at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
[DBValidator] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:437)
[DBValidator] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[DBValidator] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at java.base/java.util.Vector.forEach(Vector.java:1394)
[DBValidator] at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:67)
[DBValidator] at net.sf.antcontrib.logic.ForEach.executeSequential(ForEach.java:178)
[DBValidator] at net.sf.antcontrib.logic.ForEach.execute(ForEach.java:254)
[DBValidator] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
[DBValidator] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[DBValidator] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[DBValidator] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[DBValidator] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
[DBValidator] at org.apache.tools.ant.Task.perform(Task.java:350)
[DBValidator] at org.apache.tools.ant.Target.execute(Target.java:449)
[DBValidator] at org.apache.tools.ant.Target.performTasks(Target.java:470)
[DBValidator] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
[DBValidator] at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
[DBValidator] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[DBValidator] at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
[DBValidator] at org.apache.tools.ant.Main.runBuild(Main.java:818)
[DBValidator] at org.apache.tools.ant.Main.startAnt(Main.java:223)
[DBValidator] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
[DBValidator] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
!+! ERROR OCCURRED @ C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\modules\Database.xml:8: !!!
[ant] Exiting C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\modules\Database.xml.
--------------------------------------------------------------------------------
!+! EXITING FROM Database[C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\modules\Database.xml]
!+! RETURNING TO Rehost[C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml]
--------------------------------------------------------------------------------
!+! ERROR OCCURRED @ C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml:210: !!!
[antcall] Exiting C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml.
--------------------------------------------------------------------------------
!+! EXITING FROM ANTCALL WITHIN Rehost[C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml]
--------------------------------------------------------------------------------
!+! ERROR OCCURRED @ C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml:177: !!!
********************************************************************************
!+! FINISHED @ Tue Feb 06 08:11:11 PST 2024
!+! Log: C:\ptc\Windchill_12.1\Windchill\buildlogs\0042-rehost.log
********************************************************************************
BUILD FAILED
C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml:177: The following error occurred while executing this line:
C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\rehost.xml:210: The following error occurred while executing this line:
C:\ptc\Windchill_12.1\Windchill\utilities\wcRehost\conf\modules\Database.xml:8: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Repository'.
I've already done the step in Article - CS268509 and the error still persists.
Is the SA account enabled for login? In my limited Windchill / MS SQL experience I remember that the SA account had to be set for login during install, but after that it was not used.
Yes, The user was configured to login at the time of installation.
I got the same error with rehost too