search

digital-asset / daml

The Daml smart contract language
https://www.digitalasset.com/developers
801 stars 203 forks source link

HTTP JSON API on Oracle fails on query tokens greater than 256B #10780

Open stefanobaghino-da opened 3 years ago

stefanobaghino-da commented 3 years ago

Due to a known limitation on Oracle, the full-text JSON search index on the contract payload causes queries to fail is a query token is longer than 256 bytes.

Workaround: wipe the query store database and run the HTTP JSON API adding the disableContractPayloadIndexing=true as a parameter to the JDBC URL. This will slow down queries on the contract payloads but will enable query tokens larger than 256 bytes.

dasormeter commented 3 years ago

@stefanobaghino-da did we ever raise a ticket to oracle on this? Although i doubt it would be called a bug they may be able to provide some configuration ideas to increase this limit.

stefanobaghino-da commented 3 years ago

@stefanobaghino-da did we ever raise a ticket to oracle on this? Although i doubt it would be called a bug they may be able to provide some configuration ideas to increase this limit.

We haven't but it's probably worth checking if someone else did. So far Oracle's documentation explicitly tells you to re-write the query.