Could not parse the GetIndexes metadata command..

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Could not parse the GetIndexes metadata command..

Post by martinw30 » Fri 15 Aug 2014 13:52

Following problem in our test enviroment:

Machine 1:
Running on Windows 2008 R2 -> Oracle 12c server this error occour:

Could not parse the GetIndexes metadata command. Problem near:- Original query: GetIndexes

Machine 2,3,4
Win 7 -> Oracle 12c
Working fine.

Machine 5
Running on Windows 2008 R2
Working fine.

All machines with dbexpoda.dll 6.23, have tested with 6.4.7 with same error. Project is build with Delphi XE2.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Mon 18 Aug 2014 10:45

Hello,

Please specify the action (server connection, opening DataSet etc.), during which the error occurs. Ensure, that all PCs use the same library version and the same actions are executed.

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Mon 18 Aug 2014 11:15

Same build (exe file), all pcs uses the same library version.

We can get a Oracle 11 working but Oracle 12 raises exception from a single computer. It executes from the same client folder from the same machine.

/Martin

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Thu 21 Aug 2014 11:09

We can't reproduce the problem. Please try to reproduce it on a simple console application:

Code: Select all

begin
    SQLConnection.ConnectionName := 'Devart Oracle';
    SQLConnection.DriverName := 'DevartOracle';
    SQLConnection.LoginPrompt := False;
    SQLConnection.Params.Values['DataBase'] := 'DB';
    SQLConnection.Params.Values['User_Name'] := 'login';
    SQLConnection.Params.Values['Password'] := 'passwd';
    SQLConnection.Connected := True;
end;

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Mon 06 Oct 2014 08:13

Hello

If I use UseQuoteChar=True everthing works.

Agaist Oracle 11 UseQuoteChar=False works but against Oracle 12 we must set the parameter to true.

Both Oracle 11 and 12 works with UseQouteChar=True

Any more information why appreciated

Regards

/Martin

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Tue 07 Oct 2014 08:55

Please send an application reproducing the problem to alexp*devart*com , and specify where the error occurs (connection to the server, opening the DataSet, etc.).

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Tue 07 Oct 2014 12:43

Sample project sent.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Wed 08 Oct 2014 10:27

I have received your email, however, the problem is not reproduced. Please specify the exact version of the Oracle client you are using.

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Wed 08 Oct 2014 10:42

Windows 7: Oracle 11.2.0.1.0
Windows 2008 R2: Oracle 12.1.0.1.0

/Martin

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Thu 09 Oct 2014 09:40

We can't reproduce the problem. Please try using the Oracle client version 11 on "problem machines" and let us know the result.

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Thu 09 Oct 2014 09:42

We use Oracle client version 11 and reicievs the error.

Only way to get this work against Oracle 12 is to use UseQuoteChar=true

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Fri 10 Oct 2014 12:31

Unfortunately, we can't reproduce the problem on our Oracle servers and computers. Try to experiment with different Oracle clients.

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Fri 10 Oct 2014 12:33

Tried with both 11 and 12 version same problem.

Will try to change Delphi version later.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Could not parse the GetIndexes metadata command..

Post by AlexP » Mon 13 Oct 2014 08:26

The problem may be due to the configuration of the Oracle clients. Please make sure that settings of the Oracle clients are the same (in the registry) on different machines.

martinw30
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: Could not parse the GetIndexes metadata command..

Post by martinw30 » Mon 13 Oct 2014 08:28

Any suggestion what I should look after? We have no Oracle client working against Oracle 12. Only UseQuoteChar=true works.

Post Reply