April 20, 2015 at 11:16 am
Hello,
I'm using CozyRoc's SugarCRM Connection manager (and SugarCRM source) for SSIS for the first time. I enter my credentials and the servername:port but when doing a "Test Connection" in the SugarCRM Connection dialog box, I see this error: "The server committed a protocol violation. Section=ResponseStatusLine (System.Web.Services).
The details:
The server committed a protocol violation. Section=ResponseStatusLine (System.Web.Services)
------------------------------
Program Location:
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at CozyRoc.SugarCrm.Service.SugarCrmService.login(user_auth user_auth, String application_name, name_value[] name_value_list)
at CozyRoc.SugarCrm.Connection._Connect()
at CozyRoc.SugarCrm.Connection.Connect()
at CozyRoc.SqlServer.SSIS.SugarCrmConnectionManagerForm.btnTestConnection_Click(Object sender, EventArgs e)
I'm using Visual Studio 2013 SSIS. I haven't written any code. At this point I just dragged the connection manager and the SugarCRM Source into my SSIS package. I googled for this error and read all the items returned from the search (only a page worth) but most don't seem to apply. I did see a suggestion to disable UseUnsafeHeaderParsing.
I haven't found any config files for my installation of CozyRoc, only dlls. Does something need to be installed or configured on the server? I don't have access to that. I just have a username and password.
This seems like a good resource[/url] but I need a little more help because I don't have access to the server to experiment.
Any help with this will be greatly appreciated.
Thanks!
April 20, 2015 at 11:28 am
OK, I'll ask the obvious question. Have you asked Cozyroc, given that it's their product?
-Edit, fixed typo.
April 20, 2015 at 11:42 am
They have a forum I posted to but I don't think I can call until I buy the license. I was surprised to see that a search of their forum returned zero records for SugarCRM. I did post there but the forum doesn't have high activity. I thought I'd post it here because I know SQLServerCentral has a lot of activity though I'm new to posting to the SSIS forum as I'm newish to using SSIS.
I realize my question is narrowly specialized but as we are using the community version of SugarCRM (Apache server/MySQL db) and the error is not specific to CozyRoc, maybe some might have a suggestion.
Thanks for your reply. I will definitely post back when (if?) I have a solution.
April 20, 2015 at 11:49 am
pharmkittie (4/20/2015)
They have a forum I posted to but I don't think I can call until I buy the license. I was surprised to see that a search of their forum returned zero records for SugarCRM. I did post there but the forum doesn't have high activity. I thought I'd post it here because I know SQLServerCentral has a lot of activity though I'm new to posting to the SSIS forum as I'm newish to using SSIS.I realize my question is narrowly specialized but as we are using the community version of SugarCRM (Apache server/MySQL db) and the error is not specific to CozyRoc, maybe some might have a suggestion.
Thanks for your reply. I will definitely post back when (if?) I have a solution.
Fair enough. I am not familiar with the error, but if I were you, I would start modifying the settings in the Cozyroc component and see what happens. HTTP vs HTTPS seems to be a common cause of the error.
April 20, 2015 at 12:26 pm
Thanks. Unfortunately there doesn't seem to be a way to configure anything other than the basic server name, port, username, password, etc. I looked for a config file for the sugarcrm dll but I didn't find one. If I had access to the server I would try the suggestions in the posts I read but I would need to make sure to rule out anything I could do on my end and then present a specific answer to the server gatekeeper on what can be done on the server, else it won't get done.
April 21, 2015 at 9:24 pm
Update: A nice guy from COZYROC (they make the SSIS+ tools that extend SSIS capabilities by allowing connection between SSIS and SugarCRM, SalesforceCRM, provide sftp (SSIS only has ftp), etc.), helped me tremendously so that now I am to the point that I can connect to SugarCRM and create an empty table from SugarCRM(MySQL) in SQL Server via SSIS and COZYROCs Connection Manager and SugarCRM Source (with OLEDB destination to my SQL Server DB).
Unfortunately the solutions I've found from googling advise how to rewrite code to fix SOAP Access Denied error with the assumption that you're trying to connect programmatically.
There are a few parameters to set in the COZYROC Connection Manager and SugarCRM source but no code per se.
I've posted to the SugarCRM forum but I don't know if I'll get an answer as connecting between SugarCRM Community Edition (MySQL) and SQL Server isn't the most common thing to do based on there not being any results when I search SugarCRM's knowledge base.
I'll post again if I ever get it figured out.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply