BiTel

Информация о версии:

  Клиент: вер. 5.2 сборка 1017 от 06.08.2012 11:20:40
    os: Windows 2003; java: Java HotSpot(TM) Client VM, v.1.6.0_33
  Сервер: вер. 5.2 сборка 1267 от 07.08.2012 15:49:43
    os: Windows 2003; java: Java HotSpot(TM) Client VM, v.1.6.0_33

  inet вер. 5.2 сборка 949 от 07.08.2012 15:49:41
  ipn вер. 5.2 сборка 234 от 06.08.2012 11:20:52
  mps вер. 5.2 сборка 153 от 06.08.2012 11:21:08
  npay вер. 5.2 сборка 186 от 06.08.2012 11:21:09
  reports вер. 5.2 сборка 179 от 06.08.2012 11:21:20
  ru.bitel.bgbilling.plugins.cladr вер. 5.2 сборка 106 от 06.08.2012 11:21:12

<response>
<result>
300
</result>
<osmp_txn_id>
5000003
</osmp_txn_id>
<prv_txn>
0
</prv_txn>
<sum/>
<comment>
Внутренняя ошибка сервера биллинга
</comment>
</response>

mps.1.mode=1
mps.1.protocol=osmp
mps.1.title=ОСМП
mps.1.pid=3
mps.1.search.mode=contract
mps.1.numberPattern=\A\d{5,}\z
mps.1.login=1111
mps.1.passw=1111

https://127.0.0.1:8443//bgbilling/mpsexecuter/6/1?command=pay&txn_id=5000003&account=00007&sum=10.00&pay_type=0&txn_date=20120814143807

erver 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.mps_payment_seq_6' doesn't exist
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at java.lang.reflect.Constructor.newInstance(Unknown Source)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.Util.getInstance(Util.java:386)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.bean.MPSPaymentManager.addPayment(MPSPaymentManager.java:716)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.bean.MPSPaymentManager.addPayment(MPSPaymentManager.java:658)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.bean.MPSPaymentManager.addPayment(MPSPaymentManager.java:572)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.bean.OSMPAbstractPaymentManager.processRequest(OSMPAbstractPaymentManager.java:132)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.bean.MPSPaymentManager.processRequest(MPSPaymentManager.java:425)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.MPSExecuter.doPost(MPSExecuter.java:102)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.mps.MPSExecuter.doGet(MPSExecuter.java:43)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
server 08-14/22:25:08 ERROR ["http-bio-/0.0.0.0-8443"-exec-2] LoggingPrintStream -    at java.lang.Thread.run(Unknown Source)

Table 'bgbilling.mps_payment_seq_6' doesn't exist

mysql> SELECT * FROM mps_payment_6 WHERE trans_id='5000001' AND mps_id=1;
ERROR 1146 (42S02): Table 'bgbilling.mps_payment_6' doesn't exist

mysql> SELECT * FROM mps_payment_6_201208 WHERE trans_id='5000001' AND mps_id=1;

+----+--------+-----+-------+---------------------+---------------------+-------
-+----------+------+------+-----------+
| id | mps_id | cid | summ  | time                | local_time          | status
 | trans_id | pid  | type | rawNumber |
+----+--------+-----+-------+---------------------+---------------------+-------
-+----------+------+------+-----------+
|  2 |      1 |  32 | 10.00 | 2012-08-03 14:38:07 | 2012-08-08 10:59:28 |      1
 | 5000001  |  200 |    0 | 00006     |
+----+--------+-----+-------+---------------------+---------------------+-------
-+----------+------+------+-----------+
1 row in set (0.00 sec)

Table 'bgbilling.mps_payment_seq_6' doesn't exist

          7 Execute   SELECT * FROM mps_payment_6_201208 WHERE trans_id='5000001' AND mps_id=1
          7 Execute   SELECT * FROM contract WHERE id=32

mps_payment_seq_{mid}   sequence (генератор) для mps_payment_mid_month

mysql> show tables from bgbilling like '%mps_payment_seq%';
+-----------------------------------------+
| Tables_in_bgbilling (%mps_payment_seq%) |
+-----------------------------------------+
| mps_payment_seq_8                       |
+-----------------------------------------+
1 row in set (0.01 sec)

mysql>

mysql> show tables from bgbilling like '%mps_payment_seq%';
Empty set (0.00 sec)

mysql> show tables from bgbilling like '%mps_payment%';
+-------------------------------------+
| Tables_in_bgbilling (%mps_payment%) |
+-------------------------------------+
| mps_payment_6_201208                |
+-------------------------------------+
1 row in set (0.02 sec)