Bug 1051566
| Summary: | MS-SQL 2008 - Multiple "wrong column type" found on server startup (RTGOV_ACTIVITIES, BooleanExpression) | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Fuse Service Works 6 | Reporter: | Pavol Srna <psrna> | ||||||||||
| Component: | Build Process | Assignee: | Julian Coleman <jcoleman> | ||||||||||
| Status: | CLOSED NOTABUG | QA Contact: | Andrej Podhradsky <apodhrad> | ||||||||||
| Severity: | urgent | Docs Contact: | |||||||||||
| Priority: | unspecified | ||||||||||||
| Version: | 6.0.0 GA | CC: | atangrin, jpechane, ldimaggi, ncross, psrna, soa-p-jira, vdedik | ||||||||||
| Target Milestone: | CR1 | ||||||||||||
| Target Release: | 6.0.0 | ||||||||||||
| Hardware: | Unspecified | ||||||||||||
| OS: | Unspecified | ||||||||||||
| Whiteboard: | |||||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||||
| Doc Text: | Story Points: | --- | |||||||||||
| Clone Of: | Environment: | ||||||||||||
| Last Closed: | 2014-01-16 09:57:26 UTC | Type: | Bug | ||||||||||
| Regression: | --- | Mount Type: | --- | ||||||||||
| Documentation: | --- | CRM: | |||||||||||
| Verified Versions: | Category: | --- | |||||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||||
| Embargoed: | |||||||||||||
| Attachments: |
|
||||||||||||
|
Description
Pavol Srna
2014-01-10 15:13:42 UTC
Created attachment 848250 [details]
logs
Created attachment 848251 [details]
server.log
I have used mssql01.mw.lab.eng.bos.redhat.com mssql2008R2 DB. Just saw a 2nd error in the server.log: Caused by: org.hibernate.HibernateException: Wrong column type in dballo00.dbo.RTGOV_ACTIVITIES for column content. Found: text, expected: varchar(MAX) Caused by: org.hibernate.HibernateException: Wrong column type in dballo00.dbo.BooleanExpression for column expression. Found: text, expected: varchar(MAX) I cannot reproduce this issue. I think this error might have occurred because there was an old schema in the database (from previous builds). Could you try to first drop all tables in the database and then try to run the installation again? I dropped all tables (even in the testruns before) and still hit the issue. Tried several times. Please use the same DB as I did: mssql01.mw.lab.eng.bos.redhat.com mssql2008R2 DB. Tried (multiple times) to recreate this problem with this DB: jdbc:sqlserver://vmg04.mw.lab.eng.bos.redhat.com:1433;DatabaseName=dballo01 Ran into the same problem everytime - the installer could successfully connect to the DB via its 'test' UI button - but the installation failed with this error: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "dballo01" requested by the login. The login failed. See attached screenshot and install log. Will log this as a separate bz too. Created attachment 849631 [details]
Successful DB test dialog
Created attachment 849632 [details]
Unsuccessful install log
Are you sure you are using mssql jdbc4 driver version 3.0? In Pavol's log, I don't like this line: JBAS010403: Deploying JDBC-compliant driver class com.microsoft.sqlserver.jdbc.SQLServerDriver (version 2.0) In Len's log: JBAS010403: Deploying JDBC-compliant driver class com.microsoft.sqlserver.jdbc.SQLServerDriver (version 4.0) It should be "version 3.0", could you download the driver from here: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=21599 and try it again with that one? Cannot reproduce with driver from http://www.qa.jboss.com/jdbc-drivers-products/EAP/6.1.1/mssql2008R2/jdbc4/ and cleaned-up database |