BPA V9 - No events shown in calendar - SQL-Error

Product Feature: Server Management Console

Operating System: Windows 2008 64bit


 

Issue

BPA V9 - No events shown in calendar - SQL-Error

Cause


Following errors created in the Windows-Events from the BPA-Server:
=============
Problem with a custom query.
    Query = "StartDateTime > '11/17/2013 11:00:00 PM' AND StartDateTime < '11/26/2013 10:59:59 PM'"
    DataTableType = ExecutionEvents

Oracle.DataAccess.Client.OracleException ORA-00923: FROM keyword not found where expected    at AutoMate.BPAServer.DataManager.v9.ODPDataAdapter.QueryDataTable(DataSet theDataSet, String theQuery, Int32 PageSize, Int32 MinIndex, BPAServerDataTableTypes theDataTableType)

Extended stack trace:
   at AutoMate.BPAServer.DataManager.v9.ODPDataAdapter.QueryDataTable(DataSet theDataSet, String theQuery, Int32 PageSize, Int32 MinIndex, BPAServerDataTableTypes theDataTableType)
   at AutoMate.BPAServer.DataManager.v9.DataAdapterBase.GetExecutionEventsWithPagedWhereClause(String WhereClause, Int32 PageSize, Int32 MinIndex)
   at AutoMate.BPAServer.DataManager.v9.DataAdapterBase.GetConstructsWithPagedWhereClause(ConstructType Type, String WhereClause, Int32 PageSize, Int32 MinIndex)
   at AutoMate.BPAServer.DataManager.v9.BPAServerDataManager.GetConstructsWithPagedWhereClause(ConstructType Type, String WhereClause, Int32 PageSize, Int32 MinIndex)
   at AutoMate.BPAServer.Management.ManagementServer.GetExecutedConstructsEventsRequest(GetExecutedConstructsEventsRequestMessage Request, BPAManagementServerSession theSession)
   at AutoMate.Communications.Server.BPAManagementServerWCFServer.GetExecutedConstructsEventsRequest(GetExecutedConstructsEventsRequestMessage Request, String SessionID)
   at SyncInvokeGetExecutedConstructsEventsRequest(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
   at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext)
   at System.ServiceModel.Dispatcher.ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext)
   at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(IAsyncResult result)
   at System.ServiceModel.Dispatcher.ChannelHandler.OnAsyncReceiveComplete(IAsyncResult result)
   at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
   at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
   at System.Runtime.InputQueue`1.AsyncQueueReader.Set(Item item)
   at System.Runtime.InputQueue`1.EnqueueAndDispatch(Item item, Boolean canDispatchOnThisThread)
   at System.Runtime.InputQueue`1.EnqueueAndDispatch(T item, Action dequeuedCallback, Boolean canDispatchOnThisThread)
   at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, Action dequeuedCallback, Boolean canDispatchOnThisThread)
   at System.ServiceModel.Channels.HttpChannelListener.HttpContextReceived(HttpRequestContext context, Action callback)
   at System.ServiceModel.Channels.SharedHttpTransportManager.OnGetContextCore(IAsyncResult result)
   at System.ServiceModel.Channels.SharedHttpTransportManager.OnGetContext(IAsyncResult result)
   at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
   at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
   at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
   at System.Net.ListenerAsyncResult.WaitCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
   at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
==================

 

Resolution

UPDATED: December 27, 2017