NW 7.3 JTA Issue

[Former Member]

Hi.

I have NW CE 7.3, and my application runs fine on 7.1 and 7.1 EHP1.

However, in 7.3, I am getting issues with transactions.... and they seem to be SAP DB related.

We are then also getting distributed transaction lockups from an external Oracle DB, but im not sure whether this is the root cause or not!

Exception of type com.sap.sql.log.OpenSQLException caught: Failed to set the parameter 5 of the statement >>INSERT INTO BC_JTA_RM_PROPS ( RM_ID, TLOG_ID, PROPERTY_TYPE, PROPERTY_NAME, PROPERTY_VALUE ) VALUES ( ?, ?, ?, ?, ? )<<: Cannot assign a zero-length byte array to a parameter with JDBC type >>LONGVARBINARY<<..

Anyone care to shed any light on this one?

Many thanks.

Andrew

[Former Member]

Hi, all:

  We have recently updated to NW 7.3 from NWCE 7.1 and we are facing the same problem.

  Any solution?

Thanks,

Fran

[Former Member]

Dear Fran

Please apply below changes:

Open config tool (\usr\sap\<SID>\JXX\j2ee\configtool\configtool.bat) and navigate to

cluster_data -> instanceX -> services -> ts

and set parameter "EnableTransactionLogging=FALSE".

Save the change (no restart is needed for applying this change.)

After applying this change the issue should not occur anymore.

Thanks

Tapan