Hello,
When I log into my SAS VA administrator account, I have a problem viewing my reports.
At Querries folder, I have executed the SAS code for manual loading of the Querry "Load Tables" to load the tables of my cube but I receive an error message indicating that my request cannot be executed.
When I go to my transport log file, an error indicates that the source of my data cannot be found. The same error is mentionned at the BatchServer's logs for the job flow automatically scheduled.
N.B : my reports were visible the day before, but the next day, despite the fact that I didn't touch anything, they became invisible.
It may be helpful to get more information on the steps you are taking. Can you provide screenshots showing the steps you take to execute the "Load Tables" query? Also, can you provide the full error message from the logs where you see messages?
I navigate to my file where you can find the folder named "Commerce extérieur" which is a Cube. To load the "Commerce exterieur" tables, I run the "Load tables" query, and the error message in the photo appears.
I would suggest opening a Technical Support Case for this issue. In the case, you may want to provide the following:
A the SASVisualDataBuilder7.5 log i have the following error :
2024-02-14 11:33:13,778 [tomcat-http--22] ERROR [ST-37146-kdYUPo1N9WFd7PjoUDY9eMeK63k-SRVPREPRODSAS:PREPROD ADMIN] com.sas.dp.sasui.common.proxy.service.ServiceProxy - failed to run executeProxyOperation
java.lang.reflect.InvocationTargetException: null
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
at com.sas.dp.sasui.common.proxy.service.ServiceProxy.executeProxyOperation(ServiceProxy.java:255) ~[sas.dp.commons.jar:752000.0.0.20221221190000_d4dbcom9g]
at com.sas.dp.sasui.common.proxy.ServiceProxyController.runProxyAction(ServiceProxyController.java:55) ~[sas.dp.commons.jar:752000.0.0.20221221190000_d4dbcom9g]
at jdk.internal.reflect.GeneratedMethodAccessor923.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] ....
A the SASVisualAnalyticsTransport7.5 log i have the following error :
BIDATA ERROR [tomcat-http--2] 2024-02-14T10:29:30,704 [PT-38974-jGM49OptL4jj9eJNWlX-si-Ehh4-SRVPREPRODSAS:ADMIN] com.sas.bidata.error.DataErrorHandler - dataSourceNotFound
com.sas.lasr.LASRTableNotFoundException: ERROR: The table VAPUBLIC.CUBE_CONTROLE could not be located in the LASR Analytic Server image.
at com.sas.lasr.LASRClient.checkForErrors(LASRClient.java:3023) ~[sas.lasr.jar:911000.0.0.20221221190000_d421lasr1]...
I'll contact the technical support but did you faced please one of these problems before ?
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.