Hello,
We are querying the view WfAlarms (structure as given below) which has direct reference to alarmCode. When we are querying it for say 3+ months, we get the CogniteApiError, but works fine when it is 1month. This error is seen in our application deployed in production.
We expect almost 2 million of records in this view. Can you help to understand what can be done to fix this issue ? Any configuration that needs to be changed. Let me know if you need any other details.
1. Properties being queried from view - WfAlarms

Error

View:
type WfAlarms @view(version: "2") @container(indexes: [{identifier : "entityName", fields : ["entityName"], cursorable : true}, {identifier : "entityExternalId", fields : ["entityExternalId"], cursorable : true}, {identifier : "alarmFlags", fields : ["alarmFlags"], cursorable : true}, {identifier : "entityType", fields : ["entityType"], cursorable : true}, {identifier : "alarmCode", fields : ["alarmCode"], cursorable : true}, {identifier : "startDateTime", fields : ["startDateTime"], cursorable : true}, {identifier : "endDateTime", fields : ["endDateTime"], cursorable : true}]) {
entityName: String!
entityExternalId: String!
entityType: String!
startDateTime: Timestamp!
endDateTime: Timestamp!
alarmFlags: String
operationType: String
alarmCounter: Int!
ticketId: String
alarmCode: AlarmDefinition
removeAlaramForUser: JSONObject
markAsRead: JSONObject
customWorkflowAlarmMessage: String!
ssWorkflowAlarmMessage: String
relatedEntity: String
relatedEntityExternalId: String
additionalInformation: JSONObject
}
type AlarmDefinition @view(version: "1") @container(indexes: [{identifier : "alarmName", fields : ["alarmName"], cursorable : true}]) {
alarmName: String
alarmMessage: String
alarmMsgParameter: String
alarmCategory: String
alarmDescription: String
workflowCode: String
workflowName: String
alarmPriority: String
alarmCriticality: String
isAlarmTicket: String
alarmCounterToTicket: Int
alarmDataSource: String
alarmType: String
ticketAsset: String
ticketDept: String
ticketAssignedTo: String
ticketAssignedGroup: String
ticketRecommedation: String
subCategory: String
subWorkflowName: String
alarmUnifiedCode: String
alarmTypeCategory: String
alarmTypeSubCategory: String
}
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support