Rehost Error " Invalid object name 'Repository'.

RG_10875150 · ‎Feb 06, 2024

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.

jbailey · ‎Feb 07, 2024

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.

RG_10875150 · ‎Feb 07, 2024

Yes, The user was configured to login at the time of installation.

DW_8939317 · ‎Oct 14, 2024

I got the same error with rehost too

bmessenger · ‎Oct 16, 2025

I know this is quite old but I stumbled across this becasue I had the exact same issue and managed to resolve it.

The 'Repository' it is referring to is a table in the wcadmin database. I am using SQL server with all the defaults so there is a wcadmin database with that table and hundreds of others. After much gnashing of teeth I worked out that my SQL server login (also wcadmin) that I have in my rehost file did not have the user mapping to the wcadmin database with the wcadmin default schema. (Note in SQL server you have a user under the database and a login at the server level, both under security in SSMS. The login can have users underneath it under the user mapping section of the login.)

I have this setup

SQL server instance: MSSQLSERVER01

Host: myHostName

Database: wcadmin

Default Schema: wcadmin

Database User: wcadmin

Server Login: wcadmin (and this requires user mapping to the wcadmin database for user wcadmin, default schema wcadmin)

The info in the rehost file is the server login info and it uses this to connect to the database and hence the table Repository.

I tried the GUI to set up the User Mapping to the database but this kept failing. So I ended up using this script using SSMS

USE wcadmin

EXEC sp_change_users_login 'Auto_Fix', 'wcadmin'

This fixed orphan users and then my rehost worked.