Mobile Workforce Management End of Day (EOD) Does Not Complete or Process Completes With Errors Due to ODBC Driver Configuration (Doc ID 727983.1)

Last updated on MARCH 03, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version: 1.3 to 1.5.0 - Release: 1.3 to 1.5
Information in this document applies to any platform.

Symptoms

We have seen EOD run but not complete the full process.  In this case, older orders remain in the system and continue to display on the Gantt.  Also, we have seen the End Of Day (EOD) process generate the error message "EOD has completed but with errors" occur several times a week. EOD appears to actually complete without any issues.  This appears to be a problem with how the Oracle Database may have been installed on the new server.

Server log file errors may appear as:

INFO|18:29:18|3936|Error occurred during archiving of field orders. (CServerDlg:
:WriteAuditMessage)

INFO|18:29:18|1992|Sending ICD 128 to C100971 (XIpcClientProxy::Write)

INFO|18:29:18|1992|SOCKET DEBUG...Before Send of ICD [Hdr: ID=128, Len=368, Ver=
2, Time=10-Jun-08 18:29:18,SourceNetName=Server, Dest=, Ack= , Pri=0, VarKey=] (
XIpcClientSocketBase::Write)

INFO|18:29:18|3936|Error occurred during archiving of field orders. (XThreadSvEo
d::ArchiveFieldOrders) / Error occurred deleting archived field orders from hist
ory database tables. (XThreadSvEod::ArchiveFieldOrders)/ Database exception occu
rred (XDbAccessBase::DeleteArchivedOrders) / Error=ORA-01013: user requested can
cel of current operation (XDbAccessBase::DeleteArchivedOrders) / State Native Or
igin=State:S1T00,Native:1013,Origin:[Oracle][ODBC][Ora] (XDbAccessBase::DeleteAr
chivedOrders) / Return code = -1 (XDbAccessBase::DeleteArchivedOrders) (::)

-- Steps To Reproduce:
Run EOD.

-- Business Impact:
The End of Day process seems to be completing but with errors.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms