12 Replies Latest reply: Oct 14, 2014 4:44 PM by Bill Britt RSS

    Error during reload: two docs with the same process ID

    Michele Barini

      Hi,

      I have the following problem: we had several (inherited) old documents to reload every day and we use some batches because at the end of some of the docs there are macros to export data in excel/qvd files. Those excel/qvd files are the sources for the following reports.

      In the batch I use the qv.exe if there are macro in the doc, otherwise the qvdistributionservice.exe (enabled batch mode).

      Some of the batches could run at the same time.

       

      Sometimes the reload fails, and often I verified that I have two documents reload with the same process ID (in red in the logs below). Is this(2 docs sharing the same process ID) the problem? Or this is ok, and the problem is different?

       

      ///////////////////////////////////////////////////////////////////////////////////////////////////////

      10/10/2014: Execution started.
      10/10/2014: QlikView Version:11.20.12235.0
      10/10/2014: CPU Target               x64
      10/10/2014: Operating System         Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
      10/10/2014: Wow64 mode               Not using Wow64
      10/10/2014: MDAC Version             6.1.7601.17514
      10/10/2014: MDAC Full Install Version6.1.7601.17514
      10/10/2014: PreferredCompression     2
      10/10/2014: EnableParallelReload     1
      10/10/2014: ParallelizeQvdLoads      1
      10/10/2014: AutoSaveAfterReload      0
      10/10/2014: BackupBeforeReload       0
      10/10/2014: EnableFlushLog           0
      10/10/2014: SaveInfoWhenSavingFile   0
      10/10/2014: UserLogfileCharset       1200
      10/10/2014: OdbcLoginTimeout         -1
      10/10/2014: OdbcConnectionTimeout    -1
      10/10/2014: ScriptWantsDbWrite       false
      10/10/2014: ScriptWantsExe           false
      10/10/2014: LogFile CodePage Used:   1200
      10/10/2014:  Reload Executed By QW\install
      10/10/2014:  Process Executing: QVB
      10/10/2014:  Process ID: 19708

      10/10/2014: 0002  SET ThousandSep=','

      10/10/2014: 0003  SET DecimalSep='.'

      10/10/2014: 0004  SET MoneyThousandSep=','

      10/10/2014: 0005  SET MoneyDecimalSep='.'

      10/10/2014: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

      10/10/2014: 0007  SET TimeFormat='h:mm:ss TT'

      10/10/2014: 0008  SET DateFormat='DD/MM/YYYY'

      10/10/2014: 0009  SET TimestampFormat='DD/MM/YYYY'

      10/10/2014: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

      10/10/2014: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

      10/10/2014: 0018  OLEDB CONNECT*Provider*XPassword*

      10/10/2014: 0019  SET PATH_QVD = 'E:\ReportQlik_Source\QVD\'

      [....]

      ///////////////////////////////////////////////////////////////////////////////////////////////////////

      ///////////////////////////////////////////////////////////////////////////////////////////////////////

      10/10/2014 6.54.21: Execution started.
      10/10/2014 6.54.21: QlikView Version:11.20.12235.0
      10/10/2014 6.54.21: CPU Target               x64
      10/10/2014 6.54.21: Operating System         Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
      10/10/2014 6.54.21: Wow64 mode               Not using Wow64
      10/10/2014 6.54.21: MDAC Version             6.1.7601.17514
      10/10/2014 6.54.21: MDAC Full Install Version6.1.7601.17514
      10/10/2014 6.54.21: PreferredCompression     2
      10/10/2014 6.54.21: EnableParallelReload     1
      10/10/2014 6.54.21: ParallelizeQvdLoads      1
      10/10/2014 6.54.21: AutoSaveAfterReload      0
      10/10/2014 6.54.21: BackupBeforeReload       0
      10/10/2014 6.54.21: EnableFlushLog           0
      10/10/2014 6.54.21: SaveInfoWhenSavingFile   0
      10/10/2014 6.54.21: UserLogfileCharset       1200
      10/10/2014 6.54.21: OdbcLoginTimeout         -1
      10/10/2014 6.54.21: OdbcConnectionTimeout    -1
      10/10/2014 6.54.21: ScriptWantsDbWrite       false
      10/10/2014 6.54.21: ScriptWantsExe           false
      10/10/2014 6.54.21: LogFile CodePage Used:   1200
      10/10/2014 6.54.21:  Reload Executed By QW\install
      10/10/2014 6.54.21:  Process Executing: QVB
      10/10/2014 6.54.21:  Process ID: 19708

      10/10/2014 6.54.21: 0002  SET ThousandSep='.'

      10/10/2014 6.54.21: 0003  SET DecimalSep=','

      10/10/2014 6.54.21: 0004  SET MoneyThousandSep='.'

      10/10/2014 6.54.21: 0005  SET MoneyDecimalSep=','

      10/10/2014 6.54.21: 0006  SET MoneyFormat='€ #.##0,00;-€ #.##0,00'

      10/10/2014 6.54.21: 0007  SET TimeFormat='h.mm.ss'

      10/10/2014 6.54.21: 0008  SET DateFormat='DD/MM/YYYY'

      10/10/2014 6.54.21: 0009  SET TimestampFormat='DD/MM/YYYY h.mm.ss[.fff]'

      10/10/2014 6.54.21: 0010  SET MonthNames='Gen;Feb;Mar;Apr;Mag;Giu;Lug;Ago;Set;Ott;Nov;Dic'

      10/10/2014 6.54.21: 0011  SET DayNames='Lun;Mar;Mer;Gio;Ven;Sab;Dom'

      10/10/2014 6.54.21: 0018  OLEDB CONNECT*Provider*XPassword*

      10/10/2014 6.54.21: 0020  Movimenti_SG_CA_CG:

      10/10/2014 6.54.21: 0021  SQL select

      [....]

      ///////////////////////////////////////////////////////////////////////////////////////////////////////

       

      Thanks