Hi David,

I see that this table is populated only on the HDS machine. When I check this table in the AW machine, this table has no records. What do I do to get the records into this table on the AW machine? I just have one small query to run on this table, to get the CallTypeId using the SkillTargetID, that is all I intend to perform. I see no other tables where both the SkillTargetID and CallTypeID are present in one table.

Thank You,

-Bhaskar

Hi,

Why does this table in the AW database does not get populated?

-Bhaskar

Describe your machines. Do you have an AW (distributor) and an AW/HDS? Do you two AWs forming a 'site'. Do you also have two AW/HDS? Do you have WebView on another machine?

The HDS is the "Historical Data Store". What does that name mean to you? Where do you think historical data would be stored?

Regards,

Geoff

Hi Geoff,

I am sorry for the typo with the "machines". I have a machine which constitutes of AW and HDS. The database on this machine has AW database as well as HDS database. The TCD table of the HDS is populated with data, whereas the same table in the AW database isn't. I wonder why?

Thank You,

-Bhaskar

Termination Call Detail data is stored into the t_Termination_Call_Detail table on HDS database.

Termination_Call_Detail is actually a view like this -

On the AWDB --

CREATE VIEW Termination_Call_Detail AS SELECT t.* FROM aafes_hds.dbo.Termination_Call_Detail t

On the HDS -

CREATE VIEW Termination_Call_Detail AS SELECT t.* FROM t_Termination_Call_Detail t

As you can see, the view on HDS gets data from the local t_Termination_Call_Detail table whereas the one on AWDB is a view to the t_Termination_Call_Detail table on the HDS.

If this view on the AWDB is not configured correctly, you will run into this issue you describe.

There are sql files under c:\icm\install folder where you can find all the SQL needed to fix these views. I would open a TAC case on this so they can help fix these views as there is another procedure where a table is dropped to help recreate the views.

Hi,

Thanks for the information, very valuable.

I am also trying to get informtion from the t_Termination_Call_Detail table to get stats on wrap-up codes by using a Informaker without success. No data comes out in the reports. However, I have been able to create other customized reports,

1.Is there anything special with this specific table?,

2.Does it need to handled in an special way?

Thanks very much for your help.