Skip to main content

Unable to get the HTM Bulk copy to work

 

Command Prompt

cd /d C:\IFS_PSO\Software\PSOHTM\GB_6597007783\scripts\SQL

”Hierarchical Travel Matrix Bulk Copy.bat” Hierarchical Travel Matrix dse1vmpe413 IFSPSO IFS0racl3

 

Receive the following error:-

SQLState = 08001, NativeError = 53
Error = rMicrosoft]oODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQLState = S1T00, NativeError = 0
Error = rMicrosoft]oODBC Driver 17 for SQL Server]Login timeout expired
bulk copied data into Routing_Edge
bulk copying data into Routing_Network
SQLState = 08001, NativeError = 53
Error = rMicrosoft]oODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server e53]. 

 

Hi Melanie,

it looks like a connection issue. From where are you trying to access the DB host dse1vmpe413? From your local machine or are you actually on this server? If you trying to connect from your local machine than you need to allow communication with the database through Port 1433. You can do this by running SQL Configuration Manager.

Note that you can also use the PSO Installer to install the HTM.


Best regards
Roman

Hi

 

I am running this on the server running the SQL database. I will take a look at the installer tool will it handle the data import as well.

Hi

 

I have reverted back to using the installer tool which is easier to use.

 

Thought the scripts might be faster but looks like more work.

By looking at the syntax, I think you should’ve put the database name in quotes as it includes blanks. 

However, if it runs now via the Installer that’s fine as well.

Reply


Terms & ConditionsCookie settings