jomalladi
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Splitting JSON Array To multiple Fixed width items
Hello all, I have a request where we have a JSON array and we would need to split them up as multiple fixed width items. The output should be a file for each json array → multiple lines of fixed width items separated by new lines. Input : [ { “group”: [ { “Matter”: “xxxxxx.xxxxx”, “Timekeeper”: “”, “CostCode”: “C”, “Quantity”: “1.0000”, “Rate”: “800.00”, “LineItemTotal”: “800.00”, “CostLocation”: “”, “TimekeeperNotUsed”: “”, “UnUsed”: “”, “VoucherType”: “”, “Company”: “”, “Currency”: “USD”, “VendorCode”: “4567890”, “VendorInvoiceNumber”: “4567890024”, “InvoiceDate”: “2018-11-30”, “InvoiceAmount”: “800.00”, “ReferenceNumber”: “”, “GLNumber”: “”, “GLDepartment”: “”, “TaxAmount1”: “”, “TaxAmount2”: “”, “VoucherType3”: “”, “TaxCode”: “”, “TransactionDate”: “022019” } ] } ] output : FileSamplePipeline_2019_02_20 (1).slp (27.2 KB) 022019xxxxxx.xxxxx C 1.0000 800.00 800.00 45678904567890024 2018-11-30800.00 The output of the first example in the samplePipeline gives me a file will give a file without a new line between the items. The second example I am not sure on how to merge the line items after the Fixed width formatter. Can you please help me out? Also, let me know if you need more information. Appreciate all your help! Thank you, Jyotsna2.7KViews0likes0CommentsSQL Server - Update deadlock issue
Hello All, I am getting transaction deadlocked errors while Updating the records. The snap being used here is SQL Server Update. Transaction (Process ID 92) was deadlocked on lock resources with another process and has been chosen as the deadlock victim Stack Trace : java.sql.BatchUpdateException: Transaction (Process ID 92) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1740) at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:116) at com.zaxxer.hikari.proxy.StatementJavassistProxy.executeBatch(StatementJavassistProxy.java) at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:93) at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:93) at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:106) at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:78) at com.snaplogic.snap.api.sql.operations.JdbcOperationsImpl.flushBatch(JdbcOperationsImpl.java:1222) at com.snaplogic.snap.api.sql.operations.JdbcOperationsImpl.update(JdbcOperationsImpl.java:795) at com.snaplogic.snaps.sql.SimpleSqlUpdateSnap.processData(SimpleSqlUpdateSnap.java:130) at com.snaplogic.snaps.sql.SimpleSqlWriteSnap.processDocument(SimpleSqlWriteSnap.java:84) at com.snaplogic.snaps.sql.SimpleSqlSnap.process(SimpleSqlSnap.java:254) at com.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:88) at com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:100) at com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:68) at com.snaplogic.snap.api.SimpleSnap.execute(SimpleSnap.java:66) at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:709) at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:489) at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:770) at com.snaplogic.cc.snap.common.SnapRunnableImpl.access$000(SnapRunnableImpl.java:108) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:335) at com.snaplogic.cc.snap.common.SnapRunnableImpl$1.run(SnapRunnableImpl.java:331) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Unknown Source) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:330) at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:108) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Can you please let me know if you have any ideas on how to deal with this? Thank you!4.2KViews0likes2Comments