File Drop Tutorial - [Exception: Unable to connect to database!] not found in "com.wm.resources.Core

,
1

Hello,
I’m a newbie to the Integration server usage/experiment and in the process of trying out a file drop tutorial where IS processes incoming xml file , translate it and finally pint it as string using the flow:debugLog services. However, I 'm getting the following error when I verify the results through IS admin.

[Exception: Unable to connect to database!] not found in "com.wm.resources.CoreExcpMsgs

FYI : when I installed the IS server, I chose ‘Embedded Database’

Advance thanks for your assistance.

2

Configure the JDBC Pools (External DB Pool).

3

How do I configure JDBC Pools? Do I need to install an external database server? such as MS-SQL?

4

Yeah.

5

Yes external DB is required or you can live with Embedded pool (comes with IS default) and assign the pool to the related functional aliases.

HTH,
RMG

6

Thanks Mahesh/RMG.

I’m trying to understand how to setup external DB and assign the pool to the related functional aliases. Appreciate any guidance in this regard.

7

Can you refer the installation guide its explained with screen shots.

You can configure the External db pool during your installation. Or run the DB configurator.

8

Mahesh,
Thanks… I run DB configurator to setup a connection to SQL Express server for ‘Trading Networks’ product. no luck yet. Including the error for your ref.

  • Executing action
  • Action : create
  • Database : SQL Server
  • Component(s) : storage
  • Component(s) version : latest
  • URL : jdbc:wm:sqlserver://localhost;instanceName=SQLEXPRESS;
  • User : sa
  • create Database Component: Storage STR
  • Versions
  • Version: sqlserver 30.0
  • Scripts create

  •   Script(1): C:\SoftwareAG\common\db/scripts/mssql/storage/30/create/mss_str_c_ddl_database.sql

  •   Script(2): C:\SoftwareAG\common\db/scripts/mssql/storage/30/create/mss_str_c_ddl_user.sql

  •   Script(3): C:\SoftwareAG\common\db/scripts/mssql/storage/20/create/mss_str_c_sp_kill_process.sql
  • Database Connection error: [SoftwareAG][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect
      Database component configurator summary

Date : Wed Sep 30 14:38:25 EDT 2015
Database : SQL Server
User : sa
Action : create

The JDBC connection string looks good to me… but I’m puzzled with the error message and don’t know how to troubleshoot. Appreciate your assistence.

9

This error is normal and expected. To fix this check the link below. My friend has written steps clearly. Contact me if any issues. GN :slight_smile:

10

Mahesh,
Thanks for your help to address the JDBC connection issue, and able to populate DB object for ‘Trading Networks’.
After this, I had created DB pool alias and assign to function name ‘TN’. But, still getting an error while testing the File Drop tutorial.

The errors are
#1. [1622]2015-10-02 13:26:30 EDT [BPM.0101.0521W] Storage cleaner: cannot acquire lock. Exception: [Exception: Unable to connect to database!] not found in “com.wm.resources.CoreExcpMsgs”.
#2. [1612]2015-10-02 13:05:59 EDT [TNS.0002.9003C] Could not configure Ehcache. Either the SoftwareAG-IS-TN.xml file is missing from the config folder or it is an invalid XML file.

Raw server error logs:

[1622]2015-10-02 13:26:30 EDT [BPM.0101.0521W] Storage cleaner: cannot acquire lock. Exception: [Exception: Unable to connect to database!] not found in “com.wm.resources.CoreExcpMsgs”.
[1621]2015-10-02 13:16:30 EDT [BPM.0101.0521W] Storage cleaner: cannot acquire lock. Exception: [Exception: Unable to connect to database!] not found in “com.wm.resources.CoreExcpMsgs”.
[1620]2015-10-02 13:06:30 EDT [BPM.0101.0521W] Storage cleaner: cannot acquire lock. Exception: [Exception: Unable to connect to database!] not found in “com.wm.resources.CoreExcpMsgs”.
[1619]2015-10-02 13:06:00 EDT [ISS.0028.0013E] Startup service exited with the following error: java.lang.NullPointerException: null
[1618]2015-10-02 13:06:00 EDT [ISU.0000.9999E] WmTNExtDC: Error initializing package: null
[1617]2015-10-02 13:06:00 EDT [ISU.0000.9999E] WmTNExtDC: Error initializing TN JobMgr interface
[1616]2015-10-02 13:06:00 EDT [ISS.0028.0012I] WmTNExtDC: Startup service (wm.tnextdc.PkgInit:init)
[1615]2015-10-02 13:06:00 EDT [ISS.0028.0005I] Loading WmTNExtDC package
[1614]2015-10-02 13:06:00 EDT [ISS.0028.0012I] WmTN: Startup service (wm.tn.mime:init)
[1613]2015-10-02 13:06:00 EDT [ISU.0000.9999C] java.lang.NullPointerException
[1612]2015-10-02 13:05:59 EDT [TNS.0002.9003C] Could not configure Ehcache. Either the SoftwareAG-IS-TN.xml file is missing from the config folder or it is an invalid XML file.
[1611]2015-10-02 13:05:59 EDT [ISS.0017.0080I] Migrated the SoftwareAG-IS-TN.xml cache manager configuration to the Ehcache 2.8.x format.
[1610]2015-10-02 13:05:59 EDT [TNS.0000.2031C] No model version information was available from the database.
[1609]2015-10-02 13:05:59 EDT [ISS.0096.0008I] JDBC Connection pool threshold exceeded, 0 available for pool TN:USAID_LOCAL_DB_SVR_TN
[1608]2015-10-02 13:05:59 EDT [ISU.0000.9999I] TRANET: Loading system configuration
[1607]2015-10-02 13:05:59 EDT [ISU.0000.9999C] TRANET: Starting webMethods Trading Networks
[1606]2015-10-02 13:05:59 EDT [ISS.0028.0012I] WmTN: Startup service (wm.tn.admin:startup)
[1605]2015-10-02 13:05:59 EDT [ISS.0028.0005I] Loading WmTN package
[1604]2015-10-02 13:05:58 EDT [ISS.0028.0042I] Unloading WmTN package

11

I still doubt on your JDBC pool configuration.

Can you drop all the tables via DCC, uninstall webMethods. Install wM and run DCC.

12

Mahesh,
Thanks. The issue is resolved after reinstalling the WM/IS with MS SQL connection. The file drop tutorial worked without any issues.

Thanks
Dinesh

13

Cool, you can treat me with a mug of BEER :lol: :lol: Good night…