we have some strange problem at one of our customers.
We get the following error when our application tries to open a dataset from one table. This error occurs only by this customer. We already dump the complete database into our Oracle installation (Same Version as the customer has: 11.2.0.4.0), and we dont get this error. So we cant reproduce the error in our test-environment.
Whats happening:
Code: Select all
...
dm1.SQLDataSet1.Close;
dm1.SQLDataSet1.CommandText := 'SELECT * FROM T_DruDoc WHERE drdnr = ' + nr1;
dm1.SQLDataSet1.Open; << Line 649 from FormDLL.pas
dm1.SQLDataSet1.First;
...
Message: Der Metadatenbefehl Getlndexes konnte nicht analysiert werden. Problem befindet sich in der Nähe von: Originalabfrage: Getlndexes eurowigT.mainz.de. DB3219 . T_DRUDOC ."
Stacktrace:
[0E5A0DFAKeurowig_report.dll} Data.DBXMetaDataReader.TDBXBaseMetaDataReader.ParseDone [0E5A062EKeurowig_report.dll} Data.DBXMetaDataReader.TDBXBaseMetaDataReader.ParseGetObjectName [0E59FECBHeurowig_report.dll} Data.DBXMetaDataReader.TDBXBaseMetaDataReader.ParseMetaDataCommand [0E5A0E7B]{eurowig_report.dll} Data.DBXMetaDataReader.TDBXBaseMetaDataReader.FetchCollection [0E485F87Heurowig_report.dll} Data.DBXCommon.TDBXCommand.GetText
[0E5A6CF3Heurowig_report.dll} Data.DBXMetaDataCommandFactory.TDBXMetaDataCommand.DerivedExecuteQuery
[0E485D95Keurowig_report.dll} Data.DBXCommon.TDBXCommand.ExecuteQuery
[0E4862E3]{eurowig_report.dll} Data.DBXCommon.TDBXMorphicCommand.ExecuteQuery
[0E522C1C]{eurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.OpenSchema
[0E520BAE]{eurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.ExecuteStatement
[0E519D2CHeurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.InternalOpen
[0E3FDEEEKeurowig_report.dll} Data.DB.TDataSet.DolnternalOpen
[0E3FDF9EHeurowig_report.dll} Data.DB.TDataSet.OpenCursor
[0E519E67]{eurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.OpenCursor
[0E3FDE55]{eurowig_report.dll} Data.DB.TDataSet.SetActive
[0E51728E]{eurowig_report.dll} Data.SqlExpr.TSQLConnection.OpenSchemaTable
[0E521ADEKeurowig_report.dll} Data.SqlExpr.TCustomSQLDataSetAddlndexDefs
[0E5232EC]{eurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.PSGetKeyFields
[0E3FE5B2Heurowig_report.dll} Data.DB.SetKeyFields
[0E3FE873Heurowig_report.dll} Data.DB.TDataSet.CreateFields
[0E519D78Heurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.InternalOpen
[0E3FDEEEKeurowig_report.dll} Data.DB.TDataSet.DolnternalOpen
[0E3FDF9EHeurowig_report.dll} Data.DB.TDataSet.OpenCursor
[0E519E67]{eurowig_report.dll} Data.SqlExpr.TCustomSQLDataSet.OpenCursor
[0E3FDE55]{eurowig_report.dll} Data.DB.TDataSet.SetActive
[0E3FDC91 Heurowig_report.dll} Data.DB.TDataSet.Open
[0E9B9DC7Keurowig_report.dll} FormDLLTfrmDLLbtnBioLifePrintClick (Line 649, "FormDLLpas")
[0E9C546EKeurowig_report.dll} FormDLLTfrmDLLMYMessage (Line 2470, "FormDLLpas")
[0E2CB62EKeurowig_report.dll} Vcl.Controls.TControl.WndProc
[0E2D01A1]{eurowig_report.dll} Vcl.Controls.TWinControl.WndProc
[0E179E30]{eurowig_report.dll} System.TMonitor.TryEnter
[0E17998C]{eurowig_report.dll} System.TMonitor.Enter
[0E17980C]{eurowig_report.dll} System.TMonitor.CheckOwningThread
[0E179B1AKeurowig_report.dll} System.TMonitor.Exit
[0E179B6B]{eurowig_report.dll} System.TMonitor.Exit
[0E2A15C7Keurowig_report.dll} Vcl.Graphics.FreeMemoryContexts
[0E2CF7C0Heurowig_report.dll} Vcl.Controls.TWinControl.MainWndProc
[0E2CF7D5Heurowig_report.dll} Vcl.Controls.TWinControl.MainWndProc
[0E248760]{eurowig_report.dll} System.Classes.StdWndProc
[0E2D01A1]{eurowig_report.dll} Vcl.Controls.TWinControl.WndProc
[0E3AD599Keurowig_report.dll} Vcl.Forms.TCustomForm.WndProc
[0E2CF7C0Heurowig_report.dll} Vcl.Controls.TWinControl.MainWndProc
[0E248760]{eurowig_report.dll} System.Classes.StdWndProc
[0E3B6F37Keurowig_report.dll} Vcl.Forms.TApplication.ProcessMessage
[0E3B6F7AHeurowig_report.dll} Vcl.Forms.TApplication.HandleMessage
[0E3B2336Keurowig_report.dll} Vcl.Forms.TCustomForm.ShowModal
[0E9C6E2BHeurowig_report.dll} FormDLL.Eurowig_ShowForm (Line 2851, "FormDLLpas")
Environment:
Clients:
Windows 8.1 and Windows 10
Oracle 32bit Client 11.2.0.4
Server:
Linux
Oracle 64bit Server 11.2.0.4
Our Approaches so far:
- Select in SQL Plus or SQL Developer with same User Account / Schema => Worked
- Tried with SELECT * FROM T_DRUDOC and also specified some Columns testwise (SELECT col1, col2 FROM T_DRUDOC) => Worked not, same error
- DB-Connection-User owned the DBA Right => Worked not, same error
- Imported database to our testsystem => Worked