1.0.1

Table Of Contents
VMware, Inc. 91
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 92
“StorageSyncingJobFails”onpage 92
“UnabletouseCustomSSLCertificates”onpage 92
“UnabletoViewthevCenterChargebackPlugInintheVIClient”onpage 92
“ReportDoesnotDisplaytheMemoryUsageValueandtheCorrespondingCost”onpage 93
“ReportDoesnotDisplaytheNetworkTransmittedandNetworkReceivedStats”onpage 93
“ReportDoesnotDisplaytheDiskReadandDiskWriteStats”onpage 93
“UnabletoAddvCenterServerinvCenterChargeback”onpage 93
“ChangedTimezoneSettingisnotReflected”onpage 93
“InstallerThrowstheSQLDrivernotFoundErroronpage 94
“StatusofFailedDataCollectorisnotReflectedImmediatelyontheSystemHealthtab”onpage 94
“NonEnglishCharactersarenotCorrectlyStoredinthevCenterChargebackDatabase”onpage 94
“ServiceTemporarilyUnavailableErrorThrownwhenAccessingvCenterChargeback”onpage 94
“TextandMessagesonthevCenterChargebackUserInterfacearenotCorrectlyDisplayed”onpage 94
“ErrorOccursWhileImportingaHierarchyfromaCSVFile”onpage 94
“ChangestoChargebackHierarchyarenotReflectedintheConcurrentUserSessions”onpage 94
“UnabletoAccessthevCenterChargebackApplication”onpage 95
“UnabletoRemovethevCenterChargebackPlugInfromtheVIClient”onpage 95
“UnabletoFetchthePrimaryGroupofaLDAPUseronpage 95
“ChangestothevCenterServerHierarchyAreNotReflectedinvCenterChargeback”onpage 96