Stored procedure

Applying update 04_NewtestDWH_Procedures_v221.sql

"The module 'ps_DTW_ReferenceData_Update' depends on the missing object 'newtest.ps_DTW_InformationLog_Update'. The module will still be created; however, it cannot run successfully until the object exists."

The message you got is just a warning. It means that the procedure is already created in your Datawarehouse. The update script create this procedure if it doesn't already exists. In case it already exists, you have this warning message : "The module 'ps_DTW_ReferenceData_Update' depends on the missing object 'newtest.ps_DTW_InformationLog_Update'".