UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> System Resource Exceeded, On Big Table 825942 Rows (-2147467259), Access 2013    
 
   
pacala_ba
post Jun 5 2017, 07:38 AM
Post#1



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi
Access FE 2013, reopen
about 20 link tables to local DB
One problem table "KUM_R_W_CDF_TRM_MAN" with 825942...ROWS iconfused.gif
CODE
FOR I = 1 TO 10: DEBUG.Print I,TT_GET_ROWS_COUNT("KUM_R_W_CDF_TRM_MAN") : NEXT i

sometimes one loop, sometimes first try with error....

CODE
? cSQL
SELECT COUNT(*) AS [X__PCT] FROM [KUM_R_W_CDF_TRM_MAN]
Set CNN0 = CurrentProject.Connection
' ....................FIRST TRY
RS0.Open cSQL & ";", CNN0, adOpenForwardOnly, adLockReadOnly, adCmdText
? ERR, ERR.Description
-2147217887   Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
' 825942...ROWS ON TABLE KUM_R_W_CDF_TRM_MAN
' ....................SECOND TRY
RS0.Open cSQL & ";", CNN0, adOpenForwardOnly, adLockReadOnly, adCmdText
? ERR, ERR.Description
-2147467259   System resource exceeded.

I can browse table...

WIN 7 Enterprise , SP1, 8GB RAM
? Sys_GetProcessMemory("msaccess.exe")
151.8 MB iconfused.gif

It is inside nested procedures.....
AFTER PROCEDURE (TT_GET_ROWS_COUNT)... EXIT
ALL IS WORKING.... dazed.gif
TT_GET_ROWS_COUNT) with other tables .....OK dazed.gif

Access FE 2013, reopen
Query .....SELECT COUNT(*) AS [X__PCT] FROM [KUM_R_W_CDF_TRM_MAN]
Execute
........... System resource exceeded
Compact repair
825942...ROWS ........OK
Execute
........... System resource exceeded
MUST BE.... Access FE 2013, reopen + Compact repair iconfused.gif
ONLY COMPACT REPAIR.......does not work


Query Execute....System resource exceeded...Compact repair
Query Execute....System resource exceeded...Compact repair
....SOMETIMES 2 TIMES SUCCESS pullhair.gif
This post has been edited by pacala_ba: Jun 5 2017, 08:31 AM

--------------------
Go to the top of the page
 
pacala_ba
post Jun 5 2017, 08:40 AM
Post#2



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi,
This QUERY works ALLWAYS yayhandclap.gif
without count(*) iconfused.gif
CODE
SELECT Count(A.DV) AS X_PCT FROM KUM_R_W_CDF_TRM_MAN AS A;


Recordset.......OK thumbup.gif
CODE
FOR
cSQL = "SELECT Count(A.DV) AS X_PCT FROM KUM_R_W_CDF_TRM_MAN AS A"
RS0.Open cSQL & ";", CNN0, adOpenStatic, adLockReadOnly, adCmdText
RS0.CLOSE
NEXT


System resource exceeded.... shrug.gif
SELECT COUNT(*) AS [X__PCT] FROM [KUM_R_W_CDF_TRM_MAN]....

System resource exceeded.... shrug.gif
? CurrentDb.OpenRecordset("SELECT COUNT(*) AS [X__PCT] FROM [KUM_R_W_CDF_TRM_MAN]")!X__PCT

Library ADODB confused.gif
C:\Program Files (x86)\Common Files\System\ado\msado15.dll
Microsoft ActiveX Data Objects 6.1 Library
? FILEDATETIME("C:\Program Files (x86)\Common Files\System\ado\msado15.dll")
21/04/2017 17:15:34
This post has been edited by pacala_ba: Jun 5 2017, 09:15 AM

--------------------
Go to the top of the page
 
pacala_ba
post Jun 5 2017, 10:12 AM
Post#3



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi
some rows deleted
table.... KUM_R_W_CDF_TRM_MAN 171402 ....rows
When running MyProcedure COUNT ROWS FOR ABOUT 25 TABLES , AND SAVE TO TABLE...
First run....OK
Second run......again the same troubles... pullhair.gif
ALL tables ROWS COUNT.....~975 903

--------------------
Go to the top of the page
 
pacala_ba
post Jun 6 2017, 04:43 AM
Post#4



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


I found there is HOTFIX ...

--------------------
Go to the top of the page
 
pacala_ba
post Jun 7 2017, 09:10 AM
Post#5



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi,
my Admin was not able to install KB2760362 32 BIT pullhair.gif
Error: Required Product version not found in system
I am Running MS-OFFICE-2010 + MS-ACCESS-2013

WIN 7 ENTERPRISE, MS ACCESS 2013 ( 15.0.4893.1000) MSO ( 15.0.4927.1000) 32 BIT
This post has been edited by pacala_ba: Jun 7 2017, 09:11 AM

--------------------
Go to the top of the page
 
pacala_ba
post Jun 8 2017, 03:30 AM
Post#6



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi,
HotFix for: The expected version of the product was not found on the system
OK, INSTALLED
But Problem still persist, success about 90%... shrug.gif

--------------------
Go to the top of the page
 
pacala_ba
post Jun 8 2017, 07:38 AM
Post#7



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi,
Solution from: Microsoft Office for Developers.Access for Developers iconfused.gif

--------------------
Go to the top of the page
 
pacala_ba
post Jun 19 2017, 07:10 AM
Post#8



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi,
Microsoft Office for Developers.Access for Developers iconfused.gif
TEST DB Direct Download
...on me allways with problems pullhair.gif
This post has been edited by pacala_ba: Jun 19 2017, 07:12 AM

--------------------
Go to the top of the page
 
pacala_ba
post Jun 21 2017, 03:34 AM
Post#9



Posts: 606
Joined: 19-March 09
From: Europe, SLOVAKIA, Bratislava


Hi,
MS Solution via UserVoice..

I can see that if I use windows 7 I can able to reproduce the issue.
so for that please try to provide your feedback to Access User Voice. iconfused.gif dazed.gif
Welcome to Access Suggestion Box!
as a work around if you are available with Windows 10 system then we can avoid this error.
Regards
MSDN Community Support

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th September 2017 - 06:16 AM