Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have been presented with a complication when reloading my qvw file through the qlikview management console, but when I recharge it from qvw I have no problem, this is the message it throws at me.
07/01/2018 8:33:25 PM: Execution started.
07/01/2018 8:33:25 PM: QlikView Version:11.20.12577.0
07/01/2018 8:33:25 PM: CPU Target x64
07/01/2018 8:33:25 PM: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)
07/01/2018 8:33:25 PM: Wow64 mode Not using Wow64
07/01/2018 8:33:25 PM: MDAC Version 6.1.7601.17514
07/01/2018 8:33:25 PM: MDAC Full Install Version 6.1.7601.17514
07/01/2018 8:33:25 PM: PreferredCompression 2
07/01/2018 8:33:25 PM: EnableParallelReload 1
07/01/2018 8:33:25 PM: ParallelizeQvdLoads 1
07/01/2018 8:33:25 PM: AutoSaveAfterReload 0
07/01/2018 8:33:25 PM: BackupBeforeReload 0
07/01/2018 8:33:25 PM: EnableFlushLog 0
07/01/2018 8:33:25 PM: SaveInfoWhenSavingFile 0
07/01/2018 8:33:25 PM: UserLogfileCharset 1200
07/01/2018 8:33:25 PM: OdbcLoginTimeout -1
07/01/2018 8:33:25 PM: OdbcConnectionTimeout -1
07/01/2018 8:33:25 PM: ScriptWantsDbWrite false
07/01/2018 8:33:25 PM: ScriptWantsExe false
07/01/2018 8:33:25 PM: LogFile CodePage Used: 1200
07/01/2018 8:33:25 PM: Reload Executed By SAN_LORENZO\AdminQV
07/01/2018 8:33:25 PM: Process Executing: QVB
07/01/2018 8:33:25 PM: Process ID: 5988
07/01/2018 8:33:25 PM: 0002 SET ThousandSep=','
07/01/2018 8:33:25 PM: 0003 SET DecimalSep='.'
07/01/2018 8:33:25 PM: 0004 SET MoneyThousandSep=','
07/01/2018 8:33:25 PM: 0005 SET MoneyDecimalSep='.'
07/01/2018 8:33:25 PM: 0006 SET MoneyFormat='S/. #,##0.00;S/. -#,##0.00'
07/01/2018 8:33:25 PM: 0007 SET TimeFormat='hh:mm:ss TT'
07/01/2018 8:33:25 PM: 0008 SET DateFormat='DD/MM/YYYY'
07/01/2018 8:33:25 PM: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT'
07/01/2018 8:33:25 PM: 0010 SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic'
07/01/2018 8:33:25 PM: 0011 SET DayNames='lun;mar;mié;jue;vie;sáb;dom'
07/01/2018 8:33:25 PM: 0017 OLEDB CONNECT32*Provider*
07/01/2018 8:33:25 PM: Error: ErrorSource: (null), ErrorMsg: (null)
07/01/2018 8:33:25 PM: General Script Error
07/01/2018 8:33:25 PM: Execution Failed
07/01/2018 8:33:25 PM: Execution finished.
This is my connection string:
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Produccion;Data Source=PELIMDATABASE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SLPBI;Use Encryption for Data=False;Tag with column collation when possible=False];
I hope to support me.
Thank you very much Community.
Best regards,
Are you connecting from different Work station or same?
Sure, Can we talk little more when you say different AMI that means you are not carrying DB with the same machine. Can you explain with some cluster / node level so then i can understand the concern exactly where you are?
Hi loveisfail,
The server where qlikview is installed is a different one in which we have the BD from which we extract the data. I did not answer your question or how you could guide me to answer your question.
Best regards,
I am trying to help you as much i know ..
Here, Have you connected using 32 bit? If so, Have you forced "Force 32" checked using Qlik?
Hi Juan,
Your getting when you run manually? or when you started job in QMC?
Regards
Sathish
Hi,
try to create a New Connection string With password to DB:
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=ProDB;Data Source=N\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=H9;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is CFaMQRdNODdeWaJOaA);
For me it looks like you haven't installed the same ODBC driver on your server computer as you have on your workstation. SQLOLEDB indicates that it is the Microsoft SQL Server driver you are using. Make sure that this driver has been installed on the server.