I click new field button but i see error pop-up. But i can create new field on defect module.
Error code : 0x800413EC
Thanks a lot.
So we have a script working that automatically goes down the list of tests in Test Plan (you have to supply the folder path) and links every test to a requirement. The tests have a custom field called Req Ref ID, which we populate with the IDs of any requirements, and the requirements have a required field of the same name. The script simply checks the two fields, sees if there are any matches, and performs the linkage. The problem is: it crashes if it hits a test that has existing linkage. The solutions I could think of range from complicated to dangerous. The best option I can think of is to have it check whether a test has coverage or not, if no perform linkage, if yes wipe out existing coverage, then perform linkage. I'm not great at VBScript, though, and don't really know how to make it remove existing coverage. If anyone can help I'd greatly appreciate it... Here's the script:
'IN THE WORKFLOW SCRIPTS > PROJECT SCRIPTS > COMMON SCRIPT
'Use the following script to redirect this function to the module specific function:
'Use ActiveModule and ActiveDialogName to get
'the current context.
On Error Resume Next
'Use the following script to redirect this function to the module specific function:
Select Case ActiveModule
' Case "Defects"
' ActionCanExecute = Defects_ActionCanExecute(ActionName)
' Case "Test Lab"
' ActionCanExecute = TestLab_ActionCanExecute(ActionName)
Case "Test Plan"
If ActionName = "Link_T_to_Req" Then
' ActionCanExecute = TestPlan_ActionCanExecute(Link_TestP_to_Req)
' MSGBOX "IN TEST PLAN2"
' Case "Requirements"
' ActionCanExecute = Requirements_ActionCanExecute(ActionName)
' Case "Management"
' ActionCanExecute = Management_ActionCanExecute(ActionName)
' Case "Test Resources"
' ActionCanExecute = Resources_ActionCanExecute(ActionName)
' Case "Business Components"
' ActionCanExecute = Components_ActionCanExecute(ActionName)
' Case "Dashboard"
' ActionCanExecute = Analysis_ActionCanExecute(ActionName)
' Case "Business Models"
' ActionCanExecute = BusinessModels_ActionCanExecute(ActionName)
' Case "Test Runs"
' ActionCanExecute = TestRuns_ActionCanExecute(ActionName)
'ActionCanExecute = DefaultRes
On Error GoTo 0
'IN THE WORKFLOW SCRIPTS > PROJECT SCRIPTS > TEST PLAN MODULE SCRIPT
strMessage =Inputbox("Enter the sub-root folder name: ","Input Required")
If (strMessage <> "") AND (strMessage <> " ") Then
' strNodeByPath = "Subject\" & "Test" ' CAN REQUEST FOLDER NAME AS PARAMETER
strNodeByPath = "Subject\Project EMEE\" & trim(strMessage)
MsgBox "WE ARE DONE! "
MsgBox " ** YOU DID NOT ENTER A FOLDER !! **"
' Variable for adding the coverage
Dim TestF, testL
Dim TreeMgr, TestTree, TestFactory, TestList
Dim TreeMg1r, TestTree1, TestFactory1
Set tdc = TDConnection
Set TreeMgr = tdc.treemanager
'Specify the folder path in TestPlan, all the tests under that folder will be exported.
Set TestTree = TreeMgr.NodeByPath(strNodeByPath)
Set TestFactory = TestTree.TestFactory
Set TestList = TestFactory.NewList("") 'Get a list of all from node.
'Specify Array to contain all nodes of subject tree.
ReDim Preserve NodesList(0)
'Assign root node of subject tree as NodeByPath node.
NodesList(0) = TestTree.Path
Temp = NodesList(0)
'Temp1 = NodesList(1)
' MsgBox " NodesList(0) = " & Temp
'Gets subnodes and return list in array NodesList
Call GetNodesList(TestTree, NodesList)
Dim Row, Node, TestCase
Row = 2
For Each Node In NodesList
Set TestTree1 = TreeMgr.NodeByPath(Node)
Set TestFactory1 = TestTree1.TestFactory
Set TestList1 = TestFactory1.NewList("") 'Get a list of all from node.
'Iterate through all the tests.
For Each TestCase In TestList1 'Loop through all the test cases
temp = " TS_TEST_ID= " & TestCase.Field("TS_TEST_ID") & " TS_USER_11= " & TestCase.Field("TS_USER_11")
''' MsgBox temp
' ignore if any of the test case do not have Ref ID field
If (TestCase.Field("TS_USER_11") <> "") AND (TestCase.Field("TS_USER_11") <> " ") AND (TestCase.Field("TS_USER_11") <> vbNull) Then
TestID = TestCase.Field("TS_TEST_ID")
RefID = TestCase.Field("TS_USER_11")
Temp1 = Replace(RefID , vbCrLf, ",") ' remove carriage return
Temp1 = Replace(Temp1 , vbLf, ",") ' remove line feed
Temp1 = Replace(Temp1 , vbCr, ",") ' remove line feed
Temp1 = Replace(Temp1 , ",,", ",") ' remove double comas as result of removing line feed
Temp1 = Replace(Temp1 , ", ,", ",") 'remove as result of removing line control chars
Temp1 = Replace(Temp1 , ",,", ", ") ' remove double comas as result of removing line feed
Temp1 = Trim(Temp1)
RefID = Temp1
' MsgBox RefID ' New
arrRefID = Split(RefID, ",", -1, 1)
temp = " UPPER BOUND OF ArrRefID = " & UBound(arrRefID)
' Msgbox temp
inti = 0
For inti = 0 To UBound(arrRefID) 'Loop through the individual ref number (ref1)
Temp = " init = " & inti & " arrRefID(inti) = " & arrRefID(inti)
''' Msgbox Temp
If ((arrRefID(inti) = "") or (arrRefID(inti) = " ") or (arrRefID(inti) = vbNull) or (arrRefID(inti) = vbNullChar) or (arrRefID(inti) = vbNullString)) Then 'Nothing to compare
''' MsgBox " NOTHING IN ARRAY VARIABLE SKIP"
'Connect to command object
Set com = tdc.Command
com.CommandText = "SELECT * FROM REQ WHERE RQ_USER_03 = '" & Trim(arrRefID(inti)) & "' "
''' MsgBox com.CommandText
Set recset = com.Execute
'Validate the results
If recset.RecordCount > 1 Then
MsgBox "Duplicate Requirement Ref ID found under Req Module"
'If record found map against req
ElseIf recset.RecordCount = 1 Then
reqID = recset("RQ_REQ_ID")
temp2 = " FOUND ReqID= " & reqID
''' MSGBOX temp2
Set reqF = tdc.ReqFactory
Set Req = reqF.Item(reqID)
Req.AddCoverage TestID, TDPOSITION_LAST
ElseIf recset.RecordCount = 0 Then
temp2 = " Not Found " & arrRefID(inti) & " in database "
''' MsgBox temp2
Next 'Loop through the individual ref number (ref1)
Else 'No REF ID
temp2 = " No Req Ref ID for Test.Field(TS_TEST_ID) = " & Test.Field("TS_TEST_ID")
''' MsgBox temp2
Next ' Loop TestCase In TestList
''' MsgBox "No more TestCase in TestList"
Next ' Node In NodesList
MsgBox "THE TRAVERSING THRU THE FOLDERS IS COMPLETE! "
Set tdc = Nothing
Set reqF = Nothing
Set Req = Nothing
Set TestFactory = Nothing
Set TestList = Nothing
Set TestFactory1 = Nothing
Set TestList1 = Nothing
Set recset = Nothing
Set TestTree = Nothing
Set TestTree1 = Nothing
Set TreeMgr = Nothing
'Returns a NodesList array for all children of a given node of a tree.
'@param: Node Node in a Test tree.
'@param: NodesList Array to store all children of a given node of a tree.
'@return: No explicit return value.
Function GetNodesList(ByVal Node, ByRef NodesList)
'Run on all children nodes
'MsgBox " Function GetNodesList Node = " & Node & " Node.Count = " & Node.Count
For i = 1 To Node.Count
'Add more space to dynamic array
NewUpper = UBound(NodesList) + 1
ReDim Preserve NodesList(NewUpper)
'Add node path to array
NodesList(NewUpper) = Node.Child(i).Path
'If current node has a child then get path on child nodes too.
Tmp = " i = " & i & " Node.Child(i).Count = " & Node.Child(i).Count
If Node.Child(i).Count >= 1 Then
Tmp = Node.Child(i)
' Msgbox " Node.Child(i) = " & Tmp
Call GetNodesList(Node.Child(i), NodesList)
I have 3 folder in requirements module. One of them has the all requirements within. Every each requirements has a field which keeps information about folder that the requirement will be moved. I would like to move all the requirement to related folder automatically.
Folder A -> 50 requirements
Folder B -> 0 requirement
Folder C -> 0 requirement
In Folder A, 20 requirements should be moved to Folder B, 30 requirements should be moved to Folder C. It will be specified by the special requirement field which should moved to which folder.
It can be SQL Procedure or action does not matter.
Thanks in advance.
Hello Good Day All,
In ALM 12.53 version Requirement module - when i change the status for any of the requirement type am getting the below error-
"You do not have the required permissions to execute this action . "
Its not allowing me to change even for the TD Admin , and for all other roles in project.
I have changed status from Any to Any , also workflow but still no clue for this .
PLease any one have any idea suggest me .
Thanks & Regards
Requirement user template entities - not visible or updateable in Requirement Module
A project was set up with RQ_User fields created and then requirements(2800) had been captured..
Later I decided to create a template project and copied the original project customisation as a basis.
I now manage all access permisions and entities etc through this template project (the original project now being linked to this)
- our Bug User _Template entities work just fine -
I now have added some new Rq_ User_Template entities and updated all the linked projects.
the problem is:-
1/ the requirement user template entities - are not visible in the Requirement details view at all
2/ Two of the new entities are Project Lists - and the list items/values are not visible in any of the requirement module views
3/ these new entities are not updateable in any of the requirement module views
4/ all the new User Template entities are visible in the Customize/Project Entities/Requirements/User Fields - so they have been rolled out to the project
5/ even with TDAdmin access - I cannot amend these fields
6/ the Template Project does have the original User Entities as RQ_User_01 - 10 as well
any suggestions please?
can I put some coding in the Workflow to make these accesible - if so please could you supply this
is it because I have a mixture of User Entities (created and populated in the original project) and new User Template Entities?
I will be grateful of some help please - I have 10+ projects linked to this and don't want to hard code this in each project, and iof course, any new ones. Plus I cannot lose any history/audit trail on any of the existing projects - so I cannot recreate/copy all the original fields/entities as template fields.
hope that is as clear as mud
if we changed somethink in an existing requirements and the "Assigned To" is filled in, automatic mails will send... all right!
But is it possible to script that the history, all comments and the actual attachments will send by default, too?
I know, that you can send all these points by checking the checkboxes for manual sending, but what is the script settings to send also for automatic mails?
Is it possible to make the validation errors more visible when importing from MS Excel? Currently the litle red highligh is not enough. Can you highlight the entire cell in yellow?
Need to visibly show via the Requirements Grid or Tree view when a requirement has been baselined or changed after being baselined.
Is it possible to implement a new way of hiding fields from the Details menu when creating a requirement?
When you have created a project from a template, the user fields created for that requirement entity get passed along to the project. However, if you have a requirement user field that should only apply to one project, adding that user field to the template, applies that field to all projects linked to the template. We need to be able to add user fields for an entity specific to an individual project even if that project is linked to a template.
I know someone on here must know this one. I'm trying to produce an excel spreadsheet in QC replicating the tree view. I understand somehow the RQ_ORDER_ID and RQ_PARENT_ID are related, but that's about it. Looking in the DB reference it talks about a self-join but I do not know how to generate a script for that. Right now, we are referencing off Path which is not correct. We are using MS SQL Server and QC 12.01. Any help is appreciated.
SELECT REQ.RQ_USER_TEMPLATE_01 'DOORS ID',
REQ.RQ_USER_TEMPLATE_04 'Requirement.Threshold Platform Type'
order by rq_req_path asc
Can someone guide me whether is it possible to create a requirement in HP ALM QC database using REST APIs.?
Thanks for the help in advance.
Little background. The team that is in charge of the Requirements has full access to that module except they can't delete requirements.
I have setup a Requirement Folder called Trash which allows them to cut/paste or drag/drop requirements they don't want into that folder. I have then setup Data Hiding so only the Admins can see requirements in that Trash folder.
Works great, but we just found 3 requirements in the Trash that should not have been there and they want to know when and who put them there. I looked and there is no history that shows this.
I think the field I need to enable History on is the RQ_FATHER_NAME but I can't enable History on that field.
Anyone have an Idea on how I can track in history when and who puts a requirement under the Trash folder?
I'm on ALM 12.01
Hi, what is parameter I need to add to Site Admin -> Site configuration for Requirements coverage from Test Lab (not from Test Plan) ?
I need help.
If I upload requirements and found some error after the load (i.e. a few are wrong) and then I delete all of them, can I reset the req-id (auto generated) to start from beginning?
Am I able to load some additional Requirement Type Icons into ALM?
I have setup a Requirement Folder called Trash in each of my linked projects and have Data-Hiding enabled so whenever anyone "besides an admin" drags/drops requirements into that Trash folder they can no longer be seen by the users or show up in any of their reports. This effectivly deletes the items for the user but I don't loose any requirements or History, and I am able to restore items if needed, again without loosing history.
Only problem is that people keep trying to delete/rename/mess with the Trash folder which is locked down but I'd like to update that to have a standard Recycle Bin icon so they stop trying to mess with it, but I don't see any way to upload a custom icon. I'm also thinking about creating a new Requirement Type = Trash so I can more easily lock it down, but again, I'd like to have a good trash icon for it.
Is this possible?
I am expriencing a similar issue as listed in the following post. Image (s) pasted in the “Rich Text” of a requirement are displayed to the “author” of the requirement but not to any other user, who accesses that same requirement. The message displayed is “This image does not exist”.
Now, if any other user (different from the author), modifies that same requirement by pasting a few more image (s), he / she can only view them. But any other user including the Author, is not able to see those newly added images. The same message “This image does not exist” is displayed.
Original Post : http://community.hpe.com/t5/Quality-Center-ALM-Practitioners/Requirement-quot-The-image-does-not-exist-quot/m-p/6850997/highlight/true#M96234
Can you please help me with this issue? As we are heavily using the “Rich Text” a solution to this issue is extremely critical.
So far, I have done the following analysis:
- Checked the Site Admin module for any specific settings. Also, checked various if I need to setup any parameters in “Site Configuration”
- Checked the Project setup for any specific setting.For the (1) and (2) did not find any find any leads
- Also, checked the following tables :
SELECT * FROM CROS_REF where cr_entity='REQ' and cr_key_1=XXX order by CR_KEY_1
SELECT * FROM AUDIT_LOG where AU_ENTITY_TYPE='REQ' and au_entity_id= XXX order by au_time
SELECT * FROM SMART_REPOSITORY_LOGICAL_FILE SL,SMART_REPOSITORY_PHYSICAL_FILE SP
where SL.SRLF_PHYSICAL_ID=SP.SRPF_ID and SL.srlf_name like '%REQ_ XXX %'
order by SRLF_LAST_MODIFIED
Where XXX = Req ID
So essentially for every “image paste” action, an entry is made in the above tables. However, what I saw is the CRS_REF table is not getting updated for the majority of them.
In addition, I would like to get details / recommendations on the following :
- The “Rich Text” data is not stored on the database. It is stored in the file system. Can you please clarify this a bit further? Is there a way I can validate the images / paths on the QC Server?
- We can store “Rick Text” on the DB but it is not recommended. However, since we are planning to use the “Rich Test” option heavily, do you foresee any issues in storing it on a DB? As loosing that data (stored in Rich Text) will be catastrophic.
- Can you provide listing of all systems / application log/error file names with their path which can be used to troubleshoot issues?
I am using ALM 12 and have requirements which contain percent and greater than symbols. The problem is ALM is converting the % to # and the < to -= in the requirement description. Does anyone know a way to fix this so when I export the requirements, the symbols are exported correctly?
Version ALM 12.20
When creating a customized field that presents the requirement numbers that are traced to it, I have found the custom field updates as expected when the user is in the TDAdmin group but isn't able to execute it when they are in a different group. I have created a completely seperate group copied after the TDAdmin group and I am still unable to get the workflow script to execute. Only if they are in the TDAdmin group will it work.
I need all groups to be able to execute this code so that the traceability is displayed. This is used for a custom report that we can't change.
With HP ALM. I want to change the 'target cycle' and 'target release cycle' of all the requirements linked to the tests of a certain testset. Is this possible to do a certain filter on that with HP ALM?
Because now I have to do this manually one by one.
These requirements need to be have to correct 'Target release cycle' in order to have them included to generate the testfile with covered requirments of a certain release.
Thanks in advance.