Error: Invalid object name 'project_vrs'.

Hey Hugo,

I tried to replicate your error but couldn't find out how to replicate it. Some questions do raise to my mind:

• Do you get the error when trying to open the application you just created or when you try to open the Software Factory? Normally 'project_vrs' is a table in the Software Factory and should be present in the SF database.
• Which version of the SF and GUI are you using?
• Did you validate your project before executing all the code to create a database? There might be a validation in 'Validate definition' that tries to warn you beforehand.
• Did you create any tables, views, tasks or is it just an empty environment?
• Does your project have an active project version?

Hopefully we and the community can help you out and making sure your application will run smoothly.

Kind regards,
-Mark

Hi Mark,

The error appears when I try to start the application. I am using SF2018.2 and GUI 2018.3.20. We have several projects and that combination works fine. I copied the .ini from a working application and used the same directories. I only changed project / database name in the .ini, so I think there should be no problem in that area.

I validated the project and only have a few info's, no warnings and/or errors. I have a four tables with a few columns and a few references. In the mean time I have created a new version (1.01): it didn't change anything.

I am not sure what you mean by an active project version, but the latest version has developer status.


Stack trace:
at Thinkwise.Data.SqlClient.TSFSqlClientConnectionBase.CreateReader(SqlConnectionStringBuilder connectionStringBuilder, Action`1 commandInitializer, String effectiveUserId, Dictionary`2 sessionVariables, Action`1 onInfoMessage)
at Thinkwise.Data.SqlClient.TSFSqlClientSF160MetaConnection.SetGUIParametersSF(PlatformType platformType, TSFApplication application, String runtimeConfiguration)
at Thinkwise.Data.SqlClient.TSFSqlClientDeveloperApplicationManager.LoadApplications(TSFSession session)
at Thinkwise.Login.ApplicationManagerConnector.ConnectWithoutApplicationContent(TSFSession session)
at Thinkwise.Login.ApplicationManagerConnector.Connect(TSFSession session)
at Thinkwise.Login.LoginDialog.connect(TSFLoginInfo loginInfo, Boolean showSplashScreen)
at Thinkwise.Login.LoginDialog.Confirm()

Hi Hugo,

Thanks for the answers. I'm not sure where the problem is located. "Invalid object name 'project_vrs'" normally means that the application can't find the object and thus gives this error. This error also occurs when you add a table to a development version and then try and open the table in the application without creating the table in the database.

So I think something might be wrong in the Software Factory database. I don't think it has something to do with Rights and authorization. Maybe @Jasper or @Anne Buit can help out since they know about everything about the Thinkwise software.

Hope they can help you out. 🤞🏼

Kind regards,
Mark

Hi Anne,

Thanks for the help. I used the wrong database name, my mistake :-(
If all solutions were this simple... 🙂