topic Table mismatch in Application Development and Automation Discussions

Table mismatch

former_member420959 — Sat, 26 Apr 2014 07:58:34 GMT

Hello all,

In the quality system all the trasaction based on ekko tables are leading to short dump.

When i explored the problem , fields in the %_KEKKO in the function pool /1BCDWB/DBEKKO are deleted in quality some how but are in developemnt.

the program /1BCDWB/DBEKKO in quality is as below

In development it is as

And also I observed of the program in se80 screen 1000 is missing in quality but in developement its present

In quality

In development it is as

Is there any way we can regenerate this and bring it back to normal in quality

Regards

Ujwal

Re: Table mismatch

matt — Sat, 26 Apr 2014 08:46:07 GMT

/1BCDWB/DBEKKO is a program generated by SAP when you run transaction SE16 to look at the contents of EKKO.

What do you mean you are getting a dump with all transactions based on EKKO? And what dump are you getting? An SE16 program being unavailable is not going to affect other transactions.

Re: Table mismatch

jogeswararao_kavala — Sat, 26 Apr 2014 08:58:06 GMT

Hi Ujwal,

One possibility can be the inconsistency with table EKKO arose out of ZZ fields in Include structure CI_EKKODB. Investigate in this angle. Compare this structure between trouble-free client and Quality client. Also check the status of your EKKO table. Is it Partly Active?

Jogeswara Rao K

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 09:20:35 GMT

Yes,

Its dumping when i go to se16 also

Its saying due to no fields in %_KEKKO structure.

The ME21N transaction is leading to dump when save

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 09:21:27 GMT

Hi ,

The structure in both the clients is same.

Re: Table mismatch

Private_Member_7726 — Sat, 26 Apr 2014 09:31:38 GMT

Hi,

Are there any red entries in SE11 activation log for table EKKO; via menu Utilities->Activation Log? Any errors reported in SE11 Utilities->Database Object->Check and Utilites->Runtime Object->Check? Also, what exactly is the error in ME21N dump?

cheers

Janis

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 09:34:34 GMT

The problem now is not only to EKKO

When we try to adjust any Ztable in SE14 also its throwing below errors

Donno how far the above dump for EKKO and this ztables adjustment related.

again its in QAS system only

Re: Table mismatch

Former Member — Sat, 26 Apr 2014 09:36:56 GMT

Hi Ujwal,

Please check whether table-EKKO is partly active?

Regards,

Sudeesh Soni

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 09:37:23 GMT

Same error is also for EKKO table as in above screenshot.

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 09:38:09 GMT

Hi Sudeesh , EKKO table is active

Re: Table mismatch

Private_Member_7726 — Sat, 26 Apr 2014 09:54:42 GMT

I'd report this to Basis/DBA... If you want to continue investigating, however:

1) what DB is this;

2) what SUBRC does the DB_EXISTS_TABLE and DD_EXISTS_DATA Function Modules return for those tables?

cheers

Janis

P.s. don't we all programmers just loooooove those "either this or that" error messages..? I know I've written my share of them

Re: Table mismatch

Former Member — Sat, 26 Apr 2014 09:57:05 GMT

Hi Ujwal,

Check the table-EKKO version history. Is there any change done on table recently?

Also, compare table version history ideally it should be same in both the system.

Regards,

Sudeesh Soni

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 10:01:00 GMT

already done that...nothing applied.

While I display contents of a table i am getting below dump

At below line

same in the case of EKKO table also near the same select statement.

Ujwal

Re: Table mismatch

jogeswararao_kavala — Sat, 26 Apr 2014 10:14:29 GMT

Your investigation should be around the Ztable ZWEIGHMENNT.

See the status of this table, and the status of any Append Structures here, version history etc.

Jogeswara Rao K

Re: Table mismatch

matt — Sat, 26 Apr 2014 10:21:57 GMT

If you would simply give the details of the issue instead of pursuing your (wrong) idea of what is causing it, we'd make better progress.

You are not getting problems because /1BCDWB/DBEKKO is faulty. That is just a symptom. The SE16 dump is useless. Far more important is what dump do you get with ME21N?

Re: Table mismatch

Former Member — Sat, 26 Apr 2014 10:23:00 GMT

Hi Ujwal,

Is there any appended structure in EKKO table?

Regards,

Sudeesh Soni

Re: Table mismatch

Private_Member_7726 — Sat, 26 Apr 2014 10:36:19 GMT

It doesn't bring us much further, but SyBooks Online say:

590

 Dynamic SQL error - Prepared statement `%.*s' does not exist.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.

Something's (seriously) wrong with the database on Quality, I believe. DB admin (and maybe SAP Basis guy) should be looking into it.

cheers

Janis

Re: Table mismatch

former_member420959 — Sat, 26 Apr 2014 10:37:04 GMT

no append structure .

a fields has been added in CI_EKKODB.

Re: Table mismatch

Private_Member_7726 — Sat, 26 Apr 2014 11:38:21 GMT

To answer your original question: you can force regeneration in SE16 via menu Table->Generate Progam. It will be regenerated next time you try to display data:

I don't think it will solve the problem, however...

cheers,

Janis

Re: Table mismatch

matt — Sat, 26 Apr 2014 12:07:02 GMT

I agree. If ME21N is failing then the problem isn't with SE16 or /1BCDWB/DBEKKO. The problem lies with table EKKO as it is on the database. That requires DBA (BASIS) intervention.

Since anything you do could make things worse, I suggest that you get hold of someone who knows what they are doing.