T75-2015: Structures are no longer retrived after upgrading to BIOVIA Insight 2.6
Insight
The BIOVIA Foundation query service version 9.5.200 contains a defect where it is not possible to retrieve data from across DataSourceConnector. BIOVIA Foundation query service version 9.5.200 may be obtained by installing BIOVIA Foundation 9.5 SP1 or by installing Insight 2.6. This defect is not present in BIOVIA Foundation query service 9.5.100 which is present BIOVIA Foundation 9.5 or Insight 2.5.
Both of the following condtions must be met for the error to occur:
1) The primary integrating data source (IDS) must contain a DataSourceConnector.
2) The secondary IDS linked to the primary IDS through the DataSourceConnector must either have a PivotConnector as the RootConnector or have a OneToOnePivotConnector joined to the RootConnector.
The default IDS's for Chemical Registration and Biological Registration meet the second condition. If either of of these IDS's are linked to another IDS through a DataSourceConnector and you are using BIOVIA Foundation 9.5 SP1 or Insight 2.6, searching for data from those data sources will fail.
Resolution:
BIOVIA Foundation 9.5 SP1 HF1 has been released to correct the defect. If you believe you are seeing this defect, please contact BIOVIA Support to obtain BIOVIA Foundation 9.5 SP1 HF1.
Error Mesage:
Transform initialization failed: Error: 1
Category: FlattenRecordSet
Description:
(1) Unable to initialize tree of recordsets (Severe)
Error: 2
Category: null
Description:
(2) Error getting data for CHEMREG_IDS ()
Error: 3
Category: IDSRecordSet
Description:
(3) Error retrieving data from connector chemreg_ids (Severe)
Error: 4
Category: BatchRetrievalConnector
Description:
(1) ()
Exception type: java.lang.NullPointerException
System.Exception: Transform initialization failed: Error: 1
Category: FlattenRecordSet
Description:
(1) Unable to initialize tree of recordsets (Severe)
Error: 2
Category: null
Description:
(2) Error getting data for CHEMREG_IDS ()
Error: 3
Category: IDSRecordSet
Description:
(3) Error retrieving data from connector chemreg_ids (Severe)
Error: 4
Category: BatchRetrievalConnector
Description:
(1) ()
Exception type: java.lang.NullPointerException
at Accelrys.DSBuilder.QueryServiceClient.QSRequestHelper.SubmitHTTPPostRequest(String restUrl, String postData, String contentType, String responseType, IIsentrisSession aepSession) in c:\buildarea\dsbuilder\dsbuilder\QueryServiceClient\QS Client\QSRequestHelper.cs:line 125
at Accelrys.DSBuilder.QueryServiceClient.FlattenRecordSet.initialize(IDBRecordSet recordSet, Vector selectedFields, IDBPropertySet props) in c:\buildarea\dsbuilder\dsbuilder\QueryServiceClient\QS Client\FlattenRecordSet.cs:line 106
at DSBuilder.QueryBuilder.ResultsDialog.LoadResults(IDataSourceFactory dsf, IDBRecordSet rs, IDBDataSource ds, ArrayList selectedFields, String countMode, Int32 batchSize, IDBPropertySet props) in c:\buildarea\dsbuilder\dsbuilder\QueryBuilder\ResultsDialog.cs:line 66
at DSBuilder.QueryBuilder.QueryBuilderDialog.ExecuteButton_Click(Object sender, EventArgs e) in c:\buildarea\dsbuilder\dsbuilder\QueryBuilder\QueryBuilderDialog.cs:line 567