Why QV is always asking me to save the QVW aplication?

[rcandeo]

I have an application that for some reason, anytime I open it and try to reload data, ask me to save as a new file.

Even if I save in the original name, it asks me again the next time I open it.

For this reason, my automatic reloading is not working.

Any idea why is this happening?

[blaise]

If you use Reduction Qv will always force a "save as". If that not the case i dont know.

Edit:

And with reduction and mean data reduction in the qlikview document togheter with some opOpen, as other users has asked about (and not Publisher reduction).

[rcandeo]

Yes, I use reduction. And why is not reloading automatically with my publisher?

[#4]

Do you have any macros that are running (such as OnOpen) that are changing any attributes of the document?

[rcandeo]

These are the macros that I have:

Sub LimparSimulacao

set c = ActiveDocument.GetVariable("Aumento_Custo")

c.SetContent 0,true

set p = ActiveDocument.GetVariable("Aumento_Preco")

p.SetContent 0,true

End Sub

Sub SelecaoInicial

ActiveDocument.GetField("Empresa").Select "00100"

ActiveDocument.GetField("Grupo_Principal").Select "CELULOSE"

ActiveDocument.Fields("Grupo_Principal").SelectExcluded

ActiveDocument.GetField("Familia").Select "CELULOSE"

ActiveDocument.Fields("Familia").SelectExcluded

ActiveDocument.GetField("Mes").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'MM')")

ActiveDocument.GetField("Ano").Select ActiveDocument.Evaluate("date(addmonths(monthstart(today(1)),-1),'YYYY')")

ActiveDocument.GetField("Cobranca").Select "Com Débito"

ActiveDocument.GetField("Tipo_Faturamento").Select "Faturado"

End Sub

Sub ExportaXLS

set obj = ActiveDocument.GetSheetObject("CH60")

obj.ExportBiff "C:\test.xls"

End Sub

sub ShowFilters

set f = ActiveDocument.GetVariable("vShowFilters")

if f.GetContent.String = "1" then

f.SetContent "0", true

else

f.SetContent "1", true

end if

end sub

sub AutoHideFilters

set f = ActiveDocument.GetVariable("vShowFilters")

f.SetContent "0", true

end sub

sub CurrentSelections

set s = ActiveDocument.GetVariable("vSelections")

if s.GetContent.String = "1" then

s.SetContent "0", true

else

s.SetContent "1", true

end if

end sub

[#6]

You dont mention when the macros are fired but I would suspect .SetContent would cause a 'save changed' situation.

Regards,

Gordon

[rcandeo]

The macros are fired only in the oppening of the document, but they are not the problem, since I commented everything and the problem continues.

[rwunderlich · Accepted solution]

rcandeo wrote:
Yes, I use reduction. And why is not reloading automatically with my publisher?<div></div>

Are you using Section Access? In the Section Access line that contains the Publisher Account, do you have any value in the reduction field? You cannot have any value in this field, even "*'.

-Rob

[rcandeo]

After taking out the information for the publisher account, it doesn't ask me to save it anytime, But it gaves error in my publisher yet. Do You have any idea why?

531091 2009-04-17 09:09:18NormalInformation<div>
Loading document "E:\QVW_Publicados\ADMV_Demonstrativo_de_Vendas com Carteira.qvw" (23.18 Mb) </div>
531092 2009-04-17 09:09:18NormalError<div>
The document failed to open. </div>
531097 2009-04-17 09:09:18NormalInformation<div>
Closed the QlikView Engine successfully. ProcessID=4680 </div>
531099 2009-04-17 09:09:18NormalInformation<div>
Performance data (Load): Initializing load (0), Checking read (0), Creating QlikView Engine (0), Checking Size (31), Load (47), Load Completed (203) </div>
531101 2009-04-17 09:09:18NormalInformation<div>
Performance data (Checkout): Initializing Checkout (0), Loading document (281), Load completed (828), Document not found (828) </div>
531104 2009-04-17 09:09:18NormalInformation<div>
Performance data (Checkin): Initializing (0), Finished (0) </div>
531107 2009-04-17 09:09:18NormalError<div>
Reload failed because the document could not be opened successfully. DocumentState=DocumentNotFound </div>
531108 2009-04-17 09:09:18NormalInformation<div>
Checkin </div>
531109 2009-04-17 09:09:18NormalInformation<div>
Performance data (Checkin): Initializing (0), Finished (0) </div>
531110 2009-04-17 09:09:18NormalWarning<div>
Reload skipped for document "E:\QVW_Publicados\ADMV_Demonstrativo_de_Vendas com Carteira.qvw" because document "E:\QVW_Publicados\FIN_Dados_de_Clientes_Credito_e_Contas_a_Receber.qvw" failed to reload.

[rwunderlich]

I can't see what the error message is from the posting. Looks like your paste got truncated (new forum growing pains).

Take a look at the document log (ADMV_Demonstration_de_Vendcom_Carteria.qvw.log) to see what the specifics of the error may be. If you're not generating a document log, open the Document Properties and check "Generate logfile" on the General tab.

-Rob