Re: constant error with message "Message: Error: T... - Qlik Community

Troy1 · ‎2019-03-04

While running NPrinting schedule jobs we constantly get below error. We are running version 16.9. Reports run fine while running it via designer. However schedule is hit and miss where it works sometimes but often fails with below error.

Message: Error: The PivotTable field name is invalid

We have reached out to Qlik Support unfortunately they have not be able to resolve or find any solutions so far.

Ruggero_Piccoli · ‎2019-03-04

Hi,

Please send me the support case number because I'm not able to find it.

Share also some details useful to reproduce the issue like screenshots or the report template.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Frank_S · ‎2019-03-04

Try this.

1. Refresh your NP 'source connection'

2. Open the the report in the NP designer

3. Open the 'tables' node under the connection field

4. Right click on your pivot table and select 'update'

If the object changes in terms of structure from the source qvw, it must also be updated in the report template.

Hope this helps.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

constant error with message "Message: Error: The PivotTable field name is invalid"

NPrinting Pivot error