Loading
Database Upgrade Scripts complains about missing object 'PopulateInitialDataForDM_MT'

Hi Champs,

 

I just wanted to check if anyone while upgrading from 2024 R2 to 2025 R2 has faced issues like below:

 

Preparing to run step 'Migration from 23.1 to 23.2'.

Required minimum database compatibility level: SQL Server 2008 (100)

Found database compatibility level: SQL Server 2019 (150)

Required version: 23.1

Found version: 23.1

Executing step

Checking that all database objects are owned by dbo...Validated

Running 'common-mig-procs.sql'.

Running 'dw-migr2320-migprep.sql'.

Starting migration in phase "prep" at step 1

Migration phase "prep" complete.

Running 'dw-migr2320-DataWarehouseSchema.sql'.

Changed database context to 'master'.

Changed database context to 'DEV_FNMPDataWarehouse'.

The module 'PopulateInitialDataForTenant' depends on the missing object 'PopulateInitialDataForDM_MT'. The module will still be created; however, it cannot run successfully until the object exists.

The module 'PopulateInitialDataForTenant' depends on the missing object 'PopulateInitialDataForFNMP_MT'. The module will still be created; however, it cannot run successfully until the object exists.

Creating procedure to return the contents of the license file associated with a particular tenant

Creating procedure to set the contents of the license file associated with a particular internal tenant ID

Creating procedure to set the contents of the license file associated with a particular internal tenant UID

Changed database context to 'DEV_FNMPDataWarehouse'.

Changed database context to 'DEV_FNMPDataWarehouse'.

Changed database context to 'DEV_FNMPDataWarehouse'.

Changed database context to 'DEV_FNMPDataWarehouse'.

Changed database context to 'DEV_FNMPDataWarehouse'.

Changed database context to 'DEV_FNMPDataWarehouse'.

Checking identity information: current identity value '1000'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Checking identity information: current identity value '1000'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Checking identity information: current identity value '1000'.

 

 

If I proceed with upgrade, will it cause any issue. Similar logs are being shows IM and DWH.

 

Thanks,

FL

 

 


  • JohnSorensenDK (Flexera Software)

    @fawad_laiq​ 

    I can see that you raised the same question with Flexera Support and received confirmation that these messages were expected. If your experiences make sense to share with the broader community, then please do.

     

    Thanks,

    John Sorensen

    Expand Post

Loading
Database Upgrade Scripts complains about missing object 'PopulateInitialDataForDM_MT'