AnsweredAssumed Answered

Jasper Soft Load Data Warehouse Failing

Question asked by Sai95 on Jul 28, 2017
Latest reply on Aug 1, 2017 by Sai95

Hello All,

Greetings!!!

 

I have a problem, as the Jasper Soft Load Data Warehouse (Daily; 4:00a CT) is failing daily.

It is failing with an error message as below.

I am not sure on next steps of this. Any suggestions would help a lot.

dwh_db_check_ - An error occurred executing this job entry :  Couldn't execute SQL: BEGIN RPT_CALENDAR_SP(); RPT_INV_HIERARCHY_SP(); END; [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "SC51339T.RPT_CALENDAR_SP", line 330 ORA-06512: at line 2

I verified the bg-log and it shows thr info as follows:-

2017/07/22 04:00:06 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2017/07/22 04:00:06 - dwh_db_check_ - Couldn't execute SQL: BEGIN
2017/07/22 04:00:06 - dwh_db_check_ - RPT_CALENDAR_SP();
2017/07/22 04:00:06 - dwh_db_check_ - RPT_INV_HIERARCHY_SP();
2017/07/22 04:00:06 - dwh_db_check_ - END;
2017/07/22 04:00:06 - dwh_db_check_ -
2017/07/22 04:00:06 - dwh_db_check_ - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
2017/07/22 04:00:06 - dwh_db_check_ - ORA-06512: at "SC51339T.RPT_CALENDAR_SP", line 330
2017/07/22 04:00:06 - dwh_db_check_ - ORA-06512: at line 2
2017/07/22 04:00:06 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2017/07/22 04:00:06 - dwh_db_check_ - Couldn't execute SQL: BEGIN
2017/07/22 04:00:06 - dwh_db_check_ - RPT_CALENDAR_SP();
2017/07/22 04:00:06 - dwh_db_check_ - RPT_INV_HIERARCHY_SP();
2017/07/22 04:00:06 - dwh_db_check_ - END;
2017/07/22 04:00:06 - dwh_db_check_ -
2017/07/22 04:00:06 - dwh_db_check_ - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
2017/07/22 04:00:06 - dwh_db_check_ - ORA-06512: at "SC51339T.RPT_CALENDAR_SP", line 330
2017/07/22 04:00:06 - dwh_db_check_ - ORA-06512: at line 2
2017/07/22 04:00:06 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2017/07/22 04:00:06 - dwh_db_check_ - Couldn't execute SQL: BEGIN
2017/07/22 04:00:06 - dwh_db_check_ - RPT_CALENDAR_SP();
2017/07/22 04:00:06 - dwh_db_check_ - RPT_INV_HIERARCHY_SP();
2017/07/22 04:00:06 - dwh_db_check_ - END;
2017/07/22 04:00:06 - dwh_db_check_ -
2017/07/22 04:00:06 - dwh_db_check_ - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
2017/07/22 04:00:06 - dwh_db_check_ - ORA-06512: at "SC51339T.RPT_CALENDAR_SP", line 330
2017/07/22 04:00:06 - dwh_db_check_ - ORA-06512: at line 2

 

 

Thanks and Regards,

Sai.

Outcomes