When I'm trying to deploy our test environment with a deployment package in the Deployment Center, I get an error (see below). What could be the reason?
Best answer by Andre te Raa
View original
Deployment center could not retrieve product information for this database.
This topic has been closed for comments
Userlevel 7
+23
Hi Andre,
Could it be that either the sf_product_info or sf_model_info table are missing from your end product database? At least one of these tables should be present in our end product database. This holds the deployment data that the deployer (and Software Factory) uses for upgrading.
- Captain
- 101 replies
-
24 April 2023
Hi Mark,
That's what I expected, but it’s not in our database. What script is generating and updating this table?
Userlevel 7
+23
Either the Create or the Upgrade script will create the missing table or insert a record into it. For a Create of the end product, it should not occur as the database is not there yet. For an Upgrade, the table should be present. You can try manually placing the table there with a record.
- Captain
- 101 replies
-
24 April 2023
The Create and Upgrade script do not contain code to create or update the sf_model_info. A new database created with the SF, does contain a the sf_model_info. Is it only created with the DB script?
Userlevel 7
+23
No, also the Upgrade code file should contain the sf_model_info table creation (2023.1)
Could you verify if the SQLSERVER_UG base model is connected to your work model? If so, the control procedure "upgrade_sf_model_info" (or similar) should also be present (disable Hide generated prefilter)
It's a bit difficult to say exactly what the problem is. Maybe it's better to create a TCP ticket for assistance.
- Captain
- 101 replies
-
24 April 2023
- Answer
The base model SQLSERVER_UG is connected, but there is no procedure like upgrade_sf_model_info. Also code search does not find the table sf_model_info.
I will create a ticket.
- Captain
- 101 replies
-
5 June 2023
In the end it was base model SQLSERVER_MODEL_INFO that was missing.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.