[ОТВЕТИТЬ]
Опции темы
05.07.2011 09:23  
anderson
Спасибо, потихоньку завертелось. Привожу лог:
Цитата:
05.07.11 15:22:12 -- Contract number : КПМ000002
05.07.11 15:25:55 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:25:56 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:25:56 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:27:11 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:27:12 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:27:12 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:31:45 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:31:45 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:31:46 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:31:58 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:31:58 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:31:59 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:32:20 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:32:20 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:32:21 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:34:39 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:34:39 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:34:40 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:34:51 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:34:51 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:34:52 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:36:46 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:36:47 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:36:47 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:37:54 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:37:55 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:37:55 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:39:18 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:39:19 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:39:19 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:41:42 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:41:43 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:41:43 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:42:28 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:42:28 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:42:29 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:43:21 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:43:21 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:43:22 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:43:48 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:43:48 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:43:49 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:44:09 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:44:10 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:44:10 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:44:27 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:44:28 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:44:28 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:44:36 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:44:36 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:44:37 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:45:35 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:45:35 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:45:36 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:46:18 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:46:19 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:46:19 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:48:19 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:48:20 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:48:20 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:50:40 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:50:40 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:50:40 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:50:48 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-01400: cannot insert NULL into ("SUPERMAG"."SMSPEC"."ARTICLE")
05.07.11 15:50:48 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCSPECCO_SPECITEM) violated - parent key not found
05.07.11 15:50:49 -- OLEGON-ERROR! : Query:192.168.10.1:sevtorg:java.sql.SQLException: ORA-02291: integrity constraint (SUPERMAG.SMCCONTRACTPACKS_SPECITEM) violated - parent key not found
05.07.11 15:52:10 -- Process completed... Used:173 Uncompleted:0
Долговато однако... Или так и должно быть?
 
05.07.2011 09:24  
Mtirt
Не обрабатывается условие, что по штрих-коду артикул не найден???
 
05.07.2011 09:26  
anderson
Заполнилась 151 позиция из 173. Предполагаю, что ошибки из-за отсутствия штрихкода в базе...
 
05.07.2011 09:43  
OlegON
Я еще даже не заявлял в основной теме о том, что этот параметр есть, потому, что тестировать надо. Для 151 позиции зверско долго, но думаю, что косяки отсутствия артикула или в принципе база тупит, поскольку в итоге приходится штрихкод в артикул преобразовывать. Ошибки отсутствия артикула буду обрабатывать. Не успел еще.
 
06.07.2011 07:48  
OlegON
Добавил обработку нулевого артикула для вставки, пишет теперь вообще погуще. Предлагаю посмотреть, где тупит, если продолжает тупить.
 
 


Опции темы



Часовой пояс GMT +3, время: 00:56.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.