Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Time of creating Fact build getting error target table column is missing

getting error Target table check
Inconsistencies found in the following tables:
   Connection 'JAZZDWH'
          Table '"RIODS"."PROJECT"'
                    Column '"TS_TEST_VERSION"' missing

0 votes


Accepted answer

Permanent link
Hello Pravin,

I'm not familiar with the article you mention, but from a first look it only leverages the existing fields in the RIODS.PROJECT table.
You can add any column you like to the table, using your DBMS commands, but you need to understand that if you want to see the additional columns in your report you will need a customization of the Framework Manager data model as well. That is not covered by the article.

Best Regards,

Francesco Chiossi
pravin gaykar selected this answer as the correct answer

0 votes

Comments

Hello Francesco, 

Thanks for earlier...
I have tried to find out how to add column in table using frame work manager but not yet get solution.  Can you help me to add coulmn in RIODS table or datawarehouse table.

Hello Pravin,

An high level description of Data warehouse customization is available in this section of the Insight Info Center:

Customizing the data warehouse
http://pic.dhe.ibm.com/infocenter/rentrpt/v1r1m1/topic/com.ibm.rational.raer.help.doc/topics/t_modifyingdatamartsusingrda.html

It also has an "Adding columns to a table" topic.

Best Regards,

Francesco Chiossi

article which you have given is ctreation column using diff. tool Info sphere data architect. Can you help to create column in dataware house DB itself using frame work manager or insight dev tools?

Hello Pravin,

I don't think you can do it from framework manager or data manager alone.
The alternative to Info sphere data architect would be using you DBMS administrative tools or SQL clients.

Best Regards,

Francesco Chiossi

Hi Francesco,

Using below article we are able to pull HPQC data into Dataware house.

https://jazz.net/library/article/1352

Now we want generate report using query studio or report studio.

Can you help on same?

Thanks,

Pravin


One other answer

Permanent link
Hello Pravin,

TS_TEST_VERSION is not a column of the RIODS.PROJECT table.

Could you please clarify what exactly you were doing when you got the error message?
Are you doing any customization?

Best Regards,

Francesco Chiossi

0 votes

Comments

Thanks for earlier, I am pulling data from HPQC to Insight DW. I am refering below article for same https://jazz.net/library/article/1352 In Project table delivery properties In table name fileld I have selected RIODS table is Project. How I can add TS_TEST_VERSION column in RIODS.PROJECT table?

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 25 '14, 6:07 a.m.

Question was seen: 5,331 times

Last updated: May 13 '14, 3:40 a.m.

Confirmation Cancel Confirm