My Oracle Support Banner

H2H Execution fails on Partitioned Target Tables (Doc ID 2718220.1)

Last updated on OCTOBER 13, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7.4 version


ACTUAL BEHAVIOR
-----------------------
After upgrading to 8074, H2H execution fails.

EXPECTED BEHAVIOR
-----------------------
H2H execution should be successful.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1.Define a H2H where source table is not partitioned and target table is partitioned.

2.As mentioned in section 4.4.1.10 Handling Partitioned Target Tables of https://docs.oracle.com/cd/E60058_01/PDF/8.0.7.x/8.0.7.0.0/OFSAAI_User_Guide_8.0.7.0.0.pdf

If you need to enable dynamic partition in non-strict mode, set the below property as a Prescript in the Data Mapping window:

"set hive.exec.dynamic.partition.mode=nonstrict"

3.execute H2H, it fails with below error:

org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: SemanticException [Error 10096]: Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, H2H execution will not be successful.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.