Performance Intelligence Center (PIC) Scheduler Export Is Run, but No File Can Be Found with Error "Expecting / to follow the hostname in URI"

Asset ID:	1-72-2149189.1
Update Date:	2017-11-12
Keywords:

Solution Type Problem Resolution Sure

Solution 2149189.1 : Performance Intelligence Center (PIC) Scheduler Export Is Run, but No File Can Be Found with Error "Expecting / to follow the hostname in URI"

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 9.0.3 to 10.2.0 [Release 9.0 to 10.0]
Information in this document applies to any platform.

Symptoms

According to log export is run, but no file can be found on distant sftp/ftp server.

NSP application.log contains the following error:

2016-06-01 07:11:00,110 - ERROR - NSP-WEBLOGIC - ProTrace - tekelec - SYSTEM - (s)ftp copy error - org.apache.commons.vfs2.FileSystemException: Invalid absolute URI "sftp://sigin:***@x.y.z.t/opt/coletores/roaming/TXT_2016-06-01_11-00.TXT".
at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:61)
at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:693)
at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:621)
at com.tekelec.cssg.nsp.protrace.ejb.scheduler.Ftp.copyFrom(Ftp.java:80)
at com.tekelec.cssg.nsp.protrace.ejb.scheduler.XdrExportSchedulerMDB.doExport(XdrExportSchedulerMDB.java:226)
at com.tekelec.cssg.nsp.protrace.ejb.scheduler.XdrExportSchedulerMDB.onMessage(XdrExportSchedulerMDB.java:86)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: org.apache.commons.vfs2.FileSystemException: Expecting / to follow the hostname in URI "sftp://sigin:***@x.y.z.t/opt/coletores/roaming/TXT_2016-06-01_11-00.TXT".
at org.apache.commons.vfs2.provider.HostFileNameParser.extractToPath(HostFileNameParser.java:155)
at org.apache.commons.vfs2.provider.URLFileNameParser.parseUri(URLFileNameParser.java:50)
at org.apache.commons.vfs2.provider.AbstractFileProvider.parseUri(AbstractFileProvider.java:188)
at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:57)
... 12 more

Changes

Cause

Password contains reserved characters (in this case: @).

sftp url is usually formatted like:

sftp://login:password@IP/path/filename.csv

If password contains @ or : URL will be badly interpreted.

For example, if password is "p@ssword", URL is:

sftp://login:p@ssword@IP/path/filename.csv

thus password will only be "p" and "ssword" will be used as hostname. After hostname, it is expecting a / which is not the case as it is another "@".

Solution

First and easiest solution is to change password of this user on the distant server.

This is specific to sftp/ftp server software.

References

<BUG:23578175> - SCHEDULER EXPORT IS RUN, BUT NO FILE CAN BE FOUND

Attachments

This solution has no attachment