forum.bitel.ru http://forum.bitel.ru/ |
|
Проблема с начислением абон платы http://forum.bitel.ru/viewtopic.php?f=16&t=4519 |
Страница 1 из 1 |
Автор: | max [ 06 сен 2010, 12:02 ] |
Заголовок сообщения: | Проблема с начислением абон платы |
Пытаюсь начислить абон плату за позапрошлый месяц договору, и ничего не выходит. Вот логи: Код: scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 837656 sid => 28 time => 01.09.2010 10:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 29684 sid => 29 time => 01.09.2010 10:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 576696 sid => 28 time => 01.09.2010 11:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 9475 sid => 29 time => 01.09.2010 11:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 1084401 sid => 28 time => 01.09.2010 12:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 7569 sid => 29 time => 01.09.2010 12:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 485533 sid => 28 time => 01.09.2010 13:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 7679 sid => 29 time => 01.09.2010 13:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Contract id: 5 scheduler 09-06/11:48:04 ERROR [pool-2-thread-1] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 478769 sid => 28 time => 01.09.2010 14:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/11:48:05 ERROR [pool-2-thread-1] LogCalculator - Detected errors => 27440 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 837656 sid => 28 time => 01.09.2010 10:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 29684 sid => 29 time => 01.09.2010 10:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 576696 sid => 28 time => 01.09.2010 11:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 9475 sid => 29 time => 01.09.2010 11:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 1084401 sid => 28 time => 01.09.2010 12:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 7569 sid => 29 time => 01.09.2010 12:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 485533 sid => 28 time => 01.09.2010 13:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 7679 sid => 29 time => 01.09.2010 13:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Contract id: 5 scheduler 09-06/12:00:07 ERROR [pool-2-thread-10] LogCalculator - Request accepted => false relevance => -1 REQ: amount => 478769 sid => 28 time => 01.09.2010 14:00:00 tariffOptions => action => calculate part_tariff => 1.0 cid => 5 costTypeRangeTakeAllSet => [1] RESP: HIST: wasn't accepted! scheduler 09-06/12:00:09 ERROR [pool-2-thread-10] LogCalculator - Detected errors => 27440 Код: 09-06/12:01:10 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@12c0932 09-06/12:01:10 INFO [pool-1-thread-5] Recalculator - PaymentRecalculator time: 31.05.2010 23 09-06/12:01:10 INFO [pool-1-thread-5] Utils - Memory total: 352 452 608; max: 1 740 832 768; free: 229 971 832 09-06/12:01:10 INFO [pool-1-thread-5] Utils - Memory pools: Non-heap memory[Code Cache]: max: 50 331 648; used: 7 984 000; peek: 7 986 432 Heap memory[PS Eden Space]: max: 186 318 848; used: 74 922 488; peek: 182 124 544 Heap memory[PS Survivor Space]: max: 131 072; used: 0; peek: 12 969 136 Heap memory[PS Old Gen]: max: 1 606 942 720; used: 47 558 288; peek: 160 483 272 Non-heap memory[PS Perm Gen]: max: 67 108 864; used: 14 511 376; peek: 14 511 976 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Memory total: 352 452 608; max: 1 740 832 768; free: 229 971 832 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Setting balances for independ and subs.. 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Selected. 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Selecting sub account 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Selected. 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Setting balance for super.. 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Selected. 09-06/12:01:10 INFO [pool-1-thread-5] Calculator - Task finished time=34 ms. 09-06/12:05:00 INFO [Thread-5] TaskExecuter - Starting periodic taks ID: 15 bitel.billing.server.load.TaskGenerator 09-06/12:05:00 INFO [Thread-5] TaskExecuter - Starting periodic taks ID: 21 bitel.billing.server.mail.MailSender 09-06/12:05:00 INFO [pool-2-thread-8] TaskGenerator - Task finished time=11 ms. 09-06/12:05:00 INFO [pool-2-thread-9] MailSender - Task finished time=15 ms. Код: cat scheduler.out Checking port 9066... Port is free starting the applicalion... Starting TEProccessManager on 9066 Creating socket on 9066 java.lang.NullPointerException at bitel.billing.plugin.BaseManager.getDBTableName(BaseManager.java:56) at ru.bitel.bgbilling.plugins.helpdesk.server.bean.TopicManager.getTopicList(TopicManager.java:90) at ru.bitel.bgbilling.plugins.helpdesk.server.task.TopicAvtoClosedTask.executeTask(TopicAvtoClosedTask.java:56) at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:53) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) java.lang.NullPointerException at bitel.billing.plugin.BaseManager.getDBTableName(BaseManager.java:56) at ru.bitel.bgbilling.plugins.helpdesk.server.bean.TopicManager.getTopicList(TopicManager.java:90) at ru.bitel.bgbilling.plugins.helpdesk.server.task.TopicAvtoClosedTask.executeTask(TopicAvtoClosedTask.java:56) at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:53) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) npay v.5.0 build 226 from 05.07.2010 16:38:25 |
Автор: | max [ 07 сен 2010, 21:52 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
up |
Автор: | Boris [ 08 сен 2010, 09:43 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
А при чем тут логи LogCalculator это же ipn что значит не выходит, нет наработки? тариф в позапрошлом месяце подключен, абонплаты стоят? |
Автор: | max [ 08 сен 2010, 22:29 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
про ipn и логкалькулятор выложил не подумавши.... Цитата: что значит не выходит, нет наработки? именно так Цитата: тариф в позапрошлом месяце подключен, да Цитата: абонплаты стоят? да собственно может проблема в том что данный договор был восстановлен из архива? но все даты проверил всё ок! тариф юзается персональный. |
Автор: | Boris [ 10 сен 2010, 12:25 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
Попробуте перевести логи в режим DEBUG. И сделать переобсчет, посмотрим что получиьтся |
Автор: | max [ 10 сен 2010, 22:35 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
Код: 09-10/22:36:46 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@1f86c83 09-10/22:36:46 INFO [pool-1-thread-13] Recalculator - PaymentRecalculator time: 31.05.2010 23 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Services: -1,10,8,7,15,16,19,20,21,23,24,25,26,27,33,34,46,60,108 09-10/22:36:46 INFO [pool-1-thread-13] Utils - Memory total: 1 524 826 112; max: 1 740 832 768; free: 1 405 564 096 09-10/22:36:46 INFO [pool-1-thread-13] Utils - Memory pools: Non-heap memory[Code Cache]: max: 50 331 648; used: 10 144 448; peek: 10 263 232 Heap memory[PS Eden Space]: max: 158 334 976; used: 3 559 792; peek: 185 073 664 Heap memory[PS Survivor Space]: max: 21 299 200; used: 0; peek: 66 912 240 Heap memory[PS Old Gen]: max: 1 606 942 720; used: 115 702 224; peek: 1 606 942 720 Non-heap memory[PS Perm Gen]: max: 67 108 864; used: 14 948 696; peek: 15 040 848 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Memory total: 1 524 826 112; max: 1 740 832 768; free: 1 405 564 096 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Found service taker cid: 182; sid: 7; date1: 07.08.2009; date2: ; col: 1 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - After trimming cid: 182; sid: 7; date1: 01.05.2010; date2: 31.05.2010 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Tariff period: 01.01.2010- 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Request in tree: 301 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - accepted => false PARAMS: mid: 6; cid: 182 NPayServiceCost [serviceId: 7; date1: 01.05.2010; date2: 31.05.2010; serviceStart: 07.08.2009; serviceEnd: ; accountingPeriodDays: 31; amount: 1; cost: null; HIST:. 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Request after processing: 301 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - accepted => true PARAMS: mid: 6; cid: 182 NPayServiceCost [serviceId: 7; date1: 01.05.2010; date2: 31.05.2010; serviceStart: 07.08.2009; serviceEnd: ; accountingPeriodDays: 31; amount: 1; cost: 0; ad HIST: Day mode: NPayServiceCost [serviceId: 7; date1: 01.05.2010; date2: 31.05.2010; serviceStart: 07.08.2009; serviceEnd: ; accountingPeriodDays: 31; amount Service 7 closed at 01.05.2010 Service 7 closed at 02.05.2010 Service 7 closed at 03.05.2010 Service 7 closed at 04.05.2010 Service 7 closed at 05.05.2010 Service 7 closed at 06.05.2010 Service 7 closed at 07.05.2010 Service 7 closed at 08.05.2010 Service 7 closed at 09.05.2010 Service 7 closed at 10.05.2010 Service 7 closed at 11.05.2010 Service 7 closed at 12.05.2010 Service 7 closed at 13.05.2010 Service 7 closed at 14.05.2010 Service 7 closed at 15.05.2010 Service 7 closed at 16.05.2010 Service 7 closed at 17.05.2010 Service 7 closed at 18.05.2010 Service 7 closed at 19.05.2010 Service 7 closed at 20.05.2010 Service 7 closed at 21.05.2010 Service 7 closed at 22.05.2010 Service 7 closed at 23.05.2010 Service 7 closed at 24.05.2010 Service 7 closed at 25.05.2010 Service 7 closed at 26.05.2010 Service 7 closed at 27.05.2010 Service 7 closed at 28.05.2010 Service 7 closed at 29.05.2010 Service 7 closed at 30.05.2010 Service 7 closed at 31.05.2010 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Add cost cache cid: 182; sid: 7; cost: 0 09-10/22:36:46 DEBUG [pool-1-thread-13] Calculator - Add detail amount cache cid: 182; sid: 7; mid: 6; eid: 0; cost: 0.0 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Setting balances for independ and subs.. 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Selected. 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Selecting sub account 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Selected. 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Setting balance for super... 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Selected. 09-10/22:36:46 INFO [pool-1-thread-13] Calculator - Task finished time=54 ms. 09-10/22:37:02 DEBUG [Thread-5] TaskExecuter - Looking tasks я так понимаю что дело вот в этом ? Service 7 closed at 31.05.2010 верно? если да то не понятно откуда берётся! закрытый период у нас 2006 год вообще! |
Автор: | Boris [ 13 сен 2010, 10:04 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
да он считает что закрыта услуга, это не закрытый период а дата закрытия договра попробуйте выполнить вот так SELECT status.cid, status.date1, status.date2 FROM contract_status AS status LEFT JOIN contract_module ON status.cid=contract_module.cid WHERE status.status=3 AND (status.date1 IS NULL OR status.date1<=$endDate) AND (status.date2 IS NULL OR status.date2>=$beginDate) AND contract_module.mid=$mid AND status.cid =$cid где после $ поставте выши значения |
Автор: | max [ 14 сен 2010, 11:22 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
исполнил вот такой запрос SELECT status.cid, status.date1, status.date2 FROM contract_status AS status LEFT JOIN contract_module ON status.cid=contract_module.cid WHERE status.status=3 AND (status.date1 IS NULL OR status.date1<=2010-12-31) AND (status.date2 IS NULL OR status.date2>=2009-01-01) AND contract_module.mid=6 AND status.cid =182 ответ пустой. |
Автор: | Boris [ 14 сен 2010, 11:30 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
а попробуйте SELECT status.cid, status.date1, status.date2 FROM contract_status AS status LEFT JOIN contract_module ON status.cid=contract_module.cid WHERE (status.date1 IS NULL OR status.date1<=2010-12-31) AND (status.date2 IS NULL OR status.date2>=2009-01-01) AND contract_module.mid=6 AND status.cid =182 |
Автор: | max [ 14 сен 2010, 17:35 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
пустой ответ |
Автор: | Boris [ 14 сен 2010, 17:49 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
т.е. что у него вообще никаких изменений статусов нет. покажите скрин статусов договра, чтобы было видно какой у него статус и какая история статусов |
Автор: | max [ 14 сен 2010, 22:31 ] | ||
Заголовок сообщения: | Re: Проблема с наячислением абон платы | ||
пожалуйста
|
Автор: | Boris [ 15 сен 2010, 08:37 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
вы считаете с date1: 01.05.2010; по date2: 31.05.2010; а с 01.04.2010 по по 01.09.2010 договор закрыт, соответственно абонплата за это время не начисляеться. |
Автор: | max [ 15 сен 2010, 22:16 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
да но договор то фактически не закрыт! верхняя дата конечная (её не видно на скриншоте) отсутствует. Просто договор был воостановлен из архива |
Автор: | Boris [ 16 сен 2010, 09:54 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
я не так выразился, это не дата закрытия если вы посмотрите на статусы то увидите что с 30.04 по 01.09 договор в статусе закрыт, и абонплата там не идет, после 1.09 считйте наздоровье, или исправте статусы |
Автор: | max [ 16 сен 2010, 22:26 ] |
Заголовок сообщения: | Re: Проблема с наячислением абон платы |
понял вас, спасибо. |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |