Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcushenriquesk

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00907: missing right parenthesis :

Hello I am getting this error: 

INCREMENTAL_TABLE <<
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00907: missing right parenthesis : [INCREMENTAL_TABLE]: SQL SELECT RESULT_ID, RP_ID, DEL_FLAG, RESULT_NUMERIC, RESULT_ALPHA, RESULT_CODE_ID, RESULT_CODE_TEXT, FLAG, DELTA_FLAG, LOW_OR_MEAN, HIGH_OR_SD, LOT_NAME, LOT_EXPIRE, DO_NOT_REPORT, CREATED_DATE, CREATED_BY, DELETED_DATE, DELETED_BY, RERUN, ISOLATE_ID, MEDIA_ID, CORRECTIVE_ACTION, DISPLAY_ON_REPORT, ANALYZER_ID, ANALYZER_XMIT_NAME, OPTIMAL_LOW, OPTIMAL_HIGH, RESULT_TRANSLATION, UNITS FROM ACUTIS.RESULTS WHERE (CREATED_DATE > TO_DATE('08/02/2021 12:54:47', yyyy-MM-dd hh24:mi:ss))
 
using this code:
 
[INCREMENTAL_TABLE]:
SQL SELECT
RESULT_ID,
RP_ID,
DEL_FLAG,
// TEST_ID,
RESULT_NUMERIC,
RESULT_ALPHA,
RESULT_CODE_ID,
RESULT_CODE_TEXT,
FLAG,
DELTA_FLAG,
LOW_OR_MEAN,
HIGH_OR_SD,
LOT_NAME,
LOT_EXPIRE,
DO_NOT_REPORT,
CREATED_DATE,
CREATED_BY,
DELETED_DATE,
DELETED_BY,
RERUN,
ISOLATE_ID,
MEDIA_ID,
CORRECTIVE_ACTION,
DISPLAY_ON_REPORT,
ANALYZER_ID,
ANALYZER_XMIT_NAME,
OPTIMAL_LOW,
OPTIMAL_HIGH,
RESULT_TRANSLATION,
UNITS
FROM ACUTIS.RESULTS
WHERE (CREATED_DATE > TO_DATE('$(vMaxValue)', yyyy-MM-dd hh24:mi:ss));
 
Unsure why this is happening, vmaxvalue is = to a date format of mm/dd/yyyy hh24:mm:ss
 
I get the max value from the current table using this script;
 

MAX_DATE_TABLE:
Load Max(CREATED_DATE) as MaxValue
from [lib://QVDs (adny1qlik01_qlikservice)/RESULTSUTI.qvd](qvd);

LET vMaxValue = TEXT(Timestamp((peek('MaxValue',0, 'MAX_DATE_TABLE')), 'MM/DD/yyyy HH:mm:ss'));

Labels (2)
4 Replies
Chip_Matejowsky
Support
Support

Hi @Marcushenriquesk,

 

Oracle Caller Interface: ORA-00907: missing right parenthesis is an Oracle error that is being returned to QlikView from the source, and is not a Qlik error per se.  

 

Per https://www.tekstream.com/resource-center/ora-00907-missing-right-parenthesis/,

Error ORA-00907 is a syntax error and therefore, is a commonly seen error by users writing code manually. This error indicates that there is a left parenthesis but no corresponding right parenthesis, or that additional information was contained within the parentheses.

 

To correct this error, you must find the part of code that contains the missing right parenthesis, insert the missing symbol in the correct spot, and run the statement again.

 

Hope this helps

 

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
Marcushenriquesk
Author

Sadly I reviewed the documentation, and I attempted to replicate the code in visual studio and it worked. it is something on qlik's data format side.

Chip_Matejowsky
Support
Support

Have a look at https://community.qlik.com/t5/QlikView-App-Dev/Oracle-Loading-and-Parenthesis-Problems/m-p/1206890 to see if that helps.  Otherwise, suggest you create a case with Qlik Support.

 

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
cwolf
Creator III
Creator III

The format in the TO_DATE function must to be set in single quotes:

TO_DATE('$(vMaxValue)', 'yyyy-MM-dd hh24:mi:ss')