Return-Path: X-Original-To: apmail-ignite-user-archive@minotaur.apache.org Delivered-To: apmail-ignite-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3A02918526 for ; Mon, 4 Apr 2016 08:41:18 +0000 (UTC) Received: (qmail 92917 invoked by uid 500); 4 Apr 2016 08:41:18 -0000 Delivered-To: apmail-ignite-user-archive@ignite.apache.org Received: (qmail 92870 invoked by uid 500); 4 Apr 2016 08:41:18 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 92860 invoked by uid 99); 4 Apr 2016 08:41:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Apr 2016 08:41:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 84284C23CC for ; Mon, 4 Apr 2016 08:41:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.279 X-Spam-Level: * X-Spam-Status: No, score=1.279 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gridgain-com.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id bUnze1uktAWD for ; Mon, 4 Apr 2016 08:41:15 +0000 (UTC) Received: from mail-oi0-f53.google.com (mail-oi0-f53.google.com [209.85.218.53]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id E1D8A5F217 for ; Mon, 4 Apr 2016 08:41:14 +0000 (UTC) Received: by mail-oi0-f53.google.com with SMTP id s79so58629947oie.1 for ; Mon, 04 Apr 2016 01:41:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gridgain-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=xxsDEOQL3yeUQdgdfvUNUKF6T/f47TEEOjsfI2nZl24=; b=VZrIZqrtQKfuOF0xPqlPdcQAGG9pPvf3QkaVI0ogYFo8XerWLeEWAUmEWGH3O5ZRmq SoHjgenCcpL9k/OWdB7kLw9cX53lsyI8jRWLFkS+nt2XyKmahdLbMDp+cZhh9h8T5Sdo 4gqXl9gZ1AUFdRLw8GqTYR6V40mksdnTtfFj3BfctidExtE6P7oXtGlEQq5ebCN7aEW9 U8ccDbdlyF8AN8udZCN7Eqk3MJl5O98fOHAuHESZHMiO2M5LFptUDN/Ws3xOzfZLTwY9 Jkz543Aexp6dN6HZkfySC5h9BF8i8UiRTK+mJH1qXurebxg+ChPT83fsLYpICsQpGKMs AdCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=xxsDEOQL3yeUQdgdfvUNUKF6T/f47TEEOjsfI2nZl24=; b=SmFKU/vh4+FwHMgGYa9VV2byR/a6fA5aJazZIgagUIqiO1AkisTbY+0stPXjNDVNCF a4gor3fHfaLnvDxzoGudDKCcJ/tqDVTXBAlOXEsB3xGlGCmSVX1PXHOBeEDnlRvVA0FY ZaJeQanFlceUDghE0NENK++/rD2JIJk7osYXVmsYHpcEfXcoPaqiHNER8cZSZ3zrJKQS 5tISmxnN1sYdw0iTyCjiThFX+wcDt3oaal9lpuEvuMHMOvRCD6o7LJw5cO2VIG9NiKs5 W+9NFsAdZkfaEnOM1Pnuhu2fbiomhqwPPskSPuWn/k86eJWCPxwtLdPJ+3pXNYxqZVQE gi5w== X-Gm-Message-State: AD7BkJJCeUqhbHqv0u4CBE9WIoOSqdIdHEJ8k7JzxCiPmOeWfOgPToeOlhj1mUNd0BtaW0OM0c29EstKDXv3yhng X-Received: by 10.202.80.130 with SMTP id e124mr9325082oib.79.1459759273720; Mon, 04 Apr 2016 01:41:13 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.31.70 with HTTP; Mon, 4 Apr 2016 01:40:44 -0700 (PDT) In-Reply-To: References: From: Pavel Tupitsyn Date: Mon, 4 Apr 2016 11:40:44 +0300 Message-ID: Subject: Re: SQLServer Persistence Store Error To: user@ignite.apache.org Content-Type: multipart/alternative; boundary=001a113b0654f7e617052fa4b043 --001a113b0654f7e617052fa4b043 Content-Type: text/plain; charset=UTF-8 Hi Satya, "*Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.*" This is an SQL exception. Please make sure that your entity connection works. You can set a breakpoint on the first line of LoadCache method, step over your code and see what happens. Or wrap it in try-catch block. Meanwhile, looks like cache store error messages are not very informative. I've added a Jira ticket, we'll fix it shortly: https://issues.apache.org/jira/browse/IGNITE-2943 Thank you, Pavel On Mon, Apr 4, 2016 at 7:07 AM, Murthy Kakarlamudi wrote: > Hello all, > I was able to resolve the error I posted above. I had to basically add > the relevant EntityFramwork references in the solution that runs my Ignite > server node. After successfully creating the cache, however I am running > into the below timeout issue: > > [00:02:37] Ignite node started OK (id=cf8c5e00) > [00:02:37] Topology snapshot [ver=1, servers=1, clients=0, CPUs=4, > heap=0.89GB] > *>>> Cache query example started* > *Adding to cache: 228505* > [00:03:10,524][SEVERE][pub-#10%null%][GridJobWorker] Failed to execute job > [jobId=bcc9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf34, > ses=GridJobSessionImpl [ses=GridTaskSessionImpl > [taskName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheClosure, > dep=LocalDeployment [super=GridDeployment [ts=1459742547098, > depMode=SHARED, clsLdr=sun.misc.Launcher$AppClassLoader@764c12b6, > clsLdrId=a9c9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf34, userVer=0, > loc=true, sampleClsName=java.lang.String, pendingUndeploy=false, > undeployed=false, usage=0]], > taskClsName=o.a.i.i.processors.cache.GridCacheAdapter$LoadCacheClosure, > sesId=acc9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf34, > startTime=1459742557568, endTime=9223372036854775807, > taskNodeId=cf8c5e00-c86f-4e58-b0ad-6754896baf34, > clsLdr=sun.misc.Launcher$AppClassLoader@764c12b6, closed=false, > cpSpi=null, failSpi=null, loadSpi=null, usage=1, fullSup=false, > subjId=cf8c5e00-c86f-4e58-b0ad-6754896baf34, mapFut=IgniteFuture > [orig=GridFutureAdapter [resFlag=0, res=null, startTime=1459742557584, > endTime=0, ignoreInterrupts=false, lsnr=null, state=INIT]]], > jobId=bcc9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf34]] > class org.apache.ignite.IgniteException: class > org.apache.ignite.IgniteException: Timeout expired. The timeout period > elapsed prior to completion of the operation or the server is not > responding. > at > org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1792 > > Apache.Ignite.Core.Cache.Store.CacheStoreException was unhandled > HResult=-2146233088 > Message=class org.apache.ignite.IgniteException: *Timeout expired. The > timeout period elapsed prior to completion of the operation or the server > is not responding.* > Source=Apache.Ignite.Core > StackTrace: > at Apache.Ignite.Core.Impl.Unmanaged.UnmanagedCallbacks.Error(Void* > target, Int32 errType, SByte* errClsChars, Int32 errClsCharsLen, SByte* > errMsgChars, Int32 errMsgCharsLen, Void* errData, Int32 errDataLen) > at > Apache.Ignite.Core.Impl.Unmanaged.IgniteJniNativeMethods.TargetInStreamOutLong(Void* > ctx, Void* target, Int32 opType, Int64 memPtr) > at > Apache.Ignite.Core.Impl.Unmanaged.UnmanagedUtils.TargetInStreamOutLong(IUnmanagedTarget > target, Int32 opType, Int64 memPtr) > at Apache.Ignite.Core.Impl.PlatformTarget.DoOutOp(Int32 type, > Action`1 action) > at MyIgniteConsole.Program.Main(String[] args) in > C:\Data\Professional\dotnet\workspace\MyIgnite\MyIgniteConsole\Program.cs:line > 29 > at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, > String[] args) > at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence > assemblySecurity, String[] args) > at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() > 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.Threading.ThreadHelper.ThreadStart() > InnerException: > > From my main program, I am making below call: > cache.LoadCache(null); > > In my store implementation I have the following overide method: > public override void LoadCache(Action act, params > object[] args) > { > var personDetailsList = entities.personDetails; > // Iterate over whole underlying store and call act on each > entry to load it into the cache. > foreach (personDetail entry in personDetailsList) > { > Console.WriteLine("Adding to cache: " + > entry.personDetailID); > act(entry.personDetailID, entry); > > } > > } > > > thanks in advance for your help... > > Satya. > > > On Sat, Apr 2, 2016 at 11:49 AM, Murthy Kakarlamudi > wrote: > >> Hi, >> In my .NET application, I have an underlying SQL Server DB that I am >> planning to access using Ignite Persistence feature. I was following the >> StoreExample provided in the examples and created the ignite configuration >> accordingly. >> >> >> >> > class="org.apache.ignite.configuration.CacheConfiguration"> >> >> >> >> > class="org.apache.ignite.platform.dotnet.PlatformDotNetCacheStoreFactory"> >> >> >> >> >> >> >> >> My SQLServerStore which is part of MyIgnite dll is as below. I am using >> EntityFramework as ORM to access underlying SQLServer. >> >> class SQLServerStore : CacheStoreAdapter >> { >> private TestEntities entities; >> public SQLServerStore() >> { >> entities = new TestEntities(); >> } >> >> /// >> /// Loads all values from underlying persistent storage. >> /// This method gets called as a result of > cref="ICache{TK,TV}.LoadCache"/> call. >> /// >> /// Action that loads a cache entry. >> /// Optional arguments. >> public override void LoadCache(Action act, params >> object[] args) >> { >> var personDetailsList = entities.PersonDetails; >> // Iterate over whole underlying store and call act on each >> entry to load it into the cache. >> foreach (personDetail entry in personDetailsList) >> { >> act(entry.personD, entry); >> } >> >> } >> } >> >> Whwn I try to run the above, I am getting the below error. >> >> Apache.Ignite.Core.Common.IgniteException was unhandled >> HResult=-2146233088 >> Message=Exception has been thrown by the target of an invocation. >> Source=Apache.Ignite.Core >> StackTrace: >> at >> Apache.Ignite.Core.Impl.Unmanaged.UnmanagedCallbacks.Error(Void* target, >> Int32 errType, SByte* errClsChars, Int32 errClsCharsLen, SByte* >> errMsgChars, Int32 errMsgCharsLen, Void* errData, Int32 errDataLen) >> at >> Apache.Ignite.Core.Impl.Unmanaged.IgniteJniNativeMethods.IgnitionStart(Void* >> ctx, SByte* cfgPath, SByte* gridName, Int32 factoryId, Int64 dataPtr) >> at >> Apache.Ignite.Core.Impl.Unmanaged.UnmanagedUtils.IgnitionStart(UnmanagedContext >> ctx, String cfgPath, String gridName, Boolean clientMode) >> at Apache.Ignite.Core.Ignition.Start(IgniteConfiguration cfg) >> at MyIgniteConsole.Program.Main(String[] args) in >> C:\Data\Professional\dotnet\workspace\MyIgnite\MyIgniteConsole\Program.cs:line >> 21 >> at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, >> String[] args) >> at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence >> assemblySecurity, String[] args) >> at >> Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() >> 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.Threading.ThreadHelper.ThreadStart() >> InnerException: >> >> >> Any help would be appreciated. >> >> Thanks, >> Satya. >> > > --001a113b0654f7e617052fa4b043 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Satya,

"Timeout expired.=C2=A0 The timeout period elapsed prior to completio= n of the operation or the server is not responding."
Thi= s is an SQL exception. Please make sure that your entity connection works.<= /div>
You can set a breakpoint on the first line of LoadCache method, s= tep over your code and see what happens. Or wrap it in try-catch block.

Meanwhile, looks like cache store error messages= are not very informative.=C2=A0
I've added a Jira ticket, we= 'll fix it shortly:=C2=A0https://issues.apache.org/jira/browse/IGNITE-2943
=

Thank you,

Pavel

On Mon, Apr 4= , 2016 at 7:07 AM, Murthy Kakarlamudi <ksatya@gmail.com> wrot= e:
Hello all,
=C2=A0= =C2=A0I was able to resolve the error I posted above. I had to basically a= dd the relevant EntityFramwork references in the solution that runs my Igni= te server node. After successfully creating the cache, however I am running= into the below timeout issue:

[00:02:37] Ign= ite node started OK (id=3Dcf8c5e00)
[00:02:37] Topology snapshot = [ver=3D1, servers=3D1, clients=3D0, CPUs=3D4, heap=3D0.89GB]
&= gt;>> Cache query example started
Adding to cache: 2= 28505
[00:03:10,524][SEVERE][pub-#10%null%][GridJobWorker] Fa= iled to execute job [jobId=3Dbcc9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf= 34, ses=3DGridJobSessionImpl [ses=3DGridTaskSessionImpl [taskName=3Do.a.i.i= .processors.cache.GridCacheAdapter$LoadCacheClosure, dep=3DLocalDeployment = [super=3DGridDeployment [ts=3D1459742547098, depMode=3DSHARED, clsLdr=3Dsun= .misc.Launcher$AppClassLoader@764c12b6, clsLdrId=3Da9c9f6fd351-cf8c5e00-c86= f-4e58-b0ad-6754896baf34, userVer=3D0, loc=3Dtrue, sampleClsName=3Djava.lan= g.String, pendingUndeploy=3Dfalse, undeployed=3Dfalse, usage=3D0]], taskCls= Name=3Do.a.i.i.processors.cache.GridCacheAdapter$LoadCacheClosure, sesId=3D= acc9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf34, startTime=3D1459742557568= , endTime=3D9223372036854775807, taskNodeId=3Dcf8c5e00-c86f-4e58-b0ad-67548= 96baf34, clsLdr=3Dsun.misc.Launcher$AppClassLoader@764c12b6, closed=3Dfalse= , cpSpi=3Dnull, failSpi=3Dnull, loadSpi=3Dnull, usage=3D1, fullSup=3Dfalse,= subjId=3Dcf8c5e00-c86f-4e58-b0ad-6754896baf34, mapFut=3DIgniteFuture [orig= =3DGridFutureAdapter [resFlag=3D0, res=3Dnull, startTime=3D1459742557584, e= ndTime=3D0, ignoreInterrupts=3Dfalse, lsnr=3Dnull, state=3DINIT]]], jobId= =3Dbcc9f6fd351-cf8c5e00-c86f-4e58-b0ad-6754896baf34]]
class org.a= pache.ignite.IgniteException: class org.apache.ignite.IgniteException: Time= out expired.=C2=A0 The timeout period elapsed prior to completion of the op= eration or the server is not responding.
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 at org.apache.ignite.internal.processors.closure.GridClosureProcessor$C= 2.execute(GridClosureProcessor.java:1792

Apache.Ignite.Core.Cache.Store.CacheStoreException was unhandled
=C2=A0 HResult=3D-2146233088
=C2=A0 Message=3Dclass org.apache.= ignite.IgniteException: Timeout expired.=C2=A0 The timeout period elapse= d prior to completion of the operation or the server is not responding.=
=C2=A0 Source=3DApache.Ignite.Core
= =C2=A0 StackTrace:
=C2=A0 =C2=A0 =C2=A0 =C2=A0at Apache.Ignite.Co= re.Impl.Unmanaged.UnmanagedCallbacks.Error(Void* target, Int32 errType, SBy= te* errClsChars, Int32 errClsCharsLen, SByte* errMsgChars, Int32 errMsgChar= sLen, Void* errData, Int32 errDataLen)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0at Apache.Ignite.Core.Impl.Unmanaged.IgniteJniNativeMethods.Targe= tInStreamOutLong(Void* ctx, Void* target, Int32 opType, Int64 memPtr)
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0at Apache.Ignite.Core.Impl.Unmanaged.Unmana= gedUtils.TargetInStreamOutLong(IUnmanagedTarget target, Int32 opType, Int64= memPtr)
=C2=A0 =C2=A0 =C2=A0 =C2=A0at Apache.Ignite.Core.Impl.Pl= atformTarget.DoOutOp(Int32 type, Action`1 action)
=C2=A0 =C2=A0 = =C2=A0 =C2=A0at MyIgniteConsole.Program.Main(String[] args) in C:\Data\Prof= essional\dotnet\workspace\MyIgnite\MyIgniteConsole\Program.cs:line 29
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0at System.AppDomain._nExec= uteAssembly(RuntimeAssembly assembly, String[] args)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0at System.AppDomain.ExecuteAssembly(String assemblyFile, E= vidence assemblySecurity, String[] args)
=C2=A0 =C2=A0 =C2=A0 =C2= =A0at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
=C2=A0 =C2=A0 =C2=A0 =C2=A0at System.Threading.ExecutionContext.RunI= nternal(ExecutionContext executionContext, ContextCallback callback, Object= state, Boolean preserveSyncCtx)
=C2=A0 =C2=A0 =C2=A0 =C2=A0at Sy= stem.Threading.ExecutionContext.Run(ExecutionContext executionContext, Cont= extCallback callback, Object state, Boolean preserveSyncCtx)
=C2= =A0 =C2=A0 =C2=A0 =C2=A0at System.Threading.ExecutionContext.Run(ExecutionC= ontext executionContext, ContextCallback callback, Object state)
= =C2=A0 =C2=A0 =C2=A0 =C2=A0at System.Threading.ThreadHelper.ThreadStart()
=C2=A0 InnerException:=C2=A0

From my main program, I am making below call:
=C2=A0cache.LoadCa= che(null);

In my store implementation I have t= he following overide method:
=C2=A0public o= verride void LoadCache(Action<object, object> act, params object[] ar= gs)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 {
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 var personDetailsList =3D entities.personDetail= s;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 // = Iterate over whole underlying store and call act on each entry to load it i= nto the cache.
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 foreach = (personDetail entry in personDetailsList)
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 {
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 Console.WriteLine("Adding to cache: " + entr= y.personDetailID);
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 act(entry.personDetailID, entry);
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 }
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<= /div>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 }


=
thanks in advance for your help...

Saty= a.


On Sat, Apr 2, 2016 at = 11:49 AM, Murthy Kakarlamudi <ksatya@gmail.com> wrote:
Hi,
=C2=A0 =C2=A0In my .NE= T application, I have an underlying SQL Server DB that I am planning to acc= ess using Ignite Persistence feature. I was following the StoreExample prov= ided in the examples and created the ignite configuration accordingly.=C2= =A0

<property name=3D"cacheConfigurat= ion">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <list>
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <bean class=3D"org.apache.ignite= .configuration.CacheConfiguration">
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 <property name=3D"writeThrough" value=3D&= quot;true"/>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 &l= t;property name=3D"readThrough" value=3D"true"/>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <property name=3D"= cacheStoreFactory">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 <bean class=3D"org.apache.ignite.platform.dotnet.Plat= formDotNetCacheStoreFactory">
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 <property name=3D"typeName" value= =3D"MyIgnite.SQLServerStore, MyIgnite"/>
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </bean>
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </property>
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 </bean>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 &l= t;/list>
=C2=A0 =C2=A0 =C2=A0 </property>

My SQLServerStore which is part of MyIgnite dll is as belo= w. I am using EntityFramework as ORM to access underlying SQLServer.
<= div>
class SQLServerStore : CacheStoreAdapter
= =C2=A0 =C2=A0 {
=C2=A0 =C2=A0 =C2=A0 =C2=A0 private TestEntities = entities;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 public SQLServerStore()
=C2=A0 =C2=A0 =C2=A0 =C2=A0 {
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 entities =3D new TestEntities();
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 }

=C2=A0 =C2=A0 =C2=A0 =C2=A0 /// <s= ummary>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 /// Loads all values from = underlying persistent storage.
=C2=A0 =C2=A0 =C2=A0 =C2=A0 /// Th= is method gets called as a result of <see cref=3D"ICache{TK,TV}.Loa= dCache"/> call.
=C2=A0 =C2=A0 =C2=A0 =C2=A0 /// </summ= ary>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 /// <param name=3D"ac= t">Action that loads a cache entry.</param>
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 /// <param name=3D"args">Optional argu= ments.</param>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 public override = void LoadCache(Action<object, object> act, params object[] args)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 {
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 var personDetailsList =3D entities.PersonDetails;
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 // Iterate over whole underlying = store and call act on each entry to load it into the cache.
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 foreach (personDetail=C2=A0entry in= =C2=A0personDetailsList)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 {
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 act= (entry.personD, entry);
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= }
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 }
}

Whwn I try t= o run the above, I am getting the below error.

Apache.Ignite.Core.Common.IgniteException was unhandled
=C2=A0 = HResult=3D-2146233088
=C2=A0 Message=3DException has been thrown by = the target of an invocation.
=C2=A0 Source=3DApache.Ignite.Core
=C2=A0 StackTrace:
=C2=A0 =C2=A0 =C2=A0 =C2=A0at Apache.= Ignite.Core.Impl.Unmanaged.UnmanagedCallbacks.Error(Void* target, Int32 err= Type, SByte* errClsChars, Int32 errClsCharsLen, SByte* errMsgChars, Int32 e= rrMsgCharsLen, Void* errData, Int32 errDataLen)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0at Apache.Ignite.Core.Impl.Unmanaged.IgniteJniNativeMethods.Ignit= ionStart(Void* ctx, SByte* cfgPath, SByte* gridName, Int32 factoryId, Int64= dataPtr)
=C2=A0 =C2=A0 =C2=A0 =C2=A0at Apache.Ignite.Core.Impl.U= nmanaged.UnmanagedUtils.IgnitionStart(UnmanagedContext ctx, String cfgPath,= String gridName, Boolean clientMode)
=C2=A0 =C2=A0 =C2=A0 =C2=A0= at Apache.Ignite.Core.Ignition.Start(IgniteConfiguration cfg)
=C2= =A0 =C2=A0 =C2=A0 =C2=A0at MyIgniteConsole.Program.Main(String[] args) in C= :\Data\Professional\dotnet\workspace\MyIgnite\MyIgniteConsole\Program.cs:li= ne 21
=C2=A0 =C2=A0 =C2=A0 =C2=A0at System.AppDomain._nExecuteAss= embly(RuntimeAssembly assembly, String[] args)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence= assemblySecurity, String[] args)
=C2=A0 =C2=A0 =C2=A0 =C2=A0at M= icrosoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
= =C2=A0 =C2=A0 =C2=A0 =C2=A0at System.Threading.ExecutionContext.RunInternal= (ExecutionContext executionContext, ContextCallback callback, Object state,= Boolean preserveSyncCtx)
=C2=A0 =C2=A0 =C2=A0 =C2=A0at System.Th= reading.ExecutionContext.Run(ExecutionContext executionContext, ContextCall= back callback, Object state, Boolean preserveSyncCtx)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0at System.Threading.ExecutionContext.Run(ExecutionContext = executionContext, ContextCallback callback, Object state)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0at System.Threading.ThreadHelper.ThreadStart()
=C2=A0 InnerException:=C2=A0


Any help would be appreciated.

Thanks,
Satya.


--001a113b0654f7e617052fa4b043--