Uploading a decision table into BRMS generates "Unexpected packet" exception
Issue
When uploading a decision table to a particular package, we're seeing the following error from Oracle database:
Caused by: java.io.IOException: Retrieving database resource
at org.apache.jackrabbit.core.data.db.DbInputStream.openStream(DbInputStream.java:70)
at org.apache.jackrabbit.core.data.db.DbInputStream.read(DbInputStream.java:110)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:256)
at java.io.BufferedInputStream.read(BufferedInputStream.java:317)
at java.io.FilterInputStream.read(FilterInputStream.java:90)
at jxl.read.biff.File.<init>(File.java:91)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at jxl.Workbook.getWorkbook(Workbook.java:253)
at org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:74)
... 59 more
Caused by: org.apache.jackrabbit.core.data.DataStoreException: Retrieving database resource
at org.apache.jackrabbit.core.data.db.DbDataStore.convert(DbDataStore.java:717)
at org.apache.jackrabbit.core.data.db.DbDataStore.openStream(DbDataStore.java:560)
at org.apache.jackrabbit.core.data.db.DbInputStream.openStream(DbInputStream.java:68)
... 67 more
Caused by: java.io.IOException: IO Error: Unexpected packet
at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:204)
at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:174)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:143)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:132)
at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:1025)
at org.apache.commons.io.IOUtils.copy(IOUtils.java:999)
at org.apache.jackrabbit.core.data.db.TempFileInputStream.writeToFileAndClose(TempFileInputStream.java:52)
at org.apache.jackrabbit.core.data.db.DbDataStore.moveToTempFile(DbDataStore.java:424)
at org.apache.jackrabbit.core.data.db.DbDataStore.openStream(DbDataStore.java:550)
... 68 more
Caused by: java.sql.SQLException: IO Error: Unexpected packet
at oracle.jdbc.driver.T4CConnection.getBytes(T4CConnection.java:2356)
at oracle.sql.BLOB.getBytes(BLOB.java:331)
at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:181)
Environment
- JBoss Enterprise Business Rules Management System (BRMS) - 5.3.0
- Oracle Database 11g
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.