BiTel

connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerSet - Connecting to device
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - post: https://smart.XXX.XX:443/api/jsonrpc/
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - >> {"method":"authorize_user","id":24,"jsonrpc":"2.0","params":{"password":"vc7iZktcDM","username":"admin"}}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - << {"jsonrpc":"2.0","id":24,"result":{"id":1,"session_id":"45d11ec661594ab3b0d19eaaefa27868","language_iso639_1":"ru"}}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerDeviceWorker - Do task deviceId: 3; Event[ru.bitel.bgbilling.modules.tv.access.om.event.OmTvAccountModifyEvent] moduleId: 1; pluginId: no; cid: global; scid: -1; userId: -1; deviceId: 0; oldTvAccount: Account: 1; newTvAccount: Account: 1; newState: 1; timestamp: 1465810989604
connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerDeviceWorker - Command result event: ru.bitel.bgbilling.modules.tv.access.om.AccountOrderEvent@7421abf9
connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerDeviceWorker - Processing deviceId:3; command ru.bitel.bgbilling.modules.tv.access.om.AccountOrderEvent@7421abf9
connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerSet - Invoking accountModify
connection 06-13/13:43:09  INFO [sa-p-6-t-60] IptvPortalOrderManager - accountModify
connection 06-13/13:43:09  INFO [sa-p-6-t-60] IptvPortalOrderManager - accountModify0
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - post: https://smart.XXX.XX:443/api/jsonsql/
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - {Iptvportal-Authorization=sessionid=45d11ec661594ab3b0d19eaaefa27868}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - >> {"method":"update","id":25,"jsonrpc":"2.0","params":{"set":{"password":"QRBDv3","max_terminal":3,"surname":"","disabled":false,"language_id":1,"middle_name":"","first_name":"","email":"","username":"1"},"returning":"id","where":{"eq":["id","472911"]},"table":"subscriber"}}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - << {"result":[472911],"id":25,"method":"update"}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] IptvPortalOrderManager - terminalModify
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - post: https://smart.XXX.XX:443/api/jsonsql/
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - {Iptvportal-Authorization=sessionid=45d11ec661594ab3b0d19eaaefa27868}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - >> {"method":"insert","id":26,"jsonrpc":"2.0","params":{"into":"terminal","columns":["subscriber_id","mac_addr","inet_addr","profile_id","registration_id","session_id","language_id","disabled"],"returning":"id","values":[472911,"11:22:33:11:22:33","123",0,"","",1,false]}}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - << {"error":{"message":"invalid input syntax for type inet: \"123\"\nLINE 1: ...isabled, mac_addr, domain_id) values ('',472911,0,'123','',1...\n                                                             ^\n"},"id":26,"method":"insert"}
connection 06-13/13:43:09 ERROR [sa-p-6-t-60] IptvPortalJsonClient - Error while insert: invalid input syntax for type inet: "123"
LINE 1: ...isabled, mac_addr, domain_id) values ('',472911,0,'123','',1...
                                                             ^

connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - post: https://smart.XXX.XX:443/api/jsonsql/
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - {Iptvportal-Authorization=sessionid=45d11ec661594ab3b0d19eaaefa27868}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - >> {"method":"update","id":27,"jsonrpc":"2.0","params":{"set":{"subscriber_id":472911,"mac_addr":"11:22:33:11:22:33","profile_id":0,"registration_id":"","session_id":"","disabled":false,"language_id":1},"returning":"id","where":{"eq":["id","-1"]},"table":"terminal"}}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - << {"result":[],"id":27,"method":"update"}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - post: https://smart.XXX.XX:443/api/jsonsql/
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - {Iptvportal-Authorization=sessionid=45d11ec661594ab3b0d19eaaefa27868}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - >> {"method":"select","id":28,"jsonrpc":"2.0","params":{"data":["package_id"],"from":"subscriber_package","where":{"eq":["subscriber_id","472911"]}}}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] JsonClient - << {"result":[],"id":28,"method":"select"}
connection 06-13/13:43:09  INFO [sa-p-6-t-60] IptvPortalOrderManager - Current packageIds: [], need packageIds: []
connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerDeviceWorker - Process event type[2] result=true
connection 06-13/13:43:09  INFO [sa-p-6-t-60] OrderManagerDeviceWorker - Changing TvAccount:382 state and/or options
mq 06-13/13:43:09  INFO [event-proc-p-2-t-1] TvAccountRuntimeMap - Caught event: Event[ru.bitel.bgbilling.modules.tv.api.common.event.TvAccountModifiedEvent] moduleId: 1; pluginId: no; cid: 342; scid: -1; userId: 1; timestamp: 1465810989722
mq 06-13/13:43:09  INFO [event-proc-p-2-t-1] TvAccountRuntimeMap - Adding new accountRuntime: 382
mq 06-13/13:43:09  INFO [event-proc-p-2-t-1] TvAccountRuntimeMap - Loading TvAccount from database.
mq 06-13/13:43:09  INFO [event-proc-p-2-t-1] TvAccountRuntimeMap - Adding TvAccountRuntime: 382
mq 06-13/13:43:09  INFO [event-proc-p-2-t-1] TvAccountRuntimeMap - ContractId: 342; tvAccountId: 382
        SMART: 112233112233] TariffModuleTreeSet [1:10.06.2016-?; ]
        Device state: 0; serviceIds:
mq 06-13/13:43:09  INFO [event-proc-p-2-t-1] TvAccountRuntimeMap - Caught event: Event[ru.bitel.bgbilling.modules.tv.access.event.TvAccountDeviceStateAndOptionsModifiedEvent] moduleId: 1; pluginId: no; cid: global; scid: -1; userId: -1; deviceId: 3; tvAccountId: 382; state: 1; optionIds: ; timestamp: 1465810989995

Сервер: вер. 7.0.1050 / 06.06.2016 19:12:37
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_73

  card: вер. 7.0.38 / 26.05.2016 17:24:17
  reports: вер. 7.0.210 / 06.06.2016 18:29:00
  tv: вер. 7.0.212 / 06.06.2016 18:32:20

connection 06-14/14:19:41  INFO [sa-p-6-t-85] JsonClient - << {"error":{"message":"invalid input syntax for type inet: \"\"\nLINE 1: ...isabled, mac_addr, domain_id) values ('',472911,0,'','',1,fa...\n                                                             ^\n"},"id":25,"method":"insert"}
connection 06-14/14:19:41 ERROR [sa-p-6-t-85] IptvPortalJsonClient - Error while insert: invalid input syntax for type inet: ""
LINE 1: ...isabled, mac_addr, domain_id) values ('',472911,0,'','',1,fa...

IptvPortalJsonClient - Error while insert: duplicate key value violates unique constraint "terminal_domain_id_key"
DETAIL:  Key (domain_id, mac_addr)=(413, 3c:cd:93:86:b8:85) already exists