VERIFIED SOLUTION i

EngageOne - DeliverDocument WS error "DeliveryOption.name declares a column that is not compatible with the expected type"

Product Feature: web service request

Operating System: AIX 6.1

Aplication Server: Websphere 7.0.0.19

Database: Oracle 12 c 

Issue

 The following issues are faced for all templates when calling deliverDocument() web service:

<faultstring> 
"com.pb.engageone.server.tds.common.entity.DeliveryOption.name" declares a column that is not compatible with the expected type "varchar".
Column details: 
Full Name: TDS_DELIVERYOPTIONS.NAME 
Type: unknown(-9) 
Size: 255 
Default: null 
Not Null: false 
</faultstring>

<faultstring>
Type 
"com.pb.engageone.server.tds.common.entity.DeliveryOption" declares datastore identity column "id", but this column does not exist in table "ENGUSR.TDS_DELIVERYOPTIONS".
</faultstring>

observed on the following environment:

Operating System: AIX 6.1
Aplication Server: Websphere 7.0.0.19
Database: Oracle 10g, Oracle 12 c (driver ojdbc6.jar)


Database’s view Tds_DeliveryOption has Name (type nvchar2) and DeliveryOptionId.
 

Cause

A compatibility problem with Java Database Connectivity driver Oracle12c client and Websphare 7.0.0.19.

Resolution

UPDATED: March 29, 2017
 The ojdbc6.jar under folder /apps/PBBICCM/EngageOne/server/websphere/lib has to be changed.