Need suggestions - Live data displayed on application but sometimes few fields display no values where as their matching values are seen in other reports when verified

Replies to This Discussion

Permalink Reply by Ashok Holani on August 25, 2010 at 1:52pm

Can you please provide more info? I did not understand what weather problem has to do with data refresh. Is it something like ticker?

• ▶ Reply

Permalink Reply by Javed Nehal Jamali on August 25, 2010 at 3:44pm

Hi Shivani,

In a first view it seems to be that it is a problem with joins. Developer would have used Inner join instead of "Left outer join". I am saying this because I have also faced the same issue but not in live in internal testing. There was some data that was coming as NULL from other module & due to that some extra fields were not populating.
Above solution works for me but I am not sure, it will work for you.

Thanks,
Javed Nihal

• ▶ Reply

Permalink Reply by Shivani Shukla on August 26, 2010 at 11:02am

Hi Ashok,

Here GPS data and other values are being populated from different application. Both are merged and displayed in one application.

Thanks,
Shivani

• ▶ Reply

Permalink Reply by Shivani Shukla on August 26, 2010 at 11:08am

Hi Javed,

You are right, this sort of problem had come once. So we resolved this one, but again issues are up coming & I am wondering if everything is defined properly then what could be the possible reasons why the consistency is not maintained?

Looking forward for more response!


Have a nice day all!

Thanks,
Shivani

• ▶ Reply