My Oracle Support Banner

SDK:IQuery Returns ORA-00907 on Production Suddenly (Doc ID 2498308.1)

Last updated on JULY 05, 2019

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

SDK:IQuery Returns ORA-00907 on Production suddenly

Error

at QueryText.main(QueryText.java:30)
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

Actual Behavior

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.

Expected Behavior

SDK:IQuery can work correctly.

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Deploy SDK:IQuery 
  2.  Execite SDK:IQuery

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.