Announcement

**Isomorphic** · 21 Sep 2015, 12:56

Just a quick note to reassure you this is being looked at.
We'll follow up when we have this resolved.

Regards
Isomorphic Software

**Isomorphic** · 7 Oct 2015, 21:24

Sorry for the delay, this is fixed now and will be available in the next (2015-10-08) nightly build.

**Blama** · 13 Oct 2015, 16:22

Hi Isomorphic,

your fix also disabled normal view/download operations because the data column is no longer in the SELECT-list - see the log and especially the bold parts. Currently the binary field function is unusable! Tested using v10.0p_2015-10-08/PowerEdition Deployment.

Code:

=== 2015-10-14 02:19:53,518 [c-14] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        ID:15,
        download_fieldname:"DATA",
        download_filename:"Testdata.csv"
    },
    operationConfig:{
        dataSource:"T_ATTACHMENT",
        repo:null,
        operationType:"downloadFile",
        textMatchStyle:"exact"
    },
    appID:"builtinApplication",
    operation:"T_ATTACHMENT_downloadFile",
    oldValues:{
        ID:15,
        download_fieldname:"DATA",
        download_filename:"Testdata.csv"
    }
}
=== 2015-10-14 02:19:53,518 [c-14] INFO  LMSIDACall - Performing 1 operation(s)
=== 2015-10-14 02:19:53,518 [c-14] DEBUG AppBase - [builtinApplication.T_ATTACHMENT_downloadFile] No userTypes defined, allowing anyone access to all operations for this application
=== 2015-10-14 02:19:53,518 [c-14] DEBUG AppBase - [builtinApplication.T_ATTACHMENT_downloadFile] No public zero-argument method named '_T_ATTACHMENT_downloadFile' found, performing generic datasource operation
=== 2015-10-14 02:19:53,520 [c-14] DEBUG AppBase - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
=== 2015-10-14 02:19:53,520 [c-14] DEBUG AppBase - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
=== 2015-10-14 02:19:53,520 [c-14] INFO  SQLDataSource - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] Performing fetch operation with
    criteria: {criteria:[{value:15,fieldName:"ID",operator:"equals"},{value:"DATA",fieldName:"download_fieldname",operator:"iEquals"},{value:"Testdata.csv",fieldName:"download_filename",operator:"iEquals"},{value:15,fieldName:"TENANT_ID",operator:"equals"},{value:15,fieldName:"CREATED_BY_TENANT_ID",operator:"equals"},{value:15,fieldName:"MODIFIED_BY_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"}    values: {criteria:[{value:15,fieldName:"ID",operator:"equals"},{value:"DATA",fieldName:"download_fieldname",operator:"iEquals"},{value:"Testdata.csv",fieldName:"download_filename",operator:"iEquals"},{value:15,fieldName:"TENANT_ID",operator:"equals"},{value:15,fieldName:"CREATED_BY_TENANT_ID",operator:"equals"},{value:15,fieldName:"MODIFIED_BY_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"}
=== 2015-10-14 02:19:53,520 [c-14] INFO  SQLDataSource - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause$defaultAnsiJoinClause WHERE $defaultWhereClause
=== 2015-10-14 02:19:53,521 [c-14] INFO  SQLDataSource - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] 29: Executing SQL query on 'Oracle': SELECT T_ATTACHMENT.ID, T_ATTACHMENT.TENANT_ID, T_ATTACHMENT.CREATED_BY, T_ATTACHMENT.CREATED_AT, T_ATTACHMENT.MODIFIED_BY, T_ATTACHMENT.MODIFIED_AT, T_ATTACHMENT.TITLE, T_ATTACHMENT.LEAD_ID, T_ATTACHMENT.DETAIL_ID, T_ATTACHMENT.DATA_FILENAME, T_ATTACHMENT.DATA_FILESIZE, USER_CREATED_BY.FULLNAME_INITIALS_GIVENNAME AS CREATED_BY_NAME, USER_CREATED_BY.FULLNAME_LEGALENTITYNAME AS CREATED_BY_NAME_TOOLTIP, USER_MODIFIED_BY.FULLNAME_INITIALS_GIVENNAME AS MODIFIED_BY_NAME, USER_MODIFIED_BY.FULLNAME_LEGALENTITYNAME AS MODIFIED_BY_NAME_TOOLTIP, USER_CREATED_BY.TENANT_ID AS CREATED_BY_TENANT_ID, USER_MODIFIED_BY.TENANT_ID AS MODIFIED_BY_TENANT_ID FROM T_ATTACHMENT JOIN MV_USER_DATA USER_CREATED_BY ON T_ATTACHMENT.CREATED_BY = USER_CREATED_BY.ID JOIN MV_USER_DATA USER_MODIFIED_BY ON T_ATTACHMENT.MODIFIED_BY = USER_MODIFIED_BY.ID WHERE ((T_ATTACHMENT.ID = 15 AND T_ATTACHMENT.ID IS NOT NULL) AND '1'='1' AND '1'='1' AND (T_ATTACHMENT.TENANT_ID = 15 AND T_ATTACHMENT.TENANT_ID IS NOT NULL) AND (USER_CREATED_BY.TENANT_ID = 15 AND USER_CREATED_BY.TENANT_ID IS NOT NULL) AND (USER_MODIFIED_BY.TENANT_ID = 15 AND USER_MODIFIED_BY.TENANT_ID IS NOT NULL))
=== 2015-10-14 02:19:53,521 [c-14] DEBUG SQLConnectionManager - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] Borrowed connection '1900167388'
=== 2015-10-14 02:19:53,521 [c-14] DEBUG SQLTransaction - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] Started new Oracle transaction "1900167388"
=== 2015-10-14 02:19:53,521 [c-14] DEBUG SQLDriver - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] About to execute SQL query in 'Oracle' using connection '1900167388'
=== 2015-10-14 02:19:53,521 [c-14] INFO  SQLDriver - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] Executing SQL query on 'Oracle': SELECT T_ATTACHMENT.ID, T_ATTACHMENT.TENANT_ID, T_ATTACHMENT.CREATED_BY, T_ATTACHMENT.CREATED_AT, T_ATTACHMENT.MODIFIED_BY, T_ATTACHMENT.MODIFIED_AT, T_ATTACHMENT.TITLE, T_ATTACHMENT.LEAD_ID, T_ATTACHMENT.DETAIL_ID, T_ATTACHMENT.DATA_FILENAME, T_ATTACHMENT.DATA_FILESIZE, USER_CREATED_BY.FULLNAME_INITIALS_GIVENNAME AS CREATED_BY_NAME, USER_CREATED_BY.FULLNAME_LEGALENTITYNAME AS CREATED_BY_NAME_TOOLTIP, USER_MODIFIED_BY.FULLNAME_INITIALS_GIVENNAME AS MODIFIED_BY_NAME, USER_MODIFIED_BY.FULLNAME_LEGALENTITYNAME AS MODIFIED_BY_NAME_TOOLTIP, USER_CREATED_BY.TENANT_ID AS CREATED_BY_TENANT_ID, USER_MODIFIED_BY.TENANT_ID AS MODIFIED_BY_TENANT_ID FROM T_ATTACHMENT JOIN MV_USER_DATA USER_CREATED_BY ON T_ATTACHMENT.CREATED_BY = USER_CREATED_BY.ID JOIN MV_USER_DATA USER_MODIFIED_BY ON T_ATTACHMENT.MODIFIED_BY = USER_MODIFIED_BY.ID WHERE ((T_ATTACHMENT.ID = 15 AND T_ATTACHMENT.ID IS NOT NULL) AND '1'='1' AND '1'='1' AND (T_ATTACHMENT.TENANT_ID = 15 AND T_ATTACHMENT.TENANT_ID IS NOT NULL) AND (USER_CREATED_BY.TENANT_ID = 15 AND USER_CREATED_BY.TENANT_ID IS NOT NULL) AND (USER_MODIFIED_BY.TENANT_ID = 15 AND USER_MODIFIED_BY.TENANT_ID IS NOT NULL))
=== 2015-10-14 02:19:53,522 [c-14] INFO  DSResponse - [builtinApplication.T_ATTACHMENT_downloadFile, builtinApplication.null] DSResponse: List with 1 items
=== 2015-10-14 02:19:53,522 [c-14] INFO  DSResponse - [builtinApplication.T_ATTACHMENT_downloadFile] DSResponse: Map with 16 keys
[B]=== 2015-10-14 02:19:53,522 [c-14] WARN  RPCManager - dsResponse.getData().get("DATA") returned null when we were expecting an InputStream, Byte[] or byte[]. Can't continue.[/B]
=== 2015-10-14 02:19:53,522 [c-14] DEBUG SQLTransaction - getConnection() found transactional connection for Oracle with hashcode "1900167388"
=== 2015-10-14 02:19:53,522 [c-14] DEBUG SQLTransaction - Ending Oracle transaction "1900167388"
=== 2015-10-14 02:19:53,522 [c-14] DEBUG SQLConnectionManager - About to close connection with hashcode "1900167388"
=== 2015-10-14 02:19:53,523 [c-14] DEBUG SQLTransaction - getConnection() found transactional connection for Oracle (connection is null)

This is an important one for me.

Best regards
Blama

**Isomorphic** · 15 Oct 2015, 09:53

Apologies, this is fixed now and will be available for download in the next (2015-10-16) nightly build. Please let us know how it worked for you.

**Blama** · 9 Apr 2016, 14:49

Hi Isomorphic,

this is working as expected, thank you.

Best regards
Blama

Announcement

Minor bug: cacheSync & normal fetch request binary-field data although it isn't sent

Comment

Comment

Comment

Comment

Comment