Skip to main content
Solved

Missing sf_product_info insert script in Deployment package 'smart'

R
Superhero
Forum|alt.badge.img+15

When I create a Deployment Package I notice a difference between the upgrade methods “Smart” and “Full”, also described here: https://docs.thinkwisesoftware.com/docs/sf/creation.html#3-generate-source-code.

We often have small changes, so using the upgrade method ‘smart’ is preferred, because a ‘full’ update is quite heavy and can take a while. But when choosing for ‘smart’, the script ‘020_Upgrade.sql’ isn't (always) created. I have this situation for example when I only change a query in a view (no model changes).

Why isn't there a 020_Upgrade.sql containing an update of sf_product_info table generated when having only some minor changes?

Best answer by Erwin Ekkel

Indeed this part is skipped when there are no model changes. Please report this as a bug. 

View original
Did this topic help you find an answer to your question?

5 replies

E
Moderator
Forum|alt.badge.img+16
  • Erwin Ekkel
  • Moderator
  • 737 replies
  • April 14, 2020

What version of the software factory are you using?

R
Superhero
Forum|alt.badge.img+15
  • René WSuperhero
  • Author
  • Superhero
  • 196 replies
  • April 14, 2020
Erwin Ekkel wrote:

What version of the software factory are you using?

2020.1.

Hugo Nienhuis
Superhero
Forum|alt.badge.img+11
René W wrote:

When I create a Deployment Package I notice a difference between the upgrade methods “Smart” and “Full”, also described here: https://docs.thinkwisesoftware.com/docs/sf/creation.html#3-generate-source-code.

We often have small changes, so using the upgrade method ‘smart’ is preferred, because a ‘full’ update is quite heavy and can take a while. But when choosing for ‘smart’, the script ‘020_Upgrade.sql’ isn't (always) created. I have this situation for example when I only change a query in a view (no model changes).

Why isn't there a 020_Upgrade.sql containing an update of sf_product_info table generated when having only some minor changes?

 

I have noticed the same. I am using 2019.1. 

E
Moderator
Forum|alt.badge.img+16
  • Erwin Ekkel
  • Moderator
  • 737 replies
  • Answer
  • April 14, 2020

Indeed this part is skipped when there are no model changes. Please report this as a bug. 

Ester
Moderator
Forum|alt.badge.img+5
  • Ester
  • Moderator
  • 58 replies
  • July 17, 2020

​Thanks for reporting the bug (in TCP). This bug will be fixed with 2021.1.  

 

The record in product info is used by the software factory to determine if the upgrade script needs to be checked in Creation - Execute source code. Or that the upgrade has already been executed and the upgrade does not need to be checked. Therefore, it was not necessary to add this when there is nothing else in the upgrade script.   

But I understand that it is useful for you to see which version the database is. Therefore the prog object that is responsible for the insert will be always on.  

 

For now, you can workaround this by adding a dynamic CP with the following code: ​

update prog_object​
set prog_object_status = 1 -- selected_by_default
​where project_id     = @project_id​
  and project_vrs_id = @project_vrs_id​
  and prog_object_id = 'ug_sf_product_info'​

 

Note, please remember to remove this workaround after upgrading to 2021.1.​ ​

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings