Analysis Services

How can you process multiple Analysis Services databases against the same SQL Server database without receiving table locks and the processing fails.How about one by one database using some program? There is a command line tool available to execute XML/A requests.|||

Dear,

We can create a DTS Package that will process all the Analysis Databases one by one.

HTH

from

sufian

Analysis Server Hangs

Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.Hi enigma,
Do you meant to say by seeing in'Task Manager/ Application'. showing 'Not Responding' ? You try watch using performance counter/AS:Proc:,AS:Agg.Proc objects, after some time, you will get some values related to that. In my case also, I was getting 'this hanging sort of things' but actually it is not.
HTH
====

Originally posted by Enigma
Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.|||Thanks Man,

I was doing exactly the thing you said ... well .. i processed the cube using a DTS yesterday and that worked perfectly fine .

Thanks for all your help

Analysis manager cube processing error

I am trying to process a cube and during processing I get a message that " Data source provider error :[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified..." I set up my data connections and everything else as it appeared in the tutorial. I am running XP Professional and MS Server 2000.To validate your connection create a file on your desktop with UDL extension. Double-click on it and fill in the blanks. Once done, - rename the file to .TXT and open it in notepad. Modify as needed and use it.|||I did all this and still I don't get the cubes to process. Do I need to rename the file to UDL after everything? When I process now I get the message "Data Source Provider Error:[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed;IM006..." What should the provider name be in the UDL file? Mine says MSDASQL.1|||As an example, here is what I have in notepad after I create a connection:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="driver={sql server};server=l6064909;database=master;trusted_co nnection=true"|||I got the cube to process, now when I click on browse data I get a message that states "Unable to browse the cube 'Sales'. Unspecified error." Is this because of the service pack?

Analysis 2005 Cube Processing in 64-Bit Environment

I have problems with processing cubes on AS2005. I get this error message while processing:

Memory error: Allocation failure: Not enough storage is available to process this command. Error in the OLAP storage engine.

This machine has 6GB of memory and once it hits 3.5GB the processing stops. AWE is turned on.

I would appreciate, if anyone can help on this.

Thanks,

Gopal

Analysis Services is not AWE aware. So it can only use 2GB on a 32bit box (3GB if you have /3GB switch in boot.ini). Looks like the processing operation is running out of memory.

What are the number and sizes of dimension and partition tables? Do you have aggregations? Look at the processing log (in the process dialog) and find out what is the operation that causes out of memory - dimension processing, partition processing, building aggregations, etc.

This could also happen due to excessive parallelism. Try processing the dimensions and partitions individually.

|||

Thanks for your reply.

I managed to process the partitions and dimensions individually. That worked.

Gopal

|||

Hi.

Just a short question:

Is it really true that SSAS can use only 2GB RAM on a 32bit system? The technical reference for SQL Server 2005 Standard and Enterprise states that SQL Server can use the amount of RAM supported by the operating system which is 4GB for a Server 2003 Standard edition and 32GB for a Server 2003 Enterprise edition, both on 32bit systems. Does this apply only to the SQL Server Database Engine then and not the Analysis Services Server?

Regards

Kjetil

T.K. Anand wrote:

Analysis Services is not AWE aware. So it can only use 2GB on a 32bit box (3GB if you have /3GB switch in boot.ini). Looks like the processing operation is running out of memory.

What are the number and sizes of dimension and partition tables? Do you have aggregations? Look at the processing log (in the process dialog) and find out what is the operation that causes out of memory - dimension processing, partition processing, building aggregations, etc.

This could also happen due to excessive parallelism. Try processing the dimensions and partitions individually.

|||

In the 64-bit versions of Analysis Services...has this memory use limit been removed?

...cordell...

|||Yes - 64bit version doesn't have these limitations.

An unexpected error occurred in Report Processing

Hi,

I am having MSRS 2000 Reports which is using subscription feature to email PDF format reports to user . I am able to get all the reports e-mailed as expected only this report is giving an errror in the status as "Failure sending mail: An unexpected error occurred in Report Processing". I can pull this report properly and also export it in PDF manually. The Report is a 15 page Report with few images. If I try to email only the link of the Report it works fine. Was wondering if anybody would have a clue about the same .

The Log files read as

Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred in Report Processing. > System.IO.DirectoryNotFoundException:
Could not find a part of the path "F:\".

I dont know why it is going in F drive and failing.

cheers,

siaj

The more detailed log is :

ReportingServicesService!processing!1790!04/25/2006-14:15:10:: e ERROR:
Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred in Report Processing. > System.IO.DirectoryNotFoundException:
Could not find a part of the path "F:\".
at System.IO.__Error.WinIOError(Int32 errorCode, String str)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path)
at System.IO.Directory.CreateDirectory(String path)
at Microsoft.ReportingServices.Library.PartitionManager.CreateFile(String folder, String filename)
at Microsoft.ReportingServices.Library.FileChunkWriteStream.OpenFileStream()
at Microsoft.ReportingServices.Library.FileChunkWriteStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String mimeType, ChunkFlags flags)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateWriteStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String mimeType, Int32 bufferSize)
at Microsoft.ReportingServices.Library.ReportSnapshot.CreateReportChunk(String name, ReportChunkTypes type, String mimeType)
at Microsoft.ReportingServices.ReportProcessing.a.a()
at Microsoft.ReportingServices.ReportProcessing.a.c()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4, DateTime A_5, CreateReportChunk A_6, ab& A_7)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3, CreateReportChunk A_4, Boolean& A_5)

It sounds like you have the feature enabled where we store temporary snapshots in the filesystem. Check this article:

http://msdn2.microsoft.com/en-us/library/ms157439(SQL.90).aspx

Make sure that the FileShareStorageLocation element is set to a path which actually exists. My guess is that it is not.

An error occurred while receiving data: ''64(error not found)''

We are using Service Broker to synchronise two databases using async triggers (using a middle server to preform data mapping processing). We are re-using dialogs as we want to ensure order when sending messages which contain the data to be synced. A dialog is created between each intiator and target service (there are 3 of each) which is kept open indefinately (we are only ending conversation upon receiving an end conversation message or error message).

We seem to get it working for a period then after about 1 hour it seems to stop sending and we see the following error in SQL Profiler:

An error occurred while receiving data: '64(error not found)'

Any ideas what could be causing this? We do not see any errors or end conversations. It seems to happen at irregular points.

Error 64 is usually a red herring. It simply indicates that connections are being closed due to inactivity (no traffic for 90 seconds).|||

We find however that when we next try to send across to the other server the message does not get delivered, instead we only see this error.

As a last resort we have had to send one message on one dialog, closing the dialog after it has been sent, and we have no issues now. However as the messages are being sent over seperate dialog SB cannot guarantee that it will arrive in the same order as it happened in the original database.

Below is the activation SP which resides on the middle server where I think the problem lies, although all three servers contain activation SPs that are fairly similar:

Create Procedure [ctk].[ActivateMartiniSendQueue]
AS

begin
set nocount on

declare
@.ConversationHandle uniqueidentifier,
@.DialogHandle uniqueidentifier,
@.MessageType varchar(128),
@.MessageBody xml,
@.QueuingOrder bigint,
@.Counter int,
@.Error int

declare @.tableMessage table
(
queuing_order bigint,
conversation_handle uniqueidentifier,
message_type_name sysname,
message_body xml
)

declare cursorMessage cursor forward_only read_only
for select
queuing_order,
conversation_handle,
message_type_name,
message_body
from @.tableMessage
order by queuing_order asc

begin try
while (1 = 1)
begin
begin transaction

waitfor
(
receive
queuing_order,
conversation_handle,
convert(varchar(128),message_type_name),
convert(xml,message_body)
from MartiniSendQueue
into @.tableMessage
), timeout 2000

if @.@.rowcount = 0 begin
if @.@.trancount > 0 rollback transaction
break
end

open cursorMessage

while (1 = 1)
begin
fetch next from cursorMessage into
@.QueuingOrder,
@.ConversationHandle,
@.MessageType,
@.MessageBody

if @.@.fetch_status <> 0 begin
break
end

if @.MessageType = 'Martini/Customer/Create'

Begin --1

Set @.counter = 0
while (1 = 1)
begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null

begin --3
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end;--3e

set @.MessageType = 'Martini/Customer/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin --4
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
End --4e

End conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

else if @.MessageType = 'Martini/Address/Create'

Begin --1
Set @.counter = 0
while (1 = 1)

begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null
begin --3
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end; --3e

set @.MessageType = 'Martini/Address/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin --4
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end --4e

end conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

else if @.MessageType = 'Martini/Address/Update'

Begin

Set @.counter = 0
while (1 = 1)

begin

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'
if @.DialogHandle is null

begin
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off

end;

set @.MessageType = 'Martini/Address/Update';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end

end conversation @.DialogHandle
set @.DialogHandle = null

End

End

else if @.MessageType = 'Martini/Payment/Create'

Begin --1

Set @.counter = 0
while (1 = 1)

begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null
begin
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end;

set @.MessageType = 'Martini/Payment/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end

end conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

if @.MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' begin
end conversation @.DialogHandle
end

-- Error
if @.MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/Error' begin
end conversation @.DialogHandle
end
end

close cursorMessage
delete from @.tableMessage

if @.@.trancount > 0 commit transaction
end

deallocate cursorMessage
end try
begin catch
if @.@.trancount > 0 rollback transaction
end catch
end
go

Any help would be much appreciated.

Regards

David

An error occurred while receiving data: ''64(error not found)''

We are using Service Broker to synchronise two databases using async triggers (using a middle server to preform data mapping processing). We are re-using dialogs as we want to ensure order when sending messages which contain the data to be synced. A dialog is created between each intiator and target service (there are 3 of each) which is kept open indefinately (we are only ending conversation upon receiving an end conversation message or error message).

We seem to get it working for a period then after about 1 hour it seems to stop sending and we see the following error in SQL Profiler:

An error occurred while receiving data: '64(error not found)'

Any ideas what could be causing this? We do not see any errors or end conversations. It seems to happen at irregular points.

Error 64 is usually a red herring. It simply indicates that connections are being closed due to inactivity (no traffic for 90 seconds).|||

We find however that when we next try to send across to the other server the message does not get delivered, instead we only see this error.

As a last resort we have had to send one message on one dialog, closing the dialog after it has been sent, and we have no issues now. However as the messages are being sent over seperate dialog SB cannot guarantee that it will arrive in the same order as it happened in the original database.

Below is the activation SP which resides on the middle server where I think the problem lies, although all three servers contain activation SPs that are fairly similar:

Create Procedure [ctk].[ActivateMartiniSendQueue]
AS

begin
set nocount on

declare
@.ConversationHandle uniqueidentifier,
@.DialogHandle uniqueidentifier,
@.MessageType varchar(128),
@.MessageBody xml,
@.QueuingOrder bigint,
@.Counter int,
@.Error int

declare @.tableMessage table
(
queuing_order bigint,
conversation_handle uniqueidentifier,
message_type_name sysname,
message_body xml
)

declare cursorMessage cursor forward_only read_only
for select
queuing_order,
conversation_handle,
message_type_name,
message_body
from @.tableMessage
order by queuing_order asc

begin try
while (1 = 1)
begin
begin transaction

waitfor
(
receive
queuing_order,
conversation_handle,
convert(varchar(128),message_type_name),
convert(xml,message_body)
from MartiniSendQueue
into @.tableMessage
), timeout 2000

if @.@.rowcount = 0 begin
if @.@.trancount > 0 rollback transaction
break
end

open cursorMessage

while (1 = 1)
begin
fetch next from cursorMessage into
@.QueuingOrder,
@.ConversationHandle,
@.MessageType,
@.MessageBody

if @.@.fetch_status <> 0 begin
break
end

if @.MessageType = 'Martini/Customer/Create'

Begin --1

Set @.counter = 0
while (1 = 1)
begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null

begin --3
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end;--3e

set @.MessageType = 'Martini/Customer/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin --4
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
End --4e

End conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

else if @.MessageType = 'Martini/Address/Create'

Begin --1
Set @.counter = 0
while (1 = 1)

begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null
begin --3
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end; --3e

set @.MessageType = 'Martini/Address/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin --4
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end --4e

end conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

else if @.MessageType = 'Martini/Address/Update'

Begin

Set @.counter = 0
while (1 = 1)

begin

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'
if @.DialogHandle is null

begin
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off

end;

set @.MessageType = 'Martini/Address/Update';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end

end conversation @.DialogHandle
set @.DialogHandle = null

End

End

else if @.MessageType = 'Martini/Payment/Create'

Begin --1

Set @.counter = 0
while (1 = 1)

begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null
begin
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end;

set @.MessageType = 'Martini/Payment/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end

end conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

if @.MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' begin
end conversation @.DialogHandle
end

-- Error
if @.MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/Error' begin
end conversation @.DialogHandle
end
end

close cursorMessage
delete from @.tableMessage

if @.@.trancount > 0 commit transaction
end

deallocate cursorMessage
end try
begin catch
if @.@.trancount > 0 rollback transaction
end catch
end
go

Any help would be much appreciated.

Regards

David

An error occurred while receiving data: ''64(error not found)''

We are using Service Broker to synchronise two databases using async triggers (using a middle server to preform data mapping processing). We are re-using dialogs as we want to ensure order when sending messages which contain the data to be synced. A dialog is created between each intiator and target service (there are 3 of each) which is kept open indefinately (we are only ending conversation upon receiving an end conversation message or error message).

We seem to get it working for a period then after about 1 hour it seems to stop sending and we see the following error in SQL Profiler:

An error occurred while receiving data: '64(error not found)'

Any ideas what could be causing this? We do not see any errors or end conversations. It seems to happen at irregular points.

Error 64 is usually a red herring. It simply indicates that connections are being closed due to inactivity (no traffic for 90 seconds).|||

We find however that when we next try to send across to the other server the message does not get delivered, instead we only see this error.

As a last resort we have had to send one message on one dialog, closing the dialog after it has been sent, and we have no issues now. However as the messages are being sent over seperate dialog SB cannot guarantee that it will arrive in the same order as it happened in the original database.

Below is the activation SP which resides on the middle server where I think the problem lies, although all three servers contain activation SPs that are fairly similar:

Create Procedure [ctk].[ActivateMartiniSendQueue]
AS

begin
set nocount on

declare
@.ConversationHandle uniqueidentifier,
@.DialogHandle uniqueidentifier,
@.MessageType varchar(128),
@.MessageBody xml,
@.QueuingOrder bigint,
@.Counter int,
@.Error int

declare @.tableMessage table
(
queuing_order bigint,
conversation_handle uniqueidentifier,
message_type_name sysname,
message_body xml
)

declare cursorMessage cursor forward_only read_only
for select
queuing_order,
conversation_handle,
message_type_name,
message_body
from @.tableMessage
order by queuing_order asc

begin try
while (1 = 1)
begin
begin transaction

waitfor
(
receive
queuing_order,
conversation_handle,
convert(varchar(128),message_type_name),
convert(xml,message_body)
from MartiniSendQueue
into @.tableMessage
), timeout 2000

if @.@.rowcount = 0 begin
if @.@.trancount > 0 rollback transaction
break
end

open cursorMessage

while (1 = 1)
begin
fetch next from cursorMessage into
@.QueuingOrder,
@.ConversationHandle,
@.MessageType,
@.MessageBody

if @.@.fetch_status <> 0 begin
break
end

if @.MessageType = 'Martini/Customer/Create'

Begin --1

Set @.counter = 0
while (1 = 1)
begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null

begin --3
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end;--3e

set @.MessageType = 'Martini/Customer/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin --4
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
End --4e

End conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

else if @.MessageType = 'Martini/Address/Create'

Begin --1
Set @.counter = 0
while (1 = 1)

begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null
begin --3
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end; --3e

set @.MessageType = 'Martini/Address/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin --4
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end --4e

end conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

else if @.MessageType = 'Martini/Address/Update'

Begin

Set @.counter = 0
while (1 = 1)

begin

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'
if @.DialogHandle is null

begin
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off

end;

set @.MessageType = 'Martini/Address/Update';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end

end conversation @.DialogHandle
set @.DialogHandle = null

End

End

else if @.MessageType = 'Martini/Payment/Create'

Begin --1

Set @.counter = 0
while (1 = 1)

begin --2

select @.DialogHandle = [conversation_handle] from
sys.conversation_endpoints as ce
left join sys.services as s on s.service_id = ce.service_id
left join sys.service_contracts as sc on sc.service_contract_id = ce.service_contract_id
where is_initiator = 1 and s.name = 'MartiniSenderService' and far_service = 'MartiniReceptionService'

if @.DialogHandle is null
begin
begin dialog conversation @.DialogHandle
from service [MartiniSenderService]
to service 'MartiniReceptionService'
on contract MartiniContract
with encryption = off
end;

set @.MessageType = 'Martini/Payment/Create';

send on conversation @.DialogHandle
message type @.MessageType (@.MessageBody)

set @.error = @.@.error
if @.error = 0 break
set @.counter = @.counter + 1

if @.counter > 10
begin
raiserror ('Failed to SEND on a conversation for more than 10 times. Error %i.', 16, 1, @.error) with log
break
end

end conversation @.DialogHandle
set @.DialogHandle = null

End --2e

End --1e

if @.MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' begin
end conversation @.DialogHandle
end

-- Error
if @.MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/Error' begin
end conversation @.DialogHandle
end
end

close cursorMessage
delete from @.tableMessage

if @.@.trancount > 0 commit transaction
end

deallocate cursorMessage
end try
begin catch
if @.@.trancount > 0 rollback transaction
end catch
end
go

Any help would be much appreciated.

Regards

David

An error occurred while processing 'BackupMetadata' metadata for database

I have transferred a database from SQL 2000 to SQL 2005 and now I am getting an error when I try to run backup. I get there error "An error occurred while processing 'BackupMetadata' metedata for datase ID..." Does anyone have any suggestions on how to resolve this error?

whats there in the error log ? ? ?......also did you try to backup using T-SQL .......is the db accessible ? ? ? after you restored from SQL 2000......try running

dbcc checkdb........

|||

Below is the error log:

Failed-1073548784) Executing the query "BACKUP DATABASE [SURVIAC] TO DISK = N'C:\\DatabaseBackups\\DailyFull\\SURVIAC\\SURVIAC_backup_200707091051.bak' WITH NOFORMAT, NOINIT, NAME = N'SURVIAC_backup_20070709105151', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "An error occurred while processing 'BackupMetadata' metadata for database id 13 file id 65537.
Inconsistent metadata has been encountered. The only possible backup operation is a tail-log backup using the WITH CONTINUE_AFTER_ERROR or NO_TRUNCATE option.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

The database is accessible and is being used. I ran checkdb and did not come up with anything. I haven't used T-SQL. I have only used enterprise manager and my maintenance plans.

|||

seems your db is corrupted i guess.........the error log states that metadata is inconsistent ........also it allows you to take transaction log backup by using the option WITH CONTINUE_AFTER_ERROR ........you have the following options,

1.Try to backup the db with T-SQL or

2.Take a tran log backup with the above option

3.If you have any recent full backup just restore it somewhere and test if you can take backup on that restored db....coz i doubt your db is corrupted....

|||

It looks like you could be hitting a problem where you have damaged pages in the backup. The default behavior under 2005 is for the backup to fail if the checksum can't be verified.

To see if it is the maintenance plan or not, first try to backup the database using your own T-SQL and not the maintenance plan.

Also, run your DBCC CHECKDB using your own T-SQL, not a maintenance plan.

How long ago did you move this from 2000 to 2005? Did you run a checkdb after that migration? How did upgrade the database? Have you done any successful backups since upgrading the database to 2005?

-Sue

An error occurred during local report processing.

Occasionally when we are running reports in our web application we are
getting this error. It seems random and occurs even if a report has
just been run with the same criteria. Sometimes the error occurs a
couple of times in a row and then it will run after that fine.
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
Object reference not set to an instance of an object.On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> Occasionally when we are running reports in our web application we are
> getting this error. It seems random and occurs even if a report has
> just been run with the same criteria. Sometimes the error occurs a
> couple of times in a row and then it will run after that fine.
> An error occurred during local report processing.
> An unexpected error occurred in Report Processing.
> Object reference not set to an instance of an object.
Sounds like on occasion there is an issue with the cached data for the
report. If you are caching the report data, I would suggest removing
the cache data setting. Also, you might want to delete the rdl.data
file in the interim. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > Occasionally when we are running reports in our web application we are
> > getting this error. It seems random and occurs even if a report has
> > just been run with the same criteria. Sometimes the error occurs a
> > couple of times in a row and then it will run after that fine.
> > An error occurred during local report processing.
> > An unexpected error occurred in Report Processing.
> > Object reference not set to an instance of an object.
> Sounds like on occasion there is an issue with the cached data for the
> report. If you are caching the report data, I would suggest removing
> the cache data setting. Also, you might want to delete the rdl.data
> file in the interim. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique. I was starting to suspect it was something to do with
caching. Do you know how I can remove the cache data setting? I did a
search for rdl.data files on the server and it couldn't find any.|||I've managed to fix it by stopping stopping the W3SVC (WWW Publisher
Service) and deleting all the files in
C:/Windows/Microsoft.NET/Framework/v2.0.50527/Temporary ASP.NET Files/|||On Dec 6, 7:56 pm, lachlan.h...@.gmail.com wrote:
> On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > > Occasionally when we are running reports in our web application we are
> > > getting this error. It seems random and occurs even if a report has
> > > just been run with the same criteria. Sometimes the error occurs a
> > > couple of times in a row and then it will run after that fine.
> > > An error occurred during local report processing.
> > > An unexpected error occurred in Report Processing.
> > > Object reference not set to an instance of an object.
> > Sounds like on occasion there is an issue with the cached data for the
> > report. If you are caching the report data, I would suggest removing
> > the cache data setting. Also, you might want to delete the rdl.data
> > file in the interim. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique. I was starting to suspect it was something to do with
> caching. Do you know how I can remove the cache data setting? I did a
> search for rdl.data files on the server and it couldn't find any.
You're welcome. Thanks for posting your resolution; that might help
someone in the future with a similar situation.
Regards,
Enrique Martinez
Sr. Software Consultant

An error has occurred during report processing. (rsProcessingAborted) The report server installa

I'v reinstalled RS, then I configuret it. But when I want to open a report raise this error
An error has occurred during report processing. (rsProcessingAborted)
The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError)
Any Ideas
Thanks in advanceIt happens because another instace of RS was running.
See it at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsReportServerNotActivated.asp
I try to do this to solve this stuff:
rsactivate -c "path to the report server config file"
rsactivate -r
With no luck.
Any Ideas?

|||The error was cause I lose the encription key. Then I deleted with
rskeymgmt -d
After that I have to reconfigure all the connection.|||

hi, this probleb caused becaus mainly of the initializtion of reporting services you need to initialize the reporting service in the sql server for that u need to do

start-->all programs>sql server2005-->reporting services-->configure>initialize -->check the box and press initialize button

An error has occurred during report processing. (rsProcessingAborted) The report server installa

I'v reinstalled RS, then I configuret it. But when I want to open a report raise this error

An error has occurred during report processing. (rsProcessingAborted)

The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError)

Any Ideas

Thanks in advanceIt happens because another instace of RS was running.
See it at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsReportServerNotActivated.asp
I try to do this to solve this stuff:

rsactivate -c "path to the report server config file"

rsactivate -r

With no luck.

Any Ideas?|||The error was cause I lose the encription key. Then I deleted with

rskeymgmt -d

After that I have to reconfigure all the connection.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'database03'. (rsErrorOpeningConnection) Get Online Help Cannot open database requested in login 'database'. Login fails. Login failed for user 'sam'.

---

Hi Raj,

What is your question? The error is fairly clear. The query that returns data in your report cannot access the data source defined in your report for User 'sam' and 'database03'.

An error has occurred during report processing.

Hi all,

When i try to access the report Manager through the URL I get this error:

An error has occurred during report processing.

Cannot create a connection to data source 'rs2005sbsDW'.

The ConnectionString property has not been initialized.

Colud someone help me out.

Could some one out there help me out?

Ronald

An error has occurred during report processing.

While creating a new report in the report designer I can pull all the information from my cube,
however later after it is created i get this message:

An error has occurred during report processing.
Query execution failed for data set 'MedContv15S'.
Unable to recognize the requested property ID 'ReturnCellProperties'.

anybody a clue ?

I meanwhile tried to set "ConnectTo" to 8.0, however after that i get this error:

An error occured during local report processing
An error has occured during report processing
Cannot create a connection to data source 'MeD'.
The LCID or Compare String flags have already been set by an existing connection. They cannot be changed

Did you manage to resolve this. I have the same problem?

An error has occurred during report processing.

While creating a new report in the report designer I can pull all the information from my cube,
however later after it is created i get this message:

An error has occurred during report processing.
Query execution failed for data set 'MedContv15S'.
Unable to recognize the requested property ID 'ReturnCellProperties'.

anybody a clue ?

I meanwhile tried to set "ConnectTo" to 8.0, however after that i get this error:

An error occured during local report processing
An error has occured during report processing
Cannot create a connection to data source 'MeD'.
The LCID or Compare String flags have already been set by an existing connection. They cannot be changed

Did you manage to resolve this. I have the same problem?

An error has occurred during report processing.

Hi all,

When i try to access the report Manager through the URL I get this error:

An error has occurred during report processing.

Cannot create a connection to data source 'rs2005sbsDW'.

The ConnectionString property has not been initialized.

Colud someone help me out.

Could some one out there help me out?

Ronald

An error has occurred during report processing

Randomly had this error..... An error has occurred during report
processing
during a report demo. People were not pleased.
Anyone ever find out what generates this error. Is it a
high-level/generic error that is thrown?
Are there any hidden log files that perhaps specifices the cause of
this error?
Thanks,
PeterThe specific error was...
Invalid attempt to read when no data is present.
Problem is...is that there is always data returned for the stored
procedure that is being called.

An error has occurred during report processing

Hi,
I've been working through Teo Lachev's 'Custom DataSet Data Extension for
Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
I've built and deployed the DataSet Extension as specifed in the
documentation. I've also adjusted the security config files to insert the new
code group.
I've successfully created the Data Source and the DataSet.
However, I'm getting the following problems from within the report designer.
1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
@.DataSource parameter *nothing* is added to the fields toolbar.
2) When I click the preview tab I get the following error dialog:
"An error has occurred during report processing. Query execution failed for
data set 'DataSet1. DataSource parameter not specified."
I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
Any ideas or pointer would be much appreciated. Thanks>
> I've been working through Teo Lachev's 'Custom DataSet Data Extension for
> Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
> I've built and deployed the DataSet Extension as specifed in the
> documentation. I've also adjusted the security config files to insert the new
> code group.
> I've successfully created the Data Source and the DataSet.
> However, I'm getting the following problems from within the report designer.
> 1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
> @.DataSource parameter *nothing* is added to the fields toolbar.
> 2) When I click the preview tab I get the following error dialog:
> "An error has occurred during report processing. Query execution failed for
> data set 'DataSet1. DataSource parameter not specified."
> I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
> Any ideas or pointer would be much appreciated. Thanks
>
After checking some previous posts I can confirm that I'm running the latest
SP1 on my box.
I've tried connecting to a couple of different .xsd files but am still
getting the same error:
"An error has occurred during report processing. Query execution failed for
data set 'DataSet1. DataSource parameter not specified."
Does anyone have further pointers I could check?
Thanks
Hans|||Hans Gruber" <Hans Gruber@.discussions.microsoft.com> wrote in message
news:20D93706-74F5-4BF1-9680-7FC6077EFEBD@.microsoft.com...
> Hi,
>
> I've been working through Teo Lachev's 'Custom DataSet Data Extension for
> Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
> I've built and deployed the DataSet Extension as specifed in the
> documentation. I've also adjusted the security config files to insert the
new
> code group.
> I've successfully created the Data Source and the DataSet.
> However, I'm getting the following problems from within the report
designer.
> 1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
> @.DataSource parameter *nothing* is added to the fields toolbar.
> 2) When I click the preview tab I get the following error dialog:
> "An error has occurred during report processing. Query execution failed
for
> data set 'DataSet1. DataSource parameter not specified."
> I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
> Any ideas or pointer would be much appreciated. Thanks
>
I've been getting the exact same error.
Is there anyone from Microsoft who can help with this?

AMO:How we can handle the transactions in AMO

HI All,

I am working with AMO and .Net i have few queries,

1) how to handle the transactions in AMO

2)if one user is processing the cube then how to prevent other user to access it.

Please let me know.

Your suggestions are valueable to me.

Thanks in advance.

vish.

AMO is inherently transactional. If an object is being processed changes that other users submit will not be committed until after the transaction has completed.

If you need to do a series of operations, like changing a cubes structure and then processing it, but you want either both or neither of these operations to suceed, then you can use explicit transactions. The server object has beginTransaction, commitTransaction and rollbackTransaction methods.