Endeca Install Problem ‘JDBC driver does not support XA, hence cannot be a participant in to-phase c

If like me you’ve downloaded Endeca 3.1 and want to try all the extra goodies that have been added.

One of the first things I wanted to do was try out the Provisioning service and get Endeca to create a new application out of just a simple excel spread-sheet.

It seems that if you have downloaded the Linux install and used the orchestration script sometimes it doesn’t install correctly.

If you get this message ‘ Error while uploading Excel file. Error committing transaction:; nested exception is: javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannot be a participant in two-phase commit. To force this participation, set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source = jdbc/oracle.eid-ps ’

Using that port number we need to logon to WebLogic Server using the id you used in Linux to run the provisioning install. For me it was ‘endeca’.

In the Domain Structure web box click on Services -> Data Sources.

Next Click on the Name jdbc/oracle.eid.ps

click on transaction

Then change the settings here to

Supports Global transactions

AND

Emulate Two-Phase Commit.

After that click Save

You will then need to click on the ‘Control’ tab.

Select the Admin Server and then click on Shutdown and after that click on Start to cycle the data source instances.

If this doesn’t work then It is best to re-start the Endeca Provisioning and Studio domain

Navigate to (your equivalent of) :-

cd /u01/app/endeca_3_1/user_projects/domains/endeca_provisioning_domain/bin

./stopWebLogic.sh

./startWebLogic.sh

Then the Studio domain:-

cd /u01/app/endeca_3_1/user_projects/domains/endeca_studio_domain/bin

./stopWebLogic.sh

./startWebLogic.sh

 

After these domain have started then you should be able to point your Endeca Provisioning to a spreadsheet and load it!