Error Message
Import fails with the error message "Failed to Execute Stored Procedure". The trace log has the following error:
Error^Loader^ProcessID:6676^ThreadID:7316^BaseVTLProcessStep^Execute^ 2018/09/30 12:03:54^SPF.Server.SPFException: Failed to Execute Stored Procedure ---> Oracle.DataAccess.Client.OracleException: ORA-01031: insufficient privileges
ORA-06512: at "TC_VTL_DATA.VCT", line 12
ORA-06512: at line 1
Solution
Grant create table access to the Data Validator user for the target system database.
For example, when using an Oracle database, connect to the database as the system administrator and execute the following SQL statement:
grant create table to vtl_data;