This discussion is archived
0 Replies Latest reply: Nov 1, 2012 4:34 AM by 890058 RSS

Web Service Adapter import problem in ETPM

890058 Newbie
Currently Being Moderated
Hi ,
When I tried to import the http://uiappdev3.detr.nv:7090/WebService/iwfCWI.wsdl in Web Service Adapter in ETPM ,After that when i tried to generete the Request Data Area and Response Data Area I am geting the below eroor message, Can anyone suggest me...

This is my http://uiappdev3.detr.nv:7090/WebService/iwfCWI.wsdl

<wsdl:definitions xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://uilink.interfaces.com/iwf/cwi" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:sch="http://uilink.interfaces.com/iwf/cwi" name="" targetNamespace="http://uilink.interfaces.com/iwf/cwi"> <wsdl:types> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cwi="http://uilink.interfaces.com/iwf/cwi" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://uilink.interfaces.com/iwf/cwi"> <xs:element name="cwi-update-request"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="requests" nillable="true" type="cwi:cwiUpdateRequestType"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="cwi-update-response"> <xs:complexType> <xs:sequence> <xs:element minOccurs="0" name="message" type="xs:string"/> <xs:element name="requestStatus" type="cwi:requestStatusType"/> <xs:element maxOccurs="unbounded" name="responses" nillable="true" type="cwi:cwiUpdateResponseType"/> </xs:sequence> </xs:complexType> </xs:element> <xs:complexType name="cwiUpdateRequestType"> <xs:sequence> <xs:element name="userId" type="cwi:writtenUserId"/> <xs:element minOccurs="0" name="processLaunch" type="cwi:processLaunch"/> </xs:sequence> </xs:complexType> <xs:complexType name="cwiUpdateResponseType"> <xs:sequence> <xs:element minOccurs="0" name="message" type="xs:string"/> <xs:element name="requestStatus" type="cwi:requestStatusType"/> </xs:sequence> </xs:complexType> <xs:simpleType name="requestStatusType"> <xs:restriction base="xs:string"> <xs:enumeration value="SUCCESS"/> <xs:enumeration value="ERROR"/> <xs:enumeration value="DUPLICATE_REQUEST"/> <xs:enumeration value="NOT_SENT"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="writtenUserId"> <xs:restriction base="xs:string"> <xs:enumeration value="UINV"/> </xs:restriction> </xs:simpleType> <xs:complexType name="processLaunch"> <xs:sequence> <xs:element name="procTypCd" type="xs:string"/> <xs:element minOccurs="0" name="procItmTypCd" type="xs:string"/> <xs:element minOccurs="0" name="issId" type="xs:long"/> <xs:element maxOccurs="unbounded" minOccurs="0" name="keyFields" type="cwi:commonKeyFields"/> <xs:element maxOccurs="unbounded" minOccurs="0" name="histItems" type="cwi:commonProcessItemsHistory"/> <xs:element maxOccurs="unbounded" minOccurs="0" name="attachements" type="cwi:commonProcessItemsAttachments"/> <xs:element maxOccurs="unbounded" minOccurs="0" name="parties" type="cwi:commonProcessItemsParties"/> </xs:sequence> </xs:complexType> <xs:complexType name="commonKeyFields"> <xs:sequence> <xs:element name="keyFiledCd" type="xs:int"/> <xs:element minOccurs="0" name="keyFiledVal" type="xs:string"/> <xs:element minOccurs="0" name="isRequired" type="xs:boolean"/> </xs:sequence> </xs:complexType> <xs:complexType name="commonProcessItemsHistory"> <xs:sequence> <xs:element minOccurs="0" name="procHistId" type="xs:long"/> <xs:element minOccurs="0" name="actionDate" type="xs:date"/> <xs:element minOccurs="0" name="actionCd" type="xs:string"/> <xs:element minOccurs="0" name="actor" type="xs:string"/> <xs:element minOccurs="0" name="actorName" type="xs:string"/> <xs:element minOccurs="0" name="receiver" type="xs:string"/> <xs:element minOccurs="0" name="receiverName" type="xs:string"/> <xs:element minOccurs="0" name="actionComments" type="xs:string"/> <xs:element minOccurs="0" name="deadlineDate" type="xs:date"/> </xs:sequence> </xs:complexType> <xs:complexType name="commonProcessItemsAttachments"> <xs:sequence> <xs:element name="procAttachId" type="xs:long"/> <xs:element minOccurs="0" name="attachCtgCd" type="xs:string"/> <xs:element minOccurs="0" name="attachItemId" type="xs:long"/> <xs:element minOccurs="0" name="attachItemName" type="xs:string"/> <xs:element minOccurs="0" name="attachItemTypCd" type="xs:string"/> <xs:element minOccurs="0" name="attachedBy" type="xs:string"/> <xs:element minOccurs="0" name="attachReason" type="xs:string"/> <xs:element minOccurs="0" name="actionComments" type="xs:string"/> <xs:element minOccurs="0" name="attachDate" type="xs:date"/> <xs:element minOccurs="0" name="filePath" type="xs:string"/> <xs:element minOccurs="0" name="prtyNm" type="xs:string"/> <xs:element minOccurs="0" name="dueDate" type="xs:string"/> <xs:element minOccurs="0" name="rspndByDt" type="xs:string"/> <xs:element minOccurs="0" name="rspnsRcd" type="xs:string"/> <xs:element minOccurs="0" name="cpmNoticId" type="xs:long"/> <xs:element minOccurs="0" name="cprolcd" type="xs:string"/> </xs:sequence> </xs:complexType> <xs:complexType name="commonProcessItemsParties"> <xs:sequence> <xs:element name="procAssoId" type="xs:long"/> <xs:element minOccurs="0" name="procAssoTypCd" type="xs:string"/> <xs:element minOccurs="0" name="prtyUILinkId" type="xs:long"/> <xs:element minOccurs="0" name="prtyName" type="xs:string"/> <xs:element minOccurs="0" name="prtySSN" type="xs:string"/> <xs:element minOccurs="0" name="prtyAcctNum" type="xs:string"/> <xs:element minOccurs="0" name="prtyFEIN" type="xs:string"/> <xs:element minOccurs="0" name="prtyPhonePrim" type="xs:string"/> <xs:element minOccurs="0" name="prtyPhonePrimExtn" type="xs:date"/> <xs:element minOccurs="0" name="prtyPhoneCel" type="xs:string"/> <xs:element minOccurs="0" name="prtyPhoneCelExtn" type="xs:string"/> <xs:element minOccurs="0" name="prtyFax" type="xs:string"/> <xs:element minOccurs="0" name="prtyEmail" type="xs:string"/> <xs:element minOccurs="0" name="prtyStrtOne" type="xs:string"/> <xs:element minOccurs="0" name="prtyStrtTwo" type="xs:long"/> <xs:element minOccurs="0" name="prtyCty" type="xs:string"/> <xs:element minOccurs="0" name="prtySta" type="xs:string"/> <xs:element minOccurs="0" name="prtyZip" type="xs:string"/> <xs:element minOccurs="0" name="prtyCnt" type="xs:string"/> <xs:element minOccurs="0" name="noteId" type="xs:long"/> <xs:element minOccurs="0" name="createdBy" type="xs:string"/> <xs:element minOccurs="0" name="dateCreated" type="cwi:mixedDate"/> <xs:element minOccurs="0" name="dateModified" type="cwi:mixedDate"/> <xs:element minOccurs="0" name="modifiedBy" type="xs:string"/> <xs:element minOccurs="0" name="noteList" type="cwi:noteList"/> </xs:sequence> </xs:complexType> <xs:simpleType name="mixedDate"> <xs:union memberTypes="cwi:valDate cwi:altDate"/> </xs:simpleType> <xs:simpleType name="valDate"> <xs:restriction base="xs:date"> <xs:minInclusive value="1900-01-01"/> <xs:maxInclusive value="4099-12-31"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="altDate"> <xs:restriction base="xs:string"> <xs:enumeration value="********"/> <xs:enumeration value="00000000"/> <xs:enumeration value="XXXXXXXX"/> <xs:enumeration value="99999999"/> <xs:enumeration value=" "/> </xs:restriction> </xs:simpleType> <xs:complexType name="noteList"> <xs:sequence> <xs:element name="dateCreated" type="cwi:mixedDate"/> <xs:element minOccurs="0" name="dateModified" type="cwi:mixedDate"/> <xs:element minOccurs="0" name="modifiedBy" type="xs:string"/> <xs:element name="noteId" type="xs:long"/> <xs:element minOccurs="0" name="noteSubj" type="xs:string"/> <xs:element minOccurs="0" name="noteTxt" type="xs:string"/> <xs:element minOccurs="0" name="noteUrgent" type="xs:string"/> <xs:element minOccurs="0" name="notypCd" type="xs:string"/> <xs:element minOccurs="0" name="prtyId" type="xs:long"/> <xs:element minOccurs="0" name="funcAreaCd" type="xs:string"/> <xs:element minOccurs="0" name="funcId" type="xs:long"/> </xs:sequence> </xs:complexType> </xs:schema> </wsdl:types> <wsdl:message name="cwi-update-response"> <wsdl:part name="cwi-update-response" element="tns:cwi-update-response"/> </wsdl:message> <wsdl:message name="cwi-update-request"> <wsdl:part name="cwi-update-request" element="tns:cwi-update-request"/> </wsdl:message> <wsdl:portType name="iwfCWI"> <wsdl:operation name="cwi-update"> <wsdl:input name="cwi-update-request" message="tns:cwi-update-request"/> <wsdl:output name="cwi-update-response" message="tns:cwi-update-response"/> </wsdl:operation> </wsdl:portType> <wsdl:binding name="iwfCWISoap11" type="tns:iwfCWI"> <soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document"/> <wsdl:operation name="cwi-update"> <soap:operation soapAction="createWorkItem"/> <wsdl:input> <soap:body use="literal"/> </wsdl:input> <wsdl:output> <soap:body use="literal"/> </wsdl:output> </wsdl:operation> </wsdl:binding> <wsdl:service name="iwfCWIService"> <wsdl:port name="iwfCWISoap11" binding="tns:iwfCWISoap11"> <soap:address location="http://uiappdev3.detr.nv:7090/WebService/iwfCWIService"/> </wsdl:port> </wsdl:service></wsdl:definitions>


I got the below error message

VNAKKANA - 137890-184-1 2012-10-31 23:44:18,928 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (scripting.actions.Action) Executing step: 20: branch ("parm/isRequired = 'true'") goto 30 else 50;
VNAKKANA - 137890-184-1 2012-10-31 23:44:18,928 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (scripting.actions.Action) Executing step: 50: terminate;
VNAKKANA - 137890-185-1 2012-10-31 23:44:19,161 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG (org.hibernate.SQL) select * from ( select scriptprom1_.STEP_SEQ_NUM as col_0_0_, scriptprom1_.SCR_CD as col_1_0_, scriptprom1_.SEQ_NUM as col_2_0_, scriptprom1_.DEFAULT_SW as col_3_0_, scriptprom1_.SORT_SEQ as col_4_0_, scriptprom1_.NEXT_SORT_SEQ as col_5_0_, scriptprom0_.LABEL_LONG as col_6_0_, scriptprom1_.SORT_SEQ as col_7_0_ from CI_SCR_PRMPT_L scriptprom0_ inner join CI_SCR_PRMPT scriptprom1_ on scriptprom0_.SCR_CD=scriptprom1_.SCR_CD and scriptprom0_.STEP_SEQ_NUM=scriptprom1_.STEP_SEQ_NUM and scriptprom0_.SEQ_NUM=scriptprom1_.SEQ_NUM where ((scriptprom1_.SCR_CD=? )and(scriptprom1_.STEP_SEQ_NUM=? ))and(scriptprom0_.LANGUAGE_CD=? ) order by scriptprom1_.SORT_SEQ ) where rownum <= ?
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,020 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (support.schema.AbstractSchemaBasedDispatcher) Performing page:read of BusinessService F1-WsdlToDA' (service='F1-WSDLTODA'), with input request
<?xml version="1.0" encoding="UTF-8"?>

<root xmlns:ora="http://www.oracle.com/tugbu/uimap">

<serviceScript>F1-WsdlToDA</serviceScript>

<webServiceName>CM-UINV-CWI</webServiceName>

<operation>cwi-update</operation>

<requestDAexists/>

<responseDAexists/>

<requestDataAreaName>CM-RQ</requestDataAreaName>
<responseDataAreaName>CM-RS</responseDataAreaName>
</root>

VNAKKANA - 137890-190-1 2012-10-31 23:44:34,021 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (support.schema.AbstractSchemaBasedDispatcher) Converted request to page header:(PageHeader)
actionFlag: null
OPERATION_NAME: cwi-update
REQUEST_DATA_AREA_CD: CM-RQ
RESPONSE_DATA_AREA_CD: CM-RS
WEB_SVC_NAME: CM-UINV-CWI
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,113 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG (org.hibernate.SQL) select maintenanc0_.MAINT_OBJ_CD as col_0_0_ from CI_MD_MO maintenanc0_ where (maintenanc0_.SVC_NAME=? )
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,114 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (support.context.FrameworkSession) Flush requested prior to disabled flush executable
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,115 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (support.context.FrameworkSession) Flush not required, session is not dirty- prior to disabled flush executable
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,119 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG (org.hibernate.SQL) select webservice0_.WEB_SVC_NAME as WEB1_1235_0_, webservice0_.VERSION as VERSION1235_0_, webservice0_.BO_STATUS_CD as BO3_1235_0_, webservice0_.STATUS_UPD_DTTM as STATUS4_1235_0_, webservice0_.WSDL_URL as WSDL5_1235_0_, webservice0_.WSDL_SVC_NAME as WSDL6_1235_0_, webservice0_.WSDL_PORT as WSDL7_1235_0_, webservice0_.URL as URL1235_0_, webservice0_.WSDL_SOURCE as WSDL9_1235_0_, webservice0_.WEB_SVC_SECURITY_TYPE_FLG as WEB10_1235_0_, webservice0_.BO_DATA_AREA as BO11_1235_0_, webservice0_.BUS_OBJ_CD as BUS12_1235_0_ from F1_WEB_SVC webservice0_ where webservice0_.WEB_SVC_NAME=?
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,134 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG (org.hibernate.SQL) select operations0_.WEB_SVC_NAME as WEB1_1_, operations0_.OPERATION_NAME as OPERATION2_1_, operations0_.WEB_SVC_NAME as WEB1_753_0_, operations0_.OPERATION_NAME as OPERATION2_753_0_, operations0_.VERSION as VERSION753_0_, operations0_.WSDL_OPERATION_NAME as WSDL4_753_0_, operations0_.OPERATION_ACTIVE_FLG as OPERATION5_753_0_, operations0_.REQUEST_ELEMENT as REQUEST6_753_0_, operations0_.RESPONSE_ELEMENT as RESPONSE7_753_0_, operations0_.RESPONSE_DATA_AREA_CD as RESPONSE8_753_0_, operations0_.REQUEST_DATA_AREA_CD as REQUEST9_753_0_ from F1_WEB_SVC_OPERATIONS operations0_ where operations0_.WEB_SVC_NAME=? order by operations0_.OPERATION_NAME
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,903 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG (org.hibernate.SQL) select distinct businessob0_.BUS_OBJ_CD as col_0_0_ from F1_BUS_OBJ_OPT businessob0_ where (businessob0_.BUS_OBJ_OPT_FLG=? )and((businessob0_.BUS_OBJ_OPT_VAL=? )or(businessob0_.BUS_OBJ_OPT_VAL=? ))
VNAKKANA - 137890-190-1 2012-10-31 23:44:34,913 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (api.service.ServiceExecutionPolicy) Encountered exception, session marked for rollback
java.lang.NullPointerException
at com.splwg.base.support.schema.wsdl.schema.W3CSchemaToFWMappingSchema.getDataType(W3CSchemaToFWMappingSchema.java:247)
at com.splwg.base.support.schema.wsdl.schema.W3CSchemaToFWMappingSchema.visitSimpleType(W3CSchemaToFWMappingSchema.java:240)
at

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points