SQL Server 2014

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
anunagarajaiah
Posts: 4
Joined: Thu Nov 10, 2016 8:40 pm

SQL Server 2014

Post by anunagarajaiah » Thu Nov 10, 2016 8:58 pm

Good Evening,

I am facing a problem with TextPipe filter when invoked by a job in SQL Agent. TextPipe starts processing the file only after a delay of ~30 secs. The job step has only the command to run the filter. I am using /f, /g and /q at the right places in this command. When I run this step, I see that theTextPipe.exe has kicked off (can see this in the Taskmanager) but I do not see the tmp file in the output folder that tells me that the processing has begun. It starts only after ~30secs.

I am using textpipe 9.2.2 AND SQL SERVER 2014.

Can you please help me out here?

Thanks,
Anuradha

User avatar
DataMystic Support
Site Admin
Posts: 2206
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: SQL Server 2014

Post by DataMystic Support » Sun Nov 13, 2016 7:17 pm

TextPipe 9.2.2 is from September 6, 2012.

You can wade through 4 years worth of release notes here: http://www.datamystic.com/textpipe/whatsnew

Or you could just upgrade and we'd be happy to help.

What type is the file (.zip, docx etc) and is it located on a local drive or network?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

anunagarajaiah
Posts: 4
Joined: Thu Nov 10, 2016 8:40 pm

Re: SQL Server 2014

Post by anunagarajaiah » Tue Nov 15, 2016 5:13 pm

Thank you for looking into this.

It is a binary file placed in my local folder.

Thanks,
Anuradha

User avatar
DataMystic Support
Site Admin
Posts: 2206
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: SQL Server 2014

Post by DataMystic Support » Wed Nov 16, 2016 7:23 am

Sorry, I can't offer specific support for a binary file.

Please upgrade and we'll be happy to help.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

anunagarajaiah
Posts: 4
Joined: Thu Nov 10, 2016 8:40 pm

Re: SQL Server 2014

Post by anunagarajaiah » Wed Nov 16, 2016 3:20 pm

Thank you. We have upgraded it to 10.0.4. Let me check if this works and will get back to you if the issue persists.

Thanks,
Anuradha

anunagarajaiah
Posts: 4
Joined: Thu Nov 10, 2016 8:40 pm

Re: SQL Server 2014

Post by anunagarajaiah » Wed Nov 16, 2016 11:05 pm

The new version has the exit code as -1073741819. Please let me know what this means..

Thanks,
Anuradha

User avatar
DataMystic Support
Site Admin
Posts: 2206
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: SQL Server 2014

Post by DataMystic Support » Thu Nov 17, 2016 7:32 am

Thank you Anuradha,

Please send us via email
- filter file (.fll)
- complete command line
- a test file if you can
- Windows versions
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

User avatar
DataMystic Support
Site Admin
Posts: 2206
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: SQL Server 2014

Post by DataMystic Support » Mon Dec 19, 2016 6:54 am

There is no reason for TextPipe 9.9.2 to take 30 seconds to start processing. Delay on exit I can understand, as there is a race condition in MS Help and the only workaround is to pause before exiting.

Are you using SQL Server Agent to start TextPipe? Does it have any dependencies on other tasks? Does the job copy files to another folder before start?

This link may be helpful: https://social.msdn.microsoft.com/Forum ... m=sqltools

It may be due to credential impersonation of the SQL Server Agent proxy.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 4 guests