Report queries and displays in one Maximo 7.5 environment but not another

I'm experiencing some crazy behavior with a BIRT report that is being imported into two IBM Maximo 7.5 environments. It works in one w/o a problem but displays a blank screen in another. The environments are set up the same.
 
It would seem that the blank screen would indicate that there is no data being returned in the environment that displays the blank screen but, in fact, when I load the SQL into TOAD there is data returned w/o issue.
 
I'm using version: 3.7.1 Build id: M20110909-1335
 
I've scoured the report looking for anything unusual but have been unsuccessful. I've checked and rechecked the SQL, the dataset and the settings in Maximo (amongst other things) and have found nothing. 
Has anyone ever experienced anything similar? Just not sure why the report would function fine in one environment but not another?
 
Thank you.

Find more posts tagged with

Comments

micajblock

At this point I have no other idea. I am not sure but I think Maximo logs report errors somewhere. I just do not know where. If you find these logs, please share.
 
One last few straws.
<ol><li>Copy the report, delete the inner part of the table and display the time zone only part of the outer table. That will verify if the outer query works.</li>
<li>Copy the report, replace the row[0]["timezone"] syntax with a hard coded value. </li>
</ol>

onthegomiller

I will work thru your last suggestion and I will definitely look into the logs and let you know whatever info I find.
 
Again, I appreciate all of your time.
 
Thanks ever so much.