topic Change in Domain length in Application Development and Automation Discussions

Change in Domain length

ramesh_putta — Wed, 11 Jul 2012 20:19:32 GMT

Hi,

I was trying to change the domain length from NUMC 3 to DEC 2.2.

when i did that it ask me to adjust the table(which uses this domain) from se14. while adjusting the table, it gave me an error. so i went back and changed the domain from DEC 2.2 to NUMC 3. And i still get the same error message from se14. I cannot activate this table.

Please let me know your suggestions.

Here's the errors from se14.

The SQL statement was not executed

Statements for Table XXXXX could not be executed

Re: Change in Domain length

Former Member — Wed, 11 Jul 2012 20:37:38 GMT

Hi Ramesh,

In se14 did you try 'Activate and Adjust Database'? Also try deleting the field and activation - be aware that the data for that field will be lost? You may also try to force the domain activation (Make sure only error is in the table you are trying to activate) and then try to Activate and Adjust in SE14.

Regards,

Shravan

Re: Change in Domain length

ramesh_putta — Wed, 11 Jul 2012 20:46:54 GMT

shravan,

I did try 'Activate and Adjust Databse' from Se14.

My domain is active.

when i activate the table from Se11. it gives me the error log with message 'table not activated'.

Again when i try it from se14 , i got the message i pasted in earlier post.

I even tried deleting that field from the table, but it still not liking it.

Re: Change in Domain length

Former Member — Wed, 11 Jul 2012 20:54:20 GMT

Are you using that domain twice in the table - I mean two fields. If it is still not getting activated then your table activation has nothing to do with the change in your domain.

Regards,

Shravan

Re: Change in Domain length

TuncayKaraca — Wed, 11 Jul 2012 21:38:49 GMT

Hi Ramesh,

You may compare Database Object and Runtime Objects for the table by using Extras -> Database object -> Check or Display and Extras -> Runtime object -> Check or Display.

It might help you to figure out the issue.

Re: Change in Domain length

ramesh_putta — Fri, 13 Jul 2012 17:03:25 GMT

good catch shravan, yea its been used for other data element as well.

I removed all -> activated->added them back in-> worked.

thanks for help.