Having issues with Connect to Oracle database

This is an example of an issue/error I am experiencing -- when filtering a date field from my data source, then selecting Month > Last Month. It appears to be unable to handle the date format we are using.

I'm also attemting to execute the same query from the Added Column "Date" using the Date Filter = Month > Last Month.

Error Message:

Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue

Stack Trace:

Microsoft.Mashup.Evaluator.Interface.ErrorException: Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue ---> System.InvalidOperationException: Microsoft.Mashup.Engine1.Runtime.Library+Date+StartOfMonthFunctionValue
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.Visit(Object node)
at Microsoft.Mashup.Engine1.Library.Oracle.OracleAstCreator.CreateToDate(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.CreateLogicalOperation(BinaryLogicalOperator predicate, IBinaryExpression binary)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitBinary(IBinaryExpression binary)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.Visit(Object node)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.CreateConditionExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitBinary(IBinaryExpression binary)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.CreateListSelect(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.VisitInvocation(IInvocationExpression invocation)
at Microsoft.Mashup.Engine1.Language.Ast.AstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node, TypeValue type)
at Microsoft.Mashup.Engine1.Library.Common.Creators.DbAstCreator.GetValue(IExpression node)
at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.Compile(Query originalQuery, IExpression expression, LogicalAstToCachedTypeflowResultCursor cursor)
at Microsoft.Mashup.Engine1.Library.Common.QueryResultTableValue.get_Type()
at Microsoft.Mashup.Engine1.Library.Common.ExternalQueryProcessor.ApplyTake(Query originalQuery, Value input, IExpression takeQuery)
at Microsoft.Mashup.Engine1.Library.Common.ExternalQueryProcessor.Invoke(Query originalQuery, IExpression expression)
at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.ExpressionTableValue.Take(Query query, RowCount count)
at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.ExpressionTableValue.SkipTake(SkipTakeQuery query)
at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.VisitSkipTake(SkipTakeQuery query)
at Microsoft.Mashup.Engine1.Language.Query.QueryFolder.Fold(Query query)
at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
at Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass5.<RunStub>b__3()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass32`1.<OnBeginGetResult>b__2f()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
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.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.Container.EvaluationContainerMain.Run(Object args)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(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.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
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.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
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.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
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.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)