Форум OlegON > Ресурсы OlegON > Вопросы сервера > Программы OlegON

Оптимизатор, заполнение контракта ценами : Программы OlegON

23.11.2024 7:51


1 2
█ 05.07.2011 09:23
Спасибо, потихоньку завертелось. Привожу лог:
Цитата:
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
Не обрабатывается условие, что по штрих-коду артикул не найден???
█ 05.07.2011 09:26
Заполнилась 151 позиция из 173. Предполагаю, что ошибки из-за отсутствия штрихкода в базе...
█ 05.07.2011 09:43
Я еще даже не заявлял в основной теме о том, что этот параметр есть, потому, что тестировать надо. Для 151 позиции зверско долго, но думаю, что косяки отсутствия артикула или в принципе база тупит, поскольку в итоге приходится штрихкод в артикул преобразовывать. Ошибки отсутствия артикула буду обрабатывать. Не успел еще.
█ 06.07.2011 07:48
Добавил обработку нулевого артикула для вставки, пишет теперь вообще погуще. Предлагаю посмотреть, где тупит, если продолжает тупить.
Часовой пояс GMT +3, время: 07:51.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.