on 02-07-2014 8:31 AM
Hello,
I have one SQL statement like following:
SELECT DISTINCT
a~objkey AS guid_parent
b~objkey AS guid_child
INTO CORRESPONDING FIELDS OF TABLE et_parent_object
FROM srrelroles AS a
INNER JOIN crmd_binrel AS r ON a~roleid = r~role_a
INNER JOIN srrelroles AS b ON b~roleid = r~role_b
WHERE a~objkey IS NOT NULL
AND b~objkey IS NOT NULL
AND a~objkey IN lt_parents_range.
The parameter lt_parents_range has more than 1000 lines.
First time, when I run this SQL, dump occurs. Like following:
Category Installation Errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 14.01.2014 10:17:29
Short text SQL error "-1114" when accessing table "SRRELROLES".
What happened? Error Text of the Database: "POS(1) Communication packet too small"
But after refresh UI and execute this SQL again, the dump not happens again.
After one day, everything looks appear again.
Is there anybody knows why?
My environment:
OS: Linux x86_64
DB: MaxDB 7.8.02.033
NW: 720
Thanks & BR,
Tony
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tony,
-1114: Communication packet too small Locate this document in the navigation structure
Explanation
The SQL statement is so long that not all pieces of information to be exchanged between client and server can be stored in the communication packet provided for this purpose
User Response
Simplify the SQL statement or split it into several SQL statements. If this is not possible, check whether the database parameter PACKET_SIZE can be increased. This parameter indicates the size of the communication packet.
So if you can split it into smaller statements/selects of data. Or else increase parameter PACKET_SIZE.
http://maxdb.sap.com/training/internals_7.6/kernel_parameters_EN_76.pdf
Changing Parameters - MaxDB - SCN Wiki
As for daily recurrence I would guess some kind of cache built up that is cleared by your refreshing action.
Kind Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Johan,
Thanks for your reply.
Here is another question:
After this dump occurs, and refresh again, everything looks good. The dump will disappear.
Firstly I guess this is because cache. But after checked those two table, I find that all of those two table are "Buffering not allowed".
Do you know why?
Thanks & BR,
Tony
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.