I have a service operation builder based on SQL Call builder that executes a procedure. I keep getting following error when I run the operation:
Exception Error in method individualDataServiceDefinitionGetPointOfContact_InputPage_NextAction. Error in method individualDataServiceDefinitionGetPointOfContact_ShowResults. Error in method getPointOfContactExecute. Error in method GetPointOfContactSQLCallInvoke. Error in method GetPointOfContactSQLCallInvokeBase. com.bowstreet.builders.webapp.methods.SqlStatementHelper$OutputDefinition incompatible with com.bowstreet.builders.webapp.methods.SqlStatementHelper$InputDefinition
java.lang.ClassCastException: com.bowstreet.builders.webapp.methods.SqlStatementHelper$OutputDefinition incompatible with com.bowstreet.builders.webapp.methods.SqlStatementHelper$InputDefinition
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
I created a schema to map Results. I have run out of options. It seems so simple it should run.
Any Bug in WPF 6.1.5 ? Anything I am doing wrong ? Please suggest.
In SQL Call Parameter Binding is Automatic (Create XML Variable). I have also tried other options.
Preserve automatic binding is true. I have also tried without it.
In operation results, I have specified the schema. Tried with mapping the Result Fields.
Pinned topic Error executing operation on SQL Call (procedure)
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-09-15T18:54:16Z at 2010-09-15T18:54:16Z by DGawron
omsoni 0600020XUD2 Posts
Re: Error executing operation on SQL Call (procedure)2010-09-04T17:39:58ZThis is the accepted answer. This is the accepted answer.ok found out that generated SQL call for procedure was wrong..fixed that but now no data is returned when I run the operation. Since data is returned by the procedure ( when I tested it standalone)..there is something wrong ..
In SQL Call builder I selected Omit Schema Generation. In Service Operation..I provided Input Schema same as generated by SQL Call builder. I created an output schema for Service operation and provided that for Output.
Any help is appreciated.
DGawron 10000054HC251 Posts
Re: Error executing operation on SQL Call (procedure)2010-09-15T18:48:26ZThis is the accepted answer. This is the accepted answer.I seem to recall that there was a bug in 6.1.5 where this would happen. Try installing the 220.127.116.11 fixpack. That should help with the exception. If 18.104.22.168 does not help, then please post a sample model that illustrates the problem and I'll take a look.
DGawron 10000054HC251 Posts
Re: Error executing operation on SQL Call (procedure)2010-09-15T18:54:16ZThis is the accepted answer. This is the accepted answer.
- omsoni 0600020XUD