topic Anomaly Visualizing Reports in SAS Visual Analytics

Anomaly Visualizing Reports

Esma_Aj — Tue, 13 Feb 2024 13:29:53 GMT

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.

Re: Anomaly Visualizing Reports

TSBruce — Tue, 13 Feb 2024 13:35:37 GMT

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?

Re: Anomaly Visualizing Reports

Esma_Aj — Wed, 14 Feb 2024 06:22:34 GMT

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.

Re: Anomaly Visualizing Reports

TSBruce — Wed, 14 Feb 2024 12:33:57 GMT

I would suggest opening a Technical Support Case for this issue. In the case, you may want to provide the following:

The Data Builder log covering the time of the failed execution of you "Load Tables" code. Default location would be similar to /SAS-configuration-directory/Lev1/Web/Logs/SASServerX_X/SASVisualDataBuilder7.x.log
Assuming you are opening the report in VA Viewer, I would include the transport services log (/SAS-configuration-directory/Lev1/Web/Logs/SASServerX_X/SASVisualAnalyticsTransport7.x.log) and the VA Viewerlog (/SAS-configuration-directory/Lev1/Web/Logs/SASServerX_X/SASVisualAnalyticsViewer7.x.log). Please specify the date/time/user performing the test.

Re: Anomaly Visualizing Reports

Esma_Aj — Thu, 15 Feb 2024 09:11:30 GMT

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 ?