1.0

Table Of Contents
VMware, Inc. 85
Chapter 8 System Health, Utilities, and Troubleshooting
Thedatarestoringscriptsprovidedare:
restoreTablesData:Thisscriptrestoresthedatafromthecost,hierarchy,andreportrelatedCSVfiles
tothecorrespondingvCenterChargebackdatabasetables.IntheSQLServerscript,youmustsetthe
@ARCH_DIRparametertothecompletepathofthefolderinwhichtheCSVfilesandtheSchema.inifile
are
saved.Youmustalsosetthe@REQ_FROM_DATEparametertothedatefromwhichthedatamustbe
restoredfromtheCSVfiles.IntheOraclescript,youmustsettheFROM_DATEparametertothedatefrom
whichthedatamustberestoredfromtheCSVfiles.ThevalueoftheEND_TIME
fieldintheCSVfilesis
comapredwiththisspecifieddatetoidentifythedatathathastoberestored.
restoreStatsData:ThisscriptrestoresthedatafromtheCBVCPerformanceStat.csvfiletothe
CB_VC_PERFORMANCE_STATtable.IntheSQLServerscript,youmustsetthe@ARCH_DIRparametertothe
completepathofthefolderinwhichtheCSVfileandtheSchema.inifilearesaved.Youmustalsosetthe
@REQ_FROM_DATEparameter
tothedatefromwhichthedatamustberestoredfromtheCSVfileandthe
@REQ_INTERVALparametertotherequiredsampleinterval.IntheOraclescript,youmustsetthe
FROM_DATEparametertothedatefromwhichthedatamustberestoredfromtheCSVfileandthe
REQ_INTERVALparameter
totherequiredsampleinterval.
Troubleshooting
Thissectiondescribessomeoftheissuesthatyoumightface,theprobablereasonsfortheiroccurrence,and
solutionorworkaroundfortheissues,ifany.Thefollowingissuesarecovered:
“UnabletoSendReportThroughEmail”onpage 86
“StorageSyncingJobFails”onpage 86
“UnabletouseCustomSSLCertificates”onpage 86
“UnabletoViewthevCenterChargebackPlugInintheVIClient”onpage 86
“ReportDoesnotDisplaytheMemoryUsageValueandtheCorrespondingCost”onpage 87
“ReportDoesnotDisplaytheNetworkTransmittedandNetworkReceivedStats”onpage 87
“ReportDoesnotDisplaytheDiskReadandDiskWriteStats”onpage 87
“UnabletoAddvCenterServerinvCenterChargeback”onpage 87
“ChangedTimezoneSettingisnotReflected”onpage 87
“InstallerThrowstheSQLDrivernotFoundErroronpage 88
“StatusofFailedDataCollectorisnotReflectedImmediatelyontheSystemHealthtab”onpage 88
“NonEnglishCharactersarenotCorrectlyStoredinthevCenterChargebackDatabase”onpage 88
“ServiceTemporarilyUnavailableErrorThrownwhenAccessingvCenterChargeback”onpage 88
“TextandMessagesonthevCenterChargebackUserInterfacearenotCorrectlyDisplayed”onpage 88
“ErrorOccursWhileImportingaHierarchyfromaCSVFile”onpage 88
“ChangestoChargebackHierarchyarenotReflectedintheConcurrentUserSessions”onpage 88
“ChangestothevCenterServerHierarchyarenotReflectedinvCenterChargeback”onpage 89
“UnabletoFetchthePrimaryGroupofaLDAPUseronpage 89