Home » Developer & Programmer » Reports & Discoverer » REP-0496: Internal error - Unable to parse query
REP-0496: Internal error - Unable to parse query [message #380657] Mon, 12 January 2009 22:38 Go to next message
yasser2408
Messages: 1
Registered: January 2009
Location: OMAN
Junior Member
I merged three queries to into 1 to solve the problem on speed
but as I paste my query on report query I got this error.
REP-0496: Internal error - Unable to parse query

select A.EMP_CODE,A.NAME_ENG1 ||' '||NAME_ENG2 ||' ' ||NAME_ENG3 "EMPLOYEE NAME",
A.NAME_ARB1 || ' ' || NAME_ARB2 || ' ' || NAME_ARB3 || ' '|| NAME_ARB4 NAME,
A.GROSS_SALARY,GROSS_SALARY + ANNUAL_INCREMENT "AFTER INCREMENT",B.GRADE_CODE,
CASE WHEN(A.GROSS_SALARY + 600) > B.BASIC_ENDING THEN B.BASIC_ENDING ELSE (A.GROSS_SALARY + 600) END AS NEW_SALARY,
B.GRADE_NAME
FROM
PER_EMP_MASTER A , PER_GRADES B, (SELECT GROUP_NAME, MIN (BASIC_STARTING), MAX(BASIC_ENDING) FROM PER_GRADES GROUP BY GROUP_NAME) D
WHERE
A.GRADE_CODE = B.GRADE_CODE
AND B.GROUP_NAME = D.GROUP_NAME
AND A.WORK_STATUS = 'Y'
ORDER BY 1
Re: REP-0496: Internal error - Unable to parse query [message #380680 is a reply to message #380657] Tue, 13 January 2009 00:05 Go to previous message
Littlefoot
Messages: 20899
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's a lucky guess (as you didn't provide much information about your working environment, such as Reports Builder version): your version doesn't support CASE. Try to rewrite this query using DECODE instead.

Another guess: inline view is not supported - in that case, create a view and use it in the FROM clause.

[Updated on: Tue, 13 January 2009 00:06]

Report message to a moderator

Previous Topic: can't connect to Oracle Application Database by Discoverer Admin
Next Topic: Persian characters in PDF has a problem
Goto Forum:
  


Current Time: Wed Dec 07 12:56:30 CST 2016

Total time taken to generate the page: 0.08788 seconds