Error when try to Export

The report looks good and shows all data correctly.
When I try to export it to PDF; I get an error "There was an error opening
this document.This file cannot be found."
When try to export to Excel. It exports report but for some cells instead of
data it shows "#NAME?"
Any Idea?Are you using RTM or SP1?
PDF Error. By chance do you have a previous PDF export (same file name) open
in Acrobat Reader when this occurred?
EXCEL Error. Please click in one of the cells where this occurred and then
check what is displayed in Excel's cell edit area. #Name occurs because
Excel could not evaluate the expression in the cell.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:eTuyt8eZEHA.3716@.TK2MSFTNGP11.phx.gbl...
> The report looks good and shows all data correctly.
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> When try to export to Excel. It exports report but for some cells instead
of
> data it shows "#NAME?"
> Any Idea?
>

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshzt
Hi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to Windows XP and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshztHi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to Windows XP and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshztHi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

Error translations

I'm importing data from a flat file into a SQL Server table. Yes, I have this thing mapped correctly, data converted correctly, data scrubbed correctly. I've tested this against 14 successive files dumped from the source system and everything works perfectly...until today. Now I'm getting the following gobbledygook.

I have absolutely no clue where to even begin looking. I've already inspected every single column in the input file that is converted to something other than a string. Absolutely nothing shows up as being an overflow or truncation issue. I've calculated the maximum length of every single text column being imported and none of them overflow the destination either. Where do I even start in this completely uninformative junk to even try to figure out where the issue is?

Error: 0xC02020C7 at Load Tables, MLBAMBio [1656]: The attempt to send a row to SQL Server failed with error code 0x80004005.

Error: 0xC0047022 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "MLBAMBio" (1656) failed with error code 0xC02020C7. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC02020C7. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread7" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0202009 at Load Tables, MLBAMBio [1656]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E57.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E57 Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E57 Description: "String or binary data would be truncated.".

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread7" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread3" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread1" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread3" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread9" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread9" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread2" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread2" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Information: 0x40043008 at Load Tables, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x402090DD at Load Tables, Biography [951]: The processing of file "D:\FTPtransfersource\curbio.csv" has ended.

Error: 0xC02092B5 at Load Tables, MLBAMBio [1656]: A commit failed.

Error: 0xC0047018 at Load Tables, DTS.Pipeline: component "MLBAMBio" (1656) failed the post-execute phase and returned error code 0xC02092B5.

Have you tried changing the OLEDBsource &* connection manager, as I have fixed it earlier for the "DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread9" has exited" issues (trying to workaround).|||Can you set up error redirection to capture the rows that are causing the problem?|||

I would start looking for the field(s) that make it fail.

If the error redirection does not help, try splitting your file in halves (binary search) until you get close to the source of the problem.

Thanks.

Error running the Distribution Wizard

I have a very strange error (included at the end of message) and it seems to indicate that I have not installed the SQL Server correctly - perhaps the wrong version. I have re-run the configuration a couple of times with no effect. I have not removed the server and re-installed yet. I have Here is my version info:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

TITLE: Microsoft SQL Server Management Studio

Could not start the wizard.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ConfigureDistWizard, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)You did not install replication support.|||When I run setup and attempt to change installed components the Microsoft SQL Server 2005 Setup dialog shows under Database Services the Replication option as already installed on the drive - I have uninstalled it and re-installed it with no effect. Are you talking about a different option that appears if I start from a fresh install? I am hesitating to uninstall SQL completely and re-install it as the database is being used and I would prefer to update it if possible.

Thanks for the answer.|||

Hi Brian,

If you check directory D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE, could you find configuredistwizard.dll? And is this directory in your PATH environment variables?

Peng

|||Hi Peng,

No I don't have configuredistwizard.dll in my P:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE directory, but I do have the CreatePubWizard.dll in there. That directory is in the path.

Brian
|||

It is very strange. What is your upgrade sequence? 2005 RTM->SP2 or 2005 RTM->SP1->SP2? Does your machine use AMD64 processor?

One way to help troubleshoot the problem is to search in files under directory C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files and look for ConfigureDistwizard.dll. See if there are any error messages.

Also post your question in the SQL setup forum. There might be some experts that can give you better advice.

Peng

|||Hi Peng,

I'm not sure about the installation sequence because I did not install it myself. I eventually uninstalled the SQL Server Database Engine completely and re-installed fully and now the wizard appears.

Thanks again,
Brian

Error running the Distribution Wizard

I have a very strange error (included at the end of message) and it seems to indicate that I have not installed the SQL Server correctly - perhaps the wrong version. I have re-run the configuration a couple of times with no effect. I have not removed the server and re-installed yet. I have Here is my version info:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

TITLE: Microsoft SQL Server Management Studio

Could not start the wizard.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ConfigureDistWizard, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

You did not install replication support.|||When I run setup and attempt to change installed components the Microsoft SQL Server 2005 Setup dialog shows under Database Services the Replication option as already installed on the drive - I have uninstalled it and re-installed it with no effect. Are you talking about a different option that appears if I start from a fresh install? I am hesitating to uninstall SQL completely and re-install it as the database is being used and I would prefer to update it if possible.

Thanks for the answer.
|||

Hi Brian,

If you check directory D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE, could you find configuredistwizard.dll? And is this directory in your PATH environment variables?

Peng

|||Hi Peng,

No I don't haveconfiguredistwizard.dll in my P:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE directory, but I do have the CreatePubWizard.dll in there. That directory is in the path.

Brian
|||

It is very strange. What is your upgrade sequence? 2005 RTM->SP2 or 2005 RTM->SP1->SP2? Does your machine use AMD64 processor?

One way to help troubleshoot the problem is to search in files under directory C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files and look for ConfigureDistwizard.dll. See if there are any error messages.

Also post your question in the SQL setup forum. There might be some experts that can give you better advice.

Peng

|||Hi Peng,

I'm not sure about the installation sequence because I did not install it myself. I eventually uninstalled the SQL Server Database Engine completely and re-installed fully and now the wizard appears.

Thanks again,
Brian