Server error log

Hi all

Recently my prod server show below error log and I have taken two days to find the root reason but didn’t catch the exception and program save the data pipeline when system auto run and happen below error but when I restore the pipeline and debug the pipeline data ,There is no any error in my system.

Anyone have the experience for below error.

Thanks for your help!

2016-05-20 22:58:29 HKT [TNS.0000.2073I] Inserting doc m142bi00aj7apg7v000001se into datastore
2016-05-20 22:58:29 HKT [TNS.0000.2191T] Inserting attributes for doc m142bi00aj7apg7v000001se
2016-05-20 22:58:29 HKT [TNS.0000.3012D] Inserting 1 errors for doc m142bi00aj7apg7v000001se
2016-05-20 22:58:29 HKT [TNS.0000.2010D] Inserting content for doc m142bi00aj7apg7v000001se
2016-05-20 22:58:29 HKT [TNS.0000.2030T] Doc m142bi00aj7apg7v000001se has 7836 bytes of content
2016-05-20 22:58:29 HKT [TNS.0000.3017I] An error occurred trying to insert document (doc id = m142bi00aj7apg7v000001se, sender id = m142bh007nkhsnta000000qf) into the database.
2016-05-20 22:58:29 HKT [ISU.0000.9999W] com.wm.app.tn.db.DatastoreException: Couldnt insert new document
(0) java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed

(1) java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed

2016-05-20 22:58:29 HKT [TNS.0000.2054I] Data for column ActivityLog.FullMessage will not fit. So, truncating it from 12091 characters to 1024 characters.
2016-05-20 22:58:29 HKT [ISU.0000.9999C] com.wm.app.tn.db.DatastoreException: Couldnt insert new document
(0) java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed

(1) java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed

2016-05-20 22:58:29 HKT [ISP.0090.0003I] [EXCEPTION]KLVBO incomming PO at Receiver-com.wm.app.b2b.server.InternalResourceException: Couldnt insert new document (0) java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed (1) java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-01003: no statement parsed

Mandy

Hi Mandy,

please check for the latest TN and SCG-DataDirect-Fixes for your IS-Version.

Eventually you will have to increase the logging level for TN (database layer) to see what gets generated for the statement.

Regards,
Holger

1 Like