powered by simpleCommunicator - 2.0.51     © 2025 Programmizd 02
Форумы / [игнор отключен] [закрыт для гостей] / Ошибка SQL при формировании материальных ведомостей в 1С
1 сообщений из 1, страница 1 из 1
Ошибка SQL при формировании материальных ведомостей в 1С
    #35224293
Фотография ser9a
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
При формировании материальной ведомости выдает ошибку:
Ошибка СУБД:
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
...
Рейтинг: 0 / 0
1 сообщений из 1, страница 1 из 1
Форумы / [игнор отключен] [закрыт для гостей] / Ошибка SQL при формировании материальных ведомостей в 1С
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]