When one object attempts to connect to another object that does not exist, the dashboard displays an error for that object.
Click the
Design
tab, and edit the SQL source.
Under
Configuration
, edit the SQL query to:
select * from customer c,account_info a where c.cust_id=a.cust_id
The following figure shows the
Edit Source
configurations in the
Sources
view of the
Design
tab:
Click
Save and Redeploy
, and click
OK
to confirm.
A message appears that redeployment is successful and if you want to preview the events.
Click
Cancel
.
Navigate to the dashboard and verify that the status of the source controller where you deployed the source shows the status as error.
The following figure shows the error for the
Customer Account Source
on the dashboard for the source controller:
To view the logs, perform one of the following tasks:
On the
Dashboard
tab, click the
Logs
view.
The view displays the node, the log level, the component type, the message, and the log details. You can specify the start and end date to view the logs for that period.
Select the source with the error in the contents panel of the dashboard, click the
State
view in the
Activity and Status
section on the lower pane, and then click the
Errors
link.
Verify that you can view the details, such as the source name, source type, timestamp, error code, and error message. On the right-hand side, you can view the error trace. After you complete viewing the details, close the
Error Details
window.
On the
Design
tab, edit the SQL source to change the SQL query to:
select * from customer_info c,account_info a where c.cust_id=a.cust_id
Click
Save and Redeploy
.
Navigate to the dashboard and verify that the Source Controller error flag is cleared and you can view the status as