SG 4.X: Error when scheduling a report

When one tries to schedule a report from ServiceGateway GUI -> Reports -> Definition . An error might be seen when saving the Schedule " An error occurred within the application server.  If the problem persists, please contact your server administrator".

 

In the sprtManaged.log or the server.log the below Exception will be logged.

 

2012-06-06 16:25:21,160 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException in method: public abstract void com.supportsoft.encore.system.ejb.schedulemanager.ScheduleManager.add(com.supportsoft.encore.system.dto.ScheduleDTO) throws com.supportsoft.encore.common.exception.InvalidParameterException,java.rmi.RemoteException, causedBy:com.supportsoft.encore.common.exception.DAOException: ORA-00001: unique constraint (ACS.SPRT_EC_SCHEDULE_PK) violated 

 

 

The schedules will be created in the Database table "SPRT_EC_REPORT_JOB". The EC_JOB_ID  and ID values needs to match.

 

select ID,EC_JOB_ID,EC_REPORT_GUID from SPRT_EC_REPORT_JOB;

 

If there is a mismatch in the above two values as shown below, 

 

        ID  EC_JOB_ID EC_REPORT_GUID
---------- ---------- ------------------------------------
      1001       1001 73178a10-d6a3-11df-9cd9-c5c5f9a6d922
      1051       1042 747de6e2-123c-11df-b095-7d1cec251baa

We need to manually increment the EC_JOB_ID table values. This can achieved by calling the "Sequence" SPRT_EC_JOB_SEQ.NEXTVAL

 

The query to be used is as below

 

select SPRT_EC_JOB_SEQ.NEXTVAL from dual

 

Execute the above the sql statement multiple times, till the EC_JOB_ID matches with the ID field.