none
postgresql connection: DataSource.Error: Value was either too large or too small for an Int32. when connecting RRS feed

  • Question

  • Just trying to use postgresql in power query ( can use it fine from pgadmin tool)

    I installed the npgsql  .Net Connector by using an installer: http://pgfoundry.org/frs/download.php/3797/Setup_Npgsql-2.2.3.0-r2-net45.exe

    but after entering the database and server detail  I get the error:

     DataSource.Error: Value was either too large or too small for an Int32. when connecting

    any ideas?

    I am using windows 7, excel 64bits standalone
    • Edited by seanvio Saturday, May 16, 2015 4:11 PM
    Saturday, May 16, 2015 4:10 PM

Answers

  • I know other people have run into this problem, so it may be an issue with the npgsql installation process. What you probably need to do is to install Mono.Security.dll (which should be in the npgsql install directory) into something called the "GAC". Unfortunately, the tool needed to do that from the command line is in the .NET SDK and not part of Windows. I don't know a simpler way to solve the problem.

    Instructions for using gacutil with npgsql can be found at http://sqlines.com/postgresql/npgsql_dotnet.

    Monday, May 18, 2015 3:35 PM
  • Do you have a way to see the queries being executed against the server? I suspect that one of the schema queries is returning a value larger than we expect, and if we could see the queries being run it might tell us which one it is.

    Otherwise, please turn on tracing in the Diagnostics tab of the Options dialog and try to connect while collecting traces. Then, use "Send a Frown" and attach the trace files so we can get them.

    Friday, May 29, 2015 1:06 PM

All replies

  • Could you please try the 4.0 version instead of the 4.5 version?
    Saturday, May 16, 2015 8:00 PM
  • Thanks.

    I used http://pgfoundry.org/frs/download.php/3796/Setup_Npgsql-2.2.3.0-r2-net40.exe

    I now get a different (easier?)  error

    Error Message:

    Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified.

    Stack Trace:

    Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified.
       at Npgsql.NpgsqlConnection.Init()
       at Npgsql.NpgsqlFactory.CreateConnection()
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateDbConnection()
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateConnection()
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadCatalog()
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateCatalogTableValue(IEngineHost host)
       at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateTable()
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key)
       at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
       at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value frame)
       at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
       at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
       at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 handler)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Run(String[] args)
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Main(String[] args)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass1.<BeginGetResult>b__0(EvaluationResult2`1 result)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass1.<BeginGetResult>b__0(EvaluationResult2`1 result)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
       at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 handler)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Run(String[] args)
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Main(String[] args)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass10.<OnBeginGetPreviewValueSource>b__f(EvaluationResult2`1 result)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 handler)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 handler)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Run(String[] args)
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Main(String[] args)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.OnEvaluationException(IMessageChannel channel, EvaluationExceptionMessage message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
       at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
       at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<Wrap>b__14(Object o)
       at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<Wrap>b__14(Object o)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
       at System.Threading.ThreadPoolWorkQueue.Dispatch()
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

    Invocation Stack Trace:

       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Delegate.DynamicInvokeImpl(Object[] args)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
       at Microsoft.Mashup.Client.Excel.EditorManager.ShowModalEditor(IWin32Window ownerWindow, IWorkbookIdentity workbookIdentity, EditorDialogParameters editorDialogParameters, Queries queries)
       at Microsoft.Mashup.Client.Excel.ExcelDataImporter.OnImportSuccess(IEnumerable`1 importedQueries, DataImportDestination destination)
       at Microsoft.Mashup.Client.ClientShared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID)
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Delegate.DynamicInvokeImpl(Object[] args)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
       at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    Monday, May 18, 2015 9:17 AM
  • I know other people have run into this problem, so it may be an issue with the npgsql installation process. What you probably need to do is to install Mono.Security.dll (which should be in the npgsql install directory) into something called the "GAC". Unfortunately, the tool needed to do that from the command line is in the .NET SDK and not part of Windows. I don't know a simpler way to solve the problem.

    Instructions for using gacutil with npgsql can be found at http://sqlines.com/postgresql/npgsql_dotnet.

    Monday, May 18, 2015 3:35 PM
  • I think I had some setup problem ( perhaps had excel open whilst installing?) [ Note that the installation script does the installation into GAC ( but I also tried manual installation)].  

    So this problem is fixed: Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified.

    I now get back to the original problem:

    postgresql connection: DataSource.Error: Value was either too large or too small for an Int32. when connecting


    Friday, May 29, 2015 12:22 PM
  • Do you have a way to see the queries being executed against the server? I suspect that one of the schema queries is returning a value larger than we expect, and if we could see the queries being run it might tell us which one it is.

    Otherwise, please turn on tracing in the Diagnostics tab of the Options dialog and try to connect while collecting traces. Then, use "Send a Frown" and attach the trace files so we can get them.

    Friday, May 29, 2015 1:06 PM
  • OK I have sent a frown with the traces....

    here is a highlight!

    DataMashup.Trace Error: 24579 : {"Start":"2015-05-29T13:54:20.2902606Z","Action":"Engine/IO/Db/PostgreSQL/ExecuteReader","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.Mashup.Engine.1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] Value was either too large or too small for an Int32.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, String credentialName, Func`1 action, Func`2 isLoginOrAuthorizationError, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, String credentialName, Func`1 action)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.ConnectionReader.<Execute>b__0()\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.OverflowException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Value was either too large or too small for an Int32.\r\nStackTrace:\n   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)\r\n   at NpgsqlTypes.NpgsqlTypesHelper.LoadTypesMappings(NpgsqlConnector conn, NpgsqlBackendTypeMapping TypeMappings, IEnumerable`1 TypeInfoList)\r\n   at NpgsqlTypes.NpgsqlTypesHelper.CreateAndLoadInitialTypesMapping(NpgsqlConnector conn)\r\n   at Npgsql.NpgsqlConnector.Open()\r\n   at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)\r\n   at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)\r\n   at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)\r\n   at Npgsql.NpgsqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, String credentialName, Func`1 action, Func`2 isLoginOrAuthorizationError, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.22.4007.242 

    Friday, May 29, 2015 2:08 PM
  • The 2.2.5-r3 release of npgsql fixed the Mono Security DLL issue for me (I had installed 2.2.3.0-r2-net45). 

    Available directly via Github (https://github.com/npgsql/npgsql/releases/download/v2.2.5/Setup_Npgsql-2.2.5.0-r3-net45.exe) or the parent (releases page - https://github.com/npgsql/Npgsql/releases).

    Monday, June 29, 2015 4:58 PM