Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR catalog tables could not be created..

Status
Not open for further replies.

montjoile

Programmer
May 23, 2011
23
CO
hi. Im connecting to a oracle network database using power builder 6.0, but I get the following error when I display the window containing the datawindow:
Predefined message "pfc_dwderror" not found.
message arguments:
1)A database error has ocurred
Database error code: 942
Database error code message:
select error: SQLSTATE=S0002
[microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist

this is the odbc script for connection:
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=xxx;UID=xxx;PWD=xxx;'"

once I try to connect to the database, I get the following error:
"catalog tables could not be created and are not available for use".

The 942 error, says that this occurs because I don't have enough privileges to view the tables in the database, but I DO connect to the database, I can update, delete, view, and create new registries. What could be the problem??
 
When PB connects from the development environment initially, it creates the catalog tables (I believe there are six of them). These hold extended property info, edit mask info, etc. If you don't have the permissions to create these tables or you don't designate the tables' owner in your connection properties, you can't use them in development (or at run time in the case of your pfc_dwerror message).

Matt

"Nature forges everything on the anvil of time"
 
Someone recommended to ucheck Use powersoft repository option in the database painter in another forum. I already did it but I get the same error. If I'm not using the catalog tables, why then, Im getting this error?
Besides, it says something about pfc_dwderror, wich is not found by power builder
 
I fixed the problem, it was happening because I didn't have enough privileges in the database :p
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top