I have an application written in OI 3.7.2 and can not seem to Deploy any new tables.

I am using the RDK and when I select OpenInsight Tables all I see are four entries. My application has dozens of tables!!

Any ideas?

Thanks,

John Bouley

Hi John

If you can't see your tables it sounds a lot like you haven't attached the volume (directory/folder) where your new tables live. (See Attach_table in the Help).

Also - I could be wrong on this, but I think you need to put the system in development mode (change the oengine.exe) before adding new tables for OI 3.7.2 I have never used the deploy bit but I know (using basic code) I can't change tables - ie create a new table or add fields to it when the system is in run time mode. I am running OI 3.7, I can still use basic programs to copy tables but not create them in run time.

Scott, LMS

Scott,

I am using a developement, my tables are attached. It is the creation of the deployment that is not working!

If I create a new "Repository View" Deployment, select "All Application Entities", then click on "OpenInsight Tables" only four out of the hundreds of tables attached shows up!

If I use the "Deployment Definition View" and select Tables All of the tables show. But there are 406 tables. All I want to do is send one table (dictionary and data) to the customer.

I gave up and manually copied the table to a separate volume and manually installed it at the customer. I would still like to find out what the problem with the Deployment is!!

Thanks for your response.

John Bouley

John ..

Deploying Tables with changes is a PITA in OI. In order for this to have a chance of working, you have to maintain database columns in the Repository. Without this, the problem is that OI Table Builder doesn't time/date stamp the dictionary as AREV does so it's not easy to find tables / dictionary elements that have changed since … for your deployment. However, changes maintained in the Repository do. Maybe somebody smarter than me has another way to do it though.

Don Miller

C3 Inc.

To deploy a Table and data:

Deploy Application

New Repository View

Click Entities Tab

Uncheck Publishable Entities

Click on "All Application Entitis" in Worhking Search Criteria

DoubleClick on "OpenInsight Tables" in the LH ListBox

Select each table required and "Transfer" it to the RH List box

Save

NEW eployment Definition

Settings

Select Path

Select Upgrade / Module in Deployment Type

Select the Repository view just created

In the Tables tab you should see the files created.

You will find that the Processing Column will default to Deploy empty for the Data File , just DblClick and change it.

Save then extract

Attach the directory with your upgrade and select sysupgrade - from DataBase Manager ( dont save the database definition)

In Editor edit the %PROCESS% record in SYSUPGRADE and check the file path, you might need to change it from its .\DATA default

Barry Stevens

View this thread on the forum...