|
Ошибка SQL при формировании материальных ведомостей в 1С
|
|||
---|---|---|---|
#18+
При формировании материальной ведомости выдает ошибку: Ошибка СУБД: Microsoft OLE DB Provider for SQL Server: There is insufficient system memory to run this query. HRESULT=80040E14, SQLSTATE=42000, native=701 по причине: Microsoft OLE DB Provider for SQL Server: There is insufficient system memory to run this query. HRESULT=80040E14, SQLSTATE=42000, native=701 1c: 1С:Предприятие 8.0 (8.0.16.2) СУБД: SQL2000 awe включил дал 6 гигов Сервер: HP Proliant DL 580 4 Intel Xeon 3.66 ГГц 8 Гб ОЗУ Win2003 Выделил под файл подкачки еще 6 Гигов Profiler во время возникновения ошибки пишет ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.06 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.060 ErrorLog 2008-03-31 13:54:09.07 spid72 WARNING: Failed to reserve contiguous memory of Size= 65536. 1CV8 sa 2580 72 2008-03-31 13:54:09.077 ErrorLog 2008-03-31 13:54:09.15 spid72 Buffer Distribution: Stolen=27434 Free=54225 Procedures=122632 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Procedure Cache: TotalProcs=34155 TotalPages=122632 InUsePages=62987 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Dynamic Memory Manager: Stolen=150066 OS Reserved=32960 OS Committed=32163 OS In Use=31595 Query Plan=159806 Optimizer=0 General=19924 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8591 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Buffer Distribution: Stolen=27434 Free=54225 Procedures=122632 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Procedure Cache: TotalProcs=34155 TotalPages=122632 InUsePages=62987 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Dynamic Memory Manager: Stolen=150066 OS Reserved=32960 OS Committed=32163 OS In Use=31595 Query Plan=159806 Optimizer=0 General=19924 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8591 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.15 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.153 ErrorLog 2008-03-31 13:54:09.20 spid72 Buffer Distribution: Stolen=45220 Free=54225 Procedures=104846 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Procedure Cache: TotalProcs=34153 TotalPages=104846 InUsePages=50743 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Dynamic Memory Manager: Stolen=150066 OS Reserved=32960 OS Committed=32163 OS In Use=31595 Query Plan=159806 Optimizer=0 General=19924 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8591 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Buffer Distribution: Stolen=45480 Free=54225 Procedures=104586 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Procedure Cache: TotalProcs=34152 TotalPages=104586 InUsePages=50540 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Dynamic Memory Manager: Stolen=150066 OS Reserved=32960 OS Committed=32163 OS In Use=31595 Query Plan=159806 Optimizer=0 General=19924 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8591 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.20 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.200 ErrorLog 2008-03-31 13:54:09.21 spid72 Buffer Distribution: Stolen=46242 Free=54341 Procedures=103708 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.217 ErrorLog 2008-03-31 13:54:09.21 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.217 ErrorLog 2008-03-31 13:54:09.21 spid72 Procedure Cache: TotalProcs=34152 TotalPages=103708 InUsePages=49697 1CV8 sa 2580 72 2008-03-31 13:54:09.217 ErrorLog 2008-03-31 13:54:09.21 spid72 Dynamic Memory Manager: Stolen=149914 OS Reserved=32928 OS Committed=32131 OS In Use=31547 Query Plan=159616 Optimizer=0 General=19914 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.217 ErrorLog 2008-03-31 13:54:09.21 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8581 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.217 ErrorLog 2008-03-31 13:54:09.21 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.217 ErrorLog 2008-03-31 13:54:09.23 spid72 Buffer Distribution: Stolen=46114 Free=54469 Procedures=103708 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Procedure Cache: TotalProcs=34151 TotalPages=103708 InUsePages=49648 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Dynamic Memory Manager: Stolen=149814 OS Reserved=32840 OS Committed=32043 OS In Use=31465 Query Plan=159398 Optimizer=0 General=19950 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8581 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Buffer Distribution: Stolen=46091 Free=54492 Procedures=103708 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Procedure Cache: TotalProcs=34151 TotalPages=103708 InUsePages=49648 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Dynamic Memory Manager: Stolen=149791 OS Reserved=32816 OS Committed=32019 OS In Use=31436 Query Plan=159329 Optimizer=0 General=19966 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8581 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Buffer Distribution: Stolen=46055 Free=54528 Procedures=103708 Inram=0 Dirty=6207 Kept=0 I/O=0, Latched=943, Other=706063 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Buffer Counts: Commited=917504 Target=917504 Hashed=713213 InternalReservation=1073 ExternalReservation=2064 Min Free=256 Visible= 199888 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Procedure Cache: TotalProcs=34150 TotalPages=103708 InUsePages=49648 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Dynamic Memory Manager: Stolen=149752 OS Reserved=32808 OS Committed=32016 OS In Use=31432 Query Plan=159267 Optimizer=0 General=19986 Utilities=575 Connection=321 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Global Memory Objects: Resource=3874 Locks=859 SQLCache=8581 Replication=2 LockBytes=2 ServerGlobal=28 Xact=55 1CV8 sa 2580 72 2008-03-31 13:54:09.233 ErrorLog 2008-03-31 13:54:09.23 spid72 Query Memory Manager: Grants=1 Waiting=0 Maximum=84904 Available=82840 1CV8 sa 2580 72 2008-03-31 13:54:09.233 Exception Error: 701, Severity: 17, State: 200 1CV8 sa 2580 72 2008-03-31 13:54:09.247 Exception Error: 701, Severity: 17, State: 200 1CV8 sa 2580 72 2008-03-31 13:54:09.263 Exception Error: 701, Severity: 17, State: 200 1CV8 sa 2580 72 2008-03-31 13:54:09.280 Exception Error: 701, Severity: 17, State: 200 1CV8 sa 2580 72 2008-03-31 13:54:09.280 Exception Error: 701, Severity: 17, State: 200 1CV8 sa 2580 72 2008-03-31 13:54:09.280 Exception Error: 701, Severity: 17, State: 200 1CV8 sa 2580 72 2008-03-31 13:54:09.280 ... |
|||
:
Нравится:
Не нравится:
|
|||
31.03.2008, 13:31 |
|
|
start [/forum/topic.php?fid=28&fpage=171&tid=1524880]: |
0ms |
get settings: |
7ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
33ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
33ms |
get tp. blocked users: |
2ms |
others: | 320ms |
total: | 430ms |
0 / 0 |