I have a question, hope someone will address this, We are in a deep trouble.
AW Duplex / Web View/ HDS Duplex
Since web-view reporting is not meeting customer requirement, we proposed them for Crystal reports.
Customer gave us Dump data from Rogger server and we created reports based on Agents/ Call Drops/ Daily report etc etc.
We used three tables for all our reports
1) Agent table
2) Skill Group Table
3) Call Termination table
Reports works fine with the dump database and when we connect to Live Rogger DB using ODBC reports run well but complete data is not there, like if i query for this month data from 1st may till 31st may 2009, i get data from 15th May till 31st may. We understand that this database is not the historical. So we connected to our HDS Database via ODBC link.
However to our surprise, we dint get any data when we run the reports and when we digged into the database tables we dint see any data in the Agent Table & for Skill group table but data is there in Call Termination Table in HDS database which we in Rogger's database we see in all three tables.
Also AW database which is on the same server as HDS has the data for all three tables.
When i read documentation it says HDS has copy of AW database, but to our disappointment we dont have data in the database and we have to handover the reports by tomorrow.
I am not sure if we are missing something or is the the way it is, if its the way it is can i pls get some documentation which state that this...or some expert can help me what could be the cause.
We are in trouble, Please help.