What Are the Max URL Length For OOTB Web Crawler Before It Will Fail With Data Truncation Error? (Doc ID 2077674.1)

Last updated on NOVEMBER 20, 2015

Applies to:

Oracle Knowledge - Version 8.2.3 and later
Information in this document applies to any platform.

Symptoms

the OOTB OK/InQuira Web crawler failed at content update step (shows 100%) but failed with Data truncation errors as below:

[1977920 Local Workclient-default-taskrun (686)] UNKNOWN MESSAGE ID "HTTP_CRAWLER_DOC_UPDATE_FAILED" called with: "[Ljava.lang.Object;@74f4ccd5" "com.inquira.content.ContentStoreException: [Local Workclient-default-taskrun @ Thu Sep 24 20:54:33 EDT 2015 - ContentUpdate] (SQL_ERROR insert into doc_meta_info [SQLSERVER_PLACE_HOLDER] ( collection_id,doc_id,uuid,doc_language,doc_encoding,doc_type_id,cs_type_id,display_url,fetch_url,startpt_id,parent_id,checksum,status_code,doc_size_k,indexing_allowed,is_deleted,etag,creation_time,last_modified_time,valid_start_time,valid_end_time,recency, ranking, doc_level, direct_iqxml, crawl_rule_info, crawl_event_id, prep_event_id ) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) com.inquira.content.javahttp.httpDocument@17edacf0(51d2c417-9901-4111-b401-c8db1bacef39,46031))"
java.sql.DataTruncation: Data truncation



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms