Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
profilejamesbond

ErrorCode: 70 - Store Procedure error

Hi,

I am trying to run given below stored procedure in Qlik Sense but receive an error.

 

Stored Procedure:

SQL EXEC `mydatabase.myschema.mystoredprocedure`('Country', '01.01.2023', '02.01.2023', NULL, NULL);

 

Error:

The following error occurred:
Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 70, ErrorMsg: [Simba][BigQuery] (70) Invalid query: Syntax error: Unexpected identifier "EXEC" at [1:1]
 
 
Kind regards,
Ishfaque Ahmed
Labels (3)
1 Reply
anat
Master
Master

errorcode 70 means permission denied,can you check have the right permission for tables.