Hi,
We just moved our SAP database from ECC to HANA. As a result the DB schema owner has changed from SAPPGE to SAPABAP1. I have now about 400 collect errors due to the incorrect schema owner.
Instead of fixing these one-by-one manually, can I mass update the SQL statements within the DSP database?
Any help is appreciated.
Rolf
There is a way to mass update the schema. However, when moving from ECC to HANA, it is recommended that all tables/packages be rebuilt, as there are definitely field changes between these two systems. To rebuild all tables/packages:
1) Make sure the "Delete Target Table On Build" box is checked on the vertical view (Advanced Settings tab) of your Collect Target Source.
2) Change the "Schema Owner" field on the Target Source to the new value.
3) On the Target Source page, click the " Build Package" button. This will rebuild all SQL tables and Packages.
4) After the rebuild is complete, click on Refresh for the Target Source to refresh all tables.
If there is some reason you do not want to rebuild all tables and package (due to customization), you can execute this command to do a mass update on all packages. You must still do step 2 above (change the Schema Owner on the Source):
USE CranPort
GO
UPDATE CPPackage
SET SourceSQL = REPLACE(SourceSQL, 'SAPPGE', 'SAPABAP1')
WHERE SourceSQL LIKE N'%SAPPGE%'
Keep in mind that the above statement would modify ANY package that contains SAPPGE.
Please sign in to leave a comment.
Comments
1 comment