wM BR 9.9 Unable to execute

Revathi_Kanabargi · March 29, 2016, 1:43pm

I have installed wM 9.9 and BR 9.9.

From DB configurator, I have created below DB tables.

Successfully installed components

BusinessRules 10.0
CentralConfiguration 27.0
DistributedLocking 20
ISCoreAudit 50.0
ISInternal 55.0
MywebMethodsServer 46.0
OperationManagement 30.0
ProcessAudit 77.0
ProcessEngine 80.0
ProcessTracker 65.0

I have also configured the Functional Alias Definistions for the JDBC Pools ProcessEngine and ProcessAudit.

However, when I try to execute the Decision table from Designer to IS, I get an error as below :

Unable to execute the requested operation due to an error at package startup. See log for more details!
Caused by: java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501

When I manually run the start up service (wm.businessrules.admin:startup), I get the below error.

com.wm.app.b2b.server.ServiceException: java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501 at com.softwareag.rules.businessrulespackage.StartupManager.startup(StartupManager.java:91) at wm.businessrules.admin.startup(admin.java:221) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:407) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49) at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:303) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:371) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:384) at com.wm.app.b2b.server.HTTPInvokeHandler._process(HTTPInvokeHandler.java:254) at com.wm.app.b2b.server.InvokeHandler.process(InvokeHandler.java:101) at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:178) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:386) at com.wm.util.pool.PooledThread.run(PooledThread.java:127) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501 at java.util.ResourceBundle.getObject(ResourceBundle.java:450) at java.util.ResourceBundle.getString(ResourceBundle.java:407) at com.softwareag.rules.businessrulespackage.logging.Messages.get(Messages.java:15) at com.softwareag.rules.businessrulespackage.targetruntimes.dao.TargetRuntimesDatabaseAccess.throwNewServiceException(TargetRuntimesDatabaseAccess.java:254) at com.softwareag.rules.businessrulespackage.targetruntimes.dao.TargetRuntimesDatabaseAccess.insertOrUpdateTargetRuntime(TargetRuntimesDatabaseAccess.java:81) at com.softwareag.rules.businessrulespackage.targetruntimes.TargetRuntimesManager.registerCurrentRESInstance(TargetRuntimesManager.java:38) at com.softwareag.rules.businessrulespackage.StartupManager.startup(StartupManager.java:85) … 23 more

What configuration is missing?

Holger_von_Thomsen · March 29, 2016, 3:58pm

Hi Revathi,

please share more details about how you created the database schema (which COMPONENT/PRODUCT).

Please configure Functional Aliaes IS Internal and IS Core Audit additionally.

Please share complete FixLevel including Version of Database Scripts component.

Regards,
Holger

Revathi_Kanabargi · March 29, 2016, 4:53pm

Created DB Schema using the Database Component Configurator 9.9

Configured IS Core Audit and IS Internal.

There are no updates or fixes installed.
Version of WmBusinessRules is 9.9.0.0.200

Below are the detailed DB Components created :

create Database Component: Storage STR

Versions
Version: oracle 30.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql

CREATE STORAGE [30.0] SUCCESSFUL

      Database component configurator summary

Date : Tue Mar 29 16:40:07 IST 2016
Database : Oracle
User : SYSTEM
Action : create

Successfully installed components

Storage 30.0

Executing action
Action : create
Database : Oracle
Component(s) : BusinessRules,ISCoreAudit,ISInternal,MywebMethodsServer,ProcessAudit,ProcessEngine,ProcessTracker
Component(s) version : Latest
URL : jdbc:wm:oracle://localhost:1521;serviceName=orcl;
User : SYSTEM

create Database Component: ComponentTracker CTR

Versions
Version: oracle 25.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql

  Script(4): C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

  Script(5): C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql

create Database Component: BusinessRules RUL

Versions
Version: oracle 10.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/businessrules/10/create/ora_rul_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/businessrules/10/create/ora_rul_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/businessrules/10/create/ora_rul_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/businessrules/10/create/ora_rul_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE BUSINESSRULES [10.0] SUCCESSFUL

create Database Component: ISCoreAudit ISC

Versions
Version: oracle 50.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/iscoreaudit/50/create/ora_isc_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/iscoreaudit/50/create/ora_isc_c_ddl_triggers.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/iscoreaudit/50/create/ora_isc_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/iscoreaudit/50/create/ora_isc_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/iscoreaudit/50/create/ora_isc_c_ddl_triggers.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/iscoreaudit/50/create/ora_isc_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE ISCOREAUDIT [50.0] SUCCESSFUL

create Database Component: ISInternal ISI

Versions
Version: oracle 55.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/isinternal/55/create/ora_isi_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/isinternal/55/create/ora_isi_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/isinternal/55/create/ora_isi_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/isinternal/55/create/ora_isi_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE ISINTERNAL [55.0] SUCCESSFUL

create Database Component: DistributedLocking DSL

Versions
Version: oracle 20.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE DISTRIBUTEDLOCKING [20] SUCCESSFUL

create Database Component: MywebMethodsServer MWS

Versions
Version: oracle 46.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_tables.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_dml_core.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_keys.sql

  Script(4): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_seq.sql

  Script(5): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_triggers.sql

  Script(6): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_socialbpm.sql

  Script(7): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_taskorchestrator.sql

  Script(8): C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_tables.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_dml_core.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_keys.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_seq.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_triggers.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_socialbpm.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_ddl_taskorchestrator.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/mws/46/create/ora_mws_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE MYWEBMETHODSSERVER [46.0] SUCCESSFUL

create Database Component: CentralConfiguration CCS

Versions
Version: oracle 27.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/centralconfiguration/27/create/ora_ccs_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/centralconfiguration/27/create/ora_ccs_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/centralconfiguration/27/create/ora_ccs_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/centralconfiguration/27/create/ora_ccs_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE CENTRALCONFIGURATION [27.0] SUCCESSFUL

create Database Component: ProcessAudit PRA

Versions
Version: oracle 77.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/65/create/ora_pra_c_ddl_meta_tables_indexes.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/65/create/ora_pra_c_ddl_processtask_tables_indexes.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/76/create/ora_pra_c_ddl_runtime_tables_indexes.sql

  Script(4): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/75/create/ora_pra_c_ddl_runtime_triggers.sql

  Script(6): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/70/create/ora_pra_c_ddl_stage_definition.sql

  Script(7): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/70/create/ora_pra_c_ddl_views.sql

  Script(8): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/73/create/ora_pra_c_ddl_wmcontrol.sql

  Script(9): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/75/create/ora_pra_c_ddl_ruledist.sql

  Script(10): C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/77/create/ora_pra_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/65/create/ora_pra_c_ddl_meta_tables_indexes.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/65/create/ora_pra_c_ddl_processtask_tables_indexes.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/76/create/ora_pra_c_ddl_runtime_tables_indexes.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/75/create/ora_pra_c_ddl_runtime_triggers.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/70/create/ora_pra_c_ddl_stage_definition.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/70/create/ora_pra_c_ddl_views.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/73/create/ora_pra_c_ddl_wmcontrol.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/75/create/ora_pra_c_ddl_ruledist.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processaudit/77/create/ora_pra_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE PROCESSAUDIT [77.0] SUCCESSFUL

create Database Component: ProcessEngine PRE

Versions
Version: oracle 80.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/processengine/80/create/ora_pre_c_ddl.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/processengine/70/create/ora_pre_c_debugger.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/processengine/80/create/ora_pre_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processengine/80/create/ora_pre_c_ddl.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processengine/70/create/ora_pre_c_debugger.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processengine/80/create/ora_pre_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE PROCESSENGINE [80.0] SUCCESSFUL

create Database Component: OperationManagement OPM

Versions
Version: oracle 30.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/22/create/ora_opm_c_ddl_tables_indexes.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/22/create/ora_opm_c_dml.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/30/create/type_defin.pkg

  Script(4): C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/22/create/operation_mgmt.pkg

  Script(5): C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/30/create/operation_mgmt.pkb

  Script(6): C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/30/create/ora_opm_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/22/create/ora_opm_c_ddl_tables_indexes.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/22/create/ora_opm_c_dml.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/30/create/type_defin.pkg

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/22/create/operation_mgmt.pkg

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/30/create/operation_mgmt.pkb

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/operationmanagement/30/create/ora_opm_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE OPERATIONMANAGEMENT [30.0] SUCCESSFUL

create Database Component: ProcessTracker PTR

Versions
Version: oracle 65.0
```
Scripts create
```

  Script(1): C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_ddl_tables_indexes.sql

  Script(2): C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_ddl_sequences.sql

  Script(3): C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_ddl_sequences_triggers.sql

  Script(4): C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_opt_ae_ptr_c_dml_tracking.sql

  Script(5): C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_ddl_tables_indexes.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_ddl_sequences.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_ddl_sequences_triggers.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_opt_ae_ptr_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/processtracker/65/create/ora_ptr_c_dml_tracking.sql

Executing script : C:\SoftwareAG_Des\common\db/scripts/oracle/componenttracker/25/create/ora_ctr_c_dml_view.sql

CREATE PROCESSTRACKER [65.0] SUCCESSFUL

      Database component configurator summary

Date : Tue Mar 29 16:40:29 IST 2016
Database : Oracle
User : SYSTEM
Action : create

Successfully installed components

BusinessRules 10.0
CentralConfiguration 27.0
DistributedLocking 20
ISCoreAudit 50.0
ISInternal 55.0
MywebMethodsServer 46.0
OperationManagement 30.0
ProcessAudit 77.0
ProcessEngine 80.0
ProcessTracker 65.0

Holger_von_Thomsen · March 29, 2016, 5:25pm

Hi Revathi,

Process Tracker and Central Configuration are only needed when using Optimize.
But in this case there are more components missing.

Please check if you have configured your IS in MWS under Administration → My webMethods → System Settings → webWebmethods Businees Rules Settings.

Were the rules be uploaded from Designer to MWS/IS?
What happens when you click on Administration → Business - webMethods Business Rules → Welcome → Update Entries in Navigation Pane?

Is there any Data in the Tables for Component “Business Rules”?

Please check in Installer if you have all Business Rules-relevant objects installed.
There might be some common libraries, shared bundles or infrastructure components missing.
If so, shutdown IS, apply the missing components and restart IS.

Regards,
Holger

Revathi_Kanabargi · March 30, 2016, 4:43pm

I do not want to export the BRs into the MWS.
Just want to execute from IS.
Do I still need to configure an MWS and IS and BRs in the MWS?

Looks like some common libraries, shared bundles or infrastructure components only missed.
Will confirm on this once again by running the Installer for the BPMS free trial image, with which I have installed the BRs.

Holger_von_Thomsen · March 30, 2016, 4:56pm

Hi Revathi,

I suggest that you take a look at the BPM_Rules_Development_Help.pdf.
It can be downloaded from Empower (if you have access) or from here:
http://techcommunity.softwareag.com/ecosystem/communities/public/_communities/documentation

Especially Chapter 18 is dealing with local testing of Rules.

Regards,
Holger

Revathi_Kanabargi · March 30, 2016, 8:46pm

Thanks for the link.
I am able to locally create Rules, Decision table.
I can debug and run the Decision table too.

When I want to export it to IS (just the IS-not MWS), I get the error as below.

Unable to execute the requested operation due to an error at package startup. See log for more details!
Caused by: java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501

This comes even at the start up of the WmBusinessRules Package.
wm.businessrules.admin:startup

What exactly is missing?

Revathi_Kanabargi · April 1, 2016, 8:30am

Hi Holger,

Ensured by installing all shared bundles, libraries available with image of 9.9 IS and BPMS free trial.

Verified in the DB BUSINESSRULESTARGETRUNTIMES table and BUSINESSRULESTARGETRUNTIMES have got created. The user with whom Process Audit is configured can access these tables.

Still WmBusinessRules packe start up service throws the error

Could not run ‘new_flowservice’
com.softwareag.rules.runtime.exception.RESCoreException: Unable to execute the requested operation due to an error at package startup. See log for more details!

com.softwareag.rules.runtime.exception.RESCoreException: Unable to execute the requested operation due to an error at package startup. See log for more details!
at com.softwareag.rules.runtime.RESFacade.getInstance(RESFacade.java:205)
at com.softwareag.rules.runtime.is.consumer.UnlicensedRuleConsumerISWrapper.handleUnlicensedMethodCall(UnlicensedRuleConsumerISWrapper.java:44)
at com.softwareag.rules.runtime.is.consumer.UnlicensedRuleConsumerISWrapper.invoke(UnlicensedRuleConsumerISWrapper.java:33)
at pub.businessrules.client.invoke(client.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:407)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:303)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:371)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:384)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:238)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:225)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:254)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:511)
at com.wm.lang.flow.FlowState.step(FlowState.java:389)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:360)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1054)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:303)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:371)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:384)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:238)
at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:156)
at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:178)
at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:386)
at com.wm.util.pool.PooledThread.run(PooledThread.java:127)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501
at java.util.ResourceBundle.getObject(ResourceBundle.java:450)
at java.util.ResourceBundle.getString(ResourceBundle.java:407)
at com.softwareag.rules.businessrulespackage.logging.Messages.get(Messages.java:15)
at com.softwareag.rules.businessrulespackage.targetruntimes.dao.TargetRuntimesDatabaseAccess.throwNewServiceException(TargetRuntimesDatabaseAccess.java:254)
at com.softwareag.rules.businessrulespackage.targetruntimes.dao.TargetRuntimesDatabaseAccess.insertOrUpdateTargetRuntime(TargetRuntimesDatabaseAccess.java:81)
at com.softwareag.rules.businessrulespackage.targetruntimes.TargetRuntimesManager.registerCurrentRESInstance(TargetRuntimesManager.java:38)
at com.softwareag.rules.businessrulespackage.StartupManager.startup(StartupManager.java:85)
at wm.businessrules.admin.startup(admin.java:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:407)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:303)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:371)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:384)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:238)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:107)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:79)
at com.wm.app.b2b.server.SessionInvoke.run(SessionInvoke.java:33)
… 2 more

Can you throw some light on these error. I do not see it in the wM Error Message Reference either for the 9.9.

Holger_von_Thomsen · April 1, 2016, 12:10pm

Hi Revathi,

are there any other messages in server.log or error log?
Especially during startup of IS?

I think it might be worth to contact SAG Support for clarification.

Regards,
Holger

Revathi_Kanabargi · April 1, 2016, 12:22pm

java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501
Caused by: java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key 0501

This is the only message with the start up service. Same comes when IS starts.
Unable to figure out which java.util.PropertyResourceBundle, where to configure or set or install it.

Regards,
Revathi

Holger_von_Thomsen · April 1, 2016, 4:21pm

Hi Revathi,

please check your installation directory for the following file:
IntegrationServer\packages\WmBusinessRules\code\jars\static\wmbusinessrules_resources.jar

Does it exist and if yes, is it accessible (readable)?

Additionally check for the directory IntegrationServer\packages\WmBusinessRules\code\jars.
How many jars do you have here?
My 9.5 SP1 version shows 9 jars.

Please share the server.log snippet for the IS start.
Can you try to start with an higher loglevel (option “-debugTrace”)?

If the mentioned file does not exist please try the following:
Are you able to uninstall and re-install (or overinstall) the Rules Engine Support for IS?

Looks like an Installation issue.

Regards,
Holger

Holger_von_Thomsen · April 1, 2016, 4:28pm

Hi Revathi,

did you export the rules project to the IS repository?

Check for the Chapter “Exporting a Rule Project to the Integration Server” in the Rules Development Guide.

Regards,
Holger

Revathi_Kanabargi · April 1, 2016, 4:44pm

Yes Hogler, I am following this video → - YouTube

Ok until debug of BR on Designer.
Unable to export rule to IS. Get the below error.

Regarding jars in …\IntegrationServer\instances\default\packages\WmBusinessRules\code\jars I have 17. See attached image, bottom part, for names of jars found.

Regarding …\IntegrationServer\instances\default\packages\WmBusinessRules\code\jars\static\wmbusinessrules_resources.exe, it exists. When I open, I can see some unusual characters. But values in tag are proper English.
Image of same I have attached for your review.

Please have a look.

Revathi_Kanabargi · April 1, 2016, 6:03pm

Hey Hogler,

There was an issue with the DB Pools.
I created DB components in a diff schema by selecting ALL tables, the reconfigured DB pools to new schema.

Now its exporting rules to IS and executing rules on IS!!

Thanks for your troubleshooting advice

Holger_von_Thomsen · April 1, 2016, 6:06pm

Hi Revathi,

please check IntegrationServer/packages/WmBusinessRules/config/ for licenseKey.xml and if it is valid.

Under IntegrationServer\instances\default\packages\WmBusinessRules\code\jars there is a wmbusinessrules.jar, which contains a message.properties file.
In this one there is a Key 0050.0501 which has error message as “Database connection not available”.

As Jars have the same file format then Zip Archives, these can be analyzed by any program that support zip archives.

The number of jars can differ from wM Version to wM Version.

Regards,
Holger

wM BR 9.9 Unable to execute

Successfully installed components

Date : Tue Mar 29 16:40:07 IST 2016 Database : Oracle User : SYSTEM Action : create

Successfully installed components

Date : Tue Mar 29 16:40:29 IST 2016 Database : Oracle User : SYSTEM Action : create

Successfully installed components

Date : Tue Mar 29 16:40:07 IST 2016
Database : Oracle
User : SYSTEM
Action : create

Date : Tue Mar 29 16:40:29 IST 2016
Database : Oracle
User : SYSTEM
Action : create