"Table already exists" error

When you execute the SQL file from Appeon using database tools, an error message may pop up saying, "Table already exists".

Cause: The SQL file from PowerServer will create five PowerBuilder System Tables: pbcatcol, pbcatedt, pbcatfmt, pbcattbl, and pbcatvld. If the five tables already exist, the error message will display.

Solution: s Appeon rebuilds the PowerBuilder System Tables to make sure the stored procedures from PowerServer will be successfully created. You can click No on the message window to use the original system tables, or click Yes to rebuild these tables. Your choice will not affect the execution result.