topic Data Base Trigger in Application Development and Automation Discussions

Data Base Trigger

Former Member — Fri, 01 Oct 2010 14:39:56 GMT

Hi All,

Can any body guide me as to how to delete a database trigger of standard a table?

While applying the pre implement manual steps included in the oss Note 1441246,

i.e. while adding a field LAST_PRCS_TIME of type OIU_RUN_TIME in table 'OIU_PR_DNSTD' we have got an activation error as below,

Table change is not possible.There is a DB Trigger on the table..

According to The performance assistant ,

We need to delete the Db Trigger manually using the report 'SFSRFW_DROP_FSI_TRIGGER' which does not exists in the required system.

And after making the changes in the table we need to create DB Trigger by using report 'SFSRFW_CREATE_FSI_TRIGGER' .Which also doesn't exists in the required system.

Please Guide.

Re: Data Base Trigger

Former Member — Fri, 01 Oct 2010 19:06:19 GMT

Hi,

Maybe the message is wrong.

Please see the OSS Note 1387560 - Long text for message DA 515 is misleading:

"Summary

Symptom

The long text of message DA 515 refers to two non-existent programs SFSRFW_DROP_FSI_TRIGGER and SFSRFW_CREATE_FSI_TRIGGER.

Reason and Prerequisites

There is an error in the documentation.

Solution

The message text is corrected by importing the Support Packages specified in this note."

I don´t know your support package, so this is just a guess.

Regards,

Kate

Re: Data Base Trigger

Former Member — Mon, 04 Oct 2010 06:17:42 GMT

hi,

my system is at support pack level 14 for IS_OIL component of release 600.

and the note 1387560 suggested by you is applicable for component SAP_BASIS .

For the companent sap_basis my system is at SP level 17 for release 700.

but the note 1441246 regarding which i am facing the problem is applicable to IS_OIL component.

please clarify.

Re: Data Base Trigger

Former Member — Tue, 05 Oct 2010 13:09:17 GMT

Kate is right.

SAP note 1387560 says the error will be corrected with Basis SP level 21 for release 700. Yours is 17.

Well, 17 < 21.

For higher SP levels the message will be:

Delete the DB trigger using the same means with which it was created.

hope this helps

Edited by: Joe Bo. on Oct 5, 2010 3:12 PM