Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
9 replies Latest Post - ‏2012-11-19T21:55:43Z by gonzalo.alvarez
gonzalo.alvarez
gonzalo.alvarez
23 Posts
ACCEPTED ANSWER

Pinned topic BPM 7.5.1. Standard - Databases scripts not generated

‏2012-08-22T22:34:50Z |
Hello,
I've installed BPM 7.5.1 Standard in Linux 64 bit and created a Process Center Deployment Manager profile but the databases scripts where not generated in the profile_root/dbscripts/* directory.

I also tried generating the scripts with the DbDesignGenerator.sh tool, but in the third step I just receive these entries, but not the Common Database:

(1)BPM_ProcessServer BPM_ProcessServer : master status = not complete
(2)BPM_PerformanceDW BPM_PerformanceDW : status = not complete
(3)SibMe BPM_PerformanceDW_ME : status = not complete
(4)SibMe BPM_ProcessServer_ME : status = not complete
(5)save and exit

Is there anything wrong or this profile doesn't need any Common Database at all, I'm planning to create a Remote Messaging and Remote Support topology.

The response file that I used to create the profile was:

create
serverType=DEPLOYMENT_MANAGER
templatePath=/opt/IBM/WebSphere/AppServer/profileTemplates/BPM/dmgr.procctr
profileName=DmgrProcCenter
hostName=Dmgr.PC.host1
cellName=ProcCenter
nodeName=NodeDmgrProcCenter
enableAdminSecurity=true
adminUserName=admin
adminPassword=admin
profilePath=/opt/IBM/WebSphere/AppServer/profiles/DmgrProcCenter
dbType=DB2_UNIVERSAL
dbServerPort=50003
dbCreateNew=false
dbName=CMNDBC
dbUserId=db2admin
dbPassword=db2admin
dbHostName=db2host
dbJDBCClasspath=/opt/IBM/WebSphere/AppServer/jdbcdrivers/DB2

Regards,

--
Gonzalo Alvarez Flores
Follow the white rabbit...
Updated on 2012-11-19T21:55:43Z at 2012-11-19T21:55:43Z by gonzalo.alvarez
  • vlit
    vlit
    922 Posts
    ACCEPTED ANSWER

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-23T05:59:54Z  in response to gonzalo.alvarez
    Hi,

    I think these scripts will be created after creating of first PCenter's node (PC managed profile).
    Because BPM DB and PDW DB names are setting in that moment.

    Vladlen.
    • gonzalo.alvarez
      gonzalo.alvarez
      23 Posts
      ACCEPTED ANSWER

      Re: BPM 7.5.1. Standard - Databases scripts not generated

      ‏2012-08-23T14:53:25Z  in response to vlit
      Thank you for your answer Vladlen, but I created the Process Center Managed Profile and the db scripts were not generated. And I'm having the same result with the DbDesignGenerator.sh script.

      Regards,

      --
      Gonzalo Alvarez Flores
      Follow the white rabbit...
      • vlit
        vlit
        922 Posts
        ACCEPTED ANSWER

        Re: BPM 7.5.1. Standard - Databases scripts not generated

        ‏2012-08-23T15:10:28Z  in response to gonzalo.alvarez
        Try -dbDelayConfig true key for DM creating

        Vladlen.
        • gonzalo.alvarez
          gonzalo.alvarez
          23 Posts
          ACCEPTED ANSWER

          Re: BPM 7.5.1. Standard - Databases scripts not generated

          ‏2012-08-23T15:55:44Z  in response to vlit
          Tried dbDelayConfig=true but, no db scripts generated. Any other clue?

          --
          Gonzalo Alvarez Flores
          Follow the white rabbit...
          • vlit
            vlit
            922 Posts
            ACCEPTED ANSWER

            Re: BPM 7.5.1. Standard - Databases scripts not generated

            ‏2012-08-24T15:41:26Z  in response to gonzalo.alvarez
            Gonzalo, have you got anything in <was_root>\dbscripts? If yes, what permission on them?

            Vladlen.
            • gonzalo.alvarez
              gonzalo.alvarez
              23 Posts
              ACCEPTED ANSWER

              Re: BPM 7.5.1. Standard - Databases scripts not generated

              ‏2012-08-24T16:03:35Z  in response to vlit
              Yes,

              drwxr-xr-x 4 root root 4096 Aug 21 18:18 dbscripts

              Inside dbscriots I have:
              drwxr-xr-x 6 root root 4096 Aug 21 18:18 PerformanceDW
              drwxr-xr-x 6 root root 4096 Aug 21 18:18 ProcessServer

              And inside DB2 I have:
              1. ls -l dbscripts/ProcessServer/DB2
              total 344
              -rwxr-xr-x 1 root root 1130 Aug 21 18:18 admin_Data_ProcessServer.sql
              -rwxr-xr-x 1 root root 1451 Aug 21 18:18 admin_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 983 Aug 21 18:18 admin_RefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 1021 Aug 21 18:18 bpmAuthor_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 836 Aug 21 18:18 createDatabase.sql
              -rwxr-xr-x 1 root root 11751 Aug 21 18:18 createProcedure_ProcessServer.sql
              -rwxr-xr-x 1 root root 202506 Aug 21 18:20 createTable_ProcessServer.sql
              -rwxr-xr-x 1 root root 1315 Aug 21 18:18 twadmin_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 1019 Aug 21 18:18 twauthor_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 1032 Aug 21 18:18 twportaladmin_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 917 Aug 21 18:18 twuser_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 923 Aug 21 18:18 twwebservice_GroupMemberRefData_ProcessServer.sql
              -rwxr-xr-x 1 root root 85274 Aug 21 18:20 wle_upgradeSchema_ProcessServer.sql
              1. ls -l dbscripts/PerformanceDW/DB2
              total 40
              -rwxr-xr-x 1 root root 836 Aug 21 18:18 createDatabase.sql
              -rwxr-xr-x 1 root root 23936 Aug 21 18:20 createTable_PerformanceDW.sql
              -rwxr-xr-x 1 root root 10152 Aug 21 18:20 wle_upgradeSchema_PerformanceDW.sql
              --
              Gonzalo Alvarez Flores
              Follow the white rabbit...
  • agouz
    agouz
    49 Posts
    ACCEPTED ANSWER

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-11-19T19:05:17Z  in response to gonzalo.alvarez
    Hello there, I am facing the same issue here, did you manage to solve it ?
  • agouz
    agouz
    49 Posts
    ACCEPTED ANSWER

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-11-19T21:21:28Z  in response to gonzalo.alvarez
    The scripts were generated after the creation of the deployment environment.
    Not all the databases though, the "MEDB" is still missing.

    just wanted to share.
    • gonzalo.alvarez
      gonzalo.alvarez
      23 Posts
      ACCEPTED ANSWER

      Re: BPM 7.5.1. Standard - Databases scripts not generated

      ‏2012-11-19T21:55:43Z  in response to agouz
      I was using BPM 7.5.1 Standard, for the Standard version there are just 3 databases for Process Center and 3 databases for Process Server.
      I was expecting for more, but they're just available in the Advanced version.

      The databases for Standard are:
      BPMDB
      PDWDB
      MEDB

      Regards,

      --
      Gonzalo Alvarez Flores
      Follow the white rabbit...