API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 19th, 2017
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 185.19 KB | None | 0 0
raw download clone embed print report
  1. [BEGIN] 19.10.2017 12:09:01
  2. [2017-10-19 15:09:04,486] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO UssdHttpServlet:doPost:159 ID:- U:- - Request received /uss/servlet/ussdHttpServlet.ru?ussd=1554476&msisdn=7711112343 from: 10.127.242.199
  3. [2017-10-19 15:09:04,487] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG UssdHttpServlet:findLangFromRequest:80 ID:- U:- - locale from URL: ru
  4. [2017-10-19 15:09:04,489] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144489-kz-ussapppl01.kar-tel U:- - Method VIPRequestProcessorEJB.sendRequestToQueue invoked with parameters [VIPRequestDO(ctn=7711112343, BAN=0, BEN=0, marketCode=null, bn=1554476, params=null, jmsId=dminServer, date=Thu Oct 19 15:09:04 ALMT 2017, additionalParams={ussd=1554476, LANG=ru_RU, msisdn=7711112343, USSDHTTP=true}, accountType=null, interface_type=2)].
  5. [2017-10-19 15:09:04,491] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG RPDAO:checkLockTable:324 ID:1508404144489-kz-ussapppl01.kar-tel U:- - RP_LOCK[7711112343/1554476]: empty
  6. [2017-10-19 15:09:04,493] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG RPDAO:setLockTable:351 ID:1508404144489-kz-ussapppl01.kar-tel U:- - insert into RP_LOCK[7711112343/1554476/dminServer]
  7. [2017-10-19 15:09:04,495] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144495-kz-ussapppl01.kar-tel U:- - Method VIPQueueSenderEJB.sendMessage invoked with parameters [VIPRequestDO(ctn=7711112343, BAN=0, BEN=0, marketCode=null, bn=1554476, params=null, jmsId=dminServer, date=Thu Oct 19 15:09:04 ALMT 2017, additionalParams={USSDHTTP=true, ussd=1554476, msisdn=7711112343, LANG=ru_RU}, accountType=null, interface_type=2), jms/BSSRPQueue].
  8. [2017-10-19 15:09:04,501] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144495-kz-ussapppl01.kar-tel U:- - Method VIPQueueSenderEJB.sendMessage invocation with parameters [VIPRequestDO(ctn=7711112343, BAN=0, BEN=0, marketCode=null, bn=1554476, params=null, jmsId=dminServer, date=Thu Oct 19 15:09:04 ALMT 2017, additionalParams={USSDHTTP=true, ussd=1554476, msisdn=7711112343, LANG=ru_RU}, accountType=null, interface_type=2), jms/BSSRPQueue] has been completed in 6 ms.
  9. [2017-10-19 15:09:04,502] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:- U:- - Method VIPRequestProcessorEJB.sendRequestToQueue invocation with parameters [VIPRequestDO(ctn=7711112343, BAN=0, BEN=0, marketCode=null, bn=1554476, params=null, jmsId=dminServer, date=Thu Oct 19 15:09:04 ALMT 2017, additionalParams={ussd=1554476, LANG=ru_RU, msisdn=7711112343, USSDHTTP=true}, accountType=null, interface_type=2)] has been completed in 13 ms.
  10. [2017-10-19 15:09:04,510] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144509-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getAccountType invoked with parameters [7711112343].
  11. [2017-10-19 15:09:04,510] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144509-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.billing.dl.VIPAppRetrieveAccountTypeSrv generateRetrieveSqlString sql is: SELECT BA.ACCOUNT_TYPE, BA.BAN, BA.MARKET_CODE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.BAN_STATUS, SUB.SUB_STATUS, SUB.INIT_ACTIVATION_DATE, SUB.DEFAULT_RC_BEN, SUB.CURRENT_PP, SUB.FUTURE_PP, SUB.NGP, SUB.ALLOW_EASY_CCN, SUB.SUB_STATUS_RSN_CODE, SUB.PRODUCT_CODE, SUB.DISCOUNT_DATE_END, SUB.PP_PEN_PER_START_DATE FROM ECR9_BILLING_ACCOUNT BA, ECR9_ADDRESS_NAME_LINK ANL, ECR9_SUBSCRIBER SUB WHERE 1=1 AND BA.BAN = SUB.CUSTOMER_ID and SUB.SUB_STATUS in ('A','S') AND SUB.SUBSCRIBER_NO = ? AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = 'T'
  12. [2017-10-19 15:09:04,511] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404144509-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.ACCOUNT_TYPE, BA.BAN, BA.MARKET_CODE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.BAN_STATUS, SUB.SUB_STATUS, SUB.INIT_ACTIVATION_DATE, SUB.DEFAULT_RC_BEN, SUB.CURRENT_PP, SUB.FUTURE_PP, SUB.NGP, SUB.ALLOW_EASY_CCN, SUB.SUB_STATUS_RSN_CODE, SUB.PRODUCT_CODE, SUB.DISCOUNT_DATE_END, SUB.PP_PEN_PER_START_DATE FROM ECR9_BILLING_ACCOUNT BA, ECR9_ADDRESS_NAME_LINK ANL, ECR9_SUBSCRIBER SUB WHERE 1=1 AND BA.BAN = SUB.CUSTOMER_ID and SUB.SUB_STATUS in ('A','S') AND SUB.SUBSCRIBER_NO = ? AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = 'T'
  13. [2017-10-19 15:09:04,511] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404144509-kz-ussapppl01.kar-tel U:- - {1: 7711112343 }
  14. [2017-10-19 15:09:04,512] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404144509-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.billing.dl.VIPAppRetrieveAccountTypeSrv Filling statement with parameters: <VIPRetrieveAccountTypeParamsDO><CTN>7711112343</CTN><ban>null</ban></VIPRetrieveAccountTypeParamsDO>
  15. [2017-10-19 15:09:04,513] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404144509-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.billing.dl.VIPAppRetrieveAccountTypeSrv
  16. init/exec/read:2/1/0 Total: 3
  17. [2017-10-19 15:09:04,515] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG VIPCustomServicesBO:retrieveAccountTypeExtended:93 ID:1508404144509-kz-ussapppl01.kar-tel U:- - account_type=com.amdocs.css.vip.billing.data.VIPRetrieveAccountTypeDO@8e962a8
  18. [2017-10-19 15:09:04,516] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144509-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getAccountType invocation with parameters [7711112343] has been completed in 7 ms.
  19. [2017-10-19 15:09:04,516] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG ProcessRequestBO:getCurrentRule:124 ID:- U:- - getCurrentRule[1014885], ctn[ctnType=1, corpType=2, intType=2, subType=1], rule[ctnType=3, corpType=3, intType=6, subType=3]
  20. [2017-10-19 15:09:04,517] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG ProcessRequestBO:getCurrentRule:130 ID:- U:- - found rule for ctn type
  21. [2017-10-19 15:09:04,522] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144521-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberBillingAccount invoked with parameters [7711112343].
  22. [2017-10-19 15:09:04,522] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144521-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S')
  23. [2017-10-19 15:09:04,522] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404144521-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S')
  24. [2017-10-19 15:09:04,523] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404144521-kz-ussapppl01.kar-tel U:- - {1: 7711112343 }
  25. [2017-10-19 15:09:04,523] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404144521-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=0, defaultRcBen=0, objectID=0)
  26. [2017-10-19 15:09:04,525] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404144521-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv
  27. init/exec/read:1/2/0 Total: 3
  28. [2017-10-19 15:09:04,526] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144521-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberBillingAccount invocation with parameters [7711112343] has been completed in 5 ms.
  29. [2017-10-19 15:09:04,531] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144531-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  30. [2017-10-19 15:09:04,532] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144531-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  31. [2017-10-19 15:09:04,532] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144531-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  32. [2017-10-19 15:09:04,532] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144531-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  33. [2017-10-19 15:09:04,532] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144531-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  34. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  35. <allInfo type=boolean>true</allInfo>
  36. </com.amdocs.css.vip.account.data.AccountFilterDO>
  37. <com.amdocs.css.core.util.data.DataObject>
  38. </com.amdocs.css.core.util.data.DataObject>
  39. <java.lang.Object>
  40. </java.lang.Object>
  41.  
  42. [2017-10-19 15:09:04,533] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144531-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  43. init/exec/read:2/0/0 Total: 2
  44. [2017-10-19 15:09:04,534] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144531-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 3 ms.
  45. [2017-10-19 15:09:04,538] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144538-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invoked with parameters [13].
  46. [2017-10-19 15:09:04,538] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144538-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invocation with parameters [13] has been completed in 0 ms.
  47. [2017-10-19 15:09:04,542] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144542-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  48. [2017-10-19 15:09:04,543] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144542-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  49. [2017-10-19 15:09:04,543] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144542-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  50. [2017-10-19 15:09:04,544] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144542-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  51. [2017-10-19 15:09:04,544] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144542-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  52. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  53. <allInfo type=boolean>true</allInfo>
  54. </com.amdocs.css.vip.account.data.AccountFilterDO>
  55. <com.amdocs.css.core.util.data.DataObject>
  56. </com.amdocs.css.core.util.data.DataObject>
  57. <java.lang.Object>
  58. </java.lang.Object>
  59.  
  60. [2017-10-19 15:09:04,545] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144542-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  61. init/exec/read:1/1/0 Total: 2
  62. [2017-10-19 15:09:04,545] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144542-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 3 ms.
  63. [2017-10-19 15:09:04,549] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144549-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invoked with parameters [13].
  64. [2017-10-19 15:09:04,550] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144549-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invocation with parameters [13] has been completed in 1 ms.
  65. [2017-10-19 15:09:04,554] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144553-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  66. [2017-10-19 15:09:04,554] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144553-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  67. [2017-10-19 15:09:04,554] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144553-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  68. [2017-10-19 15:09:04,555] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144553-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  69. [2017-10-19 15:09:04,555] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144553-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  70. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  71. <allInfo type=boolean>true</allInfo>
  72. </com.amdocs.css.vip.account.data.AccountFilterDO>
  73. <com.amdocs.css.core.util.data.DataObject>
  74. </com.amdocs.css.core.util.data.DataObject>
  75. <java.lang.Object>
  76. </java.lang.Object>
  77.  
  78. [2017-10-19 15:09:04,556] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144553-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  79. init/exec/read:1/1/0 Total: 2
  80. [2017-10-19 15:09:04,556] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144553-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 3 ms.
  81. [2017-10-19 15:09:04,561] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144561-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberInfoAsync invoked with parameters [7711112343].
  82. [2017-10-19 15:09:04,561] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144561-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S')
  83. [2017-10-19 15:09:04,562] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404144561-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S')
  84. [2017-10-19 15:09:04,562] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404144561-kz-ussapppl01.kar-tel U:- - {1: 7711112343 }
  85. [2017-10-19 15:09:04,562] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404144561-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=0, defaultRcBen=0, objectID=0)
  86. [2017-10-19 15:09:04,564] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404144561-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv
  87. init/exec/read:1/2/0 Total: 3
  88. [2017-10-19 15:09:04,564] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144561-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberInfoAsync invocation with parameters [7711112343] has been completed in 3 ms.
  89. [2017-10-19 15:09:04,568] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144568-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getB2CCurrency invoked with parameters [<VIPBillingAccountDO>
  90. <ban>172882952</ban>
  91. <accountType>13</accountType>
  92. <billCycle>7</billCycle>
  93. <banStatus>O</banStatus>
  94. <vatExemptInd>null</vatExemptInd>
  95. <registerInd>Y</registerInd>
  96. <marketCode>KZT</marketCode>
  97. <payerBan>0</payerBan>
  98. <payerBanInd>null</payerBanInd>
  99. <creditClass>1</creditClass>
  100. <creditLimitAmt>0.0</creditLimitAmt>
  101. <newCycle>0</newCycle>
  102. <accountCategory>P</accountCategory>
  103. <cugEligibilityInd>false</cugEligibilityInd>
  104. <cugId>0</cugId>
  105. <banGroup>null</banGroup>
  106. <banCurrencyInd>D</banCurrencyInd>
  107. <historicalBanInd>null</migrationStatus>
  108. <linkedBan>0</linkedBan>
  109. <unifiedBillBanInd>null</unifiedBillBanInd><unifiedBillBan>0</unifiedBillBan><payerBanAccessInd>null</payerBanAccessInd>
  110. <cycleMonth>0</cycleMonth>
  111. <defaultRcBen>1</defaultRcBen>
  112. <nbFieldsToUpdate>0</nbFieldsToUpdate>
  113. <listNames>[null, null, null, null, null]</listNames><counterIndicator>0</counterIndicator><taxId>null</taxId><replaceSimAbility>false</replaceSimAbility></VIPBillingAccountDO>
  114. , VIPSubscriberDO(subscriberNumber=7711112343, customerId=172882952, initActDate=2017-09-13, subStatus=A, subStatusDate=2017-09-13, subStatusLastAct=NAC, subStatusRsnCode=PR , defaultRcBen=1, productCode=GVOI, lastActCode=null, lastActRsn=null, lastActDate=null, limitOptionAmtValue=0.0, limitOptionAmt=0.0, currentPP=SEV_KZT2, futurePP=null, pairedResourceTp=S, currentPPDesc=????, futurePPDesc=null, futurePPDate=null, subStatusDesc=null, actCodeRsnDesc=null, accountCategory=null, viewLinkStr=view, errorChangeStatus=false, sysUpdateDate=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N)].
  115. [2017-10-19 15:09:04,569] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144568-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getB2CCurrency invocation with parameters [<VIPBillingAccountDO>
  116. <ban>172882952</ban>
  117. <accountType>13</accountType>
  118. <billCycle>7</billCycle>
  119. <banStatus>O</banStatus>
  120. <vatExemptInd>null</vatExemptInd>
  121. <registerInd>Y</registerInd>
  122. <marketCode>KZT</marketCode>
  123. <payerBan>0</payerBan>
  124. <payerBanInd>null</payerBanInd>
  125. <creditClass>1</creditClass>
  126. <creditLimitAmt>0.0</creditLimitAmt>
  127. <newCycle>0</newCycle>
  128. <accountCategory>P</accountCategory>
  129. <cugEligibilityInd>false</cugEligibilityInd>
  130. <cugId>0</cugId>
  131. <banGroup>null</banGroup>
  132. <banCurrencyInd>D</banCurrencyInd>
  133. <historicalBanInd>null</migrationStatus>
  134. <linkedBan>0</linkedBan>
  135. <unifiedBillBanInd>null</unifiedBillBanInd><unifiedBillBan>0</unifiedBillBan><payerBanAccessInd>null</payerBanAccessInd>
  136. <cycleMonth>0</cycleMonth>
  137. <defaultRcBen>1</defaultRcBen>
  138. <nbFieldsToUpdate>0</nbFieldsToUpdate>
  139. <listNames>[null, null, null, null, null]</listNames><counterIndicator>0</counterIndicator><taxId>null</taxId><replaceSimAbility>false</replaceSimAbility></VIPBillingAccountDO>
  140. , VIPSubscriberDO(subscriberNumber=7711112343, customerId=172882952, initActDate=2017-09-13, subStatus=A, subStatusDate=2017-09-13, subStatusLastAct=NAC, subStatusRsnCode=PR , defaultRcBen=1, productCode=GVOI, lastActCode=null, lastActRsn=null, lastActDate=null, limitOptionAmtValue=0.0, limitOptionAmt=0.0, currentPP=SEV_KZT2, futurePP=null, pairedResourceTp=S, currentPPDesc=????, futurePPDesc=null, futurePPDate=null, subStatusDesc=null, actCodeRsnDesc=null, accountCategory=null, viewLinkStr=view, errorChangeStatus=false, sysUpdateDate=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N)] has been completed in 0 ms.
  141. [2017-10-19 15:09:04,572] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144572-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  142. [2017-10-19 15:09:04,573] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144572-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  143. [2017-10-19 15:09:04,573] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144572-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  144. [2017-10-19 15:09:04,574] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144572-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  145. [2017-10-19 15:09:04,574] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144572-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  146. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  147. <allInfo type=boolean>true</allInfo>
  148. </com.amdocs.css.vip.account.data.AccountFilterDO>
  149. <com.amdocs.css.core.util.data.DataObject>
  150. </com.amdocs.css.core.util.data.DataObject>
  151. <java.lang.Object>
  152. </java.lang.Object>
  153.  
  154. [2017-10-19 15:09:04,575] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144572-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  155. init/exec/read:1/1/0 Total: 2
  156. [2017-10-19 15:09:04,575] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144572-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 3 ms.
  157. [2017-10-19 15:09:04,580] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144580-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveConnectedSocsAsync invoked with parameters [ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]].
  158. [2017-10-19 15:09:04,581] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144580-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv generateRetrieveSqlString sql is: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type='O' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  159. [2017-10-19 15:09:04,582] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:1508404144580-kz-ussapppl01.kar-tel U:- - SQL: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type='O' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  160. [2017-10-19 15:09:04,582] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:1508404144580-kz-ussapppl01.kar-tel U:- - {1: 2017-10-19, 2: 172882952, 3: 7711112343 }
  161. [2017-10-19 15:09:04,582] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:1508404144580-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv Filling statement with parameters: ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]
  162. [2017-10-19 15:09:04,582] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144582-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  163. [2017-10-19 15:09:04,583] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144582-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  164. [2017-10-19 15:09:04,583] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144582-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  165. [2017-10-19 15:09:04,583] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:1508404144580-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  166. init/exec/read:2/0/0 Total: 2
  167. [2017-10-19 15:09:04,584] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144582-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  168. [2017-10-19 15:09:04,584] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144582-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  169. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  170. <allInfo type=boolean>true</allInfo>
  171. </com.amdocs.css.vip.account.data.AccountFilterDO>
  172. <com.amdocs.css.core.util.data.DataObject>
  173. </com.amdocs.css.core.util.data.DataObject>
  174. <java.lang.Object>
  175. </java.lang.Object>
  176.  
  177. [2017-10-19 15:09:04,585] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144582-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  178. init/exec/read:1/1/0 Total: 2
  179. [2017-10-19 15:09:04,585] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144582-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 3 ms.
  180. [2017-10-19 15:09:04,586] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144580-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveConnectedSocsAsync invocation with parameters [ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]] has been completed in 6 ms.
  181. [2017-10-19 15:09:04,589] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144589-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invoked with parameters [13].
  182. [2017-10-19 15:09:04,590] [[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144589-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invocation with parameters [13] has been completed in 1 ms.
  183. [2017-10-19 15:09:04,594] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144594-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  184. [2017-10-19 15:09:04,594] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144594-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  185. [2017-10-19 15:09:04,595] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144594-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  186. [2017-10-19 15:09:04,595] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144594-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  187. [2017-10-19 15:09:04,595] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144594-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  188. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  189. <allInfo type=boolean>true</allInfo>
  190. </com.amdocs.css.vip.account.data.AccountFilterDO>
  191. <com.amdocs.css.core.util.data.DataObject>
  192. </com.amdocs.css.core.util.data.DataObject>
  193. <java.lang.Object>
  194. </java.lang.Object>
  195.  
  196. [2017-10-19 15:09:04,596] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144594-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  197. init/exec/read:1/1/0 Total: 2
  198. [2017-10-19 15:09:04,597] [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144594-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 2 ms.
  199. [2017-10-19 15:09:04,601] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144601-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invoked with parameters [13].
  200. [2017-10-19 15:09:04,601] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144601-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getAccountTypeAsync invocation with parameters [13] has been completed in 0 ms.
  201. [2017-10-19 15:09:04,605] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144605-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invoked with parameters [172882952].
  202. [2017-10-19 15:09:04,605] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144605-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  203. [2017-10-19 15:09:04,606] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144605-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  204. [2017-10-19 15:09:04,606] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144605-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  205. [2017-10-19 15:09:04,606] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144605-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  206. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  207. <allInfo type=boolean>true</allInfo>
  208. </com.amdocs.css.vip.account.data.AccountFilterDO>
  209. <com.amdocs.css.core.util.data.DataObject>
  210. </com.amdocs.css.core.util.data.DataObject>
  211. <java.lang.Object>
  212. </java.lang.Object>
  213.  
  214. [2017-10-19 15:09:04,607] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144605-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  215. init/exec/read:1/1/0 Total: 2
  216. [2017-10-19 15:09:04,608] [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144605-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getBillingAccountInfoAsync invocation with parameters [172882952] has been completed in 3 ms.
  217. [2017-10-19 15:09:04,612] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144612-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveSubscriberPricePlanInfoAsync invoked with parameters [7711112343, 172882952, {"rootType":"AdditionRecipientWebEntityInfo","state":{"currency":"RUR","marketCode":"KZT","prepaid":true,"b2C":true}}].
  218. [2017-10-19 15:09:04,613] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144612-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv generateRetrieveSqlString sql is: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type='P' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  219. [2017-10-19 15:09:04,613] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:1508404144612-kz-ussapppl01.kar-tel U:- - SQL: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type='P' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  220. [2017-10-19 15:09:04,614] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:1508404144612-kz-ussapppl01.kar-tel U:- - {1: 2017-10-19, 2: 172882952, 3: 7711112343 }
  221. [2017-10-19 15:09:04,614] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:1508404144612-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv Filling statement with parameters: ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]
  222. [2017-10-19 15:09:04,616] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:1508404144612-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  223. init/exec/read:1/1/1 Total: 3
  224. [2017-10-19 15:09:04,619] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144612-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SERVICE_FEATURE WHERE ban = ? and subscriber_no = ? and (ftr_expiration_date > ? or ftr_expiration_date is null)
  225. [2017-10-19 15:09:04,620] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:137 ID:1508404144612-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SERVICE_FEATURE WHERE ban = ? and subscriber_no = ? and (ftr_expiration_date > ? or ftr_expiration_date is null)
  226. [2017-10-19 15:09:04,620] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:1508404144612-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: 7711112343 , 3: 2017-10-19}
  227. [2017-10-19 15:09:04,620] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:145 ID:1508404144612-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)
  228. [2017-10-19 15:09:04,623] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:1508404144612-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv
  229. init/exec/read:1/1/2 Total: 4
  230. [2017-10-19 15:09:04,624] [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144612-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveSubscriberPricePlanInfoAsync invocation with parameters [7711112343, 172882952, {"rootType":"AdditionRecipientWebEntityInfo","state":{"currency":"RUR","marketCode":"KZT","prepaid":true,"b2C":true}}] has been completed in 12 ms.
  231. [2017-10-19 15:09:04,629] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:168 ID:- U:- - resolveMode: icome [SOCS/SIZE][3/[TP_BUND, TP_2, TP2_DL]]
  232. [2017-10-19 15:09:04,629] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:190 ID:- U:- - resolveMode: check size [3]
  233. [2017-10-19 15:09:04,632] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:197 ID:- U:- - resolveMode: 2nd soc in not connected call recursively resolveMode()
  234. [2017-10-19 15:09:04,633] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:168 ID:- U:- - resolveMode: icome [SOCS/SIZE][2/[TP_BUND, TP_2]]
  235. [2017-10-19 15:09:04,633] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:177 ID:- U:- - resolveMode: check size [2]
  236. [2017-10-19 15:09:04,636] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:184 ID:- U:- - resolveMode: 1st soc in not connected call recursively resolveMode()
  237. [2017-10-19 15:09:04,636] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:168 ID:- U:- - resolveMode: icome [SOCS/SIZE][1/[TP_BUND]]
  238. [2017-10-19 15:09:04,636] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:171 ID:- U:- - resolveMode: check size [1]
  239. [2017-10-19 15:09:04,636] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:174 ID:- U:- - resolveMode: set MODE=[FIRST_SOC]
  240. [2017-10-19 15:09:04,636] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:204 ID:- U:- - resolveMode: finish return MODE=[FIRST_SOC]
  241. [2017-10-19 15:09:04,637] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:204 ID:- U:- - resolveMode: finish return MODE=[FIRST_SOC]
  242. [2017-10-19 15:09:04,637] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractPromisedPaymentExtraApiType:resolveMode:204 ID:- U:- - resolveMode: finish return MODE=[FIRST_SOC]
  243. [2017-10-19 15:09:04,643] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144643-kz-ussapppl01.kar-tel U:- - Method PromisedPaymentEJB.getPromisedPaymentCriteria invoked with parameters [7711112343, KZT, false, false, true].
  244. [2017-10-19 15:09:04,644] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG VIPPromisedPaymentDAO:isHlc:32 ID:1508404144643-kz-ussapppl01.kar-tel U:- - VIPPromisedPaymentDAO.isHlc(ctn=7711112343)
  245. [2017-10-19 15:09:04,647] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144646-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberInfo invoked with parameters [7711112343].
  246. [2017-10-19 15:09:04,647] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144646-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S')
  247. [2017-10-19 15:09:04,648] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404144646-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S')
  248. [2017-10-19 15:09:04,648] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404144646-kz-ussapppl01.kar-tel U:- - {1: 7711112343 }
  249. [2017-10-19 15:09:04,649] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404144646-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=0, defaultRcBen=0, objectID=0)
  250. [2017-10-19 15:09:04,650] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404144646-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv
  251. init/exec/read:2/1/0 Total: 3
  252. [2017-10-19 15:09:04,651] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144646-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberInfo invocation with parameters [7711112343] has been completed in 5 ms.
  253. [2017-10-19 15:09:04,653] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144652-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberByPK invoked with parameters [VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=1, objectID=0)].
  254. [2017-10-19 15:09:04,653] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144652-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S') and customer_id = ?
  255. [2017-10-19 15:09:04,654] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404144652-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S') and customer_id = ?
  256. [2017-10-19 15:09:04,654] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404144652-kz-ussapppl01.kar-tel U:- - {1: 7711112343 , 2: 172882952}
  257. [2017-10-19 15:09:04,655] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404144652-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=1, objectID=0)
  258. [2017-10-19 15:09:04,656] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404144652-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv
  259. init/exec/read:2/1/0 Total: 3
  260. [2017-10-19 15:09:04,656] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144652-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberByPK invocation with parameters [VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=1, objectID=0)] has been completed in 4 ms.
  261. [2017-10-19 15:09:04,659] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144659-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveSubscriberPricePlanInfo invoked with parameters [VIPSubscriberDO(subscriberNumber=7711112343, customerId=172882952, initActDate=2017-09-13, subStatus=A, subStatusDate=2017-09-13, subStatusLastAct=NAC, subStatusRsnCode=PR , defaultRcBen=1, productCode=GVOI, lastActCode=null, lastActRsn=null, lastActDate=null, limitOptionAmtValue=0.0, limitOptionAmt=0.0, currentPP=SEV_KZT2, futurePP=null, pairedResourceTp=S, currentPPDesc=????, futurePPDesc=null, futurePPDate=null, subStatusDesc=null, actCodeRsnDesc=null, accountCategory=null, viewLinkStr=view, errorChangeStatus=false, sysUpdateDate=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N), {"rootType":"AdditionRecipientWebEntityInfo","state":{"currency":"USD","marketCode":"KZT","prepaid":true,"b2C":true}}].
  262. [2017-10-19 15:09:04,660] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144659-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv generateRetrieveSqlString sql is: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type='P' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  263. [2017-10-19 15:09:04,661] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:1508404144659-kz-ussapppl01.kar-tel U:- - SQL: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type='P' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  264. [2017-10-19 15:09:04,661] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:1508404144659-kz-ussapppl01.kar-tel U:- - {1: 2017-10-19, 2: 172882952, 3: 7711112343 }
  265. [2017-10-19 15:09:04,662] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:1508404144659-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv Filling statement with parameters: ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]
  266. [2017-10-19 15:09:04,663] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:1508404144659-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  267. init/exec/read:2/1/0 Total: 3
  268. [2017-10-19 15:09:04,667] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144659-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SERVICE_FEATURE WHERE ban = ? and subscriber_no = ? and (ftr_expiration_date > ? or ftr_expiration_date is null)
  269. [2017-10-19 15:09:04,667] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:137 ID:1508404144659-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SERVICE_FEATURE WHERE ban = ? and subscriber_no = ? and (ftr_expiration_date > ? or ftr_expiration_date is null)
  270. [2017-10-19 15:09:04,668] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:1508404144659-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: 7711112343 , 3: 2017-10-19}
  271. [2017-10-19 15:09:04,668] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:145 ID:1508404144659-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)
  272. [2017-10-19 15:09:04,671] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:1508404144659-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv
  273. init/exec/read:1/1/2 Total: 4
  274. [2017-10-19 15:09:04,672] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144659-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveSubscriberPricePlanInfo invocation with parameters [VIPSubscriberDO(subscriberNumber=7711112343, customerId=172882952, initActDate=2017-09-13, subStatus=A, subStatusDate=2017-09-13, subStatusLastAct=NAC, subStatusRsnCode=PR , defaultRcBen=1, productCode=GVOI, lastActCode=null, lastActRsn=null, lastActDate=null, limitOptionAmtValue=0.0, limitOptionAmt=0.0, currentPP=SEV_KZT2, futurePP=null, pairedResourceTp=S, currentPPDesc=????, futurePPDesc=null, futurePPDate=null, subStatusDesc=null, actCodeRsnDesc=null, accountCategory=null, viewLinkStr=view, errorChangeStatus=false, sysUpdateDate=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N), {"rootType":"AdditionRecipientWebEntityInfo","state":{"currency":"USD","marketCode":"KZT","prepaid":true,"b2C":true}}] has been completed in 13 ms.
  275. [2017-10-19 15:09:04,674] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144674-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.getSocFamilyIdBySoc invoked with parameters [SEV_KZT2].
  276. [2017-10-19 15:09:04,677] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144674-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.getSocFamilyIdBySoc invocation with parameters [SEV_KZT2] has been completed in 3 ms.
  277. [2017-10-19 15:09:04,678] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv generateRetrieveSqlString sql is: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.SOC = ? AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  278. [2017-10-19 15:09:04,678] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.SOC = ? AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  279. [2017-10-19 15:09:04,679] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: N, 2: N, 3: N, 4: SEV_KZT2, 5: N, 6: N, 7: N, 8: N}
  280. [2017-10-19 15:09:04,679] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv Filling statement with parameters: PromisedPaymentCriteriaFilterDO(ctn=7711112343, marketCode=KZT, autoTP=false, hls=false, roaming=false, minimalOnly=true, tms=false, currentTPSoc=SEV_KZT2, socFamilyId=SEV_KZT, bundled=false)
  281. [2017-10-19 15:09:04,681] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv
  282. init/exec/read:1/2/0 Total: 3
  283. [2017-10-19 15:09:04,681] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv generateRetrieveSqlString sql is: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.SOC_FAMILY_ID = ? and ppc.SOC is null AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  284. [2017-10-19 15:09:04,681] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.SOC_FAMILY_ID = ? and ppc.SOC is null AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  285. [2017-10-19 15:09:04,682] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: N, 2: N, 3: N, 4: SEV_KZT, 5: N, 6: N, 7: N, 8: N}
  286. [2017-10-19 15:09:04,682] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv Filling statement with parameters: PromisedPaymentCriteriaFilterDO(ctn=7711112343, marketCode=KZT, autoTP=false, hls=false, roaming=false, minimalOnly=true, tms=false, currentTPSoc=SEV_KZT2, socFamilyId=SEV_KZT, bundled=false)
  287. [2017-10-19 15:09:04,684] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv
  288. init/exec/read:2/1/0 Total: 3
  289. [2017-10-19 15:09:04,684] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv generateRetrieveSqlString sql is: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.MARKET_CODE = ? and ppc.SOC is null and ppc.SOC_FAMILY_ID is null AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  290. [2017-10-19 15:09:04,685] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.MARKET_CODE = ? and ppc.SOC is null and ppc.SOC_FAMILY_ID is null AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  291. [2017-10-19 15:09:04,685] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: N, 2: N, 3: N, 4: KZT, 5: N, 6: N, 7: N, 8: N}
  292. [2017-10-19 15:09:04,685] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv Filling statement with parameters: PromisedPaymentCriteriaFilterDO(ctn=7711112343, marketCode=KZT, autoTP=false, hls=false, roaming=false, minimalOnly=true, tms=false, currentTPSoc=SEV_KZT2, socFamilyId=SEV_KZT, bundled=false)
  293. [2017-10-19 15:09:04,687] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv
  294. init/exec/read:2/1/0 Total: 3
  295. [2017-10-19 15:09:04,687] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv generateRetrieveSqlString sql is: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.MARKET_CODE is null and ppc.SOC is null and ppc.SOC_FAMILY_ID is null AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  296. [2017-10-19 15:09:04,688] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT ppc.PCID, ppc.ARPU_CODE, ppc.REQUIRED_AGE, ppc.ATP, ppc.HLC, ppc.ROAMING, ppc.AMOUNT_RUR, ppc.AMOUNT_USD, ppc.MIN_BALANCE_RUR, ppc.MAX_BALANCE_RUR, ppc.MIN_BALANCE_USD, ppc.MAX_BALANCE_USD, ppc.DURATION, ppc.FEEVAL_RUR, ppc.FEEVAL_USD, ppc.PRICE_BUNDLED, ac.MIN_VALUE, ac.MAX_VALUE FROM PROMISED_PAYMENT_CRITERIA ppc, ARPU_CODE ac WHERE ac.MIN_VALUE = (select min(MIN_VALUE) from ARPU_CODE where HLC = ? AND ATP = ? AND NVL(TMS,'N') = ? AND NVL(BUNDLED, 'N') = 'N')AND ac.CODE = ppc.ARPU_CODE AND ac.HLC = ppc.HLC AND ac.ATP = ppc.ATP AND ppc.MARKET_CODE is null and ppc.SOC is null and ppc.SOC_FAMILY_ID is null AND ppc.ROAMING = ? AND ppc.HLC = ? AND ppc.ATP = ? AND NVL(TMS,'N') = ? AND NVL(ac.BUNDLED, 'N') = 'N' ORDER BY ppc.MARKET_CODE
  297. [2017-10-19 15:09:04,688] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: N, 2: N, 3: N, 4: N, 5: N, 6: N, 7: N}
  298. [2017-10-19 15:09:04,688] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv Filling statement with parameters: PromisedPaymentCriteriaFilterDO(ctn=7711112343, marketCode=KZT, autoTP=false, hls=false, roaming=false, minimalOnly=true, tms=false, currentTPSoc=SEV_KZT2, socFamilyId=SEV_KZT, bundled=false)
  299. [2017-10-19 15:09:04,690] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentCriteriaSrv
  300. init/exec/read:2/1/0 Total: 3
  301. [2017-10-19 15:09:04,691] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentARPUSrv generateRetrieveSqlString sql is: SELECT INIT_ACTIVATION_DATE, ARPU FROM ECR9_PROMISED_PAYMENT_ARPU WHERE CTN = ?
  302. [2017-10-19 15:09:04,691] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT INIT_ACTIVATION_DATE, ARPU FROM ECR9_PROMISED_PAYMENT_ARPU WHERE CTN = ?
  303. [2017-10-19 15:09:04,691] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: 7711112343}
  304. [2017-10-19 15:09:04,692] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentARPUSrv Filling statement with parameters: 7711112343
  305. [2017-10-19 15:09:04,693] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for ru.vimpelcom.ecare.requestprocessor.bo.pp.service.PromisedPaymentARPUSrv
  306. init/exec/read:1/1/0 Total: 2
  307. [2017-10-19 15:09:04,693] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:- U:- - Method PromisedPaymentEJB.getPromisedPaymentCriteria invocation with parameters [7711112343, KZT, false, false, true] has been completed in 50 ms.
  308. [2017-10-19 15:09:04,695] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO BaseAPITypeBO:retrieveNotificationSoc:577 ID:- U:- - Notification soc not found
  309. [2017-10-19 15:09:04,696] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO BaseAPITypeBO:substituteCommandParameters:546 ID:- U:- - Original command is CHTP8[EXPIRATION_DATE=?][PRPDAYS=?@OVRATE!1=?@BALMOD=EXAMPLE_BUNTPBAL];CHTP9[EXPIRATION_DATE=?][OVRATE!2=?@PRPDAYS=?] Substitued command is CHTP8[EXPIRATION_DATE=4][PRPDAYS=4@OVRATE=100.00@BALMOD=EXAMPLE_BUNTPBAL];CHTP9[EXPIRATION_DATE=4][OVRATE=0.00@PRPDAYS=4]
  310. [2017-10-19 15:09:04,696] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG VIPUniReqParsingBO:parse:76 ID:- U:- - VIPUniReqParsingBO parse CHTP8[EXPIRATION_DATE=4][PRPDAYS=4@OVRATE=100.00@BALMOD=EXAMPLE_BUNTPBAL];CHTP9[EXPIRATION_DATE=4][OVRATE=0.00@PRPDAYS=4]
  311. [2017-10-19 15:09:04,698] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144698-kz-ussapppl01.kar-tel U:- - Method TuxedoBaseEJB.getLogicalDate invoked with parameters [].
  312. [2017-10-19 15:09:04,698] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144698-kz-ussapppl01.kar-tel U:- - Method TuxedoBaseEJB.getLogicalDate invocation with parameters [] has been completed in 0 ms.
  313. [2017-10-19 15:09:04,700] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144700-kz-ussapppl01.kar-tel U:- - Method TuxedoBaseEJB.getLogicalDate invoked with parameters [].
  314. [2017-10-19 15:09:04,700] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144700-kz-ussapppl01.kar-tel U:- - Method TuxedoBaseEJB.getLogicalDate invocation with parameters [] has been completed in 0 ms.
  315. [2017-10-19 15:09:04,701] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG VIPUniReqParsingBO:parse:143 ID:- U:- - VIPUniReqParsingBO result: OfferingOrderDO [subscriberList=[], objects=[FeatureDO(super=OfferDO(actionType=ADD, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), code=CHTP8, socName=null), FeatureDO(super=OfferDO(actionType=ADD, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=0.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), code=CHTP9, socName=null)], effectiveDate=null, expirationDate=null]
  316. [2017-10-19 15:09:04,701] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseServiceManagerApiType:parseOffersFromCommandLine:171 ID:- U:- - RequestProcessor[API_TYPE=220, BNUMBER=1554476] parse offers from commandLine: [FeatureDO(super=OfferDO(actionType=ADD, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), code=CHTP8, socName=null), FeatureDO(super=OfferDO(actionType=ADD, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=0.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), code=CHTP9, socName=null)]
  317. [2017-10-19 15:09:04,703] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144703-kz-ussapppl01.kar-tel U:- - Method TuxedoBaseEJB.getLogicalDate invoked with parameters [].
  318. [2017-10-19 15:09:04,703] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144703-kz-ussapppl01.kar-tel U:- - Method TuxedoBaseEJB.getLogicalDate invocation with parameters [] has been completed in 0 ms.
  319. [2017-10-19 15:09:04,707] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144707-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.validateOfferingOrderRequest invoked with parameters [<OfferingOrderRequestDO>
  320. <wishSubscriberTransactionMap>{VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)=SubscriberTransactionDO [subscriberPK=VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0);objects=[FeatureDO(super=OfferDO(actionType=ADD, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), code=CHTP8, socName=TP_BUND), SocDO(super=OfferDO(actionType=ADD, objectType=SOC, offerParameters={}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), name=TP_BUND, type=OPTIONAL, excludeDefaultFeatures=false)];effectiveDate=Thu Oct 19 00:00:00 ALMT 2017;validationSettings=<com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  321. <checkList type=java.util.EnumSet>[WEB_ADD_IND, REMOVE_IND, WEB_UPDATE_IND, NON_PUBLIC_IND, CONFLICT_RESOLVING, FRIEND_BALANCE_LOGIC, SKIP_PROMISED_PAYMENT_LOGIC]</checkList>
  322. </com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  323. <com.amdocs.css.core.util.data.DataObject>
  324. </com.amdocs.css.core.util.data.DataObject>
  325. <java.lang.Object>
  326. </java.lang.Object>
  327. ;sendToSPSS=false;offerStatuses={};dependedTransactions=null;]}</wishSubscriberTransactionMap>
  328. <readySubscriberTransactionList>null</readySubscriberTransactionList>
  329. </OfferingOrderRequestDO>].
  330. [2017-10-19 15:09:04,711] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:94 ID:1508404144707-kz-ussapppl01.kar-tel U:- - 564acdf2-768c-41b4-95bf-fd74cc42e1ce: Call GetLogicalDate in session 76987251
  331. [2017-10-19 15:09:04,723] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:127 ID:1508404144707-kz-ussapppl01.kar-tel U:- - 564acdf2-768c-41b4-95bf-fd74cc42e1ce: Call GetLogicalDate in session 76987251 took 11 ms [00000]
  332. [2017-10-19 15:09:04,728] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144728-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveConnectedAgreements invoked with parameters [ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]].
  333. [2017-10-19 15:09:04,729] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144728-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedAgreementSrv generateRetrieveSqlString sql is: SELECT tr.agreement_id, subscriber_no, ban, agreement_type, agr_product_type, effective_date, expiration_date, tr.price_plan_id, price_plan_type, price_plan_description, view_ind, add_ind, remove_ind, update_ind, api_update_ind, disp_prepaid_amt_ind, prepaid_threshold_dollars, prepaid_threshold_rubles, prepaid_threshold_otc, cug_eligibility_ind, non_public_ind, market_code FROM ((SELECT agreement_id, esa.subscriber_no, esa.ban, agreement_type, agr_product_type, effective_date, expiration_date, pp.price_plan_id AS price_plan_id, price_plan_type, price_plan_description FROM ecr9_agr_app esa LEFT JOIN price_plan pp ON rtrim(pp.external_price_plan) = rtrim(esa.agreement_type) AND pp.price_plan_type='A' WHERE 0 = 0 AND NVL(TO_CHAR(esa.ENT_EXPIRATION_DATE,'YYYYMMDD'),'47001231') >= ? AND NVL(TO_CHAR(esa.EXPIRATION_DATE,'YYYYMMDD'),'47001231') >= ? AND esa.ban = ? AND esa.subscriber_no = ? AND rtrim(pp.external_price_plan) = rtrim(esa.agreement_type) AND pp.price_plan_type='A' AND esa.ent_expiration_date IS NULL) tr LEFT JOIN ecr9_price_plan_ext epp ON epp.price_plan_id = tr.price_plan_id)
  334. [2017-10-19 15:09:04,730] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:1508404144728-kz-ussapppl01.kar-tel U:- - SQL: SELECT tr.agreement_id, subscriber_no, ban, agreement_type, agr_product_type, effective_date, expiration_date, tr.price_plan_id, price_plan_type, price_plan_description, view_ind, add_ind, remove_ind, update_ind, api_update_ind, disp_prepaid_amt_ind, prepaid_threshold_dollars, prepaid_threshold_rubles, prepaid_threshold_otc, cug_eligibility_ind, non_public_ind, market_code FROM ((SELECT agreement_id, esa.subscriber_no, esa.ban, agreement_type, agr_product_type, effective_date, expiration_date, pp.price_plan_id AS price_plan_id, price_plan_type, price_plan_description FROM ecr9_agr_app esa LEFT JOIN price_plan pp ON rtrim(pp.external_price_plan) = rtrim(esa.agreement_type) AND pp.price_plan_type='A' WHERE 0 = 0 AND NVL(TO_CHAR(esa.ENT_EXPIRATION_DATE,'YYYYMMDD'),'47001231') >= ? AND NVL(TO_CHAR(esa.EXPIRATION_DATE,'YYYYMMDD'),'47001231') >= ? AND esa.ban = ? AND esa.subscriber_no = ? AND rtrim(pp.external_price_plan) = rtrim(esa.agreement_type) AND pp.price_plan_type='A' AND esa.ent_expiration_date IS NULL) tr LEFT JOIN ecr9_price_plan_ext epp ON epp.price_plan_id = tr.price_plan_id)
  335. [2017-10-19 15:09:04,730] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:1508404144728-kz-ussapppl01.kar-tel U:- - {1: 20171019, 2: 20171019, 3: 172882952, 4: 7711112343 }
  336. [2017-10-19 15:09:04,731] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:1508404144728-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedAgreementSrv Filling statement with parameters: ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]
  337. [2017-10-19 15:09:04,732] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:1508404144728-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedAgreementSrv
  338. init/exec/read:2/1/0 Total: 3
  339. [2017-10-19 15:09:04,733] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144728-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  340. [2017-10-19 15:09:04,733] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:1508404144728-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  341. [2017-10-19 15:09:04,734] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:1508404144728-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: T}
  342. [2017-10-19 15:09:04,734] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:1508404144728-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  343. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  344. <allInfo type=boolean>true</allInfo>
  345. </com.amdocs.css.vip.account.data.AccountFilterDO>
  346. <com.amdocs.css.core.util.data.DataObject>
  347. </com.amdocs.css.core.util.data.DataObject>
  348. <java.lang.Object>
  349. </java.lang.Object>
  350.  
  351. [2017-10-19 15:09:04,736] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:1508404144728-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  352. init/exec/read:2/0/1 Total: 3
  353. [2017-10-19 15:09:04,737] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144728-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveConnectedAgreements invocation with parameters [ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]] has been completed in 9 ms.
  354. [2017-10-19 15:09:04,738] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  355. [2017-10-19 15:09:04,739] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  356. [2017-10-19 15:09:04,739] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: 172882952, 2: T}
  357. [2017-10-19 15:09:04,740] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  358. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  359. <allInfo type=boolean>true</allInfo>
  360. </com.amdocs.css.vip.account.data.AccountFilterDO>
  361. <com.amdocs.css.core.util.data.DataObject>
  362. </com.amdocs.css.core.util.data.DataObject>
  363. <java.lang.Object>
  364. </java.lang.Object>
  365.  
  366. [2017-10-19 15:09:04,741] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  367. init/exec/read:2/1/0 Total: 3
  368. [2017-10-19 15:09:04,742] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S') and customer_id = ?
  369. [2017-10-19 15:09:04,742] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:- U:- - SQL: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S') and customer_id = ?
  370. [2017-10-19 15:09:04,742] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:- U:- - {1: 7711112343 , 2: 172882952}
  371. [2017-10-19 15:09:04,743] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:- U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)
  372. [2017-10-19 15:09:04,744] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:- U:- - Timings for com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv
  373. init/exec/read:1/1/0 Total: 2
  374. [2017-10-19 15:09:04,746] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404144746-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveConnectedSocs invoked with parameters [ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]].
  375. [2017-10-19 15:09:04,747] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144746-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv generateRetrieveSqlString sql is: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type in ('P', 'O') AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  376. [2017-10-19 15:09:04,748] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:1508404144746-kz-ussapppl01.kar-tel U:- - SQL: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.service_type in ('P', 'O') AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  377. [2017-10-19 15:09:04,748] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:1508404144746-kz-ussapppl01.kar-tel U:- - {1: 2017-10-19, 2: 172882952, 3: 7711112343 }
  378. [2017-10-19 15:09:04,749] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:1508404144746-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv Filling statement with parameters: ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]
  379. [2017-10-19 15:09:04,750] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:1508404144746-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  380. init/exec/read:2/1/0 Total: 3
  381. [2017-10-19 15:09:04,754] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404144746-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SERVICE_FEATURE WHERE ban = ? and subscriber_no = ? and (ftr_expiration_date > ? or ftr_expiration_date is null)
  382. [2017-10-19 15:09:04,754] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:137 ID:1508404144746-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SERVICE_FEATURE WHERE ban = ? and subscriber_no = ? and (ftr_expiration_date > ? or ftr_expiration_date is null)
  383. [2017-10-19 15:09:04,755] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:1508404144746-kz-ussapppl01.kar-tel U:- - {1: 172882952, 2: 7711112343 , 3: 2017-10-19}
  384. [2017-10-19 15:09:04,755] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:145 ID:1508404144746-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)
  385. [2017-10-19 15:09:04,758] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:1508404144746-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedFeatureSrv
  386. init/exec/read:2/0/2 Total: 4
  387. [2017-10-19 15:09:04,759] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404144746-kz-ussapppl01.kar-tel U:- - Method NewOfferingServicesEJB.retrieveConnectedSocs invocation with parameters [ServiceAgreementFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]] has been completed in 13 ms.
  388. [2017-10-19 15:09:04,775] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.subscriber.dl.BanSocAvailableSrv generateRetrieveSqlString sql is: SELECT BAN, SOC, NOTE, DEPOSIT_IND FROM ECR6_BAN_SOC_AVAILABLE WHERE 1=1 AND BAN = ?
  389. [2017-10-19 15:09:04,775] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:137 ID:- U:- - SQL: SELECT BAN, SOC, NOTE, DEPOSIT_IND FROM ECR6_BAN_SOC_AVAILABLE WHERE 1=1 AND BAN = ?
  390. [2017-10-19 15:09:04,776] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:- U:- - {1: 172882952}
  391. [2017-10-19 15:09:04,776] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:145 ID:- U:- - com.amdocs.css.vip.subscriber.dl.BanSocAvailableSrv Filling statement with parameters: com.amdocs.css.vip.subscriber.data.BanSocAvailableFilterDO@5461fe3b
  392. [2017-10-19 15:09:04,777] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:- U:- - Timings for com.amdocs.css.vip.subscriber.dl.BanSocAvailableSrv
  393. init/exec/read:1/1/0 Total: 2
  394. [2017-10-19 15:09:04,779] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractBatchSrv:executeBatch:43 ID:- U:- - SQL: insert into ECR6_SUBSCRIBER_FOR_SEL_HIER ( SUBSCRIBER_NO, CUSTOMER_ID, OBJ_ID, DEFAULT_RC_BEN ) values ( ? , ? , ? , ? )
  395. [2017-10-19 15:09:04,780] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv generateRetrieveSqlString sql is: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa, ecr6_subscriber_for_sel_hier esh WHERE 1=1 AND esa.service_type='O' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esh.customer_id=esa.ban AND esh.subscriber_no=esa.subscriber_no
  396. [2017-10-19 15:09:04,781] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:- U:- - SQL: SELECT DISTINCT esa.soc, esa.soc_seq_no, esa.effective_date, esa.expiration_date, esa.ban, esa.subscriber_no, esa.service_type FROM ecr9_service_agreement esa, ecr6_subscriber_for_sel_hier esh WHERE 1=1 AND esa.service_type='O' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esh.customer_id=esa.ban AND esh.subscriber_no=esa.subscriber_no
  397. [2017-10-19 15:09:04,781] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:- U:- - {1: 2017-10-19}
  398. [2017-10-19 15:09:04,782] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:- U:- - com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv Filling statement with parameters: ServiceAgreementFilter [subscriberNumber=null, subscriberPKs=[VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=1, objectID=0)], needGroupingBySoc=true]
  399. [2017-10-19 15:09:04,784] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:- U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  400. init/exec/read:2/2/0 Total: 4
  401. [2017-10-19 15:09:04,984] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  402. [2017-10-19 15:09:04,986] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  403. [2017-10-19 15:09:04,986] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  404. [2017-10-19 15:09:04,987] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  405. [2017-10-19 15:09:04,988] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  406. [2017-10-19 15:09:04,988] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  407. [2017-10-19 15:09:05,013] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractBatchSrv:executeBatch:43 ID:- U:- - SQL: insert into ECR6_SUBSCRIBER_FOR_SEL_HIER ( SUBSCRIBER_NO, CUSTOMER_ID, OBJ_ID, DEFAULT_RC_BEN ) values ( ? , ? , ? , ? )
  408. [2017-10-19 15:09:05,014] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.customer.dl.IWStorageDataGetSrv generateRetrieveSqlString sql is: SELECT IW.BAN, IW.SUBSCRIBER_NO, IW.INDICATOR_ID, IW.EFFECTIVE_DATE, IW.EXPIRATION_DATE, IW.IW_VALUE FROM ECR9_IW_STORAGE IW, ECR6_SUBSCRIBER_FOR_SEL_HIER SEL WHERE IW.BAN = SEL.CUSTOMER_ID AND IW.SUBSCRIBER_NO = SEL.SUBSCRIBER_NO AND IW.INDICATOR_ID = ?
  409. [2017-10-19 15:09:05,014] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:137 ID:- U:- - SQL: SELECT IW.BAN, IW.SUBSCRIBER_NO, IW.INDICATOR_ID, IW.EFFECTIVE_DATE, IW.EXPIRATION_DATE, IW.IW_VALUE FROM ECR9_IW_STORAGE IW, ECR6_SUBSCRIBER_FOR_SEL_HIER SEL WHERE IW.BAN = SEL.CUSTOMER_ID AND IW.SUBSCRIBER_NO = SEL.SUBSCRIBER_NO AND IW.INDICATOR_ID = ?
  410. [2017-10-19 15:09:05,015] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:- U:- - {1: TAB_SOC }
  411. [2017-10-19 15:09:05,015] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:145 ID:- U:- - com.amdocs.css.vip.customer.dl.IWStorageDataGetSrv Filling statement with parameters: TAB_SOC
  412. [2017-10-19 15:09:05,016] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:- U:- - Timings for com.amdocs.css.vip.customer.dl.IWStorageDataGetSrv
  413. init/exec/read:2/0/0 Total: 2
  414. [2017-10-19 15:09:05,022] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  415. [2017-10-19 15:09:05,420] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  416. [2017-10-19 15:09:05,421] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  417. [2017-10-19 15:09:05,422] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  418. [2017-10-19 15:09:05,422] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  419. [2017-10-19 15:09:05,423] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  420. [2017-10-19 15:09:05,423] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  421. [2017-10-19 15:09:05,447] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.offering.dl.VIPAppEnsRetrieveMpsFeatureRestrictionSrv generateRetrieveSqlString sql is: SELECT SOURCE_FEATURE, RESTRICT_FEATURE FROM FEATURE_RESTRICTIONS WHERE ? between EFFECTIVE_DATE and NVL(EXPIRATION_DATE, to_date('47001231','yyyymmdd'))
  422. [2017-10-19 15:09:05,448] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:89 ID:- U:- - SQL: SELECT SOURCE_FEATURE, RESTRICT_FEATURE FROM FEATURE_RESTRICTIONS WHERE ? between EFFECTIVE_DATE and NVL(EXPIRATION_DATE, to_date('47001231','yyyymmdd'))
  423. [2017-10-19 15:09:05,448] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:- U:- - {1: 2017-10-19}
  424. [2017-10-19 15:09:05,449] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:97 ID:- U:- - com.amdocs.css.vip.offering.dl.VIPAppEnsRetrieveMpsFeatureRestrictionSrv Filling statement with parameters: Thu Oct 19 00:00:00 ALMT 2017
  425. [2017-10-19 15:09:05,456] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:- U:- - Timings for com.amdocs.css.vip.offering.dl.VIPAppEnsRetrieveMpsFeatureRestrictionSrv
  426. init/exec/read:2/1/6 Total: 9
  427. [2017-10-19 15:09:05,476] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG ThresholdHelper:calcThreshold:90 ID:- U:- - ctn=7711112343, threshold[O/TP_BUND]=0.0
  428. [2017-10-19 15:09:05,478] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145478-kz-ussapppl01.kar-tel U:- - Method VIPComverseServicesEJB.getComverseBean invoked with parameters [7711112343, KZT].
  429. [2017-10-19 15:09:05,480] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145478-kz-ussapppl01.kar-tel U:- - Method VIPComverseServicesEJB.getComverseBean invocation with parameters [7711112343, KZT] has been completed in 2 ms.
  430. [2017-10-19 15:09:05,481] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145480-kz-ussapppl01.kar-tel U:- - Method VIPComverseBase.getCommonInfo invoked with parameters [{"rootType":"VIPCtnDH","state":{"ctn":"7711112343","marketCode":"KZT","needToRetrievePrevDate":false,"identity":null}}].
  431. [2017-10-19 15:09:05,484] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145480-kz-ussapppl01.kar-tel U:- - Method VIPComverseBase.getCommonInfo invocation with parameters [{"rootType":"VIPCtnDH","state":{"ctn":"7711112343","marketCode":"KZT","needToRetrievePrevDate":false,"identity":null}}] has been completed in 3 ms.
  432. [2017-10-19 15:09:05,487] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145486-kz-ussapppl01.kar-tel U:- - Method MicrochargingServiceEJB.findAllMapBySoc invoked with parameters [].
  433. [2017-10-19 15:09:05,490] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145486-kz-ussapppl01.kar-tel U:- - Method MicrochargingServiceEJB.findAllMapBySoc invocation with parameters [] has been completed in 4 ms.
  434. [2017-10-19 15:09:05,492] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:- U:- - Method VIPSubscriberServicesEJB.validateOfferingOrderRequest invocation with parameters [<OfferingOrderRequestDO>
  435. <wishSubscriberTransactionMap>{VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)=SubscriberTransactionDO [subscriberPK=VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0);objects=[FeatureDO(super=OfferDO(actionType=MODIFY, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=true, fake=false), code=CHTP8, socName=TP_BUND), SocDO(super=OfferDO(actionType=ADD, objectType=SOC, offerParameters={}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), name=TP_BUND, type=OPTIONAL, excludeDefaultFeatures=false)];effectiveDate=Thu Oct 19 00:00:00 ALMT 2017;validationSettings=<com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  436. <checkList type=java.util.EnumSet>[WEB_ADD_IND, REMOVE_IND, WEB_UPDATE_IND, NON_PUBLIC_IND, CONFLICT_RESOLVING, FRIEND_BALANCE_LOGIC, SKIP_PROMISED_PAYMENT_LOGIC]</checkList>
  437. </com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  438. <com.amdocs.css.core.util.data.DataObject>
  439. </com.amdocs.css.core.util.data.DataObject>
  440. <java.lang.Object>
  441. </java.lang.Object>
  442. ;sendToSPSS=false;offerStatuses={};dependedTransactions=null;]}</wishSubscriberTransactionMap>
  443. <readySubscriberTransactionList>[SubscriberTransactionDO [subscriberPK=VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0);objects=[SocDO(super=OfferDO(actionType=ADD, objectType=SOC, offerParameters={}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), name=TP_BUND, type=OPTIONAL, excludeDefaultFeatures=false), FeatureDO(super=OfferDO(actionType=MODIFY, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=true, fake=false), code=CHTP8, socName=TP_BUND)];effectiveDate=Thu Oct 19 00:00:00 ALMT 2017;validationSettings=<com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  444. <checkList type=java.util.EnumSet>[WEB_ADD_IND, REMOVE_IND, WEB_UPDATE_IND, NON_PUBLIC_IND, CONFLICT_RESOLVING, FRIEND_BALANCE_LOGIC, SKIP_PROMISED_PAYMENT_LOGIC]</checkList>
  445. </com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  446. <com.amdocs.css.core.util.data.DataObject>
  447. </com.amdocs.css.core.util.data.DataObject>
  448. <java.lang.Object>
  449. </java.lang.Object>
  450. ;sendToSPSS=false;offerStatuses={};dependedTransactions=null;]]</readySubscriberTransactionList>
  451. </OfferingOrderRequestDO>] has been completed in 784 ms.
  452. [2017-10-19 15:09:05,496] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145496-kz-ussapppl01.kar-tel U:- - Method GeneralServiceEJB.findGenericCode invoked with parameters [{"rootType":"GenericCodeKey","state":{"genericType":"REMOVE_SOC","genericCode":"TP_BUND"}}].
  453. [2017-10-19 15:09:05,498] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145496-kz-ussapppl01.kar-tel U:- - Method GeneralServiceEJB.findGenericCode invocation with parameters [{"rootType":"GenericCodeKey","state":{"genericType":"REMOVE_SOC","genericCode":"TP_BUND"}}] has been completed in 2 ms.
  454. [2017-10-19 15:09:05,500] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145500-kz-ussapppl01.kar-tel U:- - Method GeneralServiceEJB.findGenericCode invoked with parameters [{"rootType":"GenericCodeKey","state":{"genericType":"ADDITIONAL_SOC","genericCode":"TP_BUND"}}].
  455. [2017-10-19 15:09:05,502] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145500-kz-ussapppl01.kar-tel U:- - Method GeneralServiceEJB.findGenericCode invocation with parameters [{"rootType":"GenericCodeKey","state":{"genericType":"ADDITIONAL_SOC","genericCode":"TP_BUND"}}] has been completed in 2 ms.
  456. [2017-10-19 15:09:05,505] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145505-kz-ussapppl01.kar-tel U:- - Method CHEJB.getObjectByExternalId invoked with parameters [7711112343,172882952,1, CTN].
  457. [2017-10-19 15:09:05,506] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CHDAO:getObjectByExternalId:148 ID:1508404145505-kz-ussapppl01.kar-tel U:- - getObjectByExternalId: externalId=7711112343,172882952,1; type=CTN
  458. [2017-10-19 15:09:05,508] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CHDAO:getObjectByExternalId:168 ID:1508404145505-kz-ussapppl01.kar-tel U:- - getObjectByExternalId: externalId=7711112343,172882952,1; type=CTN; find CH: CHObject (600044573, 40, 7711112343, 7711112343,172882952,1, null)
  459. [2017-10-19 15:09:05,508] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145505-kz-ussapppl01.kar-tel U:- - Method CHEJB.getObjectByExternalId invocation with parameters [7711112343,172882952,1, CTN] has been completed in 3 ms.
  460. [2017-10-19 15:09:05,512] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145512-kz-ussapppl01.kar-tel U:- - Method VIPQueueSenderEJB.send invoked with parameters [RequestDO(requestId=0, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=OPEN, requestPriority=Low
  461. , creationDate=null, subscriberId=null, requestExternalId=null, lastUpdateName=null, lastUpdateDate=null, nodeId=600044573, accountId=null, customerId=172882952, approvalName=null, hierarchySource=null, requestParams=RequestParamsDO(realRequestType=null, requestType=MSCH, requestSubType=GAPI, effectiveDate=Thu Oct 19 15:09:05 ALMT 2017, initiatorName=/RP_USSDHTTP, operatorId=7711112343, contactName=null, contactPhone=7711112343, comments=null, requestStatus=null, contactEmail=null, hierarchySource=null, nodeId=600044573, customerId=172882952, accountId=null, locale=ru_RU, emailWelcome=null, createNotificationObject=false, generalSuccessInitiatorNotification=false, generalRejectInitiatorNotification=true, generalSuccessSubscriberNotification=false, generalRejectSubscriberNotification=false, customizeRPNotification=false, reportType=null, isB2C=true, linkedAccountContactPhone=[], linkedAccountContactEmail=[], userPosition=null, channel=RP_USSDHTTP, mainLogin=null), operatorId=/RP_USSDHTTP, notificationHolder=RequestNotificationHolderDO(params=null, generalSmsList=[com.amdocs.css.core.util.data.RequestSMSDO@4c421698], generalEmailList=[], rejectSmsList=[], rejectEmailList=[], requestComments=[]), locale=ru_RU, subMassRequestComments=null, searchLine1=null, searchLine2=null, searchLine3=null, postProcessActions=[], mainLogin=null, convergentParams=null)].
  462. [2017-10-19 15:09:05,512] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG VIPQueueSenderBO:createRequestAndJmsMessage:23 ID:1508404145512-kz-ussapppl01.kar-tel U:- - VIPQueueSenderBO: doAction: RequestDO(requestId=0, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=OPEN, requestPriority=Low
  463. , creationDate=null, subscriberId=null, requestExternalId=null, lastUpdateName=null, lastUpdateDate=null, nodeId=600044573, accountId=null, customerId=172882952, approvalName=null, hierarchySource=null, requestParams=RequestParamsDO(realRequestType=null, requestType=MSCH, requestSubType=GAPI, effectiveDate=Thu Oct 19 15:09:05 ALMT 2017, initiatorName=/RP_USSDHTTP, operatorId=7711112343, contactName=null, contactPhone=7711112343, comments=null, requestStatus=null, contactEmail=null, hierarchySource=null, nodeId=600044573, customerId=172882952, accountId=null, locale=ru_RU, emailWelcome=null, createNotificationObject=false, generalSuccessInitiatorNotification=false, generalRejectInitiatorNotification=true, generalSuccessSubscriberNotification=false, generalRejectSubscriberNotification=false, customizeRPNotification=false, reportType=null, isB2C=true, linkedAccountContactPhone=[], linkedAccountContactEmail=[], userPosition=null, channel=RP_USSDHTTP, mainLogin=null), operatorId=/RP_USSDHTTP, notificationHolder=RequestNotificationHolderDO(params=null, generalSmsList=[com.amdocs.css.core.util.data.RequestSMSDO@4c421698], generalEmailList=[], rejectSmsList=[], rejectEmailList=[], requestComments=[]), locale=ru_RU, subMassRequestComments=null, searchLine1=null, searchLine2=null, searchLine3=null, postProcessActions=[], mainLogin=null, convergentParams=null)
  464. [2017-10-19 15:09:05,513] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AppGetNextSeqSrv:execute:30 ID:1508404145512-kz-ussapppl01.kar-tel U:- - Filling statement with parameters: REQUEST_ID_SQ1
  465. [2017-10-19 15:09:05,514] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractInsertNewSrv:executeUnique:46 ID:1508404145512-kz-ussapppl01.kar-tel U:- - SQL: insert into REQUEST ( REQUEST_ID, ACCOUNT_ID, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, OPERATOR_ID, LINE_NUMBER, REQUEST_TYPE, REQUEST_SUB_TYPE, VERSION, CREATION_DATE, EFFECTIVE_DATE, INITIATOR_NAME, LAST_UPDATE_DATE, NODE_ID, HIERARCHY_SOURCE, REQUEST_PRIORITY, REQUEST_STATUS, REQUEST_CONTENT, JAXB_PACKAGE, REQUEST_EXTERNAL_ID, SEARCH_LINE1, SEARCH_LINE2, SEARCH_LINE3 ) values ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
  466. [2017-10-19 15:09:05,523] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractInsertNewSrv:executeUnique:51 ID:1508404145512-kz-ussapppl01.kar-tel U:- - {1: 2172501022, 2: null, 3: 2017-10-19 15:09:05.514, 4: 2017-10-19 15:09:05.514, 5: dminServer, 6: 7711112343, 7: 1, 8: MSCH, 9: GAPI, 10: 0, 11: 2017-10-19 15:09:05.514, 12: 2017-10-19 15:09:05.514, 13: /RP_USSDHTTP, 14: 2017-10-19 15:09:05.514, 15: 600044573, 16: null, 17: 1, 18: O, 19: byte[], 20: com.amdocs.css.vip.request.data, 21: null, 22: null, 23: null, 24: null}
  467. [2017-10-19 15:09:05,523] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractInsertNewSrv:executeUnique:54 ID:1508404145512-kz-ussapppl01.kar-tel U:- - Filling statement with parameters: RequestDO(requestId=2172501022, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=OPEN, requestPriority=Low
  468. , creationDate=Thu Oct 19 15:09:05 ALMT 2017, subscriberId=null, requestExternalId=null, lastUpdateName=null, lastUpdateDate=Thu Oct 19 15:09:05 ALMT 2017, nodeId=600044573, accountId=null, customerId=172882952, approvalName=null, hierarchySource=null, requestParams=RequestParamsDO(realRequestType=null, requestType=MSCH, requestSubType=GAPI, effectiveDate=Thu Oct 19 15:09:05 ALMT 2017, initiatorName=/RP_USSDHTTP, operatorId=7711112343, contactName=null, contactPhone=7711112343, comments=null, requestStatus=null, contactEmail=null, hierarchySource=null, nodeId=600044573, customerId=172882952, accountId=null, locale=ru_RU, emailWelcome=null, createNotificationObject=false, generalSuccessInitiatorNotification=false, generalRejectInitiatorNotification=true, generalSuccessSubscriberNotification=false, generalRejectSubscriberNotification=false, customizeRPNotification=false, reportType=null, isB2C=true, linkedAccountContactPhone=[], linkedAccountContactEmail=[], userPosition=null, channel=RP_USSDHTTP, mainLogin=null), operatorId=/RP_USSDHTTP, notificationHolder=RequestNotificationHolderDO(params=null, generalSmsList=[com.amdocs.css.core.util.data.RequestSMSDO@4c421698], generalEmailList=[], rejectSmsList=[], rejectEmailList=[], requestComments=[]), locale=ru_RU, subMassRequestComments=null, searchLine1=null, searchLine2=null, searchLine3=null, postProcessActions=[], mainLogin=null, convergentParams=null)
  469. [2017-10-19 15:09:05,527] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO JMSHelperBO:sendMessage:43 ID:1508404145512-kz-ussapppl01.kar-tel U:- - request (com.amdocs.css.vip.request.data.VIPAddRemoveServiceRequestDO): MSCH/GAPI
  470. [2017-10-19 15:09:05,532] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145512-kz-ussapppl01.kar-tel U:- - Method VIPQueueSenderEJB.send invocation with parameters [RequestDO(requestId=2172501022, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=OPEN, requestPriority=Low
  471. , creationDate=Thu Oct 19 15:09:05 ALMT 2017, subscriberId=null, requestExternalId=null, lastUpdateName=null, lastUpdateDate=Thu Oct 19 15:09:05 ALMT 2017, nodeId=600044573, accountId=null, customerId=172882952, approvalName=null, hierarchySource=null, requestParams=RequestParamsDO(realRequestType=null, requestType=MSCH, requestSubType=GAPI, effectiveDate=Thu Oct 19 15:09:05 ALMT 2017, initiatorName=/RP_USSDHTTP, operatorId=7711112343, contactName=null, contactPhone=7711112343, comments=null, requestStatus=null, contactEmail=null, hierarchySource=null, nodeId=600044573, customerId=172882952, accountId=null, locale=ru_RU, emailWelcome=null, createNotificationObject=false, generalSuccessInitiatorNotification=false, generalRejectInitiatorNotification=true, generalSuccessSubscriberNotification=false, generalRejectSubscriberNotification=false, customizeRPNotification=false, reportType=null, isB2C=true, linkedAccountContactPhone=[], linkedAccountContactEmail=[], userPosition=null, channel=RP_USSDHTTP, mainLogin=null), operatorId=/RP_USSDHTTP, notificationHolder=RequestNotificationHolderDO(params=null, generalSmsList=[com.amdocs.css.core.util.data.RequestSMSDO@4c421698], generalEmailList=[], rejectSmsList=[], rejectEmailList=[], requestComments=[]), locale=ru_RU, subMassRequestComments=null, searchLine1=null, searchLine2=null, searchLine3=null, postProcessActions=[], mainLogin=null, convergentParams=null)] has been completed in 20 ms.
  472. [2017-10-19 15:09:05,535] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145535-kz-ussapppl01.kar-tel U:- - Method VIPRequestProcessorEJB.addRpResult invoked with parameters [com.amdocs.css.vip.rp.data.ResultDO@26c55532].
  473. [2017-10-19 15:09:05,537] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145535-kz-ussapppl01.kar-tel U:- - Method VIPRequestProcessorEJB.addRpResult invocation with parameters [com.amdocs.css.vip.rp.data.ResultDO@26c55532] has been completed in 2 ms.
  474. [2017-10-19 15:09:05,539] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145539-kz-ussapppl01.kar-tel U:- - Method VIPRequestProcessorEJB.removeLockTable invoked with parameters [7711112343, 1554476].
  475. [2017-10-19 15:09:05,541] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG RPDAO:removeLockTable:375 ID:1508404145539-kz-ussapppl01.kar-tel U:- - delete from RP_LOCK[7711112343/1554476]: ok
  476. [2017-10-19 15:09:05,541] [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145539-kz-ussapppl01.kar-tel U:- - Method VIPRequestProcessorEJB.removeLockTable invocation with parameters [7711112343, 1554476] has been completed in 2 ms.
  477. [2017-10-19 15:09:05,561] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO BaseMDB:getRequestDO:157 ID:- U:- - ManageQueueMDB: Received Message: com.amdocs.css.vip.request.data.VIPAddRemoveServiceRequestDO
  478. [2017-10-19 15:09:05,563] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145563-kz-ussapppl01.kar-tel U:- - Method VIPRequestServicesEJB.updateRequestStatus invoked with parameters [RequestPK(requestId=2172501022, lineNumber=1), IN_PROGRESS].
  479. [2017-10-19 15:09:05,564] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG VIPAppUpdateRequestMultiLineNumbSrv:updateMultiLinesRequestStatus:47 ID:1508404145563-kz-ussapppl01.kar-tel U:- - pk = RequestPK(requestId=2172501022, lineNumber=1) Status = IN_PROGRESS
  480. [2017-10-19 15:09:05,566] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145563-kz-ussapppl01.kar-tel U:- - Method VIPRequestServicesEJB.updateRequestStatus invocation with parameters [RequestPK(requestId=2172501022, lineNumber=1), IN_PROGRESS] has been completed in 3 ms.
  481. [2017-10-19 15:09:05,567] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseMDB:processMessage:58 ID:- U:- - Processor: com.amdocs.css.vip.request.service.AddRemoveSocProcessor; requestID=2172501022
  482. [2017-10-19 15:09:05,567] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AddRemoveSocProcessor:processRequest:141 ID:- U:- - request=RequestDO(requestId=2172501022, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=IN_PROGRESS, requestPriority=Low
  483. , creationDate=Thu Oct 19 15:09:05 ALMT 2017, subscriberId=null, requestExternalId=null, lastUpdateName=null, lastUpdateDate=Thu Oct 19 15:09:05 ALMT 2017, nodeId=600044573, accountId=null, customerId=172882952, approvalName=null, hierarchySource=null, requestParams=RequestParamsDO(realRequestType=null, requestType=MSCH, requestSubType=GAPI, effectiveDate=Thu Oct 19 15:09:05 ALMT 2017, initiatorName=/RP_USSDHTTP, operatorId=7711112343, contactName=null, contactPhone=7711112343, comments=null, requestStatus=null, contactEmail=null, hierarchySource=null, nodeId=600044573, customerId=172882952, accountId=null, locale=ru_RU, emailWelcome=null, createNotificationObject=false, generalSuccessInitiatorNotification=false, generalRejectInitiatorNotification=true, generalSuccessSubscriberNotification=false, generalRejectSubscriberNotification=false, customizeRPNotification=false, reportType=null, isB2C=true, linkedAccountContactPhone=[], linkedAccountContactEmail=[], userPosition=null, channel=RP_USSDHTTP, mainLogin=null), operatorId=/RP_USSDHTTP, notificationHolder=RequestNotificationHolderDO(params=null, generalSmsList=[com.amdocs.css.core.util.data.RequestSMSDO@96fd6ef], generalEmailList=[], rejectSmsList=[], rejectEmailList=[], requestComments=[]), locale=ru_RU, subMassRequestComments=null, searchLine1=null, searchLine2=null, searchLine3=null, postProcessActions=[], mainLogin=null, convergentParams=null)
  484. [2017-10-19 15:09:05,606] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AddRemoveSocProcessor:processRequest:143 ID:- U:- - {"addRemoveServiceInfo":{"wishSubscriberTransactionMap":{"VIPSubscriberPK(subscriberNumber\u003d7711112343, customerID\u003d172882952, defaultRcBen\u003d0, objectID\u003d0)":{"subscriberPK":{"subscriberNumber":"7711112343","customerID":172882952,"defaultRcBen":0,"objectID":0},"objectsFirst":[],"objects":[{"code":"CHTP8","socName":"TP_BUND","actionType":"MODIFY","objectType":"FTR","offerParameters":{"PRPDAYS":{"paramName":"PRPDAYS","paramValue":"4"},"BALMOD":{"paramName":"BALMOD","paramValue":"EXAMPLE_BUNTPBAL"},"OVRATE":{"paramName":"OVRATE","paramValue":"100.00"}},"ignoreIfValidationError":true,"expirationDate":"Oct 23, 2017 12:00:00 AM","campId":-1,"subgroupId":-1,"skipAllEligibilityChecks":true,"fake":false},{"name":"TP_BUND","type":"OPTIONAL","excludeDefaultFeatures":false,"actionType":"ADD","objectType":"SOC","offerParameters":{},"ignoreIfValidationError":false,"expirationDate":"Oct 23, 2017 12:00:00 AM","campId":-1,"subgroupId":-1,"skipAllEligibilityChecks":false,"fake":false}],"removedObjects":[],"effectiveDate":"Oct 19, 2017 12:00:00 AM","sendToSPSS":false,"validationSettings":{"checkList":["WEB_ADD_IND","REMOVE_IND","WEB_UPDATE_IND","NON_PUBLIC_IND","CONFLICT_RESOLVING","FRIEND_BALANCE_LOGIC","SKIP_PROMISED_PAYMENT_LOGIC"]},"comments":[],"offerStatuses":{},"notificationHolderDO":{"generalSmsList":[],"generalEmailList":[],"rejectSmsList":[],"rejectEmailList":[],"requestComments":[]},"orderPolicy":"POST_EXECUTION_TRANSACTION","notificationTypes":["COMMENT","CHANNELS"],"status":"UNSEEN"}},"readySubscriberTransactionList":[{"subscriberPK":{"subscriberNumber":"7711112343","customerID":172882952,"defaultRcBen":0,"objectID":0},"objectsFirst":[],"objects":[{"name":"TP_BUND","type":"OPTIONAL","excludeDefaultFeatures":false,"actionType":"ADD","objectType":"SOC","offerParameters":{},"ignoreIfValidationError":false,"expirationDate":"Oct 23, 2017 12:00:00 AM","campId":-1,"subgroupId":-1,"skipAllEligibilityChecks":false,"fake":false},{"code":"CHTP8","socName":"TP_BUND","actionType":"MODIFY","objectType":"FTR","offerParameters":{"PRPDAYS":{"paramName":"PRPDAYS","paramValue":"4"},"BALMOD":{"paramName":"BALMOD","paramValue":"EXAMPLE_BUNTPBAL"},"OVRATE":{"paramName":"OVRATE","paramValue":"100.00"}},"ignoreIfValidationError":true,"expirationDate":"Oct 23, 2017 12:00:00 AM","campId":-1,"subgroupId":-1,"skipAllEligibilityChecks":true,"fake":false}],"removedObjects":[],"effectiveDate":"Oct 19, 2017 12:00:00 AM","sendToSPSS":false,"validationSettings":{"checkList":["WEB_ADD_IND","REMOVE_IND","WEB_UPDATE_IND","NON_PUBLIC_IND","CONFLICT_RESOLVING","FRIEND_BALANCE_LOGIC","SKIP_PROMISED_PAYMENT_LOGIC"]},"comments":[],"offerStatuses":{},"notificationHolderDO":{"generalSmsList":[],"generalEmailList":[],"rejectSmsList":[],"rejectEmailList":[],"requestComments":[]},"orderPolicy":"POST_EXECUTION_TRANSACTION","notificationTypes":["COMMENT","CHANNELS"],"status":"UNSEEN"}],"validationResult":{"validationErrors":[]}},"requestId":2172501022,"lineNumber":1,"requestType":{"code":"MSCH"},"requestSubType":{"code":"GAPI"},"requestStatus":"IN_PROGRESS","requestPriority":{"value":1},"creationDate":"Oct 19, 2017 3:09:05 PM","lastUpdateDate":"Oct 19, 2017 3:09:05 PM","nodeId":600044573,"customerId":172882952,"requestParams":{"requestType":{"code":"MSCH"},"requestSubType":{"code":"GAPI"},"effectiveDate":"Oct 19, 2017 3:09:05 PM","initiatorName":"/RP_USSDHTTP","operatorId":"7711112343","contactPhone":"7711112343","nodeId":600044573,"customerId":172882952,"locale":"ru_RU","createNotificationObject":false,"generalSuccessInitiatorNotification":false,"generalRejectInitiatorNotification":true,"generalSuccessSubscriberNotification":false,"generalRejectSubscriberNotification":false,"customizeRPNotification":false,"isB2C":true,"linkedAccountContactPhone":[],"linkedAccountContactEmail":[],"channel":"RP_USSDHTTP"},"operatorId":"/RP_USSDHTTP","notificationHolder":{"generalSmsList":[{"id":0,"requestID":0,"templateKey":"FINAL_TEXT220_1","phoneNumber":"7711112343","parameters":{"BNSERVICENAME":"??????????? ?????? TP_BUND EXTRA","BNUMBER":"1554476","msisdn":"7711112343","PRPDAYS":4,"OVRATE!1":"100.00","EXPIRATION_DATE":4,"BNSERVICECODE":"1554476","ANUMBER":"7711112343","CURRENCY":"P","STATUS_ENSEMBLE":"A","PCID":"PROM_PAYMENT_100 ","BALMOD":"BALANCE\u003d100.00","CURRENTDATE":"Oct 19, 2017 3:09:04 PM","ussd":"1554476","LANG":"ru_RU","USSDHTTP":"true","OVRATE!2":"0.00"},"locale":"ru_RU","priority":1,"status":"NEW","needStatusUpdate":false,"multipleNotification":false}],"generalEmailList":[],"rejectSmsList":[],"rejectEmailList":[],"requestComments":[]},"locale":"ru_RU","postProcessActions":[]}
  485. [2017-10-19 15:09:05,608] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:94 ID:- U:- - b5403c8e-16cc-46a2-a747-fadd86607a04: Call GetLogicalDate in session 76987258
  486. [2017-10-19 15:09:05,619] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:127 ID:- U:- - b5403c8e-16cc-46a2-a747-fadd86607a04: Call GetLogicalDate in session 76987258 took 10 ms [00000]
  487. [2017-10-19 15:09:05,621] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145621-kz-ussapppl01.kar-tel U:- - Method VIPCustomServicesEJB.retrieveAccountType invoked with parameters [<VIPRetrieveAccountTypeParamsDO><CTN>null</CTN><ban>172882952</ban></VIPRetrieveAccountTypeParamsDO>].
  488. [2017-10-19 15:09:05,622] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404145621-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.billing.dl.VIPAppRetrieveAccountTypeSrv generateRetrieveSqlString sql is: SELECT BA.ACCOUNT_TYPE, BA.BAN, BA.MARKET_CODE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.BAN_STATUS FROM ECR9_BILLING_ACCOUNT BA, ECR9_ADDRESS_NAME_LINK ANL WHERE 1=1 AND BA.BAN = ? AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = 'T'
  489. [2017-10-19 15:09:05,622] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404145621-kz-ussapppl01.kar-tel U:- - SQL: SELECT BA.ACCOUNT_TYPE, BA.BAN, BA.MARKET_CODE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.BAN_STATUS FROM ECR9_BILLING_ACCOUNT BA, ECR9_ADDRESS_NAME_LINK ANL WHERE 1=1 AND BA.BAN = ? AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = 'T'
  490. [2017-10-19 15:09:05,623] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404145621-kz-ussapppl01.kar-tel U:- - {1: 172882952}
  491. [2017-10-19 15:09:05,623] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404145621-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.billing.dl.VIPAppRetrieveAccountTypeSrv Filling statement with parameters: <VIPRetrieveAccountTypeParamsDO><CTN>null</CTN><ban>172882952</ban></VIPRetrieveAccountTypeParamsDO>
  492. [2017-10-19 15:09:05,625] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404145621-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.billing.dl.VIPAppRetrieveAccountTypeSrv
  493. init/exec/read:1/2/0 Total: 3
  494. [2017-10-19 15:09:05,625] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145621-kz-ussapppl01.kar-tel U:- - Method VIPCustomServicesEJB.retrieveAccountType invocation with parameters [<VIPRetrieveAccountTypeParamsDO><CTN>null</CTN><ban>172882952</ban></VIPRetrieveAccountTypeParamsDO>] has been completed in 4 ms.
  495. [2017-10-19 15:09:05,626] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AddRemoveSocProcessor:processSingleTransaction:340 ID:- U:- - before napi: [SocDO(super=OfferDO(actionType=ADD, objectType=SOC, offerParameters={}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), name=TP_BUND, type=OPTIONAL, excludeDefaultFeatures=false), FeatureDO(super=OfferDO(actionType=MODIFY, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=true, fake=false), code=CHTP8, socName=TP_BUND)];effDate=Thu Oct 19 00:00:00 ALMT 2017
  496. [2017-10-19 15:09:05,630] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:startService:67 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StartServiceRequest.setBAN(172882952)
  497. [2017-10-19 15:09:05,630] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:startService:69 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StartServiceRequest.setSUBSCRIBER_NO(7711112343)
  498. [2017-10-19 15:09:05,630] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:startService:71 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StartServiceRequest.setRSN_CODE(NR)
  499. [2017-10-19 15:09:05,631] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:startService:76 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StartServiceRequest.setACTV_DATE(20171019)
  500. [2017-10-19 15:09:05,631] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:94 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call StartServiceRequest in session 76987258
  501. [2017-10-19 15:09:05,646] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:127 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call StartServiceRequest in session 76987258 took 14 ms [00000]
  502. [2017-10-19 15:09:05,646] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:getState:148 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StartServiceRequest returned state 00000
  503. [2017-10-19 15:09:05,646] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeService:202 ID:- U:- - ChangeService.setBAN('172882952')
  504. [2017-10-19 15:09:05,646] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeService:204 ID:- U:- - ChangeService.setSUBSCRIBER_NO('7711112343')
  505. [2017-10-19 15:09:05,647] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeService:206 ID:- U:- - ChangeService.setSOC('TP_BUND')
  506. [2017-10-19 15:09:05,647] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeService:208 ID:- U:- - ChangeService.setINCLUSION_TYPE(65,'A')
  507. [2017-10-19 15:09:05,647] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeService:211 ID:- U:- - ChangeService.setEXPIRATION_DATE('20171023')
  508. [2017-10-19 15:09:05,647] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeService:218 ID:- U:- - ChangeService.setEXCL_DEF_ACT_FTR(N)
  509. [2017-10-19 15:09:05,647] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:94 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call ChangeService in session 76987258
  510. [2017-10-19 15:09:05,676] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:127 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call ChangeService in session 76987258 took 27 ms [ER028]
  511. [2017-10-19 15:09:05,676] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:getState:148 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: ChangeService returned state ER028
  512. [2017-10-19 15:09:05,676] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:callService:81 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: NAPI Service return WARNING ER028 com.vip.ensemble.napi.ChangeService@b5dfcb7[in={BAN=[172882952], EXCL_DEF_ACT_FTR=[78], OPERATOR_ID=[99926], APPLICATION_ID=[NAPI_J], SUBSCRIBER_NO=[7711112343], INCLUSION_TYPE=[65], EXPIRATION_DATE=[20171023], RUN_DATE=[20171019], DIRECTIVE=[0], TRANSACTION_MODE=[79], MARKET_CODE=[VIP], SESSION_ID=[76987258], SOC=[TP_BUND]},out={STATE=[ER028], TRANSACTION_MODE=[79], MARKET_CODE=[KZT], EXT_TRX_NO=[-8578.0], RUN_DATE=[20171019], SESSION_ID=[76987258], OPERATOR_ID=[99926], DIRECTIVE=[0], APPLICATION_ID=[NAPI_J]}]
  513. [2017-10-19 15:09:05,677] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:243 ID:- U:- - ChangeFeatureParam.setBAN('172882952')
  514. [2017-10-19 15:09:05,677] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:245 ID:- U:- - ChangeFeatureParam.setSUBSCRIBER_NO('7711112343')
  515. [2017-10-19 15:09:05,677] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:247 ID:- U:- - ChangeFeatureParam.setSOC('TP_BUND')
  516. [2017-10-19 15:09:05,677] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:249 ID:- U:- - ChangeFeatureParam.setFEATURE_CODE('CHTP8')
  517. [2017-10-19 15:09:05,677] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:252 ID:- U:- - ChangeFeatureParam.setROWCOUNT('3')
  518. [2017-10-19 15:09:05,678] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:256 ID:- U:- - ChangeFeatureParam.setPARAM_CODE(0)=PRPDAYS
  519. [2017-10-19 15:09:05,678] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:258 ID:- U:- - ChangeFeatureParam.setPARAM_VALUE(0)=4
  520. [2017-10-19 15:09:05,678] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:256 ID:- U:- - ChangeFeatureParam.setPARAM_CODE(1)=BALMOD
  521. [2017-10-19 15:09:05,678] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:258 ID:- U:- - ChangeFeatureParam.setPARAM_VALUE(1)=EXAMPLE_BUNTPBAL
  522. [2017-10-19 15:09:05,678] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:256 ID:- U:- - ChangeFeatureParam.setPARAM_CODE(2)=OVRATE
  523. [2017-10-19 15:09:05,679] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiOfferingNewDAO:changeFeatureParam:258 ID:- U:- - ChangeFeatureParam.setPARAM_VALUE(2)=100.00
  524. [2017-10-19 15:09:05,679] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:94 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call ChangeFeatureParam in session 76987258
  525. [2017-10-19 15:09:05,695] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:127 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call ChangeFeatureParam in session 76987258 took 16 ms [00000]
  526. [2017-10-19 15:09:05,695] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:getState:148 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: ChangeFeatureParam returned state 00000
  527. [2017-10-19 15:09:05,696] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:commit:31 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Start commit NAPI transaction
  528. [2017-10-19 15:09:05,696] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:stopService:85 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StopServiceRequest.setAPPROV_IND(Y)
  529. [2017-10-19 15:09:05,696] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:stopService:87 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StopServiceRequest.setBAN(172882952)
  530. [2017-10-19 15:09:05,696] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiUpdateHandler:stopService:89 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StopServiceRequest.setSUBSCRIBER_NO(7711112343)
  531. [2017-10-19 15:09:05,696] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:94 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call StopServiceRequest in session 76987258
  532. [2017-10-19 15:09:05,711] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:invokeCallService:127 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: Call StopServiceRequest in session 76987258 took 13 ms [ER028]
  533. [2017-10-19 15:09:05,711] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG NapiBaseHandler:getState:148 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: StopServiceRequest returned state ER028
  534. [2017-10-19 15:09:05,712] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR NapiBaseHandler:callService:85 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: NAPIERROR StopServiceRequest returned state [ER028]: com.vip.ensemble.napi.StopServiceRequest@477a5835[in={BAN=[172882952], OPERATOR_ID=[99926], APPLICATION_ID=[NAPI_J], SUBSCRIBER_NO=[7711112343], APPROV_IND=[89], RUN_DATE=[20171019], DIRECTIVE=[0], TRANSACTION_MODE=[79], MARKET_CODE=[VIP], SESSION_ID=[76987258]},out={LAST_UPDATE_DATE=[20171019150905], SERV_TRX_NO=[0], ERR_FUNCTION_NAME=[cvRollback], ERR_COUNTER=[1], ERR_SEVERITY=[2], MARKET_CODE=[KZT], ERR_SYMBOLIC_CODE=[ERR_TRACE_FAILURE], STATE=[ER028], OPERATOR_ID=[99926], SVC_STATUS=[32], ERR_USER_VALUE=[4], LAST_UPDATE_STAMP=[7065], GROUP_TRX_ID=[0], SESSION_ID=[76987258], ERR_FILE_NAME=[/vmphome/vmp/ccvmp/mb_ccvmp/bb/v], SECOND_DIRECTIVE=[0], ERR_TEXT=[Trace Failure], EXT_TRX_NO=[0.0], TRANSACTION_MODE=[79], ONLINE_TRX_NO=[0], ERR_LINE_NUMBER=[977], APPLICATION_ID=[NAPI_J], DIRECTIVE=[0], ERR_TYPE=[APP], ERR_CODE=[-2147483643], RUN_DATE=[20171019]}]
  535. [2017-10-19 15:09:05,712] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR NapiUpdateHandler:commit:36 ID:- U:- - 13af2d38-655c-48dc-9a08-fffba042e5c9: NapiError when commit NAPI transaction: ER028[StopServiceRequest][]
  536. [2017-10-19 15:09:05,712] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR AddRemoveSocProcessor:processSingleTransaction:363 ID:- U:- - Can't change soc [SocDO(super=OfferDO(actionType=ADD, objectType=SOC, offerParameters={}, webProduct=null, ignoreIfValidationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), name=TP_BUND, type=OPTIONAL, excludeDefaultFeatures=false), FeatureDO(super=OfferDO(actionType=MODIFY, objectType=FTR, offerParameters={PRPDAYS=OfferParameterDO(paramName=PRPDAYS, paramValue=4, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), BALMOD=OfferParameterDO(paramName=BALMOD, paramValue=EXAMPLE_BUNTPBAL, valueDescriptionRu=null, valueDescriptionEn=null, setId=null), OVRATE=OfferParameterDO(paramName=OVRATE, paramValue=100.00, valueDescriptionRu=null, valueDescriptionEn=null, setId=null)}, webProduct=null, ignoreIfValidationError=true, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=true, fake=false), code=CHTP8, socName=TP_BUND)]
  537. com.amdocs.css.core.exceptions.NapiException: ER028[StopServiceRequest][]
  538. at com.amdocs.css.vip.napi.NapiBaseHandler.callService(NapiBaseHandler.java:87) ~[_wl_cls_gen.jar:?]
  539. at com.amdocs.css.vip.napi.NapiUpdateHandler.stopService(NapiUpdateHandler.java:96) ~[_wl_cls_gen.jar:?]
  540. at com.amdocs.css.vip.napi.NapiUpdateHandler.commit(NapiUpdateHandler.java:32) ~[_wl_cls_gen.jar:?]
  541. at com.amdocs.css.vip.napi.NapiOfferingNewDAO._changeSoc(NapiOfferingNewDAO.java:111) ~[_wl_cls_gen.jar:?]
  542. at com.amdocs.css.vip.napi.NapiOfferingNewDAO.changeSoc(NapiOfferingNewDAO.java:59) ~[_wl_cls_gen.jar:?]
  543. at com.amdocs.css.vip.request.service.AddRemoveSocProcessor.processSingleTransaction(AddRemoveSocProcessor.java:342) [_wl_cls_gen.jar:?]
  544. at com.amdocs.css.vip.request.service.AddRemoveSocProcessor.processTransaction(AddRemoveSocProcessor.java:262) [_wl_cls_gen.jar:?]
  545. at com.amdocs.css.vip.request.service.AddRemoveSocProcessor.processRequest(AddRemoveSocProcessor.java:157) [_wl_cls_gen.jar:?]
  546. at com.amdocs.css.vip.request.service.AddRemoveSocProcessor.processRequest(AddRemoveSocProcessor.java:118) [_wl_cls_gen.jar:?]
  547. at com.amdocs.css.vip.request.AbstractRequestProcessor.process(AbstractRequestProcessor.java:66) [usscore-kz.5.7.0.jar:?]
  548. at com.amdocs.css.vip.request.bo.BaseMDB.processMessage(BaseMDB.java:59) [usscore-kz.5.7.0.jar:?]
  549. at com.amdocs.css.vip.request.ManageQueueMDB.onMessage(ManageQueueMDB.java:22) [_wl_cls_gen.jar:?]
  550. at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:451) [weblogic.server.merged.jar:12.1.3.0.0]
  551. at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:375) [weblogic.server.merged.jar:12.1.3.0.0]
  552. at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:310) [weblogic.server.merged.jar:12.1.3.0.0]
  553. at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4855) [weblogic.server.merged.jar:12.1.3.0.0]
  554. at weblogic.jms.client.JMSSession.execute(JMSSession.java:4529) [weblogic.server.merged.jar:12.1.3.0.0]
  555. at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3976) [weblogic.server.merged.jar:12.1.3.0.0]
  556. at weblogic.jms.client.JMSSession.access$000(JMSSession.java:120) [weblogic.server.merged.jar:12.1.3.0.0]
  557. at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5375) [weblogic.server.merged.jar:12.1.3.0.0]
  558. at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:548) [weblogic.server.merged.jar:12.1.3.0.0]
  559. at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311) [weblogic.server.merged.jar:12.1.3.0.0]
  560. at weblogic.work.ExecuteThread.run(ExecuteThread.java:263) [weblogic.server.merged.jar:12.1.3.0.0]
  561. [2017-10-19 15:09:05,713] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  562. [2017-10-19 15:09:05,714] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  563. [2017-10-19 15:09:05,714] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: 172882952, 2: T}
  564. [2017-10-19 15:09:05,714] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  565. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  566. <allInfo type=boolean>true</allInfo>
  567. </com.amdocs.css.vip.account.data.AccountFilterDO>
  568. <com.amdocs.css.core.util.data.DataObject>
  569. </com.amdocs.css.core.util.data.DataObject>
  570. <java.lang.Object>
  571. </java.lang.Object>
  572.  
  573. [2017-10-19 15:09:05,715] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  574. init/exec/read:1/1/0 Total: 2
  575. [2017-10-19 15:09:05,717] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145717-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberByPK invoked with parameters [VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)].
  576. [2017-10-19 15:09:05,718] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:1508404145717-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv generateRetrieveSqlString sql is: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S') and customer_id = ?
  577. [2017-10-19 15:09:05,718] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:185 ID:1508404145717-kz-ussapppl01.kar-tel U:- - SQL: SELECT * FROM ECR9_SUBSCRIBER WHERE SUBSCRIBER_NO = ? AND SUB_STATUS IN ('A','S') and customer_id = ?
  578. [2017-10-19 15:09:05,719] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:191 ID:1508404145717-kz-ussapppl01.kar-tel U:- - {1: 7711112343 , 2: 172882952}
  579. [2017-10-19 15:09:05,719] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:193 ID:1508404145717-kz-ussapppl01.kar-tel U:- - com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv Filling statement with parameters: VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)
  580. [2017-10-19 15:09:05,720] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUnique:216 ID:1508404145717-kz-ussapppl01.kar-tel U:- - Timings for com.amdocs.css.vip.subscriber.dl.VIPAppRetrieveSubscriberByPKSrv
  581. init/exec/read:1/1/0 Total: 2
  582. [2017-10-19 15:09:05,721] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145717-kz-ussapppl01.kar-tel U:- - Method VIPSubscriberServicesEJB.getSubscriberByPK invocation with parameters [VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=0, objectID=0)] has been completed in 3 ms.
  583. [2017-10-19 15:09:05,723] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404145723-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getB2CCurrency invoked with parameters [<VIPBillingAccountDO>
  584. <ban>172882952</ban>
  585. <accountType>13</accountType>
  586. <billCycle>7</billCycle>
  587. <banStatus>O</banStatus>
  588. <vatExemptInd>null</vatExemptInd>
  589. <registerInd>Y</registerInd>
  590. <marketCode>KZT</marketCode>
  591. <payerBan>0</payerBan>
  592. <payerBanInd>null</payerBanInd>
  593. <creditClass>1</creditClass>
  594. <creditLimitAmt>0.0</creditLimitAmt>
  595. <newCycle>0</newCycle>
  596. <accountCategory>P</accountCategory>
  597. <cugEligibilityInd>false</cugEligibilityInd>
  598. <cugId>0</cugId>
  599. <banGroup>null</banGroup>
  600. <banCurrencyInd>D</banCurrencyInd>
  601. <historicalBanInd>null</migrationStatus>
  602. <linkedBan>0</linkedBan>
  603. <unifiedBillBanInd>null</unifiedBillBanInd><unifiedBillBan>0</unifiedBillBan><payerBanAccessInd>null</payerBanAccessInd>
  604. <cycleMonth>0</cycleMonth>
  605. <defaultRcBen>1</defaultRcBen>
  606. <nbFieldsToUpdate>0</nbFieldsToUpdate>
  607. <listNames>[null, null, null, null, null]</listNames><counterIndicator>0</counterIndicator><taxId>null</taxId><replaceSimAbility>false</replaceSimAbility></VIPBillingAccountDO>
  608. , VIPSubscriberDO(subscriberNumber=7711112343, customerId=172882952, initActDate=2017-09-13, subStatus=A, subStatusDate=2017-09-13, subStatusLastAct=NAC, subStatusRsnCode=PR , defaultRcBen=1, productCode=GVOI, lastActCode=null, lastActRsn=null, lastActDate=null, limitOptionAmtValue=0.0, limitOptionAmt=0.0, currentPP=SEV_KZT2, futurePP=null, pairedResourceTp=S, currentPPDesc=????, futurePPDesc=null, futurePPDate=null, subStatusDesc=null, actCodeRsnDesc=null, accountCategory=null, viewLinkStr=view, errorChangeStatus=false, sysUpdateDate=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N)].
  609. [2017-10-19 15:09:05,723] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG CallLoggingInterceptor:intercept:59 ID:1508404145723-kz-ussapppl01.kar-tel U:- - Method VIPAccountEJB.getB2CCurrency invocation with parameters [<VIPBillingAccountDO>
  610. <ban>172882952</ban>
  611. <accountType>13</accountType>
  612. <billCycle>7</billCycle>
  613. <banStatus>O</banStatus>
  614. <vatExemptInd>null</vatExemptInd>
  615. <registerInd>Y</registerInd>
  616. <marketCode>KZT</marketCode>
  617. <payerBan>0</payerBan>
  618. <payerBanInd>null</payerBanInd>
  619. <creditClass>1</creditClass>
  620. <creditLimitAmt>0.0</creditLimitAmt>
  621. <newCycle>0</newCycle>
  622. <accountCategory>P</accountCategory>
  623. <cugEligibilityInd>false</cugEligibilityInd>
  624. <cugId>0</cugId>
  625. <banGroup>null</banGroup>
  626. <banCurrencyInd>D</banCurrencyInd>
  627. <historicalBanInd>null</migrationStatus>
  628. <linkedBan>0</linkedBan>
  629. <unifiedBillBanInd>null</unifiedBillBanInd><unifiedBillBan>0</unifiedBillBan><payerBanAccessInd>null</payerBanAccessInd>
  630. <cycleMonth>0</cycleMonth>
  631. <defaultRcBen>1</defaultRcBen>
  632. <nbFieldsToUpdate>0</nbFieldsToUpdate>
  633. <listNames>[null, null, null, null, null]</listNames><counterIndicator>0</counterIndicator><taxId>null</taxId><replaceSimAbility>false</replaceSimAbility></VIPBillingAccountDO>
  634. , VIPSubscriberDO(subscriberNumber=7711112343, customerId=172882952, initActDate=2017-09-13, subStatus=A, subStatusDate=2017-09-13, subStatusLastAct=NAC, subStatusRsnCode=PR , defaultRcBen=1, productCode=GVOI, lastActCode=null, lastActRsn=null, lastActDate=null, limitOptionAmtValue=0.0, limitOptionAmt=0.0, currentPP=SEV_KZT2, futurePP=null, pairedResourceTp=S, currentPPDesc=????, futurePPDesc=null, futurePPDate=null, subStatusDesc=null, actCodeRsnDesc=null, accountCategory=null, viewLinkStr=view, errorChangeStatus=false, sysUpdateDate=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N)] has been completed in 0 ms.
  635. [2017-10-19 15:09:05,726] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:generateRetrieveSqlString:295 ID:- U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv generateRetrieveSqlString sql is: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  636. [2017-10-19 15:09:05,726] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:240 ID:- U:- - SQL: SELECT BA.BAN, BA.ACCOUNT_TYPE, BA.BILL_CYCLE, BA.BAN_STATUS, BA.BL_VAT_EXEMPT_IND, BA.REGISTER_IND, BA.MARKET_CODE, BA.PAYER_BAN, BA.PAYER_BAN_IND, BA.CREDIT_CLASS, BA.CREDIT_LIMIT_AMT, BA.BL_NEW_CYCLE, BA.AT_ACCOUNT_CATEGORY, BA.DEF_BAN_CUR, BA.HIST_BAN_IND, BA.ADD_BAN_ID, BA.BL_VAT_REG_NUM, BA.DEFAULT_BEN, BA.CUST_DOC_NO, BAE.DEPOSIT_INTERNATIONAL_IND, BAE.DEPOSIT_NATIONAL_IND, BAE.BAN_GROUP, BAE.CUG_ELIGIBILITY_IND, BAE.CUG_ID, BAE.LIST1_NAME, BAE.LIST2_NAME, BAE.LIST3_NAME, BAE.LIST4_NAME, BAE.LIST5_NAME, BAE.UPDATE_SEQ_NO, BAE.PUBLIC_IND, BAE.SMS_REMAINS, BAE.SMS_PACKAGE_EXPIRED_DATE, BAE.REPLACE_SIM_IND, ND.NAME_FORMAT, ND.NAME_TITLE, ND.LAST_BUSINESS_NAME, ND.FIRST_NAME, ND.ADDITIONAL_TITLE FROM ECR9_BILLING_ACCOUNT BA, ECR9_BILLING_ACCOUNT_EXT BAE, ECR9_ADDRESS_NAME_LINK ANL, ECR9_NAME_DATA ND WHERE BA.BAN = ? AND ND.NAME_ID = ANL.NAME_ID AND ANL.BAN = BA.BAN AND ANL.LINK_TYPE = ? AND BA.BAN = BAE.BAN(+)
  637. [2017-10-19 15:09:05,726] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:246 ID:- U:- - {1: 172882952, 2: T}
  638. [2017-10-19 15:09:05,726] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:248 ID:- U:- - com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv Filling statement with parameters: <com.amdocs.css.vip.account.data.AccountFilterDO>
  639. <pk type=com.amdocs.css.vip.account.data.AccountPK><AccountPK><accountId>172882952</accountId></AccountPK></pk>
  640. <allInfo type=boolean>true</allInfo>
  641. </com.amdocs.css.vip.account.data.AccountFilterDO>
  642. <com.amdocs.css.core.util.data.DataObject>
  643. </com.amdocs.css.core.util.data.DataObject>
  644. <java.lang.Object>
  645. </java.lang.Object>
  646.  
  647. [2017-10-19 15:09:05,727] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeUniqueWithException:272 ID:- U:- - Timings for com.amdocs.css.vip.account.dl.VIPAppRetrieveBanInfoSrv
  648. init/exec/read:1/1/0 Total: 2
  649. 01231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  650. ervice_type FROM ecr9_service_agreement esa WHERE 1=1 AND esa.soc = ? AND esa.service_type in ('P', 'O') AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esa.ban=? AND esa.subscriber_no=?
  651. [2017-10-19 15:09:05,729] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:- U:- - {1: TP_BUND , 2: 2017-10-19, 3: 172882952, 4: 7711112343 }
  652. ntFilter [subscriberNumber=7711112343, subscriberPKs=null, needGroupingBySoc=true]
  653. [2017-10-19 15:09:05,731] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:- U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  654. init/exec/read:1/1/0 Total: 2
  655. untDO>
  656. <ban>172882952</ban>
  657. <accountType>13</accountType>
  658. <billCycle>7</billCycle>
  659. <banStatus>O</banStatus>
  660. <vatExemptInd>null</vatExemptInd>
  661. <registerInd>Y</registerInd>
  662. <marketCode>KZT</marketCode>
  663. <payerBan>0</payerBan>
  664. <payerBanInd>null</payerBanInd>
  665. <creditClass>1</creditClass>
  666. <creditLimitAmt>0.0</creditLimitAmt>
  667. <newCycle>0</newCycle>
  668. <accountCategory>P</accountCategory>
  669. <cugEligibilityInd>false</cugEligibilityInd>
  670. <cugId>0</cugId>
  671. <banGroup>null</banGroup>
  672. <banCurrencyInd>D</banCurrencyInd>
  673. <historicalBanInd>null</migrationStatus>
  674. <linkedBan>0</linkedBan>
  675. <unifiedBillBanInd>null</unifiedBillBanInd><unifiedBillBan>0</unifiedBillBan><payerBanAccessInd>null</payerBanAccessInd>
  676. <cycleMonth>0</cycleMonth>
  677. <defaultRcBen>1</defaultRcBen>
  678. <nbFieldsToUpdate>0</nbFieldsToUpdate>
  679. <listNames>[null, null, null, null, null]</listNames><counterIndicator>0</counterIndicator><taxId>null</taxId><replaceSimAbility>false</replaceSimAbility></VIPBillingAccountDO>
  680. e=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N)].
  681. ccountDO>
  682. <ban>172882952</ban>
  683. <accountType>13</accountType>
  684. <billCycle>7</billCycle>
  685. <banStatus>O</banStatus>
  686. <vatExemptInd>null</vatExemptInd>
  687. <registerInd>Y</registerInd>
  688. <marketCode>KZT</marketCode>
  689. <payerBan>0</payerBan>
  690. <payerBanInd>null</payerBanInd>
  691. <creditClass>1</creditClass>
  692. <creditLimitAmt>0.0</creditLimitAmt>
  693. <newCycle>0</newCycle>
  694. <accountCategory>P</accountCategory>
  695. <cugEligibilityInd>false</cugEligibilityInd>
  696. <cugId>0</cugId>
  697. <banGroup>null</banGroup>
  698. <banCurrencyInd>D</banCurrencyInd>
  699. <historicalBanInd>null</migrationStatus>
  700. <linkedBan>0</linkedBan>
  701. <unifiedBillBanInd>null</unifiedBillBanInd><unifiedBillBan>0</unifiedBillBan><payerBanAccessInd>null</payerBanAccessInd>
  702. <cycleMonth>0</cycleMonth>
  703. <defaultRcBen>1</defaultRcBen>
  704. <nbFieldsToUpdate>0</nbFieldsToUpdate>
  705. <listNames>[null, null, null, null, null]</listNames><counterIndicator>0</counterIndicator><taxId>null</taxId><replaceSimAbility>false</replaceSimAbility></VIPBillingAccountDO>
  706. e=null, sysCreationDate=null, ngp=1, allowEasyCCN=Y, subscriberId=68781912, discountDateEnd=null, lastChangeTariffDate=null, portInd=N)] has been completed in 0 ms.
  707. , NOTE, DEPOSIT_IND FROM ECR6_BAN_SOC_AVAILABLE WHERE 1=1 AND BAN = ?
  708. [2017-10-19 15:09:05,745] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:137 ID:- U:- - SQL: SELECT BAN, SOC, NOTE, DEPOSIT_IND FROM ECR6_BAN_SOC_AVAILABLE WHERE 1=1 AND BAN = ?
  709. [2017-10-19 15:09:05,745] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:- U:- - {1: 172882952}
  710. subscriber.data.BanSocAvailableFilterDO@33242e0e
  711. [2017-10-19 15:09:05,746] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:- U:- - Timings for com.amdocs.css.vip.subscriber.dl.BanSocAvailableSrv
  712. init/exec/read:1/0/0 Total: 1
  713. ? , ? , ? , ? )
  714. E('47001231','YYYYMMDD')) AND esh.customer_id=esa.ban AND esh.subscriber_no=esa.subscriber_no
  715. ervice_type FROM ecr9_service_agreement esa, ecr6_subscriber_for_sel_hier esh WHERE 1=1 AND esa.service_type='O' AND ? < nvl(esa.EXPIRATION_DATE,TO_DATE('47001231','YYYYMMDD')) AND esh.customer_id=esa.ban AND esh.subscriber_no=esa.subscriber_no
  716. [2017-10-19 15:09:05,749] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:95 ID:- U:- - {1: 2017-10-19}
  717. ntFilter [subscriberNumber=null, subscriberPKs=[VIPSubscriberPK(subscriberNumber=7711112343, customerID=172882952, defaultRcBen=1, objectID=0)], needGroupingBySoc=true]
  718. [2017-10-19 15:09:05,752] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:execute:117 ID:- U:- - Timings for com.amdocs.css.vip.offering.newoffering.service.bss.BssConnectedSocSrv
  719. init/exec/read:1/2/0 Total: 3
  720. [2017-10-19 15:09:05,756] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  721. [2017-10-19 15:09:05,757] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  722. [2017-10-19 15:09:05,757] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  723. [2017-10-19 15:09:05,758] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  724. [2017-10-19 15:09:05,758] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  725. [2017-10-19 15:09:05,759] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  726. ? , ? , ? , ? )
  727. W.SUBSCRIBER_NO, IW.INDICATOR_ID, IW.EFFECTIVE_DATE, IW.EXPIRATION_DATE, IW.IW_VALUE FROM ECR9_IW_STORAGE IW, ECR6_SUBSCRIBER_FOR_SEL_HIER SEL WHERE IW.BAN = SEL.CUSTOMER_ID AND IW.SUBSCRIBER_NO = SEL.SUBSCRIBER_NO AND IW.INDICATOR_ID = ?
  728. FROM ECR9_IW_STORAGE IW, ECR6_SUBSCRIBER_FOR_SEL_HIER SEL WHERE IW.BAN = SEL.CUSTOMER_ID AND IW.SUBSCRIBER_NO = SEL.SUBSCRIBER_NO AND IW.INDICATOR_ID = ?
  729. [2017-10-19 15:09:05,762] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:143 ID:- U:- - {1: TAB_SOC }
  730. [2017-10-19 15:09:05,762] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:145 ID:- U:- - com.amdocs.css.vip.customer.dl.IWStorageDataGetSrv Filling statement with parameters: TAB_SOC
  731. [2017-10-19 15:09:05,763] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AbstractNewSrv:executeWithException:165 ID:- U:- - Timings for com.amdocs.css.vip.customer.dl.IWStorageDataGetSrv
  732. init/exec/read:1/0/0 Total: 1
  733. [2017-10-19 15:09:05,764] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  734. [2017-10-19 15:09:05,765] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  735. [2017-10-19 15:09:05,765] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  736. [2017-10-19 15:09:05,766] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  737. [2017-10-19 15:09:05,767] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  738. [2017-10-19 15:09:05,767] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  739. [2017-10-19 15:09:05,767] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG BaseOfferBO:retrieveWebEntity:153 ID:- U:- - loading Web Entity not found, try to load different category
  740. d. The main transaction:
  741. ks=true, fake=false), code=CHTP8, socName=TP_BUND)];effectiveDate=Thu Oct 19 00:00:00 ALMT 2017;validationSettings=<com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  742. <checkList type=java.util.EnumSet>[WEB_ADD_IND, REMOVE_IND, WEB_UPDATE_IND, NON_PUBLIC_IND, CONFLICT_RESOLVING, FRIEND_BALANCE_LOGIC, SKIP_PROMISED_PAYMENT_LOGIC]</checkList>
  743. </com.amdocs.css.core.ens.data.TransactionValidationSettingsDO>
  744. <com.amdocs.css.core.util.data.DataObject>
  745. </com.amdocs.css.core.util.data.DataObject>
  746. <java.lang.Object>
  747. </java.lang.Object>
  748. idationError=false, expirationDate=Mon Oct 23 00:00:00 ALMT 2017, campId=-1, subgroupId=-1, spssChannelType=null, skipAllEligibilityChecks=false, fake=false), name=TP_BUND, type=OPTIONAL, excludeDefaultFeatures=false)=false};dependedTransactions=null;]
  749. erviceName=????? ????????????? ??????, requestID=2172501022, Subsctiber=7711112343, Ban=172882952, CreationDate=19.10.2017 15:09, effectiveDate=19.10.2017}
  750. ??????\" ?? ????? https://my.beeline.kz","phoneNumberFrom":"My Beeline","deliveryDate":null,"priotity":1,"needStatusUpdate":false,"smsId":null,"status":"NEW"}}]].
  751. [2017-10-19 15:09:05,777] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG AppGetNextSeqSrv:execute:30 ID:1508404145776-kz-ussapppl01.kar-tel U:- - Filling statement with parameters: SMS_MESSAGE_SEQ
  752. SMS, STATUS, STATUS_DATE, DELIVERY_DATE, TEMPLATE_KEY, REQUEST_ID, PRIORITY, NEED_STATUS_UPDATE ) values ( ?,sysdate,?,?,?,?,sysdate,?,?,?,?,? )
  753. ??????? +77711112343 ?? ????? ???? ??????????. ??????????? ??????? ?2172501022 ? "??????? ??????" ?? ????? https://my.beeline.kz, 4: My Beeline, 5: 0, 6: null, 7: b2c.request.MSCH.GAPI.ADD_SERVICES.SMS.failure, 8: 2172501022, 9: 1, 10: 0}
  754. https://my.beeline.kz","phoneNumberFrom":"My Beeline","deliveryDate":null,"priotity":1,"needStatusUpdate":false,"smsId":"43178884","status":"NEW"}}
  755. ?? ??????\" ?? ????? https://my.beeline.kz","phoneNumberFrom":"My Beeline","deliveryDate":null,"priotity":1,"needStatusUpdate":false,"smsId":"43178884","status":"NEW"}}]] has been completed in 5 ms.
  756. [7711112343, false, ru_RU].
  757. rs [7711112343, false, ru_RU] has been completed in 3 ms.
  758. O(requestId=2172501022, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=REJECTED, requestPriority=Low
  759. s.kartel.pp.PromisedPaymentPostProcessAction@4068fdd4], mainLogin=null, convergentParams=null), REJECTED].
  760. REJECTED; new status = REJECTED
  761. stDO(requestId=2172501022, lineNumber=1, requestType=MSCH, requestSubType=GAPI, requestStatus=REJECTED, requestPriority=Low
  762. s.kartel.pp.PromisedPaymentPostProcessAction@4068fdd4], mainLogin=null, convergentParams=null), REJECTED] has been completed in 16 ms.
  763. [2017-10-19 15:09:10,001] [DefaultQuartzScheduler_QuartzSchedulerThread] DEBUG PropertySettingJobFactory:newJob:51 ID:- U:- - Producing instance of Job 'DEFAULT.smsJob', class=ru.vimpelcom.ecare.requestprocessor.SMSJob
  764. [2017-10-19 15:09:10,002] [DefaultQuartzScheduler_Worker-2] DEBUG JobRunShell:run:212 ID:- U:- - Calling execute on job DEFAULT.smsJob
  765. [2017-10-19 15:09:10,002] [DefaultQuartzScheduler_QuartzSchedulerThread] DEBUG QuartzSchedulerThread:run:268 ID:- U:- - batch acquisition of 1 triggers
  766. [2017-10-19 15:09:10,002] [DefaultQuartzScheduler_Worker-2] DEBUG SMSJob:execute:31 ID:- U:- - Start SMSJob execute for SMSDispatcher
  767. [2017-10-19 15:09:10,004] [DefaultQuartzScheduler_Worker-2] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404150004-kz-ussapppl01.kar-tel U:- - Method VIPSMSJobBean.processSMSnew invoked with parameters [null].
  768. [2017-10-19 15:09:10,006] [DefaultQuartzScheduler_Worker-2] DEBUG CallLoggingInterceptor:intercept:44 ID:1508404150005-kz-ussapppl01.kar-tel U:- - Method VIPSMSOperationsEJB.receiveSms invoked with parameters [VIPReceivedSmsParameterDH: sourceId - null].
  769. [2017-10-19 15:09:10,006] [DefaultQuartzScheduler_Worker-2] INFO VIPSMSOperationsSMSDispatcherSQLImpl:receiveSms:208 ID:1508404150005-kz-ussapppl01.kar-tel U:- - receiveSms started for parameters = VIPReceivedSmsParameterDH: sourceId - null
  770. leted in 4 ms.
  771. [2017-10-19 15:09:10,010] [DefaultQuartzScheduler_Worker-2] DEBUG SmsOperationsDAO:receiveSms:54 ID:- U:- - 0 sms recieved.
  772. [2017-10-19 15:09:10,010] [DefaultQuartzScheduler_Worker-2] DEBUG CallLoggingInterceptor:intercept:59 ID:- U:- - Method VIPSMSJobBean.processSMSnew invocation with parameters [null] has been completed in 6 ms.
  773. [2017-10-19 15:09:10,010] [DefaultQuartzScheduler_Worker-2] DEBUG SMSJob:execute:47 ID:- U:- - Finish SMSJob execute.
  774.  
  775. [END] 19.10.2017 12:09:15
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!