We have a requirement from customer to increase the scale of INVOICELINE.UNITCOST field from 2 to 6.
Since the Unit Cost is OOTB attribute and assuming that it might have impact on other related attributes and functionality,
We tried to figure out all the invoice related tables(Since customer is using Invoice application only as of now) which are having DECIMAL Type and Scale<6 using below query:
select objectname, attributename, title, persistent, length, scale,maxtype
from maxattribute
where
maxtype ='DECIMAL' and scale<6
order by objectname, attributename;
'A_INVOICE';
'A_INVOICECOST';
'A_INVOICELINE';
'INVOICE';
'INVOICECOST';
'INVOICELINE';
'INVOICEMATCH';
'INVOICETRANS';
As there are large number of attributes we have prepared update statements for each attribute to update the scale from backend :
update maxobjectcfg set changed='A' where objectname='A_INVOICE';
update maxattributecfg set scale=6, changed='A' where attributename='ABC' and objectname='A_INVOICE';
1.When i run the update statements above and tried to turn on Admin mode from front end(It failed).
2.Stopped the server from the websphere console ( It failed -it read Failure to invoke Request Filters)
3.Forcibly stopped the Server from Services.msc
V8.5 cellmanager01---stop
V8.5 node01 -stop
4.Tried to Start Server it failed again
Note :
1.command Prompt : Running through Run As Admin.
2.MARXVARS table VARNAME='ADMINRESTART' and 'CONFIGURING' set to OFF and 0 .
Question:
What is the recommended approach to address the requirement to change the scale from 2 to 6 for INVOICELINE.UNITCOST?.
Thanks and Regards,
Swapna