DV Tool Dataflow Fails at Join Step

prasannasrinivasan gnanasekaran

Summary

DV Tool Dataflow Fails at Join Step

Content

I am joining to 2 queries (data sets) using Data Flow.

Join step fails with generic error.However no error on data sets.

Error Message

"It looks like we did something wrong. Please try again, but if the problem persists know that we are trying hard to make the product perfect."

 

Please let me know how to fix the issue .

 

Thanks

Prasanna

 

 

 

FPonte

Hi Prasannasrinivasan

Are you able to share the entire error message with us, please?

Cheers

Fernando

prasannasrinivasan gnanasekaran

HI

Posting the entire error log,

Error occurred while processing the query.
select InputDataset_0."ITEM_NUMBER" as "ITEM_NUMBER", InputDataset_0."ATTR_NAME" as "ATTR_NAME", InputDataset_0."VAL" as "VAL", InputDataset_0."ORG_CODE" as "ORG_CODE", InputDataset_1."ITEM_NUMBER" as "ITEM_NUMBER_1",
InputDataset_1."ATTR_GROUP_NAME" as "ATTR_GROUP_NAME", InputDataset_1."ATTR_NAME" as "ATTR_NAME_1", InputDataset_1."ORG_COUNT" as "ORG_COUNT", InputDataset_1."NUM_COUNTNOTNULL" as "NUM_COUNTNOTNULL",
 InputDataset_1."NUM_COUNTNULL" as "NUM_COUNTNULL", InputDataset_1."COUNT_NOTNULL" as "COUNT_NOTNULL", InputDataset_1."COUNT_NULL" as "COUNT_NULL", InputDataset_1."PCT_NULL" as "PCT_NULL", InputDataset_1."PCT_NOTNULL" as "PCT_NOTNULL"
from (select XSA('weblogic'.'ItmOrgQry2').input."Data"."ITEM_NUMBER" as "ITEM_NUMBER", XSA('weblogic'.'ItmOrgQry2').input."Data"."ATTR_NAME" as "ATTR_NAME", XSA('weblogic'.'ItmOrgQry2').input."Data"."VAL" as "VAL", XSA('weblogic'.'ItmOrgQry2').input."Data"."ORG_CODE" as "ORG_CODE"
from XSA('weblogic'.'ItmOrgQry2').input."Data") InputDataset_0 inner join (select XSA('weblogic'.'ItmOrgQry1').input."Data"."ITEM_NUMBER" as "ITEM_NUMBER", XSA('weblogic'.'ItmOrgQry1').input."Data"."ATTR_GROUP_NAME" as "ATTR_GROUP_NAME", XSA('weblogic'.'ItmOrgQry1').input."Data"."ATTR_NAME" as "ATTR_NAME", XSA('weblogic'.'ItmOrgQry1').input."Data"."ORG_COUNT" as "ORG_COUNT", XSA('weblogic'.'ItmOrgQry1').input."Data"."NUM_COUNTNOTNULL" as "NUM_COUNTNOTNULL", XSA('weblogic'.'ItmOrgQry1').input."Data"."NUM_COUNTNULL" as "NUM_COUNTNULL", XSA('weblogic'.'ItmOrgQry1').input."Data"."COUNT_NOTNULL" as "COUNT_NOTNULL", XSA('weblogic'.'ItmOrgQry1').input."Data"."COUNT_NULL" as "COUNT_NULL", XSA('weblogic'.'ItmOrgQry1').input."Data"."PCT_NULL" as "PCT_NULL", XSA('weblogic'.'ItmOrgQry1').input."Data"."PCT_NOTNULL" as "PCT_NOTNULL"
from XSA('weblogic'.'ItmOrgQry1').input."Data") InputDataset_1 on InputDataset_0."ITEM_NUMBER" = InputDataset_1."ITEM_NUMBER" and InputDataset_0."ATTR_NAME" = InputDataset_1."ATTR_NAME" FETCH FIRST 30 ROWS ONLY

 

Thanks

prasanna

 

FPonte

Hi Prasannasrinivasan.

I was expecting to see some extra information on that error.

Questions:

Are the attributes in the JOIN of the same data type? If they are not maybe is necessary to add an additional step to make them to be of the same data type.

Are you able to run a Data Flow for each one of the files in its entirety with no errors?

Cheers

Fernando

prasannasrinivasan gnanasekaran

HI Fernando,

Join attributes data type is same.

I am able to run the data flow just by keeping 1 data set with filter conditions other than join it is working without error.

Thanks
Prasanna

FPonte

Hi Prasanna.

Please try to run this and check the logs for some more detailed error information.

https://blogs.oracle.com/analyticscloud/4-steps-to-oracle-data-visualization-diagnostics-support

Cheers

Fernando