User try to run the Cube and he got these following Errors and also he stated that he is not able to modify or update the cube and it is still showing the old metadata modified date.
ERROR: Unable to resolve host name specified by SERVER=.
ERROR: Unable to resolve host name specified by SERVER=.
ERROR: Libref dnbtstf failed to assign from logical server.
ERROR: Libref dnbtstf3 failed to assign from logical server.
WARNING: The PATH option will be ignored; it is only valid when creating a new cube.
NOTE: The cube registration was found.
ERROR: File was not found. File =...SalesCube/RDM_Sales_Cube/gen0000/RDM_Sales_Cube.cube.
System Error Code = 2.
ERROR: The file was not found: ...SalesCube/RDM_Sales_Cube/gen0000/RDM_Sales_Cube.cube.
ERROR: The cube file cannot be opened.
ERROR: An internal cube file could not be found. The physical files for this cube might have been deleted.
NOTE: The cube registration was deleted.
ERROR: The physical cube cannot be deleted.
WARNING: Some physical files either did not exist or could not be removed at this time.
NOTE: Cube "RDM_Sales_Cube" was deleted.
NOTE: PROCEDURE OLAP used (Total process time):
real time 1.59 seconds
cpu time 0.03 seconds
I just want to clarify whether this is falling under metadata issue or this is something related coding or they way OLAP cube works.?
I think you want to start with the first error:
ERROR: Unable to resolve host name specified by SERVER=.
Looks like a SERVER was specified incorrectly and possibly not at all.
Hello @AravindPalanichamy,
it seems very much to me as you have got a corrupted cube in the metadata.
To fix it might be possible, although it requires in-depth knowledge of the metadata design and some amount of time.
If it is possible to re-create the cube as a new one, I would strongly go for that option.
User tried that and issue here is Metadata date is not modified. Its still showing the old date.
Hi
as mentioned, rebuilding might be the best way to go.
You might already be familiar with this info? As future ref for renaming cubes:
Thanks
Anja
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.