Sql Error message: servers

Showing posts with label servers. Show all posts

Tuesday, March 27, 2012

Error pulling unicode data from DB2 Linked Server

Greetings,

We have been Selecting data from A DB2 AS400 via Linked Servers in SQL 7.

We began to pull data from new intstance/tables that contain some fields with foreign characters. (double byte, unicode) Some data will pull fine, then we will get an error:

Unexpected NULL value returned for column '[MYLINKEDSERVER].[DB2NAME1].[DB2NAME2].[MYTABLENAME].DESC2' from the OLE DB provider 'MSDASQL'. This column cannot be NULL.

The DBA from the other country tells me that the field is never null.

KB article Q239458 seemed related but doesn't help. We are running SP4, and will be trying on SP3 soon.

Is there any way to turn off this checking for NULL? My guess is that it interprets the unicode as a NULL incorrectly. I've tried to explicitly cast into varchar(30.)

Sometimes this fields is readable in English and it contains data that is critical when we can see it.

Thanks In Advance,
MikeyrowThe Work-Around developed was to use a pass-thru query to the DB2. I used a NULLIF function to replace any nulls, and that prevented the OLE-DB layer from erroring and failing.

Ideally we would want the DBA in the other country to fix this themselves, but sometimes time won't allow the cogs to churn enough to get the ideal solution developed.

Mike Rowland

Friday, March 23, 2012

Error on Stored Procedure

I need to perform a select statement across servers... this statement works in query analyzer but not as a procedure. It tells me I need to enable the ANSI_NULLS and ANSI_WARNINGS options when put into a procedure (which it looks like i did!) I think it has something to do with this GO as the stored procedure isn't recognizing it. I tried even building it as a string and executing. Any ideas as to enable this in a procedure?

CREATE PROCEDURE TESTING AS
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
SELECT * FROM MIDSERV.DB000.dbo.tblcustomer
select * from #tableTake out GO statements after SET and re-run the SP.|||Originally posted by Satya
Take out GO statements after SET and re-run the SP.

CREATE PROCEDURE TESTING AS
SET ANSI_NULLS ON

SET ANSI_WARNINGS ON

SELECT * FROM MIDSERV.DB000.dbo.tblcustomer

I get the same error telling me to enable ansi_nulls and ansi_warnings...|||Aren't the ANSI_NULL and ANSI_WARNING options to has to be set at connection level?

i belive (thought not so sure) that you cannot use it inside a stored procedure, you just have to call it BEFORE you call your stored procedure.|||that is a GOOD CALL!!!!!!!!!!!

You wouldn't know how about to set those at connection level would you? I tried doing it in a job scheduled in EM and it didn't work too well

First transact-sql statement in job:
set ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO

Second transact-sql statement in job
exec procedure1

also tried combining
set ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO|||mmm...do have already tried to remove the "GO" statement?

to set an option at connection level you just have to call it BEFORE anything else you want to execute with that options activated.

now i cannot try, but i'll make a test as soon as i get a SQL Server console under my hand :-)sql

Error on setting ip partners : servers not found

Hello,

I have un problem with the mirroring, when I set the IP of the partners, I get an error saying that the server will not exists or it's impossible to join it. I try to make a mirroring without witness between two servers.

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

Msg1418, Niveau16, tat1, Ligne1
L'adresse reseau du serveur "TCP://192.168.1.71:5050" est impossible à atteindre ou elle n'existe pas. Verifiez le nom de l'adresse reseau et executez la commande de nouveau.

And it's the same problem with the second server.

I work with the sql server evaluation (I put the parameter T 1400 for). Endpoints are created (I get them with a select on systcp_endpoints) :
Mirroring 65541 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

Thanks for helping.

ps : Excuse my english ^^

The problem might be Fully Qualified Domain Name (FQDN).........try specifying as shown below,

To start database mirroring, you next specify the partners and witness. You need database owner permissions to start and administer a given database mirroring session. On server A, the intended principal server, you tell SQL Server to give a particular database the principal role and what its partner (mirror) server is :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://B.corp.mycompany.com:5022'

The partner name must be the fully qualified computer name of the partner. Finding fully qualified names can be a challenge, but the Configure Database Mirroring Security Wizard will find them automatically when establishing endpoints.
The fully qualified computer name of each server can also be found running the following from the command prompt :

IPCONFIG /ALL
Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:
Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':' and you then have the partner name.
On the mirror server, you would just repeat the same command, but with the principal server named :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://A.corp.mycompany.com:5022'

On the principal server, you next specify the witness server:

ALTER DATABASE [AdventureWorks] SET WITNESS =
N'TCP://W.corp.mycompany.com:5026'
|||Thanks for you answer.

So we can't use IP to connect servers ? I thought the contrary...

I start to work with domain, I set same domain for each server, but I have another problem, the mirror server is OK (It takes the ALTER TABLE), but I can't set the PARTNER to master, I get the same error as before, and I don't understand why.

Thanks for help |||Arnard can you pls explain it a little more ? is database mirroring configured and workiong well ? do you mean to say that you can't set the "alter database set partner" for principal ?
|||Yes, when i do the command :

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

And I don't understand why master does't find slave, in contrary of slave that find master.
|||May be can you try giving someother end point listening port instead of 5050 you've mentioned above !
|||Result of sys.tcp_endpoints on srv-bat2 :

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

I don't understand why I can't make the mirroring -_-
|||Arnard,
I have configured mirroring in sql 2005 evaluation edition pls refer the link,
http://sql-articles.com/articles/dbmrr.htm
i don't know if it will solve your problem but just have a glance through it Smile

Thanxx
Deepak
|||Thanks for your link, but I already saw this website.

Howewer, when I used the GUI to create the mirror, on the master server the path selected by sql server is <host>.<domain>:<port>, but on the slave server, I have <host>:<port>. And when I tried to start mirroring, I get the same error saying that the second server is not found

I have switch between the two servers and I get the same result. Do I need to configure another thing anywhere ? the fact that the slave server's path is <host>:<port> instead of <host>.<domain>:<port> means that there is a bug on configuration, but I can't say what and where.

Thanks fr your help ^^
|||Must I create a new login such this pattern : CREATE LOGIN <domain\\login> FROM WINDOWS ?
When You create your instance of SQL Server, what do you set for account to run service ? Local System ? Network System ? domain ? Is this element important or interessant in my problem ? thx
|||Actually in the link i gave above i've created 3 instances of sql server in my local PC and all 3 run under local system account Smile but in real time environment you need to make use of a domain id (preferably) for the sql service account in all 3 principal,mirror and witness servers

Thanxx
Deepak

|||I've tried with the elment domain, I set the login of my administrator account, the password and . for domain (. give the real domain), and I get the same problem, server not found. So the problem is not here

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Thanxx
Deepak

|||Do I need to create login on each server for the connection, and give access to connect endpoint, or sa is ok ?
|||I believe you need to create same login in each server for the connection and configure endpoint ! !

Error on setting ip partners : servers not found

Hello,

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

And it's the same problem with the second server.

Thanks for helping.

ps : Excuse my english ^^

So we can't use IP to connect servers ? I thought the contrary...

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Error on setting ip partners : servers not found

Hello,

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

And it's the same problem with the second server.

Thanks for helping.

ps : Excuse my english ^^

So we can't use IP to connect servers ? I thought the contrary...

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Error on setting ip partners : servers not found

Hello,

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

And it's the same problem with the second server.

Thanks for helping.

ps : Excuse my english ^^

So we can't use IP to connect servers ? I thought the contrary...

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Error on setting ip partners : servers not found

Hello,

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

And it's the same problem with the second server.

Thanks for helping.

ps : Excuse my english ^^

So we can't use IP to connect servers ? I thought the contrary...

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Wednesday, March 21, 2012

error on one machine and working on another

Dear sir this is a typical problem i am facing.

We have 4 web servers in out establishment.
this code works on some and does not work on some.

in all servers i have installed crystal reports the same way.

the database server is a separate server.

please help.

i must deploy this web page and the report on the one of the 2 servers( both hcl machines) allotted to me. the other 2 on which this code is working are ibm machines but i cannot deploy on them.

Error Type:
webReporting.dll (0x8004100F)
Logon failed. Details: ADO Error Code: 0x80040e21 Source: Provider Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Native Error: -2147217887 Error in File C:\WINNT\TEMP\{A687C3B5-8F52-40E2-9433-C2FF1D56D225}.rpt: Unable to connect: incorrect log on parameters.
/stores_crystal/expendable.asp, line 72

<%@. Language=VBScript %>



<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<center>
<form name=expendable method=post>
<%if request.form("dummy")="" then
set rs=server.CreateObject ("adodb.recordset")
q="sELECT item_code,item from exp_binmst order by item"
rs.Open q,conn_inventory
%>ITEM<select size=10 multiple name=eitem>
<%while not rs.eof
v="'"&rs(0)&"'"%>
<option value="<%=v%>"><%=rs(1)%></option>
<%rs.movenext
wend%>
</select>
<BR><BR><BR><BR><BR>From Date<%call urdate("mustbox-date/from date","from_date",date)%>
No From Date??<input type=checkbox name=No_From_date >
To Date<%call urdate("mustbox-date/to date","to_date",date)
%>
<BR><BR><BR><input type=submit value=show><input name=dummy value=dummy type=hidden>
<%else

dim objectfactory,htmlviewer,conInfo,coninfos
set objectfactory=createobject("crystalreports.objectfactory.2")
set htmlviewer=createobject("crystalreports.crystalreportviewer")
set conInfos=createobject("crystalreports.ConnectionInfos")
set conInfo=createobject("crystalreports.ConnectionInfo")

conInfo.UserName="sa"
conInfo.Password="3blind"
conInfos.Add(conInfo)

if Request.Form("no_from_date")="on" then
q="{Command.item_code} in ["&request.form("eitem")&"] and {Command.bin_dt} <=cdate('"&cdate(Request.Form("to_Date"))&"')"
else
q="{Command.item_code} in ["&request.form("eitem")&"] and {Command.bin_dt} >=cdate('"&cdate(request.form("from_Date"))&"') and {Command.bin_dt} <=cdate('"&cdate(Request.Form("to_Date"))&"')"
end if

with htmlviewer
.HasCrystalLogo=false
.HasExportButton=false
.HasGotoPageButton=false
.HasPageNavigationButtons=false
.HasPrintButton=false
.HasRefreshButton=false
.HasSearchButton=false
.HasToggleGroupTreeButton=false
.HasViewList=false
.HasZoomFactorList=false
.IsOwnForm=true
.IsOwnPage=true
.pageToTreeRatio=100
.ReportSource="expendable.rpt"
.EnableLogonPrompt=false
.DatabaseLogonInfos=conInfos
.SelectionFormula=q

end with

call htmlviewer.ProcessHttpRequest(request,Response,session)
'''' line no 72

end if%>

</BODY>
</HTML>
:(I encountered the same problem a couple of days before, it made me very hard to fix that, I found none solution provided on the line, finally I got the solution :
Just using ODBC connection instead of OLEDB.

Because the crystal versioning is very picky.

Error on MSDTC on win2k3 to win2k

I am currently having issue with MSDTC.
I have two servers, one running win2k3 server and the other running win2k
advanced server. Both are also running MSSQL2k.
I have a script that runs on the win2k3 server, that updates one of it's
tables, based on information accessed through a linked server to the win2k
machine. No updating is done to the win2k machine, only selection. All
updates occur to the data on the win2k3 machine, which is were the script is
running.
When I execute this script, I get the following error.
"New transaction cannot enlist in the specified transaction coordinator"
When both machines are win2k, this works without any problem.
Both servers have a linked server connection to each other. All other
scripts that work across this link work fine, as long as they are not in a
transaction.
I am running out of ideas on how to get this working, does anyone have any
ideas. Any assistance would be greatly appreciated.
Thank you
Clint ColefaxI would say it is pretty likely DTC is turned off on the Win2003 machine but
here are some things that come up in the KB search:
http://support.microsoft.com/default.aspx?scid=kb;en-us;816701&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;831425&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;555017&Product=sql2k
Andrew J. Kelly SQL MVP
"Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in message
news:4E379DAB-38A2-4034-9196-8C5B605A2193@.microsoft.com...
> I am currently having issue with MSDTC.
> I have two servers, one running win2k3 server and the other running win2k
> advanced server. Both are also running MSSQL2k.
> I have a script that runs on the win2k3 server, that updates one of it's
> tables, based on information accessed through a linked server to the win2k
> machine. No updating is done to the win2k machine, only selection. All
> updates occur to the data on the win2k3 machine, which is were the script
is
> running.
> When I execute this script, I get the following error.
> "New transaction cannot enlist in the specified transaction coordinator"
> When both machines are win2k, this works without any problem.
> Both servers have a linked server connection to each other. All other
> scripts that work across this link work fine, as long as they are not in a
> transaction.
> I am running out of ideas on how to get this working, does anyone have any
> ideas. Any assistance would be greatly appreciated.
> Thank you
> Clint Colefax|||Thank you for your response.
DTC is running on both servers, that was the first thing I checked. The 3
three knowledge base article below I have tried, most of these settings were
already set, or in the case of the win2k machine, do not exist. Many of the
security settings for DTC were added Win2k3. But I have read article stating
that this security is ignored if one of the machines is detected as Win2k.
I will look into the 3rd article.
If you have any other idea, they would be greatly appreciated.
Thank you
Clint Colefax
"Andrew J. Kelly" wrote:
> I would say it is pretty likely DTC is turned off on the Win2003 machine but
> here are some things that come up in the KB search:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;816701&Product=sql2k
> http://support.microsoft.com/default.aspx?scid=kb;en-us;831425&Product=sql2k
> http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql2k
> http://support.microsoft.com/default.aspx?scid=kb;en-us;555017&Product=sql2k
>
> --
> Andrew J. Kelly SQL MVP
>
> "Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in message
> news:4E379DAB-38A2-4034-9196-8C5B605A2193@.microsoft.com...
> > I am currently having issue with MSDTC.
> >
> > I have two servers, one running win2k3 server and the other running win2k
> > advanced server. Both are also running MSSQL2k.
> > I have a script that runs on the win2k3 server, that updates one of it's
> > tables, based on information accessed through a linked server to the win2k
> > machine. No updating is done to the win2k machine, only selection. All
> > updates occur to the data on the win2k3 machine, which is were the script
> is
> > running.
> > When I execute this script, I get the following error.
> >
> > "New transaction cannot enlist in the specified transaction coordinator"
> >
> > When both machines are win2k, this works without any problem.
> >
> > Both servers have a linked server connection to each other. All other
> > scripts that work across this link work fine, as long as they are not in a
> > transaction.
> >
> > I am running out of ideas on how to get this working, does anyone have any
> > ideas. Any assistance would be greatly appreciated.
> >
> > Thank you
> > Clint Colefax
>
>|||Sorry those would have been my guess. If no one else pipes up you might
want to give MS PSS a call. Even if it isn't a bug it might be worth the
$250.00 or so to get the systems up as soon as possible.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in message
news:0AEBF2EC-9455-47B1-BB30-56F41CB100D0@.microsoft.com...
> Thank you for your response.
> DTC is running on both servers, that was the first thing I checked. The 3
> three knowledge base article below I have tried, most of these settings
were
> already set, or in the case of the win2k machine, do not exist. Many of
the
> security settings for DTC were added Win2k3. But I have read article
stating
> that this security is ignored if one of the machines is detected as Win2k.
> I will look into the 3rd article.
> If you have any other idea, they would be greatly appreciated.
> Thank you
> Clint Colefax
>
> "Andrew J. Kelly" wrote:
> > I would say it is pretty likely DTC is turned off on the Win2003 machine
but
> > here are some things that come up in the KB search:
> >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;816701&Product=sql2k
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;831425&Product=sql2k
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql2k
> >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;555017&Product=sql2k
> >
> >
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Clint Colefax" <ClintColefax@.discussions.microsoft.com> wrote in
message
> > news:4E379DAB-38A2-4034-9196-8C5B605A2193@.microsoft.com...
> > > I am currently having issue with MSDTC.
> > >
> > > I have two servers, one running win2k3 server and the other running
win2k
> > > advanced server. Both are also running MSSQL2k.
> > > I have a script that runs on the win2k3 server, that updates one of
it's
> > > tables, based on information accessed through a linked server to the
win2k
> > > machine. No updating is done to the win2k machine, only selection. All
> > > updates occur to the data on the win2k3 machine, which is were the
script
> > is
> > > running.
> > > When I execute this script, I get the following error.
> > >
> > > "New transaction cannot enlist in the specified transaction
coordinator"
> > >
> > > When both machines are win2k, this works without any problem.
> > >
> > > Both servers have a linked server connection to each other. All other
> > > scripts that work across this link work fine, as long as they are not
in a
> > > transaction.
> > >
> > > I am running out of ideas on how to get this working, does anyone have
any
> > > ideas. Any assistance would be greatly appreciated.
> > >
> > > Thank you
> > > Clint Colefax
> >
> >
> >

Error on MSDTC on win2k3 to win2k

Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).
Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections and
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:

> Hi,
> I am getting below error on link server and the performance between the link
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit was
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>
sql

Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 731
2) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returne
d
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections an
d
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:

> Hi,
> I am getting below error on link server and the performance between the li
nk
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit wa
s
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7
312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute retur
ned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>

Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections and
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:
> Hi,
> I am getting below error on link server and the performance between the link
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit was
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>

Error on Importing datather PRIMARY FILE GROUP IS FULL

I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL
As the message is indicating, your primary file group where the table exists
is full. You will have to set the file to autogrow, if it isn't already (see
ALTER DATABASE in Books Online). Also, make sure, you have enough free space
on your data disk.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL
|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am trying to import data from one table to another on different servers.
>
> Could not allocate space for object microfilmacion in database Dbsiab
> because ther PRIMARY FILE GROUP IS FULL
>
|||How can I do that? I didnt understand.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
servers.
>
|||Assuming you are using Outlook Express when you create the post it will have
a section at the top titled "NewsGroups". Normally it will fill in the name
of the group in which you are currently in but you can click on the Icon to
the left of it and choose all the groups you wish this post to appear. Then
when someone answers in one newsgroup it will appear in all of them.
Good luck,
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:eUp%23QsshEHA.3200@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> How can I do that? I didnt understand.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
one.
> servers.
>

Error on Importing datather PRIMARY FILE GROUP IS FULL

I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULLAs the message is indicating, your primary file group where the table exists
is full. You will have to set the file to autogrow, if it isn't already (see
ALTER DATABASE in Books Online). Also, make sure, you have enough free space
on your data disk.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am trying to import data from one table to another on different servers.
>
> Could not allocate space for object microfilmacion in database Dbsiab
> because ther PRIMARY FILE GROUP IS FULL
>|||How can I do that? I didnt understand.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
servers.[vbcol=seagreen]
>|||Assuming you are using Outlook Express when you create the post it will have
a section at the top titled "NewsGroups". Normally it will fill in the name
of the group in which you are currently in but you can click on the Icon to
the left of it and choose all the groups you wish this post to appear. Then
when someone answers in one newsgroup it will appear in all of them.
Good luck,
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:eUp%23QsshEHA.3200@.TK2MSFTNGP10.phx.gbl...
> How can I do that? I didnt understand.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
one.[vbcol=seagreen]
> servers.
>

Error on Importing datather PRIMARY FILE GROUP IS FULL

I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULLAs the message is indicating, your primary file group where the table exists
is full. You will have to set the file to autogrow, if it isn't already (see
ALTER DATABASE in Books Online). Also, make sure, you have enough free space
on your data disk.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
I am trying to import data from one table to another on different servers.
Could not allocate space for object microfilmacion in database Dbsiab
because ther PRIMARY FILE GROUP IS FULL|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am trying to import data from one table to another on different servers.
>
> Could not allocate space for object microfilmacion in database Dbsiab
> because ther PRIMARY FILE GROUP IS FULL
>|||How can I do that? I didnt understand.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribió en el mensaje
news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
> Please don't post independently in separate newsgroups. You can add
> multiple newsgroups to the header and then all the answers appear as one.
> See my reply in the other newsgroup.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > I am trying to import data from one table to another on different
servers.
> >
> >
> > Could not allocate space for object microfilmacion in database Dbsiab
> > because ther PRIMARY FILE GROUP IS FULL
> >
> >
>|||Assuming you are using Outlook Express when you create the post it will have
a section at the top titled "NewsGroups". Normally it will fill in the name
of the group in which you are currently in but you can click on the Icon to
the left of it and choose all the groups you wish this post to appear. Then
when someone answers in one newsgroup it will appear in all of them.
Good luck,
--
Andrew J. Kelly SQL MVP
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:eUp%23QsshEHA.3200@.TK2MSFTNGP10.phx.gbl...
> How can I do that? I didnt understand.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribió en el mensaje
> news:uT2gn4rhEHA.632@.TK2MSFTNGP12.phx.gbl...
> > Please don't post independently in separate newsgroups. You can add
> > multiple newsgroups to the header and then all the answers appear as
one.
> > See my reply in the other newsgroup.
> >
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> > news:uRLheyrhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > I am trying to import data from one table to another on different
> servers.
> > >
> > >
> > > Could not allocate space for object microfilmacion in database Dbsiab
> > > because ther PRIMARY FILE GROUP IS FULL
> > >
> > >
> >
> >
>sql

Monday, March 12, 2012

Error number: 2812 - Transaction Replication

Hi,
I am trying transactional replication between two servers with a remote
distributor. I am getting following error each time I run the distribution
agent
Last Command : {CALL sp_MSupd_Customers (NULL,N'Alfreds Futterkiste -
test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,N'ALFKI',0x0200)}
Transaction sequence number and command ID of last execution batch are
0x0000001A00000082000900000000 and 1.
Error Message :Could not find stored procedure 'sp_MSupd_Customers'.
Error details : Could not find stored procedure 'sp_MSupd_Customers'.
(Source: L000646\AA03 (Data source); Error number: 2812)
Can some one help please
If you have used @.sync_type = None in sp_addsubscription or in the
subscription wizard, Initialize subscription page, you select 'no, the
subscriber already has the schema and data' you may get this error. The
system tables for replication will be created on the subscriber in either
case but you'll need to manually create the stored procedures on the
subscriber if you use this option otherwise you'll have the above error when
you change a row on the publisher. Use sp_scriptpublicationcustomprocs
(assuming you have >= sp1) to create a script which creates the procedures
and run this script on the subscriber.
HTH,
Paul Ibison
|||Thanks for that Paul. It is all working now.
regards
"Paul Ibison" wrote:

> If you have used @.sync_type = None in sp_addsubscription or in the
> subscription wizard, Initialize subscription page, you select 'no, the
> subscriber already has the schema and data' you may get this error. The
> system tables for replication will be created on the subscriber in either
> case but you'll need to manually create the stored procedures on the
> subscriber if you use this option otherwise you'll have the above error when
> you change a row on the publisher. Use sp_scriptpublicationcustomprocs
> (assuming you have >= sp1) to create a script which creates the procedures
> and run this script on the subscriber.
> HTH,
> Paul Ibison
>
>

Sunday, February 26, 2012

Error Message. Please help

I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
Try refreshing enterprise manger.
Regards
Amish Shah
|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>
|||I have found disconnecting from the server and/or shutting down EM helps.
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:

> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
>
>
|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You

Error Message. Please help

I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank YouTry refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:

> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884
@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank You

Tuesday, March 27, 2012

Error pulling unicode data from DB2 Linked Server

Friday, March 23, 2012

Error on Stored Procedure

Error on setting ip partners : servers not found

Error on setting ip partners : servers not found

Error on setting ip partners : servers not found

Error on setting ip partners : servers not found

Error on setting ip partners : servers not found

Wednesday, March 21, 2012

error on one machine and working on another

Error on MSDTC on win2k3 to win2k

Error on MSDTC on win2k3 to win2k

Error on MSDTC on win2k3 to win2k

Error on link Servers

Error on link Servers

Error on link Servers

Error on Importing datather PRIMARY FILE GROUP IS FULL

Error on Importing datather PRIMARY FILE GROUP IS FULL

Error on Importing datather PRIMARY FILE GROUP IS FULL

Monday, March 12, 2012

Error number: 2812 - Transaction Replication

Sunday, February 26, 2012

Error Message. Please help

Error Message. Please help

Sql Error message

Blog Archive

About Me