We have an issue when emailing a report that contains external images.
When the email recipient receives the report the images appear broken.
Although when we check the report in the report server it displays correctly and all images are intact.
We also noticed that if we manually "export" the report to the MHTML format the images appear broken but if we immediately export the report again the images appear perfectly. (the report must be exported to MHTML twice in order to work. This has been verified and is repeateable)
It is almost as if the MHTML format cannot reference the images fast enough to include them in the report on the first try. But, it is able to do so on the second attempt...
We would rather use external images as we have 700+ reports and manually updating embedded images takes quite a while. Then we can update a single image to change all reports.
I've got a real problem with inserting images into report. The problem is that I work with Reporting Services and SharePoint Portal. My employer wants to have CV created dynamically. Information for CV is taken from database under special account with read-only access. And photos of employees can be found with URL http://corporate-site/Resources/Team/Name_surname.jpg (this string is also generated dynamically). When I preview report on my local machine, everything is Ok, I can see the images. But when deployed the images are not displayed. I have created an Unattended Report Processing Account to get photos. But if I want to use it I must change account for reading data from Data Source (in my case it is SharePointDB.rds) for €œCredentials are not required€?. And after it I can't get the information for CV. Does someone know how to use one account for database and another one for getting external image? Or maybe there is another solution for this problem?
Hello, I tried to use an image from a url and got the error: "[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access."
I found a link in the MSDN about that that explain how to configure the UnattendedExecutionAccount: http://msdn2.microsoft.com/en-us/library/ms156302.aspx
But even after I configure it and use my user and password (I'm an admin) I still can't see the images.
I have developed on winodws based application using C# in .NET. I am connecting from my database using internet, means my database kept on remote location. I have to save images in DB because I can't save and access images in external folder from remote location. In this situation my DB is growing very fast. Is there any other alternative to work on this requirement or compress image in any format so that I can reduce DB size.
Hi, I am trying to import an excel spreadsheet to the sql server database, I have 7 spreadsheets. in that 6 of them work fine, but when i try to import the 7th i am getting and error called External Table is not in the expected format System.Data.OleDb.OleDbException: External table is not in the expected format
Hi, I am facing a different problem when MHTML report is exported, this happens in alternatve requests, but when I save the file report is proper.The only problem is when I click on Open button , it pops another dialouge with
Name: wbk3E.tmp Type: HTML DOcument From :mhtml:http://localhost/riq/web/UI/RunReports.aspx
wbk3E.tmp file is not displaying any report data, I am not getting what happens when I click on Open button..The same code is working on first request and its alternative requests fails to show the report...I don't have any problem with CSV and XML exports.
Please suggest me what is the problem in opening the report on Even open clicks. The below lines of code that renders the report.
I am having a problem with MMSQL BLOB with VB, Sorry to say I am new in Programming using VB 6 and MSSQL and I have never touch BLOB in my live.
I just wish anyone could give me any ideal, like, white pages, or manual on how do I insert BLOB data (Images) to MSSQL 2000 database using VB 6. I need to know exspecially the VB Code and the SQL Portion if you have a store procedure code for that it will be nice. :confused:
Hi I have a problem, when i do a select records from the production server which is situated in melbourne,around 20,000 records need to be fetched but sunddenly after 13,000 records the connection is broken why is this heppening what is the cause for this how to overcome this pls let me know asap with the evidence thanks venkat
Hi , I am running a process from from my client having TCP/IP sockets connected to WIN NT sql server 7.0. I get a error msg [MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKETS]ConnectionCheckForData (null())). Connection Broken .
The same thing happened in other NT SQL server as well,but it is ran o.k if i run from the server itself. Checked Microsoft documents they advised me to use Named Pipes and to check the client and server network utility. Check every detail but still facing same errors. Can anyone provide an solution for this.
As we have just got SQL at work I had decided to play with SQL on my home computer to find out what made it tick.
I am using the 120 day demo enterprise version. While playing in the user accounts area (under security) I denied access to the database on the guest account (like you disable the guest account on domain logins) and (if you have not guessed already) I can't get access to the server anymore. I did try reinstalling but I guess that there are still some settings in the registry that don't get deleted. Any suggestions how I can get back in.
My PC at home is a XP home edition, no domain etc. SQL was installed onto the PC and I was accessing (playing with it on this PC). The setup I was playing with has no data (except what comes with the SQL) so I am not worried about losing anything.
CREATE INDEX [NC_DateAcctTotal] ON [dbo].[BilledPackages] ([pu_date], [acct_no], [delete_flag], [billing_weight_charge]) WITH FILLFACTOR = 90 ON [PRIMARY]
::::: ERROR ::::
Server: Msg 823, Level 24, State 2, Line 1 I/O error (torn page) detected during read at offset 0x000006d5f2c000 in file 'E:MSSQLDataManagement_Data2_Data.NDF'. Connection Broken
I am trying to set up a filtered paging ObjectDataSource for a gridvoew control.
My code works, my query doesn't...
This is OK: Get all rows of data: "SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes " Returns all records as expected
This is OK: Getting rows of data with no Filter: "SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE Row >= 0 AND Row <= 10" Returns expected data
This is OK: Making sure my WHERE filter works: "SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes WHERE country_name LIKE '%u%' " Returns 85 records
This is BROKEN!!!: I want to return 10 rows of filtered data: "SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE ( Row >= 0 AND Row <= 10 ) AND ( country_name LIKE '%u%' ) " It Returns 0 records!!!
What am I doing wrong in the last query? Or even better how do I fix it?
I have had countless email alerts thru today alerting me to people replying to threads I have commented on. And I can see the person's comments.
1) WhenI click on the link it takes me to a page saying the post doesn't exist
2) When I try and browse to the thread manually I can't see the reply.
3) On one occasion I replied to one of these threads asking if someone had posted something and then deleted it. After I submitted the post I could see all the other posts in the thread which were supposedly missing before. The next time I browse to the thread (in a new browser window) I can't see any of the posts.
BROKEN!!!! I for one won't be coming back here until they fix it. Its pathetic.
I have posted something on the bug report forum by the way.
I downloaded and registered Visual Studio Express Edition. I got this nice email back with links to demos, tutorials, and starter kits. Unfortunately, the links to most of the starter kits are broken. Can I still get these things?
While performing a restore, one of the transaction logs was apparently corrupt. So the database gets partially restored with an error saying :
Backup or restore operation successfully processed 1 pages in 0.505 seconds Processed 6 pages for database 'royal', file 'royal_Log' on file 1. Server: Msg 9004, Level 21, State 2, Line 1 The log for database ' ' is corrupt. ODBC: Msg 0, Level 16, State 1 Communication link failure
Can anyone give me some tips how to restore? any help appreciated. bye Eva
Hi there, wasn't quite sure where to put this but I still regard myself as a bit of an SQL Server noob so thought it'd be ok here....hopefully?! lol
Right....I have a database called CDR and a Login set up for this on the server called CDMLogin. The CDR database is a non-live backup of another database stored elsewhere. In order to update this for testing purposes I needed to make a backup of the live database and then do a 'restore database' over the top of the old CDR one. This has worked fine before.....however, on this occasion, the link between the CDR database and the CDMLogin appears to have been broken. I have since read about how this can be an issue when restoring databases but I have still not found a fix. Any ideas?
Version: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
Problem:
Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 515532920. The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 515532920. The text, ntext, or image node at page (1:377447), slot 1, text ID 897100939264 is not referenced. <... and 4 same errors>
DBCC results for 'CC_Document'. The repair level on the DBCC statement caused this repair to be bypassed. <same messages>
The repair level on the DBCC statement caused this repair to be bypassed. There are 192 rows in 6 pages for object 'CC_Document'. CHECKTABLE found 0 allocation errors and 8 consistency errors in table 'CC_Document' (object ID 515532920). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (crmproded.dbo.CC_Document repair_fast).
I won't run checktable with 'repair_allow_data_loss' before all records aren't find out
Child fragment at Page (1:377237) Slot 0 Offset: 8080
Child fragment at Page (1:377238) Slot 0 Offset: 16160
Child fragment at Page (1:377239) Slot 0 Offset: 24240
Child fragment at Page (1:377288) Slot 0 Offset: 32320
Child fragment at Page (1:377289) Slot 0 Offset: 36572
There are 5 links at Slot 1 , that's generate error. But why? What does it mean - "The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced" ???
I saw other pages (not 'broken') - there is: Blob Fragment don't contains links - links are in other pages.
What are these 'broken' records in my example - they are chunks of lost information, that i can't recover?
Or not? May be exists a way, that i find all 'broken' records? Because, my table contains 192 records. But there is BLOB field - and i can't check consistency of every file, that uploaded in my table. In addition I will fully appreciate this problem.
At last, if i find record, i run checktable with repair_allow_data_loss, then upload file again.
I have a SSIS which have a user string variable named connectionstring. In the package definition it has empty value. But in my package.dtsconfig file I set the value of this variable.
But I am not getting the value inside a script component. I tried debugging with a msgbox echoing the variable value ... but I see only empty value i.e. at runtime the value is not being read from config file
What can be wrong here?
next if I put the value ("Data Source=<Server>;Initial Catalog=<Database>;Integrated Security=True;") in the variable definition itself I get the following error
[Execute SQL Task] Error: Failed to acquire connection "<ADO Connection>". Connection may not be configured correctly or you may not have the right permissions on this connection.
The SSIS was running fine previously ... it broke after I updated by machine with the latest windows updates today.
I am working on a 64 bit Windows 2003 SP1 Server box with Visual Studio 2005 SP1, SQL Server 2005 SP1
I have made a chart that displays data for my company. However, when I have the report.rdl on the "live" serverand use the "live" data source, I can't get the report manager to display the chart, only the famuos x of a broken image link. If I place the report.rdl on the test server and use the "live" data source the chart is displayed.
What is the difference between having the report on the test server versus the "live" server?
Report manager -> report on test server -> live data source = working
Report manager -> report on "live" server -> live data source = no image
I dont think the problem is sequrity related, but I dont know for sure...
Running a clustered webserver, windows 2000, IIS v5, and a sql server, v2000. Using OLE Db as connection, running stored procedures, no sql created on the fly. The website handles about 5000 transaction a day.
Every now and again, we get a problem whereby an error 41 - Broken Pipe is reported. I can't find any info on this error on Technet, MSDN, etc. Google returns info, but only really affecting solaris, unix, linux, etc.
Anyone ever come across this error before? or know what might cause it? and possible resolutions?
see article: Article ID: Q216700 . Within a trigger on SQL Server 6.5 Service Pack 5 or 5a, the IF UPDATE clause will evaluate to true for all columns when an INSERT is performed, even if there is no value specified and no default value exists for the column
I'm using Crystal 9 with SQL Server database. I have a report that was working fine for the first 8 months. As soon as I add another month, the report fails. I've tried different setting in my indexes with different variations of periods. The minute I have over 8 periods included, the report fails. No errors, just no data. I don't even have a clue where to look for possible answers on the Internet.
Aim – Calculate the number of days between CreatedDate and [Date_Docs_In_Complete__c],count how many Ids, Fall within a specific month by year, and then work out the avg number of days it took for each month
My query so far
select ID, left(CreatedDate,10) as CreatedDate, left([Date_Docs_In_Complete__c],10) as [Date_Docs_In_Complete__c], DATEDIFF(day,CreatedDate,[Date_Docs_In_Complete__c]) as Days from #build
Is there somewhere that I can change the links that are included in subscription emails? The link that goes out is incorrect because the port number of the server is not included in the link, so I'd like to edit this. Does anyone know where this can be done? Thank you!
I'm having serious problem with SSIS on my development machine.
each time I try to add a new Connection manager i got this error :
TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL INFORMATION:
The connection manager 'OLEDB' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design)
This happen for any type of Connection Manager, ADO.NET, FILE,SMTP. I've already tried to uninstall SSIS , but nothing change.
I was trying to download SQL Server Management Studio Express from http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx. The links on this page seem to be broken.
I tried to download the Mgmt Studio Express by clicking on a link that points to http://go.microsoft.com/fwlink/?LinkId=65110.
Anyone else facing this issue? Is there another place I can get SQL Server Management Studio Express from?
I was wondering what the best way was to deal with subscriptions breaking due to an empty table. I have subscriptions that people have scheduled to go out daily, but on certain days the table may be empty, in this case the subscription doesn't read the parameters for the report and then the subscription breaks.
My original solution involved creating a #temp table with the same columns as the original table and inserting one row into it which I'd union with the original table, this row in the temp table had all its values set to 0. The solution worked when I ran it in SQL Server Management Studio but it seems SRS doesn't like the INSERT INTO statement, which is the error I get, but I've read on these forums that it doesn't like #temp tables either. I proceeded to use a stored procedure with all the code in it, but I might have trouble filtering on multi value parameters, because at times these parameter lists get real big, plus I have to do this for multiple reports and don't want to get into creating stored procedures for each report.
Following is what the code I used look something like that executes and does the job in Management Studio but not SRS. I'm mainly just looking for the easiest and cleanest way to do this, since it'll have to be done across multiple reports, so disregard the code if there's an easier way to do it. Thanks in advance.
create table #dummytable ( name varchar(35), country varchar(35), idnumber (int) ) GO
insert into #dummytable (name),values('0');
select name, country, idnumber from originaltable where name in (@name)
union select name = 0, country = 0, idnumber = 0 from #dummytable
The execution instance guid appears to be broken in SSIS (post SP1 hotfix is the version for this test). The package itself reports a different value at runtime than management studio does via RunningPackages.
One package execution reports two guids depending on where look. The issue is not with the PackageID or VersionGUID, but the actual runtime guid, available in the package as the system variable "System::ExecutionInstanceGUID".
ExecutionGuid via System::ExecutionInstanceGUID as reported by package script task: C825418B-E796-4EBF-BEB8-14CBEC257D81
ExecutionGuid reported by /CONSOLELOG command line parameter to dtexec C825418B-E796-4EBF-BEB8-14CBEC257D81
ExecutionGuid reported by SSIS Log Provider for text files: C825418B-E796-4EBF-BEB8-14CBEC257D81
ExecutionGuid Reported by Management Studio Running Packages Node: 4810b482-6a83-4564-8b3b-c5017a590506
ExecutionGuid reported in MsDtsSrvr.exe: 4810b482-6a83-4564-8b3b-c5017a590506
ExecutionGuid reported by GetRunningPackages(): 4810b482-6a83-4564-8b3b-c5017a590506
All the gory details are below:
Text Log:
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,(null) OnPostValidate,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,(null) PackageStart,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,Beginning of package execution. Diagnostic,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 3. OnPreExecute,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,(null) OnInformation,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,LineageID: LineageId OnInformation,JAEGD,FPSjaegd,EventGuidTest,{435383C9-F9CA-463D-8A94-F654975B5D2D},{C825418B-E796-4EBF-BEB8-14CBEC257D81},10/9/2006 9:30:54 PM,10/9/2006 9:30:54 PM,0,0x,Attempting to sleep ...
Output System::ExecutionInstanceGUID via Dts.Log() C825418B-E796-4EBF-BEB8-14CBEC257D81
Management studio Integration Services Running Packages Node: Package Name ExecGuidTest Executed By FPSjaegd Execution Instance ID 4810b482-6a83-4564-8b3b-c5017a590506 Execution Started 10/9/2006 9:30:54 PM Execution Duration 213542 Package ID 435383c9-f9ca-463d-8a94-f654975b5d2d
Value logged by msdtssrvr.exe: Registering package ExecGuidTest (435383c9-f9ca-463d-8a94-f654975b5d2d) for FPSjaegd, assigned ID 4810 b482-6a83-4564-8b3b-c5017a590506 Package ExecGuidTest (435383c9-f9ca-463d-8a94-f654975b5d2d) registered by FPSjaegd, assigned ID 4810b4 82-6a83-4564-8b3b-c5017a590506
Value available via GetRunningPackages()
GAC Version Location --- ------- -------- True v2.0.50727 C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ManagedDTS9.0.242.0__89845dcd8080cc91Micros...
I'm attempting to develop a course whose objective is to present the users with several scenarios of broken or hung databases caused by different things that they then have to fix.
Do you have any ideas or examples of how to break a database and the reasons behind it, also how to repair it afterwards !!
