Without looking through the models and transformations, its' hard to say what could be causing the error.
Have you tested the models in Designer? Create a VDB and execute it from the tool to make sure everything's in working order.
I`ve already tested the model with the execute option of the vdb and it works perfectly.
IÂ´m trying other ways to generate the web service. IÂ´m trying to generate the web service directly from the data source model. This has as result a web service that includes the operations to accede the tables of the source model, but when I want to add a new operation, I need to declare some variables and elements in the xsd input file. However, there is no way I can change the DataTypes from string (default) to another data type.
Any idea about this?
Thank you for your attention!
Have you tried editing the xsd file directly (i.e., outside of Designer)?
Yes, I tried, and metamatrix changes the Data Types automatically when I open the project again.
Hmm... You've pretty much exhausted my amount of experience with the Web Service feature in MetaMatrix.
I seriously suggest contacting your MetaMatrix rep. I've found them in my experience to be very responsive to questions and problems.
What does the transformation code look like.
EXEC proc(column1, column2)
SELECT * FROM proc WHERE input1=column1 AND input2=column2.
If it looks like the first example, try the second syntax.
I would also second ndrodri's suggestion on contacting Metamatrix support. Since the source isn't open yet you must have a support agreement in place, and they will be able to address your case directly.