There is already an object named 'ossys_Publishing' in the database.

There is already an object named 'ossys_Publishing' in the database.

  
Hi,

I am trying upgrade the platform server from V8 to V9, but I get the following errors when I click on "Create/Upgrade Database":

Error 1:
RoleName
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at #aDb.#9Cb.get_Item(String name)
   at OutSystems.HubEdition.ConfigurationTool.DBConfigurationToolSqlServer.GetCurrentUserInformation(Transaction trans)
   at OutSystems.HubEdition.ConfigurationTool.DBConfigurationToolSqlServer.GetHubServerVersion(Transaction trans)

Error 2:

System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'ossys_Publishing' in the database.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at OutSystems.HubEdition.Extensibility.Data.ExecutionService.BaseExecutionService.ExecuteNonQuery(IDbCommand cmd)
   at OutSystems.Internal.Db.Command.ExecuteNonQuery(String description, Boolean isApplication, Boolean skipLog, Boolean applyTransformationsToParameters)
   at OutSystems.HubEdition.ConfigurationTool.DBConfigurationTool.ExecutePreprocessedStatement(DatabaseAccessProvider`1 dbAccess, Transaction trans, String statement, ActionType action)
   at OutSystems.HubEdition.ConfigurationTool.DBConfigurationTool.ExecuteSqlStatement(DatabaseAccessProvider`1 dbAccess, Transaction trans, String statement, ActionType action)
ClientConnectionId:a0535660-9230-40fe-ab4f-2ee812ca4321
Error Number:2714,State:6,Class:16
SQL statement:
CREATE TABLE [dbo].[ossys_Publishing](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [VERSION_ID] [int] NULL DEFAULT (null),
    [PUBLISHED_BY] [int] NULL DEFAULT (null),
    [PUBLISHED_DATE] [datetime] NULL DEFAULT ('1900-01-01 00:00:00'),
    [HUBSERVERVERSION] nvarchar(50) NULL DEFAULT (''),
) ON [PRIMARY]

Error 3:

Database Error: Database error - There is already an object named 'ossys_Publishing' in the database.
   at OutSystems.HubEdition.ConfigurationTool.DBConfigurationTool.ExecuteSqlStatement(DatabaseAccessProvider`1 dbAccess, Transaction trans, String statement, ActionType action)
   at OutSystems.HubEdition.ConfigurationTool.Schema.#Sef(DatabaseAccessProvider`1 dbAccess, Transaction trans, ActionType action, Boolean automaticMode, IPlatformDatabaseConfiguration config, IPlatformConfigurationManager manager)
   at #7df.#jff.#Sef(DatabaseAccessProvider`1 dbAccess, Boolean hasDatabaseConfiguration)


Someone can help?

Thanks,
Pedro

Hello Pedro,

Did you solve the issues you have mentioned?

If you require further assistance for this issue, I would suggest contacting us at OutSystems Support.

Best regards,
Daniel Martins
Hi Daniel,

The issue has already been reported to support.

Thanks,
Pedro