My Oracle Support Banner

Migration Runtime Repository Data Service Export REST API Error:ORA-00936 Missing Expression (Doc ID 2647071.1)

Last updated on FEBRUARY 05, 2021

Applies to:

Siebel CRM - Version 19.10 and later
Information in this document applies to any platform.

Symptoms

When attempting to use the Migration Application REST API to export the Migration Runtime Repository Data Service

https://<host>:<port>/siebel/v1.0/service/Migration Runtime Repository Data Service/Export

Request body:
{
"body":
{
  "workspace":"<workspace branch name>",
   "version":"<version>",
}

 

The following error occurs in the Migration Log


2020-02-12 17:21:21
2020-02-12 17:21:21 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-00936: missing expression
2020-02-12 17:21:21
2020-02-12 17:21:21 Failed to fetch records
2020-02-12 17:21:21 Error in Preparing Where Clause for Incremental D2P
2020-02-12 17:21:21 Error in doExport ().
2020-02-12 17:21:21 Error in Main function...
2020-02-12 17:21:21 Elapsed time: 1 sec.
2020-02-12 17:21:21 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

2020-02-12 17:21:21 SQL Statement:

SELECT LANG_CD, ROW_ID FROM SIEBEL.S_RR_OBJ_VER

WHERE REPOSITORY_ID = '1-2XJM-1'

 AND WS_ID = '1-2XJM-4'

 AND VERSION_NUM = 292

  AND LANG_CD IN(, 'ALL');

2020-02-12 17:21:21 [DataDirect][ODBC Oracle driver][Oracle]ORA-00936: missing expression

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
References


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