cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
443
Views
0
Helpful
0
Replies

Receiving an SQL error when trying to run a specific report for last month

Receiving an error when running the report from the GUI. Tried to run the below command via the CLI and got the same error.

Error report from GUI is extensive will attach:

 


From CLI:

admin:run uccx sql db_cra call sp_agent_detail('2018-10-01 06:00:00','2018-11-01 05:59:59','0',null,null,null,'SignUp',null)
Internal CLI Error: java.sql.SQLException: A subquery has returned not exactly one row.

 

0 Replies 0