Skip to Content
author's profile photo Former Member
Former Member

SQL Server 2012 Update Bug

Hi,

I did install a hybris System on a Microsoft SQL Server and all was fine. But as soon as I tried to run an Update, it killed the server process.

I got the following Error Message in the log:

 ERROR [hybrisHTTP8] [HybrisSchemaGenerator] Make sure you are trying to update already initialized type system. Cannot read existing DbTypeSystem properly due to : PreparedStatementCallback; bad SQL grammar [select * from ydeployments where typesystemname=?]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'typesystemname'.

I altered the column TypeSystemName via SQL and renamed it to typesystemname. After that I was able to do an update. So I think there is a bug in the update procedure.

I reverted my change and did the following: I tested the following statement via Direct SQL Console in the HAC against an MS SQL Server (Problem) and MySQL (No Problem).

 Select * from ydeployments where typesystemname = 'DEFAULT'

Any suggestion how to fix the system without altering the database directly? (hybris Version: 5.3.0.2)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2014 at 02:10 PM

    You need to take care of choosing a CI (case insensitive) collate when creating a database for hybris. Also please ensure that the SQL Server has been properly set up as described here:Microsoft SQL Server. We've got a few really mandatory settings which cause errors if set differently.

    The commonly used collations are:

    • Latin1_General_CI_AS :Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

    • SQL_Latin1_General_CP1_CI_AS:- Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

    Old thread from forum: https://wiki.hybris.com/display/foruminternal/Recommended+SQL+Collation

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2014 at 02:48 PM

    Hi,

    I tried the link you attached and it is hybris internal, so I (and every other partner) can't read it. Would it be possible that you add the detail of choosing a CI collate to the Wiki?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.