jeremyhurren

About

Username
jeremyhurren
Joined
Visits
0
Last Active
Roles
Member, Domosapien
Points
8
Badges
0

Comments

  • Are you using impersonation in your job settings? I have seen an issue in Wb4 where the impersonation and unimpersonation are not always synced up correctly, which could result in a situation where the thread your job is running in does not have rights to clean up its cache directory. This is an issue that would be…
  • I don't believe the csv parser in workbench allows for no encapsulating character. Usually if you put in double-quote or single-quote, or some more obscure character like tilde, that will allow your file to parse correctly.
  • The error message doesn't have great info. Is there anything else in the log that might indicate what the failure is? There is usually a series of messages about a part failed for some reason, and then that it is retrying. The random nature of the failures make me think that it's likely to be something like a network…
  • As previous posters mentioned, Domo expects all datetime data to be in UTC. Workbench includes a "Shift Timezone" transform to assist with this. So if your data is in EST, you would add this transform to tell Workbench that is the data timezone. Then Wb will shift it (by adding or subtracting the appropriate hours based on…
  • creed's answer is great. If you can do this in the SQL statement that will be the best and fastest way to get this done. I wanted to offer one other option just for the sake of completeness. In workbench (the current version of Wb4) you can do this with a calculated field or a search and replace transform. A calculated…
  • A 403 Forbidden error generally means just that. For whatever reason, the credentials workbench is using to connect to Domo do not have access to get the list of agents on your Domo instance. I would re-configure the Domo account that Workbench is connecting with. Maybe generate a new Api token for it to use.
  • Let me try to explain what is intended to happen here. First, Domo expects all datetime data in its tables to be in UTC time. Everything is kind of based on that assumption. To adjust how data is treated in the Domo web UI, you can go into the Admin section under Company Settings. On the Company Overview page there is a…
  • Just a couple of ideas for troubleshooting... 1. You can restart the Workbench service using the system tray icon - right click, then choose Service and Restart. The running job will be terminated, all the queued jobs will be lost since they are all in memory. But as soon as the service starts again it will re-queue all…
  • I think typically the QuickBooks data comes in in different columns, so the amount is either in the credit or debit column, rather than being positive or negative. I think you create a calculated field in Workbench that would pull the right amount. Use a calculation along the lines of (sorry I can't provide an exact answer…
  • So this problem is caused because Workbench is asking the database server for the schema, but the database server (SQL Server in this case) is returning an error that it doesn't know the schema of the query due to the use of the temp table. The error will look something like: ERROR [42000] [Microsoft][SQL Server Native…