Precisely Software Inc.
Original Message:
Sent: 05-30-2023 18:14
From: Vanessa Kutasi
Subject: Linked Query Failing on Server Run
Yes, I had tried that, but just tried again in case I missed something the first time around. It still fails for "Error from processor: The query exceeds the maximum permitted length. ErrorCode: 2045". Support is saying due to using the "in" condition for the 2nd & 3rd queries, that is what is causing the failure. However, I can't seem to find a way to use the data I need populated in the file to run the subsequent queries. The data is ever changing, so I can't set an "end" row as it will never be the same.
------------------------------
Vanessa Kutasi
Foundation Admin./Application Analyst II
Idexx Operations, Inc.
USA
Original Message:
Sent: 05-30-2023 17:30
From: Sigrid Kok
Subject: Linked Query Failing on Server Run
Hi Vanessa
I don't use all from the first or individual - it's custom. Everything is set to the first script except for the sheet.
I just tested this on 20.2.2, and it works. Customer query on KNA1 - general data - generates a list of customer numbers, and then the 2nd script uses it as input for KNB1 - company data.
2nd script uses this setting for input of list of customer numbers
IDK if that helps, but it can work. I hope support can further help you.
Best Regards,
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
Original Message:
Sent: 05-22-2023 10:48
From: Vanessa Kutasi
Subject: Linked Query Failing on Server Run
Hi Sigrid
Thank you for the tip. Each script is pointed to the same template/excel file, each writing to a different tab. When using the custom link settings, with everything (except sheet and start row) set as "All from First Script", I still receive the file not found error. I have re-published with the link settings as "All from Individual Script" and receive the same error. Seems no matter what link settings I use, it fails. I do have an open case with support (PRE-00678191) to try and resolve.
------------------------------
Vanessa Kutasi
Foundation Admin./Application Analyst II
Idexx Operations, Inc.
USA
Original Message:
Sent: 05-19-2023 19:19
From: Sigrid Kok
Subject: Linked Query Failing on Server Run
Hi Vanessa
Please check your chain settings. Have all of the scripts point to using the same output file (Excel workbook) and just about everything the same except perhaps the sheet it extracts to. I think that is part of the issue since the chain should be writing to the same file (most of the time).
HTH
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
Original Message:
Sent: 05-19-2023 08:48
From: Archana Chandar
Subject: Linked Query Failing on Server Run
Hi Vanessa
Thank you ; I have created ticket PRE-00678191 for this issue and will be sending further communication through the ticket as to debug this issue I might need to organise meeting with you.
Please expect next response via support ticket.
Have a lovely weekend.
Many Thanks
Archana
------------------------------
Archana Chandar
Winshuttle North America
Original Message:
Sent: 05-18-2023 14:08
From: Vanessa Kutasi
Subject: Linked Query Failing on Server Run
Hi Archana,
Thank you for the suggestion! I removed all prior versions from Foundation and published a new version with the template having a completely different name. There are no spaces in the name this time. I am now receiving the error message below. I have attached the linked queries and the template.
QUERY File PT_EMA and Master Data_KR2.Qsq(Link) was not run successfully for the following reason:
Error from processor: No input files provided ErrorCode: 2030
------------------------------
Vanessa Kutasi
Foundation Admin./Application Analyst II
Idexx Operations, Inc.
USA
Original Message:
Sent: 05-18-2023 09:15
From: Archana Chandar
Subject: Linked Query Failing on Server Run
Hi Vanessa
Thank you for reaching out to Precisely Team.Regarding this issue XML Parser Error this error appears If the parser encounters an error, it may load an XML document containing the error description. To overcome this error first I would advise is to rename the template and resubmit it to Foundation ; also if there are any hidden sheets please remove them and then try scheduling.
If this doesnt resolve the issue ; please create support ticket with the Linked scripts,Template and the Foundation logs.
Thanks
Archana
------------------------------
Archana Chandar
Winshuttle North America
Original Message:
Sent: 05-17-2023 11:57
From: Vanessa Kutasi
Subject: Linked Query Failing on Server Run
Hey Experts,
We have 3 queries which are linked, they all use the same data template, populating data on their own tabs. The 2nd & 3rd queries execute using data from the 1 & 2nd tabs. When scheduling the query to run via the Foundation Server, it fails for parsing (see error below). When I schedule as a local run, it executes as designed. What might we need to do differently to have these linked queries execute properly on the server? I can provide a copy of the linked query if necessary.
QUERY File PT_EMA and Master Data_KR.Qsq(Link) was not run successfully for the following reason:
Error while parsing XML for DataProps.
------------------------------
Vanessa Kutasi
Foundation Admin./Application Analyst II
Idexx Operations, Inc.
USA
------------------------------