PM69831: ERROR "COMEXCEPTION (0X80040E14): ORA-00932: INCONSISTENT DATATYPES: EXPECTED DATE GOT NUMBER"

APAR status

• Closed as program error.

Error description

• Customer upgraded from Controller 8.1 to Controller 10.1.1 and
  is receiving the following:????Number:    5??Source:
  FrangoDirect.CopyValuesD.CompJouBetweenPerVer#ControllerProxyCli
  ent??Description:
     System.Web.Services.Protocols.SoapException: Server was
  unable to process request. --->
  System.Runtime.InteropServices.COMException (0x80040E14):
  ORA-00932: inconsistent datatypes: expected DATE got NUMBER??
  at FrCopyValuesBT.CopyValuesTClass.CopyValues(String sPrg,
  Recordset rsComp, Recordset rsCurrType, Recordset rsBtyp,
  Recordset rsPerakt, Boolean bOB, Boolean bLog, String sGuid,
  String sUser, Boolean bAllJournalTypes, Boolean bForceCopy,
  String sPerAkt, String sFrPerAkt, String sToPerakt, String
  sFrBol, String sToBol, Boolean bSignChange, Int32& lRetValue,
  Recordset rsVkod, Boolean bIncludeSubGroups, String sConsType,
  Int32& lErrorCode, String& sErrorMsg)??   at
  Cognos.Controller.Proxy.CCRWS.CopyValuesT_CopyValues(String
  sPrg, DataSet rsComp, DataSet rsCurrType, DataSet rsBtyp,
  DataSet rsPerAkt, Boolean bOB, Boolean bLog, String sGuid,
  String sUser, Boolean bAllJournalTypes, Boolean bForceCopy,
  String sPerakt, String sFrPerAkt, String sToPerakt, String
  sFrBol, String sToBol, Boolean bSignChange, Int32& lRetValue,
  DataSet rsVkod, Boolean bIncludeSubGroups, String sConsType,
  Int32& lErrorCode, String& sErrorMsg)??   --- End of inner
  exception stack trace ---??   at
  Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object
  Source, Object Description, Object HelpFile, Object
  HelpContext)??   at
  Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo,
  String sErrSource, String sErrDesc, String sErrHelpFile, Int32
  lErrHelpContext)??   at
  Cognos.Controller.Direct.CopyValuesD.CompJouBetweenPerVer(DataSe
  t
  rsComp, DataSet rsCurrType, DataSet rsBtyp, Boolean bOB, Boolean
  bLog, Boolean bAllJournalTypes, Boolean bForceCopy, String
  sFrPerAkt, String sToPerAkt, Int32& lRetValue, Int64&
  lErrorCode, String& sErrorMsg)??   at
  Cognos.Controller.Forms.Form.frmCopyCompJourPeriod.IRun_DoRun()?
  ???
  The VB Application identified by the event source logged this
  Application FrCopyValuesBT: Thread ID: 5356 ,Logged: Error
  occured at 7/20/2012 2:54:07 PM in FrCopyValuesBT, Error
  No=-2147217900, Source=FrCopyValuesBT.CopyValuesT.CopyValues,
  Description=ORA-00932: inconsistent datatypes: expected DATE got
  NUMBER, HelpFile= HelpContext=0????????
  

Local fix

• Please contact customer support.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM  Cognos Controller 10.1.1 FP1                 *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG CONTROLLER

• Fixed component ID

  5724W24CO

Applicable component levels