Grain Does Not Exist When Deleting?

Dan Rosen

I'm getting this error when trying to validate a delete script: Data source [Grain(PO Detail_Snapshot)] does not exist

I'm using the same syntax I always do when deleting, basically deleting the dimension and fact tables:

COMPLETE
DELETE FROM [Level(Purchase Order Snapshot.Purchase Order Snapshot)]
WHERE 1=1

DELETE FROM [Grain(PO Detail_Snapshot)]
WHERE 1=1
END COMPLETE

PO Detail_Snapshot is 100% the name of the script that writes the fact table. Any idea why this isn't working?

Thanks

Find more posts tagged with

Comments

Legacy Contributor

Hi Dan Rosen,

The syntax is correct. EIther check the table name or share the error message which might be helpful

Dan Rosen

as stated, the error message is "Data source [Grain(PO Detail_Snapshot)] does not exist". not sure what else I can tell from that

Legacy Contributor

Dan,

Even though it's erroring on validate, I suggest saving it and publishing it. If it fails, you may get better info in the publish log than you do just by validating.

- Cindy

Dan Rosen

Thanks Cindy, I'll probably test that out and see what I can find

Dan Rosen

doesn't look like I got too much more info unfortunately:

Dan Rosen

Nevermind, I found the issue, a blank space I didn't know existed in my script name

Copyright © 2025 Infor. All rights reserved.