Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Unable to prepare the data in Data preparation.

Reply
Contributor
Posts: 25

Unable to prepare the data in Data preparation.

Hi,

I am trying to prepare a data in data preparation SAS VA 9.4. When I am loading the table and running it, the output is generated but when I am trying to view it is throwing the below error.

I have given all the permissions to the user (Admin user). 

 

 Untitled.png

(mx.messaging.messages::ErrorMessage)#0
body = (null)
clientId = "15587B13-A609-7AC7-B5DC-B7CC23722B03"
correlationId = "D7E4F673-F200-1129-D0AE-9123D4DF7DDE"
destination = "ResultSetViewService"
extendedData = (Object)#1
instance = "DataViewerException"
trace = "Failed to create the result set.
java.lang.Thread.run(Thread.java:748)"
faultCode = "Server.Processing"
faultDetail = (null)
faultString = "Failed to create the result set."
headers = (Object)#2
messageId = "1558C28B-8C0E-E5B3-4941-69D334745423"
rootCause = (Object)#3
additionalInfo = "SELECT * FROM LASRLIB.OutputTable"
cause = (Object)#4
cause = (Object)#5
cause = (Object)#6
cause = (null)
ErrorText = "SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
localizedMessage = "SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
message = "SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
suppressed = (Array)#7
errorCode = 138
localizedMessage = "Unable to execute query: SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
message = "Unable to execute query: SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
nextException = (null)
SQLState = "42000"
suppressed = (Array)#7
exceptionType = (Object)#8
message = "com.sas.rio.MVASQLException: Unable to execute query: SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
localizedMessage = "com.sas.rio.MVASQLException: Unable to execute query: SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
message = "com.sas.rio.MVASQLException: Unable to execute query: SQL passthru expression contained these errors: ERROR: Metadata Server denied access to operation.... NOTE: The table LASRLIB.OUTPUTTABLE does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.... ERROR: File LASRLIB.OUTPUTTABLE.DATA does not exist."
suppressed = (Array)#7
exceptionType = "com.sas.iom.SASIOMDefs.GenericError"
localizedMessage = "Failed to create the result set."
message = "Failed to create the result set."
summary = "Failed to create the result set."
suppressed = (Array)#7
timestamp = 1527148442188
timeToLive = 0

Ask a Question
Discussion stats
  • 0 replies
  • 125 views
  • 0 likes
  • 1 in conversation