LVS error

[agustin_marcoscividanes]

Hello

We installed the LVS 1.0 in our clients servers. We have one big problem with only one.

We started the LVS service and just starting we can find this message error in the system log (Application):

DataManagerService.ReceiveEventInfo: String or binary data would be truncated.

The statement has been terminated.

This message appears too many times and the result is that msdb database log file grows so fast, and the server has no free space.

Is this issue solved in LVS 2.0?

If it is not, is there any solution? Does anybody have this issue?

TIA

Agustín Marcos Cividanes

[bernhard_stbner2]

Hello Agustín,

We had the same problem on our own server. We stopped the service and later deinstalled LVS. We had big problems to shrink msdb. We found these links:

Since we have started the License Validation Service a few days ago on our SQL server the system database msdb grows about 3.2 GB. We have seen that since the service has started the service SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 puts events in a special queue named WMIEventProviderNotificationQueue in database msdb. In the meantime we have over 800.000 events there.

Here it is explained how it works:

Understanding the WMI Provider for Server Events

http://msdn.microsoft.com/en-us/library/ms181893.aspx

This helped us to shrink msdb:

We found our problem described here (in german language)

Unexpected massive growing of mdsb

http://blog.trivadis.com/blogs/imsms/archive/2008/05/19/unerwartetes-massives-wachstum-von-msdb-oder...

Regards

Bernhard

[agustin_marcoscividanes]

Dear Bernhard

Thanks for your reply.

Tomorrow we will install the LVS 2.0. SAP says that this bug is fixed.

Kind regards.

Agustín Marcos Cividans