SWPM database refresh error JZ003: Incorrect URL format. URL: sapxxx01:

[jbrzozowski]

Hello,

during database refresh (ASE), when swpm tries to connect to the database we get this error

WARNING    2023-09-14 13:01:36.189 (root/sapinst) (startInstallation) [iaxxbjsmod.cpp:83] id=modlib.jslib.childAppReturn
Execution of the command "/tmp/sapinst_exe.3108.1694689135/jre/bin/java -classpath /tmp/sapinst_instdir/GENERIC/SYB/DBREFRESH/sybhelper.jar:sybhelper.jar:/tmp/sapinst_instdir/GENERIC/SYB/DBREFRESH/sybjdbc/jconn42.jar -Xmx256m sybsql3" finished with return code 1. Output: 
java.sql.SQLException: JZ003: Incorrect URL format. URL: sapxxx01:
	at com.sybase.jdbc42.jdbc.ErrorMessage.raiseError(ErrorMessage.java:806)
	at com.sybase.jdbc42.tds.Tds.login(Tds.java:496)
	at com.sybase.jdbc42.jdbc.SybConnection.tryLogin(SybConnection.java:532)
	at com.sybase.jdbc42.jdbc.SybConnection.handleHAFailover(SybConnection.java:3864)
	at com.sybase.jdbc42.jdbc.SybConnection.<init>(SybConnection.java:385)
	at com.sybase.jdbc42.jdbc.SybConnection.<init>(SybConnection.java:285)
	at com.sybase.jdbc42.jdbc.SybDriver.connect(SybDriver.java:260)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at sybsql3.main(sybsql3.java:53)
TRACE      2023-09-14 13:01:36.189 (root/sapinst) (startInstallation) [Installer Callback]
syb_verify_jdbc_connect2: return code 1

Connecting to ASE from command line with isql (linux) works.

Any ideas what is causing this?

SWPM is in the latest version.

Kind regards

[jbrzozowski]

yes. /tmp has full permissions (777)

[Sriram2009]

Hi Jacek,

Does the temp folder have full permission(777)?

Regards

SS