Perform the following preparation tasks:
To run the application in backward-compatible mode, use the customer_overrides.properties file to set the following properties:
Table 1 lists the LONG columns that can be migrated to CLOB.
Table | Column |
---|---|
YFS_SUB_FLOW | CONFIG_XML |
YFS_REPROCESS_ERROR | MESSAGE |
INTEROP_ERROR_DISPATCH | MESSAGE |
YFS_GRAPH_UI | GRAPH_XML |
YFS_INBOX | INBOX_ADDNL_DATA |
YFS_AGENT_CRITERIA_TEMPLATE | MESSAGE_XML |
YFS_AGENT_CRITERIA | MESSAGE_XML |
YFS_BASE_DOCUMENT_TEMPLATE | TEMPLATE_XML |
YFS_DOCUMENT_PARAMS | DOCUMENT_PARAMS |
YFS_HM_THRESHOLDS | ADDITIONAL_INFO |
YFS_QUERY | QUERY_DEFINITION |
YFS_EXPORT | MESSAGE |
YFS_IMPORT | MESSAGE |
YFS_SAVED_SEARCH | SEARCH_DATA |
YFS_AUDIT | AUDIT_XML |
YFS_TRANSACTION_DEPENDENCY | TEMPLATE_XML |
YFS_ORDER_AUDIT_DETAIL | AUDIT_XML |
YFS_DEVICE | DEVICE_PARAMS_XML |
YFS_DEVICE_TYPE_TEMPLATE | DEVICE_TYPE_PARAMS_XML |
YFS_BATCH | REQ_BATCH_COMPLETION_XML |
YCS_MANIFEST_UPS_DTL | INPUT_XML |
YFS_ASYNC_REQ | MESSAGE |
YFS_BASE_DOCUMENT_PARAMS | DOCUMENT_PARAMS |
YFS_DOCUMENT_TEMPLATE | TEMPLATE_XML |
Run this script for all JARs in the <INSTALL_DIR>/extensions/${extension.root}/jars directory, too.
For Windows:<INSTALL_DIR>\bin\tmp.cmd
Here, <DBDRIVER> points to the dbdriver JARs located in the <INSTALL_DIR>\dbjar\jdbc\<DB> directory.
For Linux: <INSTALL_DIR>\bin\tmp.sh
Here, <DBDRIVER> points to the dbdriver JARs located in the <INSTALL_DIR>\dbjar\jdbc\<DB> directory.
Refer to the jdbc.properties file for the values of <jdbc url>, <user> and <passwd>.
This provides a list of all the columns whose lengths must be taken into consideration when building dbclasses for the prepared statements to function correctly. This requires all the CHAR fields to be padded to their column length.
<Customer CustomerKey="">
<CustomerAnalytics GradeCode=""/>
</Customer>