Cummulative

Jan 19, 2005

I'm having trouble creating a cummulative column in a table.

I've got the following table, sorted ASC PAID

Claim_Number Paid
123 $21.22
124 $34,87
456 $42.90
478 $67.00
890 $100.10

I want to add a column (in a new table) with the cummulative total paid. It should look like

Claim_Number Paid Cummulative
123 $21.00 $21.00
124 $34.00 $55.00
456 $42.00 $97.00
478 $67.00 $164.00
890 $100.00 $264.00


Thanks for the help.

Ray

View 9 Replies


ADVERTISEMENT

Cummulative Total

Feb 23, 2007

I'm trying to show a running sum on a set of records ordered by
Date and Order Number to prioritize shipments by first-in-first-out.


CREATE TABLE #TMP (
DUE_DATE DATETIME,
ORD_NUM CHAR(10),
PRODUCT CHAR(3),
TONS REAL)

INSERT INTO #TMP
SELECT '2/23/07', '07026.0030', 'ABC', 3.375
UNION ALL
SELECT '2/23/07', '07047.0059', 'ABC', 3.375
UNION ALL
SELECT '2/23/07', '07053.0080', 'ABC', 3.375
UNION ALL
SELECT '2/24/07', '07045.0030', 'ABC', 2.25
UNION ALL
SELECT '2/25/07','07045.0027','ABC',1.125
UNION ALL
SELECT '2/25/07','07046.0070','ABC',6.75

SELECT T1.PRODUCT, T1.DUE_DATE, T1.ORD_NUM, T1.TONS,
'TTL_TONS'=(SELECT SUM(TONS) AS CUMM
FROM #TMP T2
WHERE T1.DUE_DATE>=T2.DUE_DATE AND T1.ORD_NUM>=T2.ORD_NUM )
FROM #TMP T1

DROP TABLE #TMP


The first 3 records returned show the right numbers in the ttl_tons column,
but then it falls apart after that?

Any hints?

View 14 Replies View Related

Error Installing Cummulative Update 4

May 28, 2008

Hi,

I am consulting for a client who would like to install Cummulative Update 4 on their server. We have tested it with no issues on their development and testing servers, but when I attempted the install in the production environment, the installer threw an error saying that the target software is not installed. The logs are included below. It is a 64 bit server that is running in a Veritas cluster, is a named instance, and is SP2.

For the main SQL Server Components:


=== Verbose logging started: 5/5/2008 18:48:18 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: s:90cb035184951b50b6hotfix.exe ===
MSI (c) (90:0C) [18:48:18:604]: Resetting cached policy values
MSI (c) (90:0C) [18:48:18:604]: Machine policy value 'Debug' is 0
MSI (c) (90:0C) [18:48:18:604]: ******* RunEngine:
******* Product: {26F1A218-3158-4107-B3A6-37FD61CEE969}
******* Action:
******* CommandLine: **********
MSI (c) (90:0C) [18:48:18:604]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (90:0C) [18:48:18:604]: Grabbed execution mutex.
MSI (c) (90:0C) [18:48:18:620]: Cloaking enabled.
MSI (c) (90:0C) [18:48:18:620]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (90:0C) [18:48:18:635]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (28:1C) [18:48:18:651]: Grabbed execution mutex.
MSI (s) (28:A4) [18:48:18:651]: Resetting cached policy values
MSI (s) (28:A4) [18:48:18:651]: Machine policy value 'Debug' is 0
MSI (s) (28:A4) [18:48:18:651]: ******* RunEngine:
******* Product: {26F1A218-3158-4107-B3A6-37FD61CEE969}
******* Action:
******* CommandLine: **********
MSI (s) (28:A4) [18:48:18:651]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (28:A4) [18:48:18:651]: Adding MSIINSTANCEGUID to command line.
MSI (s) (28:A4) [18:48:18:651]: End dialog not enabled
MSI (s) (28:A4) [18:48:18:651]: Original package ==> C:WINDOWSInstaller1504f0.msi
MSI (s) (28:A4) [18:48:18:651]: Package we're running from ==> C:WINDOWSInstaller1504f0.msi
MSI (s) (28:A4) [18:48:18:667]: APPCOMPAT: looking for appcompat database entry with ProductCode '{26F1A218-3158-4107-B3A6-37FD61CEE969}'.
MSI (s) (28:A4) [18:48:18:667]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (28:A4) [18:48:18:667]: Detected that this product uses a multiple instance transform.
MSI (s) (28:A4) [18:48:18:667]: MSCOREE not loaded loading copy from system32
MSI (s) (28:A4) [18:48:18:667]: Applying multiple instance transform 'qlRun01.mst'...
MSI (s) (28:A4) [18:48:18:667]: Looking for storage transform: SqlRun01.mst
MSI (s) (28:A4) [18:48:18:667]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (28:A4) [18:48:18:667]: Transform 'SqlRun01.mst' is valid.
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2205 2: 3: Patch
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (28:A4) [18:48:18:667]: TRANSFORM: Applying regular transform to database.
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (28:A4) [18:48:18:667]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (28:A4) [18:48:18:682]: File will have security applied from OpCode.
MSI (s) (28:A4) [18:48:18:839]: Original patch ==> s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp
MSI (s) (28:A4) [18:48:18:839]: Patch we're running from ==> C:WINDOWSInstaller70288546.msp
MSI (s) (28:A4) [18:48:18:839]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 's:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp' against software restriction policy
MSI (s) (28:A4) [18:48:18:839]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (28:A4) [18:48:18:839]: SOFTWARE RESTRICTION POLICY: s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp is not digitally signed
MSI (s) (28:A4) [18:48:18:839]: SOFTWARE RESTRICTION POLICY: s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (28:A4) [18:48:18:839]: SequencePatches starts. Product code: {26F1A218-3158-4107-B3A6-37FD61CEE969}, Product version: 9.00.1399.06, Upgrade code: {12EEFC9F-91FB-490B-B00B-7164C31C1650}, Product language 1033
MSI (s) (28:A4) [18:48:18:839]: 3.0 patch s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp is of type QFE
MSI (s) (28:A4) [18:48:18:839]: PATCH SEQUENCER: verifying the applicability of QFE patch s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp against product code: {26F1A218-3158-4107-B3A6-37FD61CEE969}, product version: 9.00.1399.06, product language 1033 and upgrade code: {12EEFC9F-91FB-490B-B00B-7164C31C1650}
MSI (s) (28:A4) [18:48:18:839]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (28:A4) [18:48:18:839]: Note: 1: 2749 2: Target01ToUpgrade01 3: C:WINDOWSInstaller70288546.msp 4: 9.2.3042.00 5: 9.00.1399.06
MSI (s) (28:A4) [18:48:18:839]: 1: 2749 2: Target01ToUpgrade01 3: C:WINDOWSInstaller70288546.msp 4: 9.2.3042.00 5: 9.00.1399.06
MSI (s) (28:A4) [18:48:18:839]: PATCH SEQUENCER: QFE patch s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp is not applicable.
MSI (s) (28:A4) [18:48:18:839]: SequencePatches returns success.
MSI (s) (28:A4) [18:48:18:839]: Final Patch Application Order:
MSI (s) (28:A4) [18:48:18:839]: Other Patches:
MSI (s) (28:A4) [18:48:18:839]: UnknownAbsent: {7DE23C0A-B5A2-4059-8D09-78C7EC955D10} - s:90cb035184951b50b6HotFixSQLFilessqlrun_sql.msp
MSI (s) (28:A4) [18:48:18:839]: Product: Microsoft SQL Server 2005 (64-bit) - Update '{7DE23C0A-B5A2-4059-8D09-78C7EC955D10}' could not be installed. Error code 1642. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB941450_sqlrun_sql.msp.log.

MSI (s) (28:A4) [18:48:18:839]: Note: 1: 1708
MSI (s) (28:A4) [18:48:18:839]: Note: 1: 2729
MSI (s) (28:A4) [18:48:18:839]: Note: 1: 2729
MSI (s) (28:A4) [18:48:18:839]: Product: Microsoft SQL Server 2005 (64-bit) -- Installation failed.

MSI (s) (28:A4) [18:48:18:854]: Attempting to delete file C:WINDOWSInstaller70288546.msp
MSI (s) (28:A4) [18:48:18:854]: MainEngineThread is returning 1642
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer an
d that you have the correct upgrade patch.
C:WINDOWSInstaller1504f0.msi
MSI (c) (90:0C) [18:48:18:854]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (90:0C) [18:48:18:854]: MainEngineThread is returning 1642
=== Verbose logging stopped: 5/5/2008 18:48:18 ===



And the SSIS log:

=== Verbose logging started: 5/5/2008 18:48:19 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: s:90cb035184951b50b6hotfix.exe ===
MSI (c) (90:18) [18:48:19:167]: Resetting cached policy values
MSI (c) (90:18) [18:48:19:167]: Machine policy value 'Debug' is 0
MSI (c) (90:18) [18:48:19:167]: ******* RunEngine:
******* Product: {85B1D7F9-2B84-4386-9947-8F362E247F0B}
******* Action:
******* CommandLine: **********
MSI (c) (90:18) [18:48:19:167]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (90:18) [18:48:19:167]: Grabbed execution mutex.
MSI (c) (90:18) [18:48:19:167]: Cloaking enabled.
MSI (c) (90:18) [18:48:19:167]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (90:18) [18:48:19:167]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (28:1C) [18:48:19:167]: Grabbed execution mutex.
MSI (s) (28:C4) [18:48:19:167]: Resetting cached policy values
MSI (s) (28:C4) [18:48:19:167]: Machine policy value 'Debug' is 0
MSI (s) (28:C4) [18:48:19:167]: ******* RunEngine:
******* Product: {85B1D7F9-2B84-4386-9947-8F362E247F0B}
******* Action:
******* CommandLine: **********
MSI (s) (28:C4) [18:48:19:167]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (28:C4) [18:48:19:182]: End dialog not enabled
MSI (s) (28:C4) [18:48:19:182]: Original package ==> C:WINDOWSInstaller1504e7.msi
MSI (s) (28:C4) [18:48:19:182]: Package we're running from ==> C:WINDOWSInstaller1504e7.msi
MSI (s) (28:C4) [18:48:19:198]: APPCOMPAT: looking for appcompat database entry with ProductCode '{85B1D7F9-2B84-4386-9947-8F362E247F0B}'.
MSI (s) (28:C4) [18:48:19:198]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (28:C4) [18:48:19:198]: File will have security applied from OpCode.
MSI (s) (28:C4) [18:48:19:276]: Original patch ==> s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp
MSI (s) (28:C4) [18:48:19:276]: Patch we're running from ==> C:WINDOWSInstaller70288547.msp
MSI (s) (28:C4) [18:48:19:276]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 's:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp' against software restriction policy
MSI (s) (28:C4) [18:48:19:276]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (28:C4) [18:48:19:276]: SOFTWARE RESTRICTION POLICY: s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp is not digitally signed
MSI (s) (28:C4) [18:48:19:276]: SOFTWARE RESTRICTION POLICY: s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (28:C4) [18:48:19:276]: SequencePatches starts. Product code: {85B1D7F9-2B84-4386-9947-8F362E247F0B}, Product version: 9.00.1399.06, Upgrade code: {75DE63C9-E446-411B-AF05-8DB2BC905232}, Product language 1033
MSI (s) (28:C4) [18:48:19:276]: 3.0 patch s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp is of type QFE
MSI (s) (28:C4) [18:48:19:276]: PATCH SEQUENCER: verifying the applicability of QFE patch s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp against product code: {85B1D7F9-2B84-4386-9947-8F362E247F0B}, product version: 9.00.1399.06, product language 1033 and upgrade code: {75DE63C9-E446-411B-AF05-8DB2BC905232}
MSI (s) (28:C4) [18:48:19:276]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (28:C4) [18:48:19:276]: Note: 1: 2749 2: Target01ToUpgrade01 3: C:WINDOWSInstaller70288547.msp 4: 9.2.3042.00 5: 9.00.1399.06
MSI (s) (28:C4) [18:48:19:276]: 1: 2749 2: Target01ToUpgrade01 3: C:WINDOWSInstaller70288547.msp 4: 9.2.3042.00 5: 9.00.1399.06
MSI (s) (28:C4) [18:48:19:276]: PATCH SEQUENCER: QFE patch s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp is not applicable.
MSI (s) (28:C4) [18:48:19:276]: SequencePatches returns success.
MSI (s) (28:C4) [18:48:19:276]: Final Patch Application Order:
MSI (s) (28:C4) [18:48:19:276]: Other Patches:
MSI (s) (28:C4) [18:48:19:276]: UnknownAbsent: {C958BA39-762E-4E13-87E8-A4F28457317B} - s:90cb035184951b50b6HotFixDTSFilessqlrun_dts.msp
MSI (s) (28:C4) [18:48:19:276]: Product: Microsoft SQL Server 2005 Integration Services (64-bit) - Update '{C958BA39-762E-4E13-87E8-A4F28457317B}' could not be installed. Error code 1642. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB941450_sqlrun_dts.msp.log.
MSI (s) (28:C4) [18:48:19:276]: Note: 1: 1708
MSI (s) (28:C4) [18:48:19:276]: Note: 1: 2729
MSI (s) (28:C4) [18:48:19:276]: Note: 1: 2729
MSI (s) (28:C4) [18:48:19:276]: Product: Microsoft SQL Server 2005 Integration Services (64-bit) -- Installation failed.
MSI (s) (28:C4) [18:48:19:292]: Attempting to delete file C:WINDOWSInstaller70288547.msp
MSI (s) (28:C4) [18:48:19:292]: MainEngineThread is returning 1642
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer an
d that you have the correct upgrade patch.
C:WINDOWSInstaller1504e7.msi
MSI (c) (90:18) [18:48:19:292]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (90:18) [18:48:19:292]: MainEngineThread is returning 1642
=== Verbose logging stopped: 5/5/2008 18:48:19 ===

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved