26-07-2022 17:22:32.571+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"187741"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:23:59.911+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:25:14.193+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:29:03.733+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:29:45.610+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:35:06.188+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:35:56.108+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:38:53.746+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:40:35.168+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:40:35.433+0530 [error] : [500] POST - /v1/invoice Duplicate entry '1413363' for key 'PRIMARY'  
Payload : {"GSTNo":"","discount":0,"gstBillNo":0,"gstType":"","invoiceDate":1658857235000,"nonGstBillNo":7,"totalAfterDiscount":2662,"totalAmount":2662,"totalAmountBeforeGST":2662,"userid":214822,"items":[{"databaseid":1,"gst":0,"gstAmount":1331,"gstType":"CGST/SGST (Local customer)","id":1413363,"imei":"","invoiceid":449896,"isSync":0,"is_active":true,"localInvoiceId":449892,"localid":26,"measurementId":1,"name":"vvsdsde12","price":121,"quantity":11,"serial_no":"","totalAmount":1331,"user":0,"userId":214822},{"databaseid":1,"gst":0,"gstAmount":1331,"gstType":"CGST/SGST (Local customer)","id":1413364,"imei":"","invoiceid":449896,"isSync":0,"is_active":true,"localInvoiceId":449892,"localid":27,"measurementId":1,"name":"wqdqwe","price":121,"quantity":11,"serial_no":"","totalAmount":1331,"user":0,"userId":214822}],"customerid":344868} Error: Duplicate entry '1413363' for key 'PRIMARY'
    at Packet.asError (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/packets/packet.js:708:17)
    at Query.execute (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/commands/command.js:28:26)
    at Connection.handlePacket (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:408:32)
    at PacketParser.Connection.packetParser.p [as onPacket] (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:70:12)
    at PacketParser.executeStart (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.Connection.stream.on.data (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:77:25)
    at Socket.emit (events.js:198:13)
    at Socket.EventEmitter.emit (domain.js:448:20)
    at addChunk (_stream_readable.js:288:12)
    at readableAddChunk (_stream_readable.js:269:11)
    at Socket.Readable.push (_stream_readable.js:224:10)
    at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)



26-07-2022 17:49:43.334+0530 [error] : [500] POST - /v1/invoice Duplicate entry '1413363' for key 'PRIMARY'  
Payload : {"GSTNo":"","discount":0,"gstBillNo":0,"gstType":"","invoiceDate":1658857783000,"nonGstBillNo":7,"totalAfterDiscount":2662,"totalAmount":2662,"totalAmountBeforeGST":2662,"userid":214822,"items":[{"databaseid":1,"gst":0,"gstAmount":1331,"gstType":"CGST/SGST (Local customer)","id":1413363,"imei":"","invoiceid":449897,"isSync":0,"is_active":true,"localInvoiceId":449892,"localid":26,"measurementId":1,"name":"vvsdsde12","price":121,"quantity":11,"serial_no":"","totalAmount":1331,"user":0,"userId":214822},{"databaseid":1,"gst":0,"gstAmount":1331,"gstType":"CGST/SGST (Local customer)","id":1413364,"imei":"","invoiceid":449897,"isSync":0,"is_active":true,"localInvoiceId":449892,"localid":27,"measurementId":1,"name":"wqdqwe","price":121,"quantity":11,"serial_no":"","totalAmount":1331,"user":0,"userId":214822}],"customerid":344868} Error: Duplicate entry '1413363' for key 'PRIMARY'
    at Packet.asError (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/packets/packet.js:708:17)
    at Query.execute (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/commands/command.js:28:26)
    at Connection.handlePacket (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:408:32)
    at PacketParser.Connection.packetParser.p [as onPacket] (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:70:12)
    at PacketParser.executeStart (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.Connection.stream.on.data (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:77:25)
    at Socket.emit (events.js:198:13)
    at Socket.EventEmitter.emit (domain.js:448:20)
    at addChunk (_stream_readable.js:288:12)
    at readableAddChunk (_stream_readable.js:269:11)
    at Socket.Readable.push (_stream_readable.js:224:10)
    at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)



26-07-2022 17:49:43.666+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:50:42.178+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:52:04.575+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:52:21.971+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:52:53.311+0530 [error] : [Incoming]  - /v1/updateinvoice/449897 Make Bill Fail:catch  
Payload : {"nameValuePairs":{"nameValuePairs":{"nameValuePairs":{"customerName":"gsdgsdfsdfdf","customerMobileNo":"4242424214","customerAddress":"","GSTNo":"","userid":"214822","invoiceDate":"2022-07-26","totalAmountBeforeGST":28215,"discount":0,"totalAfterDiscount":28215,"totalAmount":28215,"gstBillNo":0,"nonGstBillNo":7,"gstType":"","items":{"nameValuePairs":{"values":{"values":[{"nameValuePairs":{"nameValuePairs":{"nameValuePairs":{"gst":0,"gstAmount":25553,"gstType":"CGST/SGST (Local customer)","id":-1,"imei":"","invoiceid":449897,"is_active":true,"measurementId":1,"name":"dqd","price":2323,"quantity":11,"serial_no":"","totalAmount":25553}}}}]}}}}}}} 
[org.json.JSONObject.get(JSONObject.java:400), org.json.JSONObject.getJSONArray(JSONObject.java:595), com.billbook.app.activities.BillingNewActivity$13.onResponse(BillingNewActivity.java:1536), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 17:58:47.444+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]



26-07-2022 18:00:26.368+0530 [error] : [Incoming]  - getLastInvoiceNumber org.json.JSONException: Value [0] at gstBillNo of type org.json.JSONArray cannot be converted to int  
Payload : {"nameValuePairs":{"userid":"214822"}} 
[org.json.JSON.typeMismatch(JSON.java:101), org.json.JSONObject.getInt(JSONObject.java:492), com.billbook.app.activities.HomeActivity$8.onResponse(HomeActivity.java:713), retrofit2.ExecutorCallAdapterFactory$ExecutorCallbackCall$1$1.run(ExecutorCallAdapterFactory.java:70), android.os.Handler.handleCallback(Handler.java:938), android.os.Handler.dispatchMessage(Handler.java:99), android.os.Looper.loop(Looper.java:223), android.app.ActivityThread.main(ActivityThread.java:7656), java.lang.reflect.Method.invoke(Native Method), com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592), com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)]