Current Position:Home > Error during Compression of an InfoCube (ORA-01438)

Error during Compression of an InfoCube (ORA-01438)

Update:10-11Source: network consolidation
Advertisement
Hi all,
I am getting an error while trying to compress a request on an infocube,
I have attached the logs from the compression;
START cond CUBE BADR_C01 at 105833 on 20080606 maxreqid      2740 maxcnsid         0 refpoint update + NO NULL ELIM
The primary index on the E table was deleted
System error: ORA-01438: value larger than specified precision a
System error: llows for this column
System error: CONDENSE_FACTTABLE-5- ERROR:1438-
Collapse terminated: Data target BADR_C01, from  to                                              2740
I have searched the SDN and OSS Notes for the ORA-1438 error but cannot find anything helpful.
Has anyone else come across this during a compression.
By the way, the compression on another cube works okay, just seems to be this cube and it is the first request I am trying to compress on this cube.
We are on BW 3.5 with an Oracle DB release 9.2.0.7.0.
Points awarded for any helpful or successful answers,
Thanks,
Shane.

The Best Answer

Advertisement
Hi Viki and Shambhu,
thanks for your quick replies.
Viki, on our TableSpaces we have the following percentage used, do you know what to check?
Table Space         Percentage Used
PSAPBBP          82
PSAPBBP640     69
PSAPBBPUSR   15
PSAPTEMP        0
PSAPUNDO        60
SYSTEM             78
Shambhu, I have looked at the e table in SE11 and there is the following indexes ;
Index using Dimension BADR_C01P
Index using Dimension BADR_C01T
Index using Dimension BADR_C01U
Index using Dimension BADR_C011
Index using Dimension BADR_C012
Index using Dimension BADR_C013
Index using Dimension BADR_C014
Index using Dimension BADR_C015
Index using Dimension BADR_C016
Index using Dimension BADR_C017
Index using Dimension BADR_C018                  
Index using Dimension BADR_C019                  
Index using Dimension BADR_C01A                  
Index using Dimension BADR_C01B                  
Index using Dimension BADR_C01C                  
Non-Unique Index (Key Fields) for Table /BIC/EBADR
Is there anything else to check here???
Thanks for your help,
Shane.
  • Error during Compression of an InfoCube (ORA-01438) Update:10-11

    Hi all, I am getting an error while trying to compress a request on an infocube, I have attached the logs from the compression; START cond CUBE BADR_C01 at 105833 on 20080606 maxreqid      2740 maxcnsid         0 refpoint update + NO NULL ELIM The pr

  • Error while compression of infocube Update:10-11

    Hello, I am facing following error while compression of inventory cube ORA-04098: trigger 'SAPPW1./BI0/0500014656' is invalid and failed re-validation Request have been loaded in the ranges of posting date and those request are not getting compressed

  • Repeated SOA ORA-01438 errors in the Logs Update:10-11

    h1. ORA-01438: value larger than specified precision allowed for this column We are using below versions and we keep getting error. And our Datasource goes to Suspended state. h2. Versions h3. Weblogic: 10.3.3.0 h3. Application Server 11g SOA Patchse

  • Problem with ORA-01438. Update:10-11

    Hello, I work with Oracle Database XE and Application Express 3.0.1, I created a table named ORDERS: CREATE TABLE "ALMACEN"."ORDERS" (     "COMPRA_COD" NUMBER(15,0) NOT NULL ENABLE,      "PROVEEDOR_COD" NUMBER(10,0)

Recommended Content

  • IllegalStateException when changing display mode of JFrame
  • "Object reference not set to an instance of an object" in WAD
  • How do I use an external monitor as my only display?
  • Since the iOS7.0.2 update to my iPhone 4S, I can no longer choose use of my Bluetooth device if using the power cord to listen to MUSIC or answer my phone (choice of powercord as 'dock,' speaker,
  • HT5019 How do I get extended display mode on two monitors off a MB?
  • Docs in Cloud Not syncing between OS (10.8.2) and iOS (6)
  • How to use two ipods on the same computer
  • I can't find my ID and Password information for my AirPort Extreme, How can I recover or re-set with a new ID
  • I have just switched over to iCloud and I am now getting an error message in iCal which is the following: The server is currently unable to handle the connection due to a temporary overloading or maintenance of the server. If this continues you should con
  • Upgrade from NW 7.0 EHP1 to NW 7.3
  • TS1538 my iphone 4 isn't recognised by windows 7 ultimate pc or itunes. doesn't charge either
  • Windows XP, Itunes error on startup, NEED HELP!!!
  • HT4528 I have no battery life in my iphone 5 since the iOS 7 upgrade.  I have completed all suggestions to help increase the battery power and now I can't use my phone more than 4 hours without the battery dying. What is the solution?
  • Internet is too slow on mac osx
  • HT1386 I have a new computer with windows 8.1.  I want to add the 52 Gb of music now on my old ipod to itunes on the computer.  I don't want to wipe out the files on the ipod by syncing to the new computer which has no music files on it yet!  How can I do