Task is not working

[#1]

Hi,

I have a report that is loading log files from a directory on different server.

when I open the document and reload it, it works fine but on I try to run and reload using the Console it shows that it runs successfully but it doesn't load any new data!

Anybody familiar with this issue?

Thxs

[#2]

Well. now i know what is the issue but I don't know how to fix it.

in my script the query will look for the last file executed and load the new files.

when the query run it is not getting to the directory:  SET vLogPath='X:\CallRecordsArchive\cdr\cdr*';

The directory is on a different server..

Hope anybody can help me.

thxs

[magavi_framsteg]

Hi Badr.

Instead of using mapped drives, X for example, use UNC paths instead.

The mapped drives are mapped for your user only, not necessarily for the user that runs the publisher service.

UNC-paths look something like this:

\\serverX\shared_folder_Y\directory_z

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

[#4]

Hi,

How about instead of using the mapped drive, use the IP (or Computer Name) of the server.

Regards,

Lester

[#5]

I have added the server IP as follow:

SET vLogPath='\\10.1.1.222\CallRecordsArchive\cdr\cdr*';

but that didn't work..

[magavi_framsteg]

Can you browse to \\10.1.1.222\CallRecordsArchive\cdr\cdr* in the standard Windows File Explorer?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

[#7]

The server Name is AGNotes03 and the IP address is 10.1.1.222

the directory is on D:\

Not sure If I am doing the right thing!

Thxs

[#8]

Oh!

there is a username and password set on that server..I have them but how can I add them to the query?

[#9]

Yes I can log this way :  \\AGNotes03\CallRecordsArchive\cdr

[magavi_framsteg]

Hi again.

The user who runs the publisher must automatically be able to connect to the share on AGNotes03\share_name. The publisher cannot supply any credentials the way you do when you map network drives, X:\ for example.

So you have to make sure the user has read access on the folder you want to read from and that the folder is shared on the network.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.