HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

HPSM Todo list_some fields not showing data

SOLVED
Go to Solution
Regular Advisor

HPSM Todo list_some fields not showing data

Hello,

 

some of the Todo list fields are empty, records are not being populated. is there a way by which I can link todo table with incidents or problems to fill such fields. actually I have searched for that and found that there is no link done at the first place to make the existing working fields work as they are.

 

so why some fields are working and some are not? and how to fix that?

 

thanks a lot

 

1 ACCEPTED SOLUTIONS
Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

Hello,

Please post the existant records from the TodoMap table for the objects which are not working properly.

 

Use database manager for that as it was written in the previous post. For accessing database manager type db in the SM command line. In the opened window search for the TodoMap table and then check the existant records in it.

20 REPLIES
Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

Hello,

There is a table TodoMap which saves all mappig of the fields from specific tables to the Todo table.

 

Search for the records in that table and fix or add required mapping.

Regular Advisor

Re: HPSM Todo list_some fields not showing data

Hello Vadim,

 

I have done that already and it does not show how it is mapped with incidents or interactions.

 

Please see attachment.

Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

Regular Advisor

Re: HPSM Todo list_some fields not showing data

It does not work, dont know why.

will keep trying
Regular Advisor

Re: HPSM Todo list_some fields not showing data

Capture.PNG

Valued Contributor

Re: HPSM Todo list_some fields not showing data

Use Database manager to open Todomap table.

Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

Hello,

Please post the existant records from the TodoMap table for the objects which are not working properly.

 

Use database manager for that as it was written in the previous post. For accessing database manager type db in the SM command line. In the opened window search for the TodoMap table and then check the existant records in it.

Regular Advisor

Re: HPSM Todo list_some fields not showing data

thank you both for that, I reached there.
but still the fields not populated yet,do I have to refresh it someway?
Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

You have to check if the right named fields are mapped from your tables (probsummary,incidents ...) to the correct fields in the Todo table (actrually the fields which are set in the columns on the Todo form).

 

You just have to check for mistypes and probable modifications which could have changed the fields in which the data is stored.

Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

First of all check what is set in the mapping for the fields which does not have data.

Regular Advisor

Re: HPSM Todo list_some fields not showing data

I made sure nothing wrong with the fields names.
Valued Contributor

Re: HPSM Todo list_some fields not showing data

Give snapshots of dbdict: Todo, db: Todomap of using table.
And say few fields whitch not showing data.

Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

Just to make sure that we are talking about the same problem can you clarify the quotes below:

 

Records are populated in Todo list without a problem.

For some records some data is missing (like for some records columns in the Todo are empty but for some the same columns are filled out).

Data in some columns is missing based on objects (for example column 3 is empty for all Interactions, but for Incidents is filled out).

Regular Advisor

Re: HPSM Todo list_some fields not showing data

todo.PNGtodo.PNGincidents.PNG

Highlighted
Valued Contributor

Re: HPSM Todo list_some fields not showing data

OK, now open some test incident.

Go to RAD Debagger and:

d contact.cisco.no in $L.file

if Value is NULL

contact.cisco.no in $L.file="111"

 

And save incident, now u can see this number(111) in Todo?

 

 

Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

Input on the Todo form  is correct for that columns?

Regular Advisor

Re: HPSM Todo list_some fields not showing data

Yes, fileds are now populated for the new ticket, thank you.

but what about the old ones?
Valued Contributor

Re: HPSM Todo list_some fields not showing data

[ Edited ]

Old record go to Todo table only after save incident/interactions and etc. Triggers works.

Honored Contributor Honored Contributor

Re: HPSM Todo list_some fields not showing data

You would not get that fields filled out for the old records unless you run mass update or something like that. Or a short script which will go trough all that records and populate that fields to the Todo table.

 

If you have added your fields to mapping later, the old records in the Todo are not updated automatically.

Regular Advisor

Re: HPSM Todo list_some fields not showing data

thank you so much,

 

really appreciate your help