PabloMC

Problem with Load Data Warehouse

Discussion created by PabloMC on Nov 10, 2017
Latest reply on Feb 23, 2018 by PabloMC

Hi there, we are running a fresh environment on the SaaS 15.2, and setting thing up on the job Load Data Warehouse we got the following issue:

 

ClarityDB - isOracle? - An error occurred executing this job entry :  Couldn't execute SQL: BEGIN  CMN_GATHER_TABLE_STATS_SP( 'DWH_CMN_PERIOD' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_FIN_BENEFIT_PLAN' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_FIN_PLAN' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_INV_ASSIGNMENT' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_INV_INVESTMENT' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_INV_TASK' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_INV_TEAM' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_RES_RESOURCE' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_TME_SHEET' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_TME_ENTRY' ,100); CMN_GATHER_TABLE_STATS_SP( 'DWH_TME_PERIOD' ,100);  UPDATE DWH_CFG_AUDIT SET DW_LOAD_START_DATE = (SELECT SYSDATE FROM DUAL@SC51951dDWH_SC51951d) WHERE TABLE_NAME = 'DWH_INV_TASK_HIERARCHY'; DWH_INV_TASK_HIERARCHY_SP( P_DBLINK => 'SC51951dDWH_SC51951d',P_ARRAY_SIZE => 50000); UPDATE DWH_CFG_AUDIT SET DW_LOAD_END_DATE = (SELECT SYSDATE FROM DUAL@SC51951dDWH_SC51951d) WHERE TABLE_NAME = 'D

We check and its seams okey the configuration, also on health report, the database is giving a object error value 46, dont know the meaning.

thanks in advance!
Pablo

Outcomes