Had a real winner this week, had some stored procs that would run fine in SSMS, but would return error 8152 String or binary data would be truncated when run as a job.
Turns out the table had a field for updated by that was defaulted to suser_name() but was only 20 chars long. The user name the job ran as was almost 40 chars.
Wont say how much time was spent tracking this one down :),
Month: January 2013
Error: The maximum string content length quota (8192) has been exceeded while reading XML data.
Solution: Adjust buffer, message, and string content length in client’s app config or web config.
...
Example using Soap Header username & password
Example of a minimal implementation that includes Soap username and password.
First create the service:
-------------------------- websvc.cs ----------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Services;
using System.Web.Services.Protocols;
namespace wstest
{
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
public class Service1 : System.Web.Services.WebService
{
public ServiceAuthHeader CustomSoapHeader;
[WebMethod]
[SoapHeader("CustomSoapHeader")]
public string HelloWorld()
{
ServiceAuthHeaderValidation.Validate(CustomSoapHeader);
return "Hello World";
}
}
public class ServiceAuthHeader : SoapHeader
{
public string Username;
public string Password;
}
public class ServiceAuthHeaderValidation
{
public static bool Validate(ServiceAuthHeader soapHeader)
{
if (soapHeader == null)
{
throw new NullReferenceException("No soap header was specified.");
}
else if (soapHeader.Username == null || soapHeader.Password == null)
{
throw new NullReferenceException("Username and password are required.");
}
else if (soapHeader.Username != "myuser" || soapHeader.Password != "mypass")
{
throw new NullReferenceException("Provide correct values for username and password.");
}
return true;
}
}
}
-------------------------- websvc.cs ----------------------
Launch the service, create a console app, right click “Service References” and select “Add Service Reference”, paste url to WSDL for web service.
-------------------------- client.cs ----------------------
using System;
using System.Collections.Generic;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
string s;
ServiceReference1.Service1SoapClient svc = new ServiceReference1.Service1SoapClient();
ServiceReference1.ServiceAuthHeader hdr = new ServiceReference1.ServiceAuthHeader();
hdr.Username = "myuser";
hdr.Password = "mypass";
s = svc.HelloWorld(hdr);
Console.WriteLine(s);
}
}
}
-------------------------- client.cs ----------------------