1Exchange Troubleshooting

1Exchange log files are located in DOMAIN_HOME/servers/MSExchange/logs/.

The files MSExchange.log and MSExchange.out usually contain the stack traces when errors occur.

Common Errors

Error

Solution

<bpelFault><faultType>1</faultType><FaultResponse xmlns="http://workflow.ms.onespatial.com/v1/activateJob">

<part name="localFaultPart"><faultMsg xmlns= "http://workflow.ms.onespatial.com/v1/activateJob"> <summary xmlns="">Exchange Extract Features: </summary> <detail xmlns="">java.lang.NullPointerException at com.onespatial.ms.exchange.ctrl.api.nodewrapper. admin.ExchangePolicyNodeWrapper.getSrsName (ExchangePolicyNodeWrapper.java:73)

The 1Exchange policy name was not created.

To do this, open the 1Exchange administrator web interface:

http://[host]:[port]/1exchange/admin/

Schema not configured on gopublisher.xml:

  • weblogic.application.ModuleException: [HTTP:101216]Servlet: "spring" failed to preload on startup in Web application: "/gopublisherwfl"

  • org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbExternalPublishing' defined in class path resource [spring/external-publish.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

  • java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

This may occur during installation or when the server is restarted.

Check that the gopublisher.xml file specifies the correct Oracle schema for GoPublisher workflow in the following line:

<sfa:databaseSchema>GP_WORKFLOW_SCHEMA</sfa:databaseSchema>

GoPublisher product has not been registered (when extracting data):

SEVERE: Unable to create a publisher job for package [User_name] because of {"apiErrorMessage":{"cause":"ProductNotFoundException: Failed to locate a persistent product with name [XXX].","developerDetail": "uk.co.snowflakesoft.workflow.model.ProductNotFoundException: Failed to locate a persistent product with name [XXX]

The GO Publisher product specified in the Exchange policy has not been published.

Could not obtain results from _CONF table: ORA-00904: "null": invalid identifier

In order for a conflict job to successfully go to a prepared state each table name in the GO Publisher project requires a unique key.

To set this within GO Publisher Desktop:

  1. Open the SQL Filters tab.
  2. For each table select Edit on the right-hand side.
  3. Populate the Unique Key column, click OK and then click Save.