437
Views
7
Comments
Could not create index on 'SS_KEY
Question

===== Restarting OutSystems Services =====

 

Stopping RMI Registry Service                              [  OK  ]

Stopping OutSystems Deployment Controller Service          [  OK  ]

Stopping OutSystems Deployment Service                     [  OK  ]

Stopping OutSystems Log Service                            [  OK  ]

Stopping OutSystems Scheduler Service                      [  OK  ]

Starting RMI Registry Service                              [  OK  ]

Starting OutSystems Deployment Controller Service          [????????!]

Starting OutSystems Deployment Service                     [  OK  ]

Starting OutSystems Log Service                            [  OK  ]

Service Center Installer v10.0.604.0

 

Start installing Service Center v10.0.604.0...

This operation may take a few minutes to complete...

 

Publishing Extension(s)...

Publishing Extension 'OMLProcessor'...

Publishing Extension 'IntegrationStudio'...

Reading ServiceCenter.oml oml file information...

Adding ServiceCenter eSpace to database...

Compiling ServiceCenter eSpace...

 

Preparing ServiceCenter eSpace deployment...

Deploying ServiceCenter eSpace...

Message 2

  [Error] Upgrade Error

Could not create index on 'SS_KEY,PRODUCER_SS_KEY,KIND,CONSUMER_VERSION_ID' of entity 'Espace_Reference'.


configurationtool.sh make the same result.

Tryed to drop and recreate oracle DB from scratch. Nothing helps.

mvp_badge
MVP
Rank: #6

Hello Pavel,

I would say that this is a matter for the OutSystems support.Out of curiosity, are you trying to update from wich version?

Also, are you following correctly all the steps in the Checklist?

Cheers.

Rank: #167

Hey Pavel,


Did you find a solution for this?

Was a matter of permissions?



Rank: #44421

Raphael Ranieri wrote:

Hey Pavel,


Did you find a solution for this?

Was a matter of permissions?



Yep, whole thing was about latest oracle release, switched to minor older ver of DB.


Rank: #27236

Hi,

Which version of Oracle are you using now? We have the same problem with Oracle 12c R2...


Rank: #23252

Paul van Hoof wrote:

Hi,

Which version of Oracle are you using now? We have the same problem with Oracle 12c R2...


I was facing the same problem with Oracle 12c R2 for many days without understanding why as i hadn't found a single solution for this problem...

At last I had solved my problem...

The problem was about DB_BLOCK_SIZE.  In Oracle 12c R2 , the default DB_BLOCK_SIZE is 8K.

It was necessary to change the tablespace's block size to 16K when you run 3 scripts for creating several tablespaces. Just for example:

CREATE TABLESPACE OSSTATE
    LOGGING
    DATAFILE 'OUTSYSTEMS_STATEDATA01.dbf'
    SIZE 50M AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO BLOCKSIZE 16K;


In the checkList ,it is also written,

•When creating the database in Oracle 12c R2, make sure the block size is set to:
      - at least 8KB, if you have patch 27079651 applied to your Oracle Database Server
      - at least 16KB, otherwise (Oracle bug 26933770)


Hope it helps...


Rank: #33324

Alam, you saved my day! Thank you so much!!!


Daniel (FICO)


Paul van Hoof wrote:

Hi,

Which version of Oracle are you using now? We have the same problem with Oracle 12c R2...


I was facing the same problem with Oracle 12c R2 for many days without understanding why as i hadn't found a single solution for this problem...

At last I had solved my problem...

The problem was about DB_BLOCK_SIZE.  In Oracle 12c R2 , the default DB_BLOCK_SIZE is 8K.

It was necessary to change the tablespace's block size to 16K when you run 3 scripts for creating several tablespaces. Just for example:

CREATE TABLESPACE OSSTATE
    LOGGING
    DATAFILE 'OUTSYSTEMS_STATEDATA01.dbf'
    SIZE 50M AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO BLOCKSIZE 16K;


In the checkList ,it is also written,

•When creating the database in Oracle 12c R2, make sure the block size is set to:
      - at least 8KB, if you have patch 27079651 applied to your Oracle Database Server
      - at least 16KB, otherwise (Oracle bug 26933770)


Hope it helps...




Rank: #11783

Hi all,

I'm facing the same issue, but in MSSQL server when upgrading from OS 10 to 11. 

Couldn't able to find any solution related to MSSQL.

[Error] Upgrade Error

Could not create index on 'SS_KEY,PRODUCER_SS_KEY,KIND,CONSUMER_VERSION_ID' of entity 'Espace_Reference'.

Kindly help.