harvest Questions

In CA SCM Harvest Workbench, Version 12. 1..1.141 We face below error while check our or promoted. not always but frequently. what should be done to overcome this issue ? I tried to reinstall PEC in user maching, but it didnt fix. Any solutions ??

E0306003e: Could not connect to Broker: /pt_HBroker://r62dp10/0/haprd5 (Error Code = -307)

When I navigate to http://inwpiccm02:8080/harweb I get the following error:
Can't get hDB from pool. Check your 'harweb.cfg' and restart your servlet server.<br>java.lang.NullPointerException

SCM Version: r12.1.3
JDBC for SQL Server version: 4.0
$JAVA_HOME:C:\Program Files\Java\jre7

harweb.cfg:

JDBCDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBCConnectionURL=jdbc:sqlserver://INWPITSQL01;databaseName=cascm_test;integratedSecurity=false;selectMethod=cursor
Database=SQLServer
ConnectionPoolSize=5
ConnectionPoolMax=100
ConnectionUseCount=5
ConnectionTimeout = 2
Broker=inwpiccm02
AuthMode=Internal
WorkingDirectory=C:\\Program Files\\apache-tomcat-6.0.32\\webapps\\harweb\\temp
SessionTimeout=600
BusinessObjectsURL=http:// hostname:portnumber/InfoViewApp/logon.jsp
ContextsMaxCount=30
AllowedSwitchInBetween=true

Error log:
Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

I am sure I am using the correct db credentials.

Any ideas? THanks

By robert_lee - September 11, 20122 Answers

Can somebody tell me who uses Harvest? What corporations? I know AT&T, K-Mart use it.

Thanks!

Can a state process be created by command line script?

Does anyone have any experiance or heard of anyone integrating BMC Remedy Service Desk with CA-SCM?

The below ant script is running successfully until yesterday using Harvest 7:

C:\Program Files\CA\SCM\hco.exe" -pn 'Check Out - Read Only' -b '${application.harvest.broker}' -ced -usr '${application.harvest.userId}' -pw '${application.harvest.password}' -en '${application.harvest.environment}' -st '${application.harvest.state}' -vp '${application.harvest.projectdir}' -r -op '${application.harvest.pc}' -sy -cp '${application.checkedout.src}' -s '${application.harvest.filepattern}

But the above ant script is throwing error as below after upgrading to Harvest 12:

E0306003e: Could not connect to Broker: rs2i/haprd5 (Error Code = -306 ).
Error: Could not attach to broker.

I am able to log in with the same broker and credentials to Harvest 12 using CA SCM workbench.

Please help me in this because all our nightly builds stopped due to this.

I am looking for a solution where the password and userid to connect to Harvest is prompted at command line in the ant script without hardcoding it in the script.

Do you know how to do that?

I tried the -prompt option, that did not solve my problem entirely. Although the ant stops for prompt, I had to interrupt the script with CTRL+Z to get the PASSWORD: prompt.

Anyone tried to run SQL to remove the -b [broker] parm from a hexecp?

hexecp -b [broker]

We have over a thousand of these in Harvest 12.0 and they are not allowed in 12.1. (Oracle DB)

Just trying to find out if anyone else is having as much fun as I am.

CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.