ProFrame C 5.0 Fix#1

This chapter briefly describes the new features added to ProFrame C 5.0 Fix#1.

1. New Features

  • Project-specific permissions and role management

    Provides the ability to assign resource permissions or and roles for project.

  • Admin Navigator

    When a user accesses the Studio with an administrator account, the Admin Navigator allows the user to view resources for all projects. However, resources can be opened in read-only mode only.

  • Alerts for DBIO IN/OUT column changes

    Provides alerts when query modifications during DBIO editing cause changes to parameter names, order, types, or column lengths in IN/OUT structures.

  • Feature to display the current edit location of EMB modules

    When modules are edited in the [Source] tab of the EMS editor, the Outline View displays the location of the module currently being modified. To minimize performance impact, the location is updated only when actions such as code edits or block selections occur.

  • Feature to view resource statistics per project

    The Studio provides a view that displays the number of resources developed or completed for each project. Resource statistics for all projects are available only when accessing the system with an administrator account that has the Admin Role.

  • Bulk cancellation of RI/WS resource checkouts in WebAdmin

    Provides the ability to cancel all checked-outs resources in the current project in WebAdmin. This feature is for project management purposes.

  • DBIO logging enhancement

    Provides enhanced DBIO logging that outputs DBIO query input structures, previously available in ProFrame C 4.0 source generator.

  • DBIO Map List feature

    Provides the ability to view the list of DBIOs linked to the SO during DBIO compilation in the Studio. This feature can be enabled or disabled using the WebAdmin option (DBIO - CHECK_DBIO_LINKING_LIST).

  • Automatic RI/WS on/off in Studio

    Automatically enables or disables the RI/WS features in the Studio based on the integrated server’s RI/WS On/OFF option (USE_RIWS).

  • Meta resource migration feature (5.0 to 5.0 Fix#1)

    Provides the ability to migrate metadata resources from previous versions (ProFrame C 5.0) to use the unified metadata structure. To migrate ProFrame C 4.0 metadata resources, perform the ProFrame C 4.0 DB migration to ProFrame C 5.0 Fix#1, and then use this feature. (Supported only for Oracle)

    • Usage

      1. Enter migration information in pfm5mig.properties.

         source.driver=oracle.jdbc.driver.OracleDriver
 source.url=jdbc:oracle:thin:@192.168.1.155:1521:orcl
 source.user=proframe5
 source.password= proframe5

 destination.driver=oracle.jdbc.driver.OracleDriver
 destination.url=jdbc:oracle:thin:@192.168.1.156:1521:orcl
 destination.user=proframe5
 destination.password=proframe5

 # default:5
 migsize=5
 # Enter the new project_id to use
 project_id=MDS

      2. Run com.tmax.proframe.mig.meta4to5.Pfm5MetaMigMain to perform the migration. (ojdbc driver is not provided but can be downloaded from the website.)

        java -classpath pfmdevsvr.jar:$JEUS_HOME/lib/datasource/ojdbc14.jar com.tmax.proframe.mig.meta4to5.Pfm5MetaMigMain

  • ProFrame DB migration Feature (4.0 to 5.0 Fix#1)

    Provides the ability to migrate ProFrame C 4.0 DB data to 5.0 format. Migration is performed on a per-table basis and can be committed and rolled back. If an error occurs, only the tables with errors can be checked and migrated separately. (Supported only for Oracle. Tables with duplicate resources must be checked and handled manually by an administrator.)

    • Usage

      1. Enter migration information in pfm5mig.properties.

        source.driver=oracle.jdbc.driver.OracleDriver
source.url=jdbc:oracle:thin:@192.168.1.155:1521:orcl
source.user=proframe4
source.password= proframe4

destination.driver=oracle.jdbc.driver.OracleDriver
destination.url=jdbc:oracle:thin:@192.168.1.156:1521:orcl
destination.user=proframe5
destination.password=proframe5

# default:5
migsize=5
# Enter the new project_id to use
project_id=MDS

      2. Create mds_legacy_tables.txt (list of tables without project_id) and mds_mp_tables.txt (list of tables with project_id).

      3. Run com.tmax.proframe.mig.proframe4to5.Pfm5MigMain to perform the migration. (ojdbc driver is not provided but can be downloaded from the website.)

        java -classpath pfmdevsvr.jar:$JEUS_HOME/lib/datasource/ojdbc14.jar com.tmax.proframe.mig.proframe4to5.Pfm5MigMain

  • Build server (source generation only)

    Provides a dedicated build server (PfmBuildSvr) that handles file-related tasks to improve the existing LogServer. To use the build server, the server-related files and server port settings must be configured. If not configured, the existing log server will operate.

    The log server must be installed by default for multi-project feature. However, the build server can be optionally installed as an extension module for improving file-handling performance.

    • Copy the build server to the log server installation directory.

      • Add TCP_PORT to pfmbuildserver.sh.

        #!/bin/sh

export LOG_EXEC_FILE=$PFMROOT/../logserver/logserver.jar
export TCP_EXEC_FILE=$PFMROOT/../logserver/pfmbuildsvr.jar
export TCP_LOG_FILE=$PFMROOT/../logserver/pfmbuildsvr.log
export TCP_ERR_FILE=$PFMROOT/../logserver/pfmbuildsvr.err
export CLASSPATH=${CLASSPATH}:$LOG_EXEC_FILE
export CLASSPATH=${CLASSPATH}:$TCP_EXEC_FILE
export TCP_PORT_NO=9718

echo ""
echo " ---------------------------"
echo " PFM BUILD SERVER BOOT START"
echo " ---------------------------"
echo ""

      • Add BLD_PORT in PfmDevSvr.xml.

        <configField id="MDS" type="subConfigField" value="true" xmlns="" >
    <subConfigField id="DATA_SOURCE" value="pfm" type="string" xmlns="" />
    <subConfigField id="LOG_IP" type="string" value="local" xmlns="" />
    <subConfigField id="LOG_PORT" type="string" value="9948" xmlns="" />
    <subConfigField id="BLD_PORT" type="string" value="9718" xmlns="" />

    • Start the build server.

      pfmbuildsvr.sh

    • Stop the build server.

      pfmbuilddown.sh

  • Feature to display file version information

    Provides the ability to view version information of each JAR file in the integrated server. Running VersionConfig in the main package of each file displays the file name, version, and build time.

    • Usage

      java -cp pfmdevsvr.jar com.tmax.proframe.VersionConfig

    • VersionConfig package

      pfmdevsvr.jar : com.tmax.proframe
logserver.jar, logviewer.jar : com.tmax.proframe.logviewer
pfmwebadmin.jar : com.tmax.proframe.devsvr
pfm_jaxb_model.jar : com.tmax.proframe.core.model
smd-c-codegen.jar : com.tmax.proframe.core.codegen
meta-schemas.jar : kr.co.tmaxsoft.proframe
pfmbuildsvr.jar : com.tmax.proframe.pfmbuildsvr

2. Changed Features

  • Unified metadata management by project

    Resolved duplicate metadata management across projects by moving metadata to a separate table (DEV_META) instead of managing it together with general resources. Metadata created before Fix#1 must be migrated using the Meta Resource Migration feature.

    • To use RI/WS functionality, synonyms must be created in the WS area database schema.

    • Query to Create the Metadata Table (DEV_META)

      CREATE TABLE DEV_META
(
    META_ID        VARCHAR2(32 BYTE)    NOT NULL,
    META_TYPE      VARCHAR2(16 BYTE),
    FIELD_TYPE     VARCHAR2(16 BYTE),
    PHYSICAL_NAME  VARCHAR2(128 BYTE),
    LOGICAL_NAME   VARCHAR2(128 BYTE),
    META_GROUP     VARCHAR2(128 BYTE),
    LENGTH         VARCHAR2(5 BYTE),
    DEFAULT_VALUE  VARCHAR2(128 BYTE),
    COMMENTS       VARCHAR2(512 BYTE),
    POINT          VARCHAR2(3 BYTE),
    IS_KEY         VARCHAR2(1 BYTE),
    IS_INDEX       VARCHAR2(1 BYTE),
    ALLOW_NULL     VARCHAR2(1 BYTE),
    DB_TYPE        VARCHAR2(16 BYTE),
    PRT_ORDER      VARCHAR2(5 BYTE)
)
ALTER TABLE DEV_META ADD (PRIMARY KEY (META_ID));

  • Enhanced integrated server logging

    Enhanced internal server logging to display the physical name or resources during CRUD operations.

  • Feature to delete resources searched from the resource pool

    Provides the ability to delete resources in the Studio resource pool search results. This feature is available only when the 'Dependencies - Independent Resources' option is selected.

  • Navigator multi-resource opening

    Improved the Navigator to allow multiple resources to be selected and opened at once.

    • Add NAVIGATOR_MULTI_SELECT_MAX_COUNT option to SiteConfig.xml to set the maximum number of resources that can be opened simultaneously.

      <!-- Multi Open ON/OFF -->
<siteElement id="NAVIGATOR_MULTI_SELECT_MAX_COUNT" type="integer" value="5" xmlns=""/>

  • Improved configuration management performance

    Improved processing speed when handling configuration management requests for multi-project.

  • Support for WebAdmin explorer

    Improved WebAdmin to operate with Internet Explorer 9 through 11.

  • Logging with handler for TCacheInvalidate in multi-node and multi-gateway Environments

    Modified console logs to be enabled or disabled using a handler for TCacheInvalidate in multi-node and multi-gateway environments.

  • Improved TCacheInvalidate processing speed

    Improved the processing speed of pfmTCacheInvalidate.

  • Duplicate resource check during restore in RIWS mode

    Added a duplicate check when restoring resources in RIWS mode. If a duplicate exists in the WS area, a confirmation dialog allows the user to proceed with or cancel the restore.

  • Improved save and compile operations for EMB resources

    Improved EMB resource save and compile operations to process tasks sequentially through a queue.

  • Improved column addition and deletion for Persist-type DBIO

    Improved Persist-type DBIO to allows columns to be added or removed by double-clicking the column name.

  • Added tab key support when defining contexts, local variables, and constants

    Improved the functionality to navigate the edit area using the tab key when defining contexts, local variables, and constants.

  • Support for DUAL table DBIO creation

    Added support for creating the system table DUAL using DBIO. (Persist type only)

3. Removed Features

  • Removed MULTI_PROJECT option

    Removed the MULTI_PROJECT option from PfmDevSvr.xml as ProFrame C 5.0 supports multi-project by default.

  • Removed the auto-configuration of ResourceID in Meta Sync

    Removed the automatic assignment of ResourceID to the physical name when using Meta Sync.

  • Removed Studio views

    Removed the Project Pool, Project Resource Pool, Project Export Manager, Project Import Manager, TestCase Export Manager, and QA views.

  • Removed Template resources

    Removed Template resources from the EMB Wizard and default resources.

  • Removed Template and UcsOnlineServer search conditions

    Removed unsupported Template and UcsOnlineServer resources from search conditions in the Resource Pool and Resource History view.

  • Removed EMB XML editing feature

    Removed XML editing feature for EMB resources to ensure data integrity.

4. Bug Fixes

  • Fixed an issue where incorrect function names are displayed when calling a function that had not been processed by tdlupdate

    Resolved an issue where the incorrect function name is output in the error log when a function that had not been updated via tdlupdate was called.

  • Fixed an issue where line breaks were generated in structure-related source code

    Resolved an issue where line break characters (^M) were generated when creating structure-related source code.

  • Fixed an issue where source generation failed due to special characters entered in DBIO query comments

    Resolved an issue where source generation was affected by special characters such as a colon (:) or single quotes (' ') entered in DBIO query comments.

  • Fixed an issue where duplicate resources were displayed during configuration management

    Resolved an issue where multiple duplicate resources were displayed when searching resources through configuration management.

  • Fixed an issue where array size changes in DBIO were not applied after module reconfiguration

    Resolved an issue where changes to the DBIO array size were not applied after reconfiguring the module. The DBIO structure array size is not automatically updated in both context definitions and source code.

  • Fixed an issue where Dynamic DBIO could not retrieve metadata value

    Resolved an issue where Dynamic DBIO failed to retrieve metadata values.

  • Fixed an error in SQL_Logging Script generation

    Resolved an issue where only the first value of the input DBIO was output when using SQL_Logging feature.

  • Fixed an issue where the Studio Batch Kind was disabled

    Resolved an issue where the Kind field was disabled in the Studio Batch Properties screen.

  • Fixed an issue occurred in Windows 7 compatibility patch

    Resolved an issue where the Studio screen became corrupted or unresponsive on Windows 7.

  • Fixed an issue where Korean users could not log in the Unit Test screen

    Resolved an issue where the Unit Test screen failed to open after login for Korean users.

  • Fixed an issue of duplicate History_id when restoring resources

    Changed numbering method of History_id to prevent duplicate History_ids when restoring resources.

  • Fixed an issue of source inconsistency after saving in Studio

    Resolved an issue where the source code in Studio and on the server became occasionally inconsistent.

  • Fixed an issue where extra spaces were repeatedly inserted when entering commands in the EMB source editor

    Resolved an issue where a certain amount of space was added when entering commands in the EMB source editor.

  • Fixed an issue where SQL_Logging failed when double quotes are included in DBIO queries

    Resolved an issue where the DBIO queries containing double quote (" ") failed to compile when using SQL Logging.

  • Fixed an issue where the query was deleted when pressing <Ctrl> + Z (Undo) for the first time in the DBIO Query input window

    Resolved an issue where the query was deleted when pressing <Ctrl>+Z (Undo) for the first time after opening DBIO types that allow direct query input (View, Execsql, Dynamicsql).

  • Fixed an issue where Invalidate was executed twice when calling TCacheInvalidate

    Resolved an issue where Invalidate was performed twice when executing TCacheInvalidate.

  • Fixed an issue where pfmTCacheItem did not function on Tmax 4.0 and Tmax 5.0 Fix#2 or later

    Resolved an issue where pfmTCacheItem failed in Tmax 4.0 and Tmax 5.0 Fix#2 or later.

  • Fixed an issue where Invalidate did not work without tpinit in multi-node environments

    Resolved an issue where Invalidate did not function in multi-node environments without tpinit.

  • Fixed an issue where TCacheInvalidate returned success when peer nodes had errors in multi-node environments

    Resolved an issue where TCacheInvalidate incorrectly returned success when one or more peer nodes had errors in a multi-node environment.

  • Fixed an issue where source generation failed when queries contain reserved keywords

    Resolved an issue where source were not generated for tables containing column names identical to the keywords.

  • Fixed an issue where resource restoration failed when RIWS was disabled

    Resolved an issue where duplicate data was inserted during resource restoration when RIWS was disabled.

  • Fixed an issue of incorrect refreshes were caused when Navigator root type is set to Group

    Resolved an issue where the resource list was incorrectly refreshed and switched to another group after compiling or saving resources when the Navigator root type was set to Group.

  • Fixed an issue where Studio login failed when encryption was enabled

    Resolved an issue where login failed in Studio when the encryption feature was enabled due to an incorrect option value.

  • Fixed an issue where the changed passwords were not encrypted when the encryption feature was enabled

    Resolved an issue where passwords changed in Studio preferences were stored in plaintext.

  • Fixed errors that occurred when mapping module IN/OUT

    Resolved an issue where the mapping feature became read-only or the module was disabled when mapping module IN/OUT.

  • Fixed errors that occurred when using variables in Array count property

    Resolved an issue where error occurred when variables were used for the Array count property in DBIO and FileIO.

  • Fixed an issue where metadata information is missing when registering metadata in DBIO editor

    Resolved an issue where type and length were missing when registering unregistered metadata in the DBIO editor.

  • Fixed an issue where the resource group information was removed during resource deletion, checkout, and check-in

    Resolved an issue where resource group information was removed during resource deletion, checkout, and check-in when RIWS is enabled. Resource group information is now removed only when no resources remain in RIWS.

  • Other Issues

    Fixed other minor issues.