Здравствуйте, при обмене между сайтом и 1с выгружается номенклатура, но не обновляются цены и остатки, 1С выдает следующую ошибку:
Выгружено товаров: 1 704
Выгружено файлов: 0
Выгружено предложений: 1 704
Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Обмен не выполнен
Ответ сервера:
<table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C">
<tr>
<td><table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td bgcolor="#FFFFFF" align="center">
<FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1">
<font color="#FF0000"><b>DB query error.</b></font><br>
Please try later.
</font><br>
</form>
<form method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5">
<input type="hidden" name="last_error_query" value="File: C:\Bitrix_business\www\bitrix\modules\main\include\dbquery_err
Query: UPD ATE b_xml_tree SET RIGHT_MARGIN = 3 WHERE ID = 0
[Table 'bsm_demo.b_xml_tree' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\mysql\database.php
[line] => 194
[class] =>
[function] => include
[args] => Array
(
[0] => C:\Bitrix_business\www\bitrix\modules\main\include\dbquery_error.php
)
)
[1] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\iblock\classes\mysql\cml2.php
[line] => 652
[class] => CDatabaseMysql
[function] => Query
[args] => Array
(
[0] => UPDATE b_xml_tree SE T RIGHT_MARGIN = 3 WHERE ID = 0
)
)
[2] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\iblock\classes\mysql\cml2.php
[line] => 318
[class] => CIBlockXMLFile
[function] => _end_element
[args] => Array
(
[0] => /СтавкиНалогов>
)
)
[3] => Array
(
[file] => C:\Bitrix_business\www\bitrix\components\bitrix\catalog.import.1c\component.php
[line] => 389
[class] => CIBlockXMLFile
[function] => ReadXMLToDatabase
[args] => Array
(
[0] => Resource id #6
[1] => Array
(
[STEP] => 2
[charset] =>
[element_stack] => Array
(
[-1] => Array
(
[R] => 3
)
[0] => Array
(
[R] => 2
)
[1] => Array
(
[ID] => 3
[L] =>
[R] => 1
[RO] => 1
)
[2] => Array
(
[ID] => 4
[L] =>
[R] => 1
[RO] => 1
)
[3] => Array
(
[R] => 2
)
[4] => Array
(
[R] => 4
)
[5] => Array
(
[ID] => 7
[L] =>
[R] => 1
[RO] => 1
)
[6] => Array
(
[ID] => 8
[L] =>
[R] => 1
[RO] => 1
)
[7] => Array
(
[R] => 3
)
[8] => Array
(
[ID] => 10
[L] =>
[R] => 1
[RO] => 1
)
[9] => Array
(
[R] => 2
)
[10] => Array
(
[R] => 3
)
[11] => Array
(
[ID] => 13
[L] =>
[R] => 1
[RO] => 1
)
[12] => Array
(
[R] => 2
)
[13] => Array
(
[R] => 5
)
[14] => Array
(
[ID] => 16
[L] =>
[R] => 1
[RO] => 1
)
[15] => Array
(
[R] => 2
)
[16] => Array
(
[R] => 2
)
[17] => Array
(
[R] => 2
)
[18] => Array
(
[R] => 2
)
[19] => Array
(
[R] => 2
)
[20] => Array
(
[R] => 2
)
[21] => Array
(
[ID] => 23
[L] =>
[R] => 1
[RO] => 1
)
[22] => Array
(
[ID] => 24
[L] =>
[R] => 1
[RO] => 1
)
[23] => Array
(
[R] => 2
)
.................................................................................................................
................................................................................................................
...................................................................................................................
[1932] => Array
(
[R] => 2
)
[1933] => Array
(
[R] => 4
)
)
[file_position] => 168211
)
[2] => 30
)
)
[4] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\component.php
[line] => 472
[class] =>
[function] => include
[args] => Array
(
[0] => C:\Bitrix_business\www\bitrix\components\bitrix\catalog.import.1c\component.php
)
)
[5] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\component.php
[line] => 90
[class] => CBitrixComponent
[function] => __includeComponent
[args] => Array
(
)
)
[6] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\component.php
[line] => 506
[class] => CBitrixComponent
[function] => executeComponent
[args] => Array
(
)
)
[7] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\main.php
[line] => 1011
[class] => CBitrixComponent
[function] => includeComponent
[args] => Array
(
[0] =>
[1] => Array
(
[IBLOCK_TYPE] => 1c_catalog
[SITE_LIST] => Array
(
[0] => s1
)
[INTERVAL] => 30
[GROUP_PERMISSIONS] => Array
(
[0] => 1
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] => 100
[PREVIEW_HEIGHT] => 100
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] => 300
[DETAIL_HEIGHT] => 300
[ELEMENT_ACTION] => N
[SECTION_ACTION] => N
[FILE_SIZE_LIMIT] => 204800
[USE_CRC] => Y
[USE_ZIP] => N
[USE_OFFERS] => N
[FORCE_OFFERS] => N
[USE_IBLOCK_TYPE_ID] => Y
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => Y
[TRANSLIT_ON_UPDATE] => Y
[TRANSLIT_REPLACE_CHAR] => _
[SKIP_ROOT_SECTION] => N
)
[2] =>
)
)
[8] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\sale\admin\1c_exchange.php
[line] => 90
[class] => CAllMain
[function] => IncludeComponent
[args] => Array
(
[0] => bitrix:catalog.import.1c
[1] =>
[2] => Array
(
[IBLOCK_TYPE] => 1c_catalog
[SITE_LIST] => Array
(
[0] => s1
)
[INTERVAL] => 30
[GROUP_PERMISSIONS] => Array
(
[0] => 1
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] => 100
[PREVIEW_HEIGHT] => 100
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] => 300
[DETAIL_HEIGHT] => 300
[ELEMENT_ACTION] => N
[SECTION_ACTION] => N
[FILE_SIZE_LIMIT] => 204800
[USE_CRC] => Y
[USE_ZIP] => N
[USE_OFFERS] => N
[FORCE_OFFERS] => N
[USE_IBLOCK_TYPE_ID] => Y
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => Y
[TRANSLIT_ON_UPDATE] => Y
[TRANSLIT_REPLACE_CHAR] => _
[SKIP_ROOT_SECTION] => N
)
)
)
[9] => Array
(
[file] => C:\Bitrix_business\www\bitrix\admin\1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => C:\Bitrix_business\www\bitrix\modules\sale\admin\1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="1ad95c71895aaac9e91d70beeb39e87a" /> <input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
Выгрузка товаров завершена с ошибками!!!
Память сервера была увеличена
Выгружено товаров: 1 704
Выгружено файлов: 0
Выгружено предложений: 1 704
Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Обмен не выполнен
Ответ сервера:
<table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C">
<tr>
<td><table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td bgcolor="#FFFFFF" align="center">
<FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1">
<font color="#FF0000"><b>DB query error.</b></font><br>
Please try later.
</font><br>
</form>
<form method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5">
<input type="hidden" name="last_error_query" value="File: C:\Bitrix_business\www\bitrix\modules\main\include\dbquery_err
Query: UPD ATE b_xml_tree SET RIGHT_MARGIN = 3 WHERE ID = 0
[Table 'bsm_demo.b_xml_tree' doesn't exist]
debug_backtrace:
Array
(
[0] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\mysql\database.php
[line] => 194
[class] =>
[function] => include
[args] => Array
(
[0] => C:\Bitrix_business\www\bitrix\modules\main\include\dbquery_error.php
)
)
[1] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\iblock\classes\mysql\cml2.php
[line] => 652
[class] => CDatabaseMysql
[function] => Query
[args] => Array
(
[0] => UPDATE b_xml_tree SE T RIGHT_MARGIN = 3 WHERE ID = 0
)
)
[2] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\iblock\classes\mysql\cml2.php
[line] => 318
[class] => CIBlockXMLFile
[function] => _end_element
[args] => Array
(
[0] => /СтавкиНалогов>
)
)
[3] => Array
(
[file] => C:\Bitrix_business\www\bitrix\components\bitrix\catalog.import.1c\component.php
[line] => 389
[class] => CIBlockXMLFile
[function] => ReadXMLToDatabase
[args] => Array
(
[0] => Resource id #6
[1] => Array
(
[STEP] => 2
[charset] =>
[element_stack] => Array
(
[-1] => Array
(
[R] => 3
)
[0] => Array
(
[R] => 2
)
[1] => Array
(
[ID] => 3
[L] =>
[R] => 1
[RO] => 1
)
[2] => Array
(
[ID] => 4
[L] =>
[R] => 1
[RO] => 1
)
[3] => Array
(
[R] => 2
)
[4] => Array
(
[R] => 4
)
[5] => Array
(
[ID] => 7
[L] =>
[R] => 1
[RO] => 1
)
[6] => Array
(
[ID] => 8
[L] =>
[R] => 1
[RO] => 1
)
[7] => Array
(
[R] => 3
)
[8] => Array
(
[ID] => 10
[L] =>
[R] => 1
[RO] => 1
)
[9] => Array
(
[R] => 2
)
[10] => Array
(
[R] => 3
)
[11] => Array
(
[ID] => 13
[L] =>
[R] => 1
[RO] => 1
)
[12] => Array
(
[R] => 2
)
[13] => Array
(
[R] => 5
)
[14] => Array
(
[ID] => 16
[L] =>
[R] => 1
[RO] => 1
)
[15] => Array
(
[R] => 2
)
[16] => Array
(
[R] => 2
)
[17] => Array
(
[R] => 2
)
[18] => Array
(
[R] => 2
)
[19] => Array
(
[R] => 2
)
[20] => Array
(
[R] => 2
)
[21] => Array
(
[ID] => 23
[L] =>
[R] => 1
[RO] => 1
)
[22] => Array
(
[ID] => 24
[L] =>
[R] => 1
[RO] => 1
)
[23] => Array
(
[R] => 2
)
.................................................................................................................
................................................................................................................
...................................................................................................................
[1932] => Array
(
[R] => 2
)
[1933] => Array
(
[R] => 4
)
)
[file_position] => 168211
)
[2] => 30
)
)
[4] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\component.php
[line] => 472
[class] =>
[function] => include
[args] => Array
(
[0] => C:\Bitrix_business\www\bitrix\components\bitrix\catalog.import.1c\component.php
)
)
[5] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\component.php
[line] => 90
[class] => CBitrixComponent
[function] => __includeComponent
[args] => Array
(
)
)
[6] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\component.php
[line] => 506
[class] => CBitrixComponent
[function] => executeComponent
[args] => Array
(
)
)
[7] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\main\classes\general\main.php
[line] => 1011
[class] => CBitrixComponent
[function] => includeComponent
[args] => Array
(
[0] =>
[1] => Array
(
[IBLOCK_TYPE] => 1c_catalog
[SITE_LIST] => Array
(
[0] => s1
)
[INTERVAL] => 30
[GROUP_PERMISSIONS] => Array
(
[0] => 1
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] => 100
[PREVIEW_HEIGHT] => 100
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] => 300
[DETAIL_HEIGHT] => 300
[ELEMENT_ACTION] => N
[SECTION_ACTION] => N
[FILE_SIZE_LIMIT] => 204800
[USE_CRC] => Y
[USE_ZIP] => N
[USE_OFFERS] => N
[FORCE_OFFERS] => N
[USE_IBLOCK_TYPE_ID] => Y
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => Y
[TRANSLIT_ON_UPDATE] => Y
[TRANSLIT_REPLACE_CHAR] => _
[SKIP_ROOT_SECTION] => N
)
[2] =>
)
)
[8] => Array
(
[file] => C:\Bitrix_business\www\bitrix\modules\sale\admin\1c_exchange.php
[line] => 90
[class] => CAllMain
[function] => IncludeComponent
[args] => Array
(
[0] => bitrix:catalog.import.1c
[1] =>
[2] => Array
(
[IBLOCK_TYPE] => 1c_catalog
[SITE_LIST] => Array
(
[0] => s1
)
[INTERVAL] => 30
[GROUP_PERMISSIONS] => Array
(
[0] => 1
)
[GENERATE_PREVIEW] => N
[PREVIEW_WIDTH] => 100
[PREVIEW_HEIGHT] => 100
[DETAIL_RESIZE] => N
[DETAIL_WIDTH] => 300
[DETAIL_HEIGHT] => 300
[ELEMENT_ACTION] => N
[SECTION_ACTION] => N
[FILE_SIZE_LIMIT] => 204800
[USE_CRC] => Y
[USE_ZIP] => N
[USE_OFFERS] => N
[FORCE_OFFERS] => N
[USE_IBLOCK_TYPE_ID] => Y
[USE_IBLOCK_PICTURE_SETTINGS] => N
[TRANSLIT_ON_ADD] => Y
[TRANSLIT_ON_UPDATE] => Y
[TRANSLIT_REPLACE_CHAR] => _
[SKIP_ROOT_SECTION] => N
)
)
)
[9] => Array
(
[file] => C:\Bitrix_business\www\bitrix\admin\1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => C:\Bitrix_business\www\bitrix\modules\sale\admin\1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="1ad95c71895aaac9e91d70beeb39e87a" /> <input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
Выгрузка товаров завершена с ошибками!!!
Память сервера была увеличена
