Forum Discussion

PSAmmirata's avatar
PSAmmirata
Employee
8 years ago

Oracle Insert Snap - BatchUpdateException: ORA-01438

We’re using Oracle Insert Snap with an Oracle Thin Account. We have the Fetch Size and Batch Size properties of the account set to 5000. We’ve been successfully using the account with this configurat...
Supratim's avatar
Supratim
Contributor III
2 years ago

vgautam64  As I can't copy your json, have created my own, you can use it- 

Data  ==> 

{
    "carList": [
    {
    "color": "purple",
    "type": "minivan",
    "debit_amount": 50,
    "credit_amount": 7
  },
  {
    "color": "red",
    "type": "station wagon",
    "debit_amount": 100,
    "credit_amount": 5
  }, {
    "color": "black",
    "type": "toyota",
    "debit_amount": 200,
    "credit_amount": 5
  },
  {
    "color": "blue",
    "type": "Maruti",
    "debit_amount": 300,
    "credit_amount": 5
  }
]
}
 
1. mapper  : 
$carList.map((val,index)=>{"sum_debit_amount": jsonPath($, "carList[*].debit_amount").reduce((cur,acc)=>cur+acc),"sum_credit_amount" : jsonPath($, "carList[*].credit_amount").reduce((cur,acc)=>cur+acc)}.extend(val)).shift()
vgautam64's avatar
vgautam64
New Contributor III
2 years ago

Hi Supratim,

Thanks for the providing a solution. I tried to validate the expression with the data I have and it seems to work when I validate the pipe. Strangely though, I observe that when I execute (not validate) the pipeline, the mapper that holds the expression only seem to process 50 records and gets stuck processing the 51st doc. But when I validate the pipe I am able to see the preview of 148 documents.

Any idea why this would happen?

  • Ganesh's avatar
    Ganesh
    New Contributor II
    6 years ago

    Hi,
    You can try Array.toString() function if its an array type or use string.replaceAll() function to achieve this.

  • ronmwhite's avatar
    ronmwhite
    New Contributor II
    6 years ago

    It is hard to tell by what has been posted here, but, perhaps you need a JSON Splitter. At the right JSON path, you should get the unique GUID values required downstream. Feel free to ping me if you need any assistance. Thanks.

  • Kulashekharan's avatar
    Kulashekharan
    New Contributor II
    6 years ago

    Use array.join(“,”) or array.toString() to achieve what you asked for. Join will allow you to change the delimiter. Keep in mind This returns one string value