SQLSTATE[55000] error from Bulk Add Record

Options
Jhon Michael Revilla
edited October 2022 in ? Report a Bug

We encountered this error . we add 2 row record using  Bulk Add Record

this is working yesterday. thank you for your help sir Chris


Error is:



Tagged:

Answers

  • Michael Udinski
    Michael Udinski Administrator

    ADMIN

    Options

    Hi @Jhon Michael Revilla - can you please shoot us a message on the support chat with this and the URL to the function stack?

  • Jhon Michael Revilla
    edited October 2022
    Options


    This Test Data:

    https://xauu-f7yc-ygdu.s2.xano.io/api:GhcgiZX4/CRT_saveEmployee_Bulk_UAT_v2

    Authorization: ****************

    {

      "raw_Data": [

        {

          "FirstName": "Wilma",

          "MiddleName": "Teves",

          "LastName":"Albina",

          "Suffix":"",

          "BirthDate": "1983-08-23",

          "Branch": "Nort",

          "Account_Type": "Easy Savings",

          "TIN": "292075499",

          "EmployeeID": "434679"

        }

      ],

      "company_code": "rrr"

    }

  • Sean Montgomery
    Sean Montgomery Administrator

    ADMIN

    Options

    Hi there,

    It looks like this bug is caused when bulk add records tries to add 0 records.

    I took a look at your logs and I see that your lambda request before the bulk add records is complaining about an error and returning 0 records to be added. Try using run&debug with variable details included and you can see the exact error.