Skip to Content
0
Former Member
Dec 27, 2010 at 05:30 AM

Root cause of "SQL error in the database when accessing a table. "

1140 Views

Dear experts,

I meet this dump "SQL error in the database when accessing a table" when executing a sql.

Sql:

SELECT sesssessno poscrm_serplan_id poscrm_ser_h_id poscrm_ser_i_id

possolution_id sessbundle_id sessdbid sessinstno pos~crm_ordered_prod

sessdbid sessinstno

INTO CORRESPONDING FIELDS OF TABLE et_sess_list

FROM dsvassessadmin AS sess JOIN service_posn_sm AS pos

ON possession_id = sesssessno

FOR ALL ENTRIES IN lt_contractno

WHERE sess~contractno = lt_contractno-contract_no

AND sess~status IN lt_status_range

AND bundle_id IN lt_bundle_id

AND pos~solution_id GT 0

.

This sql works well in dev system SD7, however, it causes dump in another dev system "SMV".

Can anyone give me any ideas?

Thanks