Connecting To MySQL Database/Server

Connecting To MySQL Database/Server

  

Dear Community,

I am in a hurry with finding a solution to my connection problem and I dont mind any wrong answers... I just need quick help! :) 

My problem:


I am trying to get "live" data from a MySQL Database Server to my Data Entities in Outsystems Service Studio 10.0. The solution, I found so far, is to get a connection in outsystem.com/ServiceCenter and continue with migrating the database tables with Integration Studio. Unfortunately I receive the following errors (3):


"

Id:
04ffc035-1a26-484b-95fa-f6be2d0d7035
Time of Log:
2017-02-14 11:48:54
eSpace:
ServiceCenter
Tenant:
ServiceCenter
User:
david.ritzer@zrnet.de (4)
Session Id:
No session
Server:
S1POL-LT2F1Y
Module:

Message:


One or more errors occurred.


Environment InformationeSpaceVer: 0 (Id=1, PubId=1, CompiledWith=10.0.200.2)
RequestUrl: https://njoerd.outsystemscloud.com/ServiceCenter/IntegrationStudio.asmx (Method: POST)
AppDomain: /LM/W3SVC/28/ROOT/ServiceCenter-2-131314706189956888
FilePath: C:\OutSystems\Sandboxes\L4HVY0025\Platform Server\running\ServiceCenter\
ClientIp: 129.13.72.198
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 60584 ('w3wp', Started='2/13/2017 2:43:28 PM', Priv=908Mb, Virt=19379Mb)
TID: 10
Thread Name:
.NET: 4.0.30319.42000
Stack:
[1] One or more errors occurred.
   at ssServiceCenter.RssExtensionIntegrationStudio.MssEntityIntrospectionGetEntityViews(HeContext heContext, IRecord inParamserver, RecordList inParamtableNames, RecordList& outParamentityViews)
   at ssServiceCenter.Actions.ActionEntityIntrospectionGetEntityViews(HeContext heContext, RCEntityIntrospectionServerRecord inParamserver, RLEntityIntrospectionTableNameRecordList inParamtableNames, RLEntityIntrospectionEntityViewRecordList& outParamentityViews)
   at ssServiceCenter.Actions.WsIntegrationStudio.WebSrvcIntegrationStudioEntityIntrospectionGetEntityViews(HeContext heContext, String inParamusername, String inParampassword, RLEntityIntrospectionTableNameRecordList inParamtableNames, RCEntityIntrospectionServerRecord inParamserver, RLEntityIntrospectionEntityViewRecordList& outParamentityViews)

[2] Unknown column 'DATETIME_PRECISION' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at OutSystems.HubEdition.DatabaseProvider.MySQL.IntrospectionService.MySQLIntrospectionService.GetColumns(IEnumerable`1 tableSources, CreateDataTypeInfo createDataTypeInfo, CreateColumnInfo createColumnInfo)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.#Ocd(RCEntityIntrospectionServerRecord ssserver, RCEntityIntrospectionTableNameRecord table, IIntrospectionService introspectionService, IExecutionService executionService)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.#zr.#rdd(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 )



Error Detail
Back to Log
Id:e2d0a60d-0347-402c-a575-2e6b4a080db6
Time of Log:2017-02-14 11:48:54
eSpace:ServiceCenter
Tenant:ServiceCenter
User:david.ritzer@zrnet.de (4)
Session Id:No session
Server:S1POL-LT2F1Y
Module:Extension metho
Message:One or more errors occurred.
Environment InformationeSpaceVer: 0 (Id=1, PubId=1, CompiledWith=10.0.200.2)
RequestUrl: https://njoerd.outsystemscloud.com/ServiceCenter/IntegrationStudio.asmx (Method: POST)
AppDomain: /LM/W3SVC/28/ROOT/ServiceCenter-2-131314706189956888
FilePath: C:\OutSystems\Sandboxes\L4HVY0025\Platform Server\running\ServiceCenter\
ClientIp: 129.13.72.198
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 60584 ('w3wp', Started='2/13/2017 2:43:28 PM', Priv=908Mb, Virt=19379Mb)
TID: 10
Thread Name:
.NET: 4.0.30319.42000
Stack:[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] Unknown column 'DATETIME_PRECISION' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at OutSystems.HubEdition.DatabaseProvider.MySQL.IntrospectionService.MySQLIntrospectionService.GetColumns(IEnumerable`1 tableSources, CreateDataTypeInfo createDataTypeInfo, CreateColumnInfo createColumnInfo)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.#Ocd(RCEntityIntrospectionServerRecord ssserver, RCEntityIntrospectionTableNameRecord table, IIntrospectionService introspectionService, IExecutionService executionService)
   at OutSystems.NssIntegrationStudio.CssIntegrationStudio.#zr.#rdd(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 )

Id:c180372e-5e32-4421-9819-f11009676a50
Time of Log:2017-02-14 11:48:54
eSpace:ServiceCenter
Tenant:ServiceCenter
User:david.ritzer@zrnet.de (4)
Session Id:No session
Server:S1POL-LT2F1Y
Module:SOAP (Expose)
Message:One or more errors occurred.
Environment InformationeSpaceVer: 0 (Id=1, PubId=1, CompiledWith=10.0.200.2)
RequestUrl: https://njoerd.outsystemscloud.com/ServiceCenter/IntegrationStudio.asmx (Method: POST)
AppDomain: /LM/W3SVC/28/ROOT/ServiceCenter-2-131314706189956888
FilePath: C:\OutSystems\Sandboxes\L4HVY0025\Platform Server\running\ServiceCenter\
ClientIp: 129.13.72.198
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 60584 ('w3wp', Started='2/13/2017 2:43:28 PM', Priv=908Mb, Virt=19379Mb)
TID: 10
Thread Name:
.NET: 4.0.30319.42000
Stack:One or more errors occurred.
   at ssServiceCenter.Actions.WsIntegrationStudio.WebSrvcIntegrationStudioEntityIntrospectionGetEntityViews(HeContext heContext, String inParamusername, String inParampassword, RLEntityIntrospectionTableNameRecordList inParamtableNames, RCEntityIntrospectionServerRecord inParamserver, RLEntityIntrospectionEntityViewRecordList& outParamentityViews)
   at ssServiceCenter.WebServices.IntegrationStudio.EntityIntrospectionGetEntityViews(String inWSusername, String inWSpassword, WORCEntityIntrospectionTableNameRecord[] inWStableNames, WORCEntityIntrospectionServerRecord inWSserver, WORCEntityIntrospectionEntityViewRecord[]& outWSentityViews)




I am aware of all other threads and that I am using an MySQL Version (5.5.2) which is not officially supported. Unfortunately, I can't update my MySQL Server (it's hosted from GoDaddy.com). I just need to import 3 columns of data.




Hello David

In this case the workaround would be to create your entities manually. Make sure you fill the "Table or View Name" and "Logical Database" fields, and that for each attribute you fill the appropriate values. Attached is an example of a MySQL entity.

Edit: The error is indeed caused by having an unsupported version of MySQL



Hi David,

It looks like the common source of your error is the message: «Unknown column 'DATETIME_PRECISION' in 'field list'».

Could you please check that you are using the correct name for the column in your extension? And that the user associated with your connection is allowed (on your MySQL installation) to access the table and column?

Hope it helps.

Regards,

Ricardo