We get an Error 8162 when one of our SQR programs attempt
to insert records into a table. The error is irratic
since it does not always occur. We have been unable to
determine exactly what this error means or what may be
causing it. The full error message we get is listed below:
"(SQR 5528) ODBC SQL dbexec: SQLExecute error 8162 in
cursor 18: [MICROSOFT] [ODBD SQL Server Driver] [SQL
Server] Formal parameter '@.P21' was defined as OUTPUT but
the actual parameter not declared OUTPUT."Looks like a mismatch in procedure parameters. Have you tried dropping and
recerating the stored proc and then running it?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Showing posts with label attempt. Show all posts
Showing posts with label attempt. Show all posts
Thursday, March 22, 2012
Monday, March 19, 2012
Error 7317 when Accessing Linked Oracle Server
I have a linked server to an Oracle 8i database. When I attempt to query th
e
Oracle tables I get the following error:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned an invalid schema definition.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid schema definition.].
The problem is occurring at my customer's site. I have tried duplicating
their environment in my office, but I can not reporduce the problem.
I would appreciate any help you could offer.
Thanks,
Bill Manring
Chief Software Architect
Wavefront Software, Inc.I found an answer to this problem so I thought I should post it in case
anyone else has a similar problem.
If I execute the query using the OPENQUERY function, the query executes
properly. Since OPENQUERY is a peferred way of querying linked srevers
anyway, there really is no problem.
"Bill Manring" wrote:
> I have a linked server to an Oracle 8i database. When I attempt to query
the
> Oracle tables I get the following error:
> Server: Msg 7317, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' returned an invalid schema definition.
> OLE DB error trace [Non-interface error: OLE/DB provider returned an
> invalid schema definition.].
> The problem is occurring at my customer's site. I have tried duplicating
> their environment in my office, but I can not reporduce the problem.
> I would appreciate any help you could offer.
>
> --
> Thanks,
> Bill Manring
> Chief Software Architect
> Wavefront Software, Inc.
e
Oracle tables I get the following error:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned an invalid schema definition.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid schema definition.].
The problem is occurring at my customer's site. I have tried duplicating
their environment in my office, but I can not reporduce the problem.
I would appreciate any help you could offer.
Thanks,
Bill Manring
Chief Software Architect
Wavefront Software, Inc.I found an answer to this problem so I thought I should post it in case
anyone else has a similar problem.
If I execute the query using the OPENQUERY function, the query executes
properly. Since OPENQUERY is a peferred way of querying linked srevers
anyway, there really is no problem.
"Bill Manring" wrote:
> I have a linked server to an Oracle 8i database. When I attempt to query
the
> Oracle tables I get the following error:
> Server: Msg 7317, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' returned an invalid schema definition.
> OLE DB error trace [Non-interface error: OLE/DB provider returned an
> invalid schema definition.].
> The problem is occurring at my customer's site. I have tried duplicating
> their environment in my office, but I can not reporduce the problem.
> I would appreciate any help you could offer.
>
> --
> Thanks,
> Bill Manring
> Chief Software Architect
> Wavefront Software, Inc.
Error 7317 when Accessing Linked Oracle Server
I have a linked server to an Oracle 8i database. When I attempt to query the
Oracle tables I get the following error:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned an invalid schema definition.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid schema definition.].
The problem is occurring at my customer's site. I have tried duplicating
their environment in my office, but I can not reporduce the problem.
I would appreciate any help you could offer.
Thanks,
Bill Manring
Chief Software Architect
Wavefront Software, Inc.
I found an answer to this problem so I thought I should post it in case
anyone else has a similar problem.
If I execute the query using the OPENQUERY function, the query executes
properly. Since OPENQUERY is a peferred way of querying linked srevers
anyway, there really is no problem.
"Bill Manring" wrote:
> I have a linked server to an Oracle 8i database. When I attempt to query the
> Oracle tables I get the following error:
> Server: Msg 7317, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' returned an invalid schema definition.
> OLE DB error trace [Non-interface error: OLE/DB provider returned an
> invalid schema definition.].
> The problem is occurring at my customer's site. I have tried duplicating
> their environment in my office, but I can not reporduce the problem.
> I would appreciate any help you could offer.
>
> --
> Thanks,
> Bill Manring
> Chief Software Architect
> Wavefront Software, Inc.
Oracle tables I get the following error:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned an invalid schema definition.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid schema definition.].
The problem is occurring at my customer's site. I have tried duplicating
their environment in my office, but I can not reporduce the problem.
I would appreciate any help you could offer.
Thanks,
Bill Manring
Chief Software Architect
Wavefront Software, Inc.
I found an answer to this problem so I thought I should post it in case
anyone else has a similar problem.
If I execute the query using the OPENQUERY function, the query executes
properly. Since OPENQUERY is a peferred way of querying linked srevers
anyway, there really is no problem.
"Bill Manring" wrote:
> I have a linked server to an Oracle 8i database. When I attempt to query the
> Oracle tables I get the following error:
> Server: Msg 7317, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' returned an invalid schema definition.
> OLE DB error trace [Non-interface error: OLE/DB provider returned an
> invalid schema definition.].
> The problem is occurring at my customer's site. I have tried duplicating
> their environment in my office, but I can not reporduce the problem.
> I would appreciate any help you could offer.
>
> --
> Thanks,
> Bill Manring
> Chief Software Architect
> Wavefront Software, Inc.
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?
Sunday, March 11, 2012
Error 605, 823
Does anyone see these errors before? How did you fixed it?
Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
object '0', not to object '#1AB78AA5'..
Error: 605, Severity: 21, State: 1
... IAM indicates that page is allocated to this object
(4:27456)/(4:27456) 0/448236197
pageno is/should be: objid is/should be:
Getpage: bstat=0x9, sstat=0x4800, cache
I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
file 'I:\MSSQL\Data\tempdb1.mdf'..
Error: 823, Severity: 24, State: 2
Thanks,
LijunGeneral recommendations for corrupt or suspect databases:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lijun Zhang" <nospam@.nospam.nospam> wrote in message news:usIUpWzdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Does anyone see these errors before? How did you fixed it?
> Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
> object '0', not to object '#1AB78AA5'..
> Error: 605, Severity: 21, State: 1
> ... IAM indicates that page is allocated to this object
> (4:27456)/(4:27456) 0/448236197
> pageno is/should be: objid is/should be:
> Getpage: bstat=0x9, sstat=0x4800, cache
> I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
> file 'I:\MSSQL\Data\tempdb1.mdf'..
> Error: 823, Severity: 24, State: 2
>
> Thanks,
> Lijun
>
Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
object '0', not to object '#1AB78AA5'..
Error: 605, Severity: 21, State: 1
... IAM indicates that page is allocated to this object
(4:27456)/(4:27456) 0/448236197
pageno is/should be: objid is/should be:
Getpage: bstat=0x9, sstat=0x4800, cache
I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
file 'I:\MSSQL\Data\tempdb1.mdf'..
Error: 823, Severity: 24, State: 2
Thanks,
LijunGeneral recommendations for corrupt or suspect databases:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lijun Zhang" <nospam@.nospam.nospam> wrote in message news:usIUpWzdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Does anyone see these errors before? How did you fixed it?
> Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
> object '0', not to object '#1AB78AA5'..
> Error: 605, Severity: 21, State: 1
> ... IAM indicates that page is allocated to this object
> (4:27456)/(4:27456) 0/448236197
> pageno is/should be: objid is/should be:
> Getpage: bstat=0x9, sstat=0x4800, cache
> I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
> file 'I:\MSSQL\Data\tempdb1.mdf'..
> Error: 823, Severity: 24, State: 2
>
> Thanks,
> Lijun
>
Error 605 when checkin a 6.5 db
I am getting an Error 605:
'Attempt to fetch logical page <page#> in database <db> belongs to object 0, not to object <table1>'
Does anyone know if this is data corruption or if it is a problem worse than that, and how to begin to address it?
Any help will be much appreciated.
Thank youDo you know what is causing this error ? When is this error generated ?|||Generally that indicates data and / or index corruption, from your specific message most probably corruption in object <table1>.
Q1 Have you at least run dbcc checktable ('table1') WITH ALL_ERRORMSGS on table1?
Normally one would also subsequently perform a dbcc checkdb ('DBName') WITH ALL_ERRORMSGS to make sure there are not issues with / in other objects. (Depending on the results you may need to either perform repairs, restore from backup dumps, etc.)|||Which service pack do you have installed ? There are other less common causes for error 605 - that is why I asked when does the error occur. If it is related to system table(s), you can use sp_fixindex to correct index pages - if the errors exist within data pages you may have to restore from a backup. Otherwise, if you think that it is a corruption then run dbcc checkdb/checkalloc.|||A good point, (certainly if checktable, checkdb, etc. have already indicated that the objects are error free? then the cause(s) likely lie elsewhere).
In any case, more information in such circumstances, (what has been done, some level of system information, etc.), usually makes it much easier to diagnose issue(s) and give you more useful / helpful feedback.|||Thank you all for your replies, we ended up creating a new table and inserting (by chunks) into the new table until the process hung, then trying to find the problem record. Once pinpointed, we selected everything before and after into a new table, dropped the old table and renamed the new table.|||You are welcome.
It is fortunate that not much data was corrupt; Sql Server version. 6.5 supported table level restores (something you may wish to consider implementing to save time, if more row corruption issues arise in the table again). You may also wish to consider periodically running a dbcc checkdb ('DBName') WITH ALL_ERRORMSGS to make sure there are not similar issues with other objects.|||Happy to help.
I remember a time with sql server 7 a similar situation. We had 1 bad pointer (text field) and had to isolate it just as you did. Replication kept bombing during the bcp. It was difficult to find since the table had hundred of thousands of records and the bad field was near the end - replication did not specify a problem with the bcp and as you watched bcp run it appeared it had processed all the records (since the corruption was at the end).
'Attempt to fetch logical page <page#> in database <db> belongs to object 0, not to object <table1>'
Does anyone know if this is data corruption or if it is a problem worse than that, and how to begin to address it?
Any help will be much appreciated.
Thank youDo you know what is causing this error ? When is this error generated ?|||Generally that indicates data and / or index corruption, from your specific message most probably corruption in object <table1>.
Q1 Have you at least run dbcc checktable ('table1') WITH ALL_ERRORMSGS on table1?
Normally one would also subsequently perform a dbcc checkdb ('DBName') WITH ALL_ERRORMSGS to make sure there are not issues with / in other objects. (Depending on the results you may need to either perform repairs, restore from backup dumps, etc.)|||Which service pack do you have installed ? There are other less common causes for error 605 - that is why I asked when does the error occur. If it is related to system table(s), you can use sp_fixindex to correct index pages - if the errors exist within data pages you may have to restore from a backup. Otherwise, if you think that it is a corruption then run dbcc checkdb/checkalloc.|||A good point, (certainly if checktable, checkdb, etc. have already indicated that the objects are error free? then the cause(s) likely lie elsewhere).
In any case, more information in such circumstances, (what has been done, some level of system information, etc.), usually makes it much easier to diagnose issue(s) and give you more useful / helpful feedback.|||Thank you all for your replies, we ended up creating a new table and inserting (by chunks) into the new table until the process hung, then trying to find the problem record. Once pinpointed, we selected everything before and after into a new table, dropped the old table and renamed the new table.|||You are welcome.
It is fortunate that not much data was corrupt; Sql Server version. 6.5 supported table level restores (something you may wish to consider implementing to save time, if more row corruption issues arise in the table again). You may also wish to consider periodically running a dbcc checkdb ('DBName') WITH ALL_ERRORMSGS to make sure there are not similar issues with other objects.|||Happy to help.
I remember a time with sql server 7 a similar situation. We had 1 bad pointer (text field) and had to isolate it just as you did. Replication kept bombing during the bcp. It was difficult to find since the table had hundred of thousands of records and the bad field was near the end - replication did not specify a problem with the bcp and as you watched bcp run it appeared it had processed all the records (since the corruption was at the end).
Friday, March 9, 2012
Error 500 Takes it's toll
The Error:
An attempt to attach an auto-named database for file C:\Users\CodeFreak\Documents\Visual Studio 2005\WebSites\PersonalSite\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I've tried allowing permissions I'VE EVEN TRIED ALLOWING EVERYONE! I've tried right clicking the datasource under the datasource explorer and clicking 'detatch.' It works Locally but fails when i pusblish with IIS. Whats with these SQL databases that just dont want to work with IIS 7 ?
Published with: IIS 7
I've tried removing the "user instance."
This is User roles and all that which uses SQL Server 2005.
So my question is, How do i publish a website with SQL Server 2005 database? 
Please give it to me step by step as im still quite a newbie.
Thanks in advance
Does the Account the Web Service is running with have the appropiate permissions to access the file ? Did you made sure that once the database is opened, the connection is reused at the second time the database is accessed ? Do you have the autoclose property set on or off ?Jens K. Suessmeyer.
http://www.sqlserver2008.de
|||It was automatically set up, I checked the permissions in both NTFS and the website's permissions they all checked out fine|||
Auto CLose?
Can you elaborate?
I even tried Microsoft's template which failed aswell
I just don't know how to publish a web page after i click and drag a login for and use the administer options to create accounts and set permissions. Remember I'm still a newbie when it comes to aspx, VWD and IIS. I've only used HTML 2 weeks ago (ps. I'm a fast learner). So I would perfer step by step instructions. It works fine during debug but falls over on publish (yes i closed VWD).
|||Problem solved. It turns out I put it in the same directory as the website.
Moving it (and modifying the connection string accordingly works)
Old connectiong String (From web.config)
data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|datadirectory|aspnetdb.mdf;User Instance=true
Modified Connection String -works (after moving the database files of course)
data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=C:\Mydatabase\aspnetdb.mdf;User Instance=true
Soo easy, I couldn't believe I missed it!
Wednesday, February 15, 2012
Error 208
Running - SQL 2K Win2K
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
Subscribe to:
Posts (Atom)