I landed in a situation where SAP Forums software was’t functioning as expected.

I posted on scn but could not get any response.also there weren’t any threads which talked about the issue.

we could identify the issue being that a certain column of a table was having length as 20 and there the insert statement was failing.

Since it was urgent we raised it to  OSS and they confirmed that the issue identified by us was correct and provided us instructions to fix the issue by ourselves while they release a sap note.

The steps are as follows.

1. Copy  the sca from eps/in folder to your local machine.

2. Modify the sca

3. Redeploy the sca.

once we copy the sca from server to local machine, we can modify it using a zip utility e.g 7zip.

let us see how to do it. i am taking example of Forums SCA.

1, Locate the sca on filesystem.

LocateSCA.png

2. Open the SCA with 7zip or any compatible software.

/wp-content/uploads/2014/01/open_371031.png

3. Locate the sda required to edit, in this case we are editing the forums.db sca.

/wp-content/uploads/2014/01/sda_371032.png

4. open the the sda .select the table which you want to edit.

/wp-content/uploads/2014/01/table_371034.png

5. Edit the table (this is important as if we just open it will not update the sca)

/wp-content/uploads/2014/01/edit_371035.png

6. Change the Length as required.

/wp-content/uploads/2014/01/change_371039.png

7. Save the file and navigate upwards in the 7zip editor.

    At each step the editor asks you to update the file. select yes at each step.

   once you reach the base SCA. you are done with the editing.

8. For deploying we will use NWDS.

    Open the Deploy window.Navigate to External Deployable Archives and select the SCA from filesytem.

    Important property to set is the Update Strategy. set it to “update deployed archives that have same or lower component version”

/wp-content/uploads/2014/01/nwds_371040.png

9. All set, Select the SCA and Click Deploy icon.

Provide the authentication if NWDS asks for the J2EE Server and wait for deployment to finish. Depending on the SCA size it may take quite a time.

for me it took 45 mins.

10. Log on to the application and check that the error has vanished!

Hope you found this useful.

Regards

Rajendra.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Andy Silvey

    Hi RajendraKumar,

    this is a nice contribution and explanation.

    I have also had situations where these steps are necessary, for example modifying the web.xml in an sca and then redeploying.

    This strategy of modifying the contents of an SDA are also used for deploying libraries in PI.

    Best regards,

    Andy.

    (0) 

Leave a Reply