Hi reader,

I want to connect the external database to outsystems, but I encounter an error when I try to generate the entity. the error is Error retrieving Entities: One or more errors occurred. like this

When I check the error log in service center, the detail error is like this:

[1] One or more errors occurred.
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.MssEntityIntrospectionGetEntityViews(RCEntityIntrospectionServerRecord ssserver, RLEntityIntrospectionTableNameRecordList sstableNames, RLEntityIntrospectionEntityViewRecordList& ssentityViews)
   at ssServiceCenter.RssExtensionIntegrationStudio.MssEntityIntrospectionGetEntityViews(HeContext heContext, IRecord inParamserver, RecordList inParamtableNames, RecordList& outParamentityViews)

[2] 42883: function to_regnamespace(text) does not exist
   at OutSystems.HubEdition.DatabaseProvider.PostgreSQL.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)
   at OutSystems.HubEdition.DatabaseProvider.PostgreSQL.IntrospectionService.IntrospectionService.GetColumns(IEnumerable`1 tableSources, DatabaseInfo dbInfo, Func`7 createColumnInfo, Boolean useCaseSentitive)
   at OutSystems.HubEdition.DatabaseProvider.PostgreSQL.IntrospectionService.IntrospectionService.GetTableSourceColumns(ITableSourceInfo tableSource)
   at OutSystems.Internal.Db.DatabaseAccess.ExecuteWithoutRequestTimeout[T](Func`1 action)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.ProcessTable(RCEntityIntrospectionServerRecord ssserver, RCEntityIntrospectionTableNameRecord table, IIntrospectionService introspectionService, IExecutionService executionService)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.<>c__DisplayClass6_0.<MssEntityIntrospectionGetEntityViews>b__0(RCEntityIntrospectionTableNameRecord table)
   at System.Threading.Tasks.Parallel.<>c__DisplayClass31_0`2.<ForEachWorker>b__0(Int32 i)
   at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.<ForWorker>b__1()
   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
   at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object <p0>) 

The table structure is quite simple like this

Can someone help me to solve this issue? 

I appreciate it Thank you :)