Error on unmarshalling field

25 views
Skip to first unread message

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 2:13:50 AM9/22/16
to OrientDB

Hai, 
If i select that particular record #33:2073 or if update  am getting this error,

com.orientechnologies.orient.core.exception.OSerializationException: Error on unmarshalling field 'install_count' in record #33:2073 with value: install_count:"0"

Even i can't delete that record also.

Thanks and Regards,
T.Pugazharasan.



Oleksandr Gubchenko

unread,
Sep 22, 2016, 2:20:05 AM9/22/16
to OrientDB
Hi, which version are you using?

Thank you.

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 2:23:18 AM9/22/16
to OrientDB
Version : orientdb-community-1.7.11-20141127.163804-2-distribution

Oleksandr Gubchenko

unread,
Sep 22, 2016, 2:29:18 AM9/22/16
to OrientDB
Why are you using such an old version?
There were some bugs fixed in next versions, see: https://github.com/orientechnologies/orientdb/issues/2924

Are you considering updating to the latest 2.2.x version?

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 2:35:35 AM9/22/16
to OrientDB
At that time of create the application, i have use that version in future we are plan to migrate to newer version.
Now currently am having that error, kindly give solution for recover that error, am waiting for your answer.

Oleksandr Gubchenko

unread,
Sep 22, 2016, 2:41:14 AM9/22/16
to OrientDB
Can you post your queries and db to reproduce the issue?

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 2:48:08 AM9/22/16
to OrientDB
select from  #33:2073

and response is

Oleksandr Gubchenko

unread,
Sep 22, 2016, 2:56:29 AM9/22/16
to orient-...@googlegroups.com
Can you try this query and post the output?

select @raw from #33:2073

Do you have JSON data in your record?

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 3:02:38 AM9/22/16
to OrientDB
Ya already i tried it ,am getting the same error..

Oleksandr Gubchenko

unread,
Sep 22, 2016, 3:06:37 AM9/22/16
to OrientDB
What is data type of install_count property?

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 3:24:45 AM9/22/16
to OrientDB
Integer

alessand...@gmail.com

unread,
Sep 22, 2016, 3:43:01 AM9/22/16
to OrientDB
Hi,
is your record a vertex or a document ?

Thanks

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 3:48:53 AM9/22/16
to OrientDB
Vertex name is : employee_activity
Under the vertex #33:2073 is a record

alessand...@gmail.com

unread,
Sep 22, 2016, 4:02:44 AM9/22/16
to OrientDB
Hi,
we have done some tests but without success.
How can we reproduce your problem ?

Thanks

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 4:51:39 AM9/22/16
to OrientDB
Either i want to delete the record or to update the record

alessand...@gmail.com

unread,
Sep 22, 2016, 5:27:59 AM9/22/16
to OrientDB
Hi,
could you try this command

delete from #33:2073 unsafe

Thanks

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 5:33:01 AM9/22/16
to OrientDB
Same error ...

alessand...@gmail.com

unread,
Sep 22, 2016, 5:41:48 AM9/22/16
to OrientDB
Hi,
could you try this command from console 

repair database

Thanks.

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 5:55:27 AM9/22/16
to OrientDB
Repairing database...
- Fixing dirty links...Done! Fixed links: 186, modified documents: 6
Repair database complete (0 errors)
orientdb {db=crm}>

Oleksandr Gubchenko

unread,
Sep 22, 2016, 5:59:17 AM9/22/16
to orient-...@googlegroups.com
So after this you are able to do delete or select the rid?

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 6:05:08 AM9/22/16
to OrientDB
No..

Oleksandr Gubchenko

unread,
Sep 22, 2016, 6:12:02 AM9/22/16
to OrientDB
You can also try exporting your db and than importing it again: http://orientdb.com/docs/last/Export-and-Import.html
But the best solution would be upgrade to the latest 2.2.x release with all bug-fixes of these years.
See: http://orientdb.com/docs/last/Upgrade.html for instructions. If you need any assistance with upgrade you can just ask.

Alex.

Pugazharasan Thirumalai

unread,
Sep 22, 2016, 6:14:15 AM9/22/16
to OrientDB
Okay, thanks you for help.
Reply all
Reply to author
Forward
0 new messages