Showing posts with label error. Show all posts
Showing posts with label error. Show all posts

Friday, March 30, 2012

Reading a flat file

I get the following error when reading a flat file : [Credit Information 1 [1]] Error: Data conversion failed. The data conversion for column "AccountName" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

I did check all the mappings, and everything seems to be fine, the field is read in as a string. I also check for any strange characters that can possibly cause this error but the value of the field only contains a person's name and spaces at the end.

Does anyone have any ideas what might be the cause of the error?What is the source data type of the AccountName field?

What is the data type of the mapped field in SSIS?

What code page are you working with? 1252?sql

Monday, March 26, 2012

Read only DB when moving database (error 5105 "device activation...")

Windows 2003 server
SQL2000 installed and running
Create a database on C:\Data called Ctest
Create a database on F:\Data called Ftest
Detach both databases.
Move Ftest to c:\Data folder.
Move Ctest to F:\Data folder.
Reattach both databases from their new locations.
Here's the problem --
Both are read only now.
Un-checking the Read only properties causes an error 5105 "device
activation..."
I do the same thing on another system and they don't attach as read
only.
Any ideas on this one?
Mark G
Mark,
Check the file properties for the .mdf and .ldf files - are they read-only?
Also since this is a test box try restarting the server as well.
HTH
Jerry
"Mark G" <megriep@.gmail.com> wrote in message
news:1128185904.036026.202210@.o13g2000cwo.googlegr oups.com...
> Windows 2003 server
> SQL2000 installed and running
> Create a database on C:\Data called Ctest
> Create a database on F:\Data called Ftest
> Detach both databases.
>
> Move Ftest to c:\Data folder.
> Move Ctest to F:\Data folder.
>
> Reattach both databases from their new locations.
>
> Here's the problem --
> Both are read only now.
> Un-checking the Read only properties causes an error 5105 "device
> activation..."
>
> I do the same thing on another system and they don't attach as read
> only.
>
> Any ideas on this one?
>
> Mark G
>
|||And also verify that the SQL Server service account has proper permission on the files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:Onzf8DrxFHA.3400@.TK2MSFTNGP14.phx.gbl...
> Mark,
> Check the file properties for the .mdf and .ldf files - are they read-only? Also since this is a
> test box try restarting the server as well.
> HTH
> Jerry
> "Mark G" <megriep@.gmail.com> wrote in message
> news:1128185904.036026.202210@.o13g2000cwo.googlegr oups.com...
>

Read only DB when moving database (error 5105 "device activation...")

Windows 2003 server
SQL2000 installed and running
Create a database on C:\Data called Ctest
Create a database on F:\Data called Ftest
Detach both databases.
Move Ftest to c:\Data folder.
Move Ctest to F:\Data folder.
Reattach both databases from their new locations.
Here's the problem --
Both are read only now.
Un-checking the Read only properties causes an error 5105 "device
activation..."
I do the same thing on another system and they don't attach as read
only.
Any ideas on this one?
Mark GMark,
Check the file properties for the .mdf and .ldf files - are they read-only?
Also since this is a test box try restarting the server as well.
HTH
Jerry
"Mark G" <megriep@.gmail.com> wrote in message
news:1128185904.036026.202210@.o13g2000cwo.googlegroups.com...
> Windows 2003 server
> SQL2000 installed and running
> Create a database on C:\Data called Ctest
> Create a database on F:\Data called Ftest
> Detach both databases.
>
> Move Ftest to c:\Data folder.
> Move Ctest to F:\Data folder.
>
> Reattach both databases from their new locations.
>
> Here's the problem --
> Both are read only now.
> Un-checking the Read only properties causes an error 5105 "device
> activation..."
>
> I do the same thing on another system and they don't attach as read
> only.
>
> Any ideas on this one?
>
> Mark G
>|||And also verify that the SQL Server service account has proper permission on the files.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:Onzf8DrxFHA.3400@.TK2MSFTNGP14.phx.gbl...
> Mark,
> Check the file properties for the .mdf and .ldf files - are they read-only? Also since this is a
> test box try restarting the server as well.
> HTH
> Jerry
> "Mark G" <megriep@.gmail.com> wrote in message
> news:1128185904.036026.202210@.o13g2000cwo.googlegroups.com...
>> Windows 2003 server
>> SQL2000 installed and running
>> Create a database on C:\Data called Ctest
>> Create a database on F:\Data called Ftest
>> Detach both databases.
>>
>> Move Ftest to c:\Data folder.
>> Move Ctest to F:\Data folder.
>>
>> Reattach both databases from their new locations.
>>
>> Here's the problem --
>> Both are read only now.
>> Un-checking the Read only properties causes an error 5105 "device
>> activation..."
>>
>> I do the same thing on another system and they don't attach as read
>> only.
>>
>> Any ideas on this one?
>>
>> Mark G
>|||Thanks,
Yes, it's a permissions thing--something to do with Windows. Not sure
why one system has the problem and the other doesn't. I'll have to
look into it.
Thanks for all your help.
Mark.

Read only DB when moving database (error 5105 "device activation...")

Windows 2003 server
SQL2000 installed and running
Create a database on C:\Data called Ctest
Create a database on F:\Data called Ftest
Detach both databases.
Move Ftest to c:\Data folder.
Move Ctest to F:\Data folder.
Reattach both databases from their new locations.
Here's the problem --
Both are read only now.
Un-checking the Read only properties causes an error 5105 "device
activation..."
I do the same thing on another system and they don't attach as read
only.
Any ideas on this one?
Mark GMark,
Check the file properties for the .mdf and .ldf files - are they read-only?
Also since this is a test box try restarting the server as well.
HTH
Jerry
"Mark G" <megriep@.gmail.com> wrote in message
news:1128185904.036026.202210@.o13g2000cwo.googlegroups.com...
> Windows 2003 server
> SQL2000 installed and running
> Create a database on C:\Data called Ctest
> Create a database on F:\Data called Ftest
> Detach both databases.
>
> Move Ftest to c:\Data folder.
> Move Ctest to F:\Data folder.
>
> Reattach both databases from their new locations.
>
> Here's the problem --
> Both are read only now.
> Un-checking the Read only properties causes an error 5105 "device
> activation..."
>
> I do the same thing on another system and they don't attach as read
> only.
>
> Any ideas on this one?
>
> Mark G
>|||And also verify that the SQL Server service account has proper permission on
the files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:Onzf8DrxFHA.3400@.TK2MSFTNGP14.phx.gbl...
> Mark,
> Check the file properties for the .mdf and .ldf files - are they read-only
? Also since this is a
> test box try restarting the server as well.
> HTH
> Jerry
> "Mark G" <megriep@.gmail.com> wrote in message
> news:1128185904.036026.202210@.o13g2000cwo.googlegroups.com...
>sql

Friday, March 23, 2012

Read large binary data from Sql Server 2005

Hi

I've followed a tutorial on how to write and read varbinary(max) data to and from a database. But when i try to read the data i get the error that the data would be truncated, but only when the varbinary(max) is greater then 8kB. I've used a system stored procedure (sp_tableoption) to set the table that holds the data to store data outside rows. To select the data i'm using a stored procedure:


SELECT imageData , MIMETypeFROMPicturesWHERE(imageTitle = @.imageTitle)

And then using an .aspx page to Response.Write the data:

Using conn As New sql.SqlConnection
conn.ConnectionString = ConfigurationManager.ConnectionStrings("myConnectionString").ToString

Dim getLogoCommand As New sql.SqlCommand
getLogoCommand.CommandType = Data.CommandType.StoredProcedure
getLogoCommand.CommandText = "GetPicture"
getLogoCommand.Connection = conn

Dim imageTitleParameter As New sql.SqlParameter("@.imageTitle", Data.SqlDbType.NVarChar, 200)
imageTitleParameter.Value = Request("imageTitle")
imageTitleParameter.Direction = Data.ParameterDirection.Input

getLogoCommand.Parameters.Add(imageTitleParameter)

conn.Open()

Using logoReader As sql.SqlDataReader = getLogoCommand.ExecuteReader
logoReader.Read()
If logoReader.HasRows = True Then
Response.Clear()
Response.ContentType = logoReader("MIMEtype").ToString()
Response.BinaryWrite(logoReader("imageData"))
End If

End Using

conn.Close()

End Using

Can anyone please help me with this?!

Even though you are using SQL Server 2005... the "compatibility mode" is set to "80" (meaning 8.0... meaning SQL Server 2000).

So, until you run "EXEC sp_dbcmptlevel 90"... your MAX will == 8000 :) (you'll only have to run this once btw)

|||

Thanks for your reply! I can see <binary data> when I'm just watching the table in SQL Server Studio Manager but still not through a stored procedure. I, however, can get the data with:

SELECT * FROM Pictures WHERE (imageTitle = @.imagetitle ) as a "text" command on the .aspx page.

So like that i'm able to actually show anything bigger then 8 kB on the page, but now I can't do anything with the stored procedure like, when there is no data for that imageTitle I can't make it return another value.

When I use



conn.Open()

Using pictureReader As sql.SqlDataReader = getLogoCommand.ExecuteReader
pictureReader.Read()
If pictureReader.HasRows = True Then
Response.Clear()
Response.ContentType = pictureReader("MIMEtype").ToString()
Response.BinaryWrite(pictureReader("imageData"))
End If

End Using


The pictureReader.HasRows = True even when there is no binary data. Is there anyway to get the page not to do anything when there is no data in a row?

Thanks

Read Failure General SQL Error

I am using Delphi 5 Enterprise version and SQL Server 2000. So, I use the
odbc bridge. SQL Client connects through TCP/IP(not named pipes). My
application works alright, but sometimes, the clients get this Error Read
Failure General SQL Error [Microsoft][ODBC SQL Server Driver]Communication
Link Failure. The client may works fine again for hours and again this
problems repeats. Please let me know of any solution. What should I do ?
"IGLC" <rightwayonline@.hotmaildot.com> wrote in message
news:OyrAX$lJGHA.1848@.TK2MSFTNGP12.phx.gbl...
>I am using Delphi 5 Enterprise version and SQL Server 2000. So,
>I use the
> odbc bridge. SQL Client connects through TCP/IP(not named
> pipes). My
> application works alright, but sometimes, the clients get this
> Error Read
> Failure General SQL Error [Microsoft][ODBC SQL Server
> Driver]Communication
> Link Failure. The client may works fine again for hours and
> again this
> problems repeats. Please let me know of any solution. What
> should I do ?
I think the error message says it all. The connection was
dropped.
- Arnie
|||OK, but why it was't happen befor.
and how to fix it.
|||"IGLC" <rightwayonline@.hotmaildot.com> wrote in message
news:OGYGOaoJGHA.1424@.TK2MSFTNGP12.phx.gbl...
> OK, but why it was't happen befor.
> and how to fix it.
>
It depends on the network to some extent. Connections should be
fairly solid on a LAN, server reboots aside. It would be more
likely to happen when using the internet and/or a VPN.
The error can be difficult to recover from. Certainly, the
SELECT (or whatever) should be in a try/catch block. You could
then catch the error, try a reconnect and retry the operation.
Not easy if you have a lot of DB I/O operations.
The only other thing I can think of is that SQL Server may have
an inactivity timeout. If this were the case, it might drop the
connection after some period of inactivity.
- Arnie

Read Failure General SQL Error

I am using Delphi 5 Enterprise version and SQL Server 2000. So, I use the
odbc bridge. SQL Client connects through TCP/IP(not named pipes). My
application works alright, but sometimes, the clients get this Error Read
Failure General SQL Error [Microsoft][ODBC SQL Server Driver]Communi
cation
Link Failure. The client may works fine again for hours and again this
problems repeats. Please let me know of any solution. What should I do ?"IGLC" <rightwayonline@.hotmaildot.com> wrote in message
news:OyrAX$lJGHA.1848@.TK2MSFTNGP12.phx.gbl...
>I am using Delphi 5 Enterprise version and SQL Server 2000. So,
>I use the
> odbc bridge. SQL Client connects through TCP/IP(not named
> pipes). My
> application works alright, but sometimes, the clients get this
> Error Read
> Failure General SQL Error [Microsoft][ODBC SQL Server
> Driver]Communication
> Link Failure. The client may works fine again for hours and
> again this
> problems repeats. Please let me know of any solution. What
> should I do ?
I think the error message says it all. The connection was
dropped.
- Arnie|||OK, but why it was't happen befor.
and how to fix it.|||"IGLC" <rightwayonline@.hotmaildot.com> wrote in message
news:OGYGOaoJGHA.1424@.TK2MSFTNGP12.phx.gbl...
> OK, but why it was't happen befor.
> and how to fix it.
>
It depends on the network to some extent. Connections should be
fairly solid on a LAN, server reboots aside. It would be more
likely to happen when using the internet and/or a VPN.
The error can be difficult to recover from. Certainly, the
SELECT (or whatever) should be in a try/catch block. You could
then catch the error, try a reconnect and retry the operation.
Not easy if you have a lot of DB I/O operations.
The only other thing I can think of is that SQL Server may have
an inactivity timeout. If this were the case, it might drop the
connection after some period of inactivity.
- Arnie

Tuesday, March 20, 2012

Re: Get not null or empty string is not work

Hi all,

Could anyone see where the error is in this IF statement?
I have three records in Shipment_history table with that work_ord_num and w/i those three records one record has a value in cust_part_num field.
I want the query return the cust_part_num value but it returns the record w/o cust_part_num.
Thanks much!

spSomething
:
Declare popu_tbl Cursor

For
SELECT TOP 100 PERCENT dbo.tblShipping_sched.work_ord_num, ...
FROM tbl
WHERE..

Open popu_tbl
Fetch Next From
While ...
Begin

--***
IF @.cust_part_num is null
SELECT @.cust_part_num = cust_part_num FROM dbo.Shipment_history
WHERE work_ord_num like (left(@.work_ord_num, 6) + '%') AND work_ord_line_num = @.work_ord_line_num
AND cust_part_num <> "";
--** the line above doesn't workUse:
IF @.cust_part_num is NOT null

...but why are you doing this in a cursor?

I'd almost guarantee that there are other issues with the code you have ommitted.

Monday, March 12, 2012

rdlc parameters error

I have :

Dim params(0)As Microsoft.Reporting.WebForms.ReportParameterparams(0) =New Microsoft.Reporting.WebForms.ReportParameter("aa","47",False)

ReportViewer1.LocalReport.SetParameters(params)

ReportViewer1.ServerReport.Refresh()

but it make error :

An error occurred during local report processing.

Microsoft.Reporting.WebForms.LocalProcessingException was unhandled by user code
Message="An error occurred during local report processing."
Source="Microsoft.ReportViewer.WebForms"
StackTrace:
at Microsoft.Reporting.WebForms.LocalReport.CompileReport()
at Microsoft.Reporting.WebForms.LocalReport.SetParameters(IEnumerable`1 parameters)
at _Default.Page_Load(Object sender, EventArgs e) in E:\Moje dokumenty\Visual Studio 2005\WebSites\VB\AJAXEnabledWebSite5\Default.aspx.vb:line 13
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hello,

Maybe u need to determine the process mode by

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local

or add to

ReportViewer2.ReportPath = Path Of report & "Inv_DamageVoucher_Template_En"

ReportViewer2.SetParameter("<Perametername>", "<Parameter Value>")

ReportViewer2.Parameters = Microsoft.Samples.ReportingServices.ReportViewer.multiState.False

|||

I use it several times and it works fine the problem with the false parameters try use this

string strTime = System.DateTime.Now.ToShortTimeString();

RptParameters[0] =
new Microsoft.Reporting.WebForms.ReportParameter("ReportParameterName",Value);
RptParameters[1]=
new Microsoft.Reporting.WebForms.ReportParameter("ReportParameterName",Value);

 
http://forums.asp.net/p/1168478/1951923.aspx#1951923

Friday, March 9, 2012

RDL Spec 2005 pg 34 error

On the RDL Nov 2005 Specification page 34 there is a table. This shows that the "Action" element does not apply to charts. This must be wrong as I was pleasantly surprised when I added a hyperlink to a chart yesterday.

Has this been added since the Spec or is there a newer version of the Spec than the Nov 2005?

The published RDL Spec is actually correct. Actions do not apply on the entire chart, but only on chart datapoints. I.e. certain areas within a chart are associated with an action (through image maps), but not the entire chart.

Please lookup the Chart DataPoint element in the spec and you should see the Action element being present.

-- Robert

Rdl files on SourceSafe

I can't get my rdl files off source safe into my solution. Error "The host
name in the certificate is invalid or does not match."Hi Cadel,
Happy New Year!
Based on my experience, error message "The host name in the certificate is
invalid or does not match" usually suggests some redirection logic in your
application for incoming requests. For example, the request to
http://localhost would redirect to another machine using https://. The URL
being redirected to did not match the URL in the SSL Certificate resulting
in the message. The problem is that once you add the redirection logic,
you will not be able to open the project to disable it.
You should disable the redirection or add logic to not redirect if the
request is from http://localhost or from any of the above pages. You could
also add an <appSettings> section to the web.config. Then in your code
check the app setting and perform the redirection based on this value.
This will allow you to enable/disable the redirection by changing the
web.config. Here is a link to the <appSettings> information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/ht
ml/gngrfappsettingselement.asp
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I only have a Solution file. I created a new solution in VB 2003 and I'm
trying to Add project from Source Control.
It seems my reporting service reports are stuck in source safe.
I'm able to add other projects in, but when I try to add my reports folder
it errors, "The source control server folder you selected contains no Visual
Studio .NET solution or project file. Please select a different server
folder."
So, then I select my Solution file and that's when I get the error, "The
host name in the certificate is invalid or does not match."
How do I add my rdl files from Source safe to my new solution file?
"Michael Cheng [MSFT]" wrote:
> Hi Cadel,
> Happy New Year!
> Based on my experience, error message "The host name in the certificate is
> invalid or does not match" usually suggests some redirection logic in your
> application for incoming requests. For example, the request to
> http://localhost would redirect to another machine using https://. The URL
> being redirected to did not match the URL in the SSL Certificate resulting
> in the message. The problem is that once you add the redirection logic,
> you will not be able to open the project to disable it.
> You should disable the redirection or add logic to not redirect if the
> request is from http://localhost or from any of the above pages. You could
> also add an <appSettings> section to the web.config. Then in your code
> check the app setting and perform the redirection based on this value.
> This will allow you to enable/disable the redirection by changing the
> web.config. Here is a link to the <appSettings> information:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/ht
> ml/gngrfappsettingselement.asp
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Can you access Source Safe through its own UI instead of through Visual
Studio? If so, do a Get Latest on the Source Safe folder that contains
your *.rdl files. Then check if that folder contains a *.rptproj file.
Sounds like it probably doesn't. However, you should be able to
create a new one by right clicking your solution in Visual Studio's
Solution Explorer and choosing Add | New Project. After adding the
project, you should be able to right-click it add choose Add | Existing
Item to add each *.rdl to the project. Then right-click again on the
project and choose Add Project to Source Control.
Hope this helps.
PS - Judging from his answer, I don't think Mr.Cheng understood your
question.|||Thanks that worked for the rdl files, but my rds files come up with an error
when I try "Add existing item", the error is "Deserialization failed: There
is an error in XML document (4,4)."
"Lee" wrote:
> Can you access Source Safe through its own UI instead of through Visual
> Studio? If so, do a Get Latest on the Source Safe folder that contains
> your *.rdl files. Then check if that folder contains a *.rptproj file.
> Sounds like it probably doesn't. However, you should be able to
> create a new one by right clicking your solution in Visual Studio's
> Solution Explorer and choosing Add | New Project. After adding the
> project, you should be able to right-click it add choose Add | Existing
> Item to add each *.rdl to the project. Then right-click again on the
> project and choose Add Project to Source Control.
> Hope this helps.
> PS - Judging from his answer, I don't think Mr.Cheng understood your
> question.
>|||There are other threads on this forum for "deserialization failed" and
some of the responses (some from MSFT folks) seem to suggest that the
report designer sometimes creates invalid XML (which is what the RDS
files contain). Can you post the contents of one of the RDS files that
produces the error? Preferably the one that gave you the message you
posted earlier...I would guess that (4,4) is a line number and position
reference and that may help us find the problem.|||<?xml version="1.0" encoding="utf-8"?>
<RptDataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="">http://www.w3.org/2001/XMLSchema-instance">
<Name>Claims</Name>
<DataSourceID>a4687848-e640-49e1-b479-
É¥962314bea</DataSourceID>
<ConnectionProperties>
<Extension>SQL</Extension>
<ConnectString>data source=db;initial catalog=Claims</ConnectString>
</ConnectionProperties>
</RptDataSource>
"Lee" wrote:
> There are other threads on this forum for "deserialization failed" and
> some of the responses (some from MSFT folks) seem to suggest that the
> report designer sometimes creates invalid XML (which is what the RDS
> files contain). Can you post the contents of one of the RDS files that
> produces the error? Preferably the one that gave you the message you
> posted earlier...I would guess that (4,4) is a line number and position
> reference and that may help us find the problem.
>|||Looks like you've got a corrupted GUID between your <DataSourceID> and
</DataSourceID> tags. The portion to the right of the 4th hyphen
should be a string of 12 characters made up of any combination of 0
through 9 and/or a through e (case-insensitive). Instead, it looks
like some non-printing characters got in there somehow (as evidenced by
the little square immediately after the 4th hyphen). This GUID was
probably produced by Visual Studio when you defined the data source
(i.e., the .rds). It's anybody's guess as to how it got corrupted.
Anyway, all you care about is fixing it...you could try to replace the
entire GUID (i.e., everything between the <DataSourceID> and
</DataSourceID> tags) with a new GUID you generate yourself (choose
Tools | Create GUID in Visual Studio), but the safer approach may be to
delete the data source (i.e., the .rds) and recreate it (with the same
name, etc., so your reports will still work).|||Hello Cadel,
I just wanted to check back with you on the status of this issue. Please
don't hesitate to contact us if you have any further questions or concerns.
Thanks very much, and have a great weekend!
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Rdl files on SourceSafe
>thread-index: AcYVLugG5aBk+6DmRSKkEhRPzSx0NQ==>X-WBNR-Posting-Host: 204.87.106.66
>From: =?Utf-8?B?TWlrZSBM?= <Cadel@.nospam.nospam>
>References: <9369838B-3C59-4BAD-AB21-90F42C375AC7@.microsoft.com>
<szZS6QaEGHA.2660@.TK2MSFTNGXA02.phx.gbl>
<B592D9E9-8504-4634-B688-230942D12718@.microsoft.com>
<1136487927.680465.74720@.z14g2000cwz.googlegroups.com>
<F018555D-9444-4F85-9E35-4E29573C51ED@.microsoft.com>
<1136584470.444321.281380@.f14g2000cwb.googlegroups.com>
>Subject: Re: Rdl files on SourceSafe
>Date: Mon, 9 Jan 2006 07:11:03 -0800
>Lines: 23
>Message-ID: <F36CF917-EFCE-4E0D-8D79-22CCDBEDF5D6@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:66418
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
><?xml version="1.0" encoding="utf-8"?>
><RptDataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>xmlns:xsi="">http://www.w3.org/2001/XMLSchema-instance">
> <Name>Claims</Name>
> <DataSourceID>a4687848-e640-49e1-b479-
>É¥962314bea</DataSourceID>
> <ConnectionProperties>
> <Extension>SQL</Extension>
> <ConnectString>data source=db;initial catalog=Claims</ConnectString>
> </ConnectionProperties>
></RptDataSource>
>"Lee" wrote:
>> There are other threads on this forum for "deserialization failed" and
>> some of the responses (some from MSFT folks) seem to suggest that the
>> report designer sometimes creates invalid XML (which is what the RDS
>> files contain). Can you post the contents of one of the RDS files that
>> produces the error? Preferably the one that gave you the message you
>> posted earlier...I would guess that (4,4) is a line number and position
>> reference and that may help us find the problem.
>>
>|||Hope what helps?|||Hi Cadel,
You can try to add it manually to VSS.
1. Open VSS Explorer, navigate to the project folder.
2. Click the add file button on the Toolbar and add it.
Kevin Yu
======="This posting is provided "AS IS" with no warranties, and confers no
rights."|||That worked.
Thank you.
"Lee" wrote:
> Looks like you've got a corrupted GUID between your <DataSourceID> and
> </DataSourceID> tags. The portion to the right of the 4th hyphen
> should be a string of 12 characters made up of any combination of 0
> through 9 and/or a through e (case-insensitive). Instead, it looks
> like some non-printing characters got in there somehow (as evidenced by
> the little square immediately after the 4th hyphen). This GUID was
> probably produced by Visual Studio when you defined the data source
> (i.e., the .rds). It's anybody's guess as to how it got corrupted.
> Anyway, all you care about is fixing it...you could try to replace the
> entire GUID (i.e., everything between the <DataSourceID> and
> </DataSourceID> tags) with a new GUID you generate yourself (choose
> Tools | Create GUID in Visual Studio), but the safer approach may be to
> delete the data source (i.e., the .rds) and recreate it (with the same
> name, etc., so your reports will still work).
>

Wednesday, March 7, 2012

rda.push error

Im using the rda.push to push the data back to the SQL SERVER.

My SQL table is OrderDetail with a blank data inside?

My push was unseccessful due to the follow error, can any one help?

[code]

rda.Push("OrderDetail", rdaOleDbConnectString, RdaTrackOption.TrackingOffWithIndexes)

[/code]

Error message:The table is not a tracked table

Any one got an idea of this problem, thanks!|||

You can only do RDA Push on table that has been RDA Pulled with Tracking ON.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

rda.push error

Im using the rda.push to push the data back to the SQL SERVER.

My SQL table is OrderDetail with a blank data inside?

My push was unseccessful due to the follow error, can any one help?

[code]

rda.Push("OrderDetail", rdaOleDbConnectString, RdaTrackOption.TrackingOffWithIndexes)

[/code]

Error message:The table is not a tracked table

Any one got an idea of this problem, thanks!|||

You can only do RDA Push on table that has been RDA Pulled with Tracking ON.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

RDA SQL MOBILE ERROR 28037 HResult = -2147012867

I am modifying the aplication to visual.net from visual studio 2005 but I have problems ( in this moment i working in my pc , with sql 2000 personal ,windows xp , sql mobile and pc pocket emulator for window ce 5.0)

I don't know but i can't make the Pull in the server.

1) the http://localhost/driver2005/sqlcesa30.dll?diag is correct

2) I don't have the windows firewall

3)the anonimous user have all the permition in the virtual directory..

Where is the error ?

Thanks

Have you granted permissions on the database itself for the anonymous IIS account (IUSR_{yourservername}) ?

You are experiencing a permissions problem between the ISAPI DLL that brokers RDA (sqlcesa30.dll) and SQL Server with this error.

-Darren

|||

Yes,in the IIS the ISAPI dll are allows and the anonymous account has total access in th database.

the problems continue, but in this moment the error is the 28017 with the Message = "An incorrect or unsupported HTTP function call was made."

Thanks

|||I found the solution . The problems was that the sqlcesa30.dll must be int the wwwroot directory.|||I am also facing the same problem, infact i copied the dll file into wwwroot directory but still getting the same error 'in correct or unsupported HTTP function call was made'.
Can you please help me ...
this error is quite frustating

RDA SQL MOBILE ERROR 28037 HResult = -2147012867

I am modifying the aplication to visual.net from visual studio 2005 but I have problems ( in this moment i working in my pc , with sql 2000 personal ,windows xp , sql mobile and pc pocket emulator for window ce 5.0)

I don't know but i can't make the Pull in the server.

1) the http://localhost/driver2005/sqlcesa30.dll?diag is correct

2) I don't have the windows firewall

3)the anonimous user have all the permition in the virtual directory..

Where is the error ?

Thanks

Have you granted permissions on the database itself for the anonymous IIS account (IUSR_{yourservername}) ?

You are experiencing a permissions problem between the ISAPI DLL that brokers RDA (sqlcesa30.dll) and SQL Server with this error.

-Darren

|||

Yes,in the IIS the ISAPI dll are allows and the anonymous account has total access in th database.

the problems continue, but in this moment the error is the 28017 with the Message = "An incorrect or unsupported HTTP function call was made."

Thanks

|||I found the solution . The problems was that the sqlcesa30.dll must be int the wwwroot directory.|||I am also facing the same problem, infact i copied the dll file into wwwroot directory but still getting the same error 'in correct or unsupported HTTP function call was made'.
Can you please help me ...
this error is quite frustating

RDA SQL MOBILE ERROR 28037 HResult = -2147012867

I am modifying the aplication to visual.net from visual studio 2005 but I have problems ( in this moment i working in my pc , with sql 2000 personal ,windows xp , sql mobile and pc pocket emulator for window ce 5.0)

I don't know but i can't make the Pull in the server.

1) the http://localhost/driver2005/sqlcesa30.dll?diag is correct

2) I don't have the windows firewall

3)the anonimous user have all the permition in the virtual directory..

Where is the error ?

Thanks

Have you granted permissions on the database itself for the anonymous IIS account (IUSR_{yourservername}) ?

You are experiencing a permissions problem between the ISAPI DLL that brokers RDA (sqlcesa30.dll) and SQL Server with this error.

-Darren

|||

Yes,in the IIS the ISAPI dll are allows and the anonymous account has total access in th database.

the problems continue, but in this moment the error is the 28017 with the Message = "An incorrect or unsupported HTTP function call was made."

Thanks

|||I found the solution . The problems was that the sqlcesa30.dll must be int the wwwroot directory.|||I am also facing the same problem, infact i copied the dll file into wwwroot directory but still getting the same error 'in correct or unsupported HTTP function call was made'.
Can you please help me ...
this error is quite frustating

RDA Select statement...

I have attempted to perform the pull operation by using a select statement that references more than one table.... Unfortunately I get an error saying I can't do this....?

I guess I don't understand....I'm pulling full rows from only one table in the statement....I'm only using a join and where clauses to partition the number of rows that are returned. It would seem to me that RDA shouldn't care how I'm requesting the rows...just that I'm asking for entire rows from one table...?

So my select would be something like....

Select Table1.col1, Table1.col2, ...Table1.colx From Table1 Left Outer Join Table2 On Table1.col1=Table2.col3 WHERE Table1.Colx=username

I guess this type of thing can't work with RDA? If it can....how do I go about it?

Thanks

I would be inclined to try a stored procedure or view in SQL Server

For the view this would be:

SELECT col1, col2, col3 from myview where col1=myval1

Brian|||I tried the view...but still no luck with tracking on.

RDA push error

While trying to push a tracked table using RDA.push, I get the following error:

Error Code: 80004005

The message cannot be built. The make message failed.

Minor Err: 28581

Source: Microsoft SQL server 2005 Mobile Edition.

All other tables in the database are getting pulled and pushed correctly. This table is different only in the larger number of columns, around 150. It has a primary key, no other constraints.

Any help to find the reason for this error will be greatly appreciated.

- Paul

As far as I remember there was a bug around when you have more than 128 columns. This got fixed later in the SP1.

Thanks,

Laxmi

|||

Thanks. Laxmi.

SQL server 2005 SP1 was indeed missing, and I installed it. But now the Pull fails, with same error code, and minor error 0. Still investigating what is happening.

Thanks,

Paul

|||

Hi,

The problem persists with SQL server 2005 SP1. Any other idea please?

- Paul

|||

Sorry I should have been more clear when I have said SP1. What I meant was SQL Server Mobile/Everywhere/Compact SP1 and not SQL Server SP1. Please visit the URL below to get you more details on SQL Server Mobile/Everywhere/Compact SP1.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=774655&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

I see this message from time to time in my replication thread, and shortly afterwards processes using the SDF file will start complaining that it has been corrupted.

Here is the stack trace that I receive:

28037 : A request to send data to the computer running IIS has failed. For more information, see HRESULT.

28581 : The message cannot be built. The Make Message failed.

at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()

at System.Data.SqlServerCe.SyncAsyncResult.BeginSyncAndStatusReporting()

at System.Data.SqlServerCe.SyncAsyncResult.SyncThread()

The only thing that I can think of that is unusual is that one of my tables has nearly 1,000,000 rows in it. I have no more than 16 columns in any table. My large table has only 7 columns.

What exactly does the message mean? Would this be causative of my sdf corruption problems, or symptomatic?

How can I determine what SP's have been installed so I can give you better information?

Thanks,

David Johnson

RDA push error

While trying to push a tracked table using RDA.push, I get the following error:

Error Code: 80004005

The message cannot be built. The make message failed.

Minor Err: 28581

Source: Microsoft SQL server 2005 Mobile Edition.

All other tables in the database are getting pulled and pushed correctly. This table is different only in the larger number of columns, around 150. It has a primary key, no other constraints.

Any help to find the reason for this error will be greatly appreciated.

- Paul

As far as I remember there was a bug around when you have more than 128 columns. This got fixed later in the SP1.

Thanks,

Laxmi

|||

Thanks. Laxmi.

SQL server 2005 SP1 was indeed missing, and I installed it. But now the Pull fails, with same error code, and minor error 0. Still investigating what is happening.

Thanks,

Paul

|||

Hi,

The problem persists with SQL server 2005 SP1. Any other idea please?

- Paul

|||

Sorry I should have been more clear when I have said SP1. What I meant was SQL Server Mobile/Everywhere/Compact SP1 and not SQL Server SP1. Please visit the URL below to get you more details on SQL Server Mobile/Everywhere/Compact SP1.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=774655&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

I see this message from time to time in my replication thread, and shortly afterwards processes using the SDF file will start complaining that it has been corrupted.

Here is the stack trace that I receive:

28037 : A request to send data to the computer running IIS has failed. For more information, see HRESULT.

28581 : The message cannot be built. The Make Message failed.

at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()

at System.Data.SqlServerCe.SyncAsyncResult.BeginSyncAndStatusReporting()

at System.Data.SqlServerCe.SyncAsyncResult.SyncThread()

The only thing that I can think of that is unusual is that one of my tables has nearly 1,000,000 rows in it. I have no more than 16 columns in any table. My large table has only 7 columns.

What exactly does the message mean? Would this be causative of my sdf corruption problems, or symptomatic?

How can I determine what SP's have been installed so I can give you better information?

Thanks,

David Johnson

RDA push error

While trying to push a tracked table using RDA.push, I get the following error:

Error Code: 80004005

The message cannot be built. The make message failed.

Minor Err: 28581

Source: Microsoft SQL server 2005 Mobile Edition.

All other tables in the database are getting pulled and pushed correctly. This table is different only in the larger number of columns, around 150. It has a primary key, no other constraints.

Any help to find the reason for this error will be greatly appreciated.

- Paul

As far as I remember there was a bug around when you have more than 128 columns. This got fixed later in the SP1.

Thanks,

Laxmi

|||

Thanks. Laxmi.

SQL server 2005 SP1 was indeed missing, and I installed it. But now the Pull fails, with same error code, and minor error 0. Still investigating what is happening.

Thanks,

Paul

|||

Hi,

The problem persists with SQL server 2005 SP1. Any other idea please?

- Paul

|||

Sorry I should have been more clear when I have said SP1. What I meant was SQL Server Mobile/Everywhere/Compact SP1 and not SQL Server SP1. Please visit the URL below to get you more details on SQL Server Mobile/Everywhere/Compact SP1.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=774655&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI

|||

I see this message from time to time in my replication thread, and shortly afterwards processes using the SDF file will start complaining that it has been corrupted.

Here is the stack trace that I receive:

28037 : A request to send data to the computer running IIS has failed. For more information, see HRESULT.

28581 : The message cannot be built. The Make Message failed.

at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()

at System.Data.SqlServerCe.SyncAsyncResult.BeginSyncAndStatusReporting()

at System.Data.SqlServerCe.SyncAsyncResult.SyncThread()

The only thing that I can think of that is unusual is that one of my tables has nearly 1,000,000 rows in it. I have no more than 16 columns in any table. My large table has only 7 columns.

What exactly does the message mean? Would this be causative of my sdf corruption problems, or symptomatic?

How can I determine what SP's have been installed so I can give you better information?

Thanks,

David Johnson