Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts

Monday, March 26, 2012

ReportViewer :: Failed to enable constraints. But my statement is valid!

An error has occurred during report processing.Exception has been thrown by the target of an invocation.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Why do I keep getting this error, even when not using any data on the report. When I run the query in SQL server I get a resultset. However when I try to render the report I get this error.

Thanks!

I'm not using Report Services for the data I use in my reports, but when I get this error in my Report Viewer controls it's because VS carried over the primary keys from source views when I created my SQL Server table adapters.

To remedy this, I open the dataset file I'm using in my VS project and find the table adapter I'm using as my data source for the problematic report. If there are keys next to any columns (thereby marking them as primary keys in the table adapter), I right click one of the columns and select "Delete Key". I make sure all the keys are removed and then save the file and try the report again. This has fixed it every time (and every time this happened, the error never showed when I previewed the data in VS or in SQL Server itself - only when I tried to render the report from my site. Quite maddening.).

Hope this works for you, too . . .

|||

What a man!!! Worked a treat. Thanks

M

Friday, March 23, 2012

reportserver login failed

Hello
I have a report server running on a win2003 sp1 domain controller. The
reportServer database is sql2005 sp2 also running on the domain controller.
Now I´m trying to configure a report. The reports datasource is a SqlServer
2000 database also running on the domain controller
The connection string is "Data Source=localhost;Initial Catalog=MyDataDB"
If I try to run the report I´ve got a login error (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at
this computer. (Exception from HRESULT: 0x80070569)
I think it isn´t the connection to the sql2000 database because I have tried
to prompt the user to type credentials. The same error
Any ideas?
regards
BjörnFound it.
Had to allow the user to login local
Björn
"Berger" <prodevteam@.gmx.net> schrieb im Newsbeitrag
news:OzxacToCIHA.4472@.TK2MSFTNGP05.phx.gbl...
> Hello
> I have a report server running on a win2003 sp1 domain controller. The
> reportServer database is sql2005 sp2 also running on the domain
> controller.
> Now I´m trying to configure a report. The reports datasource is a
> SqlServer 2000 database also running on the domain controller
> The connection string is "Data Source=localhost;Initial Catalog=MyDataDB"
> If I try to run the report I´ve got a login error (rsLogonFailed)
> Logon failure: the user has not been granted the requested logon type at
> this computer. (Exception from HRESULT: 0x80070569)
> I think it isn´t the connection to the sql2000 database because I have
> tried to prompt the user to type credentials. The same error
> Any ideas?
> regards
> Björn
>

Friday, March 9, 2012

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkI have same probleme, anybody have the solution'
"Henrik Juel" <hjh@.gbs.dk> a écrit dans le message de
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Have you added the <ReportServerExternalURL> tag to the
c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
rswebapplication.config file as below?
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
ernalURL>
</UI>
Ken
"Henrik Juel" <hjh@.gbs.dk> wrote in message
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Hello Ken
After reading others posting about this topic, I have tried the tag
<ReportServerExternalURL>. But it made no difference. I belive in this setup
there is a ok connection from the reportmanager to the reportserver.
"Ken" wrote:
> Have you added the <ReportServerExternalURL> tag to the
> c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
> rswebapplication.config file as below?
> <Configuration>
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
> ernalURL>
> </UI>
> Ken
> "Henrik Juel" <hjh@.gbs.dk> wrote in message
> news:clsmdo$2bti$1@.news.cybercity.dk...
> > I works fine when I run from our lan by a IIS virtual directory. But using
> > reportmanager from a IIS application outside the lan as a true
> > webapplication, the reportmanager produce wrong paths for controls. E.x.
> > http://images/48folderopen.jpg There should have been a domain in front of
> > /images. I haven't been able to find any parameters in config's to meet
> this
> > problem.
> >
> > Regards
> >
> > Henrik Juel
> > GBS A/S
> > Denmark
> >
> >
>
>

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkHi Henrik,
Thanks for your post.
From your descriptions, I understood that you could not access your Report
Manager via Internet while it's OK for intrannet. Have I understood you?
Correct me if i was wrong.
Based on my scope, it seems you should modify your <ReportServerUrl> Tag
for the remote access. Go look at the Report Manager configuration
file,RSWebApplication.config. There is a UI section
<UI>
<ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
>
</UI>
Change it to
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
or you could find another way in charpter "Deploying a Report Server for
Internet Access" under Topic "Enterprise Deployment Model" in Reporting
Services Books Online.
Last but not the least, make sure you follow the security practices before
you opening the Internet Access:)
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
Thanks for your instant answer. And yes you do understand me.
I haved tried the <ReportServerVirtualDirectory> tag in the
RSWebApplication.config file but it didn't made any difference to this
problem. I have read the chapter in the online book as I have read about
this topic in my Wrox book. I was not able to find this issue.
When starting the reportmanager from http://rs.gbs.dk the reportmanager
application do have connection to the reportserver, as it is able to show
folders, but fail to work with fully urls. E.x. the image problem stated
earlier.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> Thanks for your post.
> From your descriptions, I understood that you could not access your Report
> Manager via Internet while it's OK for intrannet. Have I understood you?
> Correct me if i was wrong.
> Based on my scope, it seems you should modify your <ReportServerUrl> Tag
> for the remote access. Go look at the Report Manager configuration
> file,RSWebApplication.config. There is a UI section
> <UI>
> <ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
> >
> </UI>
> Change it to
> <UI>
> <ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
> </UI>
> or you could find another way in charpter "Deploying a Report Server for
> Internet Access" under Topic "Enterprise Deployment Model" in Reporting
> Services Books Online.
> Last but not the least, make sure you follow the security practices before
> you opening the Internet Access:)
> Hope this helps and if you have any questions or concerns, don't hesitate
> to let me know. We are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>|||Hi Henrik,
If the Report Manager and Report Server are on the same machine then remove
the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
in the config file - and replace with <ReportServerVirtualDirectory>
Let me know whether this works
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
Both applications are on the same machine.
And I have only the <ReportServerVirtualDirectory> tag in the
rswebapplication.config.
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
I have created a virtual directory in the reportmanager root, which point to
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
where the server originally is installed.
So I belive It doesn't work.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> If the Report Manager and Report Server are on the same machine then remove
> the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
> in the config file - and replace with <ReportServerVirtualDirectory>
> Let me know whether this works
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>
>
>
>|||Hi Henrik,
First of all, I need to confirm that how do get the following link. Is it
in report manager when he right click a image->Properties to see the link
of the image? http://images/48folderopen.jpg
Secondly, please make sure that 'images' are in the IIS manager the image
folder:
1). Expand IIS server->Web sites->Default Website->Reports->Images
2). Right click Images->Properties->Directory and check if "The designated
directory" is used and "reports\images" is listed.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
1. Yes I have the http://images/48folderopen.jpg from right clicking a image
in reportmanager.
2. The IIS settings are as you describe
You are welcome to contact me on +45 20282851 or on email : hjh@.gbs.dk for a
login to http://rs.gbs.dk
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> First of all, I need to confirm that how do get the following link. Is it
> in report manager when he right click a image->Properties to see the link
> of the image? http://images/48folderopen.jpg
> Secondly, please make sure that 'images' are in the IIS manager the image
> folder:
> 1). Expand IIS server->Web sites->Default Website->Reports->Images
> 2). Right click Images->Properties->Directory and check if "The designated
> directory" is used and "reports\images" is listed.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Henrik,
Looking at the nature of this issue, I am afraid we need more time
researching on this issue and this issue was critical to your business, I
would like to suggest you open an incidnet call with Microsoft Support
Professional through Microsoft Product Support Services. You can contact
Microsoft Product Support directly to discuss additional support options
you may have available, by contacting us at 1-(800)936-5800 or by choosing
one of the options listed at
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, I want to set
your expectations that the issue might take a long time to narrow down.
During the course of troubleshooting, we may redirect you to PSS if
required.
For now, I doubt it might be a IIS issue instead of Reporting Services one
and please let me know the answers for the following questions
1. If you are browsing the Report Manager *Locally* via domain name
(http://rs.gbs.dk), will it shows as expected?
If you are browsing via domain name within the intrannet, will it shows as
expected?
2. Open the Web site property,
Click Advanced Button in Web site identification of Web Site Tab
Select Default in Multiple identities for the Web site, Click Edit...
Let me know whether there is anything in the Host Header value
3. Is it possible for you to post IIS logs here? You could also send it to
me if you think it was critical for your business. My email address was
v-mingqc@.online.microsoft.com (please remove "online", it's only for SPAM,
thanks:-)
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Henrik,
I am currently standing by for an update from you and would like to know
how things are going there. Should you have any questions or concerns on
the recent questions/ information I've posted, please don't hesitate to let
me know directly. It's my pleasure to be of assistance
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I have sent my reponse on your emailaddres v-mingqc@.online.microsoft.com
"removed online" for some weeks ago. Looking forward to your answer.
regards Henrik
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> I am currently standing by for an update from you and would like to know
> how things are going there. Should you have any questions or concerns on
> the recent questions/ information I've posted, please don't hesitate to let
> me know directly. It's my pleasure to be of assistance
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Henrik,
I am sorry that I have never received email from you :-(
May I ask your favor to resend the email?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Wednesday, March 7, 2012

ReportIoError 2 - Further Info

Context
--
The first of the failed log backups was run after a series
of indexes on the database were rebuilt.
Recovery mode is changed to "bulk-logged" before rebuiding
indexes. This is followed by the log backup and then
recovery mode is changed back to "full".
Additional Error Messages in SQL Server Log
---
BackupMedium::ReportIoError: write failure on backup
device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
system error 2(error not found).
Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
0x3BE50000, Size: 65536, Position: 4293497344, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
\backup\Proclaim_backup.bak
BACKUP failed to complete the command BACKUP LOG
[Proclaim] TO DISK = N'D:\mssql7
\backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMATHi Kim,
When ever you perform a recovery model change, it is always suggested to do
a full database backup and
then goahead with Transaction log backup.
This I/O issue can araises due to free space in hard disk, permissions on
the disk.
Thanks
Hari
MCDBA
"Kim" <anonymous@.discussions.microsoft.com> wrote in message
news:25bce01c46248$42024970$a601280a@.phx
.gbl...
> Context
> --
> The first of the failed log backups was run after a series
> of indexes on the database were rebuilt.
> Recovery mode is changed to "bulk-logged" before rebuiding
> indexes. This is followed by the log backup and then
> recovery mode is changed back to "full".
>
> Additional Error Messages in SQL Server Log
> ---
> BackupMedium::ReportIoError: write failure on backup
> device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
> system error 2(error not found).
> Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
> 0x3BE50000, Size: 65536, Position: 4293497344, UMS:
> Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
> OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
> m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
> \backup\Proclaim_backup.bak
> BACKUP failed to complete the command BACKUP LOG
> [Proclaim] TO DISK = N'D:\mssql7
> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
> NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT|||Thanks for the suggestion.
I'll add a full backup to the scheduled job before and
after the recovery mode change and see if the issue
persists.

ReportIoError 2 - Further Info

Context
The first of the failed log backups was run after a series
of indexes on the database were rebuilt.
Recovery mode is changed to "bulk-logged" before rebuiding
indexes. This is followed by the log backup and then
recovery mode is changed back to "full".
Additional Error Messages in SQL Server Log
BackupMedium::ReportIoError: write failure on backup
device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
system error 2(error not found).
Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
0x3BE50000, Size: 65536, Position: 4293497344, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
\backup\Proclaim_backup.bak
BACKUP failed to complete the command BACKUP LOG
[Proclaim] TO DISK = N'D:\mssql7
\backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT
Hi Kim,
When ever you perform a recovery model change, it is always suggested to do
a full database backup and
then goahead with Transaction log backup.
This I/O issue can araises due to free space in hard disk, permissions on
the disk.
Thanks
Hari
MCDBA
"Kim" <anonymous@.discussions.microsoft.com> wrote in message
news:25bce01c46248$42024970$a601280a@.phx.gbl...
> Context
> --
> The first of the failed log backups was run after a series
> of indexes on the database were rebuilt.
> Recovery mode is changed to "bulk-logged" before rebuiding
> indexes. This is followed by the log backup and then
> recovery mode is changed back to "full".
>
> Additional Error Messages in SQL Server Log
> BackupMedium::ReportIoError: write failure on backup
> device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
> system error 2(error not found).
> Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
> 0x3BE50000, Size: 65536, Position: 4293497344, UMS:
> Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
> OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
> m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
> \backup\Proclaim_backup.bak
> BACKUP failed to complete the command BACKUP LOG
> [Proclaim] TO DISK = N'D:\mssql7
> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
> NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT
|||Thanks for the suggestion.
I'll add a full backup to the scheduled job before and
after the recovery mode change and see if the issue
persists.

Monday, February 20, 2012

Reporting Services: Deserialization Failed

Hi,

I have an SSRS 2000 report which has been unchanged in months. I've been asked to make a few changes and when i attempt to open the report in VS.net 2003 i get the following warning and error message.

Warning 1 Deserialization failed: The table "table1" has rows with a different number of cells than the number of the columns in the table (including cells that span more than one column). Line 9, position 23479. 9 0

Error 2 [rsWrongNumberOfTableCells] The table ‘table1’ has rows that contain a different number of cells than the number of the columns in the table (including cells that span more than one column). C:\Documents and Settings\Leigh.Moore.VETS4PETS\My Documents\Visual Studio 2005\Projects\Report Project1\Report Project1\Daily Sales - Invoiced.rdl 0 0

Has anyone come across this problem and can anyone suggest how i rectify it as i really don't want to have to create the report from scratch.

Thanks in advance,

Leigh.

I come accross this problem everytime I try to edit the sql query in the rdl.

Reporting Services: Deserialization Failed

Hi,

I have an SSRS 2000 report which has been unchanged in months. I've been asked to make a few changes and when i attempt to open the report in VS.net 2003 i get the following warning and error message.

Warning 1 Deserialization failed: The table "table1" has rows with a different number of cells than the number of the columns in the table (including cells that span more than one column). Line 9, position 23479. 9 0

Error 2 [rsWrongNumberOfTableCells] The table ‘table1’ has rows that contain a different number of cells than the number of the columns in the table (including cells that span more than one column). C:\Documents and Settings\Leigh.Moore.VETS4PETS\My Documents\Visual Studio 2005\Projects\Report Project1\Report Project1\Daily Sales - Invoiced.rdl 0 0

Has anyone come across this problem and can anyone suggest how i rectify it as i really don't want to have to create the report from scratch.

Thanks in advance,

Leigh.

I come accross this problem everytime I try to edit the sql query in the rdl.