cancel
Showing results for 
Search instead for 
Did you mean: 

General error in PlanViz

patrickbachmann
Active Contributor
0 Kudos

Hi folks,

I have a slow SQL script view that I'm trying to analyze visual plan and am getting this error that I have never seen before;

- SAP DBTech JDBC: [4096]: General error in PlanViz: cannot generate plan due to duplicate opId on registerQo2Ptr: 0

Has anybody seen this before or have any ideas?

Thanks,

-Patrick

Accepted Solutions (1)

Accepted Solutions (1)

former_member183326
Active Contributor
0 Kudos

Hello Patrick,

So it seems to be an issue with the SDA here.

Some questions:

1: Have you tried creating a fresh connection for the SDA between the two systems?

2: Please check also if the drive manager that you are using is supported for these SP's.

3: Have you tried doing this with a systems that have the same SP's?

4: Have you ruled out issues on the network between the two systems?

patrickbachmann
Active Contributor
0 Kudos

Thanks I'm digging into your latest questions.

-Patrick

Answers (2)

Answers (2)

patrickbachmann
Active Contributor
0 Kudos

SPS 8 rev 82

former_member183326
Active Contributor
0 Kudos

Hello Patrick,

Please check the "odbc.ini" on each server and see whether or not it is identical.

Is there any config such as "fetchbuffersize" in the odbc.ini file?

Check to see if you have DSN or odbc traces active.

Cheers,

MIchael

patrickbachmann
Active Contributor
0 Kudos

Correction this particular db is rev 85.  I'm looking into your questions.  Thanks

former_member183326
Active Contributor
0 Kudos

ok, do let me know

patrickbachmann
Active Contributor
0 Kudos

Ok at first I was puzzled why you were asking about ODBC and then I realized in the SQL there is indeed a virtual connection to a different HANA db.  So I wrote a very simple new SQL to test this theory;

select * from mySchema.VirtualTableName

And did the visualPlan and sure enough got the same error.  The system that i'm running the query is SPS 8 rev 85 and the virtual connection points to table on SPS 8 rev 82 db.

I checked with our hardware administrator who sets up the virtual connections and was told it's using 'Adapter Version 1.0'

I'm not sure if that answers your question.

-Patrick

patrickbachmann
Active Contributor
0 Kudos

Also i'm told the ODBC.INI just contains something like this;

hostname:/etc/unixODBC> more odbc.ini

[virtualConnectionNameHere]

Driver =/sapmnt/ourDatabase/hdbclient/libodbcHDB.so

ServerNode = x.x.x.x:PORT

patrickbachmann
Active Contributor
0 Kudos

ODBC.INI looks very similar for both systems.

former_member183326
Active Contributor
0 Kudos

Hello,

What revision Are you running?

Regards,

MIchael