Showing posts with label load. Show all posts
Showing posts with label load. Show all posts

Thursday, March 29, 2012

Failed to retrieve long data for column

Hi,

We have a SSIS project where we load lot of image files using an OLE DB Source component and put it across the database as varbinary into OLEDB Destination component.

Things were fine until now where am getting an error like this. alongside the log also reads like,

There is not enough space on the disk. Long data was retrieved and can't be added to the data flow task buffer.

SSIS Error Code: DTS_E_InducedTransformFailureOnError.

Is this method of loading the files using an OleDb Souce not the efficient one ? If not is there a way I can get this done. Comments are highly appreciated!!

Thanks in Advance

Have you check to see if you are running out of physical disk space?

Unless you have a directory specified in the BLOBTempStoragePath property of the data flow, the default location will be the directory specified by the TEMP environment variable.

Make sure that the directory listed by either of those isn't running out of disk space. If so, then set BLOBTempStoragePath to a directory containing more disk space.|||

Hi Phil,

Thanks for the valuable inputs,Is it ok if I just point a Directory in a Physical drive that has enough disk space is it? What purpose does this BlobStorage Serve ?

|||

MShetty wrote:

Hi Phil,

Thanks for the valuable inputs,Is it ok if I just point a Directory in a Physical drive that has enough disk space is it? What purpose does this BlobStorage Serve ?

The BLOB storage path is used to hold the contents of a varbinary field if it cannot fit into memory.

So point that parameter to a directory that contains enough disk space and try it again.|||Thanks Phil.. It worked Smile|||I got the same message. Failed to retrieve long data for column I was running an ssis job to import tables from an access database to sql2000 so we could change the back end to sql. I had everything working ok. Then I had to change the source connection from the dev access back end to the production access back end so i could get the latest data. One field in one of 83 tables kept blowing up. It was an Ntext field. I tried everything in these posts to no avial. Finally I noticed that the size of the production mdb was 3x the size of my dev mdb. So, I compacted the production mdb and reran the ssis package. It worked like a charm. Hope this may help someone else out there.
tom in stumptown

Failed to retrieve long data for column

Hi,

We have a SSIS project where we load lot of image files using an OLE DB Source component and put it across the database as varbinary into OLEDB Destination component.

Things were fine until now where am getting an error like this. alongside the log also reads like,

There is not enough space on the disk. Long data was retrieved and can't be added to the data flow task buffer.

SSIS Error Code: DTS_E_InducedTransformFailureOnError.

Is this method of loading the files using an OleDb Souce not the efficient one ? If not is there a way I can get this done. Comments are highly appreciated!!

Thanks in Advance

Have you check to see if you are running out of physical disk space?

Unless you have a directory specified in the BLOBTempStoragePath property of the data flow, the default location will be the directory specified by the TEMP environment variable.

Make sure that the directory listed by either of those isn't running out of disk space. If so, then set BLOBTempStoragePath to a directory containing more disk space.|||

Hi Phil,

Thanks for the valuable inputs,Is it ok if I just point a Directory in a Physical drive that has enough disk space is it? What purpose does this BlobStorage Serve ?

|||

MShetty wrote:

Hi Phil,

Thanks for the valuable inputs,Is it ok if I just point a Directory in a Physical drive that has enough disk space is it? What purpose does this BlobStorage Serve ?

The BLOB storage path is used to hold the contents of a varbinary field if it cannot fit into memory.

So point that parameter to a directory that contains enough disk space and try it again.|||Thanks Phil.. It worked Smile|||I got the same message. Failed to retrieve long data for column I was running an ssis job to import tables from an access database to sql2000 so we could change the back end to sql. I had everything working ok. Then I had to change the source connection from the dev access back end to the production access back end so i could get the latest data. One field in one of 83 tables kept blowing up. It was an Ntext field. I tried everything in these posts to no avial. Finally I noticed that the size of the production mdb was 3x the size of my dev mdb. So, I compacted the production mdb and reran the ssis package. It worked like a charm. Hope this may help someone else out there.
tom in stumptown

Failed to retrieve data for this request.

I am trying to load data into a SQL Server table through a web page. I am getting error like this:

Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

I am doing the same for other tables in the same db its working fine. but its working for one table alone. The table name is like this (DTD_PUMA_DeliveryPerformance)

Is it cos of table name? Wink

I tried with import/export wizard also its working fine but still its not working for web page.

I don t think its cos of network or OS!! Its with table or some connection property.

Pls help me in solving this.

There is nothing wrong with the tablename.

Have you checked the connection string and compared it to the one on pages that are successful?

|||

Thanks for the reply.

Identified the problem, its cos of the excel sheet.

There is a row in the excel sheet with the description ("Get Keys"), when i removed tht row its working

So i need to know how to exclude the first row from the excel sheet while selecting (select * from [Sheet1$]).

failed to post

Hello,
I have a technical problem: I'm trying to load my xml file and xsd schema to a new post but fail to do so.
Plz if someone can help meI have put my question in the attached .txt file

Tuesday, March 27, 2012

Failed to load msxmlsql.dll

Hi All,
I get the following error message when trying to run the following SQL
script in SQL Server 2000 SP 4.
SQL Script:
--
DECLARE @.hdoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
</Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
<Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
<OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
</Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
-- Remove the internal representation.
exec sp_xml_removedocument @.hdoc
Error Message:
--
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
18
Failed to load msxmlsql.dll.
Does anybody know this error message?
Thanks,
RonenRonen,
I have a couple of questions.
1) When you performed the upgrade from SP3, did you get any errors?
2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
Server\80\Shared directory (replace X with whatever drive you installed Sql
Server on)?
Regards,
Galex
"Ronen" wrote:

> Hi All,
> I get the following error message when trying to run the following SQL
> script in SQL Server 2000 SP 4.
> SQL Script:
> --
> DECLARE @.hdoc int
> DECLARE @.doc varchar(1000)
> SET @.doc ='
> <ROOT>
> <Customer CustomerID="VINET" ContactName="Paul Henriot">
> <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00
">
> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
> </Order>
> </Customer>
> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
> <Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00
">
> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
> </Order>
> </Customer>
> </ROOT>'
> --Create an internal representation of the XML document.
> EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
> -- Remove the internal representation.
> exec sp_xml_removedocument @.hdoc
> Error Message:
> --
> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Lin
e
> 18
> Failed to load msxmlsql.dll.
> Does anybody know this error message?
> Thanks,
> Ronen
>
>|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
> Ronen,
> I have a couple of questions.
> 1) When you performed the upgrade from SP3, did you get any errors?
> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
> Server\80\Shared directory (replace X with whatever drive you installed
> Sql
> Server on)?
> Regards,
> Galex
> "Ronen" wrote:
>|||I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.
I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.
Thanks.
Best regards,
Ronen
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>sql

Failed to load msxmlsql.dll

Hi All,
I get the following error message when trying to run the following SQL
script in SQL Server 2000 SP 4.
SQL Script:
DECLARE @.hdoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
</Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
<Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
<OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
</Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
-- Remove the internal representation.
exec sp_xml_removedocument @.hdoc
Error Message:
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
18
Failed to load msxmlsql.dll.
Does anybody know this error message?
Thanks,
Ronen
Ronen,
I have a couple of questions.
1) When you performed the upgrade from SP3, did you get any errors?
2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
Server\80\Shared directory (replace X with whatever drive you installed Sql
Server on)?
Regards,
Galex
"Ronen" wrote:

> Hi All,
> I get the following error message when trying to run the following SQL
> script in SQL Server 2000 SP 4.
> SQL Script:
> --
> DECLARE @.hdoc int
> DECLARE @.doc varchar(1000)
> SET @.doc ='
> <ROOT>
> <Customer CustomerID="VINET" ContactName="Paul Henriot">
> <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
> </Order>
> </Customer>
> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
> <Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
> </Order>
> </Customer>
> </ROOT>'
> --Create an internal representation of the XML document.
> EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
> -- Remove the internal representation.
> exec sp_xml_removedocument @.hdoc
> Error Message:
> --
> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
> 18
> Failed to load msxmlsql.dll.
> Does anybody know this error message?
> Thanks,
> Ronen
>
>
|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...[vbcol=seagreen]
> Ronen,
> I have a couple of questions.
> 1) When you performed the upgrade from SP3, did you get any errors?
> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
> Server\80\Shared directory (replace X with whatever drive you installed
> Sql
> Server on)?
> Regards,
> Galex
> "Ronen" wrote:
|||I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.
I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.
Thanks.
Best regards,
Ronen
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>

Failed to load Msxml2.dll

Hi All,
Before I get directed to the Microsoft site to download the Msxml2.msi
to fix this problem I'll let everyone know that the fix has already
been applied and had no effect.
Here's the situation. There are XP worksataons and a 2000 Server
machine with MSDE SP4 installed on it. The client machines are trying
to communicate with our webservice to update data in the database on
the server.
Our support person used Filemon, Process Explorer, and Dll compare to
monitor what was being hit during our import process and he hit the
same files as our client but he doesn't get the "failed to load
Msxml2.dll" error but the client does. The client is running MDAC
2.81.1117 and its using 3.0 SP7 (8.70.1117.0).
Basically I'm at a complete loss because everywhere I've looked online
points me to the fix on the MS site which doesn't seem to have any
effect at all.
Thanks in advance for any help you can offer.
Mike Gorgone
Software Engineer II
Blackbaud Inc.
Hi Mike...
Sorry for the late response. But does this error appear as part of a stored
procedure call?
If so, you may have upgraded one instance of SQL Server to 2005 while having
still your SP4 instances running too... in that case you need to reapply the
SP4 install to get the MSXML file back (or copy it into the right location
from another machine).
Best regards
Michael
"Mike" < wrote in message
news:1163018218.382898.161130@.h48g2000cwc.googlegr oups.com...
> Hi All,
> Before I get directed to the Microsoft site to download the Msxml2.msi
> to fix this problem I'll let everyone know that the fix has already
> been applied and had no effect.
> Here's the situation. There are XP worksataons and a 2000 Server
> machine with MSDE SP4 installed on it. The client machines are trying
> to communicate with our webservice to update data in the database on
> the server.
> Our support person used Filemon, Process Explorer, and Dll compare to
> monitor what was being hit during our import process and he hit the
> same files as our client but he doesn't get the "failed to load
> Msxml2.dll" error but the client does. The client is running MDAC
> 2.81.1117 and its using 3.0 SP7 (8.70.1117.0).
> Basically I'm at a complete loss because everywhere I've looked online
> points me to the fix on the MS site which doesn't seem to have any
> effect at all.
> Thanks in advance for any help you can offer.
> Mike Gorgone
> Software Engineer II
> Blackbaud Inc.
>

Failed to load Msxml2.dll

I am running SQL 2000 on Vista box. When I am trying to open XML in my SP
EXEC sp_xml_preparedocument @.idoc OUTPUT, @.xmlstring
I am getting this error. Any help?
Thanks
Hi Mark
What service pack of SQL Server 2000 are you running?
Also, do you have SQL Server 2005 installed on the same box or upgraded one
SQL Server 2000 instance to 2005?
Thanks
Michael
"Mark Goldin" <markgoldin_2000@.yahoo.com> wrote in message
news:491D1C23-3918-485B-98B7-CE05C2FF249B@.microsoft.com...
>I am running SQL 2000 on Vista box. When I am trying to open XML in my SP
>EXEC sp_xml_preparedocument @.idoc OUTPUT, @.xmlstring
> I am getting this error. Any help?
> Thanks

Failed to load Msxml2.dll

I am running SQL 2000 on Vista box. When I am trying to open XML in my SP
EXEC sp_xml_preparedocument @.idoc OUTPUT, @.xmlstring
I am getting this error. Any help?
ThanksHi Mark
What service pack of SQL Server 2000 are you running?
Also, do you have SQL Server 2005 installed on the same box or upgraded one
SQL Server 2000 instance to 2005?
Thanks
Michael
"Mark Goldin" <markgoldin_2000@.yahoo.com> wrote in message
news:491D1C23-3918-485B-98B7-CE05C2FF249B@.microsoft.com...
>I am running SQL 2000 on Vista box. When I am trying to open XML in my SP
>EXEC sp_xml_preparedocument @.idoc OUTPUT, @.xmlstring
> I am getting this error. Any help?
> Thanks

Failed to load database information

I have Crystal Report 9 installed. I created rpt in VS2003 and set database as a dataset. Also, I developed a VS2003 dll to print report.

When I called the dll in VS2005, always got the error as the title: Failed to load database information. Even I made up datasource in dll, no luck. So there must be something wrong while calling 2003 dll from vs2005.

Any idea?

If I add CrystalDecisions.CrystalReport.Engine and CrystalDecisions.Shared in vs2005 project as reference, but the version is 9.2.3300.0. I add some codes to print report:

ReportDocument rpt = new ReportDocument();
rpt.Load(@."D:\VS 2005 Projects\CallPrintCrystalReport\CallPrintCrystalReport\CrystalReport1.rpt");
rpt.SetDataSource(CreateDS());
rpt.PrintToPrinter(1, false, 0, 0);
rpt.Close();

Same error!!! Does this mean CrystalReport 9.2.3300 can not be called by VS2005?Probably not, since CR of VS2005 is based-on version XI.|||Thank you. I just wanna make sure about it.sql

Monday, March 19, 2012

Failed Login for a WorkGroup when attempting to run a query

Hi all,
I have an application which works with SQL Server. When the applicationattempts to load a page it needs to run certain queries. When itattempts to run a particular query it fails but I catch the exceptionand then log it. The following is logged:
System.Data.Ole.Db.OleDbException: Login failed for user 'CWAMB01DWH01\ASPENT'.
Now what I don't understand is that this is the work group that ASPNETis run under, and I am running other queries to the database via SQLServer authentication. Why am I getting a failed login for thisworkgroup? Do I need to create a new Login for the Server in SQLServer, and then create a new user for the database with the sameusername as the Workgroup name? If so, then how does the password workfor the SQL Server as the workgroup (CWAMB01DWH01\ASPENT) obviouslydoesn't have a password.
Thanks, and I hope I have explain my problem clear enough.
Tryst
There are two permissions in SQL Server database permissions in the database and server permissions you create under security in Enterprise Manager. Hope this helps.