23
Views
3
Comments
Outsystems 10 configuration tool database migration
Question
Platform Version
10.0.1104.0

Hi,

I plan to migrate the os10 production to a new vm server and new 19c database.

I encountered error when doing fresh os10 installation and connect to the production migrated clone database 19c.


The fresh installation is in windows server 2019. The database is cloned from existing os10 database 11g. I have done the migration database steps.




2020-12-10 17:30:47.2781 [1748] [ERROR] SELECT VAL FROM OSSYS_PARAMETER PARAMETER WHERE UPPER(NAME)=:PARMNAME AND UPPER(HOST_SERIAL) = :HOSTSERIAL


2020-12-10 17:30:47.2781 [1748] [ERROR] Retrieving Parameter IIS.DefaultApplicationPool


2020-12-10 17:30:47.2781 [1748] [ERROR] ORA-00942: table or view does not exist


2020-12-10 17:30:47.2781 [1748] [ERROR] [1] Oracle.ManagedDataAccess.Client.OracleException


2020-12-10 17:30:47.2781 [1748] [ERROR] Target : OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution


2020-12-10 17:30:47.2781 [1748] [ERROR] Source : Oracle Data Provider for .NET, Managed Driver


2020-12-10 17:30:47.2781 [1748] [ERROR] Message : ORA-00942: table or view does not exist


2020-12-10 17:30:47.2781 [1748] [ERROR] Stack Trace


2020-12-10 17:30:47.2781 [1748] [ERROR] at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)


2020-12-10 17:30:47.2781 [1748] [ERROR] at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)


2020-12-10 17:30:47.2781 [1748] [ERROR] at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)


2020-12-10 17:30:47.2781 [1748] [ERROR] at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)


2020-12-10 17:30:47.2781 [1748] [ERROR] at OutSystems.HubEdition.DatabaseProvider.Oracle.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)


2020-12-10 17:30:47.2781 [1748] [ERROR] at OutSystems.HubEdition.DatabaseProvider.Oracle.ExecutionService.ExecutionService.ExecuteScalar(IDbCommand cmd)


2020-12-10 17:30:47.2781 [1748] [ERROR] at OutSystems.Internal.Db.Command.#Xmb()


2020-12-10 17:30:47.2781 [1748] [ERROR] at OutSystems.Internal.Db.Command.ExecuteScalar(String description, Boolean isApplication, Boolean skipLog, Boolean applyTransformationsToParameters)


2020-12-10 17:30:47.2781 [1748] [ERROR] at OutSystems.HubEdition.RuntimePlatform.DBRuntimePlatform.GetParameterValue(Transaction tran, String parmName, Boolean isNodeSetting)


2020-12-10 17:30:47.2781 [1748] [ERROR] at OutSystems.HubEdition.RuntimePlatform.Settings.GetParameter(String name, Boolean isNodeSetting, Transaction transaction)


2020-12-10 17:30:47.2781 [1748] [ERROR] Failing on GetParameter('IIS.DefaultApplicationPool') after using all retries


2020-12-10 17:30:47.2938 [1748] [ERROR] 


2020-12-10 17:30:47.2938 [1748] [ERROR] ORA-00942: table or view does not exist


2020-12-10 17:30:47.2938 [1748] [ERROR] [2] Oracle.ManagedDataAccess.Client.OracleException


2020-12-10 17:30:47.2938 [1748] [ERROR] Target : OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution


2020-12-10 17:30:47.2938 [1748] [ERROR] Source : Oracle Data Provider for .NET, Managed Driver


2020-12-10 17:30:47.2938 [1748] [ERROR] Message : ORA-00942: table or view does not exist


2020-12-10 17:30:47.2938 [1748] [ERROR] Stack Trace


2020-12-10 17:30:47.2938 [1748] [ERROR] at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)


2020-12-10 17:30:47.2938 [1748] [ERROR] at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)


2020-12-10 17:30:47.2938 [1748] [ERROR] at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.HubEdition.DatabaseProvider.Oracle.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.HubEdition.DatabaseProvider.Oracle.ExecutionService.ExecutionService.ExecuteScalar(IDbCommand cmd)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.Internal.Db.Command.#Xmb()


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.Internal.Db.Command.ExecuteScalar(String description, Boolean isApplication, Boolean skipLog, Boolean applyTransformationsToParameters)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.HubEdition.RuntimePlatform.DBRuntimePlatform.GetParameterValue(Transaction tran, String parmName, Boolean isNodeSetting)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.HubEdition.RuntimePlatform.Settings.GetParameter(String name, Boolean isNodeSetting, Transaction transaction)


2020-12-10 17:30:47.2938 [1748] [ERROR] at OutSystems.HubEdition.RuntimePlatform.Settings.Get(String key, Nullable`1 isNodeSettingParam, Nullable`1 isEncryptedSettingParam, Transaction transaction, Boolean skipCache)

Rank: #1065

Hi, any help? 

I plan to migrate existing os10 production windows server 2012 and oracle 12c to a new vm server windows server 2019 and new 19c database.

All connection tested okay in the configuration tool. I have also click create upgrade database and create session.


The error occured during click on apply and exit button in the configuration tool

Staff
Rank: #14602

Hi Ronny.

It seems you are using an unsupported Operating System for OutSystems 10. Please refer to the System Requirements to understand what are the supported Operating Systems for version 10.

Despite this, have you found any errors during the backup & restore of the database?

Have you executed the required queries from the OutSystems documentation for cleaning references to the old environment?

Rank: #1065

Hi João,

Thanks, the DBA team did not find any errors. 

We managed to resolve the issue by executing the creating the tablespace script first before restoring the database. I think 1 of the outsystems tablespace was not created because it was not tied to the outsystems database users.

Thanks