How to resolve the issue i.e. java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist which is thrown while performing ant initialize?

[Former Member]

After upgrading hybris platform to 6.6 and resolving all of the compilation errors, I found there is one more error coming while perfort initialize. The error description is as follow: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update ydeployments set propstableName ='typesystemprops' where propstablename NOT LIKE '%typesystemprops%' AND name IN ('ComposedType', 'AtomicType', 'CollectionType', 'MapType', 'AttributeDescriptor', 'EnumerationValue') AND typesystemname='DEFAULT']; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist.

Please someone help me resolving the error. Many many thanks in advance.

Regards, Siddharth

[Former Member]

Hi Siddharth,

I'm facing the same issue on hybris 6.5.0.7. Did you find a solution for this ? Best regards