Skip site navigation (1) Skip section navigation (2)

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: pgadmin-support(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 18:11:24
Message-ID: 5.1.0.14.0.20040407135357.00acfcb0@sciborg.uwaterloo.ca (view raw or flat)
Thread:
Lists: pgadmin-support
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'


pgadmin-support by date

Next:From: Luis Carlos B.V.Date: 2004-04-07 21:32:12
Subject: PgMigration with PgAdmin2
Previous:From: Richard HuxtonDate: 2004-04-06 17:09:28
Subject: Re: Error on deleting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group