SQL type mismatch for

Hi everyone.

I've problem with nuxeo and oracle. I had test environment which worked perfectly. Than I copied almost evereything(instance of nuxeo which worked) to my production environment. The new oracle database was made for production purposes. But when I connect nuxeo to oracle it's working, IDE and everything working. I can create/delete/move files and manage users. But when I looked into log files I can see such errors:

...
2016-03-31 08:48:39,342 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "UITYPESCONF_DENIEDTYPES"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,348 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "DEFAULTS_DC_SUBJECTS_AGG"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,353 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "VAR_GLOBAL_TASK2169"."REVIEW_RESULT": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,364 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "CONTENT"."MIME-TYPE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,364 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "CONTENT"."NAME": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,364 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "CONTENT"."DIGEST": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,364 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "CONTENT"."ENCODING": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,376 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BUTTON"."FILTER": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,377 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BUTTON"."NAME": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,377 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BUTTON"."LABEL": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,382 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "CONDITIONAL_STEP_FOLDER"."POSOFCHILDSTEPTORUNNEXT": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,389 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "COMMON"."ICON-EXPANDED": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,390 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "COMMON"."ICON": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,396 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "RS_ACE_PERMISSION"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,403 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "SEARCH_COVERAGE"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,409 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "DEFAULTS_DC_SUBJECTS"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,416 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "VAR_GLOBAL_TASK2556_P_705057AE"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,426 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "USERINFO"."LOGIN": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,426 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "USERINFO"."TENANTID": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,426 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "USERINFO"."FIRSTNAME": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,426 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "USERINFO"."LASTNAME": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,426 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "USERINFO"."COMPANY": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,426 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "USERINFO"."EMAIL": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,439 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BAS_EVENTIDS"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,447 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "MODERATORS"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,483 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."RIGHTS": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,483 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."FORMAT": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,486 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."FULLTEXT_PHRASE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,487 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."LANGUAGE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,487 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."FULLTEXT_ONE_OF": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,487 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."SOURCE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,487 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."DESCRIPTION": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,487 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."FULLTEXT_ALL": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,488 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."FULLTEXT_NONE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,488 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."CURRENTLIFECYCLESTATE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,488 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."SORTCOLUMN": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,488 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "ADVANCED_SEARCH"."TITLE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,501 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "RS_ACE_USERNAME"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,509 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "SORTINFOTYPE"."SORTCOLUMN": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,515 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TENANTCONFIG"."TENANTID": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,529 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "RNODE_TASKASSIGNEES"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,539 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TASK_INFO"."ACTOR": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,539 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TASK_INFO"."TASKDOCID": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,539 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TASK_INFO"."COMMENT": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,539 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TASK_INFO"."STATUS": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,566 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TASK_VARIABLE"."VALUE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,566 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "TASK_VARIABLE"."KEY": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,576 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "VAR_TASK328D"."COMMENT": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,581 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "VAR_TASK6D8"."COMMENT": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,588 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "SEARCHC_ALLOWEDCONTENTVIEWS"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,594 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "DEFAULTS_ECM_COLLECTIONS"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,601 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "COMMENT"."TEXT": expected 2005, database has 2011 / NCLOB (4000)
2016-03-31 08:48:39,602 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "COMMENT"."AUTHOR": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,617 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."PRINCIPALNAME": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,617 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."EVENTCATEGORY": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,617 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."TARGETDOCUMENTUUID": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,617 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."TARGETREPOSITORY": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,617 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."TARGETDOCUMENTTYPE": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,617 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."TARGETDOCUMENTPATH": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,618 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "BASICAUDITSEARCH"."EVENTID": expected 12, database has -9 / NVARCHAR2 (2000)
2016-03-31 08:48:39,624 ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "VAR_GLOBAL_TASK38E_PA_CBCE1CF7"."ITEM": expected 12, database has -9 / NVARCHAR2 (2000)
...

Like i said this errors doesn't interrupt normal working, but i'm afraid it could be dangerous stability

0 votes

1 answers

2280 views

ANSWER



Hi,

We're aware of these messages (NXP-19373) and this should get fixed soon. Note that you must have changed either Oracle version or Oracle JDBC driver version.

1 votes



Thank You. Thanks to this answer I investigated JDBC driver. Earlier I tried to install ojdbc7, but then i came back to ojdbc6. What I didn't know that ojdbc7 doesn't automaticly remove from "lib" folder in $NUXEO_MAIN. So I had to drivers installed. After deleting one of them(ojdbc7) everything is working again.

Thank You again.

03/31/2016