Technical Solutions
Troubleshooting Break-Fix Issues
-
After setting up TLS on AtScale HA, modeler.stdout file keeps recording "http: TLS handshake error from <IP_address>:<port>: remote error: tls: bad certificate" frequently
SYMPTOM: After setting up TLS on AtScale HA, modeler.stdout file keeps recording "http: TLS handshake error from <IP_address>:<port>: remote error: tls: bad certificate" frequently...
-
Aggregate rebuild is not being triggered by Rest API or through Design Center UI → Aggregate → Rebuild aggregates or HDFS File Location change
INFORMATION COLLECTED Summary zip to check any errors or events reported in engine.log during the timestamp of manually triggering the aggregate build from the UI; mostly, nothing ...
-
An Aggregate/UDA is continuously attempting to build after failing with: "Timed out after total timeout [5 hours], queued for [None], with message [Timed out by master timeout control]"
SYMPTOMS The following failure message appears in the engine or debug logs or within AtScale as the result of a batch or query failure: Timed out after total timeout [5 hours], que...
-
AtScale Fails to Sync Users Due to Timeout Issues with LDAPs Configured in the Environment
SYMPTOM If AtScale is syncing a group with more than 50 users, it can timeout since the default timeout is set to 5 seconds. RESOLUTION While no specific flag/configuration in AtSc...
-
AtScale Mitigation Procedures for CVE-2021-44228
Summary To remediate the potential impact of the Apache Security issue raised by CVE-2021-44228 affecting Apache Log4j2 versions 2.0 through 2.14.1 (Note: log4j1.X is not affected)...
-
Ensure there are sufficient connections in the JDBC pool for concurrent aggregate settings
SYMPTOM Settings within AtScale can affect one another. One of these instances is the JDBC connection settings and the aggregate creation concurrency settings. There must be suffic...
-
Error after TLS/SSL implementation: Caused by: java.security.cert.CertificateException: No subject alternative names matching IP address <xx.xxx.xxx.xxx> found
SYMPTOM Enabling TLS/SSL security causes the engine to fail to connect with an error as follows: 2017-08-01 10:03:43,107 ERROR [atscale-akka.acto...
-
HiveAccessControlException Permission Denied: user [atscale] does not have [DROP] privilege on [hll_aggregate]
SYMPTOM After enabling the following two properties, "View Raw Table Data" or other querying activities from Design Center failed. connection.overrideUdfSchema.enabled = true conne...
-
In Tableau Desktop, sometimes using a filter causes an error "This query would contain joins or aggregations that are not allowed" in AtScale Design Center's "Queries" page.
SYMPTOM In Tableau Desktop, a filter sometimes causes an error "This query would contain joins or aggregations that are not allowed" in AtScale Design Center's "Queries" page. ROOT...
-
Logs show error "java.lang.OutOfMemoryError:unable to create new native thread"
SYMPTOM When running many processes, each with many threads, as the AtScale or runtime user, the error "java.lang.OutOfMemoryError:unable to create new native thread" may be seen u...
-
Modeler_backend service keeps restarting after upgrade to 2023.4.1
SYMPTOM:After upgrading the AtScale version 2023.4.1, We could see the modeler_backend service is keep restarting and getting below errors in the modeller_backend.stdout file (n...
-
Pointing existing Tableau Server reports at AtScale cubes causes slow report performance
SYMPTOMS Changing existing data sources within existing Tableau Server reports to point to published cubes from AtScale can cause the reports to run slowly. Reduced performance be...
-
Postgres shows IPv6 socket message in logs
SYMPTOM In specific environments, the following message can be seen in Postgres logs: 2017-05-10 19:24:30 UTC [143596]: [1-1] user=,db=,app=,client= LOG: could not create IPv6 soc...
-
Running Tableau Report Causes the Following Error in the Design Center: Error during query planning: Expected two arguments for a binary operator
SYMPTOM Running a particular report from Tableau causes the following error in the Design Center: Error during query planning: Expected two arguments for a binary operator The en...
-
Running Tableau Report Causes the Following Error in the Design Center: Error during query planning: Expected two arguments for a binary operator URL Name
SYMPTOM Running a particular report from Tableau causes the following error in the Design Center:Error during query planning: Expected two arguments for a binary operatorAnd the en...
-
The Correct Way to Model Multiple Hierarchies Under the Same Dimension within AtScale Cube
RESOLUTION AtScale design center allows cube modelers to implement multiple hierarchies under a single dimension. When implementing multiple hierarchies, users must ensure each hi...
-
There are more system Aggregates present than the value the retention limit is set to
SYMPTOM Current System-Defined Aggregate Count exceeds way more than the limit (Retention Limit + Excess Amount Allowed) set. DESCRIPTION Usually, the total number of System-Defi...
-
Unable to load CA certificates while connecting with Tableau using an AtScale-generated .tds file
Symptom When connecting with Tableau using an AtScale-generated .tds file, the connection fails with the following error message: Error “[Cloudera][DriverSupport] (1140) Unable to ...
-
Unable to open client transport with JDBC Uri: jdbc:hive2://...: null: org.apache.thrift.transport.TTransportException
SYMPTOM After enabling SSL / TLS on HiveServer2, AtScale can no longer communicate with Hive.The Hadoop cluster uses Kerberos, and the Hive version is 1.1 or 1.2. EXAMPLES Could n...
-
When using Excel to connect to an AtScale cube, an error prompt occurs "Errors in the ole db provider. An error occurred while loading the connection dialog box", preventing any connections to the cube.
SYMPTOM An error prompt from Excel when connecting to an AtScale cube occurs, resembling Errors in the OLE DB provider. An error occurred while loading the connection dialog box....
-
Where Clause is Missing in Outbound Queries on Dimension-Only Queries
In the case of dimension-only queries, users observe that the 'where clause' is completely missing on the outbound queries generated by the AtScale engine like in the below example...
-
While connecting to AtScale cube from Excel, users are getting "No data fields are available in the OLAP cube" error.
SYMPTOM While connecting to the AtScale cube from Excel, users get the "No data fields are available in the OLAP cube" error. RESOLUTION This error occurs when you try to connect ...
-
With a Small Cube (Less than 20 elements), when Clicking "Update Now" or "View Data" from Tableau or Excel, There's a Planning Errors
SYMPTOM With a small cube (Less than 20 elements), even though Drill Through Sets are defined, when clicking "Update Now" or "View Data" from Tableau or Excel, Drill Through sets a...