This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
Anyone come across this before
Maximo 7.5
Sql server
Rgds Ian
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Did you set a default value in database config?
On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@gdfsuezep.co.uk> wrote:
> I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> Anyone come across this before
>
> Maximo 7.5
> Sql server
>
> Rgds Ian
>
> GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
>
> **************************************************************************************************************
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system manager.
> **************************************************************************************************************
>
>
>
>
Yes I have checked and both the wpitem and wpmaterial both show have a zero
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: 27 November 2012 15:55
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] YORN field problem
Did you set a default value in database config?
On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@gdfsuezep.co.uk<mailto:ian.wright%40gdfsuezep.co.uk>> wrote:
> I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> Anyone come across this before
>
> Maximo 7.5
> Sql server
>
> Rgds Ian
>
> GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
>
> **************************************************************************************************************
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system manager.
> **************************************************************************************************************
>
>
>
>
Try running the following query to ensure each object has a defaultvalue set (replace 'YORNFIELD' with your attributename):
select * from maxattribute where (sameasobject = 'WPITEM' and sameasattribute = 'YORNFIELD') or
(objectname = 'WPITEM' and attributename = 'YORNFIELD')
You should get at least four rows returned (objects: WPITEM, WPMATERIAL, WPSERVICE, WPTOOL). Take a look at each row, and look for anything else out of the norm, versus the other rows. If something doesn't look right, take the appropriate action to correct (if the system will let you); otherwise, it may be easier to delete the attribute and re-add it.
Hope this helps.
Richard
--- In MAXIMO@yahoogroups.com, Ian Wright <ian.wright@...> wrote:
>
> Yes I have checked and both the wpitem and wpmaterial both show have a zero
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
> Sent: 27 November 2012 15:55
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] YORN field problem
>
>
>
> Did you set a default value in database config?
>
> On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@...<mailto:ian.wright%40gdfsuezep.co.uk>> wrote:
>
> > I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> > When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> > Anyone come across this before
> >
> > Maximo 7.5
> > Sql server
> >
> > Rgds Ian
> >
> > GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
> >
> > **************************************************************************************************************
> > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> > If you have received this email in error please notify the system manager.
> > **************************************************************************************************************
> >
> >
> >
> >
>
>
>
>
>
>
>
Thanks I had already looked and there aren't any differences between the records :(
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of richard_almendarez
Sent: 28 November 2012 14:34
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] YORN field problem
Try running the following query to ensure each object has a defaultvalue set (replace 'YORNFIELD' with your attributename):
select * from maxattribute where (sameasobject = 'WPITEM' and sameasattribute = 'YORNFIELD') or
(objectname = 'WPITEM' and attributename = 'YORNFIELD')
You should get at least four rows returned (objects: WPITEM, WPMATERIAL, WPSERVICE, WPTOOL). Take a look at each row, and look for anything else out of the norm, versus the other rows. If something doesn't look right, take the appropriate action to correct (if the system will let you); otherwise, it may be easier to delete the attribute and re-add it.
Hope this helps.
Richard
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Ian Wright <ian.wright@...<mailto:ian.wright@...>> wrote:
>
> Yes I have checked and both the wpitem and wpmaterial both show have a zero
>
> From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Chris Lawless
> Sent: 27 November 2012 15:55
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Subject: Re: [MAXIMO List] YORN field problem
>
>
>
> Did you set a default value in database config?
>
> On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@...<mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright@...%3cmailto:ian.wright%40gdfsuezep.co.uk>>> wrote:
>
> > I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> > When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> > Anyone come across this before
> >
> > Maximo 7.5
> > Sql server
> >
> > Rgds Ian
> >
> > GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
> >
> > **************************************************************************************************************
> > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> > If you have received this email in error please notify the system manager.
> > **************************************************************************************************************
> >
> >
> >
> >
>
>
>
>
>
>
>
Check to make sure there isn't whitespace before the 0 ?
'0' opposed to ' 0'
Make sure it's a 0 and not an O
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: Wednesday, November 28, 2012 12:49 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] YORN field problem
Thanks I had already looked and there aren't any differences between the records :(
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of richard_almendarez
Sent: 28 November 2012 14:34
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] YORN field problem
Try running the following query to ensure each object has a defaultvalue set (replace 'YORNFIELD' with your attributename):
select * from maxattribute where (sameasobject = 'WPITEM' and sameasattribute = 'YORNFIELD') or
(objectname = 'WPITEM' and attributename = 'YORNFIELD')
You should get at least four rows returned (objects: WPITEM, WPMATERIAL, WPSERVICE, WPTOOL). Take a look at each row, and look for anything else out of the norm, versus the other rows. If something doesn't look right, take the appropriate action to correct (if the system will let you); otherwise, it may be easier to delete the attribute and re-add it.
Hope this helps.
Richard
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>, Ian Wright <ian.wright@...<mailto:ian.wright@...<mailto:ian.wright@...%3cmailto:ian.wright@...>>> wrote:
>
> Yes I have checked and both the wpitem and wpmaterial both show have a zero
>
> From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Chris Lawless
> Sent: 27 November 2012 15:55
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>
> Subject: Re: [MAXIMO List] YORN field problem
>
>
>
> Did you set a default value in database config?
>
> On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@...<mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright@...%3cmailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright@...%3cmailto:ian.wright%40gdfsuezep.co.uk%3cmailto:ian.wright@...%3cmailto:ian.wright%40gdfsuezep.co.uk>>>> wrote:
>
> > I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> > When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> > Anyone come across this before
> >
> > Maximo 7.5
> > Sql server
> >
> > Rgds Ian
> >
> > GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
> >
> > **************************************************************************************************************
> > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> > If you have received this email in error please notify the system manager.
> > **************************************************************************************************************
> >
> >
> >
> >
>
>
>
>
>
>
>
Might be worth trying a default value in app designer... shoddy be necessary but it's worth a try.
Sent from my iPad
On Nov 28, 2012, at 9:49 AM, Ian Wright <ian.wright@gdfsuezep.co.uk> wrote:
> Thanks I had already looked and there aren't any differences between the records :(
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of richard_almendarez
> Sent: 28 November 2012 14:34
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] YORN field problem
>
> Try running the following query to ensure each object has a defaultvalue set (replace 'YORNFIELD' with your attributename):
>
> select * from maxattribute where (sameasobject = 'WPITEM' and sameasattribute = 'YORNFIELD') or
> (objectname = 'WPITEM' and attributename = 'YORNFIELD')
>
> You should get at least four rows returned (objects: WPITEM, WPMATERIAL, WPSERVICE, WPTOOL). Take a look at each row, and look for anything else out of the norm, versus the other rows. If something doesn't look right, take the appropriate action to correct (if the system will let you); otherwise, it may be easier to delete the attribute and re-add it.
>
> Hope this helps.
>
> Richard
>
> --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Ian Wright <ian.wright@...<mailto:ian.wright@...>> wrote:
> >
> > Yes I have checked and both the wpitem and wpmaterial both show have a zero
> >
> > From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Chris Lawless
> > Sent: 27 November 2012 15:55
> > To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> > Subject: Re: [MAXIMO List] YORN field problem
> >
> >
> >
> > Did you set a default value in database config?
> >
> > On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@...<mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright@...%3cmailto:ian.wright%40gdfsuezep.co.uk>>> wrote:
> >
> > > I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> > > When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> > > Anyone come across this before
> > >
> > > Maximo 7.5
> > > Sql server
> > >
> > > Rgds Ian
> > >
> > > GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
> > >
> > > **************************************************************************************************************
> > > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> > > If you have received this email in error please notify the system manager.
> > > **************************************************************************************************************
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
Hi Ian,
Please add that new column(persistent0 from the WPMaterial table, automaitcally it will add under the WPITEM table, after that you won't face the below problem. Pelase try this once.
From
Sriram S
________________________________
From: Ian Wright <ian.wright@gdfsuezep.co.uk>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Tuesday, 27 November 2012 7:41 PM
Subject: [MAXIMO List] YORN field problem
I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
Anyone come across this before
Maximo 7.5
Sql server
Rgds Ian
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Hi Ian,
I believe that you would have marked the new attribute as required through the database config and left the default value as blank. If that is the case in the database config set the default value as 0 for the new attribute you added, save and do a non-structural db config.
Regards,
Mahesh
Sent from my iPad
On Nov 28, 2012, at 12:49 PM, Ian Wright <ian.wright@gdfsuezep.co.uk> wrote:
> Thanks I had already looked and there aren't any differences between the records :(
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of richard_almendarez
> Sent: 28 November 2012 14:34
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] YORN field problem
>
> Try running the following query to ensure each object has a defaultvalue set (replace 'YORNFIELD' with your attributename):
>
> select * from maxattribute where (sameasobject = 'WPITEM' and sameasattribute = 'YORNFIELD') or
> (objectname = 'WPITEM' and attributename = 'YORNFIELD')
>
> You should get at least four rows returned (objects: WPITEM, WPMATERIAL, WPSERVICE, WPTOOL). Take a look at each row, and look for anything else out of the norm, versus the other rows. If something doesn't look right, take the appropriate action to correct (if the system will let you); otherwise, it may be easier to delete the attribute and re-add it.
>
> Hope this helps.
>
> Richard
>
> --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Ian Wright <ian.wright@...<mailto:ian.wright@...>> wrote:
> >
> > Yes I have checked and both the wpitem and wpmaterial both show have a zero
> >
> > From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Chris Lawless
> > Sent: 27 November 2012 15:55
> > To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> > Subject: Re: [MAXIMO List] YORN field problem
> >
> >
> >
> > Did you set a default value in database config?
> >
> > On Nov 27, 2012, at 7:41 AM, Ian Wright <ian.wright@...<mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright@...%3cmailto:ian.wright%40gdfsuezep.co.uk>>> wrote:
> >
> > > I have created a YORN field on wpitem and added the field to the planned material (WPMATERIAL) work order screen
> > > When I add a record the screen complains saying a value is needed I have to check and uncheck the field before it will let me save
> > > Anyone come across this before
> > >
> > > Maximo 7.5
> > > Sql server
> > >
> > > Rgds Ian
> > >
> > > GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
> > >
> > > **************************************************************************************************************
> > > This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
> > > If you have received this email in error please notify the system manager.
> > > **************************************************************************************************************
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>