search cancel

Database error when creating a branch in GIT

book

Article ID: 252642

calendar_today

Updated On:

Products

CA Harvest Software Change Manager

Issue/Introduction

We are able to perform all the activity in terms of GIT, however only concern is during the creating of Branch in GIT, Also we could see system is able to create the branch however there was something stopping with the database side 
 
-- RETURN CODE: DB_FAIL
[Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected NUMBER got DATE
SQLSTATE=S1000
-- ROLLBACK (usually part of Database connection cleanup)
   ROLLBACK
-- SEND ERROR:   HSRV_E_DB [Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected NUMBER got DATE

Environment

Release : 14.0

Resolution

Broadcom demonstrated the approach of using a single service account for git object transfer using ssh protocol.
Individual Harvest account profiles need not be maintained on the server machine using this approach
A single Windows Service Account shall be created on the Windows server (on which Harvest runs) with limited access. Precisely only the git staging directory is to be shared with the harvest service account, and nothing else.
All users are going to use the same service account in the grub parameter of the Harvest-Git configuration file.
Service account shall only be used for the git object transfers during git operations
The actual changes to harvest will be done using the -usr parameter or the -eh parameter (if using encrypted dfo file) provided in the Harvest-Git configuration file.