Guest

Preview Tool

Cisco Bug: CSCuj63436 - Archive (Enterprise) Service - runs/logs errors, deployment is std MSSQL

Last Modified

Nov 24, 2015

Products (1)

  • Cisco Unified E-Mail Interaction Manager

Known Affected Releases

9.0(1) 9.0(2) 9.0(3)

Description (partial)

Symptom:
Customer is concerned with Archive failure logs:
com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'egpl_arch_add_new_partn'

MSSQL standard version deployment generates below errors in log. As per specification, this service should run only on Enterprise version and not on standard version.

2013-09-11 21:36:50.857 GMT-0400 <@> ERROR <@> [30:ArchiveEEExecutor id : 0] <@> ProcessId:10592 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> com.egain.platform.framework.dataaccess.DataAccess <@> executeStoredProc() <@> I18N_EGPL_DATAACCESS-SQLEXCEPTION_WHILE_EXECUTING_QUERYCould not find stored procedure 'egpl_arch_add_new_partn'. <@> 
com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'egpl_arch_add_new_partn'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
at com.egain.platform.framework.dataaccess.dbconnectionfactory.PreparedDBStatement.executeUpdate(PreparedDBStatement.java:39)
at com.egain.platform.framework.dataaccess.dbconnectionfactory.CallableDBStatement.executeUpdate(CallableDBStatement.java:25)
at com.egain.platform.framework.dataaccess.DataAccess.executeUpdateWithTimeoutCheck(DataAccess.java:6212)
at com.egain.platform.framework.dataaccess.DataAccess.executeStoredProc(DataAccess.java:2798)
at com.egain.platform.framework.dataaccess.DataAccess.executeStoredProc(DataAccess.java:2660)
at com.egain.platform.framework.dataaccess.DataAccess.executeStoredProc(DataAccess.java:2617)
at com.egain.platform.module.eearchive.service.ArchiveEEProcess.performStep(ArchiveEEProcess.java:530)
at com.egain.platform.module.eearchive.service.ArchiveEEExecutor.startInstance(ArchiveEEExecutor.java:103)
at com.egain.platform.framework.dsm.common.ThreadPool$PoolThread.run(ThreadPool.java:103)

Following statement is seen in installation logs egpl_dbSchema_mssql.log which clears that startup type automatic is set at the time of installation for that service.

INSERT INTO EGPL_DSM_PROCESS (PROCESS_ID, PROCESS_NAME, DESCRIPTION, SERVICE_ID, STARTUP_TYPE, FAIL_OVER, INTERVAL, MAX_INSTANCES, STATE, SERVICE_TYPE) VALUES ( 1013,'archive-enterprise-process','Archive (Enterprise) Process',1013,1,1,30000,1,4,1002)

Conditions:
This issue appears when a Microsoft SQL Server Standard Edition is used for an integrated CIM installation.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.