Data Load Tool failing with error "(err.persistence.unavailable)"

[Vaibhav khopade]

Hello,

We are facing issues while running Data Load Tool for locally installed “Microsoft SQL Server 2012 Express LocalDB”.

Below are the errors we got in NexJ Studio Console –

ERROR [GenericTool] Error executing the tool command
nexj.core.persistence.AvailabilityException: Data source “Conversation” is temporarily unavailable. (err.persistence.unavailable)

Unable to create a new resource. (err.pool.resource.create)

java.sql.SQLException: Network error IOException Connection refused: connect

1	java.sql.SQLException: Network error IOException Connection refused: connect

Even after increasing resource pool size in NexJ Studio, still getting same error.

Please suggest possible reasons/solutions for this.

0

[Ed Shaw]

That typically means that the environment for the datasource hasn’t been configured quite right. Often the credentials aren’t correct or sometimes the MSSQL server hasn’t been configured correctly for IP traffic. A great way to quickly test this is to open up the environment file you are working with and navigate to the Data Source Connections tab. Select the Relational Database Connection that contains the datasource that is giving you trouble (in this case the Conversation datasource). On the General tab for the Relational Database Connection you will see the “Test Connection button. Press it and it will try to connect to the database. What you want to see is “Test connection successful”. If there is a problem, you will immediately see an appropriate error, helping you to diagnose the problem quickly without having to start the server over and over. Some example issues are:

Error: err.pool.resource.create Login failed for user nexjw.

1 2	Error: err.pool.resource.create Login failed for user nexjw.

Probably your username or password used to connect is incorrect

Error: err.pool.resource.create Network error IOException: Connection refused: connect

1 2	Error: err.pool.resource.create Network error IOException: Connection refused: connect

The NexJ Model Server can’t find the MSSQL Server. Your host or port may be incorrect. Also, if you haven’t configured MSSQL properly to allow IP traffic, you will receive this message. Launch the SQL Server Configuration Manager and ensure that TCP/IP is enabled for your server under Client Protocols. The setup of a SQL Server database is also described in our “funamentals” training materials.

Error: err.pool.resource.create Cannot open database analytics13 requested by the login. The login failed.

1 2	Error: err.pool.resource.create Cannot open database analytics13 requested by the login. The login failed.

You probably have the database name wrong or you haven’t created it yet.

Some useful documentation can also be found at Configuring a Relational Database Connection

Microsoft SQL Server Links

1

[Vaibhav khopade]

Thank you so much Ed for the detailed response.

Actually after clicking Test Connection also we are getting error message as – “Error: Unable to create a new resource. (err.pool.resource.create)
Network error IOException: Connection refused: connect”

Note that we are using “MSSQL Server Express LocalDB” which is different than MSSQL Server Express.

Also we found below articles mentioning that JDBC driver does not support connection to “SQL Server LocalDB”-

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/259f11e2-e740-40f8-9b6c-64d015ab4b74/jdbc-connection-string-to-localdb?forum=sqldataaccess

http://stackoverflow.com/questions/11816522/connect-to-sql-server-localdb-jdbc

Please suggest.

 

0

[Author]

Posts