sql - Doing BULK Insert SUSPENDED With Wait Type LCK_M_RIn_LN -


i'm having awful problems doing bulk insert. i'm using sqlbulkcopy insert number of rows table. @ first, timeout exception. so, set sqlbulkcopy's bulkcopytimeout ridiculous[?] 1800 seconds. exception wouldn't thrown (yet). so, checked activity monitor (as suggested here: timeout expired. timeout period elapsed prior completion of operation or server not responding. statement has been terminated) ms server management studio , saw bulk insert's task status suspended wait type of lck_m_rin_ln.my code goes this:

using sqlcon sqlconnection = connection.connect()    dim sqlbulkcopy new sqlbulkcopy(sqlcon, sqlbulkcopyoptions.checkconstraints ,    sqlbulkcopyoptions.firetriggers ,    sqlbulkcopyoptions.keepnulls ,    sqlbulkcopyoptions.keepidentity, sqltran)     sqlbulkcopy.bulkcopytimeout = 1800 ' ridiculous?    sqlbulkcopy.batchsize = 1000    sqlbulkcopy.destinationtablename = destinationtable    sqlbulkcopy.writetoserver(datatableobject)     sqltran.commit() end using

i have been searching solutions in web, no avail. although have found defintion of lck_m_rin_ln:

occurs when task waiting acquire null lock on current key value, , insert range lock between current , previous key. null lock on key instant release lock. lock compatibility matrix, see sys.dm_tran_locks (transact-sql).

from http://msdn.microsoft.com/en-us/library/ms179984.aspx

but it's not helping. may me out. deepest gratitude.

edit

i think it's because of keepidentity attribute because primary key auto incremented. according sqlbulkcopy insert identity column. i'll see if fixes issue.

edit 2

i don't know what's happening bulk insert worked fine when tested on management studio (using direct transact-sql). don't know. maybe it's sqlbulkcopy. when checked on activity monitor, query generated this:

insert bulk tablename ([columnname] int)

edit 3

i forgot write i'm using entity framework copied code (translated c# vb, actually) create datatable entity object since entitydatareader available c# (which distressed me). but, anyway. trashed sqlbulkcopy thing , stored values in xml because when @ it, realized did not need values inside database.


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more