topic Re: Erro na carga pelo Server in Brasil https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238815#M43981 <HTML><HEAD></HEAD><BODY><P>e o odbc foi criado como DNS de usuário e não DNS de Sistema, que vale para todos os usuários.....</P><P></P><P>Se for oracle, configuração do TNS deste usuário (o do serviço)</P></BODY></HTML> Tue, 21 Feb 2017 22:14:16 GMT afurtado 2017-02-21T22:14:16Z Erro na carga pelo Server https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238813#M43979 <HTML><HEAD></HEAD><BODY><P>Boa tarde...</P><P></P><P>Estou com um erro na carga de dados pelo SERVER, segue o LOG abaixo, pelo desktop faz a carga normal.....</P><P></P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Execution started.</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QlikView Version:11.20.12664.0</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CPU Target&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x86</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Operating System&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Windows Server 2008 R2 Datacenter&nbsp; (64 bit edition)</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wow64 mode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using Wow64. 32 bit QlikView running on 64 bit OS</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MDAC Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.1.7600.16385</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MDAC Full Install Version&nbsp;&nbsp;&nbsp;&nbsp; 6.1.7600.16385</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PreferredCompression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EnableParallelReload&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ParallelizeQvdLoads&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AutoSaveAfterReload&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BackupBeforeReload&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EnableFlushLog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SaveInfoWhenSavingFile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UserLogfileCharset&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OdbcLoginTimeout&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OdbcConnectionTimeout&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ScriptWantsDbWrite&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; false</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ScriptWantsExe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; false</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LogFile CodePage Used:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Reload Executed By TS410\srv_qlikview</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Process Executing: QVB</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Process ID: 4768</P><P>21/02/2017 14:04:20: 0002&nbsp; SET ThousandSep='.'</P><P>21/02/2017 14:04:20: 0003&nbsp; SET DecimalSep=','</P><P>21/02/2017 14:04:20: 0004&nbsp; SET MoneyThousandSep='.'</P><P>21/02/2017 14:04:20: 0005&nbsp; SET MoneyDecimalSep=','</P><P>21/02/2017 14:04:20: 0006&nbsp; SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'</P><P>21/02/2017 14:04:20: 0007&nbsp; SET TimeFormat='hh:mm:ss'</P><P>21/02/2017 14:04:20: 0008&nbsp; SET DateFormat='DD/MM/YYYY'</P><P>21/02/2017 14:04:20: 0009&nbsp; SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'</P><P>21/02/2017 14:04:20: 0010&nbsp; SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'</P><P>21/02/2017 14:04:20: 0011&nbsp; SET DayNames='seg;ter;qua;qui;sex;sáb;dom'</P><P>21/02/2017 14:04:20: 0013&nbsp; ODBC CONNECT32*XUserId*XPassword*</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; General Script Error</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Execution Failed</P><P>21/02/2017 14:04:20:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Execution finished.</P></BODY></HTML> Tue, 21 Feb 2017 17:21:13 GMT https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238813#M43979 ruzivao1980 2017-02-21T17:21:13Z Re: Erro na carga pelo Server https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238814#M43980 <HTML><HEAD></HEAD><BODY><P>Roosevelt,</P><P></P><P>o que deve ser é que a carga pelo Server usa o usuário do serviço&nbsp; e que deve ser diferente do usuário que você conecta e abre o desktop.</P></BODY></HTML> Tue, 21 Feb 2017 22:12:40 GMT https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238814#M43980 afurtado 2017-02-21T22:12:40Z Re: Erro na carga pelo Server https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238815#M43981 <HTML><HEAD></HEAD><BODY><P>e o odbc foi criado como DNS de usuário e não DNS de Sistema, que vale para todos os usuários.....</P><P></P><P>Se for oracle, configuração do TNS deste usuário (o do serviço)</P></BODY></HTML> Tue, 21 Feb 2017 22:14:16 GMT https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238815#M43981 afurtado 2017-02-21T22:14:16Z Re: Erro na carga pelo Server https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238816#M43982 <HTML><HEAD></HEAD><BODY><P>also check if you need a 64 bit connection</P><P>instead of </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ODBC CONNECT32*XUserId*XPassword*</SPAN></P></BODY></HTML> Tue, 21 Feb 2017 22:19:11 GMT https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238816#M43982 maxgro 2017-02-21T22:19:11Z Re: Erro na carga pelo Server https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238817#M43983 <HTML><HEAD></HEAD><BODY><P>Valeu Alessandro, era isso mesmo.. tinha feito como usuário... coloquei no sistema e funcionou corretamente, obrigado</P></BODY></HTML> Wed, 22 Feb 2017 11:18:32 GMT https://community.qlik.com/t5/Brasil/Erro-na-carga-pelo-Server/m-p/1238817#M43983 ruzivao1980 2017-02-22T11:18:32Z