Odd, I have no idea why that would be. Given that it is listed as bug #3920 <https://github.com/orientechnologies/orientdb/issues/3920> on GitHub I thought it would apply more broadly.
On Tuesday, April 14, 2015 at 12:14:04 PM UTC-5, l.garulli wrote: > > Great! However I'm using UTF-8 and seems to work like a charm. > > Lvc@ > > > On 14 April 2015 at 19:03, William Marshall <[email protected] > <javascript:>> wrote: > >> Found the problem! >> >> It turns out that the *ETL process does not support the UTF-8 Character >> Encoding*. I changed the encoding to ANSII and the errors disapeared. >> >> On Monday, April 13, 2015 at 4:37:38 PM UTC-5, William Marshall wrote: >>> >>> For the past few days I've been trying to get the orientdb-etl process >>> to import data from either JDBC or CSV, but I can't get it to parse my >>> configuration files. I've tried on both Windows and Linux, but I end up >>> with the same "Error on unmarshalling JSON content" every time. According >>> to JSON Lint my JSON is valid. None of the values are NULL, empty strings, >>> or contain backslashes. >>> >>> *Configuration File (company.json) contents* >>> { >>> "config": { "log": "debug" }, >>> "extractor": { >>> "jdbc": { >>> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", >>> "url": "jdbc:sqlserver://serverIP: >>> Port;databaseName=DBName;", >>> "userName": "**********", >>> "userPassword": "**********", >>> "query": "SELECT [COMPANY_ID],[COMPANY_NAME],[TRUE_LAST_DATE] >>> FROM [Testing].[Company]" >>> } >>> }, >>> "transformers": [ >>> { "vertex": { "class": "Company", "skipDuplicates": true } } >>> ], >>> "loader": { >>> "orientdb": { >>> "dbURL": "plocal:/databases/iirDev", >>> "dbType": "graph", >>> "dbAutoCreate": true, >>> "standardElementConstraints": false, >>> "classes": [ { "name": "Company", "extends": "V" } ] >>> } >>> } >>> } >>> >>> >>> *Resulting Error Messages* >>> *Windows* >>> G:\orientdb\bin>oetl.bat company.json >>> OrientDB etl v.2.0.6 (build @BUILD@) www.orientechnologies.com >>> Exception in thread "main" >>> com.orientechnologies.orient.core.exception.OSerializationException: >>> Error on unmarshalling JSON content '{ >>> "config": { "log": "debug" }, >>> "extractor": { >>> "jdbc": { >>> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", >>> "url": "jdbc:sqlserver://serverIP: >>> Port;databaseName=DBName;", >>> "userName": "**********", >>> "userPassword": "**********", >>> "query": "SELECT [COMPANY_ID],[COMPANY_NAME],[TRUE_LAST_DATE] >>> FROM [Testing].[Company]" >>> } >>> }, >>> "transformers": [ >>> { "vertex": { "class": "Company", "skipDuplicates": true } } >>> ], >>> "loader": { >>> "orientdb": { >>> "dbURL": "plocal:/databases/iirDev", >>> "dbType": "graph", >>> "dbAutoCreate": true, >>> "standardElementConstraints": false, >>> "classes": [ { "name": "Company", "extends": "V" } ] >>> } >>> } >>> }': content must be between { } >>> at com.orientechnologies.orient.core.serialization.serializer. >>> record.string.ORecordSerializerJSON.unwrapSource( >>> ORecordSerializerJSON.java:399) >>> at com.orientechnologies.orient.core.serialization.serializer. >>> record.string.ORecordSerializerJSON.fromString( >>> ORecordSerializerJSON.java:173) >>> at com.orientechnologies.orient.core.record.ORecordAbstract. >>> fromJSON(ORecordAbstract.java:165) >>> at com.orientechnologies.orient.core.record.impl.ODocument. >>> fromJSON(ODocument.java:1649) >>> at com.orientechnologies.orient.etl.OETLProcessor.main( >>> OETLProcessor.java:145) >>> G:\orientdb\bin> >>> *Linux* >>> orientdb@linux:/usr/bin/orientdb/bin> sh oetl.sh company.json >>> OrientDB etl v.2.0.6 (build @BUILD@) www.orientechnologies.com >>> >>> 2015-04-13 21:19:11:187 WARNING Not enough physical memory available for >>> DISKCACHE: 1,999MB (heap=494MB). Set lower Maximum Heap (-Xmx setting on >>> JVM) and restart OrientDB. Now running with DISKCACHE=256MB >>> [orientechnologies]Exception in thread "main" >>> com.orientechnologies.orient.core.exception.OSerializationException: >>> Error on unmarshalling JSON content '{ >>> "config": { "log": "debug" }, >>> "extractor": { >>> "jdbc": { >>> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", >>> "url": "jdbc:sqlserver://serverIP: >>> Port;databaseName=DBName;", >>> "userName": "**********", >>> "userPassword": "**********", >>> "query": "SELECT [COMPANY_ID],[COMPANY_NAME],[TRUE_LAST_DATE] >>> FROM [Testing].[Company]" >>> } >>> }, >>> "transformers": [ >>> { "vertex": { "class": "Company", "skipDuplicates": true } } >>> ], >>> "loader": { >>> "orientdb": { >>> "dbURL": "plocal:/databases/iirDev", >>> "dbType": "graph", >>> "dbAutoCreate": true, >>> "standardElementConstraints": false, >>> "classes": [ { "name": "Company", "extends": "V" } ] >>> } >>> } >>> }': content must be between { } >>> at com.orientechnologies.orient.core.serialization.serializer. >>> record.string.ORecordSerializerJSON.unwrapSource( >>> ORecordSerializerJSON.java:399) >>> at com.orientechnologies.orient.core.serialization.serializer. >>> record.string.ORecordSerializerJSON.fromString( >>> ORecordSerializerJSON.java:173) >>> at com.orientechnologies.orient.core.record.ORecordAbstract. >>> fromJSON(ORecordAbstract.java:165) >>> at com.orientechnologies.orient.core.record.impl.ODocument. >>> fromJSON(ODocument.java:1649) >>> at com.orientechnologies.orient.etl.OETLProcessor.main( >>> OETLProcessor.java:145) >>> >>> Does anyone have any ideas on what is going on here? >>> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best Regards, > > Luca Garulli > CEO at Orient Technologies LTD > the Company behind OrientDB > http://about.me/luca.garulli > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
