Error: Data overflow, Connector 'oledb', Method -Execute-

HCL Domino Domino Forum
1

Hi All,

I have a Domino Application that writes data back to SQL database. The application has been running fine since one year. Since this week the application is not able to write data to the SQL database.

I get below error:

Error: Data overflow, Connector ‘oledb’, Method -Execute-

However i am able to execute the same query through SQL query analyzer or by executing the query thrugh a local agent.

Calling the same agent on the server results in the same error. Not even a simple insert query is sucessfull now.

There has been no change in code.

I found out the a new OS patch has been applied on Domino servers lately.

http://www.microsoft.com/technet/security/bulletin/ms08-may.mspx

Can you please help.

Thanks,

Abhishek

2

Subject: Error: Data overflow, Connector ‘oledb’, Method -Execute-

could you post the query?

And is the result bigger than it used to be?

Have you checked whether the patch can indeed cause this tohappen?

3

Subject: RE: Error: Data overflow, Connector ‘oledb’, Method -Execute-

Marjan,Even the simple Insert query is failing now

Here is my test code :

lcCon.Provider=“SQLOLEDB”

lcCon.Server=gConServer

lcCon.database=gConDb

lcCon.Userid=gConUsr

lcCon.Password=gConPw

lcCon.Metadata=“tmpSurv”

lcCon.Disconnect

lcSess.ClearStatus

lcCon.Connect

SrvyStr = “04-KM-1001”

valih_report_nbr = “R-2008-015MKX10-7EMQC7-v01”

SQLQuery =“INSERT INTO tmpSurv (srvy_nbr, ih_report_nbr) VALUES ('” + SrvyStr + “‘,’” + Trim$(valih_report_nbr) + “')”

data=lcCon.execute(SQLQuery,Nothing)

lcCon.disConnect

I am following up the IT Operations to check on the patch details.

Any help on this is greatly appreciated.

4

Subject: RE: Error: Data overflow, Connector ‘oledb’, Method -Execute-

Its sounds like one of your values is to large for the width of the column in the relational store. Put your SQLquery contents into a SQL command line client(outside of notes fully) and see if works where the code runs. So if a scheduled agent run the SQL command line client on your Domino server.

5

Subject: RE: Error: Data overflow, Connector ‘oledb’, Method -Execute-

Rami, The same query works fine though SQL Query analyzer on my machine. It only fails when running on Notes server…now i have started getting the error

ConnectionOpen (Connect()).]SQL Server does not exist

The server,port number and access is all right…

Thanks,

Abhi

6

Subject: Error: Data overflow, Connector ‘oledb’, Method -Execute (PROBLEM SOLVED)

The problem was on the SQL database side. The SQL server Admin was able to trace that a trigger was being fired when data was updated in a particular table.I asked the SQL developer who had added the trigger last week to do error handling for the data entered (trigger was capturing hostname and in this case it was servername and was more than 8 characters) though Domino server(through LSX LC).