ORA-36863: (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.

Cause : Invalid COLUMNMAP syntax.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Check the syntax of the column map. Normally, users should not call OLAP Random Access Cursor table function themselves and therefore should not encounter this error.

update : 24-05-2017

ORA-36863 - (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
ORA-36863 - (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.

  • ora-07210 : slcpu: getrusage error, unable to get cpu time.
  • ora-19224 : XP0004 - XQuery static type mismatch: expected - string got - string
  • ora-27126 : unable to lock shared memory segment in core
  • ora-13771 : cannot obtain exclusive lock string on "SQL Tuning Set" "string" owned by user "string"
  • ora-31686 : error creating worker processes
  • ora-06007 : NETASY: bad dialogue format
  • ora-22891 : cannot have multiple columns in REF constraint
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-28116 : insufficient privileges to do direct path access
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-09871 : TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.
  • ora-09919 : Unable to set label of dedicated server
  • ora-28276 : Invalid ORACLE password attribute.
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-31221 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.
  • ora-01051 : deferred rpc buffer format invalid
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • ora-00741 : logfile size of (string) blocks exceeds maximum logfile size
  • ora-04079 : invalid trigger specification
  • ora-24129 : table name string does not start with string prefix
  • ora-30553 : The function is not deterministic
  • ora-27156 : request for process information failed
  • ora-01866 : the datetime class is invalid
  • ora-16116 : no work available
  • ora-25263 : no message in queue string.string with message ID string
  • ora-22055 : unknown sign flag value [string]
  • ora-12699 : Native service internal error
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.