I am trying to upgrade a Stored Procedure in my application.

I have made and Upgrae/Module deployment definition.

The Stored Procedure I want to upgarde is called S_Word.

I start by making a repository View:

Stored Procedures Debug Tables

Stored Procedures Excutables

Stored Procedures

Call the Repository_View KSF_Test

Then a deployment definition as an Upgrade/Module.

View_Name would be KSF_Test.

After the Extraction i run the RDKInstall and nothng happends. No code is written to the old stored procedure.

Any one can help?

Thanks

KSF

What is the version of OI, in use? They were a couple of bugs in the deployment process which have been removed in version 3.7/3.71. Have you tried to do a full install in another/test directory to see if the procedure is copied over?

Make sure you are following the complete Deployment/Upgrade procedure, which you can access from the folowing link:

CLICK </QUOTE> ---- === At 16 AUG 1999 09:00AM Don Bakke wrote: === <QUOTE>How are you running the RDKInstall() function? Are you sure you are passing in the correct pathname where the deployment files are? Next I would verify that the entities were actually deployed. Attach the volume where your entities were deployed. You will find a table called SYSUPGRADE and within that you should find references to your routine that you wanted to deploy. If you don't see anything than something has prevented the extract process from completing its mission. There is a known bug where entities that need evaluation won't deploy. dbakke@srpcs.com [url=http://www.srpcs.com]SRP Computer Solutions

I run RDKInstall() like this:

run RDKInstall(pathname to deployed files, Applecationname).

I do not get any errormessages form the system.

Regards

KSF

Did you verify that the entities are actually in the SYSUPGRADE table?

Also, what version of OI are you using? A bug was introduced in 3.7 that causes OI to think more than one user is logged in so it aborts without giving you any error messages. We had to modify the the RDK function that checks this to get it to work. The latest patch for 3.7.2 seems to have fixed this however.

dbakke@srpcs.com

SRP Computer Solutions

Thanks for the response.

How do you verify that the SYSUPGARDE is actually there. I am a begginer.

I am using version 3.7.1

Regards

OI 3.7.1, I believe, is where the problems with getting deployments to install correctly began. You might want to install the OI 3.7.2 release candidate patch, re-run your RDK deployment (this is necessary to refresh the code used to install a deployment), and then re-run the RDKInstall process at the runtime.

If you still want to manually verify your deployment file contents follow these steps:

1. Let's assume, for example, you deployed your components to C:\DEPLOY

2. Launch System Editor

3. In the Exec: line type: RUN ATTACH_TABLE "C:\DEPLOY"

4. Make sure you get the response: Request successfully executed. Otherwise that means no valid Revmedia tables exist

5. Press Ctrl-R to launch the Open Record dialog box

6. Scroll down the Table listbox and look for SYSUPGRADE. You might have to click on the Refresh button first if it doesn't appear. If it still doesn't appear then you don't have an RDK deployment in this directory

7. If you find SYSUPGRADE then double click on it so you can see the list of rows in SYSUPGRADE

8. Scroll through these rows and look for the components that you were expecting

9. If they aren't there, then the RDK failed to deploy your components. If they are there then the runtime application failed to install them

dbakke@srpcs.com

SRP Computer Solutions

View this thread on the forum...