Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

GRC CUP Error creating request

HI,

I am facing issue while creating request on CUP. Error message " Error Creating Request" .

Log file :

Caused by: com.sap.sql.log.OpenSQLException: The SQL statement "SELECT "EMAILID","EML_FROM","EML_TO","SUBJECT","MSG_NEW","REQID","STAGE","EMAIL_TYPE" FROM "VIRSA_AE_EMLLOG" WHERE "REQID" = ? AND "STAGE" = ? AND "EMAIL_TYPE" = ? AND "STATUS_FLAG" = ?" contains the semantics error[s]: - 1:53 - the column >>REQID<< is undefined in the current scope

- 1:60 - the column >>STAGE<< is undefined in the current scope

- 1:67 - the column >>EMAIL_TYPE<< is undefined in the current scope

- 1:105 - the column >>REQID<< is undefined in the current scope

- 1:121 - the column >>STAGE<< is undefined in the current scope

- 1:137 - the column >>EMAIL_TYPE<< is undefined in the current scope

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:38)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:101)

at com.sap.sql.sqlj.common.runtime.StatementAnalyzer.preprepareStatement(StatementAnalyzer.java:62)

at com.virsa.ae.dao.sqlj.EmailLogDAO_SJStatements.getSqlStatement(EmailLogDAO.java:978)

at com.virsa.ae.dao.sqlj.EmailLogDAO.findAllForEmailTypeAndReqidAndStageAndStatus(EmailLogDAO.sqlj:478)

Please help to resolve ASAP.

Former Member
Not what you were looking for? View more on this topic or Ask a question