.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Best way to find out if a very large PDF has rendered on a file share?

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

We are building our bill system printing process and part of the process is to generate a huge PDF to a file share with single page bills inside to print on our folding / stuffing appliance.  Currently, there is a one time subscription created on the report server that is then executed from SSIS in the form of a "Execute SQL Server Agent Job Task" which will send a PDF to a file share defined in the subscription.

We are noticing that this process can go wrong at many points and need to find a way to account for each potential problem.  We first notice that SSIS is totally unaware of almost all failures of the report subscription except the most basic failures that the SQL Server agent is aware of like the subscription being faulty or the database being down; we can capture that easily enough; but it isn't sufficient. 

SSIS executes the SSRS subscription in seconds even though it might take 45 minutes or longer to render.

After SSIS has called the subscription, we have noticed a few problems can happen.

1. A permissions issue can occur on the file share if your password expires (Failure writing file: A log on error occurred when attemp

View Complete Post

More Related Resource Links

Need to find File Share Excel Rendering time--SSRS 2008

we are using SSRS 2008 file share subscription to generate EXCEL reports,Requirement here is need to find the file rendering/completion time in order to send the excel file as attachement using xp_senddbmail. Your help is highly appreciated-- Sathish

Cant find vsi file for CSS Friendly Control Adapters


Hi guys

This is driving me crazy... I cant find the .vsi file for installing the CSS Friendly Control Adapters Project. Does anyone know where I can get this?

The following link: http://www.asp.net/cssadapters/ only leads to the CodePlex wiki where I can download the dll and a partial solution. Essentially, I'm looking for the source code to implement the Menu adapter.

Any help is much appreciated!

How do I find the file path from a namespace.class name?


I'm programatically looking ito a .aspx file and getting the file class name declared in its CodeBehind. For example, when analyzing myFile.aspx I read in its Page Directive and found its CodeBehind equals "myApplication\myPage.aspx.vb". Then I use the code below:


Dim Assm As System.Reflection.Assembly = System.Reflection.Assembly.LoadFrom("myApplication\bin\myApplication.dll")
Dim ClassType As Type = Assm.GetType("myApplication\myPage.aspx.vb")
' myBaseType = "myApplication.Forms.BasePage"
Dim myBaseType As System.Type = ClassType.BaseType


Now I want to read the BaseFile (class = myApplication.Forms.BasePage). However, to read in this file, I need I need to get its full path instead of its namespace.class hiearchy. In this case, the BasePage is wrapped in a different namespace declaration thus I cannot just change the '.' to '\' in order to get the path.

How can I get the path of BasePage so I can read it? Thank you - Frank

Error: Do you want to save this file, or find a program online to open it?



I am relatively new to MVC , i am getting the following error when i try to browse to a page in which i have used usercontrol and within the usercontrol i have a simple grid.

Error: Do you want to save this file, or find a program online to open it?

I am returning the data from the controller like this

 var jsonData = new
                    total = 1,
                    page = 1,
                    records = myRequests.Count,
                    rows = new[]{myRequests.ToArray()                 

Upload large file via webservice problem in vb.net 1.1

Hi All, I am uploading large file via webservice using below my code in vb.net 1.1. Problem is vb.net 1.1 don't know Using Object loop. I would like to know any other loop similar Using loop to replace in vb.net 1.1Public Function UploadLargeFile(ByVal FileName As String, ByVal buffer As Byte(), ByVal Offset As Long) As Boolean Dim retVal As Boolean = False Try Dim FilePath As String = Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory.ToString() & "\fpath\", FileName) If Offset = 0 Then File.Create(FilePath).Close() End If Using fs As New FileStream(FilePath, FileMode.Open, FileAccess.ReadWrite, FileShare.Read) fs.Seek(Offset, SeekOrigin.Begin) fs.Write(buffer, 0, buffer.Length) End Using retVal = True Catch ex As Exception Throw ex End Try Return retVal End Function  

using SSRS Windows File Share subscription to send file to sharepoint

Hello, I'm looking for the simplest way to automate sending SSRS reports to a Sharepoint document directory.  I know a document library is not a real directory but I am able to run copy scripts into one using the virtual path thats shown when I do Actions-> Open in Windows Explorer. However when I set up a subscription to send a report to this directory, I get an error: Failure writing file \\intranet\projects\docs\test.pdf : The network name cannot be found.  Just checking if anyone knows if this should be able to work or not. Thanks

Uploading Large File (40mb) fails... (webhttpbinding) (Azure)

I'm using javascript to upload a file to my WCF service hosted on Azure.  (40 mb file) Here is the snippets from the web.config for the service: <system.serviceModel> <bindings> <webHttpBinding> <binding transferMode="Streamed" maxBufferSize="2147483647" maxReceivedMessageSize="2147483647" openTimeout="00:25:00" closeTimeout="00:25:00" sendTimeout="00:25:00" receiveTimeout="00:25:00" name="WebConfiguration"> </binding> </webHttpBinding> </bindings> <behaviors> <endpointBehaviors> <behavior name="RestfulEndpointBehavior"> <webHttp/> </behavior> </endpointBehaviors> <serviceBehaviors> <behavior name="CPUploadServiceBehavior"> <serviceMetadata httpGetEnabled="true" httpGetUrl=""/> <serviceDebug includeExceptionDetailInFaults="false"/> </behavior> </serviceBehaviors> </behaviors> <serviceHostingEnvironment aspNetCompatibilityEnabled="true"/> <services> <service name="CPUpload" behaviorConfiguration="CPUploadServiceBehavior"> <endpoint add

Migrating large, existing company share drives to SharePoint 2010.

My company has terabytes of documents stored out on a large share drive.  In implementing SharePoint 2010, one of the great features with documents is versioning, permissions etc.  Currently I'm planning on each department to slowly upload documents to SharePoint 2010 under their department sites/site collections as it makes sense and of course create any new documents there in their site document libraries.  99% of every document uploaded to SharePoint will be from this old share drive.  Is there a better way to migrate this content into SharePoint than having people upload documents individually (or "upload multiple files")?  I know I can add the share drive to the SharePoint search results, or add links to the share drive location, but we really need the versioning on documents and have things show up in SharePoint like it normally would in a list.  Any guidance is much appreciated. Thanks!

SSIS throws error when it doesn't find file

Hello All, I am facing one issue that i dont know in advance if there is file on FTP or not. I scheduled a job which runs every hour which in turn calling SSIS package. Now, when there is file on FTP, it works fine. But, when there is no file on FTP then itthrows error which i want to handle. Is it possible to check for any files present on FTP? Cheers, Pranav

Error: 0x80070002 The system cannot find the file specified

From Windows Server 2003 Std Ed SP, 32 bit VMWare Virtual Server .Net Framework v1.1.4322 When attempting to run a hello world aspx page it fails to load returning the message "Server Application Unavailable".  The application even viewer logged the following: Event Type: ErrorEvent Source: ASP.NET 1.1.4322.0Event Category: NoneEvent ID: 1088Description:Failed to execute request because the App-Domain could not be created. Error: 0x80070002 The system cannot find the file specified. I tried to run aspnet_regiis.exe -i, rebooted but this did not work. I tried to uninstall, reboot, reinstall .net from the Windows component section of Add/Remove Programs. Does anybody have any ideas? thanks, MP

find and replace linebreaks in file read from disk

I have a css file which I want to read from disk and in that content I want to find and replace all linebreaks (do I look for vbCrlf or ...?)   Public Shared Function GetFileContents(ByVal FullFilename As String) As String        Dim filecontents As String = ""        If File.Exists(FullFilename) Then            Dim objStreamReader As StreamReader            objStreamReader = File.OpenText(FullFilename)            filecontents = objStreamReader.ReadToEnd()            objStreamReader.Close()        End If       Return filecontents    End FunctionSo in the returned variable "filecontents" I want to find and replace any linebreaks.        FILE: style.css#progress{color:#000;width:500px;height:30px;padding:0px;clear:both;}#progress ul{list-style:none;padding:0px;margin: auto;display:block;}#progress ul li{list-style:none;display:inline;float:left;width:auto;height:30px;padding:0px;line-height:30px; font-family:Arial, Helvetica, sans-serif; font-size:13px;}

Migrate documents from File share to Sharepoint Services 3.0

Hi, everyone! One company is planning to migrate from File share, where they are storing all company documents, to sharepoint services 3.0, and begin to use document versioning, is it possible to migrate mass of documents to sharepoint services 3.0 ? Now I have no opportunity to test it, that's the reason why I'm asking.

Search cannot find contents of the PDF file

I have small SharePoint 2010 Server with 2 servers. Steps I made: 1. I have Downloaded and installed Adobe’s 64-bit PDF iFilter to the Front-End machine 2. I have downloaded Adobe PDF icon and inlucluded to the DOCICON.XML. 3. I have added PDF as supported file type 4. I have restarted IIS 5. I have made full crawl 6. Crawl log showed no errors. All items were succesfully crawled. Results: A) PDF icon displayed b) Search based on PDF document name works fine C) Search based on words inside PDF document is not found. What should I do? Reference: http://www.sharepointsharon.com/2010/03/sharepoint-2010-and-adobe-pdf/Kenny_I

Error when accessing an InfoPath file on a file share

Some users get an error when they try to open an InfoPath (2007) file which is location on a file share.  The users getting the error are from our South America domain.  All users, regardless of domain, have the same permissions to the file share folder and they can open and save other files on that file share, txt file, Excel file, etc.  They get this error when trying to open the Info Path file:  "InfoPath cannot create a new, blank form.  InfoPath cannot open the form.  to fix this problem, contact your system administrator.  The query cannot be run for the following data source:SoftwareList"

Upload image to database - couldn't find file path

I'm trying to display images in a GridView (yes, still this...). [edit] Before I can come to that I have to upload some images to the database.I've followed this tutorial for the "upload image to database" code (this worked fine for uploading images, but I don't know if the images were converted to byte):http://aspsnippets.com/Articles/Save-Files-to-SQL-Server-Database-using-FileUpload-Control.aspxand I've followed this tutorial for the "display images in gridview" code (and "retrieve file" from the tutorial below).http://www.aspsnippets.com/Articles/Display-images-from-SQL-Server-Database-in-ASP.Net-GridView-control.aspxIt doesn't quite work, the GridView shows but without imagesNow I'm trying to change the "save file" code according to this tutorial:http://aspsnippets.com/Articles/Save-and-Retrieve-Files-from-SQL-Server-Database-using-ASP.Net.aspxbut I don't understand everything in it. When I try to upload an image I get an error on this line:FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read); //couldn't find file (path to image I tried to upload) What should I do about it?

---How can I find a CSS FILE that is related to News page?

Hi everybody, I am trying to customize SP Portal (MOSS 2007) I customized the very first page (Home) using Default.master and Core.CSS. But when I am going to "News page", sites and the other ones the top navigation looks original. What CSS files are responsible for the other pages(News, Doc. Ctr, Reports, search, sites)? How to find out that CSS files? Is there any file schema that exists that I can look at? Thank you.

---How can I find a CSS FILE that is related to News page?

Hi everybody, I am trying to customize SP Portal (MOSS 2007) I customized the very first page (Home) using Default.master and Core.CSS. But when I am going to "News page", sites and the other ones the top navigation looks original. What CSS files are responsible for the other pages(News, Doc. Ctr, Reports, search, sites)? How to find out that CSS files? Is there any file schema that exists that I can look at? Thank you.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend