Automate

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.

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

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.

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

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

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.

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

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

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

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.

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

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

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

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

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.