Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  MAS8.7 issue with DB2

    Posted 01/05/24 07:52 AM

    Hi Guys,
    we just trying to run an action(class) file using workflow designer(it have some SQL execution segments). we got some irrelevant errors in logs related with DB2.

    we don't know what is DEVDEVMANAGEDB schema and where it is coming from. any help will be useful

     SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DEVDEVMANAGEDB.PR, DRIVER=4.32.28

    ===========================

    [1/5/24, 12:37:19:115 GMT] 00001b56 SystemOut                                                    O 1111
[1/5/24, 12:37:20:142 GMT] 00001b56 SystemErr                                                    R com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DEVDEVMANAGEDB.PR, DRIVER=4.32.28
[1/5/24, 12:37:20:143 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.b7.a(b7.java:810)
[1/5/24, 12:37:20:143 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.b7.a(b7.java:66)
[1/5/24, 12:37:20:143 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.b7.a(b7.java:140)
[1/5/24, 12:37:20:143 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.c(lc.java:2868)
[1/5/24, 12:37:20:143 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.d(lc.java:2852)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.a(lc.java:2278)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.t4.ab.i(ab.java:204)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.t4.ab.b(ab.java:94)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.t4.p.a(p.java:32)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.t4.av.i(av.java:150)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.al(lc.java:2247)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.a(lc.java:3376)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.e(lc.java:1138)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr                                                    R 	at com.ibm.db2.jcc.am.lc.execute(lc.java:1117)
[1/5/24, 12:37:20:144 GMT] 00001b56 SystemErr
    ====================================================


    ------------------------------
    ---------------------------
    Karthik Krishnamurthy
    ---------------------------
    ------------------------------


  • 2.  RE: MAS8.7 issue with DB2

    Posted 01/09/24 12:29 AM

    Hi Karthik,

    Try checking this system property on Manage mxe.db.schemaowner. You can also edit the database settings on MAS Administration for the deployed Manage and check the schema.

    If the schema param wasn't provided during the installation, it would use the default value maximo.



    ------------------------------
    Maycon Belfort
    Consultant
    BPD Zenith
    Melbourne
    Australia
    ------------------------------



Related Content