PM53311: ORACLE DATABASE IMPORT FLAT FILE ERROR MESSAGE:(0X800A0005): INVALID PROCEDURE CALL OR ARGUMENT

APAR status

• Closed as program error.

Error description

• Controller 10.1?Controller Application Server : ?OS : Windows
  2008 Enterprise R2??Oracle 11G R2?Oracle Database Server :?OS :
  Red Hat Enterprise Linux 5.7 64bit with Oracle 11G
  R2??Patch10100100 installed on Controller application server.
  ??Error message occurred when trying import flat file in
  controller. ??Controller show:?(0x800A0005): Invalid procedure
  call or argument??The event viewer log showing Source=FrSrvFunc,
  Description=Invalid use of Null,
  

Local fix

• Onálinuxáweágetá6áexactádecimalsáfromátheásystimestampáfunction,
  ábutáonáwindowsáweágetá6ádecimalsáwithátheálastáthreeádecimalsáa
  sázeros.
  
  Aáworkaroundátoáthisáisátoáchangeátheátableádefinitionáonáxhappe
  ningáto:
  alterátableáxhappeningá
  modifyáccrtimestampátimestamp(6)
  

Problem summary

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

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