AS stops working, Eventid 22, category 256

Hi!

During the last week my AS2005 server has behaved strangely. It works for two-three days and then it stops and cant handle any more queries. However i can list the catalog and cubes in ProClarity but when i try to connect to a cube it does not work. The same when i go to Management Studio. If i restart the service it works again, probably for another 2-3 days.

Also AS2005 send a lot of error events to the eventlog. All like this(i think one for every query that fails but i am not sure). Event id looks like this:

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (256)
Event ID: 22
Date: 2006-08-23
Time: 13:09:47
User: N/A
Computer: XXXXX
Description:
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured.

It is a x64 box with 4GB ram and Windows Server 2003 R2. I have SP1 installed and its only AS 2005 running on it.

Any clue to what the reason could be? Could it be something that is fixed in the cumalitve hotfix package?

Description for the error code 22 is "An unexpected exception occured." doesnt give you much.

There is not much I can suggest you here. Try contacting Microsoft customer support services and report your problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Article Defaults > can't change

Hello,
We're running transactional replication with no trouble...except we can't
seem to change the article defaults. We are running SQL Server 2000, SP3,
Standard edition.
We don't want data deleted on the subscribers when data is deleted on the
publisher. I follow directions in chapter 4 of Hilary Cotter's book...type
the string 'NONE' in the 'Replace DELETE...' box.
I dropped the subscription before doing this. After saving Default Articles
Property, I exit it, go back in, and the 'NONE' string is gone.
I do this with table articles and indexed view articles...same results. I
try to change a property on the 'Snapshot' tab, same thing. The change
doesn't stick.
Any ideas?
Thanks...
Mojo Jojo
If the None is gone it means that nothing will be replicated. This is an
inconsistency in the GUI/Wizard.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mojo" <Mojo@.discussions.microsoft.com> wrote in message
news:F2F8C8CE-AA36-4957-BBA0-0B29F5CE6CEB@.microsoft.com...
> Hello,
> We're running transactional replication with no trouble...except we can't
> seem to change the article defaults. We are running SQL Server 2000, SP3,
> Standard edition.
> We don't want data deleted on the subscribers when data is deleted on the
> publisher. I follow directions in chapter 4 of Hilary Cotter's book...type
> the string 'NONE' in the 'Replace DELETE...' box.
> I dropped the subscription before doing this. After saving Default
Articles
> Property, I exit it, go back in, and the 'NONE' string is gone.
> I do this with table articles and indexed view articles...same results. I
> try to change a property on the 'Snapshot' tab, same thing. The change
> doesn't stick.
> Any ideas?
> Thanks...
> --
> Mojo Jojo
|||It doesn't seem to matter what I do in the GUI/Wizard...no changes I attempt
to make in article defaults are saved. The behavior of the database doesn't
change.
Mojo Jojo
"Hilary Cotter" wrote:

> If the None is gone it means that nothing will be replicated. This is an
> inconsistency in the GUI/Wizard.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mojo" <Mojo@.discussions.microsoft.com> wrote in message
> news:F2F8C8CE-AA36-4957-BBA0-0B29F5CE6CEB@.microsoft.com...
> Articles
>
>
|||This is the default behavior. Once you have made this change you can't go
back, unless you use sp_changearticle.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mojo" <Mojo@.discussions.microsoft.com> wrote in message
news:73D45C24-6410-41E0-80FD-6345DE88DA6F@.microsoft.com...
> It doesn't seem to matter what I do in the GUI/Wizard...no changes I
attempt
> to make in article defaults are saved. The behavior of the database
doesn't[vbcol=seagreen]
> change.
> --
> Mojo Jojo
>
> "Hilary Cotter" wrote:
can't[vbcol=seagreen]
SP3,[vbcol=seagreen]
the[vbcol=seagreen]
book...type[vbcol=seagreen]
results. I[vbcol=seagreen]

Array data type in SQL Server 2005

Hi,

I was migrating from Oracle to SQL Server 2005 using SSMA (SQL Server Migration Assistant) but i`ve found an issue, i can′t find how to fix it. In my stored procedure in PL/SQL exists this lines:

TYPE T_ARRAY_COL IS VARRAY (1000 ) OF VARCHAR2 (50);
A_COLUMNS T_ARRAY_COL := T_ARRAY_COL();

Somebody know how can i simulate this data type ARRAY. I was reading http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/ but some things are not clear for me.... please help me, give me one hand.

Thank you

David

There is no array data type in SQL Server. You can simulate one using the built-in data types and a table (table variable or temporary table or permanent table).

declare @.t_array_col table( i int not null identity primary key, v varchar(50) not null )

insert into @.t_array_col values('a')

insert into @.t_array_col values('b')

....

select v from @.t_array_col where i = 1

select v from @.t_array_col where i = 2

...

Alternatively, you can just have fixed-length strings that represent the entire array and split them using the built-in functions.

declare @.array_str varchar(max)

set @.array_str = replicate(replicate('x', 2), 100) -- array of size 100, value is of fixed length - 2 bytes

select substring(@.array_str, (@.n * 2) + 1, 2) -- n varies from 0 through 99

set @.array_str = stuff(@.array_str, (@.n * 2) + 1, 2, replicate('z', 2)) -- initialize nth element

You can use varbinary(max) to store numeric values although it is tricky to convert from binary to one of the numeric data types & forth.

Also, there are more efficient ways to do this in SQL than trying to simulate arrays. You will get better performance by using set-based logic.

Arithmetic overflow error for data type smallint, value = 46080

Hello friends, in this moments I have a problem with my Ms Sql server 2000,
at the enterprise manager I can't see the databases, a message error
"Arithmetic overflow error for data type smallint, value = 46080" appears,
but the server is seems to be still working, what it is?
Regards,
Jess R.
Hi
You may want to run SQL profiler to see what is being run by Enterprise
manager.
It could be similar (but not necessarily the same thing as!) to
http://support.microsoft.com/default...b;en-us;234028
Also check the version of SQL Server http://www.aspfaq.com/show.asp?id=2160.
John
"Jesus Brito" wrote:

> Hello friends, in this moments I have a problem with my Ms Sql server 2000,
> at the enterprise manager I can't see the databases, a message error
> "Arithmetic overflow error for data type smallint, value = 46080" appears,
> but the server is seems to be still working, what it is?
> Regards,
> Jesús R.
>
>

ARGH! Cant pass smalldatetime to stored procedure in DEBUGGER!

I know this is probably user error, but here's the scoop:

I have a stored procedure...

CREATE PROCEDURE [dbo].[sp_Build_CurrentPortfolio_By_Date]
@.NewDate smalldatetime

and when I try to run it in debug in the SQL Query Analyzer, I sent in the parameter via the debug interface as '2004/02/02', and as GETDATE(), and a number of other formats, but cannot even get into the procedure once debugger starts up!

I get the following error once I hit "execute" after putting in the above data in the parameter text box...

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

HELP PLEASE!!! (I'm about to punch my new monitor!!!)Remove apostrophe and pass it as 2004-02-02 00:00:00.000|||I LOVE YOU, Man!!!

why, if'n I wasn't already married... ;)

That worked...thanks so much!

I'll hafta file that one on my scorch list!!!

Thanks again!
Paul