Updated recently

cryptic PreparedStatementCallback error when accessing project view
PLFM-6103
oauth client verification request should include client ETag
PLFM-6041
Download list item has incorrect icon
PLFM-6033
400 error when getting a table
PLFM-6069
9 500 responses for POST /entity/#/lockaccessrequirement
PLFM-6108
extend character limit on file view column
PLFM-6111
STS APIs to get temporary credentials
PLFM-6008
MigrationUtility: fix typos in config properties
PLFM-6053
A collaborator was able to add about half of her team however got the error below for the remaining half
PLFM-6105
cannot delete a folder with more than 10000 subfolders
PLFM-4989
Cleanup migration code for evaluations
PLFM-6113
ability to configure whether certification is required for data upload
PLFM-5908
Can no longer submit to evaluation queues without any quota
PLFM-6112
Better error message when bad characters prevent uploading data to new table from a csv file
PLFM-4916
STS Move restrictions
PLFM-6007
Include md5 in file view default columns
PLFM-5651
multiple invites to the same user
PLFM-6104
294-QUERY-queue-oldest-message-exceed-time alarm triggered twice on Jan. 28
PLFM-6075
file view performance is slow and made slower by facets
PLFM-5986
Allow migration of threads between projects
PLFM-4217
Delete index tables for multi-value LIST columns when a table is deleted
PLFM-6001
Disallow swapping to/from a multivalue LIST column type in Tables (not Entity Views)
PLFM-6109
In Tables (not Views) setting a table that was previously single value columnType to a LIST does not wrap it in a list
PLFM-6002
Multiple Values in Annotations
PLFM-5390
Migrate prod stack to new VPC
PLFM-6042
Stack trace for POST /externalfilehandle/googlecloud around 2020/02/01 (stack-295)
PLFM-6092
Problems downloading GDC files
PLFM-6101
203 500 statuses in the past week for POST /entity/#/table/download/csv/async/start
PLFM-6027
Table Facet "passed reset-token was invalid"
PLFM-6058
View column suggestions need to take into account multi-value lists and then suggest the appropriate column type
PLFM-6013
allow versioned entity in a table column
PLFM-5433
AddToDownloadList should contain versioned entities
PLFM-6107
Restrict entity acl content
PLFM-4376
Look at slow POST /repo/v1/column/batch on 1/30 stack-294
PLFM-6078
Docker access denied when pushing updated image to deleted repository
PLFM-6106
Handle empty string in ProjectSettingsManagerImpl.validateS3BucketOwnership()
PLFM-6057
issue 1 of 36

cryptic PreparedStatementCallback error when accessing project view

Description

Access to the file view syn10142562 is broken.
The web client gives a truncated error message:
PreparedStatementCallback; SQL [INSERT INTO T10142562(ROW_ID, ROW_VERSION, ROW_ETAG, ROW_BENEFACTOR, C81721, C85405, C81968, C81969, C85331, C82660, C85820, C85821, C81722, C81728, C81764, C85822, C85823, C85824, C85825, C111505, C111506, C111507) SELECT R.ID, MAX(R.CURRENT_VERSION) AS CURRENT_VERSION, MAX(R.ETAG) AS ETAG, MAX(R.BENEFACTOR_ID) AS BENEFACTOR_ID, MAX(R.ID) AS ID, MAX(IF(A.ANNO_KEY ='institution', A.STRING_VALUE, NULL)) AS C85405, MAX(IF(A.ANNO_KEY ='consortium', A.STRING_VALUE, NULL)) AS C81968, MAX(IF(A.ANNO_KEY ='grantType', A.STRING_VALUE, NULL)) AS C81969, MAX(IF(A.ANNO_KEY ='grantNumber', A.STRING_VALUE, NULL)) AS C85331, MAX(IF(A.ANNO_KEY ='fundingAgency', A.STRING_VALUE, NULL)) AS C82660, MAX(IF(A.ANNO_KEY ='teamMembersProfileId', A.STRING_VALUE, NULL)) AS C85820, MAX(IF(A.ANNO_KEY ='teamProfileId', A.LONG_VALUE, NULL)) AS C85821, MAX(R.NAME) AS NAME, MAX(R.TYPE) AS TYPE, MAX(R.MODIFIED_ON) AS MODIFIED_ON, MAX(I..

This code reproduces the problem (with an error message that is still truncated):
view.id <- "syn10142562"
tbl <- synTableQuery(sprintf("select * from %s", view.id))

Environment

None

Assignee

John Hill

Reporter

Brian White

Labels

None

Validator

Brian White

Development Area

None

Release Version History

None

Priority

Major
Configure