jjoz
asked on
Need help in SAP BPC and Infor Q&A Excel add-ins conflict
Hi,
I'm having problem in my Excel 2007 SP2 with the conflicting Excel Add ins (after the SAP BPC 7.5 add ins install the existing Infor Q&A keeps on infinite installing - MSI installer), does anyone know where and how to diagnose or troubleshoot this issue please ?
I'm having problem in my Excel 2007 SP2 with the conflicting Excel Add ins (after the SAP BPC 7.5 add ins install the existing Infor Q&A keeps on infinite installing - MSI installer), does anyone know where and how to diagnose or troubleshoot this issue please ?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Please check the keys in this registry location:
HKEY_LOCAL_MACHINE\SOFTWAR E\Microsof t\Office\E xcel\Addin s
Please post the name of your addins and the value of the LoadBehavior values.
HKEY_LOCAL_MACHINE\SOFTWAR
Please post the name of your addins and the value of the LoadBehavior values.
ASKER
ASKER
and this is what I have got when I click on the addin link
ExcelAddins-Error.JPG
ExcelAddins-Error.JPG
Does this happen even if you have closed Excel?
Have you tried to disable the Excel Add-in before you install? If not, does it fail even then?
Have you tried to disable the Excel Add-in before you install? If not, does it fail even then?
ASKER
yes I tried to disable the "Vision" / the other name of Infor Q&A before while installing the SAP BPC the installation is OK, SAP is happy, but then when I enable the Add ins and then execute it, it always failed and installing infinitely in every button that i pressed in the addins :-|
As you saw, you did not have the add-in in registry. Try to remove (uninstall) the Vision add-in from the system. Restart the system. Remove any pointers to this add-in from %appdata%\<username> and %appdata%\All Users
Try to install the file again with the parameters mentioned earlier in this thread.
Did you get a warning or error in the event log or did you get an information value saying MSI Installer succeeded?
Can you post the msi.log when you have run this command?
Try to install the file again with the parameters mentioned earlier in this thread.
msiexec /i package.msi /L*v C:\msi.log
Did you get a warning or error in the event log or did you get an information value saying MSI Installer succeeded?
Can you post the msi.log when you have run this command?
ASKER
OK, The actual Infor Q&A Addins is eventually working but not fully running smooth since in every command that I clicked I got the MSI install Error 1720 pop up and then the Warning below is always logged after the Error.
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 11720
Date: 5/04/2011
Time: 10:34:13 AM
User: WS-BPCT01\Administrator
Computer: WS-BPCT01
Description:
Product: Query & Analysis -- Error 1720.There is a problem with this Windows Installer package. A script required for this install to complete could not be run. Contact your support personnel or package vendor. Custom action BackupSettingsFile script error -2146828287, Microsoft VBScript runtime error: Unknown runtime error Line 91, Column 3,
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 39 35 44 34 31 35 35 {95D4155
0008: 36 2d 42 30 31 45 2d 34 6-B01E-4
0010: 31 42 34 2d 38 39 44 41 1B4-89DA
0018: 2d 41 41 45 45 34 39 31 -AAEE491
0020: 33 39 33 35 33 7d 39353}
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1004
Date: 5/04/2011
Time: 10:39:15 AM
User: WS-BPCT01\Administrator
Computer: WS-BPCT01
Description:
Detection of product '{95D41556-B01E-41B4-89DA-AAEE49139353}', feature 'ThirdParty', component '{EB43DD72-D405-4707-AA75-5358D4726408}' failed. The resource 'C:\WINDOWS\system32\XceedZip.dll' does not exist.
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1001
Date: 5/04/2011
Time: 10:39:15 AM
User: WS-BPCT01\Administrator
Computer: WS-BPCT01
Description:
Detection of product '{95D41556-B01E-41B4-89DA-AAEE49139353}', feature 'ThirdParty' failed during request for component '{9AFC70A9-9FCB-40DF-B81F-F24E49E0275E}'
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
found one file is missing after looking at the event viewer.
ASKER