Windows 95 GPF when Data Warehousing (OpenInsight Specific)
At 24 FEB 1999 11:03:46PM Matt Sorrell wrote:
HELP!!!
I've just created a very simple data warehousing procedure that creates two SQL tables, and the warehouses one LH table that contains multi-value data. As a sample, I've been trying to warehouse the SYSKNOWLEDGE table.
The create table scripts run perfectly, and my tables are created. Then, the warehouse manager indicates it is running a query, which completes. It then starts to process the records that were selected. Every time I've run it, when it gets to record 2 (two) out of 167, I get a GPF in OIWIN (I think this was the exe).
I'm running OI 3.7 on a Windows 95 workstation, trying to load into a SQL 6.5 database.
I don't have 16-bit drivers, so I've spoofed OI by including a 16-bit driver section in my ODBC.INI file, and placing my DSN entry from the 32-bit section in there.
I can connect to the server just fine, and as I mentioned, the tables are created.
Also, I ran the data warehouse script provided in the EXAMPLES application, and it ran perfectly, with no problems.
Any help would be greatly appreciated.
Matt Sorrell
At 24 FEB 1999 11:20PM Matt Sorrell wrote:
More information:
The GPF is in OENGINE, not OIWIN. Sorry about that. Also, once it bombs out, I cannot restart OI without rebooting my system. Finally, if I am in one application, and attempt to open another application, the system breaks to a debugger, and says that the source code for RTP11 cannot be found.
I can close the application that I am currently in, but when I try to open another application, OI locks up and I have to give it the three fingered salute.
Do I just have a bad install of OI?
Matt
At 01 MAR 1999 07:37AM Cameron Revelation wrote:
Hi Matt,
What is the exact error message text and details when it GPF's?
If you are warehousing to SQL Server, you do not have to go through ODBC. You can use the SQL Server direct connection (OI30SQLS.DLL) … you will want to get the older versions of W3DBLIB.DLL and DBNMP3.DLL however; the 6.5 versions are buggy. (Search on either of those names in this online discussion.)
Cameron Purdy
Revelation Software
At 01 MAR 1999 09:02AM Matt Sorrell wrote:
Cameron,
I have tried to specify a SQL server connection, but I cannot get it to work.
I think I am missing something really simple.
When I specify the server name, do I have to use "\\" or just type in the server name. I've tried both, and cannot get either to work.
Matt
At 01 MAR 1999 12:42PM Cameron Revelation wrote:
If you have trusted connections set up (MS SQL Server) you can just specify the name of the NT server machine. You may have to configure what client library you are using … (is that W3DBVER, WINDBVER, …?) or use SQL Admin to verify that you can connect.
Cameron Purdy
Revelation Software
At 30 MAR 1999 12:12AM J.X. Thomas wrote:
I am doing data warehousing to an Oracle database using the Workgroups Oracle interface. I can warehouse 100,000+ records on some tables without an error. On other tables I keep getting a GPF: Specifically the error is:
OENGINE caused a General Protection Fault in module ORA73WIN.DLL @ 0006:63DD.
I have to close the OENGINE and cannot reboot without exiting my session completely.
Any ideas or help would be appreciated
Joe Thomas
Nova Scotia Power