David Boot-Olazabal

Hi Kseniia, Thanks for elaborating on this, so we know better the impact for end users. Please proceed with creating a support case, so the issue can be closely looked into by our support team. Kind regards, David

Hi apreble, Here are a few iron python scripts related to the mail part: https://spotfired.blogspot.com/2018/04/send-email-with-pdf.html https://spotfired.blogspot.com/2014/05/sending-emails-gmail-example.html When it comes to using icons for the script, you can do so per script in the action control window (inside a text area). When you set up an Action Control, you're asked to enter the Display text, the Control type and select an action (in your case this would be the script). When you inspect the drop-down list from Control type, you can select an image, that acts as the icon. By clicking on the browse button, you can then select your image file (the home.png in the example below): Kind regards, David

Hi Kseniia, Thank you for the input file. We think this issue needs deeper investigation. Therefore we would ask you to open a support ticket via https://support.tibco.com. Our colleagues from support can then view the monitor logs to deep dive into this particular issue. You may share the ticket number with us, so we can trace it as well. To have a clear view on who's impacted, is that just you, or does this have an impact on other users as well, since you can't proceed with your analysis file? Kind regards, David

Hi Yannick, I'm not aware that you can't connect to a Community version of a data source in Spotfire. Could you tell us the data source template is that you use to connect to MySQL? And can you also share the data source template content you are using? Not sure if you know the below article, but you can find some MySQL data source templates there as well. When it comes to ODBC connections to MySQL, I see that there are other options as well (see here). Would it be possible to check: - if you can connect to MySQL via the ODBC way? - if yes, which driver did you use? - can you find the corresponding jdbc equivalent for the working ODBC driver (if not using the MySQL driver but another one) in the above mentioned article? Kind regards, David

Hi, I understand why you are a bit confused. Not sure if this got fixed in the latest version (I'm on Spotfire 14.4 HF4), but you can see that I have been able to capture the 'clicks' in my Actionlog table (the set_page LOG_ACTION is accompanied by the ActionLink value in column ARG6): My dashboard looks like this (first tab): Second tab: And repeating the same actions (clicking on the action control buttons), adds an extra set of rows in my Actionlog table (row number 3 and 4). I also manually clicked on the tabs, to give you an idea of what the information looks like, compared to the ActionLink value in ARG6 (it then says PageTabs; row number 1 and 2): So I would encourage you to test this out on your side, and see if the entries pop up in your Actionlog table as well. Kind regards, David

Hi Kseniia, Hmmm, that is strange indeed. I've asked my colleagues if they know if there is a limit of 22 symbols per column. We will let you know once we know more. Kind regards, David

Hi Kseniia, Thank you for the feedback. So, the issue is not so much with the number of values in the 'IN' clause, but more with the content of the values. I can confirm that the number of values in the 'IN' clause, will work fine in on-demand queries when larger than 1000. And as you mentions, it seems like the content (or length) is the culprit. Are there specific characters in the used column values, that could cause this behavior? Could you see what the max length of the values are and try to put a Left/Right statement around the column with the max number of characters to see if that works? I'm thinking that maybe leading or ending spaces may have an impact here. Kind regards, David

Hi apreble, Do the script has to be a javascript, or is iron python or action mods (when you're on the latest version) also an option for you? Kind regards, David

Hi Amit, Yes, this also works when using a action control button to navigate to another page. Assuming that you have activated the actionlog, you could easily check the outcome of navigating to pages through action controls in the actionlog table (directly on the database or via the user_actions dxp file in Spotfire. Kind regards, David

Hi Kseniia, I just took a quick peak into the log file. Two things were popping up. The error message you already mentioned as well as a (possible) authentication issue. I looked up the error message on our support site and found some very old references. Could you tell us on which version you are and if all the latest hotfixes have been deployed? Because in these old posts, references were made to installing/deploying the latest (client) hotfix for your version of Spotfire. Concerning the authentication issue, this is the last part of the logfile (I have tried to mask as many references to your environment as possible, such as the actual server name, your id, etc.): 2024-09-10T12:23:54,935+03:00 2024-09-10 09:23:54,935 s1102495 [Main Thread] WARN Spotfire.Dxp.Services.Http.HttpClient [(null)] - ExecuteNonSpotfireServerRequestWithRetry(https://<spotfire server name>/spotfire/oauth2/token, RequestId , User OAuth2Identity: Auth '<id>...', Refresh '<id2>...' (False), Scope 'internal.client-login', SpotfireIdentity: Kurianova Kseniia (ext) CHST (<sID>), IsAuthenticated True, time of authentication: 9/9/2024 12:23:48 PM, , en-US, en-US, <spotfire server name>::JSESSIONID=<session id>= on <spotfire server name>/spotfire, sec=True, http=True, expire=1/1/0001 12:00:00 AM, XSRF-TOKEN=<xsrf-token id> on <spotfire server name>/, sec=True, http=False, expire=1/1/0001 12:00:00 AM): Failed to make request, giving up. Status: ProtocolError, HResult: -2146233079, Response: ---. SecurityProtocol Tls, Tls11, Tls12, DefaultConnectionLimit 8, MaxServicePointIdleTime 50000 ServerCertificateValidationCallback Spotfire.Dxp.Services.Http.HttpClient.RemoteCertificateValidationCallback System.Net.WebException: The remote server returned an error: (400) Bad Request. at System.Net.HttpWebRequest.GetResponse() at Spotfire.Dxp.Services.Http.SpotfireRequest.ExecuteNonSpotfireServerRequestWithRetry(Func`1 requestCreator, RetryOptions retryOptions). I'm not sure if this is related, but it comes up right after the error message about the failing on-demand query (multiple times in fact). Does the connection to VerticaDB requires an authentication that is missed by the on-demand query perhaps? Kind regards, David

Thanks Kseniia. I'll check the logs and see if I can come up with a similar set up on my end (hoping to reproduce the same error). Could you also tell us what the underlying data sources/data bases are (what the information link should be loading the on demand data from)? Kind regards, David

Hi Kseniia, You probably see nothing since the query is failing and no output is being logged. The initial column with 1000 rows, where does it come from. Is that from a data table also being connected to an Information Link? Or direct query? And what are the data sources being used? Could you also set your Analyst logging level to DEBUG (if not already done) and see what Spotfire.Dxp.SupportDiagnostics.log file is mentioning about this issue when you reproduce the error? And if so, share that log file? Kind regards, David

Hi YB1, Not sure why your data seems weird after a while. You mentioned you had to add in a token, to connect to DataIku + SLB DELFI. Could it be that this token becomes invalid after a while and you need to refresh it? To go back to your original request, copying data to another data table so it becomes independent of the back end, could you do with this iron python script? Kind regards, David

Hi, You can try to add another y-axis variable, that calculates the difference. In the example I used, this is the formula I used: Sum([Class Sales Year 1]) THEN [Value] - First([Value]) OVER (NavigatePeriod([Axis.Color],0,-1)) The analysis file looks like this (with an overview of the settings I used for the above formula): I have used Marking as the input for my subset (hence the yellow highlighted States in the US) and calculated the difference over the color axis (rather than the default category axis). Kind regards, David

Hi Praveen, Looking at the alerting log message, it seems that the subscription id is not found in the alerting database. Can you check that? As the job fails at task two (the apply rules), it seems to me that the alerting server is working (otherwise it wouldn't have started at all). Can you: - create a new subscription, a simple one (just open an analysis file and send an email for instance); - check in the database if the subscription is created properly (SUBSCRIPTIONS table); - run the alert and check out if there are new entries in the RULE_RUN_LOG table; - check the created .xml file for the alert and try to run it directly from the Automation Services job builder in the Analyst. If this works, it might be that if you re-create the original subscription, it will then work. Kind regards, David