topic SQL Error -206 in se11 in Application Development and Automation Discussions

SQL Error -206 in se11

Former Member — Wed, 29 May 2013 14:39:39 GMT

Hi All,

I added a new field to my custom table at the bottom . During activation, it is failing. Even If I try to activate thru SE14(database utility) i.e. adjust and activate table, I see Error message as 'SQL statement was not executed' & 'Statements of Table 'ZXX_123' could not be executed. But Table is activated and when i try to display entries in Table, it gives a Dump " SQL error "-206" when accessing table "ZXX_123" ; Error Text of the Database: "Column 'ZVEHICLE_ID' not in specified tables.

I searched in Google with this error and could not find; I searched in OSS Notes, all notes i found was implement patches etc in BW/BI, which our dont carry any of them.

Any Suggestions .

Thanks in Advance.

Re: SQL Error -206 in se11

Former Member — Wed, 29 May 2013 15:07:16 GMT

Hi Michael

what's the error when you try to activate that in SE11 ?

Let me know

Re: SQL Error -206 in se11

RaymondGiuseppi — Wed, 29 May 2013 15:08:09 GMT

Did you check the activation log for actual error code (SQL -206 (in DB2 ? ) only check that one field of the request don't exist in database.)

Else could you remove your field, reactivate table and execute once again SE14 ?

Regards,

Raymond