HP ALM 11 - Excel Export Error (6442 Views)
Reply
Occasional Visitor
sha77
Posts: 2
Registered: ‎10-06-2010
Message 1 of 14 (6,442 Views)

HP ALM 11 - Excel Export Error

Hello,

i got an error message when i want to exort tests from Excel to HP ALM 11 using Export Wizard v.11.0.0.28:

###
General error: mdlShared: FindTestByName: Field < Subject > requires a value from the subject tree.

Export Report - 1 error.
###

I have a value choosen from the subject tree and HP ALM creates a folder but no test and no steps.

Any advices would be helpful!

Regards
Stefan
Please use plain text.
Occasional Visitor
sha77
Posts: 2
Registered: ‎10-06-2010
Message 2 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

Some more Info for this:

My Test Tree in HP ALM for testing the export function in Excel looks like this:

Subject > Test > Docs

My row in Excel mapped on Field "Subject":
Test\Docs\MyTestWithSteps

I got this error message and HP ALM creates the folder, but no Test and Steps.

Please use plain text.
Occasional Advisor
Breski
Posts: 11
Registered: ‎11-17-2010
Message 3 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

Hello Guys

I´m facing the same problem in ALM 11:

General error: mdlShared: FindTestByName: Field < Subject > requires a value from the subject tree

Export Report - 1 error.


Only the project "Demoproject" I can import requirements and testcases, but in the project that I created and customized I can not import testcases only import requirements.

Could someone help us?

Regards

Breski

Please use plain text.
Respected Contributor
Erodabasi Atacan
Posts: 588
Registered: ‎01-16-2008
Message 4 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

Hi sha,
Try \Test\Docs\MyTestWithSteps for the subject field
Please use plain text.
Occasional Advisor
Adile
Posts: 11
Registered: ‎02-18-2011
Message 5 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

How Did You Get Result?
I have the same Problem.

Row: 1, Column: B - Field 'Subject': Value Subject 1 is not a valid list item.
Row: 2, Column: B - Field 'Subject': Value Subject 1 is not a valid list item.
Please use plain text.
Frequent Advisor
Edwin Wiancko
Posts: 56
Registered: ‎11-24-2008
Message 6 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

I see this exact error on one of our installations that has https (note the "s") access but the same import file works fine for others installs of ALM.

Adile or Stefan, do you use https also?

Did anyone find a resolution?

Ed
Please use plain text.
Occasional Advisor
Breski
Posts: 11
Registered: ‎11-17-2010
Message 7 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

Hello

This is a issue on ALM 11.

For the moment I can propose that you try the following steps:

1. Make sure that the project has been backed up recently
2. Login to Site Administration and select the affected project
3. Click on the + next to the project name from the Site Projects screen to see the list of tables in this projectâ s DB
4. Select the SYSTEM_FIELDS table
5. Paste the following query and click on â Execute SQLâ button. Make a note of the SF_ROOT_ID (pointer to a list maintained in the ALL_LIST table) value for this record
SELECT * FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT'
6. Verify that there is no list associated with this root id:
SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = (SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT')
7. Verify that the default list we intend to use for the â Subjectâ field still exists:
SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = 2
8. Update the SYSTEM_FIELD table so that the â Subjectâ field correctly points to an existing list
UPDATE SYSTEM_FIELD SET SF_ROOT_ID=2 WHERE SF_COLUMN_NAME='TS_SUBJECT'
9. Verify that the changes were made as expected
SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT'
10. Update the SEQUENCES table so that QC knows that fields have been modified
UPDATE SEQUENCES SET SQ_SEQ_VALUE = SQ_SEQ_VALUE+1 WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION')
11. Verify that the updates were made correctly
SELECT * FROM SEQUENCES WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION')
12. Logout of Site Administration
13. Export Tests to QC using Excel add-in and verify that Tests are exported and no errors are noticed

Please let us know if this helps.

Best regards,
Breski
Please use plain text.
Frequent Advisor
Edwin Wiancko
Posts: 56
Registered: ‎11-24-2008
Message 8 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

My goodness Breski. What a quick and complete answer!

It was all going very good until step 11 revealed that the SEQUENCES table does not have entries for either "FIELDS_VERSION" or "TABLES_VERSION".

Any idea how to recover from this situation?

Thanks!!
Ed
Please use plain text.
Frequent Advisor
Edwin Wiancko
Posts: 56
Registered: ‎11-24-2008
Message 9 of 14 (6,442 Views)

Re: HP ALM 11 - Excel Export Error

Hello everyone,

The solution from HP Support for the error: "Field 'Subject': Value x is not a valid list item." was to execute the three queries below. The first will not have results (but no errors should occur) The second two will have results as shown below. The Excel Export macro should then work successfully.

Query 1:

UPDATE
SYSTEM_FIELD

SET
SF_ROOT_ID =
(SELECT
AL_ITEM_ID
FROM
ALL_LISTS
WHERE
(0 = 0)
AND AL_DESCRIPTION LIKE 'SUBJECT'
AND AL_FATHER_ID = 0)

WHERE
(0 = 1)
OR SF_COLUMN_NAME LIKE 'TS_SUBJECT'
OR SF_COLUMN_NAME LIKE 'BG_SUBJECT'



Query 2:

SELECT
SF_TABLE_NAME AS 'Table',
SF_COLUMN_NAME As 'Column',
SF_ROOT_ID As 'Tree Root FK'
FROM
SYSTEM_FIELD
WHERE
(0 = 1)
OR SF_COLUMN_NAME LIKE 'TS_SUBJECT'
OR SF_COLUMN_NAME LIKE 'BG_SUBJECT';

Result:
Table Column Tree Root FK
-----------------------------------
BUG BG_SUBJECT 2
TEST TS_SUBJECT 2


Query 3:

SELECT
AL_ITEM_ID As 'Tree Root ID',
AL_FATHER_ID As 'Parent',
AL_DESCRIPTION As 'Name'
FROM
ALL_LISTS
WHERE
(0 = 0)
AND AL_DESCRIPTION LIKE 'SUBJECT'
AND AL_FATHER_ID = 0;

Result:
Tree Root ID Parent Name
---------------------------
2 0 Subject

I was told HP R&D is working in this defect; according to them this problem occurs because of a database corruption, the corruption is per database, so it's per project. You can track it using the bellow link http://support.openview.hp.com/selfsolve/document/KM1040812

As of 3/18/11 they have implemented a fix for it, but it is QA process, it could be possible that the fix will be included in the ALM patch 2 (or maybe 3,) but we do not have an ETA.

Ed
www.genilogix.com
Please use plain text.
Occasional Visitor
fecsa
Posts: 2
Registered: ‎07-08-2011
Message 10 of 14 (6,420 Views)

Re: HP ALM 11 - Excel Export Error

Thanks a lot!

It caused me some headaches until found your post! Now it works!

 

br,

f

Please use plain text.
Occasional Visitor
Drew_ha
Posts: 1
Registered: ‎08-29-2011
Message 11 of 14 (6,291 Views)

Re: HP ALM 11 - Excel Export Error

Hi Folks,

 

I also require this functionality to use the product correctly.  Has a patch for this been released?  Is there an easier way to get this basic functionality to work without making changes directly to the database?

 

Thanks

- Andy

Please use plain text.
Occasional Visitor
Atish
Posts: 1
Registered: ‎11-28-2011
Message 12 of 14 (5,980 Views)

Re: HP ALM 11 - Excel Export Error

Thanks Breski

 

The solution worked like a charm.

Please use plain text.
Visitor
mesg2anil
Posts: 4
Registered: ‎07-12-2012
Message 13 of 14 (4,304 Views)

Re: HP ALM 11 - Excel Export Error

Hi Breski,

 

Thank you very much... all your steps are perfect... it is working for me!!

 

Regards,

Anil

Please use plain text.
Visitor
MDARLA777
Posts: 2
Registered: ‎04-16-2013
Message 14 of 14 (2,726 Views)

Re: HP ALM 11 - Excel Export Error

Method I:

1. Create a new dummy project and use it to export Tests

2. Copy Tests from dummy project to affected project


Method II

1. Update SYSTEM_FIELDS table

2. Update SEQUENCES


Neither options are easy to implement and cause too much work for the end users / admins. Need a fix for this problem.

 

 

 


==================================================
1. SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = (SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT')

2. UPDATE
SYSTEM_FIELD

SET
SF_ROOT_ID =
(SELECT
AL_ITEM_ID
FROM
ALL_LISTS
WHERE
(0 = 0)
AND AL_DESCRIPTION LIKE 'SUBJECT'
AND AL_FATHER_ID = 0)

WHERE
(0 = 1)
OR SF_COLUMN_NAME LIKE 'TS_SUBJECT'
OR SF_COLUMN_NAME LIKE 'BG_SUBJECT'


3. SELECT
SF_TABLE_NAME AS 'Table',
SF_COLUMN_NAME As 'Column',
SF_ROOT_ID As 'Tree Root FK'
FROM
SYSTEM_FIELD
WHERE
(0 = 1)
OR SF_COLUMN_NAME LIKE 'TS_SUBJECT'
OR SF_COLUMN_NAME LIKE 'BG_SUBJECT'

4. SELECT
AL_ITEM_ID As 'Tree Root ID',
AL_FATHER_ID As 'Parent',
AL_DESCRIPTION As 'Name'
FROM
ALL_LISTS
WHERE
(0 = 0)
AND AL_DESCRIPTION LIKE 'SUBJECT'
AND AL_FATHER_ID = 0

5. SELECT * FROM SEQUENCES WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION')

6. UPDATE SEQUENCES SET SQ_SEQ_VALUE = SQ_SEQ_VALUE+1 WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION')


 This worked for me. afterwards i am able to upload the TEst Scripts from Excel.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation