EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB39213: "[Oracle]ORA-01658: unable to create INITIAL extent for segment in tablespace" error received when trying to create Statistics tables in MicroStrategy 9.x and 10.x


Community Admin

• Strategy


"[Oracle]ORA-01658: unable to create INITIAL extent for segment in tablespace" error received when trying to create Statistics tables in MicroStrategy 9.x and 10.x

SYMPTOM:
When creating statistics tables in an Oracle database in Strategy 9.x and 10.x, an error message similar to the one shown below appears. The error can be received during the creation of other statistics tables also.
 


ORA-01658: unable to create INITIAL extent for segment in tablespace 
MSTR_META_DATA Connection String: DSN=Production META;UID=MSTR;SRVR=MS;. 
SQL Statement: CREATE TABLE IS_REP_STEP_STATS(
DAY_ID                 DATE NOT NULL,
HOUR_ID                             NUMBER NOT NULL,
MINUTE_ID        FLOAT NOT NULL,
JOBID                    NUMBER(10) NOT NULL,
STEPSEQUENCE                NUMBER(10) NOT NULL,
SESSIONID          CHAR(32) NOT NULL,
SERVERID            CHAR(32) NULL,
STEPTYPE             NUMBER(10) NULL,
STARTTIME         DATE  NOT NULL ,
FINISHTIME        DATE NULL ,
QUEUETIME       FLOAT NULL ,
CPUTIME                             FLOAT NULL ,
STEPDURATION                FLOAT NULL ,
RECORDTIME     DATE NULL,
SERVERMACHINE             VARCHAR2(768) NULL,
PROJECTID          CHAR(32) NULL,
PRIMARY KEY     (SESSIONID, JOBID,STEPSEQUENCE)
)
PARTITION BY RANGE (DAY_ID)
SUBPARTITION BY HASH(StepType) subpartitions 25 
(
PARTITION P_1 VALUES LESS THAN (TO_DATE('01-01-2001', 'DD-MM-YYYY')),
PARTITION P_2 VALUES LESS THAN (TO_DATE('01-02-2001', 'DD-MM-YYYY')),
PARTITION P_3 VALUES LESS THAN (TO_DATE('01-03-2001', 'DD-MM-YYYY')),
PARTITION P_4 VALUES LESS THAN (TO_DATE('01-04-2001', 'DD-MM-YYYY')),
................
................
PARTITION P_172            VALUES LESS THAN (TO_DATE('01-04-2015', 
'DD-MM-YYYY')),
PARTITION P_173            VALUES LESS THAN (TO_DATE('01-05-2015', 
'DD-MM-YYYY')),
PARTITION P_174            VALUES LESS THAN (TO_DATE('01-06-2015', 
'DD-MM-YYYY')),
PARTITION P_175            VALUES LESS THAN (TO_DATE('01-07-2015', 
'DD-MM-YYYY')),
PARTITION P_176            VALUES LESS THAN (TO_DATE('01-08-2015', 
'DD-MM-YYYY')),
PARTITION P_177            VALUES LESS THAN (TO_DATE('01-09-2015', 
'DD-MM-YYYY')),
PARTITION P_178            VALUES LESS THAN (TO_DATE('01-10-2015', 
'DD-MM-YYYY')),
PARTITION P_179            VALUES LESS THAN (TO_DATE('01-11-2015', 
'DD-MM-YYYY')),
PARTITION P_180            VALUES LESS THAN (TO_DATE('01-12-2015', 
'DD-MM-YYYY')),
PARTITION P_MAX  VALUES LESS THAN(MAXVALUE)
).
2012-01-20 14:30:10.008-05:00 ConfigManager::GetServerDefSetting(): 
ServerDef not initialized: Long SettingId=75.”

 
CAUSE:
This is caused by insufficient contiguous table space in the database.
 
ACTION:
Add additional space to the tablespace and attempt to recreate the statistics tables.
 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

June 6, 2017