Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

From: Ray Nassar <ray(at)acebox(dot)uwaterloo(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Date: 2004-04-07 21:52:55
Message-ID: 5.1.0.14.0.20040407175227.00acfcb0@sciborg.uwaterloo.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I am getting the error "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done." when I try
to view tables in my database with PG Admin. If chose "Continue" then PG
Admin behaves as if I have no tables in this database even though I know
they are there by checking the database in other ways. I have already
tried rebooting, reinstalling and other things but nothing works. I guess
I probably gave a bad command and it could not recover. What should I do?
I hope someone can help me. The last portion of the log file starting from
the command sequence that I gave right before it bugged out on me is below.

Thanks,
Ray

2004-04-02 16:54:19 - SQL (climatology): CREATE TABLE newtable AS SELECT
id, occultation, cmc_data, numalt, cmc_high, datetimestamp, lat_ref,
long_ref, z, t, p, d, lat, long, uts FROM a_priori_tp;

ALTER TABLE newtable RENAME TO a_priori_tp_new;

GRANT SELECT ON TABLE a_priori_tp_new TO PUBLIC;
GRANT ALL ON TABLE a_priori_tp_new TO acelib;

ALTER TABLE a_priori_tp_new ALTER id SET DEFAULT
nextval('"profile_test_id_seq"'::text)

2004-04-02 16:54:30 - SQL (climatology): SELECT oid, relname,
pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM pg_class
WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname

2004-04-02 16:54:30 -
*******************************************************************
2004-04-02 16:54:30 - Error(s)
2004-04-02 16:54:30 -
*******************************************************************
2004-04-02 16:54:30 - Error in pgAdmin II:frmMain.mnuPopupRefresh_Click:
-2147217887 - Multiple-step OLE DB operation generated errors. Check each
OLE DB status value, if available. No work was done.

2004-04-02 16:54:30 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 4
2004-04-02 16:54:30 - pgSchema Version: 1.6.0
2004-04-02 16:54:30 - MDAC Version: 2.5
2004-04-02 16:54:30 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on
sparc-sun-solaris2.8, compiled by cc -Xa
2004-04-02 16:54:30 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=databace.uwaterloo.ca;PORT=5432;UID=acelib;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0"

2004-04-02 16:54:38 - SQL (climatology): SELECT objoid, objsubid,
description FROM pg_description
2004-04-02 16:54:38 - SQL (climatology): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname
2004-04-02 16:54:57 - SQL (climatology): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname
2004-04-02 16:54:57 - SQL (climatology): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname

2004-04-02 16:56:31 -
*******************************************************************
2004-04-02 16:56:31 - Error(s)
2004-04-02 16:56:31 -
*******************************************************************
2004-04-02 16:56:31 - Error in pgAdmin II:frmSQLOutput.RefreshData: 380 -
Invalid property value

2004-04-02 16:56:31 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 4
2004-04-02 16:56:31 - pgSchema Version: 1.6.0
2004-04-02 16:56:31 - MDAC Version: 2.5
2004-04-02 16:56:31 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on
sparc-sun-solaris2.8, compiled by cc -Xa
2004-04-02 16:56:31 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=databace.uwaterloo.ca;PORT=5432;UID=acelib;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0"

2004-04-02 17:03:15 - SQL (template1): SELECT numbackends, xact_commit,
xact_rollback, blks_read, blks_hit FROM pg_stat_database WHERE datname =
'climatology'

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2004-04-07 22:13:19 Re: Help with Select Statement
Previous Message Richard Hayward 2004-04-07 21:02:40 Everyone can see tables?