[DOCS-9242] Documentation for BI-639: Support read only views Created: 31/Oct/16  Updated: 11/Jan/17  Resolved: 09/Nov/16

Status: Closed
Project: Documentation
Component/s: BI Connector
Affects Version/s: None
Fix Version/s: 01112017-cleanup

Type: Task Priority: Major - P3
Reporter: Emily Hall Assignee: Andrew Aldridge
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
Participants:
Days since reply: 7 years, 15 weeks, 2 days ago

 Description   

Engineering Ticket Description:

Currently mongodrdl exits with an error when it encounters a read-only view in MongoDB 3.4:

$ ./drdl --verbose=5 -d viewtest -c view1
2016-09-13T17:05:43.530-0400	Exporting tables for "viewtest.view1".
2016-09-13T17:05:43.532-0400	Including sample: [{_id 1} {x str}]
2016-09-13T17:05:43.532-0400	Including sample: [{_id 2} {x str2}]
2016-09-13T17:05:43.532-0400	Failed: Namespace viewtest.view1 is a view, not a collection

This is likely occurring when mongodrdl attempts to load the indexes for the view. You can see in the shell that MongoDB treats that as an error:

> db.view1.getIndexes()
2016-09-13T17:24:19.518-0400 E QUERY    [thread1] Error: listIndexes failed: {
	"ok" : 0,
	"errmsg" : "Namespace viewtest.view1 is a view, not a collection",
	"code" : 166
}


Generated at Thu Feb 08 07:57:53 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.