question

Sakthivel avatar image
Sakthivel asked

Pattern match policy error in sql server

Hi All, We have Asp .net application with SQL server 2008 R2 server environment then the process is sending the xml attached file into testing server environment through some services.From that point we will sending the request (xml attache file) and getting the response file from the testing server then the error is we will processing 10 no.of attached xml file and getting 6 response file rest of them indicates some error.We don't know the error is based on Sql server or Application server or else firewall,So kindly give me the suggestion if know that issues then the error is **IDP Rule 'MeF_PatternHit' aborted processing** **Pattern match policy violation: Pattern match policy 'SQL_KWFull' matched text '";' of Attachment XML Element Content '#text' using pattern '[\x2F][\x2A]|(?i)['"]\s*((Insert)|(Not)|(And)|(Or)|(Union)|(Select)|(Delete)|(Distinct)|(Having)|(Truncate)|(Replace)|(Handler)|(Like)|(Procedure)|(Limit)|(Drop)|(Dual)|(Create)|(Alter)|(;))|(?i)['"]\s*;' Submission Id= 1234567894 ********* System.Web.Services.Protocols.SoapException: IDP Rule 'MeF_PatternHit' aborted processing. Pattern match policy violation: Pattern match policy 'SQL_KWFull' matched text '";' of Attachment XML Element Content '#text' using pattern '[\x2F][\x2A]|(?i)['"]\s*((Insert)|(Not)|(And)|(Or)|(Union)|(Select)|(Delete)|(Distinct)|(Having)|(Truncate)|(Replace)|(Handler)|(Like)|(Procedure)|(Limit)|(Drop)|(Dual)|(Create)|(Alter)|(;))|(?i)['"]\s*;' at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at TTI.Excise.SenderChannel.MeFTransmitterServicesMTOM.SendSubmissions.CallSendSubmissions(SendSubmissionsRequestType SendSubmissionsRequest) at TTI.Excise.SenderChannel.IRSSender.Submit(DataRow dr)
sql server 2008 r2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
It appears that you are hitting an Intrusion Detection and Prevention (IDP) appliance. This is similar to a firewall and is rejecting your XML file based on the rule you posted which appears to prevent SQL from being submitted to the web service port.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sakthivel avatar image Sakthivel commented ·
Hi Ken, Thanks for your valuable response.I'll check and get back to you shortly.
0 Likes 0 ·
smilenjonn avatar image
smilenjonn answered
Hi Sakthivel, I am facing same error which you have posted above. Could you please let me know how this errror was resolved. Please send your response to smilenjonn@gmail.com
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.