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

[Former Member]

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.

[Former Member · Accepted solution]

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.

[keerthi]

This is to add steps on how to restart the JAVA application with 0 downtime and steps to check the JAVA, HTTP logs.

Refer KBA 2963165 - GST IN: DCS: How to restart java and check logs in SAP Cloud Platform

Refer KBA 2961665 - GST IN: DCS: EDOC_COCKPIT frequent errors (FAQ)