No data is found in any of the Platform Analytics warehouse table in Strategy 2019 Update 2 on Linux. For example, table access_transactions is empty.
When performing a manual health check with Platform Analytics Health Check Utility on Platform Analytics, the below error occurrs in
platform-analytics-consumer.err.
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'metadata_db_connection' at row 1
from Kapil to everyone:
ment.executeBatch(NewProxyPreparedStatement.java:1135)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:123)
... 26 more
Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'metadata_db_connection' at row 1
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716)
... 30 more (edited)
This is a known issue with Strategy 2019.
This issue has been addressed in Strategy 2020. Upgrade to Strategy 2020 or later versions to take advantage of this fix.
Shorten the repository_connection_string to be within 255 characters.
IsSessionStats:
./kafka-console-consumer.sh --bootstrap-server localhost:9092 --topic Mstr.PlatformAnalytics.IsSessionStats --from-beginning
The repository_connection_string is the string highlighted below and counts over 300 characters.
xxx","owid":"xxx","n":"Reporting Date","vwm":0,"locale":1033,"des":"","abbreviation":"","stp":3072,"ext_type":0,"parent_id":"xxx","icp":"","hidden":0,"sta":0,"ct":"2019-07-03T04:30:35.182-0000","mdt":"2020-06-17T17:03:10.822-0000", "comments":[], "dependents":[{"object_id":"45C11FA478E745FEA08D781CEA190FE5","tp":21},{"object_id":"6674291911E8FC2542CC0080EF75D6D7","tp":26},{"object_id":"A6432AC3494C8BABBAC4579FF6B177C7","tp":15}],"repository_id":"757C059411E20B8F6C6600802F9707D8","repository_connection_string":"Driver=200;AlternateServers={(HostName=xxxxxxxxxxxxxx:PortNumber=1622:SN= xxxxxxxxxxxxxx)};ApplicationUsingThreads=1;EnableNCharSupport=1;host= xxxxxxxxxxxxxx;IANAAppCodePage=111;port=1622;ServiceName= xxxxxxxxxxxxxx;UID=xxx;"
odbc.inifile by removing alternate server or replace HostName with IP address.
[Metadata_DSN] HostName= xxxxxxxxxxxxxx PortNumber=1622 ServiceName= xxxxxxxxxxxxxx AlternateServers=(HostName= xxxxxxxxxxxxxx) Driver=/uat/edm/software/MicroStrategy/Strategy11X/install/lib/MYoraXX.so Description=Strategy ODBC Driver for Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EnableNcharSupport=1 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 IgnoreODBCTimeStampLiteral=1 LocalTimeZoneOffset= LockTimeOut=-1 ProcedureRetResults=0 UseCurrentSchema=1 IANAAppCodePage=111b
After remove the alternate servers, the string counts less than 200 characters. Driver=200;ApplicationUsingThreads=1;EnableNCharSupport=1;;IANAAppCodePage=111;port=1622;ServiceName= xxxxxxxxxxxxxx;UID= xxxxxxxxxxxxxx;