What tests can be performed to determine that the Harvest ODBC Data Source is configured correctly?

Document ID : KB000028017
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary:

An ODBC Data Source is required in order for CA Harvest servers to connect with distinct database instances. To test that the Data Source has been created correctly, a few tests can be performed.

 

Environment:

CA Harvest 12.x, 13
Windows OSOracle database server

 

Instructions:

Please follow these steps to test to make sure the Datasource is configured correctly:

  1. Identify the Data Source that Harvest is using first. Normally its in the %HARVESTHOME%\HServer.arg file.
  2. Launch the properties for this Data Source in Start -> Settings ->Control Panel -> Admin Tools -> ODBC Data Sources -> System DSN -> Configure
  3. Make sure that this same Data Source Name exists in the %HARVESTHOME%/HServer.arg file.
  4. Make a note of the Server Name (if it is populated, normally it is blank). The Advanced tab should have the default username set as blank.
  5. The options Enable Scrollable Cursors and Application Using Threads should be checked ON.
  6. Use MS-DOS and navigate to C:\Program Files\CA\SharedComponents\odbc\bin or %HARVESTHOME%\ODBC\bin directory. Type drivconn or static (both are ODBC Test routines).
  7. Select the DSN Name (same as the one in step c) above) - by number.
  8. Provide the Harvest Database Schema username and password.
  9. Both tests should show success and should not cause any Ora-XXXX error messages.

An additional SQL Plus test could also be performed incase you get any TNS Timeout or such issues (user, pass below are the Harvest Database Username and Password)

  1. If step d) above has got the ServerName field populated, sqlplus user/pass@ServerName should get you to the SQL Prompt
  2. If step d) above has a Null value, sqlplus user/pass should get you to the SQL Prompt