on 01-25-2016 8:50 PM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SPS 8 rev 82
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hello,
What revision Are you running?
Regards,
MIchael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.