You will get this error when your target database does't not contain the suitable table.So before running the extract please check the checkbox to generate the create table query so that it will give you the query . Run the same query in the target database and perform the extract operations
Is the target database table part of PegaRules and PegaData schema or it is created as part of separate schema. Can you please provide us the database table definition along with screen shots of Extract rule?
Also please enable the debug logs for below class and provide us the log file.