Solved

Deleting a record in dataset

  • 5 January 2022
  • 3 replies
  • 26 views

I am trying to delete 1 record and I have run into some problem. When trying to delete a record in the Spending dataset where the order no is = 2021_6734. According to the documentation the query should look something like this to delete the facts:
https://help.gooddata.com/pages/viewpage.action?pageId=86796761

 

DELETE FROM {attr.spending.factsof} WHERE {attr.spending.no} = "2021_6734";


When I am running the delete statement I am getting the following error: 

"error" : {

"component" : "DJG",

"errorClass" : "GDC::Exception::User",

"message" : "Object \"%s\" doesn't exist.",

"parameters" : [

"attr.spending.factsof"

],

"requestId" : "hjUDGKYxIf3OuhS:7txqnamxk997mgy0"

}

}

 

Which object does not exist? I am not sure what the issue is there? 

icon

Best answer by Michael Ullock 5 January 2022, 15:36

View original

3 replies

Userlevel 1

Hi Samantha,

thanks for reaching out, we'll be happy to help with this.

From our logs, we can see the same error as you have reported:

exception_msg="Object \"attr.spending.factsof\" doesn't exist." project="byanfpis31ycd38qpyer1yg3cy8ng5ne" auth_user="4783ncv55abe88e3b87c32a48c06d4" request_id=hjUDGKYxIf3OuhS:7txqnamxk997mgy0

As the errors states, you're trying to delete records from an object that doesn't exist: attr.spending.factsof

Please refer to the following article that will help you find the correct object identifier:
https://help.gooddata.com/pages/viewpage.action?pageId=86796821

Best regards, 

Hi Michael,

I have the same problem as Samantha, I find the identifiers through Gray Pages so it have to work (I have an Admin role) But it doesn't help. I need to delete some data from the dataset by date (old data)  used the condition

``` DELETE FROM {attr._identifier of the dataset_.factsof} WHERE {_identifier of the date dataset_.date.yyyymmdd} between "2021-11-01" AND "2021-11-30";``` 

 

Please can you help me with it?

 

With respect,

Daria

I found the solve for my issue. In this table we have a PK jsou we don't have any factsof attribute. So I used a  ID attribute and  it was solved. 

 

Daria

Reply