Re: unable to update using empty strings or 'null' in value

2019-12-16 Thread rhys J 
On Mon, Dec 16, 2019 at 2:51 AM Paras Lehana 
wrote:

> Hey Rhys,
>
>
> Short Answer: Try using "set": null and not "set": "null".
>
>
Thank you, this worked!

Rhys

Re: unable to update using empty strings or 'null' in value

2019-12-15 Thread Paras Lehana 
Hey Rhys,


Short Answer: Try using "set": null and not "set": "null".

Explanation: Although I empty fields via XML, I can see a similar problem
in your query that is actually telling the value to be a string "null" and
not the type null. See:

{ "id": "601000", "agent": {"set": "null"} ...

This commands Solr to index "null" to agent field that has fieldType of int
and that's why NumberFormatException. I could not index null by this either:

null

and would get the same error.

This is the command that I use now:



Notice the attribute null="true". You should be doing the similar thing via
json. Upon googling
,
I think this should work:

{ "id": "601000", "agent": {"set": null} ...

Notice the no quotes enclosing around null.

On Sat, 14 Dec 2019 at 01:17, rhys J  wrote:

> When I do the following update:
>
> curl http://localhost:8983/solr/dbtr/update?commit=true -d '[{ "id":
> "601000", "agen
> t": {"set": "null"},"assign_id": {"set": "320"},"client_group": {"set":
> "null"},"credit_class": {"se
> t": "null"},"credit_hold": {"set": "null"},"credit_hold_date": {"set":
> "null"},"credit_limit": {"set
> ": "null"},"credit_terms": {"set": "null"},"currency": {"set":
> "null"},"data_signature": {"set": "nu
> ll"},"debtor_id": {"set": "601000"},"dl1": {"set": "25611"},"dl2": {"set":
> "null"},"do_not_call": {"
> set": "null"},"do_not_call_date": {"set": "null"},"do_not_report": {"set":
> "null"},"in_aris_date": {
> "set": "2016-09-01 00:00:00"},"name1": {"set": "60 Grit Studios"},"name2":
> {"set": "null"},"next_con
> tact_date": {"set": "2018-12-24 00:00:00"},"parent_customer_number":
> {"set": "null"},"potential_bad_debt": {"set": "null"},"priority_followup":
> {"set": "null"},"reference_no": {"set": "25611"},"report_as": {"set":
> "null"},"report_status": {"set": "null"},"risk": {"set":
> "null"},"rms_acct_id": {"set": "null"},"salesperson": {"set":
> "null"},"ssn1": {"set": "null"},"ssn2": {"set": "null"},"status_code":
> {"set": "172"},"status_date": {"set": "2018-10-30 00:00:00"},"timestamp":
> {"set": "null"},"tz_offset": {"set": "null"},"warning_item_no": {"set":
> "null"},"watch_list": {"set": "null"},"watch_list_date": {"set":
> "null"},}]'
>
> I get the following error:
>
>  "error":{
> "msg":"For input string: \"null\"",
> "trace":"java.lang.NumberFormatException: For input string:
> \"null\"\n\tat java.base/jdk.interna
>
> l.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054)\n\tat
> java.base/jdk.internal.
> math.FloatingDecimal.parseFloat(FloatingDecimal.java:122)\n\tat
> java.base/java.lang.Float.parseFloat
> (Float.java:461)\n\tat
>
> org.apache.solr.schema.IntPointField.toNativeType(IntPointField.java:54)\n\ta
> t
>
> org.apache.solr.update.processor.AtomicUpdateDocumentMerger.getNativeFieldValue(AtomicUpdateDocume
> ntMerger.java:563)\n\tat
> org.apache.solr.update.processor.AtomicUpdateDocumentMerger.doSet(AtomicUpd
> ateDocumentMerger.java:436)\n\tat
> org.apache.solr.update.processor.AtomicUpdateDocumentMerger.merge(
> AtomicUpdateDocumentMerger.java:112)\n\tat
> org.apache.solr.update.processor.DistributedUpdateProcess
> or.getUpdatedDocument(DistributedUpdateProcessor.java:704)\n\tat
> org.apache.solr.update.processor.Di
>
> stributedUpdateProcessor.doVersionAdd(DistributedUpdateProcessor.java:372)\n\tat
> org.apache.solr.upd
>
> ate.processor.DistributedUpdateProcessor.lambda$versionAdd$0(DistributedUpdateProcessor.java:337)\n\
> tat
>
> org.apache.solr.update.VersionBucket.runWithLock(VersionBucket.java:50)\n\tat
> org.apache.solr.up
>
> date.processor.DistributedUpdateProcessor.versionAdd(DistributedUpdateProcessor.java:337)\n\tat
> org.
>
> apache.solr.update.processor.DistributedUpdateProcessor.processAdd(DistributedUpdateProcessor.java:2
> 23)\n\tat
>
> org.apache.solr.update.processor.LogUpdateProcessorFactory$LogUpdateProcessor.processAdd(L
> ogUpdateProcessorFactory.java:103)\n\tat
>
> org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
>
> org.apache.solr.update.processor.AddSchemaFieldsUpdateProcessorFactory$AddSchemaFieldsUpdateProcessor.processAdd(AddSchemaFieldsUpdateProcessorFactory.java:475)\n\tat
>
> org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
>
> org.apache.solr.update.processor.FieldMutatingUpdateProcessor.processAdd(FieldMutatingUpdateProcessor.java:118)\n\tat
>
> org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
>
> org.apache.solr.update.processor.FieldMutatingUpdateProcessor.processAdd(FieldMutatingUpdateProcessor.java:118)\n\tat
>
> org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
>
>

unable to update using empty strings or 'null' in value

2019-12-13 Thread rhys J 
When I do the following update:

curl http://localhost:8983/solr/dbtr/update?commit=true -d '[{ "id":
"601000", "agen
t": {"set": "null"},"assign_id": {"set": "320"},"client_group": {"set":
"null"},"credit_class": {"se
t": "null"},"credit_hold": {"set": "null"},"credit_hold_date": {"set":
"null"},"credit_limit": {"set
": "null"},"credit_terms": {"set": "null"},"currency": {"set":
"null"},"data_signature": {"set": "nu
ll"},"debtor_id": {"set": "601000"},"dl1": {"set": "25611"},"dl2": {"set":
"null"},"do_not_call": {"
set": "null"},"do_not_call_date": {"set": "null"},"do_not_report": {"set":
"null"},"in_aris_date": {
"set": "2016-09-01 00:00:00"},"name1": {"set": "60 Grit Studios"},"name2":
{"set": "null"},"next_con
tact_date": {"set": "2018-12-24 00:00:00"},"parent_customer_number":
{"set": "null"},"potential_bad_debt": {"set": "null"},"priority_followup":
{"set": "null"},"reference_no": {"set": "25611"},"report_as": {"set":
"null"},"report_status": {"set": "null"},"risk": {"set":
"null"},"rms_acct_id": {"set": "null"},"salesperson": {"set":
"null"},"ssn1": {"set": "null"},"ssn2": {"set": "null"},"status_code":
{"set": "172"},"status_date": {"set": "2018-10-30 00:00:00"},"timestamp":
{"set": "null"},"tz_offset": {"set": "null"},"warning_item_no": {"set":
"null"},"watch_list": {"set": "null"},"watch_list_date": {"set": "null"},}]'

I get the following error:

 "error":{
"msg":"For input string: \"null\"",
"trace":"java.lang.NumberFormatException: For input string:
\"null\"\n\tat java.base/jdk.interna
l.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054)\n\tat
java.base/jdk.internal.
math.FloatingDecimal.parseFloat(FloatingDecimal.java:122)\n\tat
java.base/java.lang.Float.parseFloat
(Float.java:461)\n\tat
org.apache.solr.schema.IntPointField.toNativeType(IntPointField.java:54)\n\ta
t
org.apache.solr.update.processor.AtomicUpdateDocumentMerger.getNativeFieldValue(AtomicUpdateDocume
ntMerger.java:563)\n\tat
org.apache.solr.update.processor.AtomicUpdateDocumentMerger.doSet(AtomicUpd
ateDocumentMerger.java:436)\n\tat
org.apache.solr.update.processor.AtomicUpdateDocumentMerger.merge(
AtomicUpdateDocumentMerger.java:112)\n\tat
org.apache.solr.update.processor.DistributedUpdateProcess
or.getUpdatedDocument(DistributedUpdateProcessor.java:704)\n\tat
org.apache.solr.update.processor.Di
stributedUpdateProcessor.doVersionAdd(DistributedUpdateProcessor.java:372)\n\tat
org.apache.solr.upd
ate.processor.DistributedUpdateProcessor.lambda$versionAdd$0(DistributedUpdateProcessor.java:337)\n\
tat
org.apache.solr.update.VersionBucket.runWithLock(VersionBucket.java:50)\n\tat
org.apache.solr.up
date.processor.DistributedUpdateProcessor.versionAdd(DistributedUpdateProcessor.java:337)\n\tat
org.
apache.solr.update.processor.DistributedUpdateProcessor.processAdd(DistributedUpdateProcessor.java:2
23)\n\tat
org.apache.solr.update.processor.LogUpdateProcessorFactory$LogUpdateProcessor.processAdd(L
ogUpdateProcessorFactory.java:103)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.AddSchemaFieldsUpdateProcessorFactory$AddSchemaFieldsUpdateProcessor.processAdd(AddSchemaFieldsUpdateProcessorFactory.java:475)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.FieldMutatingUpdateProcessor.processAdd(FieldMutatingUpdateProcessor.java:118)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.FieldMutatingUpdateProcessor.processAdd(FieldMutatingUpdateProcessor.java:118)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.FieldMutatingUpdateProcessor.processAdd(FieldMutatingUpdateProcessor.java:118)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.FieldMutatingUpdateProcessor.processAdd(FieldMutatingUpdateProcessor.java:118)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.FieldNameMutatingUpdateProcessorFactory$1.processAdd(FieldNameMutatingUpdateProcessorFactory.java:75)\n\tat
org.apache.solr.update.processor.UpdateRequestProcessor.processAdd(UpdateRequestProcessor.java:55)\n\tat
org.apache.solr.update.processor.AbstractDefaultValueUpdateProcessorFactory$DefaultValueUpdateProcessor.processAdd(AbstractDefaultValueUpdateProcessorFactory.java:92)\n\tat
org.apache.solr.handler.loader.JsonLoader$SingleThreadedJsonLoader.handleAdds(JsonLoader.java:507)\n\tat
org.apache.solr.handler.loader.JsonLoader$SingleThreadedJsonLoader.processUpdate(JsonLoader.java:145)\n\tat
org.apache.solr.handler.loader.JsonLoader$SingleThreadedJsonLoader.load(JsonLoader.java:121)\n\tat