Topic
  • 8 replies
  • Latest Post - ‏2013-05-17T02:04:30Z by Nakita
Nakita
Nakita
5 Posts

Pinned topic updatedb Maximo 7.5.1 gas and oil error

‏2013-05-13T09:52:50Z |

Hi All

When I run command updatedb for maximo 7.51. gas and oil. It's errors. Please review attach file. Can you help me! 

Attachments

  • Ana Paula Brambila
    Ana Paula Brambila
    3 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-14T18:57:49Z  

    Hi!

    What is the version of Maximo Base Services?

  • Nakita
    Nakita
    5 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-15T02:00:58Z  

    Hi!

    What is the version of Maximo Base Services?

    Hi Ana

     

    I'm using Maximo 7.5. Infact, I want to install Maximo gas and oil. I were install middleware with Websphere, DB2 with empty database. And then I were install Maximo and gas. I were checked Defer maximo application redeployment , defer the update of the maximo database. It were reconfiguration later. With step re-install summary, it will error. Please review attach picture.

    Attachments

    Updated on 2013-05-15T02:09:25Z at 2013-05-15T02:09:25Z by Nakita
  • Pramod kumar
    Pramod kumar
    3 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-15T06:58:14Z  

    Hi,

    Please check this file V7510_02 for SQL statements there may some syntax error after below statement.

    insert into maxlabels (value,app,id,property,maxlabelsid) values ('Go To','MENUS','plusglocations_5','label', 1572063);

     and run updatedb again

    Updated on 2013-05-15T06:58:53Z at 2013-05-15T06:58:53Z by Pramod kumar
  • Nakita
    Nakita
    5 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-15T07:13:49Z  

    Hi,

    Please check this file V7510_02 for SQL statements there may some syntax error after below statement.

    insert into maxlabels (value,app,id,property,maxlabelsid) values ('Go To','MENUS','plusglocations_5','label', 1572063);

     and run updatedb again

    Hi Kumar

     

    You are missing 1 parameter: Rowstamp. How to insert?

  • Pramod kumar
    Pramod kumar
    3 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-15T07:23:16Z  
    • Nakita
    • ‏2013-05-15T07:13:49Z

    Hi Kumar

     

    You are missing 1 parameter: Rowstamp. How to insert?

    No no..

    In Updatedb log file which you have attached  there are so may insert and other sql statements are running ,But error is comming after this below statement which I  have mentioned ..

    so please go in to this file( V7510_02 )  and search for  this statement and there must be one statemet which is running after this statement which is throughing error and for syntax error.

    search in file V7510_02
    insert into maxlabels (value,app,id,property,maxlabelsid) values ('Go To','MENUS','plusglocations_5','label', 1572063);

    Attachments

  • Ana Paula Brambila
    Ana Paula Brambila
    3 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-15T11:49:11Z  
    • Nakita
    • ‏2013-05-15T02:00:58Z

    Hi Ana

     

    I'm using Maximo 7.5. Infact, I want to install Maximo gas and oil. I were install middleware with Websphere, DB2 with empty database. And then I were install Maximo and gas. I were checked Defer maximo application redeployment , defer the update of the maximo database. It were reconfiguration later. With step re-install summary, it will error. Please review attach picture.

    Hi Nakita,

    Before installing Maximo Oil and Gas 7.5.1 you need to install Maximo Base Services 7.5.0.4. As you are using Maximo 7.5, there was one method not found during updatedb, what caused the error.

    Thanks!

    Ana

  • Nakita
    Nakita
    5 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-17T02:02:12Z  

    Hi Nakita,

    Before installing Maximo Oil and Gas 7.5.1 you need to install Maximo Base Services 7.5.0.4. As you are using Maximo 7.5, there was one method not found during updatedb, what caused the error.

    Thanks!

    Ana

    Hi Ana

     

    Great! It's succesful. Thanks so much! Do you have skype Id? Can you give for me? We can exchange technology of Maximo!

  • Nakita
    Nakita
    5 Posts

    Re: updatedb Maximo 7.5.1 gas and oil error

    ‏2013-05-17T02:04:30Z  

    No no..

    In Updatedb log file which you have attached  there are so may insert and other sql statements are running ,But error is comming after this below statement which I  have mentioned ..

    so please go in to this file( V7510_02 )  and search for  this statement and there must be one statemet which is running after this statement which is throughing error and for syntax error.

    search in file V7510_02
    insert into maxlabels (value,app,id,property,maxlabelsid) values ('Go To','MENUS','plusglocations_5','label', 1572063);

    Hi Kumar

     

    You don't understand my problem. Thanks for your reply.