Getting a BadSQLGrammar exception when upgrading f...

Former Member · ‎2018 Jul 27

The following exception is coming when upgrading Hybris commerce from 6.1 to 6.7 version during server startup and Hybris update operation.

INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | ERROR [Task-master-poll] [DefaultTasksQueueGateway] error while adding tasks to queue INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO tasks_aux_queue (PK, RANGE_VALUE, NODE_ID, NODE_GROUP, EXECUTION_TIME) SELECT FROM (SELECT PK, floor(0+ (dbms_random.value()(1000-0))) AS rangeCol, CASE WHEN p_nodeId IS NULL THEN -1 ELSE p_nodeId END AS nodeIdCol, CASE WHEN p_nodeGroup IS NULL THEN '---' ELSE p_nodeGroup END AS nodeGroupCol, p_executiontimemillis/1000/60 AS execTimeCol FROM tasks t WHERE p_failed = 0 AND p_executiontimemillis <= ? AND p_runningonclusternode = -1 AND NOT EXISTS (SELECT p_task FROM taskconditions WHERE p_task =t.PK AND p_fulfilled = 0)) A WHERE NOT EXISTS (SELECT 1 FROM tasks_aux_queue B WHERE A.PK = B.PK)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:876) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:937) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:947) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.gateways.DefaultTasksQueueGateway.addTasks(DefaultTasksQueueGateway.java:239) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.AuxiliaryTablesSchedulerRole.copyTasksToAuxiliaryTable(AuxiliaryTablesSchedulerRole.java:148) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.AuxiliaryTablesSchedulerRole.tryToPerformSchedulerJob(AuxiliaryTablesSchedulerRole.java:104) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.AuxiliaryTablesBasedTaskProvider.getTasksToSchedule(AuxiliaryTablesBasedTaskProvider.java:52) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.DefaultTaskService.getTasksToSchedule(DefaultTaskService.java:1086) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.DefaultTaskService.poll(DefaultTaskService.java:1058) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.DefaultTaskService$Poll.process(DefaultTaskService.java:934) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.task.impl.DefaultTaskService$Poll.run(DefaultTaskService.java:886) [processingserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.core.AbstractTenant$5.run(AbstractTenant.java:2460) [coreserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at java.lang.Thread.run(Thread.java:836) [?:1.8.0_172] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.core.threadregistry.RegistrableThread.internalRun(RegistrableThread.java:144) [coreserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:134) [coreserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) ~[ojdbc6-11.2.0.3.jar:11.2.0.3.0] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at de.hybris.platform.jdbcwrapper.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:313) ~[coreserver.jar:?] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:883) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:876) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:639) ~[spring-jdbc-4.3.14.RELEASE.jar:4.3.14.RELEASE] INFO | jvm 1 | main | 2018/07/24 13:13:24.764 | ... 15 more

former_member623026 · ‎2020 Sep 23

Any solution? We're facing on the same problem on update from 1905 to 2005.01 with oracle DB

Getting a BadSQLGrammar exception when upgrading from 6.1 to 6.7 version

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (1)

Answers (1)