web services pack for datastage 7.5

[aladap12]

Hi All



I have total of 7 jobs that pick up data from webservices and put in my oracle table.
these jobs are running good from past few months.As i said before today we tried to test with bulk data.

My job design is like

webservices client(source)->xml input->transformer->seq file->oracle

out 7 jobs 3 jobs got aborted and remaing got finished with warnings

here i am posting the warning i got from my jobs

please look at these and let me know if you have any idea on this

..TransformFlatToTable: ORA-00001: unique constraint (tablename_PK) violated

and

Fatal error from one more job which is aborted



Event type:Fatal

Message:
jobJs..XML_Input_Mo: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelop ... pException: Server was unable to process request. ---> System.ArgumentException: Column &apos;BaseTable_movrowid&apos; does not belong to table JuvMovements_Data.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at JJCWebService.NJ_Eobcis_JuvMovements..ctor(DataRow myDataRow)
at JJCWebService.eOBCISWebService.GetMovementsData()
--- End of inner exception stack trace ---</faultstring><detail/></ns1:Fault>
at com.ascentialsoftware.wsclient.OperationCall.handleRemoteException(OperationCall.java:369)
at com.ascentialsoftware.wsclient.OperationCall.invoke(OperationCall.java:274)
at com.ascentialsoftware.wsclient.WebService.callServiceInternal(WebService.java:1659)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1566)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1519)
at com.ascentialsoftware.wspack.Transformer.process(Transformer.java:102)
at com.ascentialsoftware.jds.StageFactory.runStage(StageFactory.java:544)
at com.ascentialsoftware.jds.StageFactory.runSource(StageFactory.java:335)


Thanks in advance

[ray.wurlod]

We do not do "urgent" here. DSXchange is an all-volunteer site whose participants post as and when they can.

If you want "urgent" or "immediate" help, sign up with your support provider for premium service and learn the true cost of "urgent".

[chulett]

Reply needed Immediately

Why would that be?

This is extention to my previous post about webservices pack

What post would that be?

[aladap12]

I am extreamly sorry for putting my subject as urgent.

We do not do "urgent" here. DSXchange is an all-volunteer site whose participants post as and when they can.

If you want "urgent" or "immediate" help, sign up with your support provider for premium service and learn the true cost of "urgent".

[aladap12]

I am extreamly sorry for putting my subject as urgent.

We do not do "urgent" here. DSXchange is an all-volunteer site whose participants post as and when they can.

If you want "urgent" or "immediate" help, sign up with your support provider for premium service and learn the true cost of "urgent".