Skip to main content
Solved

Metrics Server Upload Failure


Forum|alt.badge.img+7

Hi All,

 

I build the new License Server and customized all the SQL Ports. All the CS releated function are working fine. But the Private Metrics reports upload is failing.

I changed the latest Ports in the below Registry with format of                                        commserve_name, port_number\Commvault based on previous experiance with CV engineers

  • sCLOUDINSTANCE
  • sDM2INSTANCE
  • sINSTANCE
  • sWFINSTANCE

Added the following additional setting.

Changed the ODBC configuration and connection was successful. 

 

But, the metrics upload is failing and I can found below error message in the CommserveSurveyUtility log

 

5804  555c  08/16 10:35:19 ### CommservSurvey::downloadTimeStamp() - Private: Download Timestamp file Failed with Error [0xEDD00000:{CvCURL::CvProtocolReq::download(463)} + {CvCURL::CvProtocolReq::SendReqest(614)} + {CvCURL::CvProtocolReq::Execute(690)/CvCURL.0.0x0-Requested Operation Failed. Return value from CURL: [0] Response code from server: [400]}]
5804  555c  08/16 10:35:19 ### CCommservSurvey::initialize() - Private: New scripts are being downloaded, initiating collection and upload.
5804  555c  08/16 10:35:19 ### downloadLicServerUpdateXml() - Private: Failed to receive LicenseXML from URL [webconsole/RestServlet/GetCustomerLicenseUsage?ccguid=EF36C66E-6A54-481B-88A2-DFF182BFF7F8], Error message [0xEDD00000:{CvCURL::CvProtocolReq::download(463)} + {CvCURL::CvProtocolReq::SendReqest(614)} + {CvCURL::CvProtocolReq::Execute(690)/CvCURL.0.0x0-Requested Operation Failed. Return value from CURL: [0] Response code from server: [400]}], response []
5804  555c  08/16 10:35:19 ### CCommservSurvey::downloadLicensingServerUpdateXml() - Private: CommServ Survey process failed during Download of License server update XML
5804  555c  08/16 10:35:19 ### CCommservSurvey::downloadScript() - Private: Timestamp file download had failed. Not attempting download at this time.
5804  555c  08/16 10:35:19 ### CCommservSurvey::collectSurveyData() - Private: Unable to read timestamp file [C:\Program Files\Commvault\ContentStore\Reports\CommservSurvey\private\downloads/sqlscripts/Timestamp.txt], bypassing file comparison. Error [0xECCC0002:{CQiFile::ReadWholeFile(1121)} + {CQiFile::Open(95)} + {CQiUTFOSAPI::open(77)/ErrNo.2.(No such file or directory)-Open failed, File=\\?\C:\Program Files\Commvault\ContentStore\Reports\CommservSurvey\private\downloads\sqlscripts\Timestamp.txt, OperationFlag=0x8000, PermissionMode=0x100}]
5804  555c  08/16 10:35:19 ### CCommservSurvey::collectSurveyData() - Private: Failed to open SQL Connection for [CommServ] Error Code [-1]

 

Can anyone suggest me, where can I check Sql connection and also suggest any other report which provide more details.

 

Thanks,

Mani

Best answer by Manikandn

@Gseibak , Verfied that the user has full access.

 

Raised the case with commvault and resolved the issue.

 

The solution was, even though we updated the our own password in the ODBC during the process, still the backend communication happening using sqladmin_cv. There is no option to change the default user.

 

We have tried with default de-crypted password of sqladmin_cv in the ODBC and issue solved.

View original
Did this answer your question?

5 replies

Forum|alt.badge.img+11
  • Vaulter
  • 118 replies
  • August 16, 2022

HI Mani,

 

can you confirm the download & upload URL’s are correct in control panel as descried below

 

https://documentation.commvault.com/2022e/expert/37700_activating_private_metrics_reporting_on_commcell_console.html


Forum|alt.badge.img+7
  • Author
  • Byte
  • 35 replies
  • August 16, 2022

Hi @Gseibak ,

 

I verified the above doccument too.

It was working before change the port. I am sure, need to check/change the port configuration somewhere.But, struggle to find the place.


Forum|alt.badge.img+7
  • Author
  • Byte
  • 35 replies
  • August 17, 2022

Hi All,

 

I resolved one issue out of two, but still getting SQL Communication issue.

 

CommserveSurveyUtility log

11352 4120  08/17 09:52:39 ### CCommservSurvey::initialize() - Private: Executing Commserve Metrics Data Collection
11352 4120  08/17 09:52:39 ### CvInternetGateway::setProxyFromCSDB() - Private: Using HTTP Proxy . Proxy Server [proxyrrus.delphiauto.net],Proxy User [aptiv\jj4l15],Proxy Port [8080]
11352 4120  08/17 09:52:39 ### CCommservSurvey::initialize() - Private: New scripts are being downloaded, initiating collection and upload.
11352 4120  08/17 09:52:39 ### CvInternetGateway::setProxyFromCSDB() - Private: Using HTTP Proxy . Proxy Server [proxyrrus.delphiauto.net],Proxy User [aptiv\jj4l15],Proxy Port [8080]
11352 4120  08/17 09:52:39 ### downloadLicServerUpdateXml() - Private: Response returned from the REST API [<App_ClientGroupCLAUsages commCellId="1056179"><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="-1" updateTime="1660176070" quotaType="100002" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="-1" updateTime="1660176070" quotaType="100004" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="-1" updateTime="1660176070" quotaType="100005" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="-1" updateTime="1660176070" quotaType="100006" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100007" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100011" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100013" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100014" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100020" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100023" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100026" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100028" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100035" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100036" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100037" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100038" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100039" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100041" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100042" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100043" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100044" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100045" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100046" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100047" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100048" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100049" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="0" updateTime="1660176070" quotaType="100050" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="120" updateTime="1660176070" quotaType="100017" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="2970" updateTime="1660176070" quotaType="100021" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="2970" updateTime="1660176070" quotaType="100022" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="0" quotaLimitGB="122880" updateTime="1660176070" quotaType="100034" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="3" quotaLimitGB="35" updateTime="1660176070" quotaType="100024" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="4" quotaLimitGB="35" updateTime="1660176070" quotaType="100025" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="6" quotaLimitGB="2970" updateTime="1660176070" quotaType="100040" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="194" quotaLimitGB="2970" updateTime="1660176070" quotaType="100027" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="390" quotaLimitGB="680" updateTime="1660176070" quotaType="100032" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="602" quotaLimitGB="0" updateTime="1660176070" quotaType="100018" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="797" quotaLimitGB="2970" updateTime="1660176070" quotaType="100033" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="1182" quotaLimitGB="2970" updateTime="1660176070" quotaType="100019" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="5926047" quotaLimitGB="-1" updateTime="1660176070" quotaType="100016" expiryTime="0" /><usageData clientGroupName="CommCell Inherited Capacity" quotaUsedGB="6113060" quotaLimitGB="0" updateTime="1660176070" quotaType="100015" expiryTime="0" /></App_ClientGroupCLAUsages>]
11352 4120  08/17 09:52:39 ### CCommservSurvey::downloadLicensingServerUpdateXml() - Private: Successfully downloaded License server update XML
11352 4120  08/17 09:52:41 ### CvInternetGateway::setProxyFromCSDB() - Private: Using HTTP Proxy . Proxy Server [proxyrrus.delphiauto.net],Proxy User [aptiv\jj4l15],Proxy Port [8080]
11352 4120  08/17 09:52:41 ### CommservSurvey::downloadScript() - Private: Download started
11352 4120  08/17 09:52:42 ### CommservSurvey::downloadScript() - Private: Download done
11352 4120  08/17 09:52:42 ### CCommservSurvey::collectSurveyData() - Private: Failed to open SQL Connection for [CommServ] Error Code [-1]
11352 4120  08/17 09:52:42 ### CCommservSurvey::upload() - Private: There are no Collected Results available to upload, any existing XMLs will be uploaded
11352 4120  08/17 09:52:42 ### CCommservSurvey::zipUploadFiles() - Private: No files to zip!
11352 4120  08/17 09:52:42 ### CCommservSurvey::upload() - Private: Attempting non-proxy upload
11352 4120  08/17 09:52:42 ### CommservSurvey::uploadfiles() - Private: Upload started
11352 4120  08/17 09:52:42 ### CommservSurvey::uploadfiles() - Private: No files to upload in directory C:\Program Files\Commvault\ContentStore\Reports\CommservSurvey\privateupload of pattern CSS*_*.*
11352 4120  08/17 09:52:42 ### CCommservSurvey::upload() - Private: Failed to upload xml, deleting files created before [30] days only. 
11352 4120  08/17 09:52:42 ### CCommservSurvey::upload() - Private: CommServ Survey process completed without uploading the XML (no files found to upload)
11352 4120  08/17 09:52:42 ### CCommservSurvey::~CCommservSurvey() - Private: Commserve Survey execution complete

 

CVSurverlog

12308  12312  08/17 09:07:35 ERROR "CommServDatabase :: Failed to open DB 'CommServ', with error [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. (18456) (SQLDriverConnect); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CommServ" requested by the login. The login failed. (4060); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. (18456); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CommServ" requested by the login. The login failed. (4060)"
12308  12312  08/17 09:07:35 ERROR "CloudServicesDatabase :: Failed to open DB '', with error [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)"
12308  12312  08/17 09:07:37 ERROR "CustomerFeedbackDatabase :: Failed to open DB 'CVCloud', with error [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. (18456) (SQLDriverConnect); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CVCloud" requested by the login. The login failed. (4060); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. (18456); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "CVCloud" requested by the login. The login failed. (4060)"
12308  12312  08/17 09:07:37 ERROR "Failed to connect to database CVCloud."

 

Anyone have idea about where I need to check the permission?

 

I validated and there is no issue with ODBC connection.

 

Mani


Forum|alt.badge.img+11
  • Vaulter
  • 118 replies
  • August 17, 2022

Hi Mani,

 

make sure that user has sysadmin privs - can verify this in sql studio


Forum|alt.badge.img+7
  • Author
  • Byte
  • 35 replies
  • Answer
  • August 17, 2022

@Gseibak , Verfied that the user has full access.

 

Raised the case with commvault and resolved the issue.

 

The solution was, even though we updated the our own password in the ODBC during the process, still the backend communication happening using sqladmin_cv. There is no option to change the default user.

 

We have tried with default de-crypted password of sqladmin_cv in the ODBC and issue solved.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings