Software

Ask Software Development Questions and Get Answers ASAp

Ask a Computer Expert,
Get an Answer ASAP!

Software

We are getting the following error when trying to send

Customer Question
emails and log them in...
we are getting the following error when trying to send emails and log them in our SQL Server database. The application is written in ColdFusion.
[Macromedia][SQLServer JDBC Driver]Request cannot be submitted due to wire contention.
This message appears after over 1000+ emails are sent and logged, then all of the remaining attempts result in this message.
Submitted: 1 year ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Answered in 1 hour by:
10/8/2016
Software technician: Andrew James, Senior Systems Engineer replied 1 year ago
Andrew James
Andrew James, Senior Systems Engineer
Category: Software
Satisfied Customers: 11
Experience: RedHat certified. Ansible & Salt Ninja. Professional background running the automation platform for a major internet firm
Verified

Hello,

This is usually caused by the JDBC Driver having a buffer set too low, or not to 'unlimited/0'. Basically, what you are seeing (and i'm guessing you're sending large amounts of mail at once) is that the process rolling through your queue, and after it hits so many (somewhere in the 1000+ range) you are hitting the buffer limit. I'd need a full stacktrace around the time it starts failing from the process to give you a more exact cause. But I can tell you just from the error and how you describe it happening its resource contention, whether its literally your script is eating up everything server side, (but i'd expect an OOM and it sounds like your script keeps going just fails to connect) or its limitations in the drivers configurations.

Take a look at InsensitiveResultSetBufferSize https://docs.oracle.com/cd/E13157_01/wlevs/docs30/jdbc_drivers/mssqlserver.html which is where I expect you are having this problem. Usually this gets set to a low number, increasing it or setting it to 0 usually helps with wire contention issues.

Let me know if that helps or if you've already tried that direction. If you can get a full stack trace if that doesn't help, I may be able to see more

Ask Your Own Software Question
Software technician: Andrew James, Senior Systems Engineer replied 1 year ago

Hey,

I'm going to drop you back into the queue for someone else hopefully figure out what's missed.

I apologize, I missed that you were loading the macromedia driver and not the oracle driver. While all java, you are correct they are different. I do expect the issue you are having is similar between the two, but I expect, like with the oracle driver, this is not something you can modify through the administrator panel.

I looked over the strace for a bit, but I couldn't find anything that said "this is surely the fault, blame this". So hopefully another expert will.

Ask Your Own Software Question
Software technician: swmcdonnell, Computer Scientist replied 1 year ago
swmcdonnell
swmcdonnell, Computer Scientist
Category: Software
Satisfied Customers: 292
Experience: Steve has many years of experience in software development.
Verified

Hi there, my name is***** few things:

  1. Can you post the code in the application where it's connecting to the database?
  2. Can you tell me exactly what it's logging to the database? I want to get a sense of whether it's logging the entire email vs. just one log line per email.
  3. Did this suddenly start happening, i.e. was it working fine and all of a sudden it stopped working? If so, what changes did you make to the SQL Server database or the application, if any?
Ask Your Own Software Question
Customer reply replied 1 year ago
1.Can you post the code in the application where it's connecting to the database?
THE CONNECTIONTO THE DATABASE IS DONE VIA A STORED PROCEDURE CALL: <cfstoredproc datasource="#Application.datasource#" procedure="getMktgMessageMyContact">2. Can you tell me exactly what it's logging to the database? I want to get a sense of whether it's logging the entire email vs. just one log line per email.
IT IS GENERATING A NEW RECORD IN THE SENT TABLE FOR EACH EMAIL SENT (AS THEY ARE SENT, NOT IN A GROUP)3. Did this suddenly start happening, i.e. was it working fine and all of a sudden it stopped working? If so, what changes did you make to the SQL Server database or the application, if any?
WE HAD TO REBUILD OUR SERVER FROM A BACKUP BECAUSE OUR PREVIOUS SERVER WAS TERMINATED SO WE CANNOT SEE WHAT IS DIFFERENT.
Software technician: swmcdonnell, Computer Scientist replied 1 year ago

OK, so it was working OK and then you replaced the server, so it's most likely a setting on the server side. When you say it's generating a new record in the Sent table, what does it store? The entire email or just a little log information that it was sent?

Ask Your Own Software Question
Software technician: swmcdonnell, Computer Scientist replied 1 year ago

Have you checked the SQL Server logs? What do they say?

Ask Your Own Software Question
Customer reply replied 1 year ago
No errors appear in the SQL Server logs.
Software technician: swmcdonnell, Computer Scientist replied 1 year ago

You haven't told me yet how much data it's storinig about each email it sends.

Can you give me the code in the stored procedure for connecting to the database?

Ask Your Own Software Question
Customer reply replied 1 year ago
It stores the html version of the email and identifiers of the message and recipient as well as dates.
Software technician: swmcdonnell, Computer Scientist replied 1 year ago

Thank you. And the connection code?

Ask Your Own Software Question
Customer reply replied 1 year ago
There is no code in the stored procedure for connecting to the database since the stored procedure RESIDES in the database.
Software technician: swmcdonnell, Computer Scientist replied 1 year ago

Right. Sorry, since it already existed I thought you might have a copy of it somewhere, since the issue is connecting to the database and not recovering or rebuilding its contents.

Ask Your Own Software Question
Ask swmcdonnell Your Own Question
swmcdonnell
swmcdonnell
swmcdonnell, Computer Scientist
Category: Software
Satisfied Customers: 292
292 Satisfied Customers
Experience: Steve has many years of experience in software development.

swmcdonnell is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

670 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

505 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Jins M. N.

Computer Hardware Engineer

463 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

456 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

164 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
My Facebook and I messenger has been hacked what do I need
My Facebook and I messenger has been hacked what do I need to do to fix this? … read more
Kris R
Kris R
IT Manager
Computing
2,648 satisfied customers
Office ribbon question: in some installations, some of the
office ribbon question: in some installations, some of the items do not show up, although when trying to customize the ribbon they appear listed as available … read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
I keep getting NGStudio has stopped working while trying to
I keep getting NGStudio has stopped working while trying to edit my movie in pinnicle17 … read more
Kris R
Kris R
IT Manager
Computing
2,648 satisfied customers
I bought a new laptop and installed Photoshop CS-4 on it.
I bought a new laptop and installed Photoshop CS-4 on it. The menus are all micro sized and are super difficult to navigate. Can you help me? … read more
Bryan
Bryan
IT Consultant
8,751 satisfied customers
I suddenly cant open email attachments on AOL. Earlier
Earlier yesterday I believe. First experience of the problem was yesterday and again today … read more
Kamil Anwar
Kamil Anwar
Software Specialist
Bachelor's Degree
456 satisfied customers
I am running Mac High Sierra 10,13,2. I have Bento version
I am running Mac High Sierra 10,13,2. I have Bento version 4.1.2. I am not able to get my Bento data printed. Even though I have selected/highlighted all the data the only thing that shows up when I t… read more
Kris R
Kris R
IT Manager
Computing
2,648 satisfied customers
How can I save a shared google album as a jpeg or pdf? The
How can I save a shared google album as a jpeg or pdf ? The preference would be to safe each picture as separate jpeg pictures.… read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
How do I recover W10 deleted files? Dell Optiplex PC. W10.
Few minutes. Looked for file history and Carbonite backup. … read more
caraleneK
caraleneK
Service Manager
1,676 satisfied customers
Ineed recovery disk for my Dell Inspiron 11 3000 series.
Ineed recovery disk for my Dell Inspiron 11 3000 series. Service Tag No. DLFJ3C2. eXPRESS SERVICE CODE*********** … read more
caraleneK
caraleneK
Service Manager
1,676 satisfied customers
I'm trying to buy a movie and it is giving me the run around
I'm trying to buy a movie and it is giving me the run around can I have a phone # to talk to a human? … read more
Kris R
Kris R
IT Manager
Computing
2,648 satisfied customers
My eld says I'm unauthenticated and can't sign in. The main
The main screen to log in I got a new phone which is the same as my old one but I can't sign in … read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
Help to install installation of Mcafee Livesafe. McAfee All.
Help to install installation of Mcafee Livesafe. JA: Which McAfee product do you have? Customer: McAfee All JA: What have you tried so far with your McAfee software? Customer: Need to enter product ke… read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
Purchased a subscription to ancestry.com this morning. When
Purchased a subscription to ancestry.com this morning. When I click on see details I get a page of maps wanting me to subscribe---can't get past this. … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,124 satisfied customers
My files have disappeared. Can you help. HP 620, Windows 7
Did have Microsoft 365 until last Friday 1/12/18, and all files have disappeared. Tried a restore to last Friday, but no files. … read more
Martin
Martin
Network Engineering Diploma
141 satisfied customers
I can't remember my username. Dell 1505 inspirion windows 7.
yes, I sent the request to turbo tax and they sent back some thing with a lot of *******10 I cannot remember what the ********* 10 is… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
My Sibelius5 freezes while entering notes. so that nothing
My Sibelius5 freezes while entering notes. so that nothing works. How to solve? Thanks for help. Alan Wingard Appleton, Maine.… read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
I purchased the anti-virus software earlier today. Order #
I purchased the anti-virus software earlier today. Order #*********** the screens came up to load it which I did. It did not ask for pass words or activation code. but seemed to load OK. As I was runn… read more
Mr.Med
Mr.Med
942 satisfied customers
I believe we have the new gen 5 ready, but not sure how to
I believe we have the new gen 5 ready, but not sure how to put the old password ***** … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,124 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x