Hello ALL!
I got strage problem. While perfoming long update i got error 8646 (The inde
x entry for row ID was not found in index ID 2, of table 641098466, in data
base 'MyBase').
At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a DELETE
or UPDATE Against a Table That Contains a Unicode Column with a Latin1_Gene
ral_BIN Collation'
But my collation is SQL_Latin1_general_CP1251_CI_AS and that table 64109846
6 have not Unicode Columns.
What is wrong?What does DBCC CHECKDB and DBCC CHECKCTALOG say? Any errors? You might just
have some database corruption.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Volhv" <anonymous@.discussions.microsoft.com> wrote in message
news:9E597526-356A-435A-A760-629C1141A3F9@.microsoft.com...
> Hello ALL!
> I got strage problem. While perfoming long update i got error 8646 (The
index entry for row ID was not found in index ID 2, of table 641098466, in
database 'MyBase').
> At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a
DELETE or UPDATE Against a Table That Contains a Unicode Column with a
Latin1_General_BIN Collation'
> But my collation is SQL_Latin1_general_CP1251_CI_AS and that table
641098466 have not Unicode Columns.
> What is wrong?
>|||All DBCC comand say nothing. After this error i run
dbcc checktable & dbcc dbreindex
After this all work fine until next ocurency of this error|||In addition to Tibor's suggestion,
Be watchful of potential hardware error which may be causing this... AND
since the index ID is = 2, this is a non-clustered index... You might try to
drop and re-create the non-clustered index...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Volhv" <anonymous@.discussions.microsoft.com> wrote in message
news:9E597526-356A-435A-A760-629C1141A3F9@.microsoft.com...
> Hello ALL!
> I got strage problem. While perfoming long update i got error 8646 (The
index entry for row ID was not found in index ID 2, of table 641098466, in
database 'MyBase').
> At microsoft site i found: 'FIX: Error 644 or 8646 May Occur During a
DELETE or UPDATE Against a Table That Contains a Unicode Column with a
Latin1_General_BIN Collation'
> But my collation is SQL_Latin1_general_CP1251_CI_AS and that table
641098466 have not Unicode Columns.
> What is wrong?
>|||Yes its non-clustered index and i done drop and re-create...
Hardware problem...i do not think so. I shrink base, defragment, recreating
and so on. I think real place of this index derfert after this operations a
nd problem occured only in one table. This table at the and of transaction a
nd data move to it via trig
ger.
Showing posts with label alli. Show all posts
Showing posts with label alli. Show all posts
Tuesday, March 27, 2012
Monday, March 19, 2012
Error 70038 on install Solved!
Hi all
I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
--
Any ideas?
TIA
Gary
Hi Gary,
I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.
Have a nice day
Ralf.
|||Hi RalfThanks for your posting. Works beautifully!
Gary|||
I also got the same error,
I see in the log
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
In the package.xml file it states that:
<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>
Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?
Error 70038 on install Solved!
Hi all
I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
--
Any ideas?
TIA
Gary
Hi Gary,
I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.
Have a nice day
Ralf.
|||Hi RalfThanks for your posting. Works beautifully!
Gary|||
I also got the same error,
I see in the log
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
In the package.xml file it states that:
<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>
Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?
Error 70038 on install
Hi all
I packaged .Net Framework & Sql Express with my setup project. When I attempt to install it on an XP (with SP2) system .Net Framework installs fine. The Sql Express gets about 25% of the way through then fails. Here's the content of the log file:
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.2 {version}
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '6.0.2900.2180'
Setting value '6.0.2900.2180 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 6.0.2900.2180 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition', phase BuildList
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
EULA for components 'SQL Server 2005 Express Edition' was accepted.
Copying files to temporary directory "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\"
Copying from '\\.host\Shared Folders\G-CDRW\MovieCollection Setup\Debug\SqlExpress\sqlexpr32.exe' to 'C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe'
Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage
Running external check with command line "C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SqlExpress\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\Gary\LOCALS~1\Temp\VSDA0.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1'
Process exited with code 70038
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
--
Any ideas?
TIA
Gary
Hi Gary,
I got the same error today on my Win XP SP2 workstation. An update for the MSI installer to Version 3.1 helped. After that, SQLexpress could be installed correctly.
Have a nice day
Ralf.
|||Hi RalfThanks for your posting. Works beautifully!
Gary|||
I also got the same error,
I see in the log
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SqlExpress\sqlexpr32.exe'
In the package.xml file it states that:
<BypassIf Property="VersionNT" Compare="VersionGreaterThanOrEqualTo" Value="5.1"/>
Should this be there? Why would we bypass sql installation if VersionNT is >= 5.1?
Subscribe to:
Posts (Atom)