execInfo = rsReportExec.LoadReport(strReportPath, strHistoryID). The errro was "System.Web.Services.Protocols.SoapException: The path of the item "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=119&nvchrWhoRan=DYW" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=119&nvchrWhoRan=DYW" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply.
I copied and pasted the path on the URL and it worked. What did I miss in the code? Why strHistoryID is required as it is nothing? Please refer to http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Private Sub sExecuteReportingServicesReport()
Dim rsReportExec As ReportExecutionService = New ReportExecutionService
I'm trying to use the message queue task in SSIS 2005 and not getting very far. Right off the bat I'm trying to create a Message Queue Connection Manager and when I enter the path, trying both "seawxxxx estq" (my local computer name) or ". estq" and test it, it comes back with "invalid path". Have done quite a bit of searching around and can't find anything on this particular error.
I run SB between 2 SQL servers. In profiler on an initiator side I see next error: 'This message could not be delivered because its message timestamp has expired or is invalid'. For the conversation we use best practice, i.e. target closes a conversation. Target side succeed to close conversation, but initiator still stay in DO (disconnect_outbound). What is a reasone for the error? What to do?
I see in profiler this error: "This message could not be delivered because its message timestamp has expired or is invalid" What is a reason for error?
I used the DTSmigration wizard to transfer DTS jobs from SQL2000 to SQL2005. The wizard transfered the old DTP packages without error but now I cannot access some of them. The old DTS packages had names of the form <program_name>**<output_type> for example JM-102**excell. When I try to access (or delete) the new packages in SSIS I get the error:
The path is not valid. Parameter name: packagePath (MsDtsSrvr)
I'm trying to restore my DB to a new server and also a new instance of SQL 2005 SP2+ hotfix KB934458.
I've successfully restored my MSDB database and everything seems to be working fine, but now when I'm trying to do a restore of my Database RMc to the attached SAN,
I'm getting the error:
System.Data.SqlClient.SqlError: The path 'H:' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive. (Microsoft.SqlServer.Smo)
the H: is the Drive letter for my attached SAN.
The path I'm trying to give is H:\DBData for the MDF-file and the H:DBLog for the LDF-file.
I have the DB running on another server also with a SAN attached and there are no problems.
I also moved the MSDB to another drive on the SAN - a G-drive without any problems.
Hello. I am attempting to add a distribution database to an instance of SQL Server on my local PC. I am using SQL 2005 Developer Edition. I am able to set the instance up as a distributor using the following command:
It's not due to permissions on that particular folder. I have tried using other folders, all with the same results. Also, I am an Administrator on the PC, so I have full permissions. I have tried running the SQL Server services as myself and Local System. Same results both times. Co-workers with apparently the same setup are able to create the distribution database without a problem.
I am working on the SSIS FTP Task that transfer file from one FTP server to local location, rename the file name, and finally transfer the renamed file to another FTP server. So I defined 2 FTP tasks.
For the FTP file receive operation, I need the remote path to be updated by a script and pass to the user define variable. So I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPSourcePath where the variable is set in the script with "/DMFTP/filename1.jpg"
For the FTP file send operation, I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPDestPath where the variable is set in the script with "/DestFTP/"
After all the setting, the FTP Task box show me the error as "Variable "FTPSourcePath" doesn't start with "/". Another FTP box show me "Variable "FTPDestPath" doesn't start with "/"
I am having difficulty restoring a database (DB_1) with 2 datafiles and one log file, DB Structure is as following:
Filegroup PRIMARY with file name 'fnm_data' with physical file name and location D:dbfile_1.mdf, Filegroup 'FG1' with file name 'fgnm1_data1' with physical file name and location F:dbfile_FG1.mdf, One log file with file name 'fnm_log' with physical file name and location (E:loglog_db.ldf)
{Note} Logfile resides on E drive whereas Datafiles reside on several other drives.
I need to restore the DB on another machine. And I need to move the log file to a drive other than E.In this case it is K drive. Hence I have used the following code,
restore log DB_1 from disk='M:kupccciclog.txt'
WITH RESTRICTED_USER , MOVE 'fnm_log'
TO 'K:DBlog_db.ldf', recovery, replace,RESTART
go
When I try to restore from backup files, I keep error message saying "Physical file name E:loglog_db.ldf may be incorrect." 'fnm_log' cannot be restored. Use Move command to identify a valid location for the file.
Even though I am using Move command to move the log file.
Then I found that if I create a drive with E: and a folder named 'log' then restore program runs alright. That is, when E:log exists then code does run smoothly. All the restore code is looking for the presence of path of the log file from where it is been backed up. In this case it is E:log folder. Once the database is restored I could kill that directory and nothing happens. Also log file has been restored on K:DB only.
Why the restore code is looking for the initial drive letter and path even though I have used Move command? Is there an issue in my code?
i'm working on an application using vs 2005, sql server2000, with c# asp.net i can access many tables in my db that the dbo is the dbowner for them, but when i access few tables that the owner for them is dswebwork, i recieved an error says, invalid object name tbluser...which tbluser is table name...this is the error message in details..... Invalid object name 'tblUsers'. 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: Invalid object name 'tblUsers'.Source Error:
Line 57: string passWord = txtPassword.Text; Line 58: Line 59: Users users = new Users(Constants.DB_CONNECTION, Line 60: userName, passWord); Line 61: Source File: e:web worksWebworksDSCWebWorksLoginMaster.master.cs Line: 59 Stack Trace:
Hi Friends, I have the below procedure in my local system for sending automatic mails in sql server 2005. Create Procedure dbo.SendEmail1@To VarChar(500), @From VarChar(100), @Subject VarChar(200), @Body VarChar(1000), @SMTPServer VarChar(50)ASDeclare @Object int, @Hr int, @Src VarChar(255), @Desc VarChar(255)--Create Message objectExec @Hr = sp_OACreate 'CDO.Message', @Object OUTIf @Hr <> 0BeginExec sp_OAGetErrorInfo @Object, @Src OUT, @Desc OUT SELECT hr=convert(varbinary(4),@Hr), Source=@Src, Description=@DescReturnEnd--set sEndusing propertyExec @Hr = sp_OASetProperty @Object, 'Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sEndusing")', '1'If @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set port propertyExec @Hr = sp_OASetProperty @Object, 'Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/SEndUsingMethod")', '25'If @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set smtp server propertyExec @Hr = sp_OASetProperty @Object, 'Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver")', @SMTPServerIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--Update the configurationExec @Hr = sp_OAMethod @Object, 'Configuration.Fields.Update', NullIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set TO propertyExec @Hr = sp_OASetProperty @Object, 'To', @ToIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set FROM propertyExec @Hr = sp_OASetProperty @Object, 'From', @FromIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set Subject propertyExec @Hr = sp_OASetProperty @Object, 'Subject', @SubjectIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set HTMLBody propertyExec @Hr = sp_OASetProperty @Object, 'HTMLBody', @BodyIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--SEnd the mailExec @Hr = sp_OAMethod @Object, 'SEnd', Null If @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--No memory leaks!Exec @Hr = sp_OADestroy @ObjectIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd and executed as SendEMail1 'x@x.com','a@a.com', 'Sending email through Stored Procedure', 'Body : An Email can be sent through stored procedure... and this is SAMPLE', 'smtpservername' This is working fine when I excuted the above procedure in the local system. Same procedure I have created in the developement machine and excute it the it is giving error as 0x80040220 CDO.Message.1 The "SendUsing" configuration value is invalid. NULL 0
I need the suggestions on the above error and how to solve this in our development server.
I'm having trouble with cube processing. While processing a code I'm getting a "Invalid column name MessageType" error.
I unfolded the cube, then I opened "measure groups", my failing dimension (ServiceRequestDim) and the partition.
In the partition I opened the "Source" attribute so it now includes my column which was missing. But it didn't solve the issue.
If I get the query used during the process I'm getting this :
SELECT DISTINCT [ServiceRequestDim].[MessageType] AS [ServiceRequestDimMessageType0_0] FROM ( Select IsNull(IsDeleted, 0) as IsDeleted, [ServiceRequestDimKey], IsNull([Status_ServiceRequestStatusId], 0) as [Status_ServiceRequestStatusId],[Status],IsNull([TemplateId_ServiceRequestTemplateId], 0) as
[Code] ....
In the nested query which defines ServiceRequestDim the messagetype attribute is still missing. In my source datamart the ServiceRequestDim has the "MessageType" column.
So the question is where do I change the nested request that the dim process use to reflect the actual columns in my datamart .
i was deleting a row from my gridview.this fail ("System.Data.SqlClient.SqlException: Invalid object name 'MESSAGE'.") consists what must i do ?My SQL query is "UPDATE MESSAGESET DELETIONSTATUSTO = 1,_LASTMODIFYDATE =getdate() WHERE (_ID = @ID)"
I am trying to set up a ODBC connection to a remote database using the ODBC data source administrator. I am getting an error message complaining of an invalid instance(). The database I am trying to connect to does have a default instance and a named instance. Do I need to specify the instance name somewhere in the connection settings? I tried specifying the server name as <Remote computer IP Address>/<Instance Name> but this didn't work. Any ideas?
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
When trying to install Business Contact Manager (BCM) for Outlook 2007, the setup failed and I was refered to a log file in my Local Settings/Temp folder. The log actually says that Business Contact Manager was installed sucessfully! BCM is supposed to install SQL Express 2005 as an instance or as instance if SQL Express is already installed. There is an MSSMLBIZ instance in Services..
Who can I send the Log File to for analysis and the fix feedback?
When I first went into Computer Management and clicked on Services and Applications in the left panel, the error message appeared "Snap-in failed to intialize. Name: SQL Server Configuration Manager CLSID:{CA9F8727-31DF-41D2-975C-887D84903967} This message diappeared when I clicked on Services and Applications again. Under Services, there are 3 SQL services - one is an application that was uninstalled 3-4 weeks ago and I disabled this service. The other 2 are: SQL Server (MSSMLBIZ) and the other one is SQL Server (SQLEXPRESS) When I tried to start either of the last 2, the message appeared: Services "Could not start the SQL Server (MSSMLBIZ) service on Local Computer. Error 3: The system cannot find the path specified. Under Program Files/Microsoft SQL Server/MSSGL.1 folder is mostly empty. So, it seems like the Path in the Registry is not valid and that nothing is being installed in the MSSQL.1 folder. If so, how do I fix this?
How do I get the BCM SQL instance to install and run properly? what do the messages in Services mean and how do I resolve these.
After updating TempDB path to a wrong path (without file name only folder name) the service is not starting. How can i sovle this and start the service
I am having trouble specifying a message body that is valid. I mean for the client to send. If I leave it as null then everything is ok but if I create a memorystream and add a line of text it reports back it did not pass validation. I do not understand this and am not sure what to do. I need to send a message based on a code and text but do not know the format of the body that is allowed. The code I am refering to comes out of HelloWord_CLR because that is what I am formating my sample after. I call it the same way it calls the return message done in ServiceProc. I need to know the message format including body since this does not seem to work. A sample of the call is bellow.
// Create an empty request message
string Msg = "Hello";
MemoryStream body = new MemoryStream(Encoding.ASCII.GetBytes(Msg));
Sorry if this is not the correct forum... I am using the FOR XML PATH feature of SQL Server 2005 (Amazing!!) Is it possible to return multiple rows? For example:SELECT 'Field1' AS 'Element1/@Field1'FROM TableFOR XML PATH('Repeating') Say the above SELECT returns 5 records, I want it to return 5 rows of xml in my ASP.NET application. So in this case each of the 5 rows would contain:<Repeating><Element Field1="Field1"></Element> <Repeating>Instead of returning 1 row with all the xml together.
When using sp_xml_preparedocument @hdoc OUTPUT, @doc I see code everywhere with huge xml text embedded in some store procedures. Can the SELECT XXX FROM XXX FOR XML PATH('') syntax be used instead to produce the second parameter @doc (xmltext) for sp_xml_preparedocument ?
Im trying to reference a ExcelFilePath connection properties using a UNC path, however it doesnt seem to like it, when i use a mapped drive everything works fine.
Hello to all, help, help,... i have with this problem since 3 weeks, until now i cann't resolve this problem. Maybe can somebody help me. I am hopeless. i have a data table ValidRelationship, i will check if there is a relationship between two members by this table. datas in the table ValidRelationship: IDMember IDOtherMember IDType
3700 3726 10000
3726 3700 10000
3742 3672 10000
3672 3742 10000
3422 3548 10000
3548 3422 10000
3548 3717 10000
3717 3548 10000
3675 3695 10000
3695 3675 10000 I will give two member and check their Relationship with a sql query. but it can be that this two member have no relationship. So i define here that man should search processor <= 6 . To better describe i use a example: max. Result of this query is: 1-2-3-4-5-6. If this is a relationship between 1-7 is 1-2-3-4-5-6-7, but i will give a answer that this is no relationship between 1-7. because processor > 6. But my problem is: this query executing is too slow. if i habe two member no relationship, the time of this complete sql query to execute is more than 1 minutes. Is my algorithm wrong, or where is the problem, why this executing is so slow? How can i quickly get the relationships between two member, if my algorithms is not right? The following Query is only to processor = 3, but it works too slowly, so i don't write remaining processors. declare @IDM int; declare @IDO int; set @IDM = 3418; set @IDO = 4270 select top 1 IDMember from v_ValidRelationships where IDMember = @IDM and @IDO in (select a.IDOtherMember from v_ValidRelationships as a where a.IDMember = @IDM)
select top 1 a.IDMember, b.IDMember from v_ValidRelationships as a, v_ValidRelationships as b where a.IDMember = @IDM and b.IDMember in (select c.IDOtherMember from v_ValidRelationships as c where c.IDMember = @IDM) and @IDO in (select d.IDOtherMember from v_ValidRelationships as d where d.IDMember = b.IDMember )
select top 1 a.IDMember, b.IDMember, e.IDMember from v_ValidRelationships as a, v_ValidRelationships as b, v_ValidRelationships as e where a.IDMember = @IDM and b.IDMember in (select c.IDOtherMember from v_ValidRelationships as c where c.IDMember = @IDM) and e.IDMember in (select f.IDOtherMember from v_ValidRelationships as f where f.IDMember = b.IDMember) and @IDO in (select d.IDOtherMember from v_ValidRelationships as d where d.IDMembe = e.IDMember)
If someone has a idea, please help me. Thank a million Best Regards Shasha
I have my SqlDataSource with my connection string:<add name="ConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersLaurensDesktopstockmanASP****.accdb" providerName="System.Data.OleDb"/> but I wanted to make a relative path from it because when I put it online i get an error. Thanks in advance
Hey everyone, I'm in the midst of setting up hMailServer on my server and at one point it tells me to enter the name of my database I setup for my email. I entered my database name along with the username and password to access the database. What I'm lost on is the database server address. I thought that would be localhost but I wasn't quite sure and I was hoping that someone might be able to help me with this. Thanks for any help, QWERTYtech
I am having difficulty restoring a database (DB_1) consists of 2 datafiles and one log file, DB Structure is as following:
Filegroup PRIMARY with file name 'fnm_data' with physical file name and location D:dbfile_1.mdf, Filegroup 'FG1' with file name 'fgnm1_data1' with physical file name and location F:dbfile_FG1.mdf, One log file with file name 'fnm_log' with physical file name and location (E:loglog_db.ldf)
{Note} Logfile resides on E drive whereas Datafiles reside on several other drives.
I need to restore the DB on another machine. And I need to move the log file to a drive other than E.In this case it is K drive. Hence I have used the following code,
restore log DB_1 from disk='M:kupccciclog.txt'
WITH RESTRICTED_USER , MOVE 'fnm_log'
TO 'K:DBlog_db.ldf', recovery, replace,RESTART
go
When I try to restore from backup files, I keep error message saying "Physical file name E:loglog_db.ldf may be incorrect." 'fnm_log' cannot be restored. Use Move command to identify a valid location for the file.
Even though I am using Move command to move the log file.
Then I found that if I create a drive with E: and a folder named 'log' then restore program runs alright. That is, when E:log exists then code does run smoothly. All the restore code is looking for the presence of path of the log file from where it is been backed up. In this case it is E:log folder. Once the database is restored I could kill that directory and nothing happens. Also log file has been restored on K:DB only.
Why the restore code is looking for the initial drive letter and path even though I have used Move command? Is there an issue in my code?
How do I dynamically change the file path for the source file in DTS? Can i use global variable?. if so , How do i use it in the connection task. Appreciate your help.
15 or so databases are being backed up overnight to a remote server using UNC paths. All bar one database is being copied fine. The one that isn't is the largest at 8gb. The error in the log is OS error 64 (the network name could not be found).
Now I've got the customer looking into any reasons why their network may be interrupted overnight, but while googling around I saw someone mentioned that backing up to UNC with databases over 2gb can cause problems? Is there any truth in this?
I am inclined to reccomend the user backs up the database to a local drive and then sets up a scheduled task to copy it across, but I'm interested to see if this is a known issue.