i am unable to create a chart using the Lead Owner (“OwnerId”).
when i select Charts->New Chart->Generic Chart, select “Module: Lead”, the select choice in “Dimensions->Field”, there is option for owner. there is lead source and lead type, but no lead owner.
Lead:
list of leads, select a lead (module Lead".
the options “Convert this Lead into an Account” and the other automation button are disabled.
how do i enable this button?
the automation help doc only shows scripting (this is a docker install), and i do not see a permissions setting.
You currently can not use some fields as a dimension, such as rich text and references (record and user types).
To overcome the limitation you can create a new field (let’s call it ref_owner) and a fresh workflow that populates a newly created field with some value from the reference.
I gave this a quick test on a fresh instance and it worked fine.
One issue I’ve spotted is that the email send step failed due to me not configuring SMTP.
Make sure your SMTP configuration is fine (so you can send out emails).
If you don’t wish to send out emails, remove any function step of type Email.
To debug if there is some other issue you can:
In the page builder, edit the automation page block and re-add the two buttons.
Perhaps there was some issue with referencing when provisioning your instance.
Open up the developer console (ctrl+shift+j), go to the network tab and click on the button.
Are there any requests happening? Any errors?
Open up the related workflow (in the workflow web application) and try to run it manually.
To do that, hover over the trigger and click on the little green play button; fill in the parameters and run it.
Can you try to restart your server? Does that fix it?
Can you take a look at your dump SQL files to check if they are ok? MySQL sometimes adds a few permission related error messages which could cause issues.
Can you inspect the contents of the auth_clients table? Can you also send over the .env file (make sure to remove any sensitive info).
The restart worked after a restore. site responds.
my backup sql file did not include the workflow items (the backup from upgrade of 2020.12 → 2021.9.5, 2021.9.6)
i looked through a few of my old backup files and the “automation_workflows” table does not exist.
i also got this error on the backup command:
mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
site wont let me upload a file (new user)
here is text of .env: (only diff was i think i turned on debug messages)
########################################################################################################################
docker-compose supports environment variable interpolation/substitution in compose configuraiton file