topic Dump while accessing VIQMEL view in Application Development and Automation Discussions

Dump while accessing VIQMEL view

Former Member — Sat, 25 Aug 2007 09:03:35 GMT

Hello friends,

I added a field in an Append Structure of the Table QMEL.I saved,checked and

activated that Structure and QMEL Table.

Also in SE14 , I saved and adjusted the QMEL Table.

But the Added Field doesn't get reflected in VIQMEL view.

So, I saved and adjusted VIQMEL view in SE14.

After Doing this , System throws Dump Error in IW22 and QM02 Transactions

with the the following message.

" DBIF_RSQL_SQL_ERROR ".

"An error occurred when reading from the database".

" -

> SELECT SINGLE * FROM VIQMEL WHERE QMNUM = QMNUM. "

Please tell the corrective procedure if anybody knows.

With Regards,

Hari Prasath.S

Former Member — Sat, 25 Aug 2007 09:53:23 GMT

It seems the problem is with selecting the sequence of the fields from the VIQMEL view

the error RSQL_SQL_ERROR is lways related to the mismatch of the selected fields and the work area/internl table.

so check for that by correctly activating the VIQMEL in se14 and check the select statements.

Regards

Anji

Former Member — Sat, 25 Aug 2007 11:36:43 GMT

Looks like your QMEL table is partly active. Please try to correct any errors in your append structure and reactive the table.