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.