Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello again.
I get this error in my log when trying to reload a task.
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
However, I use an login which has access on my SQL database.
So i am not using a windows user, but an SQL user..
Hi,
The script is only used to load data. Once the data is loaded and the QVW is published you son't need the script. The Source file will still have the script for future reloads.
Bill
I think i got it to work - Apparently it didnt register that i changed my credentials. But it does now.
However, when i reload it removes all my scripting??
Hi,
Gald to see you got it working. If you are reloading using publisher it does remove the script that is put out on the accesspoint. No, there isn't away to stop publisher from doing that.
Bill
Okay, now im curious.
If it removes my script - How is anyone able to see my data then?
Cause when it removed my script, it also stops loading data.
Maybe im doing something wrong?
I can post my log file after it removed my script:
Before it removed my log contained all my scriptning, and i was able to see data in qvw file. But now there is only design elements and my expressions.
2013-05-31 12:39:53: Execution started.
2013-05-31 12:39:53: QlikView Version:11.20.11922.0
2013-05-31 12:39:53: CPU Target x64
2013-05-31 12:39:53: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
2013-05-31 12:39:53: Wow64 mode Not using Wow64
2013-05-31 12:39:53: MDAC Version 6.1.7601.17514
2013-05-31 12:39:53: MDAC Full Install Version 6.1.7601.17514
2013-05-31 12:39:53: PreferredCompression 2
2013-05-31 12:39:53: EnableParallelReload 1
2013-05-31 12:39:53: ParallelizeQvdLoads 1
2013-05-31 12:39:53: AutoSaveAfterReload 0
2013-05-31 12:39:53: BackupBeforeReload 0
2013-05-31 12:39:53: EnableFlushLog 0
2013-05-31 12:39:53: SaveInfoWhenSavingFile 0
2013-05-31 12:39:53: UserLogfileCharset 1200
2013-05-31 12:39:53: OdbcLoginTimeout -1
2013-05-31 12:39:53: OdbcConnectionTimeout -1
2013-05-31 12:39:53: ScriptWantsDbWrite false
2013-05-31 12:39:53: ScriptWantsExe false
2013-05-31 12:39:53: LogFile CodePage Used: 1200
2013-05-31 12:39:53: Reload Executed By XXXXXXX\qvadmin
2013-05-31 12:39:53: Process Executing: QVB
2013-05-31 12:39:53: Process ID: 4128
2013-05-31 12:39:53: Execution finished.
Hi,
The script is only used to load data. Once the data is loaded and the QVW is published you son't need the script. The Source file will still have the script for future reloads.
Bill
But this here is what my source file looks like in my script:
// Write your script here. Note: Reload is disabled upon distribution. Enable by changing the checkbox at Settings->Document preferences->Security->Reload.
Is it because i have set the Documents and Source Doucments to the same path? So it maybe overwrites my Source doucment, and thereby deletes my scripting?
Yes, you should never so that.
Bill
Thanks alot