Plot Management

Update an Existing Installation

Open the Oracle SQLplus Worksheet.

Execute the SQL file cdd_upd.sql with the command start cdd_upd.sq

  A log file CDD_UPD.LOG will be created in the current directory.

Check the log file for errors.

The following error may occur:

SQL> ALTER TABLE T_PAC_MUL ADD
2 (
3 CDD_FILE_SEL VARCHAR(2000)
4 );
CDD_FILE_SEL VARCHAR(2000)
*
ERROR at line 3:
ORA-01430: column being added already exists in table

Start Agile e6.

Login with an administrative user, e.g. EDBCUSTO.

To set the password for the plotkernel and plotcusto users, open the context menu of the user mask and select Set Password.

Re-login with the user plotkernel or plotcusto, and enter the previously set password.

Search in the list of number variants for the number variant PAC and write down the current number for later use.

Delete the old Logic Models before importing the new loader files.

Keep in mind that all previous data owned by the user plotkernel and plotcusto will be deleted prior to the loading process!

Copy the logic model CDD_CUSTOMIZE first.

Open the Oracle SQLplus Worksheet.

Execute the SQL file upd_del_verbund.sql with the following command:

  start upd_del_verbund.sql CDD_CUSTOMIZE
start upd_del_verbund.sql CDD_DELETE
start upd_del_verbund.sql CDD_MENU
start upd_del_verbund.sql CDD_NTREE
start upd_del_verbund.sql CDD_PAC_DOC_RLI
start upd_del_verbund.sql CDD_PLOT
start upd_del_verbund.sql CDD_PLOTORDER
start upd_del_verbund.sql CDD_PLOTTEN
start upd_del_verbund.sql CDD_PLOTTER_PK_SFR
start upd_del_verbund.sql CDD_PLOT_DEF
start upd_del_verbund.sql CDD_PLO_PAC_TFR_LGV
start upd_del_verbund.sql CDD_SELPLOTTER
start upd_del_verbund.sql CDD_STATUS
start upd_del_verbund.sql CDD_UTIL
Delete DTV definitions (e.g. Tables, Masks, Menus, …) from the repository.

Run the SQL-Script cdd_del_dtv.sql.

 

The following loader files have to be loaded:

  • dtv_cdd.bin
  • lgv_cdd.bin
  • lgv_cdd_cust.bin
Load the files dtv_cdd.bin, lgv_cdd.bin and lgv_cdd_cust.bin with mode import/insert.

Exit Agile e6 and log in again as user plotkernel

Set the number variant PAC to the value as described in step 2.
Adapt the logic model CDD_CUSTOMIZE.

The user has access to the plot order interface through the document type masks of the type DRAWING and DRAWFILE and through the item and project mask. If access to the plot management interface is required from other document types (forms or lists), please attach the selection CDD-PLOTTEN-CG to the related menu (NOS menu for forms or SEL menu for lists).