Unable to retrieve rows from database. SELECT IM_SYSTEM_OPTIONS.
Hello everyone,
i am facing the login issue in REIM 13.2.6. i am getting this below error in the log.
2014-01-28 13:01:40,274 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] com.retek.reim.merch.utils.ReIMException - com.retek.reim.merch.utils.ReIMException: Unable to retrieve rows from database. SELECT IM_SYSTEM_OPTIONS.DEBIT_MEMO_SEND_DAYS,IM_SYSTEM_OPTIONS.CLOSE_OPEN_RECEIPT_DAYS,IM_SYSTEM_OPTIONS.COST_RESOLUTION_DUE_DAYS,IM_SYSTEM_OPTIONS.QTY_RESOLUTION_DUE_DAYS,IM_SYSTEM_OPTIONS.DOC_HIST_DAYS,IM_SYSTEM_OPTIONS.DEBIT_MEMO_PREFIX_COST,IM_SYSTEM_OPTIONS.DEBIT_MEMO_PREFIX_QTY,IM_SYSTEM_OPTIONS.DEBIT_MEMO_PREFIX_TAX,IM_SYSTEM_OPTIONS.CREDIT_MEMO_PREFIX_COST,IM_SYSTEM_OPTIONS.CREDIT_MEMO_PREFIX_QTY,IM_SYSTEM_OPTIONS.CREDIT_NOTE_REQ_PREFIX_COST,IM_SYSTEM_OPTIONS.CREDIT_NOTE_REQ_PREFIX_QTY,IM_SYSTEM_OPTIONS.CREDIT_NOTE_REQ_PREFIX_TAX,IM_SYSTEM_OPTIONS.POST_DATED_DOC_DAYS,IM_SYSTEM_OPTIONS.MAX_TOLERANCE_PCT,IM_SYSTEM_OPTIONS.DAYS_BEFORE_DUE_DATE,IM_SYSTEM_OPTIONS.DEFAULT_PAY_NOW_TERMS,IM_SYSTEM_OPTIONS.CALC_TOLERANCE_IND,IM_SYSTEM_OPTIONS.CALC_TOLERANCE,IM_SYSTEM_OPTIONS.TAX_VALIDATION_TYPE,IM_SYSTEM_OPTIONS.TAX_DOCUMENT_CREATION_LVL,IM_SYSTEM_OPTIONS.DEFAULT_TAX_HEADER,IM_SYSTEM_OPTIONS.TAX_RESOLUTION_DUE_DAYS, IM_SYSTEM_OPTIONS.VPN_ITEM_LOOKUP, IM_SYSTEM_OPTIONS.DFLT_CBC_REASON_CODE, IM_SYSTEM_OPTIONS.DFLT_CBQ_REASON_CODE, IM_SYSTEM_OPTIONS.DFLT_CMC_REASON_CODE, IM_SYSTEM_OPTIONS.DFLT_CMQ_REASON_CODE, IM_SYSTEM_OPTIONS.MATCH_USING_REF_3, IM_SYSTEM_OPTIONS.MATCH_USING_REF_4, IM_SYSTEM_OPTIONS.RECEIPT_WRITE_OFF_DAYS, IM_SYSTEM_OPTIONS.TAX_VALIDATION_SRC, IM_SYSTEM_OPTIONS.NUM_TAX_ALLOW,IM_SYSTEM_OPTIONS.POST_BASED_ON_DOC_HEADER, IM_SYSTEM_OPTIONS.PRORATE_ACROSS_TAX_CODES FROM IM_SYSTEM_OPTIONS WHERE 1=1
0