VMware Cloud Community
Theovd
Enthusiast
Enthusiast

Error generating report

Hi all,

I have an issue with CB 1.6: When a try to generate a report 4 out of the 5 times, it gives an error. The error reported is

Error reading data from data source for vCenter Chargeback Database

vCenterCB.log on the CB server shows:

2011-04-04 14:27:45,383 ERROR [pool-3-thread-2] stat.UsageCollectorImpl: Error in getting samples from CBDB for vc server 506, resources [1, 2, 6] and entities [vm-3984, vm-4030, vm-4230].
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 75) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4700)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1683)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:956)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
at com.vmware.vim.vcenter.datacollector.stat.UsageCollectorImpl$5.getSamplesForEntitiesFromCBDB(UsageCollectorImpl.java:508)
at com.vmware.vim.vcenter.datacollector.stat.UsageCollectorImpl$5.executeInternal(UsageCollectorImpl.java:460)
at com.vmware.vim.vcenter.datacollector.stat.UsageCollectorImpl$5.executeInternal(UsageCollectorImpl.java:443)

From the error I can see that there is a deadlock problem in the database. Has someone an idea what can cause this and how it can be prevented.

My Setup

Chargeback 1.6 with vCloud Director and vShield Manager data collectors

Chargeback database running on SQL Server 2008 Std Edition.

vCenter 4.1 managing around 50 ESX servers and 500 VMs.

Thanks for any feedback

Theo

Reply
0 Kudos
4 Replies
deepak_ashwath
VMware Employee
VMware Employee

Hi Theo,

I too have faced the same issue, the setup is similar to yours except mine is v1.5

Once I have the reports scheduled to be mailed to the recipients, I get 2 errors and like as you said it works 5 out of 8 times.

The errors I get is

(1) Unable to save information in the database &

(2) The other error is the one you have mentioned.

Chargeback seems to be a very buggy tool, it still needs a lot of fixes

Any new configuration a user tries, he ends up with a problem

vCB1.GIF

Reply
0 Kudos
deepak_ashwath
VMware Employee
VMware Employee

While generating Reports or after scheduling the reports to be generated & mailed, the errors we encounter are

(1) Error reading data from data source for vCenter Chargeback Database


(2) Unable to save information in the database

Does anyone have any idea ? it seems to be a bug

Reply
0 Kudos
HemanthPannem
VMware Employee
VMware Employee

Hi Deepak,

Could you please provide logs to debug this further?

Regards,

Hemanth

Reply
0 Kudos
Theovd
Enthusiast
Enthusiast

Hi,

No idea yet. I still have a support request open at vmWare to have it solved.

Regards,

Theo

Reply
0 Kudos