Skip to Content

Error 'INVOICE-P-100' when submitting invoice from EDOC_COCKPIT (ECC) to DCS (HANA Cloud).

Hi,

We have a system set up here for pushing Invoices from ECC using transaction 'EDOC_COCKPIT' to the Digital Compliance Service (DCS on HANA Cloud). I'm getting the following error when posting invoice.

"errorcode":"INVOICE-P-100","errormsg":"Could not commit JPA transaction

As far I debugged, I can see that data is getting pushed out of ECC successfully. But when it tries to insert this data on the cloud DB's table GSTR1_INV_HEADER, it fails and gives the above error, which I got from the log. I'm a newbie for HANA Cloud cockpit and not able to understand the error, or sure about ways that exist to analyse it either.

I'm attaching the complete log below:

{"status":"ERROR","error":{"b2berror":[{"errors":[{"errorcode":"INVOICE-P-100","errormsg":"Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql.SQLException: Borrow prepareStatement from pool failed\nError Code: 0\nCall: INSERT INTO \"sap.slh.dcs.gstr1.table::GSTR1_INV_HEADER\" (INV_TYPE, SUPP_GSTIN, FIN_PERIOD, INV_NUM, AUTH_OBJECT, CANC_FLAG, CHECKSUM, CREATED_AT, CREATED_BY, CR_DR_REASON_CODE, CURRENCY, CUST_GSTIN, CUST_NAME, DCS_INVHDR_EXT_FIELD1, DCS_INVHDR_EXT_FIELD2, DCS_INVHDR_EXT_FIELD3, DCS_INVHDR_EXT_FIELD4, DCS_INVHDR_EXT_FIELD5, DCS_INVHDR_EXT_FIELD6, ECOM_CUST_GSTIN, ECOM_MERCHANT_ID, ERROR_FLAG, EXP_INV_TYPE, FILING_SRC, IN_PROCESS_FLAG, INV_AMT, INV_COMM_STATUS, INV_DATE, INV_FLAG, NIL_INV_TYPE, NR_NUMBER, NR_PREFIX, NR_SUFFIX, ON_HOLD_FLAG, POS, PROV_ORD_DATE, PROV_ORD_NUM, RCVR_STATE, REF_INV_DATE, REF_INV_DATE_2, REF_INV_NUM, REF_INV_NUM_2, REVERSE_CHARGE, SHIP_PORT_CODE, SUPP_STATE, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n\tbind => [46 parameters bound]\nQuery: InsertObjectQuery(SUPP_GSTIN:24AAFCG4699H1ZAFIN_PERIOD:042018INV_NUM:6183400038INV_TYPE:B2B)"}]}],"b2cerror":[],"experror":[],"aterror":[],"cdnerror":[],"txpderror":[]}}

Help me to understand/solve/debug the error.

Thank You,

Ilakkia.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 08 at 12:44 PM

    Hi,

    The issue is solved. We had to get in touch with SAP.

    The following was the reply we got from the team in response to this issue.

    "As per the error messages. It’s DU error. Please update the latest DU then JAVA Artifacts and last UI MTAR. After that please restart the Java application".

    Replying so that anybody else may find it useful.

    Ilakkia.

    Add comment
    10|10000 characters needed characters exceeded