Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







An Unhandled Exception Occurred In Reporting Services


Hi,
 
I am getting below error in the event Log after followed by a Event saying Database stopped. Can anybody tell me the resolution for this error.
 
Below is the system info
1. Microsoft Windows Server 2003 Enterprise Edition Service Pack 2
2. .Net Framework 2.0
 
 
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  3/28/2008
Time:  1:55:46 AM
User:  N/A
Computer: HostMachine
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/28/2008 1:55:46 AM
Event time (UTC): 3/28/2008 8:55:46 AM
Event ID: 6651c52c0a7a45c2bcc904514bab99f2
Event sequence: 68
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/root/Reports-1-128511680648122031
    Trust level: RosettaMgr
    Application Virtual Path: /Reports
    Application Path: D:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportManager
    Machine name: HostMachine
 
Process information:
    Process ID: 2096
    Process name: w3wp.exe
    Account name: NT AUTHORITYNETWORK SERVICE
 
Exception information:
    Exception type: ReportServerException
    Exception message: Execution 'aogqmz45z4at1q3oui2elc55' cannot be found (rsExecutionNotFound)
 
Request information:
    Request URL: http://ViewReports/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=aogqmz45z4at1q3oui2elc55&ControlID=1ff944bddbce45f9860fdf44300bf3bf&Culture=1033&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl141TouchSession0&CacheSeed=Fri Mar 28 01:39:34 2008
    Request path: /Reports/Reserved.ReportViewerWebControl.axd
    User host address: 172.19.97.233
    User: Valid User
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: NT AUTHORITYNETWORK SERVICE
 
Thread information:
    Thread ID: 15
    Thread account name: NT AUTHORITYNETWORK SERVICE
    Is impersonating: True
    Stack trace:    at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
   at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 
 
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 
Aditya


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Unhandled Exception Occurred In SQLWB.EXE
I downloaded the trail version of SQL Server Management Studio 2005. Whenever I open a legacy DTS in the DTS 2000 package designer and I select "Build QueryI get the error line "An unhandled win32 exception occurred in SQL wb.exe [852].

 

 

View Replies !   View Related
An Unhandled Win32 Exception Occurred In DtsDebugHost.exe[3172]
 
can somebody advice me on this error.
 

An Unhandled win32 exception occurred in DtsDebugHost.exe[3172]
 
Thanks a lot
 
 
 

View Replies !   View Related
An Unhandled Exception Occurred During The System.Data.SqlClient.SqlException: Login Failed For User 'IT-CELLIWAM_IT-SERVER'.
While making a connection to a SQL server Enterprise Database using ASP.Net(C#), during execution of .aspx file i got the following error :-

Kindly help me if anybody knows the solution .

Thanks in advance


Login failed for user 'IT-CELLIWAM_IT-SERVER'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'IT-CELLIWAM_IT-SERVER'.

Source Error:


Line 52: //mycommand.SelectCommand.CommandType=CommandType.StoredProcedure;
Line 53: DataSet ds=new DataSet();
Line 54: mycommand.Fill(ds);
Line 55: DataTable dt;
Line 56: dt=new DataTable();


Source File: c:inetpubwwwrootetapplogin.aspx.cs Line: 54

Stack Trace:


[SqlException: Login failed for user 'IT-CELLIWAM_IT-SERVER'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
netapp.login.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootetapplogin.aspx.cs:54
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

View Replies !   View Related
Unhandled Exception In Mmc.exe: : Access Violation
Hi all,Since yesterday I'm unable to lauch the enterprise manager, it givesthe following error :Unhandled exception at 0x0101f07e in mmc.exe: 0xC0000005: Accessviolation reading location 0x00000064.The weird thing is that except installing the office xp PIA's I can'timage what else could be changed on my system.I tried reinstalling, but still the same error.I tried SP3a, still nothing changed.Searched in some groups and it seems that not much can be found aboutit, so my inspiration is running dry.Anyone had this problem ? Anyone any suggestions how to solve it ?Regards,Koen

View Replies !   View Related
SQL 2005 Unhandled Exception Error
Hi,I have installed SQL 2005 RTM on a new server and I keep getting thiserror (described below) quite frequently. Was wondering if anyone has aclue on what's happening here. I tried googling but no success!This generally happens when I am browsing the tree in Object explorerin SQL 2005 Management Studio. I can be doing anything - like viewingdatabases, or viewing table list or viewing stored procedure list, etc.I get the following error (screenshot in URL link)http://img5.imageshack.us/img5/6274/sql2005error3vt.jpgWhen this happens and I click Continue, I can work in Management Studiolike queries, etc. - the summary window appears blank though. It doeshowever refresh the count of items in the list but the main windowdisplays no table list or view list or sp list (whatever the case maybe). Screen shot link:http://img5.imageshack.us/img5/6076...05error21yu.jpgAny ideas???Thanks in advance for all your help!VishalText if message when I click on the Details Button:See the end of this message for details on invokingjust-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.ArgumentOutOfRangeException: InvalidArgument=Value of '5' is notvalid for 'index'.Parameter name: indexatSystem.Windows.Forms.ListView.ListViewItemCollecti on.get_Item(Int32index)at System.Windows.Forms.ListView.set_VirtualListSize( Int32 value)atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.set_VirtualListSize (Int32value)atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.PopulateView()atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.Microsoft.SqlServer .Management.UI.VSIntegration.AppIDPackage.IReportV iew.SetReportSource(ReportSourcereportSource)atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneControl.InternalSetReportSourc e(ReportSourcereportSource, IReportView newView)************** Loaded Assemblies **************mscorlibAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------AppIDPackageAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL----------------------------------------SystemAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------Microsoft.SqlServer.SqlTools.VSIntegrationAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL----------------------------------------Microsoft.VisualStudio.Shell.InteropAssembly Version: 7.1.40304.0Win32 Version: 7.0.4054CodeBase:file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll----------------------------------------Microsoft.VisualStudio.OLE.InteropAssembly Version: 7.1.40304.0Win32 Version: 7.0.4054CodeBase:file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll----------------------------------------System.Windows.FormsAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System.DrawingAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------Microsoft.SqlServer.SqlTDiagMAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll----------------------------------------Microsoft.DataWarehouse.SQMAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL----------------------------------------Microsoft.SqlServer.InstapiAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll----------------------------------------ObjectExplorerAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL----------------------------------------ConnectionDlgAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL----------------------------------------SqlWorkbench.InterfacesAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL----------------------------------------Microsoft.SqlServer.CustomControlsAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll----------------------------------------AccessibilityAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll----------------------------------------SqlMgmtAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL----------------------------------------Microsoft.SqlServer.RegSvrEnumAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll----------------------------------------EnvDTEAssembly Version: 8.0.0.0Win32 Version: 8.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll----------------------------------------Microsoft.NetEnterpriseServers.ExceptionMessageBox Assembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox /9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox .dll----------------------------------------System.DataAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------Microsoft.SqlServer.ConnectionInfoAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll----------------------------------------System.XmlAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------Microsoft.SqlServer.SmoEnumAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll----------------------------------------System.ConfigurationAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------System.TransactionsAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------System.EnterpriseServicesAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll----------------------------------------Microsoft.SqlServer.SmoAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll----------------------------------------Microsoft.SqlServer.SqlEnumAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll----------------------------------------Microsoft.SqlServer.BatchParserAssembly Version: 9.0.242.0Win32 Version: 2005.090.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll----------------------------------------msvcm80Assembly Version: 8.0.50608.0Win32 Version: 8.00.50727.42CodeBase:file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727. 42_x-ww_0de06acd/msvcm80.dll----------------------------------------ObjectExplorerReplicationAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL----------------------------------------Microsoft.ReportViewer.WinFormsAssembly Version: 8.0.0.0Win32 Version: 8.0.50727.42CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll----------------------------------------System.ManagementAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll----------------------------------------SQLEditorsAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL----------------------------------------Microsoft.VisualStudio.TextManager.InteropAssembly Version: 7.1.40304.0Win32 Version: 7.0.4054CodeBase:file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll----------------------------------------************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.For example:<configuration><system.windows.forms jitDebugging="true" /></configuration>When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.

View Replies !   View Related
RSConfigTool.exe Unhandled Exception After Patching SP2
After patching SQL2005 SP2, an unhandled exception occurred in RSConfigTool.exe.

The error message:

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Not found.

Is this a known issue?  Thanks.

 

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Management.ManagementException: Not found
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.PropertyData.RefreshPropertyInfo()
   at System.Management.PropertyDataCollection.get_Item(String propertyName)
   at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName)
   at System.Management.ManagementBaseObject.get_Item(String propertyName)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated()
   at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
   at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
   at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
   at ReportServicesConfigUI.ConfigurationManager.tsbConnect_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RSConfigTool
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/binn/RSConfigTool.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.ServiceProcess
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
System.DirectoryServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


 

View Replies !   View Related
Unhandled Exception While Calling A Stored Procedure
Error is :
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

for the Code :
Public Function insertresult(ByVal txtsearch As String) As Boolean
Dim cmd As New SqlCommand("InsResult", m_cn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@Word", txtsearch)
cmd.ExecuteNonQuery()
End Function

Error :
An unhandled exception of type 'System.ArgumentException' occurred in microsoft.visualbasic.dll

Additional information: Argument 'Prompt' cannot be converted to type 'String'.


Public Function insertresult(ByVal txtsearch As String) As Boolean
Dim cmd As New SqlCommand("InsResult", m_cn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@Word", txtsearch)
Try
cmd.ExecuteNonQuery()
Catch e As Exception
MsgBox(e)
End Try
End Function
InsResult Procedure:
CREATE PROCEDURE dbo.InsResult
(
@Word VarChar(30)
)
AS
SET NOCOUNT ON
Declare @wordid Integer
Declare @urlid Integer
Declare @url varchar(150)
Declare @title varchar(250)
Declare @kc Integer
set @wordid =( Select ID from tblKeywords
where Keyword = @Word)
set @kc =( Select KeywordCount from tblKeywords
where Keyword = @Word)
set @urlid = (select URLID from tblkeywordurl
where KeywordID=@wordid)
set @url = (select URL from tblURLs
where ID=@urlid)
set @title = (select TITLE from tblURLs
where ID=@urlid)
Insert Into tblResults(URLID,TITLE,URL,KeyCount) values (@urlid,@title,@url,@kc)
RETURN
GO


Plz suggest me the solution or correct code

View Replies !   View Related
Embedded SQL Server Express Deployment - Unhandled Exception: Database Already Exists
Good Afternoon.

I am trying to write a short application within which I would like to embed a SQL Server Express database, all of which would be deployed via ClickOnce through a web site. The installation process seems to be working without trouble, including installation of the .NET Framework 2.0 and SQL Server Express 2005.

When the application launches on the new machine, however, I get a big Microsoft .NET Framework "Unhandled exception" error dialog box that indicates the database already exists and that the database file could not be attached. I am working with a clean virtual machine that I know has never had the database installed on it.

I fear I am overlooking something quite straightforward, but since this is the first time I have ever attempted to build a data-bound application, I am not sure where I am going wrong.

Perhaps the source of the problem, or a related problem, might be revealed even when I run the application in debug mode from within Visual Studio. I can run the application once, but if I try to run it again, I get an error when I try to open the database connection that is similar in content (database already exists...could not attach). I can run the SSEUtil and detach the database and then run the application again in debug mode and it works no problem (the first time!).

Lastly, if I install the application on the machine on which it was developed and make sure the database is detached, it will run without any trouble (even repeatedly). But, on a new blank machine, there is no database listed that matches my database name, so I cannot try to detach anything!?

My apologies for such a novice question!

Sean

View Replies !   View Related
Bcp_sendrow Causing Unhandled Exception (0xC0000005: Access Violation Reading Location 0x00000123)
Hi,

Background:

This could be a simple C++ issue as I am not that familiar with the language.  I am trying to prototype a small program to test the performance of inserting data using the BCP interface.  I want to BCP data that my program generates and passes via program variables.

 

I have narrowed the issue down to a sprintf call.  Following are two variations of the code - one that works and one that does not.  The error happens when I try to execute the bcp_sendrow() call.

 

What is the appropriate way to create / send string data to the BCP interface.  Any good examples available?  I have created the following from the BulkCopyFromVariables example on the Microsoft SQL Server downloads site.

 

Thanks in advance, Kerry

 

----  Works  ----




Code Snippet

  for(idx=1; idx<=5; idx++){
    //sprintf(k1, "%d", idx);    //does not work...
    sprintf(k1, "oo");         //works....

    if ( (SendRet = bcp_sendrow(hdbc1) ) != SUCCEED ) {
      printf("bcp_sendrow(hdbc1) Failed");
      Cleanup();
      return(9);
    }
  }


 



--- Causes Access Violation ----

 


Code Snippet

for(idx=1; idx<=5; idx++){
    sprintf(k1, "%d", idx);    //does not work...
    //sprintf(k1, "oo");         //works....

    if ( (SendRet = bcp_sendrow(hdbc1) ) != SUCCEED ) {
      printf("bcp_sendrow(hdbc1) Failed");
      Cleanup();
      return(9);
    }
  }


 





 

--- Additional information ---

---------------------------
Target Table Definition
---------------------------



Code SnippetCREATE TABLE PtTest(
  [ID] [int] IDENTITY(1,1) NOT NULL,
  [PtID] [int] NOT NULL,
  [ParamID] [nchar](10) NULL DEFAULT ((200)),   --Above example trying to insert data here via k1 variable...
  [ParamValue] [nchar](10) NULL  DEFAULT ((200)),
  [InsDate] [datetime] NULL DEFAULT (getdate()),
)


 ----------------------------




-----------------
Bind statements
-----------------
  


Code Snippet

  int idx;  
   char k1[5];
   char *terminator = "";


   retcode = bcp_bind(hdbc1, (BYTE *)&idx, 0, sizeof(DBINT), NULL, 0, SQLINT4, 2);
   if ( (retcode != SUCCEED) ) {
      printf("bcp_bind(hdbc1) Failed");
      Cleanup();
      return(9);
   }

   retcode = bcp_bind(hdbc1, (BYTE *)&k1, 0, SQL_VARLEN_DATA, (UCHAR*)terminator, 1, SQLCHARACTER, 3);
   if ( (retcode != SUCCEED) ) {
      printf("bcp_bind(hdbc1) Failed");
      Cleanup();
      return(9);
   }

 



Note: there are other bind statements...
-----------------

View Replies !   View Related
Synchronization Exception Occurred
Hi!

I recently installed the Technical Refresh for SPS v2. Now I keep getting an error in the application log that says " Synchronization exception occurred" . This occurs every 30 seconds since the technical refresh install.

Has anybody been in this situation and actually resolved it?


 

Thnaks, Kumsi

View Replies !   View Related
DTS: An Exception Occurred In The TSQL Subsystem
I have 2 step job. 1st is to run sproc which produces several outputs:

CREATE PROCEDURE spProcName
as
SET NOCOUNT ON

declare @hr int
declare @err int
declare @totalcount int
SELECT 'This is 1st result'
SELECT ' '
select 'TimeZone'= rtrim(s.TimeZoneDesc), 'State'=rtrim(s.State), 'CoCode'= p.cocode, count(*) as Records
from States s (NOLOCK)
inner join tblProducts p (NOLOCK) on s.stateAbbr= p.costate and AsOfDate>= convert(datetime,convert(char,datepart(yyyy,getdat e()))+'/'+convert(char,datepart(mm,getdate()))+'/'+convert(char,datepart(dd,getdate())))
group by s.TimeZone, s.TimeZoneDesc, s.State, p.cocode
order by s.TimeZone, s.State, p.cocode
compute Count(p.cocode)

if @@error <> 0
begin
print 'error after 1st '
select @err = 1
end

SELECT 'This is 2nd result'
SELECT ' '
select 'TimeZone'=rtrim(s.TimeZoneDesc), 'State'=u.CoState, 'CoCode'=u.cocode, count(*) as Records
from States s (NOLOCK)
inner join Results u (NOLOCK) on s.stateAbbr= u.Costate
group by s.TimeZone, s.TimeZoneDesc, u.CoState, u.cocode
having u.Costate is not null
order by s.TimeZone, u.CoState, u.cocode
compute Count(u.cocode)

if @@error <> 0
begin
PRINT 'error after 2nd '
select @err = 1
end

select @totalcount= count(*) from Results (NOLOCK)
SELECT 'Aproximate Pending time is ' + convert(varchar(30),(@totalcount*0.7)/60) + ' minutes'

if @@error <> 0
begin
PRINT 'error after 3rd '
select @err = 1
end
if @err = 1 RETURN 1 else RETURN 0
SET NOCOUNT OFF


It's set to produce TXT output file with Overwrite.

Second step is to send e-mail with TXT file produced in Step 1 using CDO from sproc.

I have two issues:
1. When I run 1st sproc in QA, it runs without problems, but when I run it as a part of job, errors out EVERY OTHER time with message:
"An exception occurred in the TSQL subsystem. The step failed."

2. Second issue: Output file is created in UNICODE, or some other code, so e-mail client sees only ÿþJ instead of 6000 characters of text file if client set to see attachments Inline.
Why I think it's UNICODE? I tried to sent other files, and UNICODE one shows as ÿþJ every time


Please help,

Michael

View Replies !   View Related
Error In DTS: An Exception Occurred In The TSQL Subsystem
I have 2 step job. 1st is to run sproc which produces several outputs:
[size=2]
CREATE PROCEDURE spProcName
as
SET NOCOUNT ON

declare @hr int
declare @err int
declare @totalcount int
SELECT 'This is 1st result'
SELECT ' '
select 'TimeZone'= rtrim(s.TimeZoneDesc), 'State'=rtrim(s.State), 'CoCode'= p.cocode, count(*) as Records
from States s (NOLOCK)
inner join tblProducts p (NOLOCK) on s.stateAbbr= p.costate and AsOfDate>= convert(datetime,convert(char,datepart(yyyy,getdat e()))+'/'+convert(char,datepart(mm,getdate()))+'/'+convert(char,datepart(dd,getdate())))
group by s.TimeZone, s.TimeZoneDesc, s.State, p.cocode
order by s.TimeZone, s.State, p.cocode
compute Count(p.cocode)

if @@error <> 0
begin
print 'error after 1st '
select @err = 1
end

SELECT 'This is 2nd result'
SELECT ' '
select 'TimeZone'=rtrim(s.TimeZoneDesc), 'State'=u.CoState, 'CoCode'=u.cocode, count(*) as Records
from States s (NOLOCK)
inner join Results u (NOLOCK) on s.stateAbbr= u.Costate
group by s.TimeZone, s.TimeZoneDesc, u.CoState, u.cocode
having u.Costate is not null
order by s.TimeZone, u.CoState, u.cocode
compute Count(u.cocode)

if @@error <> 0
begin
PRINT 'error after 2nd '
select @err = 1
end

select @totalcount= count(*) from Results (NOLOCK)
SELECT 'Aproximate Pending time is ' + convert(varchar(30),(@totalcount*0.7)/60) + ' minutes'

if @@error <> 0
begin
PRINT 'error after 3rd '
select @err = 1
end
if @err = 1 RETURN 1 else RETURN 0
SET NOCOUNT OFF

[/size=2]
[size=3]

It's set to produce TXT output file with Overwrite.

Second step is to send e-mail with TXT file produced in Step 1 using CDO from sproc.

I have two issues:
1. When I run 1st sproc in QA, it runs without problems, but when I run it as a part of job, errors out EVERY OTHER time with message:
"An exception occurred in the TSQL subsystem. The step failed."

2. Second issue: Output file is created in UNICODE, or some other code, so e-mail client sees only ÿþJ instead of 6000 characters of text file if client set to see attachments Inline.
Why I think it's UNICODE? I tried to sent other files, and UNICODE one shows as ÿþJ every time
[/size=3]

Please help,
Michael

View Replies !   View Related
An Exception Occurred During The DBComms.receive Method.
I am getting SQLException when I  connect SQL Server 2005. I would like to know how to correct this problem.
I get this error randomly. Never seenit before. Sometimes I get this error one day later from application begins, sometimes two days later, sometimes 3 day later.
 
DBCP borrowObject failed: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context841) [Thread[http-8080-Processor18,5,main], IO:457d2, Dbc:1a642]. PktNum:0. TotalReceived:0. PktSize:4,096.
org.apache.commons.dbcp.DbcpException: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context841) [Thread[http-8080-Processor18,5,main], IO:457d2, Dbc:1a642]. PktNum:0. TotalReceived:0. PktSize:4,096.
 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
 at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
 at org.apache.struts.util.GenericDataSource.getConnection(GenericDataSource.java:276)
 at com.y.util.DbAccess.getConnection(DbAccess.java:29)
 at com.y.biz.UserMgr.leftDays(UserMgr.java:404)
 at com.y.action.LoginAction.login(LoginAction.java:194)
 at sun.reflect.GeneratedMethodAccessor303.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:220)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
 at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:534)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context841) [Thread[http-8080-Processor18,5,main], IO:457d2, Dbc:1a642]. PktNum:0. TotalReceived:0. PktSize:4,096.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
 at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
 at com.microsoft.sqlserver.jdbc.IOBuffer.sendCommand(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.changeSettings(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
 ... 44 more
 

Web Server:
CPU 2*1.66G,  4GB ram, 146GB
Windows 2003 Server
JDK 1.4.2
Tomcat 5.0
Driver Name: Microsoft SQL Server 2005 JDBC Driver

JDBC Driver Version 1.0
Use struts connection pool in application.
 
Database Server:
CPU 2*1.66G, 4GB ram, 4 x 146GB
Windows 2003 Server
SQL Server 2005, Product Version: 9.00.1399
 
 

View Replies !   View Related
.......A Floating Point Exception Occurred In The User Process.........
I'm getting this error:

System.Data.SqlClient.SqlException: A floating point exception occurred in the
user process. Current transaction is canceled. at
System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping
tableMapping) at ...etc etc

    when updating one particular table, but not when updating another using nearly the same code.

I've searched and searched on the inet, but with no joy.

Microsoft have several different manifestations of it, under various
different circumstances, but the solutions all seem to involve
installing SP4, which by the looks of it is a massive procedure that
you have to go to university to be competent to do.

In any case, according to Enterprise Manager, I already have SP4
included. On the other hand, the one file of mine I checked the date of
against MS's hotfix file list was 2002 not 2003, so who knows?

My Service Manager is v 8.00.760, and it's the Development Edition (ie it's all running on the one machine).

According to the info on sqlDataAdaptor.update,  the
sqlError that gets returned  as part of the sqlException contains
fields Class, which gives the seriousness of the error, and State,
which identifies the exact error.  I get Class=16 (user-fixable)
and State=1, which we have to go to SQL Books Online to discover the
meaning of.  SQL BO probably sounded like a good idea to W.Gates,
but it took me half an hour to get anywhere near finding out what that
'1' meant.  When I did, it was (guess): 'A floating point
exception occurred in the user process. Current transaction is
canceled.' !!!

Can anyone please tell me what exactly might be causing the error?

Graham Rounce

View Replies !   View Related
A Floating Point Exception Occurred In The User Process
sql server 2000 sp4 build 2184runs stats with maintenance plansp_msforeachtablestored procedure updating full stats for each table and the resultsare identicalA floating point exception occurred in the user process. Currenttransaction is canceled.all pointers are to move to latest service packAny pointers on how to avoid this errorThanks for your timeMassa

View Replies !   View Related
&&"An Overflow Occurred While Converting To Datetime Exception
 

32 Bit Vista RTM - Patch Level up todate. - Desktop
SQL CE V3.5
VS2008 - RTM
 
I have a really strange problem where I am receiving a ""An overflow occurred while converting to datetime Exception."
 
I have an existing database where I am making a copy of an old row, and updatting date/time fields. The old fields were filled with date/time and the columns are datetime columns.

 
Private Function CopyChildRowsDST(ByVal SearchID As Guid, ByVal CurrentParentID As Guid, _
                                      ByVal dsttbl As DataTable) As Boolean
        Dim Rows() As DataRow = Ds.Tables("SrcTbl").Rows.Find(SearchID).GetChildRows(ChildrenRel)
        Dim NewEntityId As Guid
        For Each Row As DataRow In Rows
            NewEntityId = Guid.NewGuid
            Row(MDTbl.cgParentID) = CurrentParentID
            Select Case Row(MDTbl.csRecordType)
                Case RecordTypes.Directory
                    CopyChildRowsDST(Row(MDTbl.cgEntityID), NewEntityId, dsttbl)
                Case RecordTypes.Topic
                    ' Increment reference count and ticks of data
                    Qury.IncrementReferenceCount(Row(MDTbl.cgDataID), _
                     ReferenceCount.Increment, Tables.DocumentTable)
            End Select
            Dim Rw As DataRow = dsttbl.NewRow : Rw.ItemArray = Row.ItemArray
            Rw(MDTbl.cgEntityID) = NewEntityId
            ' Rw(MDTbl.cdtDateCreated) = Curtime

            'Rw(MDTbl.cdtDateModified)  = Curtime
            dsttbl.Rows.Add(Rw)
        Next
    End Function
After executing this code..... I do ...
 
Public Function PersistTable(ByVal Table As DataTable) As Boolean
        ' SqlCe.PersistTable - called by any routine needing to make
        €˜permanent changes in a table.
        ' Usually this would be midlevel procedures in IOSUBS
        Con.Open() : Dim Status As Boolean
        Using Adapter = New SqlCeDataAdapter("Select * from " &
                     Table.TableName & " ;", Con)
            Adapter.UpdateCommand = New SqlCeCommand("Update " &
                     Table.TableName & " ;", Con)
            Dim builder As New SqlCeCommandBuilder(Adapter)
            With builder : .QuotePrefix = "[" : .QuoteSuffix = "]" : End With
            Try
                Adapter.Update(Table) : Status = True
            Catch e As SqlCeException
                Con.Close()
                MsgBox("Error persisting Table: " + Table.TableName + vbCrLf
                      + "Exception was: " + e.Message, _
                      MsgBoxStyle.Information,"ADONET.PersistTable")
                Return False
            Finally
                Con.Close()
            End Try
            Return Status
        End Using
    End Function
If I include the two redlines of code, I recieve a time overflow exception WHEN UPDATING THE TABLE. Those database fields are datetime fields and the orginal rows have datetimes in them.
 
Does anyone understand what is happening?
 
Thank you.

View Replies !   View Related
A Floating Point Exception Occurred In The User Process - Msg 3628
I am trying to run "select * from <table> where <columnname> = 0.0" inquery analyzer<columnname> is a floatI get the following error:Server: Msg 3628, Level 16, State 1, Line 1A floating point exception occurred in the user process. Currenttransaction is canceled.I get the same error when I use the float <columnname> through anapplicationI have tried upgrading to SP4, without any luck - still get the errormessage.Any help would indeed be appreciated.Thanks -AH

View Replies !   View Related
A Native Exception Occurred: Synchronizing Data Between The MS SQL Server Database And PDA
ISSUE: While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception:   Error During Synchronization: A native exception occurred. ExceptionCode:0xc0000005 ExceptionAddress:0x01627b28 Reading: 0x1e000000 OK to terminate CANCEL to debug   Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful. Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.

View Replies !   View Related
I Am Getting An Error Message When I Try To Print Using Reporting Services: &&"an Error Occurred During Printing (0x80004005)&&"
I am getting an error message when I try to print using reporting services: "an error occurred during printing (0x80004005)"

View Replies !   View Related
A Floating Point Exception Occurred In The User Process. Current Transaction Is Canceled.
Hi,I'm running SQL Server Version 8.00.194 on Windows 2000.I am am running this query:select TOP 2000TheoVolImpliedfrom OptionTradeswhere ReutersSymbol = 'IBM.N'and TheoVolImplied > 0.0TheoVolImplied is of type float, precision 15, length 8.When I run this query I get this error:Server: Msg 3628, Level 16, State 1, Line 1A floating point exception occurred in the user process. Currenttransaction is canceled.If I run this query:select TOP 2000TheoVolImpliedfrom OptionTradeswhere TheoVolImplied > 0.0It works fine with no problems.If I run this query:select TOP 2000TheoVolImpliedfrom OptionTradeswhere ReutersSymbol = 'IBM.N'It works fine with no problems.Anyone have any ideas about what might be wrong?

View Replies !   View Related
Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services
 

Hello,
 
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
 
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
 
Any help is appreciated

View Replies !   View Related
Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services
I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.

One option possibly is the SQL Express with Advanced Services download, which has Reporting Services.  My questions are as follows:

Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?

Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.

Thanks to anyone who can help.

        -- Mark

View Replies !   View Related
Exception Reporting !?!
Hi everyone,
 
I'm trying to figure out, how I can solve following problem. I need to generate an overview of a department (parameter) of their employees which have visited a course (2nd parameter) and which haven't. For this I'm working with following tables:
 
- Employee Data (incl. Unit Code)
- Participant Table (one employee can have none, one or more entries - for every participation she/he gets one entry)
- Course Table (with details of the course - out of here I need to choose the course)
 
The participant table is merged to the course table over a course # (primary key in course table). The employee data is merged to the participant table over an employee #.
 
Which data I can generate until now:
 
- Participants of the course of the chosen department
- Employees which have never visited a course of the chosen department
and
- Employees which haven't visited the specific course but have visited an other one
 
---> my problem now, is to get those employees which haven't participated at the specific course but participated in an other one together with the ones which have participated. When I set a filter for the course number "NOT = 224847362" then I receive all those, which have participated in an other course - that's ok - but as mentioned before, an employee can participate in more than just one course. Thus when I make an UNION I get double entries - one for the participation and one for the "participation in an other course".
 
Can someone help? That would be fantastic!
 
Cheers,
Swisscougar

View Replies !   View Related
Exception Reporting SSRS VS SAP BI
In SAP BI we have capacity for Exception Reporting under BEx Query Designer.
 
ie
·        Determining threshold values or intervals that are given a priority (bad, critical, good). The priority given to an exception corresponds to pre-assigned colors that become more €˜intense€™ the greater the deviation. Up to 9 different shades of the traffic light colors red, yellow, and green are used. These traffic light colors are also used in the alert monitor to display the results of exception reporting.
 
Do we in SSRS have the aforesaid capacity?
 
I have seen IIF function but it act as a flag not actually color that particular cell or am i missing something. 
 
ie
 



Code Snippet
Color Code
=iif(RowNumber(nothing) Mod 2, "Silver","White")
 
 
 

View Replies !   View Related
A First Chance Exception Of Type 'System.Data.SqlClient.SqlException' Occurred In System.data.dll
Hi,
I've written this code multiple times now. But for the first time i get an error at the line underlined. My procedure runs perfectly when i execute it through Sql Query analyzer.
plzz help.. Its urgent and am unable to find the reason for this error "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll"
Thanks !SqlConnection conn = new SqlConnection(DbConnectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "dbo.rqryTradesPRR";
cmd.Parameters.Add("@COBDate",SqlDbType.DateTime).Value = "2002-10-31 00:00:00.000" ;
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
// have written something here

}
 Thanks in advance !
 

View Replies !   View Related
Exception Returned From Reporting Servicing
Hi, I'm got this unhandled exeption return from our reporting server and I don't know what it means or how I can ensure it doesn't happen again.  We are using SQL Server 2005 and Reporting Services 2005 with .Net 2.0 (VS 2005) ASP.NET

 

any help appreciated

 

regards


Satvinder

 

Exception information:        Exception typeoapException       

Exception message: System.Web.Services.Protocols.SoapException: Execution 'l53cr2bl5ces523lsvet0s2y'
cannot be found ---> Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution
'l53cr2bl5ces523lsvet0s2y' cannot be found   
--- End of inner exception stack trace ---
   
at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo_executionInfo)       
Request information:        Request URL: http://uat-WebSite/Reserved.ReportViewerWebControl.axd?ReportSession=l53cr2bl5ces523lsvet0s2y_ControlID=90412828-217e-4c47-a8b4-445adb99cf71_Culture=2057_UICulture=1033_ReportStack=1_OpType=SessionKeepAlive_Interval=454000
      
Request path: /Reserved.ReportViewerWebControl.axd        User host address: 10.110.125.68  
    User: LONDON_UAT_SONASA        Is authenticated: True        Authentication Type: NTLM        Thread
account name: LONDON_UAT        Thread information:        Thread ID: 10        Thread account
name: LONDON_UAT        Is impersonating: False       

Stack trace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)    
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)    
at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.TouchSession()    
at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection
urlQuery, HttpResponse response)    
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)    
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean_ completedSynchronously)

        Custom event details:      "
App: E 'Mon Jun 04 16:58:34 2007': LONDONWEB - " An internal error occurred on the report server. See the
error log for more details. (rsInternalError)  "
App: E 'Mon Jun 04 16:58:34 2007': LONDONWEB - " An internal error occurred on the report server. See the
error log for more details. (rsInternalError)  "
Sys: E 'Mon Jun 04 16:58:37 2007': DCOM - " The application-specific permission settings do not grant
Local Activation permission for the COM Server application with CLSID   {BA126AD1-2166-11D1-B1D0-00805FC1270E}
  to the user LONDON_ABC_PROD_UAT SID (S-1-5-21-388395589-1927312763-1538882281-22140).  This security
permission can be modified using the Component Services administrative tool.  "

View Replies !   View Related
Reporting Service Webservice Access Denied Exception
I am running SQL Express with Reporting Services 2005 SP2.

Installed both on with the NT-AuthorityNetwork Service

 

I uploaded a report and I can execute it in the Report Manager.

What I want to do is execute the report via Webservice and stream the result as PDF.

 




Code SnippetReporting.ReportExecutionService svc = new Reporting.ReportExecutionService();
        svc.Credentials = System.Net.CredentialCache.DefaultCredentials;
        svc.LoadReport(report, historyID);
        svc.SetExecutionParameters(parameters, "en-us");
        byte[] results = svc.Render(format,deviceInfor,out fileNameExtension,out mimeType,out encoding,out warnings,out streams);
        this.Response.Clear();
        this.Response.ContentType = "application/pdf";
        this.Response.AddHeader("Content-disposition", "attachment; filename=Report.pdf");
        this.Response.BinaryWrite(results);
        this.Response.End();

 

this is my code in the asp.net page

 

and I get following exception

 
System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation.
  at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
  at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
  at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
  at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
  at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
  --- End of inner exception stack trace ---
  at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
  at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation.
  at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
  at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
  at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
  at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
  at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
  --- End of inner exception stack trace ---
  at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
  at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)

Source Error:





Line 206: [return: System.Xml.Serialization.XmlElementAttribute("executionInfo")]
Line 207: public ExecutionInfo LoadReport(string Report, string HistoryID) {
Line 208: object[] results = this.Invoke("LoadReport", new object[] {
Line 209: Report,
Line 210: HistoryID});
Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eporttest8a8d2a7956046022App_WebReferences.x8k9hsoj.0.cs    Line: 208

Stack Trace:





[SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +533462
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204
Reporting.ReportExecutionService.LoadReport(String Report, String HistoryID) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eporttest8a8d2a7956046022App_WebReferences.x8k9hsoj.0.cs:208
_Default.RenderReport(String client_short, String gobj_long, String event_date, String event_time) in c:WebsitesReportTestDefault.aspx.cs:68
_Default.Button1_Click(Object sender, EventArgs e) in c:WebsitesReportTestDefault.aspx.cs:22
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102


 

Looks like I need some additional adjustment on the authentication. But I do not know where and how.

I try to change the webservice identity but after changing the user identity of the application pool in iis ( I think this is the only way to change webservice identity) I got the error message service unavailable in IIS. With this I also couldn't start the webfront end any more. Switching back to NT-AuthorityNetwork Serive the web front end worked again.

I tryed to add


Code Snippet<identity impersonate="true" />

 to the web config and I get the same Error on the webserver account...

It would be great if someone could help me to adjust the settings...

 

 

 

 

View Replies !   View Related
To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine
Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right?  I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

View Replies !   View Related
Reporting Services Menu Does Not Appear When Install Reporting Service Add-in For SharePoint
Hi all,
 
I have some problem about reporting service add-in.
 
After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.
 
I try to uninstall and re-install again, it remain not work.
 
How can I solve this problem?
 
Thank you very much.

View Replies !   View Related
SQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue
Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2  reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error  "The group name could not be found"
Does anyone have any ideas?
Thanks

View Replies !   View Related
Reporting Services - Analysis Services - Displaying Dimension Members As Columns
I think I've seen a similar post on a blog or on the forums - but it seems like this should be possible -

I have an MDX query - that works fine in SQL Enterprise Manager, and has my dimension members on columns, and my measures on the rows.  When I try the same query in Reporting Services, I get the error:

"The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension..
Parameter name: mdx (MDXQueryGenerator)"

Although it works when you pivot the view, I really need my data presented with the members on the columns and the measures on the rows.  Another forum post mentioned using the SQL 9.0 driver, but I can't see this listed anywhere (the only one I see is the .NET framework Data Provider for Microsoft Analysis Services).

Here's what my query looks like -

 SELECT
{ [Time].[Month].&[2006-09-01T00:00:00] ,
[Time].[Month].&[2006-10-01T00:00:00],
[Time].[Month].&[2006-11-01T00:00:00],
[Time].[Month].&[2006-12-01T00:00:00]
} on COLUMNS,
{
 [Measures].[Unique Users],
 [Measures].[UU Pct 1],
 [Measures].[UU Pct 2],
} ON ROWS
FROM [Cube]



Any ideas?

Thanks,
Arjun

View Replies !   View Related
'((System.Exception)($exception)).Message' Threw An Exception Of Type 'System.NotSupportedException'
Greetings everyone, I am attempting to build my first application using Microsofts Sql databases. It is a Windows Mobile application so I am using Sql Server Compact 3.5 with Visual Studio 2008 Beta 2. When I try and insert a new row into one of my tables, the app throws the error message shown in the title of this topic.
'((System.Exception)($exception)).Message' threw an exception of type 'System.NotSupportedException'
 

 
My table has 4 columns (i have since changed my FavoriteAccount datatype from bit to Integer)
http://i85.photobucket.com/albums/k71/Scionwest/table.jpg
 
Account type will either be "Checking" or "Savings" when a new row is added, the user will select what they want from a combo box.
 
Next is a snap shot of my startup form.
http://i85.photobucket.com/albums/k71/Scionwest/form.jpg

 
 
Where it says "Favorite Account: None" in the top panel, I am using a link label. When a user clicks "None" it will go to a account creation wizard, and set the first account as it's primary/favorite. As more accounts are added the user can select which will be his/her primary/favorite. For now I am just creating a sample account when the label is clicked in an attempt to get something working. Below is the code used.
 

private void lnkFavoriteAccount_Click(object sender, EventArgs e)

{

FinancesDataSet.BankAccountRow account = this.financesDataSet.BankAccount.NewBankAccountRow();

account.Name = "MyBank Checking Account";

account.AccountType = "Checking";

account.Balance = Convert.ToDecimal("15.03");

account.FavoriteAccount = 1;//datatype is an integer, I have changed it since I took the screenshot.

financesDataSet.BankAccount.Rows.Add(account);
//The next three lines where added while I was trying to get this to work.
//I don't know if I really need them or not, I receive the error regardless if these are here or not.



this.bankAccountTableAdapter1.Update(financesDataSet);

this.financesDataSet.AcceptChanges();

refreshDatabase();

}

 
the refreshDatabase() code is here:
 

private void refreshDatabase()

{

this.bankAccountTableAdapter1.Fill(this.financesDataSet.BankAccount);

//Aquire a count of accounts the user has

int numAccounts = financesDataSet.BankAccount.Count;

//Loop through each account and see which one is the primary.

for (int num = 0; num != numAccounts; num++)

{
//Works ok in frmMain_Load, but when my lnkFavoriteAccount_click calls this, it throws the error.

if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)

{
//Display the primary account on our home page. User can click the link label & be taken to their account register.

this.lnkFavoriteAccount.Text = this.financesDataSet.BankAccount[num].Name.ToString();

this.lnkFavoriteFunds.Text = this.financesDataSet.BankAccount[num].Balance.ToString();

break;

}

}

}

 
and my form_load code

private void frmMain_Load(object sender, EventArgs e)

{

refreshDatabase();

}

 
So, when I click on the lnkFavoriteAccount label, and my new row gets added, the app stops at the following line in my DataSet.Designer

[global:ystem.Diagnostics.DebuggerNonUserCodeAttribute()]

public byte FavoriteAccount {

get {

try {

return ((byte)(this[this.tableBankAccount.FavoriteAccountColumn]));

}

catch (global:ystem.InvalidCastException e) {
//Stops at the following line, this error was caused by 'if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)'

throw new global:ystem.Data.StrongTypingException("The value for column 'FavoriteAccount' in table 'BankAccount' is DBNull.", e);

}

}

set {

this[this.tableBankAccount.FavoriteAccountColumn] = value;

}

}

 
I have no idea what I am doing wrong, all of the code I used I retreived from Microsofts help documentation included with VS2008. I have tried used my TableAdapter.Insert() method and it still failed when it got to

if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)

in my refreshDatabase() method it still failed.
 
When I look, the data has been added into the database, it's just when I try to retreive it now, it bails on me. Am I retreiving the information wrong?
 
Thanks for any help you guys can offer.
 
Johnathon

View Replies !   View Related
Analysis Services 2000 + Reporting Services 2005 + Parameters
 

Hi All,
 
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
 
Regards,
Joseph

View Replies !   View Related
SQL Express With Advanced Services Reporting Services Security Configuration
Hi, i have a development scenario with various XP Pro (sp2) machines and no network server, the computers are conected by a switch and all computers have static IP addresses, one of the computers have and instance of SQL Exp. W Advances Services and Reporting services installed and working fine.

the thing id that i can not access the reporting services from other computers on the network because they always try to log in by the use of the Guest account witch by default is disabled, i realy need other people on the network to validadde the reports that are being developed on thet machine, can some one please tell me how to configure access to then, i don't even need the users to be asked for a password can it be configured for anonymous access?? and if it can. how do i have to configure security settings in reporting services and in IIS??

Please need help fast .

Thanx in advance for the help.

View Replies !   View Related
Using ReportViewer Controls In A Jsp Application Calling Reporting Services Using Web Services
 Hi,

 

 I am invoking RS web services to render reports, using Apache Axis to generate stub classes from Reporting Service WSDL.

 

Please let me know if I can integrate Report Viewer control in the jsp where I am writing the report output. Else do I have to create my own custom tags simulating ReportViewer functionality.

View Replies !   View Related
Error Programaticaly Rendering A Report Using Reporting Services Web Services
I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has  few parameters that must be passed so I pass these parameters with code.

<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;               
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;               
               
     ParameterValue[] parameters = new ParameterValue[2];
                  
     parameters[0] = new ParameterValue();                       
     parameters[0].Name = "pID";
     parameters[0].Value = "6548747";      

     parameters[1] = new ParameterValue();                       

     parameters[1].Name = "pClass";

     parameters[1].Value = "8";                 


    ExecutionHeader header = new ExecutionHeader();
    ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
    executionInfo = rs.SetExecutionParameters(parameters, "en-us");
    rs.ExecutionHeaderValue = header;
    rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;

    byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);                   
</My code>

Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():

<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>

I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.

Any help would be much appreciated.

View Replies !   View Related
How Can I Access A Custom Assembly In Analysis Services From Reporting Services?
Hi Everyone,



I'm hoping someone can give me a pointer here, because this seems like a pretty strange bug.



I've created a few CLR stored procs that I compile into a dll and add to my SSAS database as an assembly. This all works fine, and I can write MDX that takes advantage of that assembly.



In SSRS, however, I've included the analysis services database, and when I try to generate a dataset off it using my CLR procs, it throws up an error.



How can I access a custom assembly in analysis services from reporting services?



Thanks!

Andrew

View Replies !   View Related
Parameters In Reporting Services And Data Source Is Analytical Services
 

My requirement for the parameter is multivalue parameter with a text box. for example when user enters aa15 it need to include product aa15. when the user enters aa15, aa16, zz15 than it needs to include all the three products. the last case is when the user enters AA** than i need to inclued all the products start with AA.  when i use default multivalue  parameter with data source analytical services than i am getting a drop down box. I dont want that. I need a text box where user can enter the value.
1. In sql we have a like key word to query . for example select * from product where product like "AA%".
what is equavalent mdx query to get such results ?
2.How to impliment the multivalue parameters without using dropdown box?

View Replies !   View Related
Reporting Services ReportServer DB Reporting - 3rd Party Tool ?
HI There

We are required to gather certain information regarding reporting services.

Which reports were requested, by whom , how long did they run for, what parameters were passed etc etc.

I see that the system tables do provide some of this information, is there a 3rd party tool or something we can use to gather all this type of information for us?

This is for reporting services 2000 and 2005.

Thanx

 

View Replies !   View Related
Reporting Services 2005 And Analysis Services 2000
 

Hello,
 
 

i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
 
thank you
regards
Andreas

View Replies !   View Related
Reporting Services + Analysis Services Data Source
Hi all,

Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.

Most of the reports take 10 to 15 report Parameters and all are multi valued.

 

Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.

Can someone tell me how to use the report parameters to query the Cube.

Any links,books for reference would be of great help..

 

Thanks,

Looking forward to your replies

 

View Replies !   View Related
Blocking When Using Reporting Services With Analysis Services Datasource
We have a report in Reporting Services that connects to a Analysis Services Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this?

View Replies !   View Related
Can I Add User In Reporting Services With Command Line Or Web Services
Can I add user in Reporting Services with command line or web services?

I can't find the way to add user in Reporting Services with command line or web services. Are we have another way to add user in Reporting Services by web portal ( http://<machinename>/reports ).

Thanks for all answers.

iRat

View Replies !   View Related
Reporting Services Is Too Slow With Analysis Services 2005
 

Hi,
i am trying to build a report in Repoting servies 2005 from Cube which is built in Analysis services 2005.
when i try to include one memer each from three dimensions , this report becomes too slow and response time goes around 30 seconds. same report on other reporting tools like excel or crystal reports takes milliseconds.
 
members from dimesions are destination_name, carrier and  product  with 6 measures and 3 calculated measures.
 
please somebody helps me out ?
 
Cheers

View Replies !   View Related
SQL Reporting - An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)
I have created an RDL file programatically. When I execute the code I get the error as mentioned below:

Error: Sub report cannot be shown.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)

When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result.
Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer.

Any Suggestion/feedback is highly appreciated.
Thank You.


The code of the sample RDL is shown below:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="DataSource1">
      <DataSourceReference>DataSource1</DataSourceReference>
      <rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <BottomMargin>0.25in</BottomMargin>
  <RightMargin>0.25in</RightMargin>
  <PageWidth>11in</PageWidth>
  <ReportParameters>
    <ReportParameter Name="machine_id">
      <DataType>String</DataType>
      <Prompt>machine_id</Prompt>
    </ReportParameter>
    <ReportParameter Name="from_date">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>From Date</Prompt>
    </ReportParameter>
    <ReportParameter Name="to_date">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>To Date</Prompt>
    </ReportParameter>
  </ReportParameters>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ReportItems>
      <Table Name="table1">
        <DataSetName>Main_Report</DataSetName>
        <TableGroups>
          <TableGroup>
            <Header>
              <TableRows>
                <TableRow>
                  <TableCells>
                    <TableCell>
                      <ReportItems>
                        <Textbox Name="textbox2">
                          <rd:DefaultName>textbox2</rd:DefaultName>
                          <ZIndex>1</ZIndex>
                          <Style>
                            <TextAlign>Left</TextAlign>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingBottom>2pt</PaddingBottom>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                          </Style>
                          <CanGrow>true</CanGrow>
                          <Value>=Fields!syscode.Value</Value>
                        </Textbox>
                      </ReportItems>
                    </TableCell>
                  </TableCells>
                  <Height>0.25in</Height>
                </TableRow>
              </TableRows>
              <RepeatOnNewPage>true</RepeatOnNewPage>
            </Header>
            <Grouping Name="table1_Group1">
              <PageBreakAtEnd>true</PageBreakAtEnd>
              <GroupExpressions>
                <GroupExpression>=Fields!syscode.Value</GroupExpression>
              </GroupExpressions>
            </Grouping>
          </TableGroup>
        </TableGroups>
        <Details>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Subreport Name="subreport1">
                      <Parameters>
                        <Parameter Name="machine_id">
                          <Value>=Fields!machine_ip.Value</Value>
                        </Parameter>
                        <Parameter Name="syscode">
                          <Value>=Fields!syscode.Value</Value>
                        </Parameter>
                        <Parameter Name="from_date">
                          <Value>=Parameters!from_date.Value</Value>
                        </Parameter>
                        <Parameter Name="to_date">
                          <Value>=Parameters!to_date.Value</Value>
                        </Parameter>
                      </Parameters>
                      <ReportName>Holding_Summary_Multi_Period</ReportName>
                    </Subreport>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.25in</Height>
            </TableRow>
          </TableRows>
        </Details>
        <TableColumns>
          <TableColumn>
            <Width>10.5in</Width>
          </TableColumn>
        </TableColumns>
        <Height>0.5in</Height>
      </Table>
    </ReportItems>
    <Height>0.75in</Height>
  </Body>
  <rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID>
  <LeftMargin>0.25in</LeftMargin>
  <DataSets>
    <DataSet Name="Main_Report">
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list
where machine_ip = @machine_id</CommandText>
        <QueryParameters>
          <QueryParameter Name="@machine_id">
            <Value>=Parameters!machine_id.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <DataSourceName>DataSource1</DataSourceName>
      </Query>
      <Fields>
        <Field Name="syscode">
          <rd:TypeName>System.Int64</rd:TypeName>
          <DataField>syscode</DataField>
        </Field>
        <Field Name="display_name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>display_name</DataField>
        </Field>
        <Field Name="customer_syscode">
          <rd:TypeName>System.Int64</rd:TypeName>
          <DataField>customer_syscode</DataField>
        </Field>
        <Field Name="account_syscode">
          <rd:TypeName>System.Int64</rd:TypeName>
          <DataField>account_syscode</DataField>
        </Field>
        <Field Name="machine_ip">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>machine_ip</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Code>Shared offset As Integer

Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
  If reset
    offset = pagenumber - 1
  End If
  Return pagenumber - offset
End Function

</Code>
  <Width>10.5in</Width>
  <InteractiveHeight>11in</InteractiveHeight>
  <Language>en-US</Language>
  <PageFooter>
    <ReportItems>
      <Image Name="image1">
        <Sizing>Fit</Sizing>
        <Left>8.875in</Left>
        <MIMEType />
        <Width>1.5in</Width>
        <Source>External</Source>
        <Style />
        <Value>bottom_right_logo.gif</Value>
      </Image>
    </ReportItems>
    <Height>0.5in</Height>
    <PrintOnLastPage>true</PrintOnLastPage>
    <PrintOnFirstPage>true</PrintOnFirstPage>
  </PageFooter>
  <TopMargin>0.5in</TopMargin>
  <PageHeight>8.5in</PageHeight>
</Report>

View Replies !   View Related
Reporting Services - Analysis Services PROBLEM ?!
Hi all,
I use SQL Server 2005 version 9.00.2153 on Windows XP SP2.
I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds.
When I build Reporting Services project with same cubes as data sources (on same computer), CPU was increased to 100% for more than 30 minutes (process msmdsrv.exe) ... and I interpurt it.
Transfer project to Windows SP1, but same result.

Do you have any idea what happens ?

Best regards,
Siol En

View Replies !   View Related
Reporting Services Authenticating With Analysis Services
Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services.

Problem: Reporting Server does not apply Analysis Services Role after login.

Details:

I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role.

On the Reporting Server I set the data source to :

* Credentials supplied by the user running the report
and
Use as Windows credentials when connecting to the data source

Internally when I connect devsql2005/Reports/ReportName I get the user and password fields. When I fill them in I get the report but I can see all the data while my role was restricted to see only few results.

Can anyone suggest what may be wrong? Any articles or tutorials on how to setup and deploy solutions where Report Server is talking to Analysis Services and NOT Sql Server.

Thank You,

Pavel Hlobil

View Replies !   View Related
Web Services As An Expression In Reporting Services 2005
Hi All,

Is it possible to use Web Services as an Expression in Reporting Services 2005? Has anybody tried it? I want to call a web service method in reporting services.

Thanks,

View Replies !   View Related
Internal Error: An Unexpected Error Occurred In Analysis Services Processing
 

Hi There,
 
I've got this error coming up while running the sql job for AS processing. I can't find anything about it on google or anywhere else. Has anyone had issues like this?
 



Code Snippet
Executed as user: xyzsvc_sqlsvr. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  1:21:02 PM  Error: 2008-04-04 13:21:07.41     Code: 0xC1000000     Source: Analysis Services Processing Task Analysis Services Execute DDL Task     Description: Internal error: An unexpected error occurred (file 'mdprocessdim.cpp', line 3429, function 'MDProcessPropertyJob::OnLaunch').  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:21:02 PM  Finished: 1:21:07 PM  Elapsed:  5.141 seconds.  The package execution failed.  The step failed.
 
 



Thanks
 
Vivek

View Replies !   View Related
The Script Threw An Exception: Exception Of Type 'System.OutOfMemoryException' Was Thrown.
Hi,

I got an strange problem with one of my packages.

When running the package in VisualStudio it runs properly, but if I let this package run as part of an SQL-Server Agent job, I got the message "The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown." on my log and the package ends up with an error.

Both times it is exactly the same package on the same server, so I don't know how the debug or even if there is anything I need to debug?

Regards,

Jan

 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved