-
Card Error Report
It'd be useful to have an ability to build real-time reporting around which cards are broken. The existing DomoStats Card Loads dataset is more of a log of card load performance, and the fact that there's no datetime value does not allow to tell that card X's last log is a failure. Given this limitation, it cannot be…
-
Tracking Cards with Errors
Hey All, Our organization is trying to find a good way to keep track of cards that are broken. We want to be able to address any card errors as soon as they come up. Right now it doesn't look like any of the DomoStats or Domo Governance datasets allow to report on card errors. Curious if anyone here has had a similar need…
-
CSV SFTP Push Connector Error
Hi all, I am asking a third-party to push a dataset into DOMO using the CSV SFTP Push Connector. They have tried to push the data on two separate dates and both times we are seeing the error message, "Domo system error encountered processing your data. We are working to resolve this issue (Temporary Internal Connector…
-
Error Message: "Lost Connection to Domo" Handle Differently
Our users see a popup in the lower left that says, "Lost Connection to Domo" and panic, particularly if they're been modifying a card when this pops up. From my experience this is a very momentary ultra-short outage and is often restored before I'm able to click the "X" or in worst cases need a refresh of my browser — so…
-
Warning: Not all the data is shown | Calendar Card
Hello, I'm having a problem with the Calendar card. It's supposed to display the count by day using data from the last 6 months. However, I keep getting a warning saying that not all the data is shown. Does anyone have any ideas on how to handle this? Maybe there's something I'm overlooking in the ETL process that could…
-
Beast Mode Formula error
Could you please help me identify an error in my formula: POWER((SUM(CASE WHEN Parts Kits Fiscal Year=SEG PMKA CAGR End Period THEN Parts Kits Qty END) / SUM(CASE WHEN Instrument Fiscal Year BETWEEN SEG PMPK CAGR Start Period AND SEG PMKA CAGR End Period THEN Instrument Qty END))/(SUM(CASE WHEN Parts Kits Fiscal Year=SEG…
-
Email Connector: Way to ignore #N/A fields in xls files ?
I am using the email connector to send .xls files to DOMO. There were some fields in the excel file that contained "#N/A" and they were automatically converted to "ERROR 42" in the dataset that was created and caused my downstream dataflow to fail. Is there a way to have the connector somehow ignore #N/A fields or convert…
-
Beast Mode calculation works but when trying to insert into a card, I get an error.
Good day, I have a beast mode calculation that I believe can calculate the sum of accidents over the previous 12 months for any given month. My data set goes back 3 years on a month by month basis. Here is the current beast mode that works when I validate it: SUM(SUM(fieldsAccident Count)) OVER ( PARTITION BY…
-
Domo bug? from Excel file import
When I append data on a Excel File export (same structure) the valid ID's in the ID column are errored out with ERROR:#N/A Right now its at 58,000 rows, is there an issue here? Wondering why its erroring out those ID's
-
Magic ETL History Error Log Visual Representation
It would be great if in the history of the dataflow it gave some sort of visual representation on which FAILED had an actual error message unsafe:blob:https://community-forums.domo.com/3f21bf82-40fc-40ed-9c50-d0deb55aed1e I normally have to look at each one to find the one with the actual error
-
Provide details on when Domo will attempt to run a dataset again
As an Admin or Editor I want to see the details of when Domo will attempt to run a dataset again. In order to know if I should try to manually kick off a dataset, or wait for Domo to run it. Currently the Interface shows this when there is an isssue: When clicking view details, it takes you to the History tab. I would like…
-
Transaction Deadlock workbench error
Good morning. I am curious if anyone has had this error before. One of our workbench jobs has been getting it more and more. I don't know if it is a domo workbench issue, or if it is an issue on the database side where we query the workbench job from Error 40001 Microsoft ODBC SQL Server Driver SQL Server Transaction was…
-
Error in PPT. Plugin
Hi Everyone, I am having an error code on a ppt I connected to Domo. Everything was set with cards but I ended up deleting some cards from the dashboard itself and also on the ppt. Now when I refresh the ppt. I get an error message below. I deleted the cards from the dashboard and ppt so I am not sure how to solve this…
-
Multiple Case statements
Hi there, I am trying to make a table that has the following columns. Customer Name / AW 2022 Pre-Orders / AW 2022 Replen Orders / AW 2023 Pre-Orders So what i need is a beast mode formula that can get me data based off the 'Invoiced Month' of 10, 11, 12. The 'Invoiced Year' of 2022 and 2023. And finally the 'Sales Order…
-
I am needing help to create a condition in order to make a beast mode I am working on
I need this beast mode to switch its year offset based on which quarter it currently is. This is the first and most important part of the beast mode since it will effect how the data is read and written each quarter. I have come up with three ways to do this but none work, here is what I have come up with: (CASE When (CASE…
-
One of my bar charts won't display properly in the dashboard.
Hi, everyone! I have a card which shows up properly in analyzer, but does not show its bars in the dashboard or when I click into the card for a drilldown. The weird thing is, if I hover over another card as if to filter a time period, the data will show up. Our management and executive leadership regularly access this…
-
Workbench - Source File Does Not Exist
Has anyone found a solution for the "Source File Does Not Exist" error? I am using the 'Excel: On-Premise' processing method and using a network drive for storage. Even when I reconfigure and reselect the file it does not resolve and I get the above reference error. Any ideas? Thanks all!
-
Details on why the "attention" symbol appears on dataset/dataflows
Hi, I have a few datasets or dataflows that have an attention symbol next to them: However, when hovering over it, it doesn't say why this symbol is here, so I don't know how to fix the issue. It looks like it can be related to the upstream lineage, however if that lineage is long, it can take a lot of time to investigate…
-
ML model null values and unknown error message
We are trying to create a machine learning workflow wherein we are trying to predict by feeding in several rows of data to train the model and use that as base to get the predictions. We were able to run the same model (with samechosen parameters) in Python and get an accuracy of upto 95%. When we try to replicate the same…
-
Instagram Business Connector - Server Error
Hi guys, Has anyone had this error whilst trying to pull data from Instagram? Domo is ready, but received a 'Server Error' from the data provider. If the issue persists contact the data provider for support. All suggestions welcome as I really need to get this fixed. Thanks, Shiel.
-
Snowflake Federated Connector 'No federated agent was found for the provided values...'
Have been using snowflake federated connector for about 3 months no issues then today all of a sudden receiving this error. The error displays when trying to 'create' the dataset meaning I am able to navigate through the scheme browser, select and view the dataset I want to connect but once I get to the final menu and…
-
Is there a reliable way to make Magic ETL intentionally fail?
I have an ETL that uses, among other inputs, a Webform that isn't always maintained perfectly. One recent problem involved two rows for the same identifier, with different text in the description column. What I'd like to do is make the ETL fail if something like this happens. I tried doing a Group By on the identifier…
-
Capture error in a Card
We're currently using a Range Selector card to allow users to filter our data based on a MIN and MAX date. The problem is that we sometimes have no data when users initially access our platform and they see the error "Error: The maximum value is less than the minimum value" and that leads this to thing that there's an…