Re: Pb with document versions manager

[ghislain\.cussonneau]

Hi,

I've use the oracle script. I've use this data type mapping to change the script like the DSS site describe it:

• NUMBER   --> NUMERIC
• VARCHAR2 --> VARCHAR
• DATE     --> DATETIME

This mapping is describe at this URL : http://www.indiana.edu/~dss/Services/DataWarehouse/Oracle/Sybase/conversion.html

Ghislain

Hi,

I don't think Jahia do this implicit conversion, so it seems like the script used to create the db schema is not correct. What script did you use and what modifications did you make on it ?
A good think would be to enable the debug mode in the log4j.xml, so that you have a more descriptive error and most probably the SQL request which produces this error message.

Michel

Hi !

I'm using Jahia 4.0.4 with a Sybase SGBD. All work fine instead of the document versions manager

I've got a problem whith the version manager. I want to use it (for example invalidate last modifications) and the jahia administration JSP whitch do that is based on implicit conversion betwen CHAR and NUMERIC types.

The Sybase DB don't accept this conversions. I've got this error :

[ServletException in:/views/engines/versioning/pages/sitemap.jsp] Cannot load page data from the database, Error in getStagingPageFieldIDs : La conversion implicite du type de donn�e 'CHAR' en 'NUMERIC' n'est pas autoris�e. Employez la fonction CONVERT pour ex�cuter cette interrogation., root cause:La conversion implicite du type de donn�e 'CHAR' en 'NUMERIC' n'est pas autoris�e. Employez la fonction CONVERT pour ex�cuter cette interrogation.'

Has anybody any idea ?

Thanks

Ghislain


Acc�dez au courrier �lectronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34�/mn) ; t�l : 08 92 68 13 50 (0,34�/mn)

Acc�dez au courrier �lectronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34�/mn) ; t�l : 08 92 68 13 50 (0,34�/mn)