This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi Everyone,
We are on Maximo 7.6.0.7 /WebSphere 8.5.5.11/Oracle 12c and facing a unique issue for one of our custom application. When we are running the saved ad-hoc report it throws an Invalid Identifier error message.
The first-time ad-hoc report runs perfectly but the second time saved ad-hoc report throws the invalid identifier error message. What I noticed in the log files, the second-time ad-hoc report didn't build up the SQL properly.
1=1 and "and" clause is missing in when saved report is run [ where ( assetstatus.assetnum = '150724') ]
Query When Report Run First Time.
select encdowntimehist.assetnum,a2.assettype,a3.changeby from encdowntimehist left outer join asset a2 on a2.assetnum = encdowntimehist.assetnum and a2.siteid = encdowntimehist.siteid left outer join assetstatus a3 on a3.assetstatusid = encdowntimehist.assetstatusid where 1=1 and ( encdowntimehist.assetnum = '150724' )
Query When Report Ran Second Second - Throwing Error
select encdowntimehist.assetnum,a2.assettype,a3.changeby from encdowntimehist left outer join asset a2 on a2.assetnum = encdowntimehist.assetnum and a2.siteid = encdowntimehist.siteid left outer join assetstatus a3 on a3.assetstatusid = encdowntimehist.assetstatusid where ( assetstatus.assetnum = '150724') and ( encdowntimehist.assetnum = '150724' )
Any idea wha'ts wrong here.
great, thanks for the heads up.