topic Re: SAS OLAP Cube Issue in Administration and Deployment

SAS OLAP Cube Issue

AravindPalanichamy — Wed, 18 Jan 2017 15:31:05 GMT

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.?

Re: SAS OLAP Cube Issue

ballardw — Wed, 18 Jan 2017 15:39:46 GMT

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.

Re: SAS OLAP Cube Issue

AravindPalanichamy — Wed, 18 Jan 2017 18:41:24 GMT

Please ignore the server part as he mentioned correct server names and port details.

I have just got an update that this user renamed the cube. But in the error it was still checking for the old name.

Re: SAS OLAP Cube Issue

JuanS_OCS — Thu, 19 Jan 2017 13:28:08 GMT

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.

Re: SAS OLAP Cube Issue

AravindPalanichamy — Thu, 19 Jan 2017 13:36:18 GMT

User tried that and issue here is Metadata date is not modified. Its still showing the old date.

Re: SAS OLAP Cube Issue

anja — Thu, 19 Jan 2017 14:57:02 GMT

as mentioned, rebuilding might be the best way to go.

You might already be familiar with this info? As future ref for renaming cubes:

http://support.sas.com/documentation/cdl/en/olapug/69844/HTML/default/viewer.htm#n1hehwp07vbxf1n18pa1q3h510q6.htm

Thanks

Anja