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 am using Maximo 7.5.0.1
I have a custom table with contains a YORN field called "active"
I have created an Object Launch Point Automation script on this custom table with the Add and Activate check box's selected (Initialize, Update, and Delete are unchecked). I have tried with the Initialize as well but still get the same error message.
When I click on the "New Row" button to add a new record in the application and then select the Active field, I get the following message, "The Boolean field is blank and requires a value BMXAA4118
If I save the new record the active value is saved as 0 (NO)
I have set a value in my script (below) . Can anyone help as to why the value is still blank (as per the error message) on the application screen
from psdi.mbo import MboConstants
if onadd:
print 'New record entered'
mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
print 'Active value: ' + mbo.getString('active')
With the debugger on I get the following in the log file
New record entered
Active value: N
Instead of false use 0 as yorn is stored as smallint.
Basant M Kumar
________________________________
From: whakamaru <whakamaru@yahoo.com.au>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, May 8, 2013 4:55 AM
Subject: [MAXIMO List] Automation Script
I am using Maximo 7.5.0.1
I have a custom table with contains a YORN field called "active"
I have created an Object Launch Point Automation script on this custom table with the Add and Activate check box's selected (Initialize, Update, and Delete are unchecked). I have tried with the Initialize as well but still get the same error message.
When I click on the "New Row" button to add a new record in the application and then select the Active field, I get the following message, "The Boolean field is blank and requires a value BMXAA4118
If I save the new record the active value is saved as 0 (NO)
I have set a value in my script (below) . Can anyone help as to why the value is still blank (as per the error message) on the application screen
from psdi.mbo import MboConstants
if onadd:
print 'New record entered'
mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
print 'Active value: ' + mbo.getString('active')
With the debugger on I get the following in the log file
New record entered
Active value: N
Thanks for the reply. I have already tried that, 0,1 and true and False but get the same result.
It as if the automation script has completed but the screen has not been refreshed.
--- In MAXIMO@yahoogroups.com, Basant M Kumar <mahato01@...> wrote:
>
> Instead of false use 0 as yorn is stored as smallint.
>
> Â
> Basant M Kumar
>
>
> ________________________________
> From: whakamaru <whakamaru@...>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, May 8, 2013 4:55 AM
> Subject: [MAXIMO List] Automation Script
>
>
>
> Â
> I am using Maximo 7.5.0.1
>
> I have a custom table with contains a YORN field called "active"
>
> I have created an Object Launch Point Automation script on this custom table with the Add and Activate check box's selected (Initialize, Update, and Delete are unchecked). I have tried with the Initialize as well but still get the same error message.
>
> When I click on the "New Row" button to add a new record in the application and then select the Active field, I get the following message, "The Boolean field is blank and requires a value BMXAA4118
>
> If I save the new record the active value is saved as 0 (NO)
>
> I have set a value in my script (below) . Can anyone help as to why the value is still blank (as per the error message) on the application screen
>
> from psdi.mbo import MboConstants
>
> if onadd:
> print 'New record entered'
> mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
> print 'Active value: ' + mbo.getString('active')
>
> With the debugger on I get the following in the log file
>
> New record entered
> Active value: N
>
>
>
>
>
>
>
Are you absolutely sure this is the only place you are using the field "ACTIVE" in your automation scripts
You can run
Sql server you might not need the collate depends if your system has case sensitivity turned on
Select * from AUTOSCRIPT where SOURCE like '%ACTIVE%' COLLATE SQL_Latin1_General_CP1_CI_AS
Or oracle I haven't got an oracle database so hope upper works on the source field
Select * from AUTOSCRIPT where upper(SOURCE) like '%ACTIVE%'
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of whakamaru
Sent: 08 May 2013 23:44
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Automation Script
Thanks for the reply. I have already tried that, 0,1 and true and False but get the same result.
It as if the automation script has completed but the screen has not been refreshed.
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Basant M Kumar <mahato01@...> wrote:
>
> Instead of false use 0 as yorn is stored as smallint.
>
> Â
> Basant M Kumar
>
>
> ________________________________
> From: whakamaru <whakamaru@...>
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Sent: Wednesday, May 8, 2013 4:55 AM
> Subject: [MAXIMO List] Automation Script
>
>
>
> Â
> I am using Maximo 7.5.0.1
>
> I have a custom table with contains a YORN field called "active"
>
> I have created an Object Launch Point Automation script on this custom table with the Add and Activate check box's selected (Initialize, Update, and Delete are unchecked). I have tried with the Initialize as well but still get the same error message.
>
> When I click on the "New Row" button to add a new record in the application and then select the Active field, I get the following message, "The Boolean field is blank and requires a value BMXAA4118
>
> If I save the new record the active value is saved as 0 (NO)
>
> I have set a value in my script (below) . Can anyone help as to why the value is still blank (as per the error message) on the application screen
>
> from psdi.mbo import MboConstants
>
> if onadd:
> print 'New record entered'
> mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
> print 'Active value: ' + mbo.getString('active')
>
> With the debugger on I get the following in the log file
>
> New record entered
> Active value: N
>
>
>
>
>
>
>
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.
**************************************************************************************************************
Which patch was it that changed the primary reference to the current mbo
from scriptHome to mbo? Was it 7501 or 7502?
You might want to try...
scriptHome.setValue('ACTIVE',false)
In your script add some more print statements to verify the value of ACTIVE
before you enter, during as well as afterwards. Assuming you are using
Jython is your indentation correct after the If?
print 'Before onAdd Active = ' + scriptHome.getString('active')
if onadd:
print 'New record entered'
scriptHome.setValue('ACTIVE',false)
print 'Active value: ' + scriptHome.getString('active')
or
print 'Before onAdd Active = ' + mbo.getString('active')
if onadd:
print 'New record entered'
mbo.setValue('ACTIVE',false)
print 'Active value: ' + mbo.getString('active')
Chris.
On Thu, May 9, 2013 at 8:19 AM, Ian Wright <ian.wright@gdfsuezep.co.uk>wrote:
> **
>
>
> Are you absolutely sure this is the only place you are using the field
> "ACTIVE" in your automation scripts
>
> You can run
> Sql server you might not need the collate depends if your system has case
> sensitivity turned on
> Select * from AUTOSCRIPT where SOURCE like '%ACTIVE%' COLLATE
> SQL_Latin1_General_CP1_CI_AS
>
> Or oracle I haven't got an oracle database so hope upper works on the
> source field
> Select * from AUTOSCRIPT where upper(SOURCE) like '%ACTIVE%'
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> whakamaru
> Sent: 08 May 2013 23:44
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Automation Script
>
>
> Thanks for the reply. I have already tried that, 0,1 and true and False
> but get the same result.
>
> It as if the automation script has completed but the screen has not been
> refreshed.
>
> --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Basant M
> Kumar <mahato01@...> wrote:
> >
> > Instead of false use 0 as yorn is stored as smallint.
> >
> > �
> > Basant M Kumar
> >
> >
> > ________________________________
> > From: whakamaru <whakamaru@...>
> > To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
>
> > Sent: Wednesday, May 8, 2013 4:55 AM
> > Subject: [MAXIMO List] Automation Script
> >
> >
> >
> > �
> > I am using Maximo 7.5.0.1
> >
> > I have a custom table with contains a YORN field called "active"
> >
> > I have created an Object Launch Point Automation script on this custom
> table with the Add and Activate check box's selected (Initialize, Update,
> and Delete are unchecked). I have tried with the Initialize as well but
> still get the same error message.
> >
> > When I click on the "New Row" button to add a new record in the
> application and then select the Active field, I get the following message,
> "The Boolean field is blank and requires a value BMXAA4118
> >
> > If I save the new record the active value is saved as 0 (NO)
> >
> > I have set a value in my script (below) . Can anyone help as to why the
> value is still blank (as per the error message) on the application screen
> >
> > from psdi.mbo import MboConstants
> >
> > if onadd:
> > print 'New record entered'
> > mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK |
> MboConstants.NOVALIDATION_AND_NOACTION)
> > print 'Active value: ' + mbo.getString('active')
> >
> > With the debugger on I get the following in the log file
> >
> > New record entered
> > Active value: N
> >
> >
> >
> >
> >
> >
> >
>
> 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.
>
> **************************************************************************************************************
>
>
>
>
>
>
I'm just getting started, so take this FWIW, but is there a possibility that a data coversion is occuring within the MBO? So instead of stating No = 0/false, use No = N, like in the UI.
--- In MAXIMO@yahoogroups.com, Ian Wright <ian.wright@...> wrote:
>
> Are you absolutely sure this is the only place you are using the field "ACTIVE" in your automation scripts
>
> You can run
> Sql server you might not need the collate depends if your system has case sensitivity turned on
> Select * from AUTOSCRIPT where SOURCE like '%ACTIVE%' COLLATE SQL_Latin1_General_CP1_CI_AS
>
> Or oracle I haven't got an oracle database so hope upper works on the source field
> Select * from AUTOSCRIPT where upper(SOURCE) like '%ACTIVE%'
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of whakamaru
> Sent: 08 May 2013 23:44
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Automation Script
>
>
>
> Thanks for the reply. I have already tried that, 0,1 and true and False but get the same result.
>
> It as if the automation script has completed but the screen has not been refreshed.
>
> --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Basant M Kumar <mahato01@> wrote:
> >
> > Instead of false use 0 as yorn is stored as smallint.
> >
> > Â
> > Basant M Kumar
> >
> >
> > ________________________________
> > From: whakamaru <whakamaru@>
> > To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> > Sent: Wednesday, May 8, 2013 4:55 AM
> > Subject: [MAXIMO List] Automation Script
> >
> >
> >
> > Â
> > I am using Maximo 7.5.0.1
> >
> > I have a custom table with contains a YORN field called "active"
> >
> > I have created an Object Launch Point Automation script on this custom table with the Add and Activate check box's selected (Initialize, Update, and Delete are unchecked). I have tried with the Initialize as well but still get the same error message.
> >
> > When I click on the "New Row" button to add a new record in the application and then select the Active field, I get the following message, "The Boolean field is blank and requires a value BMXAA4118
> >
> > If I save the new record the active value is saved as 0 (NO)
> >
> > I have set a value in my script (below) . Can anyone help as to why the value is still blank (as per the error message) on the application screen
> >
> > from psdi.mbo import MboConstants
> >
> > if onadd:
> > print 'New record entered'
> > mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
> > print 'Active value: ' + mbo.getString('active')
> >
> > With the debugger on I get the following in the log file
> >
> > New record entered
> > Active value: N
> >
> >
> >
> >
> >
> >
> >
>
>
> 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.
> **************************************************************************************************************
>
>
>
>
>
Do you have a Default value set to 0 in Database Configuration? You don't need an AutoScript for this.
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
>
> I'm just getting started, so take this FWIW, but is there a possibility that a data coversion is occuring within the MBO? So instead of stating No = 0/false, use No = N, like in the UI.
>
>
>
> --- In MAXIMO@yahoogroups.com, Ian Wright <ian.wright@> wrote:
> >
> > Are you absolutely sure this is the only place you are using the field "ACTIVE" in your automation scripts
> >
> > You can run
> > Sql server you might not need the collate depends if your system has case sensitivity turned on
> > Select * from AUTOSCRIPT where SOURCE like '%ACTIVE%' COLLATE SQL_Latin1_General_CP1_CI_AS
> >
> > Or oracle I haven't got an oracle database so hope upper works on the source field
> > Select * from AUTOSCRIPT where upper(SOURCE) like '%ACTIVE%'
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of whakamaru
> > Sent: 08 May 2013 23:44
> > To: MAXIMO@yahoogroups.com
> > Subject: Re: [MAXIMO List] Automation Script
> >
> >
> >
> > Thanks for the reply. I have already tried that, 0,1 and true and False but get the same result.
> >
> > It as if the automation script has completed but the screen has not been refreshed.
> >
> > --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, Basant M Kumar <mahato01@> wrote:
> > >
> > > Instead of false use 0 as yorn is stored as smallint.
> > >
> > > Â
> > > Basant M Kumar
> > >
> > >
> > > ________________________________
> > > From: whakamaru <whakamaru@>
> > > To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> > > Sent: Wednesday, May 8, 2013 4:55 AM
> > > Subject: [MAXIMO List] Automation Script
> > >
> > >
> > >
> > > Â
> > > I am using Maximo 7.5.0.1
> > >
> > > I have a custom table with contains a YORN field called "active"
> > >
> > > I have created an Object Launch Point Automation script on this custom table with the Add and Activate check box's selected (Initialize, Update, and Delete are unchecked). I have tried with the Initialize as well but still get the same error message.
> > >
> > > When I click on the "New Row" button to add a new record in the application and then select the Active field, I get the following message, "The Boolean field is blank and requires a value BMXAA4118
> > >
> > > If I save the new record the active value is saved as 0 (NO)
> > >
> > > I have set a value in my script (below) . Can anyone help as to why the value is still blank (as per the error message) on the application screen
> > >
> > > from psdi.mbo import MboConstants
> > >
> > > if onadd:
> > > print 'New record entered'
> > > mbo.setValue('ACTIVE',False,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
> > > print 'Active value: ' + mbo.getString('active')
> > >
> > > With the debugger on I get the following in the log file
> > >
> > > New record entered
> > > Active value: N
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > 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.
> > **************************************************************************************************************
> >
> >
> >
> >
> >
>