SDK:IQuery Returns ORA-00907 on Production Suddenly
(Doc ID 2498308.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Agile PLM Framework - Version 126.96.36.199 and later
Information in this document applies to any platform.
SDK:IQuery Returns ORA-00907 on Production suddenly
Caysed bt: Error code : 60086
Error message: ORA-00907: missing right parenthesis
Root Cause exception : com.agile.util.exception.CMAppException: ORA-00907: missing right parenthesis
SDK:IQuery Returns ORA-00907 on Production suddenly.
This SDK is created as WSX.The issue occurs for all objects and all users on production.
There is no changes on Production setting, Data, SDK program etc...
Same query can works fine on Web Client and same SQL which execute by SQL*Plus works fine on command prompt.
Also same SDK works fine on Development/Test Environment.
SDK:IQuery can work correctly.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Deploy SDK:IQuery
- Execite SDK:IQuery
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document