Topic
  • 9 replies
  • Latest Post - ‏2012-11-19T21:55:43Z by gonzalo.alvarez
gonzalo.alvarez
gonzalo.alvarez
23 Posts

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
    924 Posts

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-23T05:59:54Z  
    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

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-23T14:53:25Z  
    • vlit
    • ‏2012-08-23T05:59:54Z
    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.
    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
    924 Posts

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-23T15:10:28Z  
    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...
    Try -dbDelayConfig true key for DM creating

    Vladlen.
  • gonzalo.alvarez
    gonzalo.alvarez
    23 Posts

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-23T15:55:44Z  
    • vlit
    • ‏2012-08-23T15:10:28Z
    Try -dbDelayConfig true key for DM creating

    Vladlen.
    Tried dbDelayConfig=true but, no db scripts generated. Any other clue?

    --
    Gonzalo Alvarez Flores
    Follow the white rabbit...
  • vlit
    vlit
    924 Posts

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-24T15:41:26Z  
    Tried dbDelayConfig=true but, no db scripts generated. Any other clue?

    --
    Gonzalo Alvarez Flores
    Follow the white rabbit...
    Gonzalo, have you got anything in <was_root>\dbscripts? If yes, what permission on them?

    Vladlen.
  • gonzalo.alvarez
    gonzalo.alvarez
    23 Posts

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-08-24T16:03:35Z  
    • vlit
    • ‏2012-08-24T15:41:26Z
    Gonzalo, have you got anything in <was_root>\dbscripts? If yes, what permission on them?

    Vladlen.
    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

    Re: BPM 7.5.1. Standard - Databases scripts not generated

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

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-11-19T21:21:28Z  
    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

    Re: BPM 7.5.1. Standard - Databases scripts not generated

    ‏2012-11-19T21:55:43Z  
    • agouz
    • ‏2012-11-19T21:21:28Z
    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.
    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...