Kbase P22816: PeerDirect: Unable to create tables with Replication Designer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
PeerDirect: Unable to create tables with Replication Designer
PeerDirect
CREATE TABLE "dSite" ("SiteID" integer NOT NULL,
..list of tables names ........>
1050 ODBC Error -1: (S1000) '[DataDirect][ODBC PROGRESS driver][PROGRESS]No RESOURCE privileges (7574)' <-20057,SQLExecDirect>
715 ODBC statement failed: -1 from function ExecDirect
< ........ new list of tables names ........>
Unable to create dSite table
1227 Not all internal tables could be created.
1276 Error '{An ODBC error occurred}': Could not insert system tables for the database 'localhost:pd1:Sports' (data source 'xPDCONZEK').
1517 Could not edit the replication rules for database 'localhost:pd1:Sports' (data source 'xPDCONZEK').
930 Error '{System Error}': DDBSetDatabase failed in PDNewDBWizSheet::SetDatabase().
CAUSE:
PDUSER does not have the necessary privileges.
FIX:
Grant DBA and RESOURCE PRIVILIEGES to PDUSER.