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.
Hi Gang,
We are facing an issue right now. Here are our environment details :
App Server IBM WebSphere Application Server 6.1
Version
Maximo Asset Configuration Manager 7.1.1.1-20111019-1206 Build 20100509-1059 DB Build V7121-06 HFDB Build HF7121-07
Common PMP 7.1.1.6 Build 20091130D DB Build V7116-05
Transportation 7.1.1.0 Build 20091209-0841 DB Build V7120-08
Base Services 7.1.1.6-LA20100907-1248 Build 20091208-1415 DB Build V7116-173 HFDB Build HF7116-12
Server OS Linux 2.6.18-128.el5
When we try to Transfer out the application from Issues and transfers(Tr) application , we select the item, from location, rotating assetnum and from bin. When we try to save the record it gives us the following error :
"BMXAA7094E - The entered value null is not valid. Enter a valid integer value."
Has anyone faced this issue ? We have this issue in production and we are unable to replicate it in other test and development environments even after refreshing it with the production copy of instance and database.
Any suggestions and help will be highly appreciated.
Thanks & regards,
Victor.
It sounds like a logic field is looking for a 0 or 1 value and is trying to
save with a null value.
Kevin
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Victor
Sent: Wednesday, December 07, 2011 8:58 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Issues and Transfers (Tr) : Unable to transfer out
rotating item
Hi Gang,
We are facing an issue right now. Here are our environment details :
App Server IBM WebSphere Application Server 6.1
Version
Maximo Asset Configuration Manager 7.1.1.1-20111019-1206 Build 20100509-1059
DB Build V7121-06 HFDB Build HF7121-07
Common PMP 7.1.1.6 Build 20091130D DB Build V7116-05
Transportation 7.1.1.0 Build 20091209-0841 DB Build V7120-08
Base Services 7.1.1.6-LA20100907-1248 Build 20091208-1415 DB Build V7116-173
HFDB Build HF7116-12
Server OS Linux 2.6.18-128.el5
When we try to Transfer out the application from Issues and transfers(Tr)
application , we select the item, from location, rotating assetnum and from
bin. When we try to save the record it gives us the following error :
"BMXAA7094E - The entered value null is not valid. Enter a valid integer
value."
Has anyone faced this issue ? We have this issue in production and we are
unable to replicate it in other test and development environments even after
refreshing it with the production copy of instance and database.
Any suggestions and help will be highly appreciated.
Thanks & regards,
Victor.
Is this relevant to your setup?
https://www-304.ibm.com/support/docview.wss?uid=swg21418689
It sounds as though it may be related to a missing sequence, depending on
your process to refresh from production the sequences may not be copied
over from one database to another if you are only copying the Maximo schema.
Otherwise... can you enable SQL Logging and capture the actual SQL that is
failing? That would be the best clue in helping to diagnose the issue.
Chris.
On Wed, Dec 7, 2011 at 6:37 PM, Kevin Egolf <kegolf@techopsolutions.net>wrote:
> **
>
>
> It sounds like a logic field is looking for a 0 or 1 value and is trying to
> save with a null value.
>
> Kevin
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Victor
> Sent: Wednesday, December 07, 2011 8:58 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Issues and Transfers (Tr) : Unable to transfer out
> rotating item
>
> Hi Gang,
>
> We are facing an issue right now. Here are our environment details :
>
> App Server IBM WebSphere Application Server 6.1
>
> Version
>
> Maximo Asset Configuration Manager 7.1.1.1-20111019-1206 Build
> 20100509-1059
> DB Build V7121-06 HFDB Build HF7121-07
> Common PMP 7.1.1.6 Build 20091130D DB Build V7116-05
> Transportation 7.1.1.0 Build 20091209-0841 DB Build V7120-08
> Base Services 7.1.1.6-LA20100907-1248 Build 20091208-1415 DB Build
> V7116-173
> HFDB Build HF7116-12
>
> Server OS Linux 2.6.18-128.el5
>
> When we try to Transfer out the application from Issues and transfers(Tr)
> application , we select the item, from location, rotating assetnum and from
> bin. When we try to save the record it gives us the following error :
>
> "BMXAA7094E - The entered value null is not valid. Enter a valid integer
> value."
>
> Has anyone faced this issue ? We have this issue in production and we are
> unable to replicate it in other test and development environments even
> after
> refreshing it with the production copy of instance and database.
>
> Any suggestions and help will be highly appreciated.
>
> Thanks & regards,
> Victor.
>
>
>
>
>
Hi Chris and Kevin,
Thank you for your replies. Actually I am new to the company and they had some interfaces with the receipts which had some processing rules in the publish channel processing class. This class was checking the PONUM on the Transfer out tab and was giving a different maximo error as they handled the exception by calling the Maximo inbuilt error handling methods.
This was prohibiting us to get the proper debugging analysis and solutions from the maximo logs.
This has been resolved now. Thanks again for the inputs :)
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, Chris Lawless <lawlessc@...> wrote:
>
> Is this relevant to your setup?
> https://www-304.ibm.com/support/docview.wss?uid=swg21418689
>
> It sounds as though it may be related to a missing sequence, depending on
> your process to refresh from production the sequences may not be copied
> over from one database to another if you are only copying the Maximo schema.
>
> Otherwise... can you enable SQL Logging and capture the actual SQL that is
> failing? That would be the best clue in helping to diagnose the issue.
>
> Chris.
>
> On Wed, Dec 7, 2011 at 6:37 PM, Kevin Egolf <kegolf@...>wrote:
>
> > **
> >
> >
> > It sounds like a logic field is looking for a 0 or 1 value and is trying to
> > save with a null value.
> >
> > Kevin
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> > Victor
> > Sent: Wednesday, December 07, 2011 8:58 PM
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] Issues and Transfers (Tr) : Unable to transfer out
> > rotating item
> >
> > Hi Gang,
> >
> > We are facing an issue right now. Here are our environment details :
> >
> > App Server IBM WebSphere Application Server 6.1
> >
> > Version
> >
> > Maximo Asset Configuration Manager 7.1.1.1-20111019-1206 Build
> > 20100509-1059
> > DB Build V7121-06 HFDB Build HF7121-07
> > Common PMP 7.1.1.6 Build 20091130D DB Build V7116-05
> > Transportation 7.1.1.0 Build 20091209-0841 DB Build V7120-08
> > Base Services 7.1.1.6-LA20100907-1248 Build 20091208-1415 DB Build
> > V7116-173
> > HFDB Build HF7116-12
> >
> > Server OS Linux 2.6.18-128.el5
> >
> > When we try to Transfer out the application from Issues and transfers(Tr)
> > application , we select the item, from location, rotating assetnum and from
> > bin. When we try to save the record it gives us the following error :
> >
> > "BMXAA7094E - The entered value null is not valid. Enter a valid integer
> > value."
> >
> > Has anyone faced this issue ? We have this issue in production and we are
> > unable to replicate it in other test and development environments even
> > after
> > refreshing it with the production copy of instance and database.
> >
> > Any suggestions and help will be highly appreciated.
> >
> > Thanks & regards,
> > Victor.
> >
> >
> >
> >
> >
>
>
>
>