ms access - Invalid argument Error when attempting UPDATE query on linked SharePoint list -

-

i'm running update query access 2010 on linked sharepoint 2013 list, getting invalid argument error.

my access db 200 mb, have tried compacting , repairing db. query "runs" when select "view"--the error appears when click "run". query i'm running goes like:

update sp_table inner join access_table on sp_table.id1 = access_table.id1 set  sp_table.field1 = access_table.field1, sp_table.field2 = access_table.field2, --etc...  (sp_table.field1 <> access_table.field1 , sp_table.id1 = access_table.id1) or (sp_table.field2 <> access_table.field2 , sp_table.id1 = access_table.id1) or --etc... ;

this question seems have same problem, , solution seems plausible, they're both distinctly lacking in detail. i'm not sure how view pk on sharepoint list, or how tell if it's problem.

any ideas on how resolve error?

i able resolve error, though i'm still not sure causing it. went through of fields in where clause, , narrowed issue down 2 fields cause query generate error if included. compared fields in both tables, making sure of field settings identical, wasn't able make query work them.

fortunately me, these fields not particularly vital, , can leave them out, if else has thoughts, i'd love have deeper understanding what's causing issue.

edit

the error cropped again in field did care about, had figure out causing it. looks "invalid argument" error can caused few things, including having size of either sharepoint list, sharepoint site, or access db being large. in case, appears victim of corrupt data.

after narrowing down field causing issue, went through , updated of data elements manually on sharepoint list. doing apparently overwrote corrupt data element causing error, because when ran query again, last few records updated without issue.

bottom line, if happens again, i'm going check size of sp list (no more 5,000 rows), size of sp site (ymmv), size of access db (no more 2gb) , narrow down field giving me error, , try replacing data elements 1 @ time until find corrupted data element.


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more