1. Downloaded the SalesInsertExample.csv. This worked in the demo site.
2. I used the same file (without changes) in my local set-up.
3. I got the error 'org.postgresql.util.PSQLException: Error: syntax error at or near "null".
4. This is the result of the posgresql log file:
2013-11-25 23:01:51.853 NZDT,"adempiere","idempiere",4181,"
127.0.0.1:40327",52931c5c.1055,690,"INSERT",2013-11-25 22:46:04 NZDT,10/637,0,LOG,00000,"execute <unnamed>: INSERT INTO AD_Issue (Processing,JavaInfo,ReleaseTag,Processed,OperatingSystemInfo,DatabaseInfo,StatisticsInfo,Local_Host,AD_Issue_UU,Version,DBAddress,IssueSummary,Record_ID,ProfileInfo,SystemStatus,ReleaseNo,SourceClassName,SourceMethodName,LoggerName,Created,IsActive,CreatedBy,Updated,UpdatedBy,AD_Org_ID,Name,UserName,AD_Client_ID,AD_Issue_ID) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29)","parameters: $1 = 'N', $2 = 'OpenJDK Client VM 23.7-b01', $3 = 'iDempiere', $4 = 'N', $5 = 'Linux 3.5.0-23-generic unknown', $6 = '9.1.10;PostgreSQL 9.2 JDBC4 (build 1003)', $7 = 'C4U15B178P2235I8L24M28', $8 = 'adempiere-VirtualBox/
127.0.1.1', $9 = '6257840d-5ec9-4c9e-ac29-54a5eae77b83', $10 = '2013-06-27', $11 = 'jdbc:postgresql://localhost:5432/idempiere?encoding=unicode', $12 = '>>org.adempiere.exceptions.AdempiereException: org.adempiere.exceptions.DBException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ""null""
Position: 21
>>org.adempiere.exceptions.DBException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ""null""
Position: 21
[SQL: 0, 42601]
>>org.postgresql.util.PSQLException: ERROR: syntax error at or near ""null""
>> Position: 21
>> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
>> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
>> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
>> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
>> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
>> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
>> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
>> at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at reflect.Method.invoke(Method.java:606)
>> at org.compiere.db.StatementProxy.invoke(StatementProxy.java:126)
>> at com.sun.proxy.$Proxy0.executeQuery(Unknown Source)
>> at org.compiere.util.DB.getSQLValueEx(DB.java:1268)
>> at org.adempiere.impexp.GridTabCSVImporter.resolveForeign(GridTabCSVImporter.java:1272)
>> at org.adempiere.impexp.GridTabCSVImporter.preprocessRow(GridTabCSVImporter.java:780)
>> at org.adempiere.impexp.GridTabCSVImporter.fileImport(GridTabCSVImporter.java:284)
>> at org.adempiere.webui.panel.action.FileImportAction.importFile(FileImportAction.java:329)
>> at org.adempiere.webui.panel.action.FileImportAction.onEvent(FileImportAction.java:247)
>> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742)
>> at org.zko', $13 = '1', $14 = 'MH Food Corporation|TestClient|GardenWorld|SYSTEM|', $15 = 'E', $16 = '1.0c', $17 = 'org.zkoss.zk.ui.impl.UiEngineImpl', $18 = 'handleError:1359', $19 = 'org.zkoss', $20 = '2013-11-25 23:01:51.743', $21 = 'Y', $22 = '101', $23 = '2013-11-25 23:01:51.743', $24 = '101', $25 = '0', $26 = '?', $27 = '?', $28 = '11', $29 = '1002864'",,,,,,,,""
2013-11-25 21:43:50.076 NZDT,,,1038,"[local]",52930dc6.40e,1,"",2013-11-25 21:43:50 NZDT,,0,LOG,08P01,"incomplete startup packet",,,,,,,,,""
2013-11-25 21:43:50.078 NZDT,,,1037,,52930dc6.40d,1,,2013-11-25 21:43:50 NZDT,,0,LOG,00000,"database system was shut down at 2013-11-25 21:42:41 NZDT",,,,,,,,,""
2013-11-25 21:43:50.455 NZDT,"postgres","postgres",1054,"[local]",52930dc6.41e,1,"",2013-11-25 21:43:50 NZDT,,0,FATAL,57P03,"the database system is starting up",,,,,,,,,""
2013-11-25 21:43:50.471 NZDT,,,838,,52930dc3.346,1,,2013-11-25 21:43:47 NZDT,,0,LOG,00000,"database system is ready to accept connections",,,,,,,,,""
2013-11-25 21:43:50.472 NZDT,,,1059,,52930dc6.423,1,,2013-11-25 21:43:50 NZDT,,0,LOG,00000,"autovacuum launcher started",,,,,,,,,""
2013-11-25 22:00:16.202 NZDT,"adempiere","idempiere",2506,"
127.0.0.1:40109",529310df.9ca,1,"PARSE",2013-11-25 21:57:03 NZDT,11/988,0,ERROR,42601,"syntax error at or near ""null""",,,,,,"SELECT null_ID FROM null WHERE Value=$1 AND IsActive='Y' AND AD_Client_ID=$2",21,,"
5. I tested importing in other windows (i.e. Inventory Move, Production (Single Product), Freight Category etc.) and I was able to import the files. It's only in the Sales Order window.
6. This is my set-up - Version: 1.0.0.qualifier; Database Version: 201311061318_IDEMPIERE-1083.sql; Created the database from adempiere dump file and migrated to 1.0c.