system,screen you,can,fin"/>

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Error when access to System Log tab

admin
navigation

Hello,

I have an error (send it by email to me) when i attempt to access to "System Log" tab in configuration->System screen. you can fin the email error i get in the attachement of this thread.

Can you help to sole this error

ErrorMessage_SystemLogTab.txt ]
zino1973
· 50
zino1973
Replies (12)
helpful
0
not helpful

Did you upgrade? If so from which version? Can you copy the sql query and run it?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Iindeed I have just upgrade from 4.2 to 5.1.1, what query you want to run?


zino1973
· 50
zino1973
helpful
0
not helpful
SELECT this_.srn as srn24_0_, this_.messagetype as messaget2_24_0_, this_.messagesource as messages3_24_0_, this_.logmessage as logmessage24_0_, this_.username as username24_0_, this_.created as created24_0_ FROM gemini_systemlog this_ ORDER BY this_.srn desc

Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

ok i runed this sql query: "SELECT this.srn as srn240, this.messagetype as messaget2240, this.messagesource as messages3240, this.logmessage as logmessage240, this.username as username240, this.created as created240 FROM geminisystemlog this ORDER BY this_.srn desc"

and the obtain a results (50 lines)

··· but i canot attach new attachement with query result zino1973Friday, October 26, 2012, 1:46:29 PM
··· yes i attached it on the main questionzino1973Friday, October 26, 2012, 1:48:06 PM
··· no sorry is'nt possiblezino1973Friday, October 26, 2012, 1:49:37 PM

zino1973
· 50
zino1973
helpful
0
not helpful

You are not getting errors when running it?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

maybe i have error but i'am not see them, here is the result of the query run :

http://imageshack.us/photo/my-images/854/26102012144228.jpg


zino1973
· 50
zino1973
helpful
0
not helpful

Can you copy and paste the error from the first line (srn=50)?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful
  • 50
  • 0
  • Gemini
  • Le format de la chaîne d'entrée est incorrect. mscorlib à System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) à System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) à System.String.System.IConvertible.ToInt32(IFormatProvider provider) à System.Convert.ToInt32(Object value) à NHibernate.Type.PersistentEnumType.SystemInt32EnumConverter.Convert(Object input) à NHibernate.Type.PersistentEnumType.AbstractEnumConverter`1.ToObject(Type enumClass, Object code) à NHibernate.Type.PersistentEnumType.GetInstance(Object code) à NHibernate.Type.PersistentEnumType.Get(IDataReader rs, Int32 index) à NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) à NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[] names, ISessionImplementor session, Object owner) à NHibernate.Type.AbstractType.Hydrate(IDataReader rs, String[] names, ISessionImplementor session, Object owner) à NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session) à NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session) à NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session) à NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session) à NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies) à NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) à NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) à NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
  • Manager Person
  • 2012-10-26
  • 09:13:33.643

zino1973
· 50
zino1973
helpful
0
not helpful

Please send us your database (support@countersoft.com).


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

in has wich format backup or mdf file? and size is 200MB


zino1973
· 50
zino1973
helpful
0
not helpful

zipped backup, put on ftp / http for us to download


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful
ANSWER

ok the support send a me specific SQL script that solve my problem.


zino1973
· 50
zino1973