Problems with Poison Message Processing

I am getting the following Error and I can't find it in the Manual.

Failure to send an event notification instance of type 'BROKER_QUEUE_DISABLED' on conversation handle '{5D273374-E84F-DB11-B3BC-0004239AB15C}'. Error Code = '8429'.

I have checked the service name for the notification and it appears to be okay.

Any ideas would be welcomed,

Gary

select * from sys.messages where message_id = 8429

The conversation endpoint is not in a valid state for SEND. The current endpoint state is '%ls'.

This indicates that the dialog is ended prematurely, probably by a dialog error. The ERRORLOG file and the system eventlog will contain an entry indicating the error which ended the notification dialog. The corrective action depends on the said error.

HTH,
~ Remus

|||

Thanks Remus,

I will send the error from the log the next time I recreate it. It has rolled off of the log for now.

Gary

|||

Hi All!

Remus, could you please help me?

I received error message when I processing messages:

"The conversation endpoint is not in a valid state for SEND. The current endpoint state is 'ER'"

You sad " The corrective action depends on the said error."

How can I fixed my problem with endpoint state = 'ER'?

Thank you very much for help!

Sveta

|||

It means that the dialog carrying the notifications was ended with an error. The NT EventLog should contain an entry like this:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17003
Date: 11/9/2006
Time: 11:25:06 AM
User: N/A
Computer: REMUSR64
Description:
Closed event notification conversation endpoint with handle '{387BECFA-2770-DB11-9D68-00123F783601}', due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;s&apos; because it does not exist.</Description></Error>'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 6b 42 00 00 10 00 00 00 kB......
0008: 09 00 00 00 52 00 45 00 ....R.E.
0010: 4d 00 55 00 53 00 52 00 M.U.S.R.
0018: 36 00 34 00 00 00 07 00 6.4.....
0020: 00 00 74 00 65 00 6d 00 ..t.e.m.
0028: 70 00 64 00 62 00 00 00 p.d.b...

The actual error (highlighted) will probably be different in your case, but it will indicate what the problem is.

HTH,
~ Remus

Problems with Poison Message Processing

I am getting the following Error and I can't find it in the Manual.

Failure to send an event notification instance of type 'BROKER_QUEUE_DISABLED' on conversation handle '{5D273374-E84F-DB11-B3BC-0004239AB15C}'. Error Code = '8429'.

I have checked the service name for the notification and it appears to be okay.

Any ideas would be welcomed,

Gary

select * from sys.messages where message_id = 8429

The conversation endpoint is not in a valid state for SEND. The current endpoint state is '%ls'.

This indicates that the dialog is ended prematurely, probably by a dialog error. The ERRORLOG file and the system eventlog will contain an entry indicating the error which ended the notification dialog. The corrective action depends on the said error.

HTH,
~ Remus

|||

Thanks Remus,

I will send the error from the log the next time I recreate it. It has rolled off of the log for now.

Gary

|||

Hi All!

Remus, could you please help me?

I received error message when I processing messages:

"The conversation endpoint is not in a valid state for SEND. The current endpoint state is 'ER'"

You sad " The corrective action depends on the said error."

How can I fixed my problem with endpoint state = 'ER'?

Thank you very much for help!

Sveta

|||

It means that the dialog carrying the notifications was ended with an error. The NT EventLog should contain an entry like this:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17003
Date: 11/9/2006
Time: 11:25:06 AM
User: N/A
Computer: REMUSR64
Description:
Closed event notification conversation endpoint with handle '{387BECFA-2770-DB11-9D68-00123F783601}', due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;s&apos; because it does not exist.</Description></Error>'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 6b 42 00 00 10 00 00 00 kB......
0008: 09 00 00 00 52 00 45 00 ....R.E.
0010: 4d 00 55 00 53 00 52 00 M.U.S.R.
0018: 36 00 34 00 00 00 07 00 6.4.....
0020: 00 00 74 00 65 00 6d 00 ..t.e.m.
0028: 70 00 64 00 62 00 00 00 p.d.b...

The actual error (highlighted) will probably be different in your case, but it will indicate what the problem is.

HTH,
~ Remus

problems when processing the cube

if i download a cube in a local environment to make it some changes. and then process it.. it loses its roles lets say it has this administrator role and inside this in the memberships. i added some users on the network.. when one of this users donwload the cube in his pc to make it some changes.. and the process it.. when he atempts to donwload it again.. the cube just doesn`t appear in the wizard.. the in the server where is storaged. i check the role and it has lost its properties like memberships and options like full control and so on.. why does this happens?

I suspect the role memebership is getting lost at the moment when changes are being done to the cube.

In order to make changes you open you project in BI Dev Studio. Project also contains the roles defnitions, but they are empty. So when you deploy your changes back to the server, the Role's membership is getting wiped out.

To overcome this problem you should use Deployment Wizard to make changes to your cubes. And specify in there you want Role's membership to be preserved.

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

|||DOES THIS WIZARD RUN ON THE TARGET SERVER OR CAN I RUN IT FROM MY COMPUTER DIRECTLY?|||

You run the Deployment Wizard on the local machine an point it to the project files.

It will ask you for the machine name you going to deploy your project into . That is your target server.

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

|||

thanks for your help.. it worked without any problems!!!!

regards...

Problems when processing cube partitions

Hello all

I am experiencing problems with one of my cubes. We have a historical cube which is partitiones in quarters from 2004-2006, and then monthly for 2007. I have processed the dimensions in full, and now try to process only the newest cube partition, the one for june 2007, and after thats done the cube reults are quite bad, my measures are way way way off... What am I missing in here?

After processing a dimension in full mode all fact data in the cube is deleted! So now, you only have the data for June 2007.

Hope this clarifies you question.

|||Thanks for your reply, this answers my question... I wonder what to do then, as the process update takes almost double time as the process full |||

Are you actually updating attributes of existing members or only adding new members?

If you are only adding new ones you could look into doing a processAdd.

|||Unfortunately every friday the dimension is "cleaned" which means removing some data from it