Analysis Services

Hi All,
I have an issue registering a server using Analysis Manager, whenever I try
I get a fairly generic error saying:
'the server is either not started or too busy'.
I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
2003 Server Enterprise box. This server is running IIS 6.0, Project Server
2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
register this server to allow me to migrate the Analysis Services Repository
to a SQL database but so far to no avail.
Any advice or assistance anyone can offer would be most appreciated.
Regards,
Darren KingHellow Darren. I too was trying to get Analysis Services up and running for
the purpose of using the portfolio modeling etc. on Project Server. It is a
funny coincidence that we ran into similar problems. I've finally gotten this
stuff working after much bumbling around. I uninstalled and re-installed
Analysis Services 4 -5 times, with each install presenting its own strange
results. The reason I am sending you this reply is assuming this last
installation holds up, I could review with you my install and the settings
that I am using and perhaps that will get you past your present hurdles. It
is often difficult to diagnose using these forums. If you care to send me an
email at
johnca@.asg.com and we can set up a time to converse about your situation.
If you have already resolved your problems, then no need to reply.
"Darren King" wrote:
> Hi All,
> I have an issue registering a server using Analysis Manager, whenever I try
> I get a fairly generic error saying:
> 'the server is either not started or too busy'.
> I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
> 2003 Server Enterprise box. This server is running IIS 6.0, Project Server
> 2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
> register this server to allow me to migrate the Analysis Services Repository
> to a SQL database but so far to no avail.
> Any advice or assistance anyone can offer would be most appreciated.
> Regards,
> Darren King
>
>

Analysis Services

Hi All,
I have an issue registering a server using Analysis Manager, whenever I try
I get a fairly generic error saying:
'the server is either not started or too busy'.
I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
2003 Server Enterprise box. This server is running IIS 6.0, Project Server
2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
register this server to allow me to migrate the Analysis Services Repository
to a SQL database but so far to no avail.
Any advice or assistance anyone can offer would be most appreciated.
Regards,
Darren KingHellow Darren. I too was trying to get Analysis Services up and running for
the purpose of using the portfolio modeling etc. on Project Server. It is a
funny coincidence that we ran into similar problems. I've finally gotten thi
s
stuff working after much bumbling around. I uninstalled and re-installed
Analysis Services 4 -5 times, with each install presenting its own strange
results. The reason I am sending you this reply is assuming this last
installation holds up, I could review with you my install and the settings
that I am using and perhaps that will get you past your present hurdles. It
is often difficult to diagnose using these forums. If you care to send me an
email at
johnca@.asg.com and we can set up a time to converse about your situation.
If you have already resolved your problems, then no need to reply.
"Darren King" wrote:

> Hi All,
> I have an issue registering a server using Analysis Manager, whenever I tr
y
> I get a fairly generic error saying:
> 'the server is either not started or too busy'.
> I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
> 2003 Server Enterprise box. This server is running IIS 6.0, Project Serve
r
> 2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
> register this server to allow me to migrate the Analysis Services Reposito
ry
> to a SQL database but so far to no avail.
> Any advice or assistance anyone can offer would be most appreciated.
> Regards,
> Darren King
>
>

An exception occurred while executing a Transact-SQL statement or batch

Hi,

i have a problem received from my client saying that she received an error that say : An exception occurred while executing a Transact-SQL statement or batch. There is no error code given in the error message. There is a additional infomation given: Timeout expired. timeout period elapsed prior to completion of the operation of the server is not responding. So can u advise me on this matter.

Thank You.

Regards,
S.PrathaIf you have a question about mysql you might get more responses if you post in the mysql forum instead of the misc forum.

-MODERATOR|||Hi Pratha. Welcome to The Scripts!

What type of software threw this exception?
What type of SQL server are you trying to connect to?
What programming language is the software written in?

Did you write any of this software yourself?
Do you have the code that is generating the error?

Do you have any information we can use to help you solve this?|||

Quote:

Originally Posted by Atli

Hi Pratha. Welcome to The Scripts!

What type of software threw this exception?
What type of SQL server are you trying to connect to?
What programming language is the software written in?

Did you write any of this software yourself?
Do you have the code that is generating the error?

Do you have any information we can use to help you solve this?

Atli has the patience of a saint!|||... this looks more like a MS SQL problem than a MySQL problem.|||Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

I'm going to go ahead and move this thread to the MS SQL forum, where our resident Experts will be better able to help you out.|||Timeout errors usually happen when something is running on the backend and doesnt return result to meet predefined deadline.
For example you are running a stored procedure that has to return some data to a front end application and setting on your connection says that it would wait for 30 seconds before timeout expired and error will be issued.

So you have to do several things to investigate this issue:
1. Check if application connects to the server with no problem.
2. Debug application and find where timeout happens and which command is sent to the server that is taking longer then expected.
3. Go back to the serve and see how long the same command actually runs on the server side and try optimizing if possible. It should include evaluation of a showplan and determine that you might need to create some indexes or maybe your server didnt have maintenance for a long time and you dont update statistics regularly. Could be a space issue or just some unattended process having exclusive lock on a table and can not release resources without intervention.
4. On application side you can extend timeout by setting it to 0 you will set waiting time to infinite until result will actually be returned back to the front end. Make sure that it is an only option you have left by trying to fix your problem with previous suggestions.

If everything I said here is gibberish to you try to find more experienced programmer to investigate an issue.

Thank you and good luck.

Am completely lost

Hello all let me first start out by saying I suck at SQL. I can do quite a bit with ASP.NET but SQL Server is on area that has haunted me and I have finally decided to bite the bullet and figure this behamouth out.

Well here is my first problem, which is the biggest reason I can't seem to understand SQL Server or dataases in general.

To have a realtional database you set up tables with foriegn keys and primary keys referenceing the id's like product table has a product name and one of the columns is a user_id displaying the id number of the user in the user table. From what I can tell you are supposed to set up the user_id in the products table a foriegn key to the Primary Key in the user table. I may be totally wrong on this though.

Now my biggest question is how do you retrive this information the proper way to get it ready to be displayed in a gridveiw or a datalist?

I have been reading SQL Server 2005 for developers and reading online tutorials and it seems like they say you need to set up a relationship and because of the realtionship you don't need to do a join, but I never hear how to use the relationship at all.

Please someone help I am so totally lost that i feel like i will never understand. I have spent the last week trying to figure this out and I guess I am just googleing this wrong completely or i am incompentent one of the two.

Thank you.

try this

select a.column1, a.column2 ... b.column1, b.column2

from user a inner join product b on a.userID = b.userID

Hope this help.

Alternatives to CURSORs

Hi all

I have often come across discussions on this forum saying that CURSORs are expensive in time (processing power?).

Having used CURSORs to processing a mere 2000+ record (not much at all) which took a fair while to complete, I now realize why you guys are saying CURSORs are expensive.

But is there alternatives to using CURSORs in the situation where I try to process every records returned by a particular query?

Say for example, i want to update columns that comes from different tables for every record that is returned by a SELECT JOIN query. there is no way that i can do that with a single UPDATE statement cause i can't do JOIN with UPDATE query.

All comments welcome

James :)well u can :
update a set aa= b.bb
from table_a a
inner join table_b b on a.key = b.key

since in cursors u use loops try :
loop on numeric key in table

select @.i = Min(int_key) From Tablename
while @.i <= (select @.Max(int_key) From Tablename)
begin
.
.

end|||yes you can join tables in the from clause of an update statement
[BOL] UPDATE (described)

check out example 'C' at the bottom of the help document|||Thank you guys.

Is it standard ANSI to use join in an update query? Although it would make sense that it is. I have tried it before without success for some reason. :( I will try it again.

James :)|||No, JOIN operations in an UPDATE are explicitly forbidden by the ISO, and were never addressed by ANSI. While JOIN operations in an UPDATE can be convenient, they violate most of the rules of relational algebra. Sybase and Microsoft are the only commercially successful engines I can think of that support them.

-PatP|||Really?

So in Oracle, for instance, you can't execute a statement like:

update A
set A.Column = NewValue
from A
inner join B on A.Key = B.Value

?

ANSI or not, that's pretty simple and pretty convenient too.|||Originally posted by Pat Phelan
No, JOIN operations in an UPDATE are explicitly forbidden by the ISO, and were never addressed by ANSI. While JOIN operations in an UPDATE can be convenient, they violate most of the rules of relational algebra. Sybase and Microsoft are the only commercially successful engines I can think of that support them.

-PatP

Nope...even DB2 OS/390 can do it now...it's just extremely painful...

But we did have a very good thread where we discussed how I "crossed the line" and broke the rules...

I gotta look it up...|||Here it is...

Bookmarked it...

http://www.dbforums.com/showthread.php?threadid=989508|||subqueries are useful here, as they provide for the referencing of tables.
normally in a complex update or delete i will create a query that doesnt change the data and after i recieve the correct results, i will use it as a subquery for the update\delete stmt. especially if the sarg is a dynamic value.

update t1
set c2 = x
where col3 in (select col3 from t2
where col4 = x)

however, be carefull with subqueries as they can have some definite disadvantages. specifically correlated subqueries

in addition when you join tables in an update\delete, the sql optimizer has a great deal of flexibility with the join operations where in the subquery the inner and outer queries kind of restrict the optimizers options.|||Originally posted by blindman
Really?

So in Oracle, for instance, you can't execute a statement like:

update A
set A.Column = NewValue
from A
inner join B on A.Key = B.Value

?

ANSI or not, that's pretty simple and pretty convenient too. I rarely think of Oracle, or at least I try not to.

I didn't realize that DB2 supported this form of blaspheme. I'm sure that it is great fun listening to Celko on this topic!

-PatP|||It's just so damn useful...in the (DB2) old days when it didn't, you had to either use a cursor, or genrate the satements and then execute them in a batch...|||As far back as I can remember, DB2 supported sub-queries. Sub-queries are safe to use in an UPDATE as long as they are stochastic and deterministic. I don't know when DB2 added support for JOIN operations within an UPDATE.

-PatP|||I think it was back in V5...

and whoah...

had to look that one up

http://www.hyperdictionary.com/dictionary/stochastic|||Ooops, my bad. I meant non-stochastic. Sorry.

-PatP|||Thought it was kind of like oil and water...