on 10-05-2015 1:10 PM
Hello Gurus,
One of my client run on SAP BW 7.3 SP11 on DB6.
I have a requirement to delete temporary generated programs for transformation where the source (Data Source) and data target (DSO) do not exist any more.
Using the standard sap procedure I tried with the program SAP_DROP_TMPTABLES with check box for generated (Temporary reports) and executed report SAP_UPDATE_DBDIFF.
Still I can see the generated temporary program in SE38 and also in table RSSGTPDIR (Directory of the generated programs).
Question: Is there one have faced similar issue ? If you how to solve this using standard SAP mechanism.
Note: We have already created a low priority ticket with SAP.
Also I have created a program to check the input program name GP* in RSSGTPDIR (with template as RSTEAN_MASTER_TEMPL, *EXPERT, *MULTI_SEG) and check in RSTRAN if it is related to any transformation. If not delete the program and delete from RSSGTPDIR.
Thanks in advance!!
-J
Dear All,
I think the following step will work. Not sure about the impact.
Question:
Note: We are still waiting for real answer from SAP.
Thanks,
-J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The easiest and fastest way is to use RSSGPCLA and then delete the
generated programs ,and also reset the generation flag.
For the trfn template RSTRAN_MASTER_TMPL it will clean up ALL
Programs which belong to this template. When the generation status is reset, then the next time the transformation is activated/executed, the system regenerates the program.
Thanks
Hi Jugal,
As already mentioned by Frédéric both programs are not useful for this purpose. Program SAP_DROP_TMPTABLES is used for deleting temporary database objects, e.g. interim results from BEx Query processing. Please refer to SAP Note 449891 - Temporary database objects in BW 3.x for more information.
Program SAP_UPDATE_DBDIFF is meant for differences between ABAP Data Dictionary and database.
Although I wonder what could be the root cause of those 6,000 orphaned generated programs, I don't think that it will cause any problem. But I can understand that you prefer to do a clean-up.
Please share how you will proceed and also what SAP's reaction will be.
Thanks in advance.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jugal,
Generated programs for transformation (GP*) are not temporary at all. SAP_DROP_TMPTABLES will have no effect on them. As for the SAP_UPDATE_DBDIFF, it concerns inconsistencies between the ABAP dictionnary and the database dictionnary.
To my knowlegde, there is no such utility.and you'd better search to delete the transformation itself rather than the generated program.
Regards,
Frederic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Frederic,
The transformation (including the source and target) are already deleted long ago. Still the generated program do exist (via SE38) and also have entries in the table RSSGTPDIR.
I was wondering is there a standard way to clean up those non applicable/ obsolete generated programs.
Thanks,
-J
Hi Frederic,
I was able to find around 6K orphaned GP in development environment only.
Have already raised message with SAP.
The Orphaned GP list can be made with simple SQL statement like below. May be helpful for others.
SELECT uni_idc25 progname
INTO CORRESPONDING FIELDS OF TABLE [Internal table name]
FROM rssgtpdir
WHERE uni_idc25 NOT IN ( SELECT tranprog FROM rstran )
AND template = 'RSTRAN_MASTER_TMPL'.
Thanks,
-J
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.