QVW with Macros to publish excel report to Share point
Hello Everyone,
Task in QMC is keep on running w/o result.
Task will execute batch file, the batch file will run QVW which has Macros to publish report to Sharepoint.
Recently i have done changes to macros in QVW to update new sharepoint email. When tested it is working fine in DEV. The same QVW is not working in UAT and PROD.
Anand, the service account is a domain user account, correct? Just wanted to be sure it was not a local account on the server, pretty sure it is a domain account, but just wanted to be certain for everyone.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
QVW with macro working fine when executed thru batch file (External Program) from QMC (both in DEV and PROD).
In the Macros, we had share point email as 'XX'. Due to Share point migrated to latest version, we have updated share point email in the macros as 'YY'. This is the only update we have done in macros as part of the new share point migration.
After update in DEV, everything is working fine like reports are published to new Share point. But the same code when deployed in PROD, task in QMC is keep on running w/o result.
We have roll backed changes in PROD (by replacing email from YY to XX). Now reports are published to Old Share point when executed from QMC. I don't see any issue with Macros as the existing code with email XX is working fine. we need to make the reports to be published to New SP YY.
Note - DEV and PROD has the same code, same batch file, same tasks but it is working in DEV but not in PROD.
If it's worked with the old XX as target and not with the new YY it meant that the issue isn't related to the macro-stuff else to any security/rights topic and there might be just one entry in the group policies missing. In our company nearly everything is blocked per default and will be only permitted per white-listing - means each new IP, port, user, ... must be separate permitted.
.png "Former Employee"){kind=icon}
