Could not create index on 'SS_KEY

Could not create index on 'SS_KEY

  

===== 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.

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.

Hey Pavel,


Did you find a solution for this?

Was a matter of permissions?



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.


Hi,

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


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...