Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0642

D toc

Problem - Unable to access customer encryption key

When trying to create, edit, or test a relational connection, you may receive the following error message:

Code Block
400 - Encryption Key Error. Please Contact Administrator:
Unable to access customer encryption key.

You are unable to access the relational source.

Solution

The encryption keyfile is missing from the 

D s item
itemdeployment
rtrue
, or the keyfile has been moved without updating the platform of the new location.

You must create and deploy this keyfile, which is required for ensuring that encrypted usernames and passwords are used in relational connections.

Info

NOTE: This keyfile must be created and deployed before any relational connections are created. Deployment requires access to the file system on the

D s node
.

After you have deployed the keyfile, you must configure the platform to point to its location. A platform restart is not required. 

For more information, see Enable Relational Connections.

Problem - Retrieving sample data for large relational tables is very slow

In some cases, you may experience slow performance in reading from database tables, or previews of large imported datasets are timing out. 

Solution

In these cases, you can experiment with the number of records that are imported per database read. By default, this value is 25000

To improve performance, you can modify the following setting. 

D s config

Code Block
"data-service.sqlOptions.limitedReadStreamRecords": 25000, 

To improve performance, you can try lowering this limit incrementally. Avoid raising this limit over 100000, which can overwhelm the browser. 

Content by Label
showLabelsfalse
max5
spacesDEV
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("troubleshooting","relational","database","jdbc") and type = "page" and space = currentSpace()
labelstroubleshooting jdbc datasource relational database

Page properties
hiddentrue
Related issues