Questions

I have a query that works as I expect only on some projects. (This is with Harvest r7.1 using an Oracle 10g database.):

SELECT En.EnvironmentName, ST.Statename,
PF.PathFullName || '\' ||IT.ItemName AS "Pathname",
VR.MappedVersion,
TO_CHAR(VR.CreationTime, 'YYYY/MM/DD HH24:MI:SS') AS "Created",
U.Username as "UserID", U.Realname as "Name"
FROM HarEnvironment EN,
HarState ST,
HarView VW, HarVersionInView VV,
HarVersions VR, HarItems IT,
HarPathFullName PF,
Harallusers U
WHERE IT.ItemType = 1
AND EN.EnvironmentName = 'EMERALD3'
AND ST.Statename in ('Coding','Development')
AND EN.EnvObjId = VW.EnvObjId
AND VW.ViewObjId = VV.ViewObjId
AND ST.ViewObjID = VW.ViewObjId
AND VV.VersionObjId = VR.VersionObjId
AND VR.ItemObjId = IT.ItemObjId
AND IT.ParentObjId = PF.ItemObjId
AND U.Usrobjid = VR.Creatorid
order by EN.Environmentname, VR.CreationTime ;

The intent was to list all file versions in the specified project and states in order of VR.CreationTime. However, it seems to always get zero results when the only versions are the BASE (0) versions. Apparently a project newly baselined from a snapshot will show zero results.

How should I change the query to show these BASE versions now being skipped?

Thanks,
Tom

I am a IT Compliance Auditor. Can anyone direct me as to where I might find an audit program for both of these CA products?

I need to perform a security health check and assessment for Endeavor and for Harvest.

We have Windows clients connecting fine to the broker through the GUI. Attempts to run hsql in a command window get past the login and provide a prompt for the SQL Command.

Any select command then hangs. There is no output in the log.

How to debug ?

What would be the Pros and Cons of using CA SCM in this way ?

Is there a better alternative that using CA SCM as a Definitive Software Library ?

Looking for guidance. All information would be appreciated on this topic.

Thanks.

We are trying to standardize our parallel development model, and I am trying to find a best practice to accomplish what we are looking to do. Here is the scenario:

Project: App - Prod
States (each with own view): Dev, Build, QA, Prod, Closed
Repository: App

Project App - Branch1
States (each with own view): Dev, Build, QA, MergetoProd
Repository: ?

The scenario is this: the project App - Branch1 is created in the future, after App - Prod has had multiple changes go through the lifecycle. I want the code visible in App - Branch1 to be the latest in Production at the time of creation (snapshot?).

I want a Cross Project Merge process to bring changes from App - Branch1 into the App - Prod lifecycle once Branch1 is complete with code updates.

I am still new with r12, so I am still learning the differences that need to be taken into account with the repositories. Are they supposed to share a repository, and if so, how does Branch1 get created based on the latest code in the Production state of App - Prod?

Thanks in advance,
Tim

With the Harvest r12.1 you have to specify a port number when using/installing an agent.

So the question is what port should we be using? I started using 5101.

Only down side I can think of is that my broker couldn’t have an agent on that same port. Currently, the broker’s agent is only used for testing. That’s no loss; I could live without an agent on the broker. I’ve also already opened 5101 on the boxes behind the firewall so by reusing that number I could avoid the inconvenience of opening up another port.

I’m I missing something? What else should I be considering?

We have a single Oracle DB instance hosting around 20 repositories. These repositories in turn are mapped to around 60 projects(environments). Now there is a requirement to get only one repository (mapped to around 4 proejects / environments). Can this be achieved..if so how?

Appreciate any help in this regard.

Cheers
Vijay

I am using following hco command for checking out the files from harvest for building project in Synchronize mode,

[b]<exec executable="C:\Program Files\CA\AllFusion Harvest Change Manager\hco.exe">
<arg line="-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}'"/>
</exec>[/b]

Untill yesterday it is working perfectly.

[i]Yesterday an update was happened to the harvest by the harvest admin, that is they added new process named "Check Out - Concurrent" to the harvest.[/i]

So after that if I am running my ant build using the above command (hco command in bold) results as following,

[b]I00060040: New connection with Broker HARVPROD established.
An invalid check out mode was given for process: 'Check Out - Concurrent'.[/b]

I've been trying to get some reporting working on package history and experience some 'challenges' to obtain the right set of data.

What I need is the (average) time it takes (or took) for a package to get from state X to state Y in a given environment.
I can get a per environment list of all Created, Promote and Demote actions from table harPkgHistory (plus the date/time of execution). But when a package has been promoted/demoted into a state more than once, the query returns too many rows.

Any help would be very welcome ...

Pages

CMCrossroads is a TechWell community.

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