1
How "NOT" to expire the ReportSession and ControlID in the request This question is related to VSTS and above parameters in the request. Question is: A script created with VSTS for testers has hard coded values for ReportSession and ControlID in the requests, These IDs are expired after some time and scripts fails to run after few hours. Can some one tell me how to set the session expiration time on these ID's in the Report server so I can increase the value to 60*24*365 (1 year) this would solve my problem with hard coded values in the scripts for above mentioned IDs. Tag: Dropdown won't show values if only one item is available
2
Reporting Services 2005 Deployment - Overwrite .rdl Hi, i have SSRS project which has 40 reports and one datasource. I have deployed my reports to report server and tested. every thing is working fine. but recently when i made changes to the reports and tried to deploy them, they are not getting overwritten. although the data source is getting overwritten as i set the Overwrite property to true. can any one help me Thanks, Srik Tag: Dropdown won't show values if only one item is available
3
AVG MDX Function I have been trying to solve a calculated measure using both the sum/count methods and the avg function, but neither is working for the result that I want. We are trying to come up with an average course score based on an average test score. Example: user takes two tests (test1 twice for 50% and 100% - avg = 75% test2 once for 100%) and the course average would be (75+100)/2 = 87.5%. In our MDX we are getting (50+100+100)/3 = 83.33% instead. We do have a hierarchy set based on course-->test-->test iteration where test iteration is each individual score. The overall average works the way you would typically thing with the sum/count method, but not based on how we want it to calculate AVG(AVG(test1 scores) + AVG(Test2 scorces)). I tried to use the AVG function, but this only works at the lowest level in the hierarchy and then appears to SUM up the results as you go up into the hierarchy (avg test1 75% test 2 100% course 175% -- not sure why the AVG works that way). Can anyone tell me if this is even possible to get the average the way I am proposing or do I need to create some type of an aggregated take will calculations in the data warehouse to reference. Thanks. Tag: Dropdown won't show values if only one item is available
4
Problem Related to Package execution in SSIS Hi, I have the hierarchy of packages.. there are three levels.. first package (say L1) calls two child packages.(say L2_1 , L2_2) the parameters are passed to L2_1 from L1 and it executes completely and successfully. next step is L1 calls L2_2 without any parameters.. and package fails with error as execution of L2_2 failed. when I executed L2_2 individually it successfully executes. L2_2 itself calls 5 other packages (at level 3).. Am not able to identify the possible reason for failure.. Tag: Dropdown won't show values if only one item is available
5
Using Oracle procedures in SSIS Hi Everyone Please pardon my inexperience, I am new to SSIS. I am having some difficulty with using Oracle procedures in SSIS. I have installed and configured the Oracle Client Software for 10g. I have managed to create a connection to the Oracle database that I will be using. I am currently using the Oracle Provider For OLE DB. I want to add an OLE DB Source component to the Data Flow which I then want to configure to use an Oracle procedure to bring back the data that I need. When I want to execute the Oracle Proc in the same way that I would normally execute a SQL Proc it returns an error saying: TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4A. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E4A Description: "Command was not prepared.". Error at Data Flow Task [OLE DB Source [1]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC020204A (Microsoft.SqlServer.DTSPipelineWrap) I have tried using a ADO.NET connection and then using a Data Reader Source component but I get an error with my SQL Statement saying "Invalid SQL Command" Could anyone please provide me with some information on what I am doing wrong Or possibly point me to information that will help me I have been searching the net non-stop without success. Tag: Dropdown won't show values if only one item is available
6
Adding different columns from different table I have three tables. Member(name, address, ID) Loan(ID, startdate, amount) Deposite(ID, startdate, amount) I wanna create a report which look like this. ID MembersName startdate address etc Member can be either borrower or a depositor. I'm thinking of using inner join. Can anyone help me to write the query Thanks Tag: Dropdown won't show values if only one item is available
7
SSIS (DImension and Fact Tables) Hi, I am new at SSIS and I am trying to create a Datawarehouse using SSIS. I have the data files as flat files I have the Dimensional Model ready on Paper and Now I need to use the SSIS for the ETL process. I am trying to figure out how to make dimension tables in SSIS I mean I want to create the 5 Dimension tables and then create a Fact table out of it but I cant understand where to start Can any one tell me how we create Dimesion tables in SSIS. Like one of the dimesion tables I need to create uses 2 flat files and is like a flattened dimension, How would I create this in SSIS Even if there is any tutorial which shows this step by step do let me know. I would really appreciate any guidance on this. Thanks, Sarang Tag: Dropdown won't show values if only one item is available
8
PMML and BizTalk Hello! Anybody know if can I use (and how can I use) PMML with the rule engine of Biztalk Server, or if there is some module that translate PMML format to Biztalk. Sorry by my english. Tag: Dropdown won't show values if only one item is available
9
Using variables in a data reader source Greetings SSIS friends, I have tried using a sql command for my data reader source. I added the following expression to my datareader source : "select * from result where result_id > " + @.[max_result_id] but I get the following error message : The SQL command has not been set correctly. Check SQLCommand property. I then got rid of the variable (defined at package level) and replaced it with a string like so : "select * from result where result_id > " + "123456" but I still get the same error message! What am I doing wrong ! Please advise. Tag: Dropdown won't show values if only one item is available
10
Peer-to-peer replication Questions Our current setup is as follows: serverA - DB1, DB2 ServerB - DB3 ServerC - DB4, DB5 Question 1 : In peer-to-peer, is this the right setup ServerA - DB1, DB2, DB3, DB4, DB5 ServerB - DB1, DB2, DB3, DB4, DB5 ServerC - DB1, DB2, DB3, DB4, DB5 Question 2 : Are we backing up all DBs or just DB1 Question 3: When serverA.DB1 goes down, does it affect the other DB1s Question 4: Can any of the DBs publish to any server say a reporting_serverG that is outside the peer-to-peer topology. Question 5: Is it best to have .mdf, .ldf, tempdb, etc. on local drive or in the SAN Question 6: What is the recommended NLB hardware needed to handle peer-to-peer Tag: Dropdown won't show values if only one item is available
11
Running ALTER on stored procedure removes delay Every so often we have problems running several stored procedures on our database. Specifically, our applications begin timing out. We have been able to fix the problem everytime by running an ALTER on our stored procedures. Note that the we don't change anything in the tsql, we just run ALTER. Example: If we created the SP using: CREATE PROCEDURE [dbo].[Test] AS SELECT * FROM TABLES running ALTER PROCEDURE [dbo].[Test] AS SELECT * FROM TABLES will fix our timeout problem. What could running the ALTER do which which could get rid of timeout issues Tag: Dropdown won't show values if only one item is available
12
BIDS and SSMS very slow on Windows XP SP2 Hi, opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action. Is anybody aware of this problem We didn't have those problems on Win2000 so I guess it is XP related. Any ideas Regards Norbert Bender Tag: Dropdown won't show values if only one item is available
13
TDSSNIClient init failure I started getting this error when I tried to start my local SQL Server yesterday and nothing I do seems to help: Error: 17182, Severity: 16, State: 1. TDSSNIClient initialization failed with error 0x2, status code 0x35. Error: 17182, Severity: 16, State: 1. TDSSNIClient initialization failed with error 0x2, status code 0x1. Error: 17826, Severity: 18, State: 3. Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. Error: 17120, Severity: 16, State: 1. SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. The only thing I did recently was move the My Documents folder from my local machine to a folder on a network share (to make sure my docs are backed up) via a right click on the My Documents folder in the Start menu, then pick the new location. I've since moved it back, but the above error persists. Also, when I try to configure the server's protocols, I'm not able to enable any of the protocols. I can right click the protocol and click enable, then I get the error that says it'll take effect when i restart the service, but then in the display, it still says disabled. Refreshing doesn't change the status. The client protocols are enabled though. Any help would be greatly appreciated (since the service never successfully starts)... Tag: Dropdown won't show values if only one item is available
14
Pls help with Package Configurations Hi I created an xml configuration file and specified all the details,i have saved the package with protection level as "dont save sensitive".We are running the package thru autosys.But the package is repeatedly failing,not sure whats wrong with this one. Pls can someone help me with this Thanks in Advance. SVGP. Tag: Dropdown won't show values if only one item is available
15
Dynamic SQL error Hello, Im trying to do dynamic SQL but get the following error with the SQL below Must Declare the variable '@.TopRange' can someone please help Declare @.TopRange int Declare @.BottomRange int Declare @.SQL Varchar(1000) Set @.TopRange = RTRIM(LEFT(REPLACE(@.param_leadage,'-',''),2)) Set @.BottomRange = LTRIM(RIGHT(REPLACE(@.param_leadage,'-',''),2)) SET @.SQL = 'SELECT dbo.tblCustomer.idStatus, dbo.tblCustomer.idCustomer, dbo.tblCustomer.DateSigned' + ' FROM dbo.tblCustomer' + ' WHERE DateDiff(day, dbo.tblCustomer.DateSigned, GetDate()) >= @.TopRange AND DateDiff(day,dbo.tblCustomer.DateSigned, GetDate()) <= @.BottomRange' EXEC(@.SQL) Tag: Dropdown won't show values if only one item is available
16
Parent Package Variables and SQL Package Store Hello All, I have a Master Package which calls a group of other packages out on the SSIS Package Store using parent / child and a number of variables. These seem to work when passing various audit information (audit key, record counts, etc) but when I try to pass a variable for the connection string and assign it via an expression to the connection manager, I get the Master Package writing to the correct database and the children package writing to their "default" database which is supplied as the default value in the variables which should be populated by the parent task. i.e., I end up with my master package audit information in database a and child package audit and transactions in database b, even though the packages associated with these transactions are supposed to be reading the connection string from a parent variable. Any clues or suggestions Edit: It is still passing along the correct parent audit information and record counts, it's just not connecting to the correct database by the variables holding the connect string Thanks for your time. Tag: Dropdown won't show values if only one item is available
Next
1
Full & differential restore Hi All, I am trying to restore full backup in Sql Server 2005. I am using the following query to restore full backup. "Restore database Testdb from Disk = 'C:\Testdbfull.bak' with move 'Testdb' to 'C:\DB\Testdb.mdf ', move 'Testdb_log' to 'C:\DB\Testdb_log.ldf ', norecovery " The above query is running successfully and database restored. But i am not able to access this database since in the database tab it is showing 'Testdb (Restoring)' The next day I want to restore the differential database backup so i used the 'norecovery' statement. please help why it is showing as '(Restoring)' Thanks in advance, Senthil Tag: Dropdown won't show values if only one item is available
2
Cannot delete report from Report Builder We have successfully implemented Forms Authentication with Reporting Services. While users can create new reports and modify existing reports in Report Builder without a problem, the "Delete" option is grayed out. The "Delete" option is even grayed out for the all-powerful "admin" user defined in the RS configuration files. There is no problem deleting reports using Report Manager. What security setting is Report Builder checking when it determines whether the delete option should be available or not Tag: Dropdown won't show values if only one item is available
3
MDX calculated measure Hi, can someone help me write a calculated measure that shows: all customers / all customers we sold an article to I guess that I need some form of crossjoin or something... someone have any idea that you want to share with me Code Snippet count ([Customer].[Customer].members) / [ ] Tag: Dropdown won't show values if only one item is available
4
Convert Date from DatePicker to TimeId value I have the following Code that returns the results I require Code Block SELECT { [Measures].[Total Square Area] } ON COLUMNS , NON EMPTY { { { [Time].[Date].&[29013] : [Time].[Date].&[29102] } * { [Location].[Market].AllMembers } * { DESCENDANTS( [Developer].[All Developer], [Developer].[Name] ) } *{ [DevelopmentType].[Development Description].AllMembers} } } ON ROWS FROM [QMSConstruction] I am trying to get this working in a reporting services report, however they lient wnats to use a date picker that will pass a date such as 1/1/2007 3/31/2007 to the above MDX once I add the result of the paramter choices to replace .&[29013] The MDX will then fail. I think this is because the TimeId is used as the Key in the dimension as opposed to the actual in order to correctly order the dimension date values, so the MDX requires a TimeId as opposed to the date. How do I go about converting the date to match up with the expected TimeId value Really a bit stumped with this Tag: Dropdown won't show values if only one item is available
5
New version of MSSQL CE RC1 I noticed the new date on the download page for RC1 of MSSQL CE. I downloaded it and compared it to the last one (I think it was maybe dated 11/17/06 ) and found there are differences between the 2 msi files. That leads me to some questions: 1. What has changed with this latest RC1 release Any fixes that would make this a "required" download 2. Can I get away with just uninstalling the old MSSQL CE RC1 and reinstalling the new one i.e. without having to go through all of the other prerequisite, exacting steps required to get MSSQL CE working with VS.NET. 3. Why wouldn't this new file be named RC2 Slipstream releases are never a good idea, as they just add confusion. Thanks for any input. Dan Tag: Dropdown won't show values if only one item is available
6
Backup and restore of mdf database Hi, I've got a following problem: I have a VB 2005 application that uses SQL Server 2005 Express as DB engine. This application has it's own database stored in mdf file, e.g. invoices.mdf with corresponding log file. I'd like to give users opportunity to backup and restore this DB file from this application (there won't be a system administrator, only end-users). Unfortunatelly after I connect to this database (using user instance of SQL Server), I'm unable to read or copy it, despite the fact, that I close all connections. And I'm sure that all connections are closed. Database files become accessible for reading after I close the whole application. I've tried to detach this database using sp_detach_db prcedure, but it can't be done with database I'm connected to. I will be grateful for any help. Tomasz Tag: Dropdown won't show values if only one item is available
7
Generating reports on fly Hello, SRS 2005 provides functionality for loading and rendering reports on fly using LoadReportDefinition and Render methods defined in ReportExecutionService webservice. I was wondering if the same/similar behaviour can be accomplished in Reporting Services 2000. Thanks in advance, Kobi Tag: Dropdown won't show values if only one item is available
8
Sql server report service samples not installed ? Hi,I have installed the Sql server 2005 standerd edition to my computer but i cant find this folder to view report service authentication samples C:\Program Files\Microsoft SQL Server\90\Samples but i can see C:\Program Files\Microsoft SQL Server\90 folder ! any idea sujithf Tag: Dropdown won't show values if only one item is available
9
How to see the SQL Statement I want to write all insert/update/delete staments to seperate text file I know i can use the trigger to get the task Can anyone help me to write the T-SQL statement for that Thanks Niroshan Tag: Dropdown won't show values if only one item is available
10
Stored Procedure HI friends I am new to sql server,i am having a doubt please clarify it. I am having a table with 10 fields and i have to insert data into it from the front end(front end language is DOTNET) but i want to insert all of them at once into the table instead of assigining variables for each field . can we use any method where these collection of values are passed into stored procedure and they are assigned to the respective field in the stored procedure example like passing collection of values to stored procedure and seperating them there please give me reply as soon as possible your help will be appreciated Regards Srikumar Tag: Dropdown won't show values if only one item is available
11
SQL Agent jobs hanging Periodically I have different SQL jobs (which run a DTS packages) that are scheduled to run daily and one or two will hang. Notifications are setup to send out email to certain personnel as well as write to the event log it the job fails. The problem is, is that, because it hangs no notification is sent out becuase it hasn't failed and sometimes takes days before anyone notices that the job is no longer running. Once it is discovered, I stop the job and then it starts to run on its daily schedule without problems. How do I set up a job notification for a hung job Or better yet, is there a way to kill the job after it runs for a set period of tile like I can do with a sheduled task Any help will be appreciated. Tag: Dropdown won't show values if only one item is available
12
How? Sharing configuration info among packages The scenario is an ETL that takes flat file feeds via FTP to move data into varous production SQL server databases nightly. There are a number of packages involved, and this depends upon the type of data being sent. There are a set number of servers and databases to receive the transformed data. I would like to be able to define say 3 servers, and maybe a couple of databases in each one time in the configuration. For simplicity lets say 6 databases total. I would like a single point of maintenance for these 6 locations. I would like all connection managers in all packages in all solutions to share these 6 settings in all connection managers. Is this possible From my initial attempts, it would appear each package gets its own independent list of connection managers and which must be configured separately. I don't see how to share settings, which is really where the power of SSIS configurations would be. Similarly, I would like to be able to locate flat files at given paths. The package may know the name of the file it is looking for, or the file it will create, and the folder path needs to be computed from a configured folder root, and for the package connection manager to store only the name of the file, which never changes. I can not see how to set something like this up with connection managers and configurations. Perhaps I still need a highly customized solution to achieve this, as we did for DTS, where we would only execute packages using our own executor, which would load the package, search out all environment specific settings and modify them on the fly prior to executing the package. Thanks for any direction you can give here. The books I've read seem to imply I might be able to do what I need here, but I can't seem to find the mechanics of making it happen. Tag: Dropdown won't show values if only one item is available
13
Distriubtion Error on Stored Procedure Setting up Transactional Replication. Log Reader Agent successfull. Snapshot Agent successfull. Distribution Agent Error (Replication is failing because of this error. I don't know what is wrong with the stored procedure that causes it not to replicate): Date 1/19/2007 10:28:13 AM Log Job History (IS36-MMS_20061213-MMSRepTest-IS4-30) Step ID 2 Server IS4 Job Name IS36-MMS_20061213-MMSRepTest-IS4-30 Step Name Run agent. Duration 00:00:11 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message 2007-01-19 16:28:24.700 Category:COMMAND Source: Failed Command Number: Message: CREATE PROCEDURE "dbo"."spBTG_GetEventsSince"(@.EventMin datetime, @.BoatID int) AS BEGIN create table #TmpEvents ( BoatHistoryID int null, PositionID int null, Event varchar(50) null, EventDateTime datetime null, Direction char(1) null, River char(3) null, Mile numeric(6,2) null ) insert into #TmpEvents select bh.BoatHistoryID, null, Event, EventDateTime, Direction, riverloc, mileloc --jds 6/22/05 hardcoded index to fix it when you call it from vb -- from 2007-01-19 16:28:24.700 Category:NULL Source: Microsoft SQL Native Client Number: 1018 Message: Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax . Here is the entire source of the sp: GO CREATE PROCEDURE [dbo].[spBTG_GetEventsSince](@.EventMin datetime, @.BoatID int) AS BEGIN create table #TmpEvents ( BoatHistoryID int null, PositionID int null, Event varchar(50) null, EventDateTime datetime null, Direction char(1) null, River char(3) null, Mile numeric(6,2) null ) insert into #TmpEvents select bh.BoatHistoryID, null, Event, EventDateTime, Direction, riverloc, mileloc --jds 6/22/05 hardcoded index to fix it when you call it from vb -- from mtsEventHistory eh (NOLOCK) -- left join mtsBoatHistory bh (NOLOCK) on bh.EventID = eh.EventID from mtsEventHistory eh (NOLOCK, index(PK_MtsEventHistory)) left join mtsBoatHistory bh (NOLOCK, index(IDX_MtsBoatHistory_BoatID)) on bh.EventID = eh.EventID where EventDateTime > @.EventMin and BoatID = @.BoatID and voidflag = 0 And eh.Event IN ('Pickup','Drop','Log Exchange','Off-Layup','Off-Repair','On-Layup','On-Repair','Morning Log','Bt Trip Dir Chg','End Boat Charter Out', 'Begin Boat Charter Out', 'Begin Boat Charter In') insert into #TmpEvents select null,BoatPositionID, Description, PositionDateTime, Direction, river, mile from mtsBoatPosition (NOLOCK) where PositionDateTime > @.EventMin and BoatID = @.BoatID select * from #TmpEvents Order By EventDateTime drop table #TmpEvents END Tag: Dropdown won't show values if only one item is available
14
Aggregation Issue I have a cube that I designed aggregation with 12% performance in MOLAP storage mode. However, when I ran query it read from partition not from aggregation. How can I change so that the query read from aggregation Thanks in advance, A. Imamuddin Tag: Dropdown won't show values if only one item is available
15
Decision tree in MS SQL Server Hi, Can we represent the Decision Tree in a programatically way in an .NET application I understand that the outcome of a Decision Tree model can be integrated into an .NET application but not sure if we can also visualize it. Does MS SQL Server support any API to render such a tree Thanks a lot! Tag: Dropdown won't show values if only one item is available
16
check sql server edition is there a way to get the edition(e.g. sqlexpress,enterprise etc...) of an installed sql server instance in your local machine programatically Tag: Dropdown won't show values if only one item is availableI have a report that has 2 dropdowns, selecting from the first dropdown populates the second one. This works fine in the BI Studio.
When I deploy this report to the 'Report Manager' and make a selection from the first dropdown, the second dropdown loads (as expected). I tried to select from the second dropdown (which has only 1 item - which is correct), the dropdown does not appear correctly - as in, I can't see that item.
Since we can't attach anything here, below is the link to a screenshot of my issue:
http://docs.google.com/View docid=ddd6j2xn_52c5qd5
If you look closely at the screenshot from the link above, you'll see that there is a value in the second dropdown - it just won't show completely - as if the dropdown is not rendering correctly. I can view source on the page and see that the dropdown has a value.
What appears to be happening is the if only 1 item is in the second dropdown and that item is longer than the size of the dropdown, the dropdown won't render.
Here is my value for the second dropdown '012 Candy Gadler David Thapero'. This is the only value in the second dropdown. - You can try 35 chars or more in the dropdown to confirm.
Notes:
+ No special chars are in either dropdown
+ I am using IE 7 (Also had someone test this on IE 6 - same problem)
+ Using Visual Studio 2005 to build report - where this works fine
Work around:
+ If I add another item to the dropdown via a UNION query, I see the original value + the new item in the dropdown #2
Please share your thoughts
Thanks,
h.
|||SNMSDN
Weird, because I cannot make that happen. I created two dropdowns with items that are each way longer than yours, the second one is dependent on the first and has only one item, and I don't get that scrollbar in the dropdown, the page just becomes wide enough for the dropdowns and I have to scroll the whole page across to see the second dropdown, but it displays fine. I tried it in Report Manager, then I tried it in the Report Viewer and there it also works although it looks a little different. Instead of the whole report getting wider, just the parameters section gets wider, so I have to scroll it, but again the dropdown is full width.
I'm using Reporting Services 2005 with SP1.|||Are your parameters Multi-value Try making them multi-value. Your assistance is appreciated.|||SNMSDN
Haha - that's it, if it's multivalue I cannot see the single value either.
Someone from MS - we have a bug.|||It is a bug. Actually the value is there, but horizontal scrollbar took too much space, and completely covered it.
As far as I remember it was fixed in Sql Server 2005 SP1|||It isn't fixed in SP1, because I'm using SP1, hopefully in the SP2|||Sorry, I was wrong. There is a QFE for this issue. And it will be fixed in SqlServer SP2
rs12345 wrote:
gbarnett: