Цитата:
покажите результат запроса
Код:
mysql> SELECT widths, positions, hiddens FROM user_tables WHERE userId=1 AND table_module='ru.bitel.bgbilling.plugins.crm' AND table_id='task';
+----------------------------------------------------------------+------------------------------------------------+---------------------------------------+
| widths | positions | hiddens |
+----------------------------------------------------------------+------------------------------------------------+---------------------------------------+
| 150,76,120,60,60,120,100,60,60,40,90,150,90,50,100,0,200,35,50 | 14,12,0,1,2,13,3,4,5,6,8,7,10,11,16,17,18,15,9 | 0,1,1,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0 |
+----------------------------------------------------------------+------------------------------------------------+---------------------------------------+
1 row in set (0.00 sec)
Цитата:
еще интересует лог клиента перед этой ошибкой
Вот лог из клиента (открыл биллинг, сразу же открыл вкладку CRM):
Код:
https://xxxxxxxxxxxx:8443/bgbilling/executer/ru.bitel.bgbilling.kernel.admin.messages4users/MessagesForUsersService?wsdl -> {http://common.messages4users.admin.kernel.bgbilling.bitel.ru/}MessagesForUsersService:getLastMessageId
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><ns5:getLastMessageId xmlns:ns5="http://common.messages4users.admin.kernel.bgbilling.bitel.ru/" xmlns:common="http://common.bitel.ru" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/></S:Body></S:Envelope>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Header/><S:Body><ns5:getLastMessageIdResponse xmlns:ns5="http://common.messages4users.admin.kernel.bgbilling.bitel.ru/" xmlns:common="http://common.bitel.ru" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:S="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xml="http://www.w3.org/XML/1998/namespace"><return>0</return></ns5:getLastMessageIdResponse></S:Body></S:Envelope>
https://xxxxxxxxxxxx:8443/bgbilling/executer/ru.bitel.bgbilling.kernel.admin.messages4users/MessagesForUsersService?wsdl -> {http://common.messages4users.admin.kernel.bgbilling.bitel.ru/}MessagesForUsersService:getUserId
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><ns5:getUserId xmlns:ns5="http://common.messages4users.admin.kernel.bgbilling.bitel.ru/" xmlns:common="http://common.bitel.ru" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/></S:Body></S:Envelope>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Header/><S:Body><ns5:getUserIdResponse xmlns:ns5="http://common.messages4users.admin.kernel.bgbilling.bitel.ru/" xmlns:common="http://common.bitel.ru" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:S="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xml="http://www.w3.org/XML/1998/namespace"><return>%1%</return></ns5:getUserIdResponse></S:Body></S:Envelope>
https://xxxxxxxxxxxx:8443/bgbilling/executer/ru.bitel.bgbilling.kernel.admin.messages4users/MessagesForUsersService?wsdl -> {http://common.messages4users.admin.kernel.bgbilling.bitel.ru/}MessagesForUsersService:getMessageListFromLastMessageId
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><ns5:getMessageListFromLastMessageId xmlns:ns5="http://common.messages4users.admin.kernel.bgbilling.bitel.ru/" xmlns:common="http://common.bitel.ru" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><arg0>0</arg0><arg1>%1%</arg1></ns5:getMessageListFromLastMessageId></S:Body></S:Envelope>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Header/><S:Body><ns5:getMessageListFromLastMessageIdResponse xmlns:ns5="http://common.messages4users.admin.kernel.bgbilling.bitel.ru/" xmlns:common="http://common.bitel.ru" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:S="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xml="http://www.w3.org/XML/1998/namespace"/></S:Body></S:Envelope>
https://xxxxxxxxxxxx:8443/bgbilling/executer?table_module=ru.bitel.bgbilling.plugins.crm&module=admin&action=BGTable&table=call&BGBillingSecret=JvQ4KlIOTSWlcBTOrRv5wRol&
[ length = 215 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="19FFA12FD45A87DABE4396462225DB3F" status="ok"><table_param hiddens="0,0,0,0,0,0,0,0" positions="1,3,4,5,0,6,2,7" width="100,130,100,525,60,0,121,0"/></data>
https://xxxxxxxxxxxx:8443/bgbilling/executer?table_module=ru.bitel.bgbilling.plugins.crm&module=admin&action=BGTable&table=history&BGBillingSecret=H53rdniMi5jjYEZjOHt7gLZe&
[ length = 106 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="E150744F122083CC34531684C54B59F8" status="ok"/>
https://xxxxxxxxxxxx:8443/bgbilling/executer?table_module=ru.bitel.bgbilling.plugins.crm&module=admin&action=BGTable&table=problem&BGBillingSecret=KvhpzyRixvalVr2WjzJC7QZV&
[ length = 106 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="77BCCA18F77E7B72F0588037366F579C" status="ok"/>
https://xxxxxxxxxxxx:8443/bgbilling/executer?table_module=ru.bitel.bgbilling.plugins.crm&module=admin&action=BGTable&table=task_log&BGBillingSecret=Jjy3q7CstHlpoB8dEXmmBMdq&
[ length = 106 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="05A186416D59579E27C14DF2417C624B" status="ok"/>
https://xxxxxxxxxxxx:8443/bgbilling/executer?table_module=ru.bitel.bgbilling.plugins.crm&module=admin&action=BGTable&table=task&BGBillingSecret=P7JwstJI1VisKhyNF5zXPHre&
[ length = 304 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="763C6141906EC6A87D0F6599DA0852F9" status="ok"><table_param hiddens="0,1,1,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0" positions="14,12,0,1,2,13,3,4,5,6,8,7,10,11,16,17,18,15,9" width="150,76,120,60,60,120,100,60,60,40,90,150,90,50,100,0,200,35,50"/></data>
java.lang.ArrayIndexOutOfBoundsException: 19
at bitel.billing.module.common.table.BGTable.init(BGTable.java:1592)
at bitel.billing.module.common.table.BGTable.tryInit(BGTable.java:1379)
at bitel.billing.module.common.table.BGTable.setHeader(BGTable.java:491)
at bitel.billing.module.common.table.BGTable.setHeader(BGTable.java:422)
at ru.bitel.bgbilling.plugins.crm.client.common.TaskManager.<init>(TaskManager.java:206)
at ru.bitel.bgbilling.plugins.crm.client.admin.RegisterManager.<init>(RegisterManager.java:36)
at ru.bitel.bgbilling.plugins.crm.client.admin.ActionRegisterManager.doAction(ActionRegisterManager.java:15)
at ru.bitel.bgbilling.client.common.BGMenuBar$MenuAction.actionPerformed(BGMenuBar.java:63)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
at java.awt.Component.processMouseEvent(Component.java:6290)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6055)
at java.awt.Container.processEvent(Container.java:2039)
at java.awt.Component.dispatchEventImpl(Component.java:4653)
at java.awt.Container.dispatchEventImpl(Container.java:2097)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
at java.awt.Container.dispatchEventImpl(Container.java:2083)
at java.awt.Window.dispatchEventImpl(Window.java:2482)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:607)
at java.awt.EventQueue$1.run(EventQueue.java:605)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:621)
at java.awt.EventQueue$2.run(EventQueue.java:619)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
https://xxxxxxxxxxxx:8443/bgbilling/executer?table_module=ru.bitel.bgbilling.plugins.crm&module=admin&action=BGTable&table=work&BGBillingSecret=fuylJdwDIij0QrqOBPoNa8Sj&
[ length = 219 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="DDF7256E91D047DD1827FA2223A3DC29" status="ok"><table_param hiddens="0,0,0,0,0,0,0,0" positions="0,1,2,3,4,5,6,7" width="50,154,154,187,237,100,250,100"/></data>
https://xxxxxxxxxxxx:8443/bgbilling/executer?module=ru.bitel.bgbilling.plugins.crm&action=RegisterSubjectList&BGBillingSecret=KMGBOYUW8jqBnkqxXIuQrECe&
[ length = 386 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="E5893CF814507CB41463F9FB6F681220" status="ok"><list><item id="6" title="Абонент ИНТ"/><item id="5" title="Абонент КТВ"/><item id="7" title="Абонент СТВ"/><item id="10" title="Другое обращение"/><item id="8" title="Пот. абонент ИНТ и КТВ"/><item id="9" title="Пот. абонент СТВ"/></list></data>
Цитата:
версия какая ?
Обновил сегодня, что бы итемы несколько выделялись для массовых действий..
Код:
ru.bitel.bgbilling.plugins.crm вер. 5.2 сборка 181 от 21.06.2012 20:35:50
Сейчас решил приглядеться, в общем проблема в следующем, в таблице CRM задач при выборе задачи, он открывает не по ID задачи, а по порядковому номеру строки в таблице...
Т.е. не зависимо ни от чего, если в списке клацкнуть по 18ой строчке откроется задача с taskId=17, если нажать на 16 откроется задача с taskId=15
Проверил опытным путем в общем =)
У меня часть задач удалена, поэтому из договора при открытии задачи, он не находил задач с id < 10 и показывал пустой и незаполненный редактор