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.
Maximo 7.5 - DB2 10.1 - WebSphere
I am getting the following error when inserting a new work order (in any application that uses the WORKORDER object). All other applications work fine on insert.
I am hoping someone might have an idea?
BMXAA7136E - Validation failed when the database default values were set. See the associated message for more information.
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
1 st question have you changed anything
2nd look in your log it will probably tell you something – looks like either a mandatory field isn’t being set or a wrong value is being placed in the field
Log path is normally like this
\\servername\e$\apps\ibm\WebSphere\AppServer\profiles\ctgAppSrv01\logs\MXServer
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 02 February 2014 19:16
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Help with error when inserting new workorder
Maximo 7.5 - DB2 10.1 - WebSphere
I am getting the following error when inserting a new work order (in any application that uses the WORKORDER object). All other applications work fine on insert.
I am hoping someone might have an idea?
BMXAA7136E - Validation failed when the database default values were set. See the associated message for more information.
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
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.
**************************************************************************************************************
Watch out on DB2 - it's very picky - if a field is defined wrong, it won't make an "implicit" conversion as you might see in SQL Server or Oracle...
As Ian noted - your logs should have more information as exactly what is going wrong...
R/
Will
Sent from my iPhone
On Feb 3, 2014, at 3:44, "Ian Wright" <ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>> wrote:
1 st question have you changed anything
2nd look in your log it will probably tell you something - looks like either a mandatory field isn't being set or a wrong value is being placed in the field
Log path is normally like this
\\servername\e$\apps\ibm\WebSphere\AppServer\profiles\ctgAppSrv01\logs\MXServer
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com<mailto:mlevinson@ledgesoft.com>
Sent: 02 February 2014 19:16
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] Help with error when inserting new workorder
Maximo 7.5 - DB2 10.1 - WebSphere
I am getting the following error when inserting a new work order (in any application that uses the WORKORDER object). All other applications work fine on insert.
I am hoping someone might have an idea?
BMXAA7136E - Validation failed when the database default values were set. See the associated message for more information.
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
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 Ian & Will,
I have carefully reviewed a known working configuration of the MAXATTRIBUTCFG object and compared the"default" values for all attributes to my "non-working" configuration and fail to see any issues.
I have uploaded the comparison file here if either of you have a chance to have a look.
https://www.dropbox.com/sh/0t5vds5bej4a9m5/2ne18yd41o
I am waiting (rather impatiently) for the administrator to give me access to the box with the log files. In the mean time I am doing everything I can to identify the problem. Since this error occurs in any application accessing the workorder object I have decided this must be a problem with the configuration of the object and not a particular application.
I certainly appreciate your responses and hope that i can get to the bottom of this. Of course it happens at the most inconvenient time as I have a demo today at 1:00PM.
I thought I would add the following findings.
When I try and update an existing record (description field) I get the following error:
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
If i wait exactly 1 minute (yes I timed it) the record saves just fine. This is getting stranger and stranger.........
Have you got access to the database
You could try
Update workorder set description = description concat ’.’ where wonum = ‘your wonum’ and site = ‘your site’
commit
just to eliminate the database
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 03 February 2014 13:22
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: Help with error when inserting new workorder
I thought I would add the following findings.
When I try and update an existing record (description field) I get the following error:
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
If i wait exactly 1 minute (yes I timed it) the record saves just fine. This is getting stranger and stranger.........
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.
**************************************************************************************************************
So you search for.a WO, open it up, change he description then... get this error when you tab out of the description field or when you save? If you modify a different field does the same thing happen? Do you have any automation scripts? Chris.
On February 3, 2014 at 8:21:57 AM EST, mlevinson@ledgesoft.com wrote: I thought I would add the following findings.When I try and update an existing record (description field) I get the following error: BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure. If i wait exactly 1 minute (yes I timed it) the record saves just fine. This is getting stranger and stranger.........
If you do have scriptd Goto dbconfig set admin mode on – this will turn off all automation scripts
Then try the description change again
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: 03 February 2014 13:29
To: MAXIMO
Subject: [MAXIMO List] RE: Help with error when inserting new workorder
So you search for.a WO, open it up, change he description then... get this error when you tab out of the description field or when you save?
If you modify a different field does the same thing happen?
Do you have any automation scripts?
Chris.
On February 3, 2014 at 8:21:57 AM EST, mlevinson@ledgesoft.com<mailto:mlevinson@ledgesoft.com> wrote:
I thought I would add the following findings.
When I try and update an existing record (description field) I get the following error:
BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, ask the System Administrator to review the log files for the application and database server to identify the source of the failure.
If i wait exactly 1 minute (yes I timed it) the record saves just fine. This is getting stranger and stranger.........
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.
**************************************************************************************************************
Ian,
Worked perfectly. added a '.' to my description with no problem
Also, looks like there's an existing issue reported to IBM with that error code you provided http://www-01.ibm.com/support/docview.wss?uid=swg21591153
Could try the steps tech support outlined to resolve.
-Luke
On Feb 3, 2014, at 8:32 AM, <mlevinson@ledgesoft.com> wrote:
> Ian,
>
>
>
> Worked perfectly. added a '.' to my description with no problem
>
>
So were you getting the error as you leave the field or on save? This should point you toward a script on WORKORDER with an object launch point (save) or attribute launch point (tabbing out). As was mentioned earlier logs are very helpful things to have access to...! Chris,
On February 3, 2014 at 8:32:43 AM EST, mlevinson@ledgesoft.com wrote: Ian, Worked perfectly. added a '.' to my description with no problem
Luke, Ian, Will
Luke may be on to something here. When I looked at the views using SQL Maestro I see of bunch of the views are red in color. In addition I started looking and there is no WOACTIVITY view!!! How could this happen and what would be your recommendation? Take lukes suggestion and delete the rowstamp for views that show up red and then try and recreate any missing views?
What happened to my views aggrrrr. I want my Oracle back!!!!!
So what was the last change anyone made to the system
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.
**************************************************************************************************************
Chris,
The error happens on save of the work order, tabbing out produces no error.
I had a single automation script that was in draft status. I have deleted it to remove that possibility.
Ian,
I am the only one working in this system. The last change that I made was following this post.
https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/server_round_trips_taking_too_long10?lang=en
I have since changed the values back to the Maximo defaults. Restarted the app server and even rebuilt the ears as a last ditch effort.
Chris,
I know the log files would be extremely useful, but since the admin does not answer emails on the weekend and get in the office at who knows what time, I am sort of flying without any controls. I have expressed the urgency and am waiting.
Ian,
I set the admin mode to "on" and tried again, but it produced the same error.
A bit more information:
I can see the WOACTIVITY view in DBCCONFIG but not in my SQL tool "SQL Maestro"
When you say can’t see it do you mean can’t select from it
i.e
select * from woactivity
returns an error ?
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 03 February 2014 14:17
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: Help with error when inserting new workorder
A bit more information:
I can see the WOACTIVITY view in DBCCONFIG but not in my SQL tool "SQL Maestro"
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.
**************************************************************************************************************
Ian,
The WOACTIVITY view did not exist. I recreated the view using my SQL tool and can now select from it.
i.e
select * from WOACTIVITY
When I compare another working Maximo instance (Oracle) I see views that are not present in my DB2 instance, and I cannot "Select *" from any of them.
i.e
(complete list of missing views)
plusgact
plusgdrl
plumimprove
plusgmoc
plusgmocreq
unassignedworkview
wmassignment
wochange
worelease
If I recreate these views do I need to restart the DB or app server to have these changes take effect?
I can’t say for certain but it wouldn’t hurt
I don’t know much about DB2 but just before re-creating them can you check in database config that the storage partitions are the same for woactivity and workorder
Its very strange that the views have gone
I couldn’t get to the lbm link it just times out but I’m presuming it was something quite benign
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of mlevinson@ledgesoft.com
Sent: 03 February 2014 15:34
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] RE: Help with error when inserting new workorder
Ian,
The WOACTIVITY view did not exist. I recreated the view using my SQL tool and can now select from it.
i.e
select * from WOACTIVITY
When I compare another working Maximo instance (Oracle) I see views that are not present in my DB2 instance, and I cannot "Select *" from any of them.
i.e
(complete list of missing views)
plusgact
plusgdrl
plumimprove
plusgmoc
plusgmocreq
unassignedworkview
wmassignment
wochange
worelease
If I recreate these views do I need to restart the DB or app server to have these changes take effect?
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.
**************************************************************************************************************
Finally got access to the log files.
they are located here:
https://www.dropbox.com/sh/0t5vds5bej4a9m5/2ne18yd41o
Friday night they ran the DB2 tuning script:
\ibm\SMP\scripts\database\db2tuning.cmd.
I am not sure if the missing views are related to this? But just after this is when the problems started occurring.
Just a followup and closure on this issue. It looks as if the missing views were the culprit. After recreating the missing views all works as expected.
Thank you so much to all those that helped. I wish I had a way to return the favor!!!