API tools faq
paste
Advertisement
Guest User

govt_org M.bill-11,2019 generatation log

a guest
Nov 18th, 2019
409
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 50.57 KB | None | 0 0
raw download clone embed print report
  1. 2019-11-01 04:04:35 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2040b1a: select clientId,ltcAdjustment,ltcDiscountAdjustment,mbpsBreakDownContent,billingRangeBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,longTermContractBreakDownContent,createdDate,month,year,isDeleted,grandTotal,discountRate,discount,totalPayable,vatRate,vat,netPayable,id from at_lli_monthly_bill_client where clientId = 556002 and createdDate >= 1572544800000 and createdDate <= 1575136799999
  2. 2019-11-01 04:04:35 FATAL LLIMonthlyBillAction:? - [ X ] No data found for the month of 10
  3. 2019-11-01 04:04:35 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: getMonthlyBillView)=>:0.001068607s******
  4. 2019-11-01 04:04:38 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: getMonthlyBillView
  5. 2019-11-01 04:04:38 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  6. 2019-11-01 04:04:38 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@14d6e4a2: select clientId,ltcAdjustment,ltcDiscountAdjustment,mbpsBreakDownContent,billingRangeBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,longTermContractBreakDownContent,createdDate,month,year,isDeleted,grandTotal,discountRate,discount,totalPayable,vatRate,vat,netPayable,id from at_lli_monthly_bill_client where clientId = 556002 and createdDate >= 1572544800000 and createdDate <= 1575136799999
  7. 2019-11-01 04:04:38 FATAL LLIMonthlyBillAction:? - [ X ] No data found for the month of 10
  8. 2019-11-01 04:04:38 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: getMonthlyBillView)=>:0.001010057s******
  9. Nov 01, 2019 4:04:49 AM hudson.util.DoubleLaunchChecker execute
  10. SEVERE: Collision detected. timestamp=1572557548000, expected=1572555709000
  11. 2019-11-01 04:06:28 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: goMonthlyBillGeneratePage
  12. 2019-11-01 04:06:28 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: goMonthlyBillGeneratePage)=>:3.9804E-5s******
  13. 2019-11-01 04:06:29 INFO NotificationAction:? - Invoking : class notification.NotificationAction :: getNotificationByRoleId
  14. 2019-11-01 04:06:29 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@360c7cd0: select generation_time,module_id,entity_id,entity_Type,role_account_id,user_id,description,action_url,is_seen,is_action_taken,has_child,is_for_client,child_id,id from notification where role_account_id = 1 and user_id = 40131 and is_action_taken = 0 order by id desc
  15. 2019-11-01 04:06:29 INFO AnnotatedRequestMappingAction:? - ******(NotificationAction :: getNotificationByRoleId)=>:0.004218052s******
  16. 2019-11-01 04:06:31 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: checkMonthlyBillGenerate
  17. 2019-11-01 04:06:31 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  18. 2019-11-01 04:06:31 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@72044bdb: select clientId,mbpsBreakDownContent,billingRangeBreakDownContent,longTermContractBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,createdDate,bill_id,id from at_lli_monthly_bill_summary_client where createdDate >= 1572544800000 and createdDate <= 1575136799999
  19. 2019-11-01 04:06:31 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: checkMonthlyBillGenerate)=>:0.001617043s******
  20. 2019-11-01 04:06:38 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: checkIsBillGenerateSearch
  21. 2019-11-01 04:06:38 INFO RecordNavigationManager:? - Record Navigation0
  22. 2019-11-01 04:06:38 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  23. 2019-11-01 04:06:38 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@672f2fc0: select clientId,mbpsBreakDownContent,billingRangeBreakDownContent,longTermContractBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,createdDate,bill_id,id from at_lli_monthly_bill_summary_client where createdDate >= 1572544800000 and createdDate <= 1575136799999
  24. 2019-11-01 04:06:38 INFO RecordNavigationManager:? - Skipping/ Offset: 0, Limiting: 20
  25. 2019-11-01 04:06:38 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: checkIsBillGenerateSearch)=>:0.007127982s******
  26. 2019-11-01 04:06:39 INFO NotificationAction:? - Invoking : class notification.NotificationAction :: getNotificationByRoleId
  27. 2019-11-01 04:06:39 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@77e91961: select generation_time,module_id,entity_id,entity_Type,role_account_id,user_id,description,action_url,is_seen,is_action_taken,has_child,is_for_client,child_id,id from notification where role_account_id = 1 and user_id = 40131 and is_action_taken = 0 order by id desc
  28. 2019-11-01 04:06:39 INFO AnnotatedRequestMappingAction:? - ******(NotificationAction :: getNotificationByRoleId)=>:0.00323732s******
  29. Monthly Bill Not Generated
  30. rn :m_pageSize = 20, m_totalRecords = 846, m_currentPageNo = 1, m_totalPages = 43
  31. 2019-11-01 04:07:00 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: checkIsBillGenerateSearch
  32. 2019-11-01 04:07:00 INFO RecordNavigationManager:? - Record Navigation0
  33. 2019-11-01 04:07:00 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  34. 2019-11-01 04:07:00 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@58fcd583: select clientId,mbpsBreakDownContent,billingRangeBreakDownContent,longTermContractBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,createdDate,bill_id,id from at_lli_monthly_bill_summary_client where clientId = 556002 and createdDate >= 1572544800000 and createdDate <= 1575136799999
  35. 2019-11-01 04:07:00 INFO RecordNavigationManager:? - Skipping/ Offset: 0, Limiting: 1
  36. 2019-11-01 04:07:00 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: checkIsBillGenerateSearch)=>:0.005818007s******
  37. 2019-11-01 04:07:01 INFO NotificationAction:? - Invoking : class notification.NotificationAction :: getNotificationByRoleId
  38. 2019-11-01 04:07:01 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6abec215: select generation_time,module_id,entity_id,entity_Type,role_account_id,user_id,description,action_url,is_seen,is_action_taken,has_child,is_for_client,child_id,id from notification where role_account_id = 1 and user_id = 40131 and is_action_taken = 0 order by id desc
  39. 2019-11-01 04:07:01 INFO AnnotatedRequestMappingAction:? - ******(NotificationAction :: getNotificationByRoleId)=>:0.003181652s******
  40. Monthly Bill Not Generated
  41. rn :m_pageSize = 20, m_totalRecords = 1, m_currentPageNo = 1, m_totalPages = 1
  42. fromTime: 2019-11^C
  43. [root@localhost logs]# clear
  44. [root@localhost logs]# tail -f catalina.out
  45. 2019-11-01 04:07:00 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  46. 2019-11-01 04:07:00 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@58fcd583: select clientId,mbpsBreakDownContent,billingRangeBreakDownContent,longTermContractBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,createdDate,bill_id,id from at_lli_monthly_bill_summary_client where clientId = 556002 and createdDate >= 1572544800000 and createdDate <= 1575136799999
  47. 2019-11-01 04:07:00 INFO RecordNavigationManager:? - Skipping/ Offset: 0, Limiting: 1
  48. 2019-11-01 04:07:00 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: checkIsBillGenerateSearch)=>:0.005818007s******
  49. 2019-11-01 04:07:01 INFO NotificationAction:? - Invoking : class notification.NotificationAction :: getNotificationByRoleId
  50. 2019-11-01 04:07:01 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6abec215: select generation_time,module_id,entity_id,entity_Type,role_account_id,user_id,description,action_url,is_seen,is_action_taken,has_child,is_for_client,child_id,id from notification where role_account_id = 1 and user_id = 40131 and is_action_taken = 0 order by id desc
  51. 2019-11-01 04:07:01 INFO AnnotatedRequestMappingAction:? - ******(NotificationAction :: getNotificationByRoleId)=>:0.003181652s******
  52. Monthly Bill Not Generated
  53. rn :m_pageSize = 20, m_totalRecords = 1, m_currentPageNo = 1, m_totalPages = 1
  54. fromTime: 2019-11Nov 01, 2019 4:07:23 AM hudson.util.DoubleLaunchChecker execute
  55. SEVERE: Collision detected. timestamp=1572559489000, expected=1572555623000
  56. 2019-11-01 04:07:34 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: getMonthlyBillGenerate
  57. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5dcb2b37: select clientId,ltcAdjustment,ltcDiscountAdjustment,mbpsBreakDownsContent,billingRangeBreakDownsContent,mbpsBreakDownsForCacheContent,billingRangeBreakDownsForCacheContent,longTermContractBreakDownsContent,createdDate,month,year,isDeleted,grandTotal,discountPercentage,discount,totalPayable,vatRate,vat,netPayable,lateFee,description,id from at_lli_monthly_usage_client where clientId = 556002 and month = 9 and year = 2019
  58. 2019-11-01 04:07:34 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  59. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6fdc32d8: select clientId,ltcAdjustment,ltcDiscountAdjustment,mbpsBreakDownContent,billingRangeBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,longTermContractBreakDownContent,createdDate,month,year,isDeleted,grandTotal,discountRate,discount,totalPayable,vatRate,vat,netPayable,id from at_lli_monthly_bill_client where clientId = 556002 and createdDate >= 1572544800000 and createdDate <= 1575136799999
  60. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@17c204d5: select clientId,ltcAdjustment,ltcDiscountAdjustment,mbpsBreakDownsContent,billingRangeBreakDownsContent,mbpsBreakDownsForCacheContent,billingRangeBreakDownsForCacheContent,longTermContractBreakDownsContent,createdDate,month,year,isDeleted,grandTotal,discountPercentage,discount,totalPayable,vatRate,vat,netPayable,lateFee,description,id from at_lli_monthly_usage_client where clientId = 556002 and month = 9 and year = 2019
  61. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3733bb9f: select monthlyUsageByClientId,clientId,connectionId,type,name,address,createdDate,remark,mbpsCost,loopCost,totalCost,localLoopBreakDownsContent,connectionBandwidthBreakDownsContent,feesContent,grandCost,discountRate,discount,vatRate,vat,id from at_lli_monthly_usage_connection where monthlyUsageByClientId = 82004
  62. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1c3da4c: select ID,clientID,name,connectionType,costChartID,activeFrom,activeTo,validFrom,validTo,bandwidth,status,startDate,incident,zoneID,discountRate,historyID from at_lli_connection where activeFrom < 1572544799999 and activeTo > 1572458400000 and validTo = 9223372036854775807
  63. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1cc9ee2d: select ID,connectionHistoryID,name,address,union_area_id,historyID from at_lli_office where connectionHistoryID IN (179001,179002,196002,196006,196007,196008,196009,196010,196011,196014,196016,197001,198001,200001,200002,201001,202001,203001,203002,205002,206001,207001,207002,208001,208002,209001,209002,209003,209004,209005,209006,209007,209008,209009,209010,209011,209012,209013,209014,209015,209016,209017,209018,209019,209020,209021,209022,209023,209024,210001,210002,210003,210004,210005,210006,210007,210008,210009,210010,210011,210012,210013,210014,210015,210016,210017,210018,210019,210020,210021,210022,210023,210024,210025,210026,210027,210028,210029,210030,210031,210032,210033,210034,210035,210036,210037,210038,210039,210040,210041,210042,210043,210044,210045,210046,210047,210048,210049,210050,210051,210052,210053,210054,210055,210056,210057,210058,210059,210060,210061,210062,210063,210064,210065,210066,210067,210068,210069,210070,210071,210072,210073,210074,210075,210076,210077,210078,210079,210080,210081,210082,210083,210084,210085,210086,210087,210088,210089,210090,210091,210092,210093,210094,210095,210096,210097,210098,210099,210100,210101,210102,210103,210104,210105,210106,210107,210108,210109,210110,210111,210112,210113,210114,210115,210116,210117,210118,210119,210120,210121,210122,210123,210124,210125,210126,210127,210128,211001,211002,211003,211004,211005,211006,211007,211008,211009,211010,211011,211012,211013,211014,211015,211016,211017,211018,211020,211021,211022,211023,211024,211026,211027,211028,211029,211030,211031,211032,211033,211034,211035,211036,211037,211038,211039,211040,211041,211042,211043,211044,211045,211046,211047,211048,211049,211050,211052,211053,211054,211055,211056,211057,211058,211059,211060,211061,211063,211066,211067,211068,211069,211070,211071,211072,211073,211074,211075,211076,211077,211078,211079,211080,211081,211082,211083,211084,211086,211087,211088,211089,211090,211092,211093,211095,211097,211099,211100,211101,211104,211105,211106,211107,211108,211109,211110,211111,211112,211113,211114,211115,211116,211117,211118,211119,211120,211122,211123,211124,211125,211126,211127,211128,211129,211130,211131,211132,211133,212001,212002,212003,212004,212005,212006,212007,212008,212009,212010,212011,212012,212013,212014,213001,214001,214002,214003,214004,215001,215002,215003,215004,215005,215006,215008,215009,215010,215011,215012,215013,215014,215015,215017,215018,215019,215020,215021,215023,215025,215026,215027,215028,215029,215030,215031,215032,215033,215034,215035,215036,215037,215038,215039,215040,215042,215043,215044,215045,215046,215047,215048,215049,215050,215051,216001,216002,216003,216004,216005,216006,216007,216009,216010,216011,216012,216013,216014,216015,216016,216017,216019,216020,216022,216023,216024,216025,216026,216027,216028,216029,216030,216031,216032,216033,216034,216035,216036,216037,216038,216039,216040,216041,216042,216043,216044,216045,216046,216047,216048,216049,216050,216051,216052,216053,216054,216055,216056,216057,216058,216059,216060,216061,216062,217001,217002,217003,217004,217005,217006,217007,217008,217009,217010,217011,217012,217013,217014,217015,217016,217017,217018,217019,217020,217021,217022,217023,217024,217025,217026,217027,217028,217029,217030,217031,217032,217033,217034,217035,217036,218001,218002,218003,218004,218005,218006,218007,218008,218009,218010,218011,218012,218013,219001,219002,219003,219004,219005,219006,219007,219008,220001,220002,220003,220005,220006,220007,220008,220009,220010,220011,220012,220013,220014,220015,220016,220017,220018,221001,221002,221003,221004,221005,221006,221007,221008,221009,221010,221011,221012,221013,221014,221015,221016,221017,221018,221019,221020,221021,221022,221023,221024,221025,221026,221027,221028,221029,221030,221031,221032,221033,221034,221035,221036,221037,221038,221039,221040,221041,221042,221043,221044,221045,221046,221047,221048,221049,221051,221052,221053,221054,221055,222001,223001,223002,223003,223004,223005,224001,224002,224003,224004,224005,224006,224007,224008,224009,224010,224011,224012,224013,224014,224015,224016,224017,224018,224019,224020,224022,224023,224024,224026,224027,224028,224029,224030,224031,224032,224033,224034,224035,224036,224037,224038,224039,224040,224041,224042,224043,224044,224045,224046,224047,224048,224049,224050,224051,224052,224053,224054,224055,224056,224057,224058,224059,224060,224061,224062,224063,224064,224065,224066,224067,225001,225002,225003,225004,225005,225006,225007,225008,225009,225010,225011,225012,225014,225015,225016,225017,225018,226001,226002,226003,231004,234002,234003,245001,246001,247001,247003,247005,248002,248003,248005,248006,248007,250001,250002,251001,252002,253001,255001,258001,258002,258003,259003,262001,263001,265003,265004,265005,265007,265008,265010,267002,268001,271002,272001,273002,278001,279001,280001,281001,282001,282002,282003,283003,285001,285002,286001,290001,290002,290004,290010,290011,290014,290015,290025,290029,292002,296001,297004,297006,297011,299002,299003,300003,300004,300005,300006,303001,303002,303006,303007,303010,303011,303012,306001,307003,307004,307005,307006,307013,308005,308006,308007,310005,310007,311001,312002,313004,314001,316002,317001,319001,319004,319006,322001,322003,322004,322007,322008,322009,322010,322011,322012,322013,322014,322015,322016,322017,322018,322019,322020,322021,323001,324002,325002,326001,327001,334001,335001,336001,337001,339001,341001,341002,343001,343002,345001,345002,346001,346002,347001,348001,353001,356001,359001,360001,367001,368001)
  64. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4f1d8110: select ID,lliOfficeHistoryID,clientDistance,btclDistance,OCDistance,OCID,popID,router_switchID,portID,vlanID,numOfCore,adjustedBTClDistance,adjustedOCDistance,is_deleted,historyID from at_lli_local_loop where lliOfficeHistoryID IN (188001,188005,188006,188007,188008,188009,188010,188013,188014,188017,193001,196001,196002,197002,198001,198002,199002,199003,199004,205002,206001,207001,207002,208001,208002,209001,209002,209003,209004,209005,209006,209007,209008,209009,209010,209011,209012,209013,209014,209015,209016,209017,209018,209019,209020,209021,209022,209023,209024,210001,210002,210003,210004,210005,210006,210007,210008,210009,210010,210011,210012,210013,210014,210015,210016,210017,210018,210019,210020,210021,210022,210023,210024,210025,210026,210027,210028,210029,210030,210031,210032,210033,210034,210035,210036,210037,210038,210039,210040,210041,210042,210043,210044,210045,210046,210047,210048,210049,210050,210051,210052,210053,210054,210055,210056,210057,210058,210059,210060,210061,210062,210063,210064,210065,210066,210067,210068,210069,210070,210071,210072,210073,210074,210075,210076,210077,210078,210079,210080,210081,210082,210083,210084,210085,210086,210087,210088,210089,210090,210091,210092,210093,210094,210095,210096,210097,210098,210099,210100,210101,210102,210103,210104,210105,210106,210107,210108,210109,210110,210111,210112,210113,210114,210115,210116,210117,210118,210119,210120,210121,210122,210123,210124,210125,210126,210127,210128,211001,211002,211003,211004,211005,211006,211007,211008,211009,211010,211011,211012,211013,211014,211015,211016,211017,211018,211019,211020,211021,211022,211023,211024,211025,211026,211027,211028,211029,211030,211031,211032,211033,211034,211035,211036,211037,211038,211039,211040,211041,211042,211043,211044,211045,211046,211047,211048,211049,211050,211051,211052,211053,211054,211055,211056,211057,211058,211059,211060,211061,211062,211063,211064,211065,211066,211067,211068,211069,211070,211071,211072,211073,211074,211075,211076,211077,211078,211079,211080,211081,211082,211083,211084,211085,211086,211087,211088,211089,211090,211091,211092,211093,211094,211095,211096,211097,211098,211099,211100,211101,211102,211103,211104,211105,211106,211107,211108,211109,211110,211111,211112,211113,211114,211115,211116,211117,211118,211119,212001,212002,212003,212004,212005,212006,212007,212008,212009,212010,212011,212012,212013,212014,213001,214001,214002,214003,214004,215001,215002,215003,215004,215005,215006,215007,215008,215009,215010,215011,215012,215013,215014,215015,215016,215017,215018,215019,215020,215021,215022,215023,215024,215025,215026,215027,215028,215029,215030,215031,215032,215033,215034,215035,215036,215037,215038,215039,215040,215041,215042,215043,215044,215045,215046,216001,216002,216003,216004,216005,216006,216007,216008,216009,216010,216011,216012,216013,216014,216015,216016,216017,216018,216019,216020,216021,216022,216023,216024,216025,216026,216027,216028,216029,216030,216031,216032,216033,216034,216035,216036,216037,216038,216039,216040,216041,216042,216043,216044,216045,216046,216047,216048,216049,216050,216051,216052,216053,216054,216055,216056,216057,216058,216059,217001,217002,217003,217004,217005,217006,217007,217008,217009,217010,217011,217012,217013,217014,217015,217016,217017,217018,217019,217020,217021,217022,217023,217024,217025,217026,217027,217028,217029,217030,217031,217032,217033,217034,217035,217036,218001,218002,218003,218004,218005,218006,218007,218008,218009,218010,218011,218012,218013,219001,219002,219003,219004,219005,219006,219007,219008,220001,220002,220003,220004,220005,220006,220007,220008,220009,220010,220011,220012,220013,220014,220015,220016,220017,221001,221002,221003,221004,221005,221006,221007,221008,221009,221010,221011,221012,221013,221014,221015,221016,221017,221018,221019,221020,221021,221022,221023,221024,221025,221026,221027,221028,221029,221030,221031,221032,221033,221034,221035,221036,221037,221038,221039,221040,221041,221042,221043,221044,221045,221046,221047,221048,221049,221051,221052,221053,221054,221055,222001,223001,223002,223003,223004,223005,224001,224002,224003,224004,224005,224006,224007,224008,224009,224010,224011,224012,224013,224014,224015,224016,224017,224018,224019,224020,224021,224022,224023,224024,224025,224026,224027,224028,224029,224030,224031,224032,224033,224034,224035,224036,224037,224038,224039,224040,224041,224042,224043,224044,224045,224046,224047,224048,224049,224050,224051,224052,224053,224054,224055,224056,224057,224058,224059,224060,224061,224062,224063,224064,224065,225001,225002,225003,225004,225005,225006,225007,225008,225009,225010,225011,225012,225014,225015,225016,225017,225018,228006,233001,233002,233006,233012,241002,245002,256002,257003,257004,269001,270003,271001,271003,272003,272004,272005,272006,272007,280001,280002,282001,284001,285001,287001,292001,292002,292003,293003,296001,297001,299004,299005,299007,299009,299010,299011,301002,301003,302002,303001,306001,307003,307004,309003,314001,315001,317001,319005,320002,320003,322001,326001,326002,326004,326010,326011,326014,326015,326025,326029,328002,332001,333005,333009,333020,338001,338002,339004,339005,339006,339007,339008,342004,342013,342017,345001,346002,346003,346004,346005,346006,346007,346008,346016,347008,347009,347010,347011,352008,352010,353001,354002,355005,358001,361005,364001,367001,373004,373008,373009,373010,373011,373012,373013,373014,373015,373016,373017,373018,373019,373020,373021,374002,377002,379001,388001,389001,390001,391001,393001,395001,395002,396001,396002,398001,398002,399001,399002,400001,401001,406001,412001,415001,416001,421001,422001) and is_deleted = 0
  65. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@d0805b0: select invitInvCatTypeID,invitParentItemID,invitName,invitIsChildItem,invitIsUsed,invitIsDeleted,invitLastModificationTime,invitOccupierEntityID,invitOccupierEntityTypeID,invitOccupierClientID,invitID from at_inventory_item where invitInvCatTypeID = 1
  66. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2cd30e8c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 1
  67. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3ad5406a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 1
  68. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@43b2d0c7: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 2
  69. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4ba463b1: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 2
  70. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@61a5303c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 3
  71. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@472dea1c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 3
  72. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1c42bea9: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 4
  73. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7e4c34b8: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 4
  74. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@517c9936: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 5
  75. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5244e4af: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 5
  76. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@29d3f348: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 6
  77. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@62d7d2b: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 6
  78. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@37e0a66f: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 7
  79. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@65bc6c96: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 7
  80. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2cdc6094: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 8
  81. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@ed7dd92: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 8
  82. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@347fefed: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 9
  83. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@427d4e2a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 9
  84. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3524b84e: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 10
  85. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5e809fcf: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 10
  86. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@499921a5: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 11
  87. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4152f404: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 11
  88. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6028567f: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 12
  89. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1e209f96: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 12
  90. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3a1d5fb4: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 13
  91. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4d3027e6: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 13
  92. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2654b1d7: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 14
  93. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@bf5e0fd: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 14
  94. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5b99ff25: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 15
  95. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@f0e0a92: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 15
  96. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@42dc7688: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 16
  97. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5165ce1a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 16
  98. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6049d4a4: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 17
  99. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@31939f77: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 17
  100. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5a854c75: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 18
  101. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@75567ab6: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 18
  102. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4b9c5173: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 19
  103. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4c7c7a41: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 19
  104. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@c85cb9c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 20
  105. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@606d475a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 20
  106. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3f5c04dc: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 21
  107. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1e528bdd: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 21
  108. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@635c95e2: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 22
  109. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7f775c9: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 22
  110. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@74ec2252: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 23
  111. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4da32a09: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 23
  112. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@69b3d0ea: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 24
  113. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7e17614c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 24
  114. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@31281d23: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 25
  115. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@59467254: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 25
  116. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@330ad308: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 26
  117. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3629075a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 26
  118. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@418d02a5: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 27
  119. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5b41e588: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 27
  120. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6c301bf: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 28
  121. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@163f650f: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 28
  122. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3291c71e: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 29
  123. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@28315b30: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 29
  124. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3768db55: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 30
  125. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@aba6d47: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 30
  126. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1a453199: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 31
  127. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@69cbc732: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 31
  128. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@605111e: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 32
  129. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1301570f: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 32
  130. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@712f4c0f: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 33
  131. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6b7f4f45: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 33
  132. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5ed1c481: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 34
  133. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@432f7637: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 34
  134. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6b4f188f: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 35
  135. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@592a9ef2: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 35
  136. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2087f93a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 36
  137. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2a4d258d: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 36
  138. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7eedc572: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 37
  139. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@758e9bda: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 37
  140. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6192482c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 38
  141. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@33323245: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 38
  142. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@17a8e3d8: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 39
  143. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1e9eac96: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 39
  144. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6af66b5d: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 40
  145. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5dad41d5: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 40
  146. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@393aff8a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 41
  147. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5d4dfe33: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 41
  148. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2d560d29: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 42
  149. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@38ec49d7: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 42
  150. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@15e3cca9: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 43
  151. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@51f18afe: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 43
  152. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5f86286e: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 44
  153. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@47742072: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 44
  154. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@24df8116: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 45
  155. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2759ff16: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 45
  156. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1563be7c: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 46
  157. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7de54799: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 46
  158. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5a318e55: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 47
  159. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7d38a2b5: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 47
  160. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@33cde632: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 48
  161. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@167c3205: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 48
  162. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6b5ad454: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 49
  163. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7acd6cc5: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 49
  164. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@22d06181: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 50
  165. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@ade8f5d: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 50
  166. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1bf43d0a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 51
  167. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5d6fe3fb: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 51
  168. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@11cb7f68: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 52
  169. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@3903a950: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 52
  170. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@308c8310: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 53
  171. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@ab1e2b: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 53
  172. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1acbb53e: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 54
  173. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@55ce91d3: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 54
  174. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@5282bf7: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 55
  175. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4d0cf736: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 55
  176. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@23bed123: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 56
  177. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@856eea6: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 56
  178. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@53fad8ba: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 57
  179. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@681cdf8: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 57
  180. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4450709a: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 58
  181. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@1c4606ed: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 58
  182. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@485405d5: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 59
  183. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@770683bc: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 59
  184. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@2be7dd15: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 60
  185. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6fd96345: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 60
  186. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@11cd7bcd: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 61
  187. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@117f481d: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 61
  188. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@577438c1: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 62
  189. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4f7e5261: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 62
  190. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@7d0ee577: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 63
  191. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@324c3d56: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 63
  192. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6046ad99: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 64
  193. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@58982042: select distID,installCost,lastModificationTime,id from at_ofc_install_cost where distID = 64
  194. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6ee0aa1a: select category_ID,registration_charge,downgrade_charge,port_charge,shifting_charge,fiber_charge,cache_service_flat_rate,instant_closing_charge,max_vat_percentage,max_discount_percentage,reconnection_charge,activationDate,lastModificationTime,isDeleted,fixed_ip_count,fixed_ip_charge,variable_ip_charge,ID from at_lli_fixed_cost_config where activationDate <= 1572559654754 and isDeleted = 0 order by activationDate desc limit 1
  195. 2019-11-01 04:07:34 WARN LLIMonthlyBillGenerator:? - cacheFlatRate : 200.0 ; vatRate : 5.0
  196. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@32a23595: select fiberLength,oneTimeCost,fiberCost,createdDate,applicableFrom,id from lli_local_loop_base_charge where applicableFrom <= 1572559654755
  197. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4a7dbb67: select moduleId,registrantTypeId,isDeleted,lastModificationTime,id from at_reg_type_vs_module where moduleId = 7 and registrantTypeId = 1
  198. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@ac748bc: select regTypeInAModuleId,registrantCategoryId,tariffCatId,isDeleted,lastModificationTime,id from at_reg_category_vs_type Where regTypeInAModuleId = 2000 and registrantCategoryId = 8
  199. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@645e97a9: select tblIsDeleted,tblActivationDate,tblModuleID,tblCategoryID,tblLastModificationTime,tblID from at_cost_chart where tblActivationDate<=1572559654756 and tblModuleID = 7 and tblIsDeleted = 0 and tblCategoryID=2 order by tblActivationDate desc limit 1
  200. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@4a3c9bb3: select rwIndex,rwLowerRange,rwUpperRange,rwTableID,rwIsDeleted,rwLastModificationTime,rwID from at_cost_chart_row where rwTableID = 44005 order by rwIndex
  201. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@6b2b43fe: select colIndex,colLowerRange,colUpperRange,colTableID,colIsDeleted,colLastModificationTime,colID from at_cost_chart_col where colTableID = 44005 order by colIndex
  202. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@65dbcffc: select vmnthcrgChargePerMbps,vmnthcrgRowID,vmnthcrgColID,vmnthcrgTableID,vmnthcrgIsDeleted,vmnthcrgLastModificationTime,vmnthcrgID from at_vpn_monthly_charge_cell where vmnthcrgTableID = 44005
  203. 2019-11-01 04:07:34 INFO LLIMonthlyBillGenerator:? - totalMbpsBreakDown : 0.0
  204. 2019-11-01 04:07:34 INFO LLIMonthlyBillGenerator:? - totalMbpsBreakDownForCache : 0.0
  205. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@825cecd: select ID,clientID,contractStartDate,contractEndDate,activeFrom,activeTo,bandwidth,validFrom,validTo,status,historyID from at_lli_longterm_contract where clientID = 556002 and activeTo = 9223372036854775807 and validTo = 9223372036854775807 and status = 1
  206. 2019-11-01 04:07:34 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@59c4edac: select clientId,billId,connectionType,createdDate,lastModifiedDate,activeFrom,bwCharge,bwDiscount,loopCharge,totalDue,vatRate,vat,status,id from at_lli_dn_adjustment where status LIKE 'ACTIVE'
  207. 2019-11-01 04:07:34 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: getMonthlyBillGenerate)=>:0.134274155s******
  208. 2019-11-01 04:07:36 INFO LLIMonthlyBillAction:? - Invoking : class lli.monthlyBill.LLIMonthlyBillAction :: checkIsBillGenerateSearch
  209. 2019-11-01 04:07:36 INFO RecordNavigationManager:? - Record Navigation0
  210. 2019-11-01 04:07:36 INFO DateUtils:? - number of days in month 10 and year 2019 is 30
  211. 2019-11-01 04:07:36 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@67ed9ce1: select clientId,mbpsBreakDownContent,billingRangeBreakDownContent,longTermContractBreakDownContent,mbpsBreakDownForCacheContent,billingRangeBreakDownForCacheContent,createdDate,bill_id,id from at_lli_monthly_bill_summary_client where createdDate >= 1572544800000 and createdDate <= 1575136799999
  212. 2019-11-01 04:07:36 INFO RecordNavigationManager:? - Skipping/ Offset: 0, Limiting: 20
  213. 2019-11-01 04:07:36 INFO AnnotatedRequestMappingAction:? - ******(LLIMonthlyBillAction :: checkIsBillGenerateSearch)=>:0.008136376s******
  214. 2019-11-01 04:07:36 INFO NotificationAction:? - Invoking : class notification.NotificationAction :: getNotificationByRoleId
  215. 2019-11-01 04:07:36 INFO SqlGenerator:? - com.mysql.jdbc.JDBC42PreparedStatement@632c79eb: select generation_time,module_id,entity_id,entity_Type,role_account_id,user_id,description,action_url,is_seen,is_action_taken,has_child,is_for_client,child_id,id from notification where role_account_id = 1 and user_id = 40131 and is_action_taken = 0 order by id desc
  216. 2019-11-01 04:07:36 INFO AnnotatedRequestMappingAction:? - ******(NotificationAction :: getNotificationByRoleId)=>:0.003084215s******
  217. Monthly Bill Not Generated
  218. rn :m_pageSize = 20, m_totalRecords = 846, m_currentPageNo = 1, m_totalPages = 43
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!